Last_insert_id()

[sneha24]

this is a part of my code where m trying to retrieve the last autoincremented id

if(!isset($_COOKIE['bill_no']) || $_COOKIE['bill_no']==0 ){
$sql=mysql_query("insert into bill_id values('null')");
$sql1=mysql_query("select @last := Last_insert_id()");
$row=mysql_fetch_array($sql1);
setcookie("bill_no",$row[0],3600);} 

but it is not returning the correct value

[kuldeepkaundal]

you can try mysql_insert_id();

like:

$lastid=mysql_insert_id(); after your insert query.

[sneha24]

its not working

[Raju Gautam]

its not working

What do you mean 'it is not working'? If rest of the conditions are fine and also if the row is inserted into the table then mysql_insert_id() must return the last inserted id as shown above.

Edit:

if(!isset($_COOKIE['bill_no']) || $_COOKIE['bill_no']==0 ){
    $sql = mysql_query("insert into bill_id values('null')") or die(mysql_error());
    echo mysql_insert_id();
} 

[AnthonySterling]

<?php
if(!isset($_COOKIE['bill_no']) || $_COOKIE['bill_no']==0 )
{
    $sql = mysql_query("INSERT INTO bill_id VALUES('null')");
    setcookie('bill_no', mysql_insert_id(), 3600);
}
?>

[sneha24]

thanks tat worked
new problem is tat the cookie is not being set

if(!isset($_COOKIE['bill_no'])){
$sql=mysql_query("insert into bill_id values('null')");
$lastid=mysql_insert_id();
setcookie("bill_no",$lastid,3600);
$i=0;
foreach($_REQUEST['check'] as $id){
$selected =$_REQUEST["qty"];
$sql=mysql_query("insert into bill(`id`,`bill_id`,`qty`) values($id,$lastid,$selected[$i])");
$i++;
    }
}
//if cookie is set
else{
$i=0;
$selected =$_REQUEST["qty"];
foreach($_REQUEST['check'] as $id){
$sql=mysql_query("insert into bill(`id`,`bill_id`,`qty`) values($id,$_COOKIE[bill_no],$selected[$i])");
$i++;
      }
}
header("Location: list.php"); 

each time a new id is inserted

[kuldeepkaundal]

Ah, that's grrt that it worked.

[Raju Gautam]

Are you sure that you do not have any output before the function setcookie() to the browser? Otherwise it should work at least for an hour.

Try print_r($_COOKIE) at the top and see if you see the bill_no is set there.

[sneha24]

it displayed
Array ( [SMFCookie956] => a:4:{i:0;s:1:"1";i:1;s:40:"cd3761c049b2792c847b1215ada1631e8b4a2251";i:2;i:1426696719;i:3;i:2;} [PHPSESSID] => 826a2ihd2s9898ltiej190nss3 )
for
print_r($_COOKIE);
the whole code is

<?php require_once("../shared/common.php");
      session_cache_limiter(null);
      $tab = "profile";
       $nav = "profile";
      require_once("../classes/Localize.php");
if(!isset($_COOKIE['bill_no'])){
$sql=mysql_query("insert into bill_id values('null')");
$lastid=mysql_insert_id();
setcookie("bill_no",$lastid,3600);
$i=0;
foreach($_REQUEST['check'] as $id){
$selected =$_REQUEST["qty"];
$sql=mysql_query("insert into bill(`id`,`bill_id`,`qty`) values($id,$lastid,$selected[$i])");
$i++;
    }
}
//if cookie is set
else{
$i=0;
$selected =$_REQUEST["qty"];
foreach($_REQUEST['check'] as $id){
$sql=mysql_query("insert into bill(`id`,`bill_id`,`qty`) values($id,$_COOKIE[bill_no],$selected[$i])");
$i++;
      }
}
 header("Location: list.php");?>

[sneha24]

plz help
i seriously don understand what is wrong?

[fristi]

plz help
i seriously don understand what is wrong?

try this:

setcookie("bill_no", $lastid, time() + 3600); 

you just used the number 3600. This is a time way in the past. So the coockie never gets sets. You need to give the current time + the time to live.

Manual:
http://php.net/manual/en/function.setcookie.php

[sneha24]

do i need to send it as parameter to all pages?

[fristi]

do i need to send it as parameter to all pages?

Once the coockie is set, it is accessible on all pages of the same domain.
So no parameter required to all pages...

[sneha24]

m using session for it now
the problem with session is how do i unset it?

[sneha24]

i guess this will work fine
unset($_SESSION['bill_no']);