Error No query found - Help with scripting for php form into mysql database

edegreeadvisor · August 30, 2009

I created a simple form that collects info on my website. I tried scripting the php so that when the form collects the information it is sent to a simple mysql database consisting of one table and one field for each question on the form.

When I complete the form I am getting an error message that states: Error: Query was empty

Any advice would be great. I went to php.net and mysql sites and took a crash course spending 8 hours trying to figure this out. Thanks in advance!!!

Below is my form and php script (sorry its so long)

<tr>

<td width="56%">* Which area of study are you interested in?</td>

<select name="program" id="program" title="

<option selected="selected">- Select One -</option>

<option>Arts and Sciences</option>

<option>Business</option>

<option>Criminal Justice</option>

<option>Fire Science </option>

<option>Higher Education</option>

<option>Health Sciences</option>

<option>Human Services</option>

<option>Nursing</option>

<option>Teaching Education</option>

<option>Psychology</option>

<option>Public Policy</option>

</select>

</label></td>

</tr>

<tr>

<td>* Which program are you most interested in?</td>

<option selected="selected">- Select One -</option>

<option>Associates</option>

<option>Bachelors</option>

<option>Certificate</option>

<option>Masters</option>

</select>

</label></td>

</tr>

<tr>

<td>* First Name:</td>

</label></td>

</tr>

<tr>

</label></td>

</tr>

<tr>

<td>* Email Address: (valid email required)</td>

</label></td>

</tr>

<tr>

<td>* Work Phone: (valid number required)</td>

</label></td>

</tr>

<tr>

<td>* Home Phone: (valid number required)</td>

</label></td>

</tr>

<tr>

<td>* Address Line 1:</td>

</label></td>

</tr>

<tr>

<td>* Address Line 2:</td>

</label></td>

</tr>

<tr>

</label></td>

</tr>

<tr>

<td>* State or Providence:</td>

<option value="SelectState" selected="selected">Select a state</option>

<option value="Alaska">AK - Alaska</option>

<option value="Alabama">AL - Alabama</option>

<option value="Arkansas">AR - Arkansas</option>

<option value="Arizona">AZ - Arizona</option>

<option value="California">CA - California</option>

<option value="Colorado">CO - Colorado</option>

<option value="Connecticut">CT - Connecticut</option>

<option value="District of Columbia">DC - District of Columbia</option>

<option value="Delaware">DE - Delaware</option>

<option value="Florida">FL - Florida</option>

<option value="Georgia">GA - Georgia</option>

<option value="Hawaii">HI - Hawaii</option>

<option value="Idaho">ID - Idaho</option>

<option value="Illinois">IL - Illinois</option>

<option value="Indiana">IN - Indiana</option>

<option value="Kansas">KS - Kansas</option>

<option value="Kentucky">KY - Kentucky</option>

<option value="Louisiana">LA - Louisiana</option>

<option value="Massachusetts">MA - Massachusetts</option>

<option value="Maryland">MD - Maryland</option>

<option value="Maine">ME - Maine</option>

<option value="Michigan">MI - Michigan</option>

<option value="Minnesota">MN - Minnesota</option>

<option value="Missouri">MO - Missouri</option>

<option value="Mississippi">MS - Mississippi</option>

<option value="Montana">MT - Montana</option>

<option value="North Carolina">NC - North Carolina</option>

<option value="North Dakota">ND - North Dakota</option>

<option value="Nebraska">NE - Nebraska</option>

<option value="New Hampshire">NH - New Hampshire</option>

<option value="New Jersey">NJ - New Jersey</option>

<option value="New Mexico">NM - New Mexico</option>

<option value="Nevada">NV - Nevada</option>

<option value="Oklahoma">OK - Oklahoma</option>

<option value="Oregon">OR - Oregon</option>

<option value="Pennsylvania">PA - Pennsylvania</option>

<option value="Puerto Rico">PR - Puerto Rico</option>

<option value="Palau">PW - Palau</option>

<option value="Rhode Island">RI - Rhode Island</option>

<option value="South Carolina">SC - South Carolina</option>

<option value="South Dakota">SD - South Dakota</option>

<option value="Tennessee">TN - Tennessee</option>

<option value="Texas">TX - Texas</option>

<option value="Virginia">VA - Virginia</option>

<option value="Virgin Islands">VI - Virgin Islands</option>

<option value="Vermont">VT - Vermont</option>

<option value="Washington">WA - Washington</option>

<option value="Wisconsin">WI - Wisconsin</option>

<option value="West Virginia">WV - West Virginia</option>

<option value="Wyoming">WY - Wyoming</option>

<option value="Outside of the U.S.A.">- Outside of the U.S.A.</option>

</select>

</label></td>

</tr>

<tr>

</label></td>

</tr>

<tr>

<td>* Country:</td>

<option selected="selected" value="United States">United States</option>

<option value="American Samoa">American Samoa</option>

<option value="Puerto Rico">Puerto Rico</option>

<option value="Virgin Islands (U.S.)">Virgin Islands (U.S.)</option>

<option value="Albania">Albania</option>

<option value="Algeria">Algeria</option>

<option value="Andorra">Andorra</option>

<option value="Angola">Angola</option>

<option value="Anguilla">Anguilla</option>

<option value="Antarctica">Antarctica</option>

<option value="Antigua ">Antigua </option>

<option value="Argentina">Argentina</option>

<option value="Armenia">Armenia</option>

<option value="Aruba">Aruba</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 ">Bosnia </option>

<option value="Botswana">Botswana</option>

<option value="Bouvet Island">Bouvet Island</option>

<option value="Brazil">Brazil</option>

<option value="Bulgaria">Bulgaria</option>

<option value="Burma">Burma</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="Cayman Islands">Cayman Islands</option>

<option value="Chile">Chile</option>

<option value="China">China</option>

<option value="Colombia">Colombia</option>

<option value="Comoros">Comoros</option>

<option value="Congo">Congo</option>

<option value="Cook Islands">Cook Islands</option>

<option value="Costa Rica">Costa Rica</option>

<option value="Cote dIvoire">Cote d'Ivoire</option>

<option value="Croatia">Croatia</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="England">England</option>

<option value="Eritrea">Eritrea</option>

<option value="Espana">Espana</option>

<option value="Estonia">Estonia</option>

<option value="Ethiopia">Ethiopia</option>

<option value="Falkland Islands">Falkland Islands</option>

<option value="Faroe Islands">Faroe Islands</option>

<option value="Finland">Finland</option>

<option value="France">France</option>

<option value="French Guiana">French Guiana</option>

<option value="French Polynesia">French Polynesia</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="Gibraltar">Gibraltar</option>

<option value="Great Britain">Great Britain</option>

<option value="Greece">Greece</option>

<option value="Greenland">Greenland</option>

<option value="Grenada">Grenada</option>

<option value="Guadeloupe">Guadeloupe</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="Hungary">Hungary</option>

<option value="Iceland">Iceland</option>

<option value="India">India</option>

<option value="Indonesia">Indonesia</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="Korea (South)">Korea (South)</option>

<option value="Korea">Korea</option>

<option value="Kuwait">Kuwait</option>

<option value="Kyrgyzstan">Kyrgyzstan</option>

<option value="Latvia">Latvia</option>

<option value="Lebanon">Lebanon</option>

<option value="Lesotho">Lesotho</option>

<option value="Liberia">Liberia</option>

<option value="Liechtenstein">Liechtenstein</option>

<option value="Lithuania">Lithuania</option>

<option value="Luxembourg">Luxembourg</option>

<option value="Macau">Macau</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="Malta">Malta</option>

<option value="Marshall Islands">Marshall Islands</option>

<option value="Martinique">Martinique</option>

<option value="Mauritania">Mauritania</option>

<option value="Mauritius">Mauritius</option>

<option value="Mayotte">Mayotte</option>

<option value="Mexico">Mexico</option>

<option value="Monaco">Monaco</option>

<option value="Mongolia">Mongolia</option>

<option value="Montserrat">Montserrat</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="Netherlands Antilles">Netherlands Antilles</option>

<option value="New Caledonia">New Caledonia</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="Norfolk Island">Norfolk Island</option>

<option value="Northern Ireland">Northern Ireland</option>

<option value="Norway">Norway</option>

<option value="Pakistan">Pakistan</option>

<option value="Palau">Palau</option>

<option value="Panama">Panama</option>

<option value="Papua New Guinea">Papua New Guinea</option>

<option value="Paraguay">Paraguay</option>

<option value="Philippines">Philippines</option>

<option value="Pitcairn">Pitcairn</option>

<option value="Poland">Poland</option>

<option value="Portugal">Portugal</option>

<option value="Qatar">Qatar</option>

<option value="Reunion">Reunion</option>

<option value="Romania">Romania</option>

<option value="Russia">Russia</option>

<option value="Russian Federation">Russian Federation</option>

<option value="Rwanda">Rwanda</option>

<option value="Saint Kitts and Nevis">Saint Kitts and Nevis</option>

<option value="Saint Lucia">Saint Lucia</option>

<option value="Saint Vincent and the Grenadines">Saint Vincent and the Grenadines</option>

<option value="Samoa (Independent)">Samoa (Independent)</option>

<option value="San Marino">San Marino</option>

<option value="Saudi Arabia">Saudi Arabia</option>

<option value="Scotland">Scotland</option>

<option value="Senegal">Senegal</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="South Korea">South Korea</option>

<option value="Spain">Spain</option>

<option value="Sri Lanka">Sri Lanka</option>

<option value="St. Helena">St. Helena</option>

<option value="St. Pierre and Miquelon">St. Pierre and Miquelon</option>

<option value="Suriname">Suriname</option>

