php5.4以上 mysqli 实例操作mysql 增,删,改,查
1 <?php 2 //php5.4以上 mysqli 实例操作mysql 3 header("Content-type:text/html;charset=utf8"); 4 $conn = new mysqli('localhost', 'root', 'root'); 5 mysqli_select_db($conn, 'cc'); 6 $conn->query('set names utf8'); 7 $sql_search = "select * from bb where id=9"; 8 /*$sql_add = "insert into bb(name) values ('小明')"; 9 $sql_update = "update bb set name = '小h' where id=9"; 10 $sql_del = "delete from bb where id=9";*/ 11 $result = $conn->query($sql_search); 12 while ($row = $result->fetch_array()) { 13 echo $row['name'] . '<br/>'; 14 } 15 $conn->close();