1
I’m new to PDO (I was forced to choose between mysqli and Pdo after migrating php from version 5.2 to 7.0) and made a system where the user does the search:
$b2 = $_POST['b2'];
$busca = $PDO->query("SELECT * FROM noticias WHERE titulo LIKE '%$b2%' UNION SELECT * FROM noticias WHERE corpo LIKE '%$b2%'");
$total->columnCount();
OR
$total->rowCount();
At the end will be used to display the following information:
A busca retornou <?php echo $total ?> resultados;
1
It’s not a question of "which is best", it’s functions with different purposes.
According to PDO documentation:
columnCount - Returns the number of columns obtained in the query result
and
rowCount - Returns the number of rows affected by the SQL statement
Like fetchAll returns an array, you can simply use count to check the number of results
count($busca->fetchAll())
When I said "which is the best" I meant which is the most recommended/performatic/fast for this situation, but I will test with fetchAll too, thank you for the answer.
if you want to count the lines, columnCount is not an option, therefore, you have only rowCount or make a count in the result array.
Funny @juniorgarcia here both (columnCount, rowCount and Count($search->fetchAll()) returned the same result and worked, for now I’m choosing columnCount, I read in php.net documentation that fetchAll searches ALL line results, then I imagine to be the heaviest to pick up and show the pagination, correct me if I’m wrong...
fetchAll will return all lines that fall into your SELECT. Since you want paging, you can only use fetch and rotate within a loop to control it. So you don’t need to pick up all the lines. And columnCount is to count columns, not results. Remember this :)
0
rowCount() and columnCount() have purposes.
rowCount() returns the number of rows affected by an INSERT/UPDATE/DELETE which is the equivalent of mysqli_affected_rows().
As PDO supports multiple databases in some such as Mysql this method also returns the number of rows of a SELECT as well as mysqli_num_rows(). In other databases some settings are required.
columnCount() Returns a number of columns of a SELECT
Relating:
Browser other questions tagged php sql pdo
You are not signed in. Login or sign up in order to post.
columnCount() returns the number of columns, and rowCount() returns the number of records ( Lines ).
– NoobSaibot