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 #178170 is a reply to message #178160]

Thu, 17 May 2012 11:09

bill
Messages: 310
Registered: October 2010

Karma:

Senior Member

On 5/16/2012 10:12 AM, apavluck(at)gmail(dot)com wrote:
> 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 have all the data in the row (or hidden fields) you can
just do a REPLACE instead of the UPDATE

bill

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: Wed Nov 27 00:48:58 GMT 2024

Total time taken to generate the page: 0.03991 seconds