[SOLVED] Blank feilds in Mysql database

RCS · May 7, 2008

I have two drop down menus in my form and when I submit them to my database I just get blank fields

This is how I tried to write the code, can someone tell me what I'm doing wrong???

Thanks in advance.

include($_SERVER["DOCUMENT_ROOT"]."/include/dbinfo.inc");
$con = mysql_connect($db_host, $db_user, $db_pass) or die ("Could not make connection to database.");
mysql_select_db($db_name) or die ("Unable to select database!");
if(isset($_POST['submit'])){
$state= mysql_real_escape_string($_POST['select']);
$country= mysql_real_escape_string($_POST['select']);
$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) VALUES ('$_POST[firstName]','$_POST[lastName]','$_POST[email]','$_POST[address]', '$_POST[city]', '$_POST[$state]', '$_POST[other]', '$_POST[$country]', '$_POST[phone]', '$_POST[userName]', '$_POST[password]')";
$result = @mysql_query($query);
if($result){
  echo "Account creation Successfull<br />";
  } else {
  die ("Error in query: $query. " . mysql_error()."<br />");
  }
  }
mysql_close($con);

DarkWater · May 7, 2008

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

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

Name them two different things...Not the same name. >_>

BlueSkyIS · May 7, 2008

you need to curly-bracket all of your arrays in a double-quoted string:

