masotti wrote:

>> On Thu, Sep 13, 2012 at 12:10 PM, Lester Caine <lester@...
>> ><mailto:lester%40lsces.co.uk>> wrote:
>> > > call_user_func_array
>> >
>> >Ahh, call_user_func_array. Great idea. Thanks.
> if you search for call_user_func_array in the history of this mailing
> list, you should peek a post I did some years ago with functions
> replacing Delphi style parameters (i.e. nominal like :par1) and an
> associative array of values into PHP '?' (i.e. positional) maintaining
> correct order and managing duplicate names (i.e. WHERE :name ='S100' or
> substring(:name from 1 FOR 2) = 'X2')
>
> http://tech.groups.yahoo.com/group/firebird-php/message/2480

I never did finish that thread :(
With ADOdb we build an array of values for things like insert or update and then
create a suitable query from the array. Toggling between the two depending on
whether there is a primary id for the record ...
Extending where statements and the like is a similar process, and always using
'?' for values naturally provides some protection and eliminates the need to
worry about 'magic_quotes' :)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk