Solved

Filter a PHP/MySQL recordset as I did in Classic ASP with ADO Filter

Posted on 2010-11-27
4
721 Views
Last Modified: 2012-05-10
Hello,
In the good old Classic ASP days I used sometimes to filter a recordset like this:
myRS = "SELECT myid, myname, mykey FROM mytable" ' just to give the idea
...
myRS.Filter = "mykey = " & myfirstvariable
...[loop through filtered records]...
myRS.Filter = "mykey = " & mysecondvariable
...[loop through filtered records]...

Open in new window

In this way, I had to create a recordset only once, instead of creating multiple recordsets:
myRS1 = "SELECT myid, myname, mykey FROM mytable WHERE mykey = " & myfirstvariable
...[loop]...
myRS2 = "SELECT myid, myname, mykey FROM mytable WHERE mykey = " & mysecondvariable
...[loop]...

Open in new window


Well, is there a similar "filter" capabilities in PHP/MySQL, or should I create so many recordset as are my filters?
Thanks
0
Comment
Question by:ivanhalen
  • 2
4 Comments
 
LVL 13

Expert Comment

by:darren-w-
ID: 34221590
Hi,

I think this could be done with place markers as in example 2 in this link?  
http://php.net/manual/en/pdo.prepare.php

Darren
0
 
LVL 12

Expert Comment

by:zappafan2k2
ID: 34221777
How about using "IN" instead of "="?
// assuming you have a list of keys in array $myKeys
$myRS = "SELECT myid, myname, mykey FROM mytable WHERE mykey IN (" . implode(',', $myKeys) . ");";
// loop

Open in new window

0
 

Author Comment

by:ivanhalen
ID: 34221910
@darren-w-: this seems a nice solution, but what about without PDO?
@zappafan2k2: mmm... I can't understand how your example could be useful to me... the idea is to reach something like:
create a general recordset
filter only records that match a certain parameter X
loop only the filtered records X
re-filter only records that match a certain parameter Y
loop only the filtered records Y
etc...

Open in new window

I need this becouse my HTML structure MUST be so:
<table>
// here goes the first filter
<tbody>
// loop through the filtered records
</tbody>
// here goes the second filter
<tbody>
// loop through the filtered records
</tbody>
etc...
</table>

Open in new window

And no, I can't put my records in a single <tbody>...</tbody>, I MUST use as many as my filters are
0
 
LVL 13

Accepted Solution

by:
darren-w- earned 500 total points
ID: 34221955
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now