VALUES ('{$_POST['firstName']}','{$_POST['lastName']}',

etc...

RCS · May 7, 2008

NOT sure what you mean, I can't see how else I would do it??

this is my form

<form id="register" name="register" method="POST" action="register.php">
      <table width="511" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="184" height="41" bgcolor="#666666"> </td>
          <td width="144" bgcolor="#666666"><div align="center"><span class="style1">USER REGISTRATION</span></div></td>
          <td width="183" bgcolor="#666666"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> First Name:</div></td>
          <td bgcolor="#CCCCCC"><input name="firstName" type="text" id="firstName" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"></div></td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">* </span>Last Name</div></td>
          <td bgcolor="#CCCCCC"><input name="lastName" type="text" id="lastName" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">* </span>E-Mail:</div></td>
          <td bgcolor="#CCCCCC"><input name="email" type="text" id="email" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> Confirm E-Mail:</div></td>
          <td bgcolor="#CCCCCC"><input name="confirmEmail" type="text" id="confirmEmail" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> Home Address:</div></td>
          <td bgcolor="#CCCCCC"><input name="address" type="text" id="address" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"></div></td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> Zip/Postal Code:</div></td>
          <td bgcolor="#CCCCCC"><input name="zip" type="text" id="zip" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> City:</div></td>
          <td bgcolor="#CCCCCC"><input name="city" type="text" id="city" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> State/Province:</div></td>
          <td bgcolor="#CCCCCC"><select name="state" id="state">
          <option value="-1" selected="selected">-- State/Province --</option>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AB">Alberta</option>
<option value="AZ">Arizona</option>
<option value="AR">Arkansas</option>
<option value="BC">British Columbia</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DE">Delaware</option>
<option value="DC">District of Columbia</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="IA">Iowa</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="ME">Maine</option>
<option value="MB">Manitoba</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>
<option value="NV">Nevada</option>
<option value="NB">New Brunswick</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NY">New York</option>
<option value="NF">Newfoundland and Labrador</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="NT">Northwest Territories</option>
<option value="NS">Nova Scotia</option>
<option value="NU">Nunavut</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="ON">Ontario</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="PE">Prince Edward Island</option>
<option value="QC">Quebec</option>
<option value="RI">Rhode Island</option>
<option value="SK">Saskatchewan</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>
<option value="VA">Virginia</option>
<option value="WA">Washington</option>
<option value="WV">West Virginia</option>
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
<option value="YT">Yukon Territory</option>
          </select>          </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right">Other:</div></td>
          <td bgcolor="#CCCCCC"><input name="other" type="text" id="other" size="34" maxlength="3" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"></div></td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> Country:</div></td>
          <td bgcolor="#CCCCCC"><select name="counrty" id="counrty">
            <option value="" selected="selected">Select Your Country</option>
            <option value="211">UNITED STATES OF AMERICA</option>
            <option value="210">UNITED KINGDOM (Incl. N. Ireland)</option>
            <option value="76">GERMANY</option>
            <option value="70">FRANCE</option>
            <option value="100">JAPAN</option>
            <option value="1">AFGHANISTAN</option>
            <option value="2">ALBANIA</option>
            <option value="3">ALGERIA</option>
            <option value="4">ANDORRA</option>
            <option value="5">ANGOLA</option>
            <option value="6">ANGUILLA</option>
            <option value="7">ANTIGUA & BARBUDA</option>
            <option value="8">ARGENTINA</option>
            <option value="9">ARMENIA</option>
            <option value="10">ARUBA</option>
            <option value="11">AUSTRALIA</option>
            <option value="12">AUSTRIA</option>
            <option value="13">AZERBAIJAN</option>
            <option value="14">BAHAMAS</option>
            <option value="15">BAHRAIN</option>
            <option value="16">BANGLADESH</option>
            <option value="17">BARBADOS</option>
            <option value="18">BELARUS</option>
            <option value="19">BELGIUM</option>
            <option value="20">BELIZE</option>
            <option value="21">BENIN</option>
            <option value="22">BERMUDA</option>
            <option value="23">BHUTAN</option>
            <option value="24">BOLIVIA</option>
            <option value="25">BOSNIA-HERCEGOVINA</option>
            <option value="26">BOTSWANA</option>
            <option value="27">BRAZIL</option>
            <option value="28">BRITISH INDIAN OCEAN TERRITORY</option>
            <option value="29">BRITISH VIRGIN ISLANDS</option>
            <option value="30">BRUNEI</option>
            <option value="31">BULGARIA</option>
            <option value="32">BURKINA FASO</option>
            <option value="33">BURUNDI</option>
            <option value="34">CAMBODIA</option>
            <option value="35">CAMEROON</option>
            <option value="36">CANADA</option>
            <option value="37">CAPE VERDE</option>
            <option value="38">CAYMAN ISLANDS</option>
            <option value="39">CENTRAL AFRICAN REPUBLIC</option>
            <option value="40">CHAD</option>
            <option value="41">CHILE</option>
            <option value="42">CHINA (MAINLAND)</option>
            <option value="44">CHRISTMAS ISLAND (INDIAN OCEAN)</option>
            <option value="45">COCOS (KEELING) ISLANDS</option>
            <option value="46">COLOMBIA</option>
            <option value="47">COMOROS</option>
            <option value="48">CONGO</option>
            <option value="49">COOK ISLANDS</option>
            <option value="50">COSTA RICA</option>
            <option value="51">CROATIA</option>
            <option value="52">CYPRUS</option>
            <option value="53">CZECH REPUBLIC</option>
            <option value="54">DENMARK</option>
            <option value="55">DJIBOUTI</option>
            <option value="56">DOMINICA</option>
            <option value="57">DOMINICAN REPUBLIC</option>
            <option value="58">ECUADOR</option>
            <option value="59">EGYPT</option>
            <option value="60">EL SALVADOR</option>
            <option value="61">EQUATORIAL GUINEA</option>
            <option value="62">ERITREA</option>
            <option value="63">ESTONIA</option>
            <option value="64">ETHIOPIA</option>
            <option value="65">FALKLAND ISLANDS</option>
            <option value="66">FAROE ISLANDS</option>
            <option value="67">FIJI</option>
            <option value="68">FINLAND</option>
            <option value="69">FR SOUTHERN & ANTARTIC LANDS</option>
            <option value="71">FRENCH GUIANA</option>
            <option value="72">FRENCH POLYNESIA</option>
            <option value="73">GABON</option>
            <option value="74">GAZA STRIP</option>
            <option value="75">GEORGIA</option>
            <option value="77">GHANA</option>
            <option value="78">GIBRALTAR</option>
            <option value="79">GREECE</option>
            <option value="80">GREENLAND</option>
            <option value="81">GRENADA</option>
            <option value="82">GUADELOUPE</option>
            <option value="83">GUATEMALA</option>
            <option value="84">GUINEA</option>
            <option value="85">GUINEA-BISSAU</option>
            <option value="86">GUYANA</option>
            <option value="87">HAITI</option>
            <option value="88">HEARD AND MCDONALD ISLANDS</option>
            <option value="89">HONDURAS</option>
            <option value="90">HONG KONG</option>
            <option value="91">HUNGARY</option>
            <option value="92">ICELAND</option>
            <option value="93">INDIA</option>
            <option value="94">INDONESIA</option>
            <option value="96">ISRAEL</option>
            <option value="97">ITALY</option>
            <option value="98">IVORY COAST</option>
            <option value="99">JAMAICA</option>
            <option value="101">JORDAN</option>
            <option value="102">KAZAKHSTAN</option>
            <option value="103">KENYA</option>
            <option value="104">KIRIBATI</option>
            <option value="105">KUWAIT</option>
            <option value="106">KYRGYZSTAN</option>
            <option value="107">LAOS</option>
            <option value="108">LATVIA</option>
            <option value="109">LEBANON</option>
            <option value="110">LESOTHO</option>
            <option value="111">LIBERIA</option>
            <option value="112">LIECHTENSTEIN</option>
            <option value="113">LITHUANIA</option>
            <option value="114">LUXEMBOURG</option>
            <option value="115">MACAO (MACAU)</option>
            <option value="116">MACEDONIA (SKOPJE)</option>
            <option value="117">MADAGASCAR (MALAGASY)</option>
            <option value="118">MALAWI</option>
            <option value="119">MALAYSIA</option>
            <option value="120">MALDIVES</option>
            <option value="121">MALI</option>
            <option value="122">MALTA AND GOZO</option>
            <option value="123">MARSHALL ISLANDS</option>
            <option value="124">MARTINIQUE</option>
            <option value="125">MAURITANIA</option>
            <option value="126">MAURITIUS</option>
            <option value="127">MEXICO</option>
            <option value="128">MICRONESIA, FEDERATED STATES</option>
            <option value="129">MOLDOVA</option>
            <option value="130">MONACO</option>
            <option value="131">MONGOLIA</option>
            <option value="132">MONTENEGRO</option>
            <option value="133">MONTSERRAT</option>
            <option value="134">MOROCCO</option>
            <option value="135">MOZAMBIQUE</option>
            <option value="136">MYANMAR (BURMA)</option>
            <option value="137">NAMIBIA</option>
            <option value="138">NAURU</option>
            <option value="139">NEPAL</option>
            <option value="140">NETHERLANDS</option>
            <option value="141">NETHERLANDS ANTILLES</option>
            <option value="142">NEW CALEDONIA</option>
            <option value="143">NEW ZEALAND</option>
            <option value="144">NICARAGUA</option>
            <option value="145">NIGER</option>
            <option value="146">NIGERIA</option>
            <option value="147">NIUE</option>
            <option value="148">NORFOLK ISLAND</option>
            <option value="149">NORTH KOREA</option>
            <option value="150">NORWAY</option>
            <option value="151">OMAN</option>
            <option value="152">PAKISTAN</option>
            <option value="153">PALAU</option>
            <option value="154">PANAMA</option>
            <option value="155">PAPUA NEW GUINEA</option>
            <option value="156">PARAGUAY</option>
            <option value="157">PERU</option>
            <option value="158">PHILIPPINES</option>
            <option value="159">PITCAIRN ISLAND</option>
            <option value="160">POLAND</option>
            <option value="161">PORTUGAL</option>
            <option value="162">PUERTO RICO</option>
            <option value="163">QATAR</option>
            <option value="95">REPUBLIC OF IRELAND</option>
            <option value="165">REUNION (ISLAND, FRENCH)</option>
            <option value="166">ROMANIA</option>
            <option value="167">RUSSIA</option>
            <option value="168">RWANDA</option>
            <option value="169">SAN MARINO</option>
            <option value="170">SAO TOME AND PRINCIPE</option>
            <option value="171">SAUDI ARABIA</option>
            <option value="172">SENEGAL</option>
            <option value="173">SERBIA</option>
            <option value="174">SEYCHELLES</option>
            <option value="175">SIERRA LEONE</option>
            <option value="176">SINGAPORE</option>
            <option value="177">SLOVAKIA</option>
            <option value="178">SLOVENIA</option>
            <option value="179">SOLOMON ISLANDS</option>
            <option value="180">SOMALIA</option>
            <option value="164">SOUTH AFRICA, REPUBLIC OF</option>
            <option value="181">SOUTH KOREA</option>
            <option value="182">SPAIN</option>
            <option value="183">SRI LANKA</option>
            <option value="184">ST CHRISTOPHER-NEVIS</option>
            <option value="185">ST HELENA</option>
            <option value="186">ST LUCIA</option>
            <option value="187">ST PIERRE AND MIQUELON</option>
            <option value="188">ST VINCENT AND THE GRENADINE</option>
            <option value="189">SURINAME</option>
            <option value="190">SVALBARD AND JAN MAYEN ISLAND</option>
            <option value="191">SWAZILAND</option>
            <option value="192">SWEDEN</option>
            <option value="193">SWITZERLAND</option>
            <option value="43">TAIWAN</option>
            <option value="194">TAJIKISTAN</option>
            <option value="195">TANZANIA</option>
            <option value="196">THAILAND</option>
            <option value="197">THE GAMBIA</option>
            <option value="198">TOGO</option>
            <option value="199">TOKELAU ISLANDS</option>
            <option value="200">TONGA</option>
            <option value="201">TRINIDAD AND TOBAGO</option>
            <option value="202">TUNISIA</option>
            <option value="203">TURKEY</option>
            <option value="204">TURKMENISTAN</option>
            <option value="205">TURKS AND CAICOS ISLANDS</option>
            <option value="206">TUVALU</option>
            <option value="207">UGANDA</option>
            <option value="208">UKRAINE</option>
            <option value="209">UNITED ARAB EMPIRATES</option>
            <option value="212">URUGUAY</option>
            <option value="213">UZBEKISTAN</option>
            <option value="214">VANUATU</option>
            <option value="215">VATICAN CITY</option>
            <option value="216">VENEZUELA</option>
            <option value="217">VIETNAM</option>
            <option value="218">VIRGIN ISLAND OF THE US</option>
            <option value="219">WALLIS AND FUTUNA</option>
            <option value="220">WEST BANK</option>
            <option value="221">WESTERN SAHARA</option>
            <option value="222">WESTERN SAMOA</option>
            <option value="223">YEMEN (SANA)</option>
            <option value="224">YUGOSLAVIA</option>
            <option value="225">ZAIRE</option>
            <option value="226">ZAMBIA</option>
            <option value="227">ZIMBABWE</option>
            <option value="0">Other</option>
          </select></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> Phone:</div></td>
          <td bgcolor="#CCCCCC"><input name="phone" type="text" id="phone" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> UserName:</div></td>
          <td bgcolor="#CCCCCC"><input name="userName" type="text" id="userName" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"> <span class="style3">*</span> Password:</div></td>
          <td bgcolor="#CCCCCC"><input name="password" type="password" id="password" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"></div></td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"><div align="right"><span class="style3">*</span> Confirm Password:</div></td>
          <td bgcolor="#CCCCCC"><input name="confirmPassword" type="password" id="confirmPassword" size="34" maxlength="34" /></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"><div align="center">
            <input type="submit" name="submit" id="submit" value="Submit" />
          </div></td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
          <td bgcolor="#CCCCCC"> </td>
        </tr>
        <tr>
          <td height="43" bgcolor="#666666"> </td>
          <td bgcolor="#666666"> </td>
          <td bgcolor="#666666"> </td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
          <td> </td>
        </tr>
      </table>
        </form>

DarkWater · May 7, 2008

Oh, you DO have it named differently. Dude, it's:

$_POST['state'] and $_POST['country']. Run mysql_real_escape_string on those and then try the query.

BlueSkyIS · May 7, 2008

you need to curly-bracket all of your arrays in a double-quoted string.

instead of this:

$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) VALUES ('$_POST[firstName]','$_POST[lastName]','$_POST[email]','$_POST[address]', '$_POST[city]', '$_POST[$state]', '$_POST[other]', '$_POST[$country]', '$_POST[phone]', '$_POST[userName]', '$_POST[password]')";

