Create Dynamic param for search

$age=10;
$height=200;

if ($age) {
$sql[] = “age = :age”;
}
if ($height) {
$sql[] = “height = :height”;
}

$query = “UPDATE user_stats SET “;

if (!empty($sql)) {
$query .= implode(‘, ‘, $sql) . ‘ WHERE id_user = :id_user’;
}

// for pdo->execute($params)

$params = array();

if ($age) {
$params = array_merge($params, array(‘:age’ => ’39’));
}

if ($height) {
$params = array_merge($params, array(‘:height’ => ’72in’));
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s