note 103378 deleted from mysqli.prepare by danbrown
| From: | danbrown@php.net | Date: | Mon, 11 Apr 2011 15:13:52 +0000 |
| Subject: | note 103378 deleted from mysqli.prepare by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-178691@lists.php.net to get a copy of this message | ||
Note Submitter: KrisCraig at php dot net
----
This example script shows how the class in my previous post can be put to use:
<?php
require( "your-mysql-connect-vars.php" );
define( "RETURN_NULL", 0 );
define( "RETURN_RESULTS", 1 ); // Default.
define( "RETURN_AFFECTEDROWS", 2 );
define( "RETURN_NUMROWS", 3 );
define( "RETURN_OBJECT", 4 );
$sql = new sql();
$db = $sql->init();
$res = $sql->query( $db, "create table temp ( tid int primary key auto_increment, tname
varchar(255), tage int, mistert varchar(255) )", array(), RETURN_NULL );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "insert into temp values ( NULL, 'Some guy named Ted',
36, 'Pity' )", array(), RETURN_NULL );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "update temp set mistert = ? where mistert = ?", array(
"Pity da", "Pity" ), RETURN_AFFECTEDROWS );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "insert into temp ( tname, tage, mistert ) values ( ?, ?, ?
)", array( "Your Mother", 16, "FOO!" ), RETURN_NULL );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "select tname, mistert from temp where tid = ? AND tname = ?",
array( "id" => 1, "name" => "Some guy named Ted" ) );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "select * from temp" );
var_dump( $res );
print "<br /><br />\r\n\r\n";
// The key is completely moot (so long as it's unique); in fact, you can omit it altogether.
--Kris
$res = $sql->query( $db, "select tid from temp where tid = ?", array( 1 ) );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "select * from temp where tname = ? AND mistert = ?", array(
"Your Mother", "FOO!" ) );
var_dump( $res );
print "<br /><br />\r\n\r\n";
$res = $sql->query( $db, "drop table temp", array(), RETURN_NULL );
var_dump( $res );
?>