PHP Application Development With ADODB (part 1) - Strange Relationships

(Page 8 of 10 )

In case you're performing an INSERT query on a table containing an auto-increment primary key, you can obtain the last auto-increment ID generated via ADODB's Insert_ID() method.

<?php
// uncomment this to see plaintext output in your browser
// header("Content-Type: text/plain");
// include the ADODB library
include("adodb.inc.php");
// create an object instance
// configure library for a MySQL connection
$db = NewADOConnection("mysql");
// open connection to database
$db->Connect("localhost", "john", "doe", "db278") or die("Unable to
connect!");
// execute query
$title = $db->qstr("It's Not Me, It's You!");
$author = $db->qstr("J. Luser");
$query = "INSERT INTO library (title, author) VALUES ($title, $author)";
$result = $db->Execute($query) or die("Error in query: $query. " .
$db->ErrorMsg());
// print auto-generated ID
if ($result)
{
echo "Last inserted ID is " . $db->Insert_ID();
}
// clean up
$db->Close();
?> 

Note also the qstr() method, which comes in handy when you need to escape special characters in your query string.

If you're executing a query that affects the table, either by adding, deleting or modifying rows, the Affected_Rows() method can come in handy to tell you the number of rows affected.

<?php
// uncomment this to see plaintext output in your browser
// header("Content-Type: text/plain");
// include the ADODB library
include("adodb.inc.php");
// create an object instance
// configure library for a MySQL connection
$db = NewADOConnection("mysql");
// open connection to database
$db->Connect("localhost", "john", "doe", "db278") or die("Unable to
connect!");
// execute query
$query = "DELETE FROM library WHERE author = 'J. Luser'"; $result =
$db->Execute($query) or die("Error in query: $query. " .
$db->ErrorMsg());
// return number of affected rows
if ($result)
{
echo $db->Affected_Rows() . " rows deleted";
}
// clean up
$db->Close();
?>

Next: Hitting The Limit >>
 

More PHP Articles
More By icarus, (c) Melonfire

Comments On: PHP Application Development With ADODB (part 1)

>>> Be the FIRST to comment on this article!