add curly brackets

$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) VALUES ('{$_POST[firstName]}','{$_POST[lastName]}','{$_POST[email]}','{$_POST[address]}', '{$_POST[city]}', '{$_POST[$state]}', '{$_POST[other]}', '{$_POST[$country]}', '{$_POST[phone]}', '{$_POST[userName]}', '{$_POST[password]}')";

RCS · May 7, 2008

not sure what you mean??

like this??

<?php

/**
* @author 
* @copyright 2008
*/
include($_SERVER["DOCUMENT_ROOT"]."/include/dbinfo.inc");
$con = mysql_connect($db_host, $db_user, $db_pass) or die ("Could not make connection to database.");
mysql_select_db($db_name) or die ("Unable to select database!");
if(isset($_POST['submit'])){
$state= mysql_real_escape_string($_POST['state']);
$country= mysql_real_escape_string($_POST['country']);
$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) VALUES ('$_POST[firstName]','$_POST[lastName]','$_POST[email]','$_POST[address]', '$_POST[city]', '$_POST[$state]', '$_POST[other]', '$_POST[$country]', '$_POST[phone]', '$_POST[userName]', '$_POST[password]')";
$result = @mysql_query($query);
if($result){
  echo "Account creation Successfull<br />";
  } else {
  die ("Error in query: $query. " . mysql_error()."<br />");
  }
  }
