Help with PHP - MYSQL

[Pebbbles]

PM ME

more info through pms?

 

[Pebbbles]

Hit me up in Discord.

here quick please
whats the php code to get number of rows of a table?

 

[Arrron]

Pebbbles

Depends on whether you're using MySQL or MySQLi (I suggest MySQLi). Here's options for both.

For MySQL:

<?php

    $query = mysql_query("SELECT * FROM table");
    $numberOfRows = mysql_num_rows($query);

    echo "The number of rows is: " . $numberOfRows;

?>

For MySQLi:

<?php

    $connection = mysqli_connect("localhost","username","password","db_name");

    $query = mysqli_query($connection, "SELECT * FROM table");
    $numberOfRows = mysqli_num_rows($query);

    echo "The number of rows is: " . $numberOfRows;

?>

 

[Jack]

Pebbbles

Depends on whether you're using MySQL or MySQLi (I suggest MySQLi). Here's options for both.

For MySQL:

<?php

    $query = mysql_query("SELECT * FROM table");
    $numberOfRows = mysql_num_rows($query);

    echo "The number of rows is: " . $numberOfRows;

?>

For MySQLi:

<?php

    $connection = mysqli_connect("localhost","username","password","db_name");

    $query = mysqli_query($connection, "SELECT * FROM table");
    $numberOfRows = mysqli_num_rows($query);

    echo "The number of rows is: " . $numberOfRows;

?>

The original MySQL API (mysql) was deprecated in PHP 5.5 and removed in PHP 7.0. Current stable PHP is 7.3.
So you will definitely need to use the improved MySQL API (mysqli).