phpでadodbを使う方法例（mysql）

phpでadodbを使う方法例（mysql）を紹介します。

include("adodb/adodb.inc.php");
$conn =NewADOConnection('mysql');
$conn->debug =true;
$conn->debug =false;
$conn->Connect("localhost", "root", "", "thedb");

//print_r($rs->GetRows());

//insert///////////////////////////////////////////
$sql = "SELECT * FROM user WHERE username=-1";
$rs = $conn->Execute($sql);
$record = array();
$record["username"] = "username1";
$record["onamae"] = "onamae1";

$insertSQL = $conn->getinsertsql($rs, $record);
//print "
";
//print $insertSQL;
$conn->Execute($insertSQL);

//update///////////////////////////////////////////
$sql = "SELECT * FROM user WHERE username='kubota'";
$rs = $conn->Execute($sql);

$record = array();
$record["onamae"] = "onamae2";
$updateSQL = $conn->GetUpdateSQL($rs, $record);
//print "
";
//print $updateSQL;
$conn->Execute($updateSQL);

//delete//////////////////////////////////////////
$conn->Execute("delete from user where username='kubota1'");

//select//////////////////////////////////////////
$rs = $conn->Execute("SELECT * FROM user");
while ($arr = $rs->fetchRow()) {
print_r($arr["username"]);
print "
";
print_r($arr);
print "
";
print "————————-";
print "
";
}
?>