StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMultiple conditions queries with PDO
text
Body
copied!<p>I asked this question in <a href="http://codereview.stackexchange.com">http://codereview.stackexchange.com</a> and they wanted me to post it here. I couldn't get this code to work at all. I switched from regular mysql to pdo which is more safer. Could someone tell me what I'm missing here. I've been struggling with it for couple of day, and I could find exact answer when I first searched this site. </p> <pre><code> $input = $_POST['input']; $categories = $_POST['category']; $state = $_POST['state']; $zipcode = $_POST['zipcode']; $qq = $db->prepare(" SELECT * FROM classified ")or die(print_r($qq->errorInfo(), true)); /*** execute the prepared statement ***/ $qq->execute(); /*** echo number of columns ***/ $rows = $qq->fetch(PDO::FETCH_NUM); if ($rows>0){ $query = (" SELECT * FROM classified "); $cond = array(); $params = array(); if (!empty($input)) { $cond[] = "title = ?"; $params[] = $input; } if (!empty($categories)) { $cond[] = "id_cat = ?"; $params[] = $categories; } if (!empty($state)) { $cond[] = "id_state = ?"; $params[] = $state; } if (!empty($zipcode)) { $cond[] = "zipcode = ?"; $params[] = $zipcode; } if (count($cond)) { $query .= ' WHERE ' . implode(' AND ', $cond)or die(print_r($query->errorInfo(),true)); } $stmt = $db->prepare($query); $stmt->execute($params); $ro = $stmt->fetch(PDO::FETCH_NUM); } if ($ro > 0) { foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) { echo $row['title']; echo $row['categories']; echo $row['state']; echo $row['zipcode']; } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload