retrieve lat inserted id

cs69165

how do i retrieve the last inserted id using mysql_insert_id()? im using this code but it doesnt seem to be working.it returns 0 and error:Cannot add header information - headers already sent.should i use sessions instead?i would like to display the id on another page after the submit form button.

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO customer (name, birthdate, email) VALUES (%s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['name'], "text"),
GetSQLValueString($HTTP_POST_VARS['birthdate'], "text"),
GetSQLValueString($HTTP_POST_VARS['email'], "text"),

printf("Your ID is %d\n", mysql_insert_id());

Mordecai

I don't see why that doesn't work without more of the code, but here are some pointers. Use $POST, it's the newer version of $HTTP_POST_VARS. If $POST['MM_INSERT'] is equal to 'form1', it clearly is set, so there's no need to check twice.

Also, be sure to post the functions you're using, since they're not standard.

Shrike

I seem to recall a version of PHP4 barfing if you tested an unset variable. Doesn't seem to happen in PHP5 and I don't have 4 here to test.

cs69165

i changed $HTTP_POST_VARS to $_POST but stil it doesnt work,i get the same error.

// build the form action
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'] . (isset($HTTP_SERVER_VARS['QUERY_STRING']) ? "?" . $HTTP_SERVER_VARS['QUERY_STRING'] : "");

if ((isset($POST["MM_insert"])) && ($POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO customer (name, birthdate, email) VALUES (%s, %s, %s)",
GetSQLValueString($POST['name'], "text"),
GetSQLValueString($POST['birthdate'], "text"),
GetSQLValueString($_POST['email'], "text"));

printf("Your ID is %d\n", mysql_insert_id());

$Result1 = $connICT->Execute($insertSQL) or die($connICT->ErrorMsg());

$insertGoTo = "confirmation.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
KT_redir($insertGoTo);
}

what about sessions?ideas,anyone?

Mordecai

$HTTP_SERVER_VARS should become $_SERVER, as well.

Here's the reason I asked that you paste the functions, too: does GetSQLValueString() run the query and get the result? If yes, you're running the query a few times, which isn't very efficient. If no, you haven't run the query.

Then there's this line:
$Result1 = $connICT->Execute($insertSQL) or die($connICT->ErrorMsg());

I'm assuming this runs the query. But this line is after this line:
printf("Your ID is %d\n", mysql_insert_id());

You must run the query before you can do anything with it.

If any of my assumptions on the functions are wrong, please paste them next time.

tommynanda

Is there an AUTO INCREMENT column in your table? this function only works if you have one...

TommYNandA

cs69165

yea,there is an autoincrement for the table,as the primary key.

ok,my script works now.juz for one tiny thing,error:cannot add header information,headers already sent by.what causes this?

tommynanda

error:cannot add header information,headers already sent by.what causes this?

if u are using set_cookie() or header() or session_start() function after generating any output. or even a blank space before "<?" generates that error

cs69165

can anyone pls check my coding?
i still get the same error🙁

<?php
//Connection statement
require_once('Connections/connICT.php');
//Aditional Functions
require_once('includes/functions.inc.php');
?>
<?php
// *** Restrict Access To Page: Grant or deny access to this page
$KT_authorizedUsers=" admin,pengguna,pegawai";
$KT_authFailedURL="aksespengguna.php";
$KT_grantAccess=0;
session_start();
if (isset($SESSION["KT_Username"])) {
if (false || !(isset($SESSION["KT_userAuth"])) || $SESSION["KT_userAuth"]=="" || strpos($KT_authorizedUsers, $SESSION["KT_userAuth"])) {
$KT_grantAccess = 1;
}
}
if (!$KT_grantAccess) {
$KT_qsChar = "?";
if (strpos($KT_authFailedURL, "?")) $KT_qsChar = "&";
$KT_referrer = $_SERVER["REQUEST_URI"];
$KT_authFailedURL = $KT_authFailedURL . $KT_qsChar . "accessdenied=" . urlencode($KT_referrer);
KT_redir($KT_authFailedURL);
}

// *** Logout the current user. false
$KT_Logout = $SERVER["PHP_SELF"] . "?KT_Logoutnow=1";
if ((isset($GET['KT_Logoutnow']) ? $GET['KT_Logoutnow'] : null)=="1") {
@session_start();
KT_session_unregister("KT_Username");
KT_session_unregister("KT_UserAuthorization");
$KT_logoutRedirectPage = "login.php";
// redirect with URL parameters (remove the "KT_Logoutnow" query param).
if ($KT_logoutRedirectPage == "") $KT_logoutRedirectPage = $SERVER["PHP_SELF"];
if (!strpos($KT_logoutRedirectPage, "?") && $SERVER['QUERY_STRING'] != "") {
$KT_newQS = "?";
reset ($GET);
while (list ($key, $val) = each ($GET)) {
if($key != "KT_Logoutnow"){
if (strlen($KT_newQS) > 1) $KT_newQS .= "&";
$KT_newQS .= $key . "=" . urlencode($val);
}
}
if (strlen($KT_newQS) > 1) $KT_logoutRedirectPage .= $KT_newQS;
}
KT_redir($KT_logoutRedirectPage);
}

// build the form action
$editFormAction = $SERVER['PHP_SELF'] . (isset($SERVER['QUERY_STRING']) ? "?" . $_SERVER['QUERY_STRING'] : "");

$Result1 = $connICT->Execute($insertSQL) or die($connICT->ErrorMsg());

printf("Your ID is: %d\n", mysql_insert_id());

$insertGoTo = "confirmation.php";
if (isset($SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $SERVER['QUERY_STRING'];
}
KT_redir($insertGoTo);
} ?>

tommynanda

the file u requested 'Connections/connICT.php' might generate some output so use session_start(); at beginning of the code
<?php
session_start();
//Connection statement
require_once('Connections/connICT.php');
//Aditional Functions
require_once('includes/functions.inc.php');
?>

or you can use functions like ob_start();

Hope this helps

cs69165

hmm,no change there:/

cs69165

what else can i do?

cs69165

yess!I GOT THE CODE RUNNING!
i use sessions so that the id is displayed on another page.

//form.php

$_SESSION['formid']=mysql_insert_id();

//to display on another page,say confirmation.php

echo "<p>Ur ID is:".$_SESSION["formid"];

thank u everyone!=)