How to get number of rows inserted in mysql?

View Discussion

Improve Article

Save Article

View Discussion

Improve Article

Save Article

PHP stands for hypertext preprocessor. MySQL is a database query language used to manage databases.

In this article, we are going to discuss how to get the count of rows in a particular table present in the database using PHP and MySQL.

Requirements:

• XAMPP

Approach: By using PHP and MySQL, one can perform database operations. We can get the total number of rows in a table by using the MySQL mysqli_num_rows()function.

Syntax:

mysqli_num_rows( result );

The result is to specify the result set identifier returned by mysqli_query() function.

Example: The following table has 5 rows.

To count the number of rows in the building table, the following code snippet is used.

$sql = "SELECT * from building";

if ($result = mysqli_query($con, $sql)) {

    // Return the number of rows in result set
    $rowcount = mysqli_num_rows( $result );
    
    // Display result
    printf("Total rows in this table :  %d\n", $rowcount);
 }

Output: The expected result is as follows.

Total rows in this table : 5

Steps for the approach:

• Create a database named database.
• Create a table named building inside the database.
• Insert records into it.
• Write PHP code to count rows.

Steps:

• Start XAMPP server.

XAMPP server

• Create a database named database and create a table named building inside the database.
• Insert records into it

building table

• Write PHP code to count rows.

PHP code:

PHP

<?php

$con = mysqli_connect("localhost","root","","database");

    $sql = "SELECT * from building";

    if ($result = mysqli_query($con, $sql)) {

    $rowcount = mysqli_num_rows( $result );

    printf("Total rows in this table : %d\n", $rowcount);

}

mysqli_close($con);

?>

Output: After running the above PHP file in localhost, the following result is achieved.

Total rows in this table : 5

Example 2: In the following example, we count the table rows using MySQL count() function. It’s an aggregate function used to count rows.

Syntax:

select count(*) from table;

Consider the table.

PHP code:

PHP

<?php

$servername = "localhost";

$username = "root";

$password = "";

 $dbname = "database";

$conn = new mysqli($servername, 

    $username, $password, $dbname);

$sql = "SELECT count(*) FROM college_data ";

$result = $conn->query($sql);

while($row = mysqli_fetch_array($result)) {

    echo "Total Rows is ". $row['count(*)'];

    echo "<br />";

}

$conn->close();

?>

Output:

Total Rows is 8