<option value="Swaziland">Swaziland</option>

<option value="Sweden">Sweden</option>

<option value="Switzerland">Switzerland</option>

<option value="Taiwan">Taiwan</option>

<option value="Tajikistan">Tajikistan</option>

<option value="Tanzania">Tanzania</option>

<option value="Thailand">Thailand</option>

<option value="Tokelau">Tokelau</option>

<option value="Tonga">Tonga</option>

<option value="Trinidad">Trinidad</option>

<option value="Trinidad ">Trinidad </option>

<option value="Tunisia">Tunisia</option>

<option value="Turkey">Turkey</option>

<option value="Turkmenistan">Turkmenistan</option>

<option value="Turks Islands">Turks Islands</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="Uruguay">Uruguay</option>

<option value="Uzbekistan">Uzbekistan</option>

<option value="Vanuatu">Vanuatu</option>

<option value="Venezuela">Venezuela</option>

<option value="Virgin Islands">Virgin Islands </option>

<option value="Wales">Wales</option>

<option value="Yemen">Yemen</option>

<option value="Zambia">Zambia</option>

<option value="Zimbabwe">Zimbabwe</option>

</select>

</label></td>

</tr>

<tr>

<td>* Are you a U.S. citizen or perm. resident?</td>

yes

no</label></td>

</tr>

<tr>

<td>* What's your highest level of education?</td>

<option selected="selected">- Select One -</option>

<option>Associates</option>

<option>Bachelors</option>

<option>Masters</option>

<option>Some College</option>

<option>High School or GED</option>

<option>No High School or GED</option>

</select>

</label></td>

</tr>

<tr>

<td>* Are you in the military or a veteran?</td>

yes

no</td>

</tr>

<tr>

<td>* Do you want classes online or campus?</td>

online

campus </label></td>

</tr>

<tr>

<td>*

<label>

</label>

<label>

I read and agree to the <a href="privacy.php">privacy policy</a>.</label>

</td>

</tr>

</table>

</div>

</form>

this the script in php:

<?php

$con = mysql_connect("my_host", "my_user", "my_pass");

mysql_select_db(my_database,$con);

$program=mysql_real_escape_string($_POST['program']);

$degree=mysql_real_escape_string($_POST['degree']);

$name_first=mysql_real_escape_string($_POST['name_first']);

$name_last=mysql_real_escape_string($_POST['name_last']);

$email==mysql_real_escape_string($_POST['email']);

$phone_1=mysql_real_escape_string($_POST['phone_1']);

$phone_2=mysql_real_escape_string($_POST['phone_2']);

$address_1=mysql_real_escape_string($_POST['address_1']);

$address_2=mysql_real_escape_string($_POST['adress_2]']);

$city=mysql_real_escape_string($_POST['city']);

$state=mysql_real_escape_string($_POST['state']);

$zip_code=mysql_real_escape_string($_POST['zip_code']);

$country=mysql_real_escape_string($_POST['country']);

$us_citizen=mysql_real_escape_string($_POST['us_citizen']);

$education_prior=mysql_real_escape_string($_POST['education_prior']);

$us_military=mysql_real_escape_string($_POST['us_military']);

$campus_type=mysql_real_escape_string($_POST['campus_type']);

$privacy_policy=mysql_real_escape_string($_POST['privacy_policy']);

mysql_query("INSERT INTO studentinfo (ID, program, degree, name_first, name_last, phone_1, phone_2, address_1, address_2, city, state, zipcode, country, us_citizen, education_prior,us_military, campus_type,privacy_policy);$studentinfo'(ID, program, degree, name_first, name_last, phone_1, phone_2, addres_1, address_2, city, state, zipcode, country, us_citizen, education_prior,us_military, campus_type,privacy_policy)VALUES('$program','$degree','$name_first','$_name_last','$email','phone_1','phone_2','$address_1','$address_2','$city','$state','$zip_code','$country','$us_citizen', '$education_prior','$campus_type','$privacy_policy')");

if (!mysql_query($sql,$con)) {

die('Error: ' . mysql_error());

}

echo "The form data was successfully added to your database.";

mysql_close($con);

?>

PFMaBiSmAd · August 31, 2009

You have two different mysql_query() statements in the posted code. The first one does have an SQL statement in it (which is likely failing due to a problem in the SQL), but the second msyql_query() statement is in the following line of code and the variable $sql does not exist in the code, resulting in an empty query error -

if (!mysql_query($sql,$con)) {

Please learn php, develop php code, and debug php code on a system with error_reporting set to E_ALL and display_errors set to ON in your php.ini to get php to help you. There would have been an error concerning the nonexistant $sql variable that might have helped you figure out why your code is producing the error you did get. Stop and start your web server to get any change made to php.ini and confirm the actual values using a phpinfo(); statement.

Sign In

Error No query found - Help with scripting for php form into mysql database

Recommended Posts

edegreeadvisor

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information