mysql - Mysql default value from wordpress form query

Question

I'm trying to work out a mysql query from a wordpress form submission.

Currently my query is:

INSERT INTO blah (`blah`, `blah`, `blah`, `blah`, `blah`, `blah`, `blah`, `blah`, `blah`) VALUES ("{11}", "{2}", "{6}", "{5}", "{4}", "{16}", "{7}", "{15}", "{10}")

If one of the values from the form (an image file location) is left empty I'd like it to be replaced with a default value (image file location)

Thanks for any help!

Alex

标签： mysql

Answer 1

您可以在发送查询之前检查数据并给它们一个默认值，如下所示：

if($img == '') $img = "your/path/to/image.jpg";