Is there a mysql query validation library for php?

szboardstretcher · 06-27-2013, 11:04 PM

Writing some php that will allow a user to dump out some mysql for an administrator to run.

It would be very nice to be able to validate the mysql statements before dumping them out to be run. Obviously an admin can run the sql against an offline slave db or something -- but for the sake of trying, is there a lib out there to validate sql?

So this would return a value of 0 or ok!

select * from some_table;

And this would return a value of 1 or noway!

sex * from some_table;

Anyone have any good libraries?

NevemTeve · 06-27-2013, 11:27 PM

Perhaps you could try "EXPLAIN SELECT ..." -- if it gives an error, the SELECT might be wrong.

szboardstretcher · 06-27-2013, 11:55 PM

Thank you. I've considered that. But the reason the sql is being plopped out in the first place is because it can't be run directly on the prod DB server. So EXPLAIN will not work for me.

dugan · 06-28-2013, 01:01 AM

Quote:

Originally Posted by szboardstretcher

Writing some php that will allow a user to dump out some mysql for an administrator to run.

sex * from some_table;

The SQL is being generated by the PHP that you're writing, right?

Why would your PHP output that in the first place?