How to Use the WHERE Clause in PHP MySQL?

Dec 14, 2022 By Admin Category: PHP  

Hi Dev,

This tutorial is focused on how to use a where clause in PHP MySQL. you'll learn how to use a where clause in a PHP MySQL. We will use how to use the where clause in PHP MySQL. if you have a question about how to use the where clause in PHP MySQL then I will give a simple example with a solution.

Now, let's see the article on how to use the where clause in PHP MySQL. it's a simple example of how to use the where clause in PHP MySQL. you can understand the concept of how to use a where clause in a PHP MySQL. if you have a question about how to use a where clause in PHP MySQL then I will give a simple example with a solution.

Example: index.php 
<?php
    
    $servername = "localhost";
    $username = "root";
    $password = "root";
    $dbname = "myDB";

    // Create a connection
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    
    // Check the connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }

    $sql = "SELECT id, firstname, lastname FROM MyGuests WHERE lastname='Doe'";
    $result = mysqli_query($conn, $sql);

    if (mysqli_num_rows($result) > 0) {
        // output data of each row
        while($row = mysqli_fetch_assoc($result)) {
            echo "Name:" . $row["firstname"].;
        }
    }else {
        echo "0 results";
    }

    mysqli_close($conn);

?>
Output: 
Name: John

I hope it could help you...

We are Recommending you

Search

Popular Posts

Random Posts

Categories

Latest Posts

Copyright © 2023 www.RVSolutionStuff.com • All Rights Reserved