mysql_insert_id()

manna · February 11th, 2012, 09:06 AM

am using wrox php beginig 5.3 book dataobject and classes to genarate my site. i add new comment class structure like members in book. this comment class database table have auto increment id and comment columns. after insert data to mysql i want id using mysql_insert_id(). i tried several times but i cant identify parameter to above function. please help me to identify parameter.

UseLess · February 11th, 2012, 10:34 AM

Greetings,

You use the resource id returned by connecting to the db like so:

Code:

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
// select the db here
// then do your query here...
// then use the following to obtain the last id
$new_id = mysql_insert_id($link);

You would then need to test $new_id to see if it's false etc

manna · February 12th, 2012, 02:33 PM

useless thanks for your reply

config.php->
define( “DB_DSN”, “mysql:dbname=mydatabase” );
define( “DB_USERNAME”, “root” );
define( “DB_PASSWORD”, “mypass” );

dataobject.class.php->
protected function connect() {
try {
$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
$conn- > setAttribute( PDO::ATTR_PERSISTENT, true );
$conn- > setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
} catch ( PDOException $e ) {
die( “Connection failed: “ . $e- > getMessage() );
}
return $conn;
}

extend dataobj comment.class.php->
public function insert() {
$conn = parent::connect();
$sql = “INSERT INTO “ . TBL_COMMENTS . “ (
comment
) VALUES (
:comment
)”;
try {
$st = $conn- > prepare( $sql );
$st- > bindValue( “:comment”, $this- > data[“comment”], PDO::PARAM_STR );
$st- > execute();
parent::disconnect( $conn );
} catch ( PDOException $e ) {
parent::disconnect( $conn );
die( “Query failed: “ . $e- > getMessage() );
}
}

comment.php->
$comment = new comment( array(
“comment” = > isset( $_POST[“comment”] ) ? preg_replace
( “/[^ \-\_a-zA-Z0-9]/”, “”, $_POST[“comment”] ) : “”,) );

$comment- > insert();
$id = mysql_insert_id("please help me");
displayThanks();

UseLess · February 12th, 2012, 03:50 PM

Greetings,

As you're using a class you could add a var to the extend class:

Code:

var $last_id;

and then after the:

Code:

$st->execute();

add:

Code:

$this->last_id = mysql_insert_id($conn);

you need to add this here as the connection is destroyed so $conn will will no longer reference the correct resource id, which is why it's not working the way you are trying to do it.

you should then be able to get the id after the insert, like so;

Code:

$comment->insert();
$id = $comment->last_id;

manna · February 12th, 2012, 07:42 PM

after an add display some massage like dis
warning: mysql_insert_id() expects parameter 1 to be resource, object given in comment.class.php line 56

UseLess · February 13th, 2012, 06:30 AM

Greetings,

Then you'll have to use this:

Code:

SELECT LAST_INSERT_ID()

as a query to get the last id, as $conn is obviously the db object and not the resource link id.

manna · February 13th, 2012, 09:01 AM

i changed my mind ,becuz dis method so risky and not friendly. im using another simple tric like this. create column rand to generate random num. and catch comment through this random number. then clear rand num in clomn.
plz reply about this tric thank you again