php pdo sql return if rows exist

Question

In PHP PDO trying to use SELECT COUNT(*) SQL to see if primary key exists (so then can update rather than insert),

When I call the function sqlCall; fetchColumn() returns 0 or 1 depending on if it exists or not, however when it is returned it always returns false?

How do I get it to return if row exists or not?

Thanks for help!!

 function sqlCall($primary) {

            $sql = $handler->prepare("SELECT COUNT(*) FROM  WHERE ". strtolower($primary)."=:".$primary);

            $sSqlParams = array(':'.$primary => $primary);

            $sql->execute($sSqlParams);


            if($sql->fetchColumn()==1){
                return 1;

            } else {
                return 0;
            }
            break;
}




try {
                $rows = sqlCall($primary);

                if($rows=True){
                    //UPDATE SQL
                } else {
                    //INSERT SQL
                }
}
catch(PDOException $er) {

                    die();
}

what are you trying to do here? WHERE ". strtolower($primary)."=:".$primary is your $primary the same as your column name? — j.Doe
– j.Doe, Commented Jul 19, 2016 at 0:19

Perfect Square · Accepted Answer · 2016-07-19 00:44:44Z

1

You are going about this wrong way - there is MySQL construct which allows you to do this without any need for workarounds. If you would like to update record if exists and if not insert it than use: INSERT ... ON DUPLICATE KEY UPDATE

It goes like this:

INSERT INTO table (primary_key, field_to_update) VALUES(primary_key_value, value_to_update) ON DUPLICATE KEY UPDATE field_to_update = value_to_update

Whenever your primar_key will be already in database the record will be updated and if primary_key does not exists than new record will be created.

answered Jul 19, 2016 at 0:44

Perfect Square

1,43817 silver badges28 bronze badges

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

1 Comment

Jonny B'Good Over a year ago

Thank you! I will try this later on :)

Collectives™ on Stack Overflow

php pdo sql return if rows exist

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related