Jump to content

funbinod

Members
 View Profile  See their activity

  • Posts

    501

  • Joined

  • Last visited

 Content Type 

Posts posted by funbinod

    if 'submit' do something is not working

    in PHP

    Posted

    single = is also not working.

    if (!isset($_POST['sort'])) {$query = "SELECT * FROM tran WHERE ssn!=0 ORDER BY date";} else {$fdate = $_REQUEST['fdate'];$tdate = $_REQUEST['tdate'];$query = "SELECT * FROM tran WHERE ssn!=0 AND date BETWEEN '$fdate' AND '$tdate' ORDER BY date";}

    it returns the query on if statement. but even after selecting the date it is the query from if statement (or simply the if, else statement is not working)..

    failed to include referer page

    in PHP

    Posted · Edited by funbinod

    yes! it is redirecting. it is redirecting to the root of webpage.

     

    like: the $refer page is "http://localhost/ac/chapat/salesReport.php?" and it is redirecting to "http://localhost/ac/chapat"

     

    i just want to include the referer page....

    --------------------------

    EDIT:

    but this is working:

    die(header("location: $refer"));

    but i need some messege to display with the redirection to the referer page.

    like

    after redirection, at the top of the page it should echo

    "Record posted successfully"

     

    and then include the referer page....

     

    using die(header(..........)) doesn't display the messege but only the referer page......

    failed to include referer page

    in PHP

    Posted

    i tried to get back to referer page after editing records but it redirected to login page.

    // this is editprocess page...$refer = $_REQUEST['refer']; // this is stored on a hidden input field on edit.php, that is redirected from http://....../salesRecord.php?echo "<h3>Sales Record Successfully Updated</h3>";include($refer); //echo ing $refer here gives the desired referer page...

    after clicking 'edit' (submit button) it redirects to login.php page. even the login page should redirect to 'main.php' since it is logged in already (there is a code for it at the top of the page) ....

     

    any suggestion????

    if 'submit' do something is not working

    in PHP

    Posted

    i'm trying to get make query relating to the date selection. and if no date is selected, i want to make default query without date selection.

    for this i tried this ----

    // above this there is a form with two input fields for from date and to date selection with a submit buttom. action is $_SERVER['PHP_SELF']if (!isset($_POST['sort'])) {     // 'sort' is the submit button name$query = "SELECT * FROM tran WHERE ssn!=0 ORDER BY date";} else {	$fdate == $_POST['fdate']; // from date	$tdate == $_POST['tdate']; // to date$query = "SELECT * FROM tran WHERE ssn!=0 AND date BETWEEN '$fdate' AND '$tdate' ORDER BY date";}

    but this is not working...

     

    any suggestion!!!?????

    multiple select mysql

    in PHP

    Posted 

    SELECT * FROM tran WHERE NOT IN(SELECT aid FROM tran WHERE aid IN ('1','2') AND tr_type IN ('SALES','PURCHASE'))

     

    thanks. but its not still selecting aid 1 & 2....

    referer check not working

    in PHP

    Posted · Edited by funbinod

    i wonder for same. file name is perfect. no error.

     

    let me explain u the error that is happening...

     

    i added the above line to 'login.php'. after adding the lines, 'login.php' fails to load and gives the error msg. removing the lines, 'login.php' opens correctly. if it was only the case of wrong file name 'chkactivation.php', it should al least redirect to the file and not open. but its not redirecting to the <header("location: chkactivation.php")>.

    multiple select mysql

    in PHP

    Posted

    u r right but one---

    i want all columns for all 'aid's but for 'aid' 1 & 2 i don't want 'sales' & 'purchase'. and 'sales' & 'purchase' are not column name. they are row value for 'tr_type' column & this column has other values also - 'receipt', 'payment' etc....

     

    lets assume with this

    |---|------------|--------|---------||aid|    date    |  amt   | tr_type ||---|------------|--------|---------|| 1 | 2014-05-01 | 50000  |  SALES  || 2 | 2014-05-02 | 50000  |PURCHASE ||---|------------|--------|---------|| 1 | 2014-05-03 | 50000  | RECEIPT || 2 | 2014-05-04 | 50000  | PAYMENT || 3 | 2014-05-05 | 50000  |  SALES  || 3 | 2014-05-06 | 50000  |PURCHASE ||---|------------|--------|---------|

    in this table i dont want first 2 rows only.

    multiple select mysql

    in PHP

    Posted

    i'm trying to select columns with multiple conditions.

     

    i want to select all 'tr_type' for all 'aid's but not 'SALES' & 'PURCHASE' for aid in '1' & '2'.

     

    i tried ---

    SELECT * FROM tran WHERE aid NOT IN ('1','2') AND tr_type IN ('SALES','PURCHASE') ORDER BY date

    it didn't work. please suggest....

    referer check not working

    in PHP

    Posted

    i'm trying to check before going to login page it should be checked if it is activated or not. if someone tries to access 'login.php' directly, it should be forwarded to 'chkactivation.php'. for this i tried--

    // login.php$ref = $_SERVER['HTTP_REFERER'];if ($ref != 'http://localhost/ac/chapat/chkactivation.php') {	die(header("location: chkactivation.php"));}

    but it says "This page can't be displayed" as if it didn't find the page (login.php) in spite of redirecting to 'chkactivation,php'.

    where m i wrong? please guide.. or suggest some better idea...

    future date with relation to mysql date

    in PHP

    Posted

    i came to learn that future and past dates are calculated with the simple use of "strtotime()".

     

    but this is calculated in relating with current date. i want to know if a future date can be calculated in relation with database stored date?

     

    for example, if '2014-01-01' is stored in database, how can i get the date of 30 days(i.e.-2014-01-30) ahead from this date?

    loop a php function

    in PHP

    Posted

    this function is only for 'sid=1'. i mean for single 'sid'. and is working properly.

    but i asked for help to derive values for all 'sid's. i mean to ask u 'how to use this function more than once'.

    why dont i get any result form the database?

    in PHP

    Posted · Edited by funbinod

    @justsomeguy refers to

    $numrows = mysqli_fetch_array($query);

    if($numrows > 0)

     

    change this to

    $numrows = mysqli_num_rows($query);        if($numrows <= 0) //or use just '=' coz there couldn't be, perhaps, negative number of messege

    loop a php function

    in PHP

    Posted · Edited by funbinod

    how can i loop a result from a php function to loop through each 'id'?

     

    like for all 'sid's, i want to use following function to get data...

    /* above this i calculate value for each $cqty */$cqty = $oqty + $inqty - $outqty;$camt = "select date, pqty, prate, pamt from stock stjoin purchase p on st.sid = p.sid where st.sid = $sidunion allselect date, -sqty, srate, samt from stock stjoin sales s on st.sid = s.sid where st.sid = $sidunion allselect null, oqty, oprice, oamt from stock where sid = $sidorder by date asc";$dataSet = array();$camtresult = mysqli_query($connect, $camt);while ($row = mysqli_fetch_array($camtresult)){	$dataSet[] = $row;}function camt($dataSet, $cqty){    $totalPurchaseValue = 0;    $totalPurchaseQty = 0;    $done = false;    foreach($dataSet as $row)    {        // skip sales rows        if ($row['pqty'] < 0)        {            continue;        }        for ($i=0; $i<$row['pqty']; $i++ )        {            $totalPurchaseQty++;            $totalPurchaseValue += $row['prate'];            if ($totalPurchaseQty == $cqty)            {                return $totalPurchaseValue;            }        }    }    return $totalPurchaseValue;}// Determine the $countOfGoodsForSale$crate = camt($dataSet, $cqty) / $cqty;$camt = $cqty*$crate;

    i tried while loop but it said---

    Fatal error: Cannot redeclare camt() (previously declared in E:xampphtdocsacstock.php:73) in E:xampphtdocsacstock.php on line 73

    please guide through

    sum until sum equals n value

    in PHP

    Posted

    i am trying to command mysql to sum until it reaches certain value
    from my table 'purchase', for each 'sid' starting from the last row, i need sum of 'pqty' until the result equals a value from string (but to try i've given a certain value).
    let me define with the rows from my table---
    the rows for 'sid=1' from 'purchase' are like this---

     

    date pqty prate pamt

    2014/04/29 5 38000 190000
    2014/05/04 1 38000 38000
    2014/05/13 20 35000 700000
    2014/05/19 1 38000 38000

     

    from this row, starting from the last row i want to 'sum(pqty) until it reaches 19(for now). it is achieved from adding last 2 rows(for 19). and stop sum here and return valus or sum of 'pqty', 'prate' and 'pamt'. to achieve this i tried the following
            SELECT date, pqty, @total := @total + pqty AS total         FROM (purchase, (select @total :=0) t)         WHERE @total<19 AND sid = $sid ORDER BY date DESC
    but it's not working. please guide me through this. also suggest something else if this is not the good technique for my purpose.
    thankz in advance.....

    error on sql select limit

    in PHP

    Posted

    thanks for the reply. its ok for the spelling! but the problem is still the same. its not retrieving sum from last 3 rows. its summing from complete rows.... i wish to add qty from the declared LIMIT...

×
×
  • Create New...