Jump to content

[SOLVED] Blank feilds in Mysql database

RCS

By RCS
in PHP Coding Help

 Share

Recommended Posts

RCS Member

RCS

Posted
Posted

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);

Link to comment
Share on other sites
RCS Member

RCS

Posted
  • Author
Posted

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>

Link to comment
Share on other sites
BlueSkyIS Newbie

BlueSkyIS

Posted
Posted

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]}')";

Link to comment
Share on other sites
RCS Member

RCS

Posted
  • Author
Posted

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.

Link to comment
Share on other sites
teng84 Member

teng84

Posted
Posted 

<?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 ....

Link to comment
Share on other sites
RCS Member

RCS

Posted
  • Author
Posted

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.

Link to comment
Share on other sites
teng84 Member

teng84

Posted
Posted 

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

Link to comment
Share on other sites
teng84 Member

teng84

Posted
Posted

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

Link to comment
Share on other sites
RCS Member

RCS

Posted
  • Author
Posted

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.

 

 

Link to comment
Share on other sites
teng84 Member

teng84

Posted
Posted

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 

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.