Re: [PHP-DB] Conditional updating...
You could do a conditional update based on whether the form input is empty/blank or not. Use trim() on every input box entry, update that entry if there is any value Make the query string based on non-empty inputs trim(formput) != '' //append to query string Finally, your update query could look like Update table set fieldname1 = fieldvalue1, fieldname2 = fieldvalue2 Make a special case for when only one value is inserted and another for when there are more than one. Above is the idea/process, do use the correct syntax Naintara On Sat, 17 Jun 2006 17:06:41 -0600, "Grae Wolfe - PHP" <[EMAIL PROTECTED]> wrote: > That was the first thing that I was going to do, but there is a concern > there for security of the data being input... This is a registration > site, > and I don't want to provide information on "John Smith" to anyone who just > happens to put his name in. > > > ""Alejandro Tesone"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> Why don't you try populating the fields the user intends to modify >> with the information you already have? >> >> Alex T >> >> On 6/17/06, Grae Wolfe - PHP <[EMAIL PROTECTED]> wrote: >>> Good day! >>> I have been working on this little "free" project for a while, and > now >>> I >>> have hit another major hiccup. Is there a simple way to only update >>> fields >>> that have something in them? >>> The problem that I am having is that if someone fills out information >>> and >>> submits it, it saves to the DB just fine. However, if they come back >>> later >>> and just put in, for example, a new phone number, it replaces all of > the >>> other information with blanks. >>> Here is my current $sql query: >>> >>> $sql = "UPDATE $table >>> SET >>> first_name='$first_name', >>> last_name='$last_name', >>> hs_last_name='$hs_last_name', >>> guest_name='$guest_name', >>> street_address1='$street_address1', >>> street_address2='$street_address2', >>> city='$city', >>> state='$state', >>> zip='$zip', >>> phone1='$phone1', >>> phone2='$phone2', >>> email_address='$email_address', >>> farmers_barn='$farmers_barn', >>> wrhs_tour='$wrhs_tour', >>> crystal_rose='$crystal_rose', >>> registration_comments='$registration_comments', >>> date_registered='$today' >>> WHERE first_name='$first_name' AND last_name='$last_name'"; >>> >>> >>> >>> -- >>> PHP Database Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> >>> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Conditional updating...
That was the first thing that I was going to do, but there is a concern there for security of the data being input... This is a registration site, and I don't want to provide information on "John Smith" to anyone who just happens to put his name in. ""Alejandro Tesone"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Why don't you try populating the fields the user intends to modify > with the information you already have? > > Alex T > > On 6/17/06, Grae Wolfe - PHP <[EMAIL PROTECTED]> wrote: >> Good day! >> I have been working on this little "free" project for a while, and now >> I >> have hit another major hiccup. Is there a simple way to only update >> fields >> that have something in them? >> The problem that I am having is that if someone fills out information >> and >> submits it, it saves to the DB just fine. However, if they come back >> later >> and just put in, for example, a new phone number, it replaces all of the >> other information with blanks. >> Here is my current $sql query: >> >> $sql = "UPDATE $table >> SET >> first_name='$first_name', >> last_name='$last_name', >> hs_last_name='$hs_last_name', >> guest_name='$guest_name', >> street_address1='$street_address1', >> street_address2='$street_address2', >> city='$city', >> state='$state', >> zip='$zip', >> phone1='$phone1', >> phone2='$phone2', >> email_address='$email_address', >> farmers_barn='$farmers_barn', >> wrhs_tour='$wrhs_tour', >> crystal_rose='$crystal_rose', >> registration_comments='$registration_comments', >> date_registered='$today' >> WHERE first_name='$first_name' AND last_name='$last_name'"; >> >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Conditional updating...
Why don't you try populating the fields the user intends to modify with the information you already have? Alex T On 6/17/06, Grae Wolfe - PHP <[EMAIL PROTECTED]> wrote: Good day! I have been working on this little "free" project for a while, and now I have hit another major hiccup. Is there a simple way to only update fields that have something in them? The problem that I am having is that if someone fills out information and submits it, it saves to the DB just fine. However, if they come back later and just put in, for example, a new phone number, it replaces all of the other information with blanks. Here is my current $sql query: $sql = "UPDATE $table SET first_name='$first_name', last_name='$last_name', hs_last_name='$hs_last_name', guest_name='$guest_name', street_address1='$street_address1', street_address2='$street_address2', city='$city', state='$state', zip='$zip', phone1='$phone1', phone2='$phone2', email_address='$email_address', farmers_barn='$farmers_barn', wrhs_tour='$wrhs_tour', crystal_rose='$crystal_rose', registration_comments='$registration_comments', date_registered='$today' WHERE first_name='$first_name' AND last_name='$last_name'"; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Conditional updating...
Good day! I have been working on this little "free" project for a while, and now I have hit another major hiccup. Is there a simple way to only update fields that have something in them? The problem that I am having is that if someone fills out information and submits it, it saves to the DB just fine. However, if they come back later and just put in, for example, a new phone number, it replaces all of the other information with blanks. Here is my current $sql query: $sql = "UPDATE $table SET first_name='$first_name', last_name='$last_name', hs_last_name='$hs_last_name', guest_name='$guest_name', street_address1='$street_address1', street_address2='$street_address2', city='$city', state='$state', zip='$zip', phone1='$phone1', phone2='$phone2', email_address='$email_address', farmers_barn='$farmers_barn', wrhs_tour='$wrhs_tour', crystal_rose='$crystal_rose', registration_comments='$registration_comments', date_registered='$today' WHERE first_name='$first_name' AND last_name='$last_name'"; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
