Re: mysql insert function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, April 17, 2005 10:56 am, Dasmeet Singh said:
> I regularly need to insert data into MySQL.. and instead of writing
> Insert query everytime i wrote this function... and it works well..
>
> Please see and tell is it a good idea using this..or there might be
> problems with it?

It's not a Bad Idea, but what are you really saving with all this?

AFTER:
> $fields=array(
> "Title" => $Title,
> "OwnerMemberId" => $memberid,
> "Address" => $Address,
> "City" => $City,
> "State" => $State,
> "Pin" => $Pin
> );
>
> insertArray("Property", $fields);

BEFORE:
$query = "insert into Property (Title, OwnerMemberId, Address, City,
State, Pin) ";
$query .= " values ('$Title', $memberID, '$Adress', '$City', '$State',
'$Pin') ";
db_query($query);

Seems to me you haven't saved any characters in typing, nor made the code
significantly more clear to the reader.

That's just my take.  Everybody and their brother does it your way.
[shrug]

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux