FUDforum: comp.lang.php » update mysql without manually tying SET statements

Home » Imported messages » comp.lang.php » update mysql without manually tying SET statements

Show: Today's Messages :: Polls :: Message Navigator

Re: update mysql without manually tying SET statements [message #178171 is a reply to message #178169]

Thu, 17 May 2012 11:14

IRC
Messages: 6
Registered: April 2012

Karma:

Junior Member

On May 16, 9:48 pm, "M. Strobel" <sorry_no_mail_h...@nowhere.dee>
wrote:
> Am 16.05.2012 16:12, schrieb apavl...@gmail.com:
>
>
>
>
>
>
>
>
>
>> I am trying to setup some generic code that will allow me to update a mysql database via form and php. I can capture the data in the row of the database that I want to update. I can present that in a form populated with the existing values. What I can't figure out how to do is to avoid typing out the SET statements in the update query.
>
>> ex
>
>> $sql = "update myhugedatabase
>> SET
>> reporter = '$_POST[reporter]',
>> date = '$_POST[date]',
>> district = '$_POST[district]',
>> village = '$_POST[village]',
>> school = '$_POST[school]',
>> address = '$_POST[address]',
>> teacher = '$_POST[teacher]',
>> teacher_contact = '$_POST[teacher_contact]',
>> alt_teach = '$_POST[alt_teach]',
>> alt_teach_contact = '$_POST[alt_teach_contact]',
>> gps = '$_POST[gps]',
>> etc
>> etc
>> etc
>
>> The reason I want to do this is because I manage many projects all with their own variables and databases and the update is the only part that I have to type in manually.
>
> If you don't use a framework, you must type in a SET statement for every single
> column you want to save in the database. There is no getting around it. You must do
> it at least once for every table.
>
> You would normally do even more: apply some test/validation on every field, and make
> sure required fields are not empty, and number fields contain numbers...
>
> You do this nowadays with prepared statements, to be protected against SQL injection
> attacks.
>
> If you want generic code, you must define the fields and their properties somewhere
> else in your code, this is normally not less work.
>
> /Str.

I agree with Strobel.

You have to create a function once (which can be generic) which will
process your update statement and you just pass an array of $_POST
data into that function and it will process it accordingly.

It may be worthwhile to look into ADODB database library found on php
http://adodb.sourceforge.net/

Report message to a moderator

[Message index]

		update mysql without manually tying SET statements By: Alex Pavluck on Wed, 16 May 2012 14:12
		Re: update mysql without manually tying SET statements By: Shake on Wed, 16 May 2012 14:23
		Re: update mysql without manually tying SET statements By: Thomas 'PointedEars' on Wed, 16 May 2012 16:06
		Re: update mysql without manually tying SET statements By: Alex Pavluck on Thu, 17 May 2012 18:06
		Re: update mysql without manually tying SET statements By: Shake on Thu, 17 May 2012 19:06
		Re: update mysql without manually tying SET statements By: M. Strobel on Wed, 16 May 2012 20:48
		Re: update mysql without manually tying SET statements By: IRC on Thu, 17 May 2012 11:14
		Re: update mysql without manually tying SET statements By: Erwin Moller on Fri, 18 May 2012 08:49
		Re: update mysql without manually tying SET statements By: bill on Thu, 17 May 2012 11:09

Previous Topic:	table appears with empty rows, and row data appears before table. Code seems ok. What is going on?
Next Topic:	Dynamic water marking (redirect?)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 03:57:27 GMT 2024

Total time taken to generate the page: 0.05203 seconds