MysqlndUhConnection::query

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::query — Performs a query on the database

说明

public bool MysqlndUhConnection::query ( mysqlnd_connection $connection , string $query )

Performs a query on the database (COM_QUERY).

参数

connection: Mysqlnd connection handle. Do not modify!
query: The query string.

返回值

Returns TRUE on success. Otherwise, returns FALSE

范例

Example #1 MysqlndUhConnection::query() example

  <?php
 class  proxy  extends  MysqlndUhConnection  {
 public function  query ( $res ,  $query ) {
   printf ( "%s(%s)\n" ,  __METHOD__ ,  var_export ( func_get_args (),  true ));
   $query  =  "SELECT 'How about query rewriting?'" ;
   $ret  =  parent :: query ( $res ,  $query );
   printf ( "%s returns %s\n" ,  __METHOD__ ,  var_export ( $ret ,  true ));
  return  $ret ;
 }
}
 mysqlnd_uh_set_connection_proxy (new  proxy ());

 $mysqli  = new  mysqli ( "localhost" ,  "root" ,  "" ,  "test" );
 $res  =  $mysqli -> query ( "SELECT 'Welcome mysqlnd_uh!' FROM DUAL" );
 var_dump ( $res -> fetch_assoc ());
 ?>

以上例程会输出：

proxy::query(array (
  0 => NULL,
  1 => 'SELECT \'Welcome mysqlnd_uh!\' FROM DUAL',
))
proxy::query returns true
array(1) {
  ["How about query rewriting?"]=>
  string(26) "How about query rewriting?"
}

参见

mysqlnd_uh_set_connection_proxy() - Installs a proxy for mysqlnd connections
mysqli_query() - 对数据库执行一次查询
mysql_query() - 发送一条 MySQL 查询