Php How To Echo Null from MySql

Question

I have the following script that I use for part of my count in payment_status from Mysql. I have seen some examples of this online, but I can't seem to figure out how to make this work WITH a Null instance. Any insight would be appreciated.

Note: The way I have it now doesn't work when Null is in the database. I'm guessing because that isn't an inserted word?

Objective: To add $row['payment_status'] == "Null" to this with the rest of the script.

if($row['payment_status'] == "Completed" || $row['payment_status'] == "Free" || $row['payment_status'] == "Cancelled" || $row['payment_status'] == "Null")

NULL means? default value in payment_status column? if Yes then check without double quote null — M.Hemant
– M.Hemant, Commented Sep 1, 2022 at 6:02

M.Hemant · Accepted Answer · 2022-09-01 06:04:16Z

1

if payment_status column has default value NULL, Then try below change

if($row['payment_status'] == "Completed" || $row['payment_status'] == "Free" || $row['payment_status'] == "Cancelled" || $row['payment_status'] == null)

answered Sep 1, 2022 at 6:04

M.Hemant

2,3551 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Christopher Robbins Over a year ago

Ahhhh yes that did the trick. Thank you. I see why now.

Collectives™ on Stack Overflow

Php How To Echo Null from MySql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related