PHP MySQLi Num Rows Tutorial 🎯

Welcome to our PHP MySQLi Num Rows tutorial! Today, we'll learn how to fetch the number of rows from a database using the MySQLi extension in PHP. This tutorial is designed for beginners and intermediates, so let's get started! 📝

What is MySQLi?

MySQLi (MySQL Improved) is an interface for connecting and interacting with MySQL databases in PHP. It provides improved performance, error reporting, and functionalities compared to the traditional MySQL extension.

Connecting to the Database 📝

Before we dive into fetching rows, let's quickly go over how to establish a connection to your MySQL database using MySQLi.

php

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

💡 Pro Tip: Always check your connection to ensure there are no issues.

Fetching Number of Rows 🎯

Now, let's learn how to fetch the number of rows from a database table. We'll use the mysqli_num_rows() function for this purpose.

php

// Query to select all rows from a table
$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

// Check if query was successful
if ($result) {
  // Get the number of rows
  $num_rows = $result->num_rows;

  // Display the number of rows
  echo "Number of rows: " . $num_rows;
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

💡 Pro Tip: Always check if the query was successful to handle any errors that might occur.

Real-world Example 📝

Let's use our previous example in a real-world scenario. Suppose we have a user registration form, and we want to check if the username already exists in the database before inserting a new user.

php

// Query to check if the username already exists
$sql = "SELECT * FROM users WHERE username = '".$_POST['username']."'";
$result = $conn->query($sql);

// Check if query was successful
if ($result) {
  $num_rows = $result->num_rows;

  if ($num_rows > 0) {
    echo "Username already exists!";
  } else {
    // Proceed with user registration
  }
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

Quiz 🎯

That's it for today! In the next lesson, we'll dive deeper into MySQLi and learn how to fetch actual data from our database. Keep practicing, and happy coding! 💡