我加上了 $myrow = mysql_fetch_row($res);这一句想获取一行数据 为什么获取不到一行 提示这个 ( ! ) Warning: mysql_fetch_row() expects parameter 1 to be resource, array given in D:\wamp\www\chaxun.php on line 7
<code><?php $pdo=new PDO("mysql:host=localhost;dbname=t1","root",""); $stmt=$pdo->prepare("select * from test"); $stmt->execute(); //$myrow = mysql_fetch_row($stmt->execute()); $res=$stmt->fetch(); $myrow = mysql_fetch_row($res); print_r($myrow); ?> </code>
我加上了 $myrow = mysql_fetch_row($res);这一句想获取一行数据 为什么获取不到一行 提示这个 ( ! ) Warning: mysql_fetch_row() expects parameter 1 to be resource, array given in D:\wamp\www\chaxun.php on line 7
<code><?php $pdo=new PDO("mysql:host=localhost;dbname=t1","root",""); $stmt=$pdo->prepare("select * from test"); $stmt->execute(); //$myrow = mysql_fetch_row($stmt->execute()); $res=$stmt->fetch(); $myrow = mysql_fetch_row($res); print_r($myrow); ?> </code>
PDOStatement::rowCount — 返回受上一个 SQL 语句影响的行数
PDOStatement::fetch — 从结果集中获取下一行
<code><?php $pdo = new PDO('mysql:host=127.0.0.1;dbname=test;charset=utf8', 'root', 'root'); $query = $pdo->query('SELECT * from users'); //获取一行 $result=$query->fetch(); print_r($result); $total = $pdo->query('SELECT * from test'); //统计条数 $count=$total->rowCount(); echo $count;</code>
要用while循环取吧