<?php
include "mysql_class.php";
$db = new mysqlDatabase("localhost","root","","test");
$table = array("coba");
$fld = array("*");
if($db->dbSelect($table,$fld)){
echo $db->getNumRows();
while($data=$db->getRows()){
var_dump($data);
}
} else {
trigger_error($db->getErrorMessage(),E_USER_ERROR);
}
$dtInsert=array("user"=>"admin","pass"=>"123");
if($db->dbInsert("coba",$dtInsert)){
echo "Berhasil";
} else {
trigger_error($db->getErrorMessage(),E_USER_ERROR);
}
$dtUpdate = array("pass"=>"Administrator");
if($db->dbUpdate("coba",$dtUpdate,"user = 'admin'")){
echo "Berhasil";
} else {
trigger_error($db->getErrorMessage(),E_USER_ERROR);
}
if($db->dbDelete("coba","user='admin'")){
echo "Berhasil";
} else {
trigger_error($db->getErrorMessage(),E_USER_ERROR);
}
?>
|
Download
