Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mysql_insert_id() and php 2
- Thread starter JJJ777
- Start date
-
1
- #2
gerrygerry
Technical User
here's a quote from that explains it all:
Another problem you may run into when changing your code is the absence of a Postgres equivalent of MySQL's mysql_insert_id(), which returns the index value of the last INSERT query. The PHP documentation's language may mislead one to think that pg_getlastoid() does the job, but that is not the case. The lack of such a function is actually not a downside, for it is a result of Postgres's power in allowing multiple auto-incrementing fields through the SEQUENCE system.
Fortunately, getting the last ID is easy. Sequence information can be accessed through SQL, so the following replacement for mysql_insert_id() is possible:
-gerrygerry
Standard response to one of my posts:
"No where in your entire rantings did you come anywhere close to what can be considered a rational answer. We are all now dumber from having heard that. I award you no points and may God have mercy on your soul."
Another problem you may run into when changing your code is the absence of a Postgres equivalent of MySQL's mysql_insert_id(), which returns the index value of the last INSERT query. The PHP documentation's language may mislead one to think that pg_getlastoid() does the job, but that is not the case. The lack of such a function is actually not a downside, for it is a result of Postgres's power in allowing multiple auto-incrementing fields through the SEQUENCE system.
Fortunately, getting the last ID is easy. Sequence information can be accessed through SQL, so the following replacement for mysql_insert_id() is possible:
Code:
function postg_insert_id($tablename, $fieldname)
{
global connection_id;
$result=pg_exec($connection_id, "SELECT last_value FROM ${tablename}_${fieldname}_seq");
$seq_array=pg_fetch_row($result, 0);
return $seq_array[0];
}Standard response to one of my posts:
"No where in your entire rantings did you come anywhere close to what can be considered a rational answer. We are all now dumber from having heard that. I award you no points and may God have mercy on your soul."
-
1
- #3
sleipnir214
Programmer
I haven't used PostgreSQL much, but I would imagine that there's a gotcha in that advice: if you don't perform the insert and the return of the sequence id within a single transaction, you're not guaranteed to get the id of the record your process inserted.
______________________________________________________________________
TANSTAAFL!
______________________________________________________________________
TANSTAAFL!
gerrygerry
Technical User
Well... i've never used postgresql at all... lol... I just pulled that off a quick search! it just sounded educated... -gerrygerry
Standard response to one of my posts:
"No where in your entire rantings did you come anywhere close to what can be considered a rational answer. We are all now dumber from having heard that. I award you no points and may God have mercy on your soul."
Standard response to one of my posts:
"No where in your entire rantings did you come anywhere close to what can be considered a rational answer. We are all now dumber from having heard that. I award you no points and may God have mercy on your soul."
- Thread starter
- #5
hi guys...
it seems doesn cari the id that autocreated bye prevoius insert ..therefore here i post the code for firs page which is page1.php. so my point is just to find the similar fuction as mysql_insert_id in postgresql..
*in page2.php i will put hidden field for the profileid..tq.
<?php
$dbconn = mysql_connect("localhost", "root", "" or die ("Could not connect to database"
mysql_select_db("jjj" or die ("could not open database"
if($Submit=="Submit"{
$query=mysql_query("insert into table1 (nama,ic) values ('$nama','$ic')" or die ("could not select"
//here is what i stuck in postgressql..
$profileid=mysql_insert_id();
header("Location: profileid=$profileid"
exit;
}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="<?php echo $PHP_SELF; ?>">
<p>nama :
<input type="text" name="nama">
</p>
<p>ic :
<input type="text" name="ic">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
mysql_close($dbconn) or die ("could not close database"
?>
it seems doesn cari the id that autocreated bye prevoius insert ..therefore here i post the code for firs page which is page1.php. so my point is just to find the similar fuction as mysql_insert_id in postgresql..
*in page2.php i will put hidden field for the profileid..tq.
<?php
$dbconn = mysql_connect("localhost", "root", ""
or die ("Could not connect to database"mysql_select_db("jjj"
or die ("could not open database"if($Submit=="Submit"
{$query=mysql_query("insert into table1 (nama,ic) values ('$nama','$ic')"
or die ("could not select"//here is what i stuck in postgressql..
$profileid=mysql_insert_id();
header("Location: profileid=$profileid"
;exit;
}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="<?php echo $PHP_SELF; ?>">
<p>nama :
<input type="text" name="nama">
</p>
<p>ic :
<input type="text" name="ic">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>
<?php
mysql_close($dbconn) or die ("could not close database"
;?>
- Status