/**
* Get the version of the database connector.
*
* @return string The database connector version.
*
* @since 1.0
*/
public function getVersion()
{
$this->connect();
return $this->connection->get_server_info();
}
/**
* Returns the server version string.
*
* @return string
*/
public function serverVersion()
{
return $this->conn->get_server_info();
}
<?php
$mysqli1 = new mysqli();
$mysqli1->connect('localhost', 'root', '123456');
$mysqli1->select_db("mysqlweb");
if (mysqli_connect_errno()) {
echo "error" . $mysqli->connect_error;
} else {
echo "no error";
}
$mysqli1->set_charset('utf8');
var_dump($mysqli1->server_info);
var_dump($mysqli1->client_info);
var_dump($mysqli1->server_version);
echo $mysqli1->get_server_info();
// $sql = 'create table test ( id tinyint auto_increment primary key);';
// var_dump($mysqli1->query($sql));
// $sql2 = "insert into orders( customerid,amount,date) values(5,215.12,'2016-04-02');";
// var_dump($mysqli1->query($sql2));
$sql3 = "update orders set date='2016-04-04' where orderid = 5;";
var_dump($mysqli1->query($sql3), 'sql3');
var_dump($mysqli1->affected_rows);
$sql4 = "delete from orders where orderid=6;";
var_dump($mysqli1->query($sql4), 'sql4');
var_dump($mysqli1->affected_rows);
$sql5 = "select * from orders";
$res = $mysqli1->query($sql5);
var_dump($res);
//返回的结果集中结果的条数
var_dump($res->num_rows);
$num_results = $res->num_rows;
