/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 vote193 views1 answer
Laravel websockets onmessage
PHP
26 votes223 views6 answers
Php header location
PHP
13 votes161 views3 answers
Laravel make model along with its controller and migration file
PHP
12 votes194 views3 answers
Laravel db::query update
PHP Laravel
0 vote181 views2 answers
Pagination using AJAX
PHP
0 vote167 views1 answer
Phpexcel
PHP
3 votes185 views1 answer
Laravel mail and sms system
PHP Laravel
1 vote167 views1 answer
Laravel pusher broadcasting/auth 403
PHP
7 votes173 views5 answers
Laravel slug
PHP
0 vote164 views1 answer
Collection different new item and old database's item
PHP