// DEMO mysqli连接方式参考$db = new mysqli("localhost:3306", "root", "", "dab"); // 简单查询//$result = $db -> query("select * from DAB_NTOS_ADMIN");//while($row = $result -> fetch_row()) {//    echo var_dump($row);//}$start = 0;$limit = 1;// 防sql注入$stmt = $db -> prepare("select * from DAB_NTOS_ADMIN limit ?,?");$stmt -> bind_param("ii", $start, $limit);$stmt -> execute(); $admin = new DAB_NTOS_ADMIN();$stmt -> bind_result($admin -> id,$admin -> name,$admin -> pwd,$admin -> telephone,$admin -> email,$admin -> autor_date,$admin -> descr,$admin -> realName);while ($stmt->fetch()) { echo var_dump($admin);} $db -> close();

$db = new mysqli("localhost:3306", "root", "", "dab"); // 防sql注入$stmt = $db -> prepare("update DAB_NTOS_ADMIN set name = ? where id = ?");$id = 1;$name = ‘dab‘;$stmt -> bind_param("si", $name, $id);$result = $stmt -> execute();echo $result; $db -> close();

$db = new mysqli("localhost:3306", "root", "", "dab"); // 防sql注入$stmt = $db -> prepare("insert into DAB_NTOS_ADMIN (name) values (?)");$name = ‘dab‘;$stmt -> bind_param("s", $name);$result = $stmt -> execute();echo $result; $db -> close();

// DEMO mysqli连接方式参考$db = new mysqli("localhost:3306", "root", "", "dab"); // 防sql注入$stmt = $db -> prepare("delete from DAB_NTOS_ADMIN where id = ?");$id = 2;$stmt -> bind_param("i", $id);$result = $stmt -> execute();echo $result; $db -> close();

try {    $db = new mysqli("localhost:3306", "root", "", "dab");     $db -> autocommit(0);    // 防sql注入    $stmt = $db -> prepare("insert into DAB_NTOS_ADMIN (name) values (?)");    $name = ‘dab‘;    $stmt -> bind_param("s", $name);    $result = $stmt -> execute();    $db -> commit();    echo $result; } catch (Exception $e) {    $db -> rollback();} finally  { // finally可能会报编译时错误,目前好像支持php5.5，而淡蓝的ide环境用的是5.3，服务器上的是5.5，所以编码的时候不行，发布之后就可以用了    $db -> close();}