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_paymentSo, 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 )