php - sending form select option values to database not working -
im working on form posts select option value database. have done code dreamweaver server behaviors still not work. here html , php code.
any appreciated
<form method="post" action="<?php echo $editformaction; ?>" name="applynow"> <table width="550" border="0"> <tr><h4>name *</h4> <td width="264"><input name="fname" type="text" size="30" maxlength="35" placeholder="first name"/></td> <td width="276"><input name="lname" type="text" size="30" maxlength="35" placeholder="last name"/></td> </tr> </table> <p> <label> <input type="radio" name="gender" value="male" id="male" /> male</label> <br /> <label> <input type="radio" name="gender" value="female" id="female" /> female</label> <br /> </p> </table> <table width="550" border="0"> <tr> <h4>address *</h4><p><input style="width:485px" name="address_1" type="text" size="30" maxlength="30" placeholder="street address"/> </tr> <tr> <input style="width:485px" name="address_2" type="text" size="30" maxlength="30" placeholder="address line 2"/> </tr> </table> <table width="550" border="0"> <tr> <td><input name="city" type="text" size="30" maxlength="30" placeholder="city"/></td> <td><input name="state" type="text" size="30" maxlength="30" placeholder="state / province / region"/></td> </tr> <tr> <td><input name="zipcode" type="text" size="30" maxlength="30" placeholder="zip / postal code"/></td> <td> <select style="width:223px" name='country' tabindex='12' id="country" > <option value="not selected">select country</option> <option value='afghanistan' >afghanistan</option> <option value='albania'>albania</option> <option value='algeria' >algeria</option> <option value='american samoa' >american samoa</option> <option value='andorra' >andorra</option> <option value='angola' >angola</option> <option value='antigua , barbuda' >antigua , barbuda</option> <option value='argentina' >argentina</option> <option value='armenia' >armenia</option> <option value='australia' >australia</option> <option value='austria' >austria</option> <option value='azerbaijan' >azerbaijan</option> <option value='bahamas' >bahamas</option> <option value='bahrain' >bahrain</option> <option value='bangladesh' >bangladesh</option> <option value='barbados' >barbados</option> <option value='belarus' >belarus</option> <option value='belgium' >belgium</option> <option value='belize' >belize</option> <option value='benin' >benin</option> <option value='bermuda' >bermuda</option> <option value='bhutan' >bhutan</option> <option value='bolivia' >bolivia</option> <option value='bosnia , herzegovina' >bosnia , herzegovina</option> <option value='botswana' >botswana</option> <option value='brazil' >brazil</option> <option value='brunei' >brunei</option> <option value='bulgaria' >bulgaria</option> <option value='burkina faso' >burkina faso</option> <option value='burundi' >burundi</option> <option value='cambodia' >cambodia</option> <option value='cameroon' >cameroon</option> <option value='canada' >canada</option> <option value='cape verde' >cape verde</option> <option value='central african republic' >central african republic</option> <option value='chad' >chad</option> <option value='chile' >chile</option> <option value='china' >china</option> <option value='colombia' >colombia</option> <option value='comoros' >comoros</option> <option value='congo, democratic republic of the' >congo, democratic republic of the</option> <option value='congo, republic of the' >congo, republic of the</option> <option value='costa rica' >costa rica</option> <option value='côte d'ivoire' >côte d'ivoire</option> <option value='croatia' >croatia</option> <option value='cuba' >cuba</option> <option value='cyprus' >cyprus</option> <option value='czech republic' >czech republic</option> <option value='denmark' >denmark</option> <option value='djibouti' >djibouti</option> <option value='dominica' >dominica</option> <option value='dominican republic' >dominican republic</option> <option value='east timor' >east timor</option> <option value='ecuador' >ecuador</option> <option value='egypt' >egypt</option> <option value='el salvador' >el salvador</option> <option value='equatorial guinea' >equatorial guinea</option> <option value='eritrea' >eritrea</option> <option value='estonia' >estonia</option> <option value='ethiopia' >ethiopia</option> <option value='fiji' >fiji</option> <option value='finland' >finland</option> <option value='france' >france</option> <option value='gabon' >gabon</option> <option value='gambia' >gambia</option> <option value='georgia' >georgia</option> <option value='germany' >germany</option> <option value='ghana' >ghana</option> <option value='greece' >greece</option> <option value='greenland' >greenland</option> <option value='grenada' >grenada</option> <option value='guam' >guam</option> <option value='guatemala' >guatemala</option> <option value='guinea' >guinea</option> <option value='guinea-bissau' >guinea-bissau</option> <option value='guyana' >guyana</option> <option value='haiti' >haiti</option> <option value='honduras' >honduras</option> <option value='hong kong' >hong kong</option> <option value='hungary' >hungary</option> <option value='iceland' >iceland</option> <option value='india' >india</option> <option value='indonesia' >indonesia</option> <option value='iran' >iran</option> <option value='iraq' >iraq</option> <option value='ireland' >ireland</option> <option value='israel' >israel</option> <option value='italy' >italy</option> <option value='jamaica' >jamaica</option> <option value='japan' >japan</option> <option value='jordan' >jordan</option> <option value='kazakhstan' >kazakhstan</option> <option value='kenya' >kenya</option> <option value='kiribati' >kiribati</option> <option value='north korea' >north korea</option> <option value='south korea' >south korea</option> <option value='kuwait' >kuwait</option> <option value='kyrgyzstan' >kyrgyzstan</option> <option value='laos' >laos</option> <option value='latvia' >latvia</option> <option value='lebanon' >lebanon</option> <option value='lesotho' >lesotho</option> <option value='liberia' >liberia</option> <option value='libya' >libya</option> <option value='liechtenstein' >liechtenstein</option> <option value='lithuania' >lithuania</option> <option value='luxembourg' >luxembourg</option> <option value='macedonia' >macedonia</option> <option value='madagascar' >madagascar</option> <option value='malawi' >malawi</option> <option value='malaysia' >malaysia</option> <option value='maldives' >maldives</option> <option value='mali' >mali</option> <option value='malta' >malta</option> <option value='marshall islands' >marshall islands</option> <option value='mauritania' >mauritania</option> <option value='mauritius' >mauritius</option> <option value='mexico' >mexico</option> <option value='micronesia' >micronesia</option> <option value='moldova' >moldova</option> <option value='monaco' >monaco</option> <option value='mongolia' >mongolia</option> <option value='montenegro' >montenegro</option> <option value='morocco' >morocco</option> <option value='mozambique' >mozambique</option> <option value='myanmar' >myanmar</option> <option value='namibia' >namibia</option> <option value='nauru' >nauru</option> <option value='nepal' >nepal</option> <option value='netherlands' >netherlands</option> <option value='new zealand' >new zealand</option> <option value='nicaragua' >nicaragua</option> <option value='niger' >niger</option> <option value='nigeria' >nigeria</option> <option value='norway' >norway</option> <option value='northern mariana islands' >northern mariana islands</option> <option value='oman' >oman</option> <option value='pakistan' >pakistan</option> <option value='palau' >palau</option> <option value='palestine' >palestine</option> <option value='panama' >panama</option> <option value='papua new guinea' >papua new guinea</option> <option value='paraguay' >paraguay</option> <option value='peru' >peru</option> <option value='philippines' >philippines</option> <option value='poland' >poland</option> <option value='portugal' >portugal</option> <option value='puerto rico' >puerto rico</option> <option value='qatar' >qatar</option> <option value='romania' >romania</option> <option value='russia' >russia</option> <option value='rwanda' >rwanda</option> <option value='saint kitts , nevis' >saint kitts , nevis</option> <option value='saint lucia' >saint lucia</option> <option value='saint vincent , grenadines' >saint vincent , grenadines</option> <option value='samoa' >samoa</option> <option value='san marino' >san marino</option> <option value='sao tome , principe' >sao tome , principe</option> <option value='saudi arabia' >saudi arabia</option> <option value='senegal' >senegal</option> <option value='serbia , montenegro' >serbia , montenegro</option> <option value='seychelles' >seychelles</option> <option value='sierra leone' >sierra leone</option> <option value='singapore' >singapore</option> <option value='slovakia' >slovakia</option> <option value='slovenia' >slovenia</option> <option value='solomon islands' >solomon islands</option> <option value='somalia' >somalia</option> <option value='south africa' >south africa</option> <option value='spain' >spain</option> <option value='sri lanka' >sri lanka</option> <option value='sudan' >sudan</option> <option value='sudan, south' >sudan, south</option> <option value='suriname' >suriname</option> <option value='swaziland' >swaziland</option> <option value='sweden' >sweden</option> <option value='switzerland' >switzerland</option> <option value='syria' >syria</option> <option value='taiwan' >taiwan</option> <option value='tajikistan' >tajikistan</option> <option value='tanzania' >tanzania</option> <option value='thailand' >thailand</option> <option value='togo' >togo</option> <option value='tonga' >tonga</option> <option value='trinidad , tobago' >trinidad , tobago</option> <option value='tunisia' >tunisia</option> <option value='turkey' >turkey</option> <option value='turkmenistan' >turkmenistan</option> <option value='tuvalu' >tuvalu</option> <option value='uganda' >uganda</option> <option value='ukraine' >ukraine</option> <option value='united arab emirates' >united arab emirates</option> <option value='united kingdom' >united kingdom</option> <option value='united states' >united states</option> <option value='uruguay' >uruguay</option> <option value='uzbekistan' >uzbekistan</option> <option value='vanuatu' >vanuatu</option> <option value='vatican city' >vatican city</option> <option value='venezuela' >venezuela</option> <option value='vietnam' >vietnam</option> <option value='virgin islands, british' >virgin islands, british</option> <option value='virgin islands, u.s.' >virgin islands, u.s.</option> <option value='yemen' >yemen</option> <option value='zambia' >zambia</option> <option value='zimbabwe' >zimbabwe</option> </select> </td> </tr> <tr> <td> <h4>phone *</h4><p> <input name="day_phone" type="text" size="30" maxlength="30" /> </td> <td> <h4>email</h4><p> <input name="email" type="text" size="30" maxlength="30" /> </td> </tr> <tr> <td colspan="2"> <h4>study number or name interested in</h4> <p> <input name="study" style="width:400px" type="text" size="30" maxlength="30" /> </td> </tr> <tr> <td colspan="2"> <h4>language *</h4><p> <select name="language" style="width:220px"> <option value="english">english</option> <option value="español" >español</option> <option value="other">other</option> </select> <tr> <td colspan="2"> <h4>are interested in specific study?<p> <select name="specific-study" style="width:220px"> <option value="gout">gout rdea594-301</option> <option value="diabetes">diabetes type ii omneon-018</option> <option value="copd">copd pt-003007</option> </select> <tr> <td colspan="2"> <h4>how did hear us?</h4><p> <select name='referral' style="width:220px"> <option value='internet' >internet</option> <option value='newspaper'>newspaper</option> <option value='magazine'>magazine</option> <option value='radio'>radio</option> <option value='tv'>television</option> <option value='doctor'>doctor</option> <option value='friend'>friend</option> <option value='family-member'>family member</option> <option value='s-s'>spouse/significant other</option> <option value='other'>other</option> </select> </td> </tr> <tr> <td colspan="2"> <h4>date of birth *</h4><p> <input type="text" name="birthdate" placeholder="mm/dd/yyyy"/> </td> </tr> </table> <div class="tail2"><h4>section 2: participant information</h4></div> <h4>when available overnight stays? *</h4> <p> <label> <input type="checkbox" name="overnight-stay" value="anytime" id="anytime" /> anytime</label> <br /> <label> <input type="checkbox" name="overnight-stay" value="weekends" id="weekends" /> weekends</label> <br /> <label> <input type="checkbox" name="overnight-stay" value="weekdays" id="weekdays" /> weekdays</label> <br /> <label> <input type="checkbox" name="overnight-stay" value="outpatient" id="outpatient" /> outpatient only</label> <br /> <label> <input type="checkbox" name="overnight-stay" value="shortstaysonly" id="shortstaysonly" /> short stays only</label> <br /> <label> <input type="checkbox" name="overnight-stay" value="longstaysonly" id="longstaysonly" /> long stays only</label> <br /> </p> <h4>smoking status *</h4> <p> <label> <input type="radio" name="smoking" value="none" id="none" /> none (no nicotine w/in last 90 days)</label> <br /> <label> <input type="radio" name="smoking" value="1-10/day" id="1-10/day" /> 1 10 cigarettes/day</label> <br /> <label> <input type="radio" name="smoking" value="11-20/day" id="11-20/day" /> 11 20 cigarettes/day</label> <br /> <label> <input type="radio" name="smoking" value="21+/day" id="21+/day" /> 21 or more cigarettes/day</label> <br /> <label> <input type="radio" name="smoking" value="occasional-social" id="occasional-social" /> occasional smoker/social smoker</label> <br /> <label> <input type="radio" name="smoking" value="other" id="other" /> other</label> <br /> </p> <h4>taking prescriptions or medicines *</h4><p> <textarea style="width:535px; height:100px" name="scripts" cols="150" rows="10"></textarea> <p style="font-size:10px; margin-top:-30px">please list prescription or over-the-counter medication have taken within last 30 days (including birth control, vitamins, herbal supplements). if have not taken prescription or over-the-counter drugs in past 30 days, type none.</p> <h4>allergies? *</h4><p> <textarea style="width:535px; height:100px" name="allergies" cols="150" rows="20"></textarea> <p style="font-size:10px; margin-top:-30px">if allergic medications, please list are, , reaction have medication (e.g. penicillin: rash, codeine: swelling). no not have alleriges, type none.</p> <h4>medical conditions? *</h4><p> <textarea style="width:535px; height:100px" name="medcond" cols="150" rows="20"></textarea> <p style="font-size:10px; margin-top:-30px">please list chronic medical conditions or diagnosis (e.g. asthma, diabetes, high blood pressure, depression, etc.) if not have chronic medical conditions, type none.</p> <h4>dietary needs? *</h4><p> <textarea style="width:535px; height:100px" name="dietneeds" cols="150" rows="20"></textarea> <p style="font-size:10px; margin-top:-30px">please list special dietary needs (e.g. vegetarian, lactose intolerant, diabetic). if not have special dietary needs, type none.</p> <h4>if vegetarian/vegen/lactose, willing eat meat/dairy if study required it?*</h4> <p> <label> <input type="radio" name="ifvegan" value="yes" id="yes" /> yes</label> <br /> <label> <input type="radio" name="ifvegan" value="no" id="no" /> no</label> <br /> <label> <input type="radio" name="ifvegan" value="na" id="na" /> not applicable</label> <br /> </p> <h4>do have (please check apply)? *</h4> <p> <label> <input type="checkbox" name="conditions" value="h-a" id="checkboxgroup1_0" /> hepatitis a</label> <br /> <label> <input type="checkbox" name="conditions" value="h-b" id="checkboxgroup1_1" /> hepatitis b</label> <br /> <label> <input type="checkbox" name="conditions" value="h-c" id="checkboxgroup1_2" /> hepatitis c</label> <br /> <label> <input type="checkbox" name="conditions" value="hiv" id="checkboxgroup1_3" /> hiv</label> <br /> <label> <input type="checkbox" name="conditions" value="none" id="checkboxgroup1_4" /> none of above</label> <br /> </p> <h4>have used illicit drugs in past year? *</h4> <p> <label> <input type="radio" name="drugs" value="yes" id="drugs_0" /> yes</label> <br /> <label> <input type="radio" name="drugs" value="no" id="drugs_1" /> no</label> <br /> </p> <h4>height *</h4><p> <input name="height" type="text" size="30" maxlength="30" /> <h4>weight *</h4><p> <input name="weight" type="text" size="30" maxlength="30" /> <h4>what classify race as? *</h4> <p> <label> <input type="radio" name="race" value="african american/black" id="race_0" /> african american/black</label> <br /> <label> <input type="radio" name="race" value="american eskimo" id="race_1" /> american eskimo</label> <br /> <label> <input type="radio" name="race" value="asian" id="race_2" /> asian</label> <br /> <label> <input type="radio" name="race" value="caucasian" id="race_3" /> caucasian</label> <br /> <label> <input type="radio" name="race" value="hispanic" id="race_4" /> hispanic</label> <br /> <label> <input type="radio" name="race" value="latino" id="race_5" /> latino</label> <br /> <label> <input type="radio" name="race" value="middle eastern" id="race_6" /> middle eastern</label> <br /> <label> <input type="radio" name="race" value="native american" id="race_7" /> native american</label> <br /> <label> <input type="radio" name="race" value="pacific islander" id="race_8" /> pacific islander</label> <br /> <label> <input type="radio" name="race" value="other" id="race_9" /> other</label> <br /> </p> <h4>can retain information in our confidential database? *</h4> <p> <label> <input type="radio" name="retain-info" value="yes" id="retain-info_0" /> yes</label> <br /> <label> <input type="radio" name="retain-info" value="no" id="retain-info_1" /> no</label> <br /> </p> <h4>comments</h4><p> <textarea name="comments" cols="1" rows="4" style="width:530px"></textarea> <input name="submit" type="submit" value="submit" /> <input type="hidden" name="mm_insert" value="applynow" /> </form> <?php require_once('../connections/conn_db.php'); ?> <?php if (!function_exists("getsqlvaluestring")) { function getsqlvaluestring($thevalue, $thetype, $thedefinedvalue = "", $thenotdefinedvalue = "") { if (php_version < 6) { $thevalue = get_magic_quotes_gpc() ? stripslashes($thevalue) : $thevalue; } $thevalue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($thevalue) : mysql_escape_string($thevalue); switch ($thetype) { case "text": $thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null"; break; case "long": case "int": $thevalue = ($thevalue != "") ? intval($thevalue) : "null"; break; case "double": $thevalue = ($thevalue != "") ? doubleval($thevalue) : "null"; break; case "date": $thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null"; break; case "defined": $thevalue = ($thevalue != "") ? $thedefinedvalue : $thenotdefinedvalue; break; } return $thevalue; } } $editformaction = $_server['php_self']; if (isset($_server['query_string'])) { $editformaction .= "?" . htmlentities($_server['query_string']); } if ((isset($_post["mm_insert"])) && ($_post["mm_insert"] == "applynow")) { $insertsql = sprintf("insert study_applications (fname, lname, gender, address_1, address_2, city, `state`, zipcode, country, day_phone, email, study, `language`, specific-study, referral, birthdate, overnight-stay, smoking, scripts, allergies, medcond, dietneeds, ifvegan, conditions, drugs, height, weight, race, retain-info, comments) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", getsqlvaluestring($_post['fname'], "text"), getsqlvaluestring($_post['lname'], "text"), getsqlvaluestring($_post['gender'], "text"), getsqlvaluestring($_post['address_1'], "text"), getsqlvaluestring($_post['address_2'], "text"), getsqlvaluestring($_post['city'], "text"), getsqlvaluestring($_post['state'], "text"), getsqlvaluestring($_post['zipcode'], "text"), getsqlvaluestring($_post['country'], "text"), getsqlvaluestring($_post['day_phone'], "text"), getsqlvaluestring($_post['email'], "text"), getsqlvaluestring($_post['study'], "text"), getsqlvaluestring($_post['language'], "text"), getsqlvaluestring($_post['specific-study'], "text"), getsqlvaluestring($_post['referral'], "text"), getsqlvaluestring($_post['birthdate'], "text"), getsqlvaluestring(isset($_post['overnight-stay']) ? "true" : "", "defined","'y'","'n'"), getsqlvaluestring($_post['smoking'], "text"), getsqlvaluestring($_post['scripts'], "text"), getsqlvaluestring($_post['allergies'], "text"), getsqlvaluestring($_post['medcond'], "text"), getsqlvaluestring($_post['dietneeds'], "text"), getsqlvaluestring($_post['ifvegan'], "text"), getsqlvaluestring(isset($_post['conditions']) ? "true" : "", "defined","'y'","'n'"), getsqlvaluestring($_post['drugs'], "text"), getsqlvaluestring($_post['height'], "text"), getsqlvaluestring($_post['weight'], "text"), getsqlvaluestring($_post['race'], "text"), getsqlvaluestring(isset($_post['retain-info']) ? "true" : "", "defined","'y'","'n'"), getsqlvaluestring($_post['comments'], "text")); mysql_select_db($database_conn_db, $conn_db); $result1 = mysql_query($insertsql, $conn_db) or die(mysql_error()); } mysql_select_db($database_conn_db, $conn_db); $query_recordset1 = "select * study_applications"; $recordset1 = mysql_query($query_recordset1, $conn_db) or die(mysql_error()); $row_recordset1 = mysql_fetch_assoc($recordset1); $totalrows_recordset1 = mysql_num_rows($recordset1); ?> sorry guys, error says
you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'specific-study, referral, birthdate, overnight-stay, smoking, scripts, allergies' @ line 1
you need use backticks around column name hyphen in it, example in query
colname, `specific-study`, etc etc on note though, having columns or tables need backticks round pain , making difficult yourself. suggest change column names before far development , have sensible names don't need cater in special ways.
on side note: when have code, please, you, there isn't need post entire bit of code, bits relevant. if had not seen comment @ bottom, there no way going dig , shovel way through code.
even if aren't sure bit post, have put in:
i have html form seems sending data through correctly, , here php code seems generating problem - , posted php itself. if folks need else, tell through comment :)
Comments
Post a Comment