Larry Garfield wrote:
On Saturday 27 January 2007 1:14 pm, Jochem Maas wrote:
query builders are alot more fiddly to get 'right' than one might
imagine, dealing with NULLs, booleans and dates for example (as Satyam
pointed out) can be a right PITA.
I actually almost never use native date
- Original Message -
From: Jochem Maas [EMAIL PROTECTED]
To: Larry Garfield [EMAIL PROTECTED]
Cc: php-general@lists.php.net
Sent: Sunday, January 28, 2007 12:55 PM
Subject: Re: [PHP] SQL Readability.. (was Re: most powerful php editor)
Larry Garfield wrote:
On Saturday 27 January
On Sunday 28 January 2007 5:55 am, Jochem Maas wrote:
And yes, I agree that MySQL has fairly decent date manipulation routines.
But at work we do try for database independence when possible, so except
on specific projects we try to avoid it.
again we differ :-) I have never bought the
- Original Message -
From: Larry Garfield [EMAIL PROTECTED]
To: php-general@lists.php.net
Sent: Saturday, January 27, 2007 12:18 AM
Subject: Re: [PHP] SQL Readability.. (was Re: most powerful php editor)
I have long since given up on raw insert/update/delete statements as the
syntax
Larry Garfield wrote:
I have long since given up on raw insert/update/delete statements as the
syntax is all kinds nasty. These days I just do this, which is even easier
and more powerful:
http://www.garfieldtech.com/blog/simplifying-sql
a quick look at those funcs gives me the
On Sat, 2007-01-27 at 14:43 +0100, Jochem Maas wrote:
also I don't really agree with the sentiment that SQL syntax is nasty,
Hear, hear :)
Cheers,
Rob.
--
..
| InterJinn Application Framework - http://www.interjinn.com |
On Saturday 27 January 2007 7:43 am, Jochem Maas wrote:
Larry Garfield wrote:
I have long since given up on raw insert/update/delete statements as the
syntax is all kinds nasty. These days I just do this, which is even
easier and more powerful:
Larry Garfield wrote:
On Saturday 27 January 2007 7:43 am, Jochem Maas wrote:
Larry Garfield wrote:
I have long since given up on raw insert/update/delete statements as the
syntax is all kinds nasty. These days I just do this, which is even
easier and more powerful:
On Saturday 27 January 2007 1:14 pm, Jochem Maas wrote:
query builders are alot more fiddly to get 'right' than one might
imagine, dealing with NULLs, booleans and dates for example (as Satyam
pointed out) can be a right PITA.
I actually almost never use native date types in the SQL
My contribution to the insanity.. INSERT statements made easy:
$genericQY = INSERT INTO MOD_LMGR_Leads (; $genericQYvalues = VALUES (;
$genericQY .= FirstName,; $genericQYvalues .= 'John',;
$genericQY .= LastName; $genericQYvalues .= 'Smith';
[EMAIL PROTECTED] wrote:
My contribution to the insanity.. INSERT statements made easy:
can't stand long var names if they're not absolutely necessary (JMO).
although I follow TG's logic here I don't find it that readable, too many
dots, [double]quotes, etc for my taste.
$genericQY =
[EMAIL PROTECTED] wrote:
My contribution to the insanity.. INSERT statements made easy:
$genericQY = INSERT INTO MOD_LMGR_Leads (; $genericQYvalues = VALUES (;
$genericQY .= FirstName,; $genericQYvalues .= 'John',;
$genericQY .= LastName;
This may not be an option for many people, 'cause ISPs and web hosts may
not be forward-thinking enough to install PDO or recent PHP, but...
PDO can do do this in a very database independant way, without having to
do the equivalent of mysql_real_escape_string:
$table = 'xyz';
$data = array(
Jon Anderson wrote:
This may not be an option for many people, 'cause ISPs and web hosts may
not be forward-thinking enough to install PDO or recent PHP, but...
PDO can do do this in a very database independant way, without having to
do the equivalent of mysql_real_escape_string:
$table =
Strangely enough, Stut and Jochem, I DO find this more readable. Hah. I know,
I'm insane. I have done it the way you guys proposed, using an associative
array and using the keys and values as the columns and insert values. While
that is what I'd call tighter code and when you understand what
- Original Message -
From: Stut [EMAIL PROTECTED]
You call that readable??
$vals = array();
$vals['FirstName'] = 'John';
$vals['LastName'] = 'Smith';
$query = mysql_query(BuildInsert('MOD_LMGR_Leads', $vals));
function BuildInsert($table, $values)
{
foreach (array_keys($values) as
On Fri, 2007-01-26 at 16:30 +, Stut wrote:
[EMAIL PROTECTED] wrote:
My contribution to the insanity.. INSERT statements made easy:
$genericQY = INSERT INTO MOD_LMGR_Leads (; $genericQYvalues = VALUES
(;
$genericQY .= FirstName,; $genericQYvalues .=
On Fri, 2007-01-26 at 12:25 -0500, [EMAIL PROTECTED] wrote:
Strangely enough, Stut and Jochem, I DO find this more readable. Hah. I know,
I'm insane. I have done it the way you guys proposed, using an associative
array and using the keys and values as the columns and insert values. While
I have long since given up on raw insert/update/delete statements as the
syntax is all kinds nasty. These days I just do this, which is even easier
and more powerful:
http://www.garfieldtech.com/blog/simplifying-sql
On Friday 26 January 2007 10:03 am, [EMAIL PROTECTED] wrote:
My contribution
19 matches
Mail list logo
