[RESOLVED] Arrays for queries?

jmartinez

I have a set of queries that I use over and over across multiple pages. What I was wanting to do is set up an array and call the query from that array. Does this make since? Here is what I have..

-multiple pages where the queries are needing to be
-1 page named queries.inc.php (where all the queries will be in an array?)

then I use something like

<?php echo $values['queries']['subs'];?>

to show the query that I want in that location.

I know how to use this to echo just plain text values but not queries. Is it possible? Does this even make since? Is there a better way I should be doing this? It would be great if I could have one page that would have all my queries and just use includes to show them.

Thanks in advance!

jkurrle

It seems feasible to do this, but you would need a way to keep track of which query is which. I see some irony of wanting a table of queries to be used on tables, though. If you have that many queries to keep track of, this might not be the way you want to do this.

Case in point. I found myself writing functions over and over again, simply changing queries and tables affected in each function. A good example of this would be an html table full of checkboxes, or a dropdown list based off of a couple of columns in a table. So, I rewrote the functions to take the table name and columns as passed parameters. By generalizing the function and forcing more parameters to be passed, I cut down my coding significantly.

I guess my point is, instead of storing multiple queries, try to store the structure of the queries instead and pass the table and column data as parameters.

Hopefully, this might be of some help.

rane500

Well you wouldn't echo so much as pull the query stored in that array slot, store it to a variable, then use that variable in the query function...unless you're talking about using a multidimensional array to substitue values into the query itself in which case no, you can't really do that with a quick and dirty 2D array.

jkurrle nailed it in my opinion, I've built several dynamic sites where the queries were 100% fluid...table names, columns, search patters...all determined by variables elsewhere in the script and built dynamically as needed. Designing it can get a bit ugly, but it's worth it in the end as it will do all of the work from that point on.

jmartinez

Thanks guys I will look at your suggestions, I like the idea of takeing the table name and columns as passed parameters.