1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| $sqltool=new SqlTool("localhost","root","mysql","test");
$sql="select * from user"; $res=$sqltool->execute_dql($sql);
foreach ($res as $key => $value) { echo "<br>--".$value->name; }
$sqls="select * from user where age>23;"; $sqls.="select * from user where age<=23;"; $res=$sqltool->execute_dqls($sqls);
foreach ($res as $key => $value) { echo "<br>new result"; foreach ($value as $key1 => $value1) { echo "<br>--".$value1->id.$value1->name; } }
$sql="insert into user(name,age,password) values('a',25,md5('xyj'))";
$sql="delete from user1 where id=4"; $res=$sqltool->execute_dml($sql);
$sqls="insert into user(name,age,password) values('b',23,md5('zxq'));"; $sqls.="insert into user(name,age,password) values('c',23,md5('xam'));"; $sqls.="insert into user(name,age,password) values('d',24,md5('mt'));"; $sqls.="update user set age=20 where id=1;"; $sqls.="delete from user where id=5;"; $sqls.="delete from user where id=6;"; $sqls.="delete from user where id=7;"; $res=$sqltool->execute_dml($sqls,true);
switch ($res) { case 0: echo "no effects"; break; case -1: echo "failed"; break; default: echo "success"; break; }
|