mysql_close($con);
?>

I tried like this and it's not working, still showing up blank.

DarkWater · May 7, 2008

I see why I think. Change:

$result = @mysql_query($query);

To:

$result = mysql_query($query) OR die(mysql_error());

Show us the error that you most definitely will have (I see it in your script).

RCS · May 7, 2008

no error message

RCS · May 7, 2008

can you not use mysql_real_escape_string twice in same script??

It just does not make sense why this will not work the code look right to me.

teng84 · May 7, 2008

<?php

/**
* @author 
* @copyright 2008
*/
include($_SERVER["DOCUMENT_ROOT"]."/include/dbinfo.inc");
$con = mysql_connect($db_host, $db_user, $db_pass) or die ("Could not make connection to database.");
mysql_select_db($db_name) or die ("Unable to select database!");
if(isset($_POST['submit'])){
$state= mysql_real_escape_string($_POST['state']);
$country= mysql_real_escape_string($_POST['country']);
$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) 
	VALUES (
	'{$_POST['firstName']}',
	'{$_POST['lastName]'}',
	'{$_POST['email]'}',
	'{$_POST['address']}', 
	'{$_POST['city]'}', 
	'{$state}',
	'{$_POST['other']}', 
	'{$country}', 
	'{$_POST['phone']}', 
	'{$_POST['userName']}', 
	'{$_POST['password]'}')";
$result = mysql_query($query) or die(mysql_error());
if($result){
  echo "Account creation Successfull<br />";
  } else {
  die ("Error in query: $query. " . mysql_error()."<br />");
  }
  }
mysql_close($con);
?>

try ....

RCS · May 7, 2008

ok I tried this code

<?php

/**
* @author 
* @copyright 2008
*/
include($_SERVER["DOCUMENT_ROOT"]."/include/dbinfo.inc");
$con = mysql_connect($db_host, $db_user, $db_pass) or die ("Could not make connection to database.");
mysql_select_db($db_name) or die ("Unable to select database!");
if(isset($_POST['submit'])){
$state= mysql_real_escape_string($_POST['state']);
$country= mysql_real_escape_string($_POST['country']);
$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) 
	VALUES (
	'{$_POST['firstName']}',
	'{$_POST['lastName']}',
	'{$_POST['email']}',
	'{$_POST['address']}', 
	'{$_POST['city']}', 
	'{$state}',
	'{$_POST['other']}', 
	'{$country}', 
	'{$_POST['phone']}', 
	'{$_POST['userName']}', 
	'{$_POST['password']}')";
$result = mysql_query($query) or die(mysql_error());
if($result){
  echo "Account creation Successfull<br />";
  } else {
  die ("Error in query: $query. " . mysql_error()."<br />");
  }
  }
mysql_close($con);
?>

and under state it shows only first two characters of my selection and under country still shows up blank in database.

teng84 · May 7, 2008

<?php

/**
* @author 
* @copyright 2008
*/
include($_SERVER["DOCUMENT_ROOT"]."/include/dbinfo.inc");
$con = mysql_connect($db_host, $db_user, $db_pass) or die ("Could not make connection to database.");
mysql_select_db($db_name) or die ("Unable to select database!");
if(isset($_POST['submit'])){
$state= mysql_real_escape_string($_POST['state']);
$country= mysql_real_escape_string($_POST['country']);
$query = "INSERT INTO user (firstName, lastName, email, address, city, state, other, country, phone, userName, password) 
	VALUES (
	'{$_POST['firstName']}',
	'{$_POST['lastName]'}',
	'{$_POST['email]'}',
	'{$_POST['address']}', 
	'{$_POST['city]'}', 
	'{$state}',
	'{$_POST['other']}', 
	'{$country}', 
	'{$_POST['phone']}', 
	'{$_POST['userName']}', 
	'{$_POST['password]'}')";

	echo $query;

$result = mysql_query($query) or die(mysql_error());
if($result){
  echo "Account creation Successfull<br />";
  } else {
  die ("Error in query: $query. " . mysql_error()."<br />");
  }
  }
mysql_close($con);
?>

try that and tell us what happen ..paste here the result

RCS · May 7, 2008

'{$_POST['password]'}')";

I get crazy errors should it not be like '{$_POST['password']}')";

RCS · May 7, 2008

state it shows only first two characters of my selection and under country still shows up blank in database.

teng84 · May 7, 2008

no... i tried to echo your query.. paste that here and on your previous post sorry about that typo error.

I want to see the result of your query thats is why i echo that so please try to paste that here

RCS · May 7, 2008

I'm not getting errors, everything goes to database but state it shows only first two characters of my selection and under country still shows up blank in database. thats the only issue.

I get Account creation Successfull with no errors.

teng84 · May 7, 2008

maybe your drop down values only has 2 characters or your field length in your db only accept two characters

on your country check if you really have the value before inserting in your db or try to hard code the value to see where the error lies

RCS · May 8, 2008

lol thanks for the input, I had some spelling errors.

also you are right the way I set it up was two characters for state.

lmao, thanks for the help I feel like a fool =)

RCS · May 8, 2008

I'm also getting blank feild for zip, not sure what is going on here

Sign In

[SOLVED] Blank feilds in Mysql database

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived

Important Information