PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $name = explode(" ", "John Doe"); $logical = isset($name[1]) ? 'AND' : 'OR' ; $name[1] = $name[1] ?? $name[0]; $sql = "SELECT * FROM users WHERE users.user_firstname = '$name[0]' $logical users.user_lastname= '$name[1]'"; echo $sql;
Show:  
Copy Clear