On 6/2/07, kvigor <k3cheese@xxxxxxxxxxxxx> wrote:
Hello,
I'm using phpMyAdmin and I can't get any of my form data into the database.
It returns message: "MySQL returned an empty result set" w/in phpMyAdmin
GUI.
However I get no errors on screen when form info is submitted.
What I have done to solve issue: drop DB and create new.
Review form vars and SQL statements can't find errors...help
Please help...
//=====================FORM======================================
<?php
echo "<div> <link href='css/SOS.css' rel='stylesheet' type='text/css' />
<form id='form1' method='post' action=''>
<label for='select'></label>
<label for='conName'><span
class='style2'>Consumer Information</span><br />
<br />
*Name:</label>
<input type='text' name='conName' id='formPosition' size='100'
class='nameAddressCity_pos' value='{$_POST['conName']}'/>
<br />
<br />
<label for='conAddress'>*Address:</label>
<input name='conAddress' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['conAddress']}' size='100' />
<br />
<br />
<label for='conCity'>*City:</label>
<input name='conCity' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['conCity']}' />
<label for='conState' class='stateLabel'>
*State:</label>
<input name='conState' type='text' class='state' id='textfield'
value='{$_POST['conState']}' />
<label for='conZip'
class='zipLabel'>*Zip:</label>
<input name='conZip' type='text' class='zip' id='textfield'
value='{$_POST['conZip']}' />
<br />
<br />
<label for='conPhone'>*Phone:</label>
<input name='conPhone' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['conPhone']}' />
<br />
<br />
<br />
<span class='style2'>School Nomination
Information </span><br />
<br />
<label for='schName'>*Name:</label>
<input name='schName' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['schName']}' size='100' />
<br />
<br />
<label for='schAddress'>*Address:</label>
<input name='schAddress' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['schAddress']}' size='100' />
<br />
<br />
<label for='schCity'>*City:</label>
<input name='schCity' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['schCity']}' />
<label for='schState'
class='stateLabel'>*State:</label>
<input name='schState' type='text' class='state' id='textfield'
value='{$_POST['schState']}'/>
<label for='schZip'
class='zipLabel'>*Zip:</label>
<input name='schZip' type='text' class='zip' id='textfield'
value='{$_POST['schZip']}' />
<br />
<br />
<span class='style2'><br />
Store Shopped At<br />
<br />
</span>
<label for='strName'>*Name:</label>
<input name='strName' type='text' class='nameAddressCity_pos'
id='textfield' value='{$_POST['strName']}' size='100'/>
<br />
<br />
<br />
<label for='strCity'>*City:</label>
<input name='strCity' type='text'class='nameAddressCity_pos'
id='textfield' value='{$_POST['strCity']}' />
<label for='strStat'
class='stateLabel'>*State:</label>
<input name='strState' type='text' class='state' id='textfield'
value='{$_POST['strState']}' />
<br />
<br />
<br />
<label for='Reset'></label>
<input type='reset' name='reset' value='Reset' id='Submit'/>
<label for='Sumbit'></label>
<input type='submit' name='submit' value='Submit' id='Reset'/>
</form></div>";
//====================END==FORM================================================
echo" <br /><br /><br /><br /><br /><br />";
//===============================striptags=and=trim===================================
$regName = trim(strip_tags($_POST['conName'])); $regAddress
= trim(strip_tags($_POST['conAddress']));
$regCity = trim(strip_tags($_POST['conCity'])); $regState =
trim(strip_tags($_POST['conState']));
$regZip = trim(strip_tags($_POST['conZip'])); $regPhone =
trim(strip_tags($_POST['conPhone']));
$sclName = trim(strip_tags($_POST['schName'])); $sclAddress
= trim(strip_tags($_POST['schAddress']));
$sclCity = trim(strip_tags($_POST['schCity'])); $sclState =
trim(strip_tags($_POST['schState']));
$sclZip = trim(strip_tags($_POST['schZip']));
$stoName = trim(strip_tags($_POST['strName'])); $stoCity =
trim(strip_tags($_POST['strCity']));
$stoState = trim(strip_tags($_POST['strState']));
//==============================end=striptags=and=trim===================================
//==============================Begin dbPopulation of Form
data============================
$dbserver = "localhost";
$dbuser = "root";
$dbpassword = "";
$dbname = "theDB";
$connection = mysqli_connect($dbserver, $dbuser, $dbpassword, $dbname) or
die
("Could not connect to the Server. Contact your Network Administrator or
your Web
Programmer");
$insert_query = "INSERT INTO contestants (conName, conAddress, conCity,
conState,
conZip, conPhone, schName, schAddress, schCity, schState, schZip, strName,
strCity,
strState) VALUES('$regName', '$regAddress', '$regCity', '$regState',
'$regZip',
'$regPhone', '$sclName', '$sclName', '$sclCity', '$sclState', '$sclZip',
'$stoName',
'$stoCity', '$stoState')";
mysqli_query($connection,$insert_query); ?>
//==============================End dbPopulation of Form
data============================
Try to add a die() to the mysqli_query, like this:
mysqli_query($connection,$insert_query) or die(mysqli_error($connection));
This will probably tell you that there's an error in your SQL code...
Tijnema
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
