On 6/2/07, kvigor <[EMAIL PROTECTED]> 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
