Cant set info in DB...HELP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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============================ 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux