php trying to return the number of rows in a sql table

Question

Trying to return the total row count for a sql table. My code returns the number of rows that are added not the total number of rows in the table. Any suggestions?

PHP:

require(ROOT_PATH . "inc/database.php");
try {
    $query = $db->prepare("REPLACE INTO launch_email VALUES ('$email')");
    $query->execute();
    $count = $query->rowCount();
    echo $count;
} catch (Exception $e) {
    echo "Data could not be submitted to the database.";
exit;

I am using MAMP with PHP 5.2.17

Ryan Salmons
– Ryan Salmons

2014-04-14 04:22:25 +00:00
Commented Apr 14, 2014 at 4:22 — Ryan Salmons
– Ryan Salmons, Commented Apr 14, 2014 at 4:22

Bjoern · Accepted Answer · 2014-04-14 04:24:03Z

1

rowCount() ist not a direct method of the PDO class, it is a method from PDOStatement.

Syntax:

public int PDOStatement::rowCount ( void )

Example based on your approach:

try {
    $query = $db->prepare("REPLACE INTO launch_email VALUES ('$email')");
    $query->execute();
    $count = $query->rowCount();
} catch (Exception $e) {
    ...

answered Apr 14, 2014 at 4:24

Bjoern

16.3k4 gold badges47 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ryan Salmons Over a year ago

So your code works. However, its not what I was looking for exactly. I have edited my post to reflect the changes. But what I was intending to do was to return the total number of rows in the table, not just the number of rows that I changed. My PDO object that I create in my database.php file is $db. Would it be easier to do a sql count function instead?

Ryan Salmons Over a year ago

I now understand that I have been attempting my intended solution with the wrong method.

Bjoern Over a year ago

@RyanSalmons Exactly. If you want to determine that, you have to SELECT it after you have updated your records, for example with a COUNT in it. Your UPDATE/REPLACE-statements will only return you the affected rows. It might look like this: SELECT COUNT(*) FROM launch_email WHERE yourfield = "somevalue";

xdazz · Accepted Answer · 2014-04-14 04:25:42Z

0

PDO::exec returns the number of affected rows.

So you don't need to use rwoCount(), and note rowCount() is the method from PDOStatement.

require(ROOT_PATH . "inc/database.php");
try {
    $count = $db->exec("REPLACE INTO launch_email VALUES ('$email')");
} catch (Exception $e) {
    echo "Data could not be submitted to the database.";
    exit;
}

answered Apr 14, 2014 at 4:25

xdazz

161k38 gold badges255 silver badges278 bronze badges

Collectives™ on Stack Overflow

php trying to return the number of rows in a sql table

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related