thief425 Posted April 21, 2010 Share Posted April 21, 2010 To be frank and honest up front, I've always been scared of php. I haven't done html in a couple of years, but I'm trying to put together a rather simple form to collect information from a form and post it to a database for online storage. The field I work in employs a huge referral network, and I want to create an online database that allows agencies to list themselves for storage and search later. I've tried to piece together the following pages for data entry and pushing to the database, but when I run it, it updates every row of the database with the information from the array. I'm sure that I'm doing something totally wrong, so don't bash me for that. I don't expect anyone to write a ton of code for me, just help me find the breakdown that is causing my db to change the entire column when I submit a new form. I suspect that my problem lies in the relationships between the following parts of the code, but my inexperience doesn't help me figure out what is actually going wrong. Thanks in advance for your help. Also, I can't get textarea on the form to submit anything, ever. It's just blank. I've tried it a number of ways, thinking maybe I was missing something minor, so take what you see there with a grain of salt. mysql_query ("INSERT INTO Agency_Contacts (category, agency_name, primary_contact_name, phone_no, email_web, street, city, state, region, client_pop, hours, services) VALUES ('$category', '$agency_name', '$primary_contact_name', '$phone_no', '$email_web', '$street', '$city', '$state', '$region', '$client_pop', '$hours', '$services') "); if ($CATEGORY_ARRAY) { $CATEGORY = implode($CATEGORY_ARRAY, ","); $result = mysql_query ("UPDATE Agency_Contacts SET CATEGORY = '$CATEGORY' "); if(!$result) { echo "<B>UPDATE unsuccessful:</b> ", mysql_error(); exit; } } DataEntry.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form id="Agency Submission" name="form1" method="GET" action="../../cgi-bin/submitform.php"> Agency Category (check all that apply): <br /> <label> <input type="checkbox" name="CATEGORY_ARRAY[]" id="Administrative" value="Administrative" /> Administrative</label> <label> <br /> <input type="checkbox" name="CATEGORY_ARRAY[]" id="Advocacy/Social Justice" value="Advocacy/Social Justice" /> Advocacy/Social Justice</label> <label><br /> <input type="checkbox" name="CATEGORY_ARRAY[]" id="Community Practice" value="Community Practice" /> Community Practice</label> <p>Agency Name: <input type=text name="agency_name" size=75 maxlength=75> </p> <p>Primary Contact: <input type=text name="primary_contact_name" size=25 maxlength=25> </p> <p> Contact Phone no.: <input name=phone_no type=text value="(555)555-1212" size=25 maxlength=25> </p> <p>Email/Website: <input name=email_web type=text value="Separate with a comma" size=25 maxlength=75> </p> <p>Street Address: <input type=text name=street size=25 maxlength=50> </p> <p>City: <input type=text name=city size=25 maxlength=25> </p> <p>State: <input name=state type=text value="XX" size=6 maxlength=2> </p> Region of your state in which services are available (check all that apply): <label> <br /> <input type="checkbox" name="REGION_ARRAY[]" id="North" value="North" /> North</label> <label> <br /> <input type="checkbox" name="REGION_ARRAY[]" id="East" value="East" /> East</label> <label><br /> <input type="checkbox" name="REGION_ARRAY[]" id="South" value="South" /> South</label> <label><br /> <input type="checkbox" name="REGION_ARRAY[]" id="West" value="West" /> West</label> <p>Client populations served (select all that apply): </p> <label> <input type="checkbox" name="CLIENT_POP_ARRAY[]" id="Adult-Male" value="Adult-Male" /> Adult-Male</label> <label> <br /> <input type="checkbox" name="CLIENT_POP_ARRAY[]" id="Adult-Female" value="Adult-Female" /> Adult-Female</label> <label> <br /> <input type="checkbox" name="CLIENT_POP_ARRAY[]" id="Child/School" value="Child/School" /> Child/School</label> <label><br /> <input type="checkbox" name="CLIENT_POP_ARRAY[]" id="Domestic Violence" value="Domestic Violence" /> Domestic Violence</label> <p>Services Available: </p> <p> <textarea cols=75 rows=5 name="SERVICES_ARRAY" value="">List services separated by a comma</textarea> </p> <p> <input type=submit> </form> <p> </p> </body> </html> submitform.php <html> <body> <p><?php $link = mysql_connect('host', 'user', 'pass'); mysql_select_db(resources2010); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_query ("INSERT INTO Agency_Contacts (category, agency_name, primary_contact_name, phone_no, email_web, street, city, state, region, client_pop, hours, services) VALUES ('$category', '$agency_name', '$primary_contact_name', '$phone_no', '$email_web', '$street', '$city', '$state', '$region', '$client_pop', '$hours', '$services') "); if ($CATEGORY_ARRAY) { $CATEGORY = implode($CATEGORY_ARRAY, ","); $result = mysql_query ("UPDATE Agency_Contacts SET CATEGORY = '$CATEGORY' "); if(!$result) { echo "<B>UPDATE unsuccessful:</b> ", mysql_error(); exit; } } if ($REGION_ARRAY) { $REGION = implode($REGION_ARRAY, ","); $result = mysql_query ("UPDATE Agency_Contacts SET REGION = '$REGION' "); if(!$result) { echo "<B>UPDATE unsuccessful:</b> ", mysql_error(); exit; } } if ($CLIENT_POP_ARRAY) { $CLIENT_POP = implode($CLIENT_POP_ARRAY, ","); $result = mysql_query ("UPDATE Agency_Contacts SET CLIENT_POP = '$CLIENT_POP' "); if(!$result) { echo "<B>UPDATE unsuccessful:</b> ", mysql_error(); exit; } } if ($SERVICES_ARRAY) { $SERVICES = implode($SERVICES_ARRAY, ","); $result = mysql_query ("UPDATE Agency_Contacts SET SERVICE = '$SERVICES' "); if(!$result) { echo "<B>UPDATE unsuccessful:</b> ", mysql_error(); exit; } } print ("Thanks for submitting your agency information."); ?> </p> </body> </html> Quote Link to comment https://forums.phpfreaks.com/topic/199272-problem-with-moving-textboxes-checkboxes-textarea-to-mysql/ Share on other sites More sharing options...
thief425 Posted April 21, 2010 Author Share Posted April 21, 2010 Also, I wanted to add that I have been able to get the form to write to the database without writing to the entire column, but it creates a new record for that single field, and doesn't add to the record where the textboxes are writing to. Quote Link to comment https://forums.phpfreaks.com/topic/199272-problem-with-moving-textboxes-checkboxes-textarea-to-mysql/#findComment-1045950 Share on other sites More sharing options...
fenway Posted April 23, 2010 Share Posted April 23, 2010 Sorry, TLDR -- what's the actual problem? You can't save to mysql? Quote Link to comment https://forums.phpfreaks.com/topic/199272-problem-with-moving-textboxes-checkboxes-textarea-to-mysql/#findComment-1047060 Share on other sites More sharing options...
Kurse Posted April 24, 2010 Share Posted April 24, 2010 Looks all good except for the VALUES ('$category', '$agency_name', '$primary_contact_name', '$phone_no', '$email_web', '$street', '$city', '$state', '$region', '$client_pop', '$hours', '$services') I may be off my rocker but isn't it supposed to be '$_POST[category]','$_POST[agency_name]', etc etc etc ? Quote Link to comment https://forums.phpfreaks.com/topic/199272-problem-with-moving-textboxes-checkboxes-textarea-to-mysql/#findComment-1047752 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.