Breaking News: Grepper is joining You.com. Read the official announcement!

pdo get row count

Zaphiel answered on July 31, 2020 Popularity 9/10 Helpfulness 8/10

answer pdo get row count

related sql row count php pdo

pdo get row count

Comment

// query example
echo $db->query("SELECT * FROM users")->rowCount(); // Will return the total member number.

// prepare example
$query = $db->prepare("SELECT * FROM users WHERE user_username=? && user_password=?");
$query->execute(array($username, md5($password)));

echo $query->rowCount(); // Will return the number of columns affected.
						 // if($query->rowCount() > 0) means there is an user found with given username and password.

Popularity 9/10 Helpfulness 8/10 Language php

Source: Grepper

Tags: count get pdo php row

Link to this answer
Share Copy Link

Contributed on Sep 29 2022

Zaphiel

0 Answers Avg Quality 2/10

Closely Related Answers

sql row count php pdo

Comment

<?php
/* Delete all rows from the FRUIT table */
$del = $dbh->prepare('DELETE FROM fruit');
$del->execute();

/* Return number of rows that were deleted */
print("Return number of rows that were deleted:\n");
$count = $del->rowCount();
print("Deleted $count rows.\n");
?>

Popularity 10/10 Helpfulness 10/10 Language php

Source: www.php.net

Tags: count coun

Link to this answer
Share Copy Link

Contributed on Jul 31 2020

Tender Turkey

0 Answers Avg Quality 2/10

pdo get row count

Contents

More Related Answers

pdo get row count

Closely Related Answers

sql row count php pdo

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.