/PHP/Php prepared statement and conditional

Php prepared statement and conditional

$conn = getConnection();
$query = "SELECT first_name, last_name, description, title, message ,font_size , DATE_FORMAT(effective_date,'%h:%i %p %m-%d-%Y')
          FROM tbl_messages
          JOIN tbl_authors ON tbl_authors.id_author = tbl_messages.id_author
          JOIN tbl_locations ON tbl_messages.id_location = tbl_locations.id_location
          WHERE tbl_messages.id_location = IF(? = 1,tbl_messages.id_location,?)
          AND effective_date <= NOW()
          ORDER BY effective_date DESC
          LIMIT 1
          ";

if (!$stmt = $conn->prepare($query)) {
    return false;
}

$stmt->bind_param('ii', $location,$location);

$result = array();

$stmt->bind_result($first_name, $last_name, $location, $title, $message, $size, $date);
$stmt->execute();

while ($stmt->fetch()) {
    $m = new Message($first_name, $last_name, $location, $title, $message, $size, $date);
    array_push($result, $m);
}

return $result;

Source: stackoverflow.com

Similar codes

1 vote312 views1 answer
Get child theme path in wordpress
PHP
0 vote351 views3 answers
Cdn javascript
PHP
0 vote299 views1 answer
Php ord deprecated
PHP
0 vote351 views2 answers
Parse error: syntax error, unexpected 'if' (T_IF) in /opt/lampp/htdocs/testphp.php on line 30
PHP
0 vote273 views0 answer
PHP
0 vote359 views1 answer
Save custom input field value into cart item
PHP
5 votes318 views5 answers
Group by laravel
PHP Laravel
0 vote333 views2 answers
Laravel return 1 as true
PHP
12 votes330 views6 answers
Set session data in laravel
PHP
0 vote455 views1 answer
Symfony check:requirements Fatal error: Using $this when not in object context in C:\Users\Admin\.symfony\cache\check.php on line 778 exit status 255
PHP Symfony