1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

need help ins php sql data doesnt inserted into the db

Discussion in 'PHP' started by Shizzle, Jan 21, 2012.

  1. #1
    can someone point me out whats wrong with my codes? im having trouble finding out whats the problem with my code because it doesnt display error
    and i cannot see the result in the data

    
    
    include "/class/include.php";
    
    
    
    $tempID =  mysql_real_escape_string ($_POST['p_id']);
    $tempQTY = mysql_real_escape_string ($_POST['p_qty']);
    $tempPRICE =mysql_real_escape_string ($_POST['p_price']);
    $tempTOTAL = mysql_real_escape_string ($_POST['p_total']);
    $tempPAID = mysql_real_escape_string ($_POST['amount_paid']);
    
    
    //insert in yo p sales
    $query = "INSERT INTO p_sales (sales_id, product_id, amount_paid, sales_date, sales_qty, price, total_price) VALUES 
    			('', '$tempID', '$tempPAID', now(), '$tempQTY','$tempPRICE', '$tempTOTAL')";
    mysql_query($query);
    
    
    // transaction id
    $id_gen=mysql_insert_id();
    
    //balance
    $sql=mysql_fetch_row(mysql_query("SELECT product_qty FROM productinfo WHERE product_id = '$tempID'"));
    
    //ledger insertion
    $sql2 = "INSERT INTO p_ledger (product_id, trans_type, trans_id, invent_dec, balance_qty) VALUES ('$tempID', 'SALE', '$id_gen','$tempQTY', '".$sql[0]."')";
    mysql_query($sql2);
    
    
    //balance update		
    $update="UPDATE productinfo SET balance_qty =(balance_qty - '$tempQTY') WHERE product_id = '$tempID'";
    mysql_query($update);
    
    mysql_close();
    
    
    Code (markup):
     
    Shizzle, Jan 21, 2012 IP
  2. Shimurai

    Shimurai Well-Known Member

    Messages:
    186
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    110
    #2
    try this code

    
    <?php
    include '/class/include.php';
    
    // insert in yo p sales
    $query1 = mysql_query("INSERT INTO p_sales (sales_id, product_id, amount_paid, sales_date, sales_qty, price, total_price) VALUES ('', '".mysql_real_escape_string($_POST['p_id'])."', '".mysql_real_escape_string($_POST['amount_paid'])."', '".now()."', '".mysql_real_escape_string($_POST['p_qty'])."', '".mysql_real_escape_string($_POST['p_price'])."', '".mysql_real_escape_string($_POST['p_total'])."')");
    
    // transaction id
    $id_gen = mysql_insert_id();
    
    // balance
    $query2 = mysql_fetch_row(mysql_query("SELECT product_qty FROM productinfo WHERE product_id = '".mysql_real_escape_string($_POST['p_id'])."'"));
    
    // ledger insertion
    $query3 = mysql_query("INSERT INTO p_ledger (product_id, trans_type, trans_id, invent_dec, balance_qty) VALUES ('".mysql_real_escape_string($_POST['p_id'])."', 'SALE', '$id_gen','".mysql_real_escape_string($_POST['p_qty'])."', '".$query2[0]."')");
    
    // balance update		
    $query4 = mysql_query("UPDATE productinfo SET balance_qty = balance_qty - '".mysql_real_escape_string($_POST['p_qty'])."' WHERE product_id = '".mysql_real_escape_string($_POST['p_id'])."'");
    
    mysql_close();
    ?>
    
    PHP:
    if it doesn't work maybe it's your database structure what's wrong ? so it's probably not adding the data..
     
    Shimurai, Jan 21, 2012 IP
  3. trtrtrtr

    trtrtrtr Greenhorn

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    for each variable add single qoutes like this :
    
    $tempPAID = "'" . mysql_real_escape_string ($_POST['amount_paid'])  . "'";
    Code (markup):
    And in the query remove the single quotes around the variable :
    
    '$tempPAID' ===>  $tempPAID
    Code (markup):
     
    trtrtrtr, Jan 21, 2012 IP
  4. Haxalot

    Haxalot Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #4
    If sales_id is set to auto increment in your database, then you will not be able to insert a NULL value (as you have done so in your query).

    And if that does not work, put "or die(mysql_error());" (w/o quotes) after each query you execute to find out if they are returning with errors.
     
    Haxalot, Jan 22, 2012 IP
  5. jarred123jarred

    jarred123jarred Greenhorn

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #5
    delete your table than re create it.
    Remember that the $query and other variables are strings, where you have put now() should not work that's incorrect syntax, try $now = now();.
    Also when adding the variables to the query strings, use the " . " method because it is the right syntax, stick to correct syntax and your code will run faster and better than if you don't.
     
    jarred123jarred, Jan 22, 2012 IP