PHP MySQL CASE WHEN Function Example

Feb 03, 2022 . Admin

Hello Friends,

This article will give you example of PHP case when function example. I explained simply about PHP case when then multiple statements. This tutorial will give you simple case when then multiple statement example in PHP query.

In this post, You'll learn use case statement in when in PHP. i will show you use of case statement in PHP query example function with example.

Here i will give you many example for case when function in PHP query.

Table: users_payment


So, let's see bellow solution:

index.php
<?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 `users_payment`";

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

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

?>
Output:
Array
(
    [id] => 1
    [user_id] => 1
    [charge] => 50
    [payment_date] => 2021-08-04
)
Array
(
    [id] => 2
    [user_id] => 2
    [charge] => 45
    [payment_date] => 2021-09-07
)
Array
(
    [id] => 3
    [user_id] => 3
    [charge] => 0
    [payment_date] => 2022-01-05
)
Array
(
    [id] => 4
    [user_id] => 4
    [charge] => 10
    [payment_date] => 2022-01-04
)
#PHP