Hello Friends,

This article will give you example of PHP if statement with is null. I explained simply about PHP if statement with is null. This tutorial will give you simply example of PHP if statement with is null.

In this post, You'll learn use how to use if statement with is null in PHP. i will show you use of if statement with is null in PHP query.

Here i will give you many example for PHP if statement with is null.

So, let's see bellow solution:

<?php

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db_php";

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

$sql = "SELECT 
            id, 
            user_id, 
            CASE WHEN charge IS NULL 
                THEN 0
                ELSE charge
            END as charge, 
            payment_date 
        FROM `user_payments`";

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

while ($row = $result->fetch_assoc()) {
    echo '<pre>';
    print_r($row);
}

?>

Array
(
    [id] => 1
    [user_id] => 1
    [charge] => 50
    [payment_date] => 2022-02-02
)
Array
(
    [id] => 2
    [user_id] => 2
    [charge] => 45
    [payment_date] => 2022-02-02
)
Array
(
    [id] => 3
    [user_id] => 3
    [charge] => 0
    [payment_date] => 2022-02-02
)
Array
(
    [id] => 4
    [user_id] => 4
    [charge] => 10
    [payment_date] => 2022-02-02
)