NYCPHP Meetup

[nycphp-talk] PHP Storing Query

jsiegel1 at optonline.net jsiegel1 at optonline.net
Sat Apr 26 09:19:24 EDT 2003


I thought he wanted to store the query as a query (as opposed to just storing the SQL in a table). I've probably got too much MS Access on the brain. ;)

Jeff

----- Original Message -----
From: "DeWitt, Michael" <mjdewitt at alexcommgrp.com>
Date: Friday, April 25, 2003 10:22 am
Subject: RE: [nycphp-talk] PHP Storing Query

> I'm not sure what you are are trying to do with storing  queries 
> in a
> database, but I think you mean storing query strings into a table.
> 
> If your queries are simple without any conditions, then this is a
> strightforward matter of merely storing the text of the query as a 
> stringvalue in an appropriate table structure. a query like 
> "select * from foo"
> should be easy to handle.
> 
> Most likely though, you have conditions and have queries that use a
> condition, i.e., "select * from foo where bar=$bar" The question 
> is whether
> or not you want to store the query string before or after 
> evaluating the
> value of $bar.  It should be doable either way.
> 
> The issues you will face if this along the lines of what you want 
> to do is
> properly escaping the data to allow Access to accept your data and 
> using the
> PHP eval() function to allow embedded variables returned in a 
> string from
> the database to be interpreted as variables and not merely part of 
> a string.
> 
> Again, I am not sure what you hope to gain by doing this, as you 
> may find
> better answers if you present your need or issue rather than 
> asking for help
> with a solution.
> 
> I use both ASP and PHP, and for me PHP is so much more capable 
> (especiallyunder a *nix), I would stick with PHP and perhaps 
> consider migrating your
> data to a better DB like mysql or Postgres. Postgres supports 
> views which
> may be the db function you are trying to emulate?
> 
> Hope this helps.
> 
> Mike
> 
> 
> > ----- Original Message -----
> > From: Michael E Keszkowski <kesz1 at sourcecodecentral.com>
> > Date: Thursday, April 24, 2003 10:28 am
> > Subject: [nycphp-talk] PHP Storing Query
> > 
> > > Hello;
> > > 
> > > I am adding a web (using php) interface to an existing MS 
> Access 
> > > database application.  Currently, databse is stored on a 
> network 
> > > drive and 10+ users query/update records daily.  Because some 
> > > people cannot handle change very well (never mind a computer 
> > > related change)  I would like to keep the existence database 
> > > application and slowly migrate the users over to the web.
> > > 
> > > My problem is, the application was developed very poorly.  I 
> need 
> > > to know if I can (and how to) create a query online and save 
> that 
> > > query (sql statement) in the access database as a query itself.
> > > 
> > > thanks,
> > > 
> > > -- mike
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > 
> > 
> > 
> > 
> > 
> 
> 
> --- Unsubscribe at http://nyphp.org/list/ ---
> 
> 
> 




More information about the talk mailing list