Good SQL builder class
| From: | Anton Heuschen | Date: | Fri, 04 Dec 2009 13:09:55 +0000 |
| Subject: | Good SQL builder class | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-300246@lists.php.net to get a copy of this message | ||
Good day.
I'm looking for a good class to handle building dynamically from and
array (and if it is good it will automatically determine / or even
have different methods) to handle mutli-dimensional arrays or simple
associative arrays ... and build the SQL statement :
for example I have an array :
$home[$suburb]["street"] = test1;
$home[$suburb]["housenr"] =2;
Ok to keep it simple to 2, then I want to build the SQL like
insert into homes (STREET, HOUSENR) VALUES ($val1,$val2);
something like that, but I could also pass some array like :
$home["street"] = test2;
$home["housenr"] = 2;
but the idea stays the same = the index is the name of the DB fields
and the assigned value the element
I have looked on hotscripts and phpclasses but I have no idea how good
the solutions are that I have found thus far - therefor need some
recommendation from someone else past experience of this