PDO statement error php mysql

Question

i am trying to fetch product list from mysql table. I am trying the following code but it is not working. Any suggestions please.

Fatal error: Call to undefined method mysqli_stmt::rowCount()

Code

$query = "SELECT id, name, price FROM female_products ORDER BY name";
$stmt = $con->prepare( $query );
$stmt->execute();
$num = $stmt->rowCount();
if($num>0)
{
//my work here
}

Config.php

 $db_username = 'root';
$db_password = '';
$db_name = 'ecommerce';
$db_host = 'localhost';

try {
$con  = new mysqli($db_host, $db_username, $db_password,$db_name);

 }catch(PDOException $exception){
echo "Connection error: " . $exception->getMessage();
 }

how do we reconcile PDO in title with mysqli error message ? Choose one interface, not both — Drew, Oct 18 '15 at 17:10
Show more code, because it is unclear how you try to accomplish your task. How did you start db connection $con?? — Terradon, Oct 18 '15 at 17:13
cool thing is that you are just starting out. imo stick with PDO — Drew, Oct 18 '15 at 17:19
If you want to use PDO functions, you have to use a PDO connection: http://php.net/manual/en/pdo.connections.php — maček, Oct 18 '15 at 17:22

score 1 · Accepted Answer · answered Oct 18 '15 at 17:46

Assuming you want a real PDO solution, rather then a mysqli one:

    try {
    $aOptions = array(  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC);
    // play around with options

    $dbh = new PDO('mysql:host='.DBHOST.';dbname='.DBNAME.';charset=utf8', ''.DBUSER.'', ''.DBPWD.'',$aOptions); 
}
catch(PDOException $e) {
    echo $e->getMessage(); 
    // do something smarter then just echo error!
}


$sql = "SELECT id, name, price FROM female_products ORDER BY name";
$stmt = $dbh->query($sql);
$aArray = $stmt->fetchAll();

if(count($aArray) > 0){
    // do something
}
else{
   // empty result 
}

I personally think PDO is a much easier style then mysqli. Options: you certainly gonna play with it soon, so it is handy to use an array for it. You have used prepare,but yo do not make use of a prepared statement yet?? If this code works, try to find out hoe prepared statements work: one of the best defenses against SQL attacks!!

For configuration i used constants, so you need to define theme in your config. Constants, because they will never change during execution of your script!

ok, now forget mysqli and stick to PDO and your life will become much easier. Just read more about PDO especially the prepared statements — Terradon, Oct 18 '15 at 22:30

PDO statement error php mysql

1 Answers1