i've encountered problem while using mysqli , can't figure out why happening.
on mariadb 5.5.41 server have table tbl1
a | b --+-- 1 | 1 i've created following php script:
<?php $db_host="localhost"; $db_user="user"; $db_pass="pass"; $db_db="db_test"; // mysqli test $db_link = @new mysqli($db_host,$db_user,$db_pass,$db_db); if($db_link->connect_error) die("mysqli connect error"); $result = $db_link->query("select tbl1 b='1'"); if(!$result) { die("mysqli query error"); } else { die("row count:".$result->num_rows); } ?> and result is:
row count:0 but if use following code:
<?php $db_host="localhost"; $db_user="user"; $db_pass="pass"; $db_db="db_test"; //mysql $db_link = @mysql_connect($db_host,$db_user,$db_pass); if(!$db_link) die("mysql connect error"); mysql_select_db($db_db,$db_link); $result = mysql_query("select tbl1 b='1'"); if(!$result) { die("mysql query error"); } else { die("row count:".mysql_num_rows($result)); } ?> and result is:
row count:1 any ideas why happens ?
mysqli_fetch_row in php manual mysqli_fetch_row
Comments
Post a Comment