Re: update mysql without manually tying SET statements
- From: bill <nobody@xxxxxxxxxxx>
- Date: Thu, 17 May 2012 07:09:44 -0400
On 5/16/2012 10:12 AM, apavluck@xxxxxxxxx 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
.
- References:
- update mysql without manually tying SET statements
- From: apavluck
- update mysql without manually tying SET statements
- Prev by Date: Re: update mysql without manually tying SET statements
- Next by Date: Re: update mysql without manually tying SET statements
- Previous by thread: Re: update mysql without manually tying SET statements
- Next by thread: Re: update mysql without manually tying SET statements
- Index(es):
Relevant Pages
|
