PHP访问Mysqli的实例

来源:互联网 发布:我的世界枪械手机版js 编辑:程序博客网 时间:2024/06/04 18:42
<?php$mysqli = new mysqli('localhost', 'root', '', 'world');if ($mysqli->connect_error) {    die('Connect Error (' . $mysqli->connect_errno . ') '            . $mysqli->connect_error);}echo 'Success... ' . $mysqli->host_info . "\n";$sql = "SELECT * from city WHERE ID = 1";if ($result = $mysqli->query($sql)) {    printf("Select returned %d rows.\n", $result->num_rows);    print_r($mysqli->stat());      $result->close();}$mysqli->close();?>

返回结果:

Success... localhost via TCP/IPSelect returned 1 rows.Uptime: 5555  Threads: 1  Questions: 27  Slow queries: 0  Opens: 40  Flush tables: 1  Open tables: 1  Queries per second avg: 0.004


原创粉丝点击