Databases
StackOverflow2013
Postsdbo
POMy php script does not work as it should
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMy php script does not work as it should
    primarykey
    data
    text
    <p>Hey everyone, I'm what you call "Thick". And I'm trying to create a PHP register page. I seem to have got it to do something but it doesn't seem to register the information in to MY SQL PHPmyAdmin. For example: It states once you have filled out the form, that the information has been registered, but there's nothing in the DB, I was wondering if someone could give me a hand and see what it is I'm doing wrong.</p> <p>I am new to website building, but I've been at it now for a year or so, and I'm now trying to put my proper site together. But I'm totally stuck on this part. If anyone could help... I would really appreciate it. Here are my codes.</p> <p>FORM</p> <pre><code>&lt;form action="##########" name="########" id="###########" method="POST"&gt; &lt;table border="0" width="625" align="left" cellpadding="15" cellspacing="0" bgcolor="#000000"&gt; &lt;tr&gt; &lt;td class="text4" align="right"&gt; Nickname: &lt;/td&gt; &lt;td&gt; &lt;div id='################' class="error_strings"&gt;&lt;/div&gt; &lt;input type="text" name="nickname" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="text4" align="right"&gt; E-mail: &lt;/td&gt; &lt;td&gt; &lt;div id='###############' class="error_strings"&gt;&lt;/div&gt; &lt;input type="text" name="email" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="text4" align="right"&gt; Password: &lt;/td&gt; &lt;td&gt; &lt;div id='###############' class="error_strings"&gt;&lt;/div&gt; &lt;input type="password" name="password" /&gt; &lt;/td&gt; &lt;tr&gt; &lt;td class="text4" align="right"&gt; Date of birth: &lt;/td&gt; &lt;td&gt; &lt;inputtype="hidden" name="date_of_bith"&gt; &lt;select name="bday"&gt; &lt;option value="1"&gt;1&lt;/option&gt; &lt;option value="2"&gt;2&lt;/option&gt; &lt;option value="3"&gt;3&lt;/option&gt; &lt;option value="4"&gt;4&lt;/option&gt; &lt;option value="5"&gt;5&lt;/option&gt; &lt;option value="6"&gt;6&lt;/option&gt; &lt;option value="7"&gt;7&lt;/option&gt; &lt;option value="8"&gt;8&lt;/option&gt; &lt;option value="9"&gt;9&lt;/option&gt; &lt;option value="10"&gt;10&lt;/option&gt; &lt;option value="11"&gt;11&lt;/option&gt; &lt;option value="12"&gt;12&lt;/option&gt; &lt;option value="13"&gt;13&lt;/option&gt; &lt;option value="14"&gt;14&lt;/option&gt; &lt;option value="15"&gt;15&lt;/option&gt; &lt;option value="16"&gt;16&lt;/option&gt; &lt;option value="17"&gt;17&lt;/option&gt; &lt;option value="18"&gt;18&lt;/option&gt; &lt;option value="19"&gt;19&lt;/option&gt; &lt;option value="20"&gt;20&lt;/option&gt; &lt;option value="21"&gt;21&lt;/option&gt; &lt;option value="22"&gt;22&lt;/option&gt; &lt;option value="23"&gt;23&lt;/option&gt; &lt;option value="24"&gt;24&lt;/option&gt; &lt;option value="25"&gt;25&lt;/option&gt; &lt;option value="26"&gt;26&lt;/option&gt; &lt;option value="27"&gt;27&lt;/option&gt; &lt;option value="28"&gt;28&lt;/option&gt; &lt;option value="29"&gt;29&lt;/option&gt; &lt;option value="30"&gt;30&lt;/option&gt; &lt;option selected value="31"&gt;31&lt;/option&gt; &lt;/select&gt; &lt;select name="bmonth" &gt; &lt;option selected value="1"&gt;1&lt;/option&gt; &lt;option value=""&gt;&lt;/option&gt; &lt;option value="2"&gt;2&lt;/option&gt; &lt;option value="3"&gt;3&lt;/option&gt; &lt;option value="4"&gt;4&lt;/option&gt; &lt;option value="5"&gt;5&lt;/option&gt; &lt;option value="6"&gt;6&lt;/option&gt; &lt;option value="7"&gt;7&lt;/option&gt; &lt;option value="8"&gt;8&lt;/option&gt; &lt;option value="9"&gt;9&lt;/option&gt; &lt;option value="10"&gt;10&lt;/option&gt; &lt;option value="11"&gt;11&lt;/option&gt; &lt;option value="12"&gt;12&lt;/option&gt; &lt;/select&gt; &lt;select name="byear"&gt; &lt;option value="2005"&gt;Year&lt;/option&gt; &lt;option value="2004"&gt;2004&lt;/option&gt; &lt;option value="2003"&gt;2003&lt;/option&gt; &lt;option value="2002"&gt;2002&lt;/option&gt; &lt;option value="2001"&gt;2001&lt;/option&gt; &lt;option value="2000"&gt;2000&lt;/option&gt; &lt;option value="1999"&gt;1999&lt;/option&gt; &lt;option value="1998"&gt;1998&lt;/option&gt; &lt;option value="1997"&gt;1997&lt;/option&gt; &lt;option value="1996"&gt;1996&lt;/option&gt; &lt;option value="1995"&gt;1995&lt;/option&gt; &lt;option value="1994"&gt;1994&lt;/option&gt; &lt;option value="1993"&gt;1993&lt;/option&gt; &lt;option value="1992"&gt;1992&lt;/option&gt; &lt;option value="1991"&gt;1991&lt;/option&gt; &lt;option value="1990"&gt;1990&lt;/option&gt; &lt;option value="1989"&gt;1989&lt;/option&gt; &lt;option value="1988"&gt;1988&lt;/option&gt; &lt;option value="1987"&gt;1987&lt;/option&gt; &lt;option value="1986"&gt;1986&lt;/option&gt; &lt;option value="1985"&gt;1985&lt;/option&gt; &lt;option value="1984"&gt;1984&lt;/option&gt; &lt;option value="1983"&gt;1983&lt;/option&gt; &lt;option value="1982"&gt;1982&lt;/option&gt; &lt;option value="1981"&gt;1981&lt;/option&gt; &lt;option value="1980"&gt;1980&lt;/option&gt; &lt;option value="1979"&gt;1979&lt;/option&gt; &lt;option value="1978"&gt;1978&lt;/option&gt; &lt;option value="1977"&gt;1977&lt;/option&gt; &lt;option value="1976"&gt;1976&lt;/option&gt; &lt;option value="1975"&gt;1975&lt;/option&gt; &lt;option value="1974"&gt;1974&lt;/option&gt; &lt;option value="1973"&gt;1973&lt;/option&gt; &lt;option value="1972"&gt;1972&lt;/option&gt; &lt;option value="1971"&gt;1971&lt;/option&gt; &lt;option selected value="1970"&gt;1970&lt;/option&gt; &lt;option value="1969"&gt;1969&lt;/option&gt; &lt;option value="1968"&gt;1968&lt;/option&gt; &lt;option value="1967"&gt;1967&lt;/option&gt; &lt;option value="1966"&gt;1966&lt;/option&gt; &lt;option value="1965"&gt;1965&lt;/option&gt; &lt;option value="1964"&gt;1964&lt;/option&gt; &lt;option value="1963"&gt;1963&lt;/option&gt; &lt;option value="1962"&gt;1962&lt;/option&gt; &lt;option value="1961"&gt;1961&lt;/option&gt; &lt;option value="1960"&gt;1960&lt;/option&gt; &lt;option value="1959"&gt;1959&lt;/option&gt; &lt;option value="1958"&gt;1958&lt;/option&gt; &lt;option value="1957"&gt;1957&lt;/option&gt; &lt;option value="1956"&gt;1956&lt;/option&gt; &lt;option value="1955"&gt;1955&lt;/option&gt; &lt;option value="1954"&gt;1954&lt;/option&gt; &lt;option value="1953"&gt;1953&lt;/option&gt; &lt;option value="1952"&gt;1952&lt;/option&gt; &lt;option value="1951"&gt;1951&lt;/option&gt; &lt;option value="1950"&gt;1950&lt;/option&gt; &lt;option value="1949"&gt;1949&lt;/option&gt; &lt;option value="1948"&gt;1948&lt;/option&gt; &lt;option value="1947"&gt;1947&lt;/option&gt; &lt;option value="1946"&gt;1946&lt;/option&gt; &lt;option value="1945"&gt;1945&lt;/option&gt; &lt;option value="1944"&gt;1944&lt;/option&gt; &lt;option value="1943"&gt;1943&lt;/option&gt; &lt;option value="1942"&gt;1942&lt;/option&gt; &lt;option value="1941"&gt;1941&lt;/option&gt; &lt;option value="1940"&gt;1940&lt;/option&gt; &lt;option value="1939"&gt;1939&lt;/option&gt; &lt;option value="1938"&gt;1938&lt;/option&gt; &lt;option value="1937"&gt;1937&lt;/option&gt; &lt;option value="1936"&gt;1936&lt;/option&gt; &lt;option value="1935"&gt;1935&lt;/option&gt; &lt;option value="1934"&gt;1934&lt;/option&gt; &lt;option value="1933"&gt;1933&lt;/option&gt; &lt;option value="1932"&gt;1932&lt;/option&gt; &lt;option value="1931"&gt;1931&lt;/option&gt; &lt;option value="1930"&gt;1930&lt;/option&gt; &lt;option value="1929"&gt;1929&lt;/option&gt; &lt;option value="1928"&gt;1928&lt;/option&gt; &lt;option value="1927"&gt;1927&lt;/option&gt; &lt;option value="1926"&gt;1926&lt;/option&gt; &lt;option value="1925"&gt;1925&lt;/option&gt; &lt;option value="1924"&gt;1924&lt;/option&gt; &lt;option value="1923"&gt;1923&lt;/option&gt; &lt;option value="1922"&gt;1922&lt;/option&gt; &lt;option value="1921"&gt;1921&lt;/option&gt; &lt;option value="1920"&gt;1920&lt;/option&gt; &lt;option value="1919"&gt;1919&lt;/option&gt; &lt;option value="1918"&gt;1918&lt;/option&gt; &lt;option value="1917"&gt;1917&lt;/option&gt; &lt;option value="1916"&gt;1916&lt;/option&gt; &lt;option value="1915"&gt;1915&lt;/option&gt; &lt;option value="1914"&gt;1914&lt;/option&gt; &lt;option value="1913"&gt;1913&lt;/option&gt; &lt;option value="1912"&gt;1912&lt;/option&gt; &lt;option value="1911"&gt;1911&lt;/option&gt; &lt;option value="1910"&gt;1910&lt;/option&gt; &lt;option value="1909"&gt;1909&lt;/option&gt; &lt;option value="1908"&gt;1908&lt;/option&gt; &lt;option value="1907"&gt;1907&lt;/option&gt; &lt;option value="1906"&gt;1906&lt;/option&gt; &lt;option value="1905"&gt;1905&lt;/option&gt; &lt;option value="1904"&gt;1904&lt;/option&gt; &lt;option value="1903"&gt;1903&lt;/option&gt; &lt;option value="1902"&gt;1902&lt;/option&gt; &lt;option value="1901"&gt;1901&lt;/option&gt; &lt;option value="1900"&gt;1900&lt;/option&gt; &lt;/td&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="text4" align="right"&gt; Country: &lt;/td&gt; &lt;td&gt; &lt;div id='################' class="error_strings"&gt;&lt;/div&gt; &lt;align="left" valign="top"&gt; &lt;select name="country" value="000" select="select" class="INPUT"&gt; &lt;option value=""&gt;&lt;/option&gt; &lt;option value="3"&gt;Africa&lt;/option&gt; &lt;option value="1"&gt;Australia&lt;/option&gt; &lt;option value="2"&gt;Canada&lt;/option&gt; &lt;option value="3"&gt;China&lt;/option&gt; &lt;option value="3"&gt;European Union&lt;/option&gt; &lt;option value="3"&gt;Greenland&lt;/option&gt; &lt;option value="3"&gt;Iceland&lt;/option&gt; &lt;option value="3"&gt;Israel&lt;/option&gt; &lt;option value="3"&gt;Japan&lt;/option&gt; &lt;option value="3"&gt;New Zealand&lt;/option&gt; &lt;option value="3"&gt;Norway&lt;/option&gt; &lt;option value="3"&gt;Russia&lt;/option&gt; &lt;option value="3"&gt;South America&lt;/option&gt; &lt;option value="3"&gt;Thailand&lt;/option&gt; &lt;option value="3"&gt;Turkey&lt;/option&gt; &lt;option value="3"&gt;Switzerland&lt;/option&gt; &lt;option value="3"&gt;United States of America&lt;/option&gt; &lt;option value="3"&gt;Other&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="text4" align="right"&gt; Terms and conditions: &lt;/td&gt; &lt;td&gt; &lt;div id='##############' class="error_strings"&gt;&lt;/div&gt; &lt;input type='checkbox' name='features[]' id='features_item_0' value='terms'/&gt;&lt;label for='features_item_0'class="text4"&gt; I agree &lt;/label&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="right"&gt;&lt;/td&gt; &lt;td&gt; &lt;input type="submit" value="Sign up" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; </code></pre> <p>PHP File:</p> <pre><code>&lt;?php // Connects to Database include("connect.php"); /* mysql_connect("http://#############", "nickname", "password", "date_of_bith", "country", "terms") or die(mysql_error()); mysql_select_db("#########") or die(mysql_error()); */ //This code runs if the form has been submitted if (isset($_POST['submit'])) { //This makes sure they did not leave any fields blank if (!$_POST['nickname'] | !$_POST['email'] | !$_POST['passwords'] | !$_POST['date_of_birth'] | !$_POST['country'] | !$_POST['terms']) { die('You did not complete all of the required fields'); } // checks if the username is in use if (!get_magic_quotes_gpc()) { $_POST['nickname'] = addslashes($_POST['nickname']); } $usercheck = $_POST['nickname']; $check = mysql_query("SELECT user FROM userlogin WHERE nickname = '$nickname'") or die(mysql_error()); $check2 = mysql_num_rows($check); //if the name exists it gives an error if ($check2 != 0) { die('Sorry, the nickname '.$_POST['nickname'].' is already in use.'); } // here we encrypt the password and add slashes if needed $_POST['password'] = md5($_POST['password']); if (!get_magic_quotes_gpc()) { $_POST['terms'] = addslashes($_POST['terms']); $_POST['country'] = addslashes($_POST['password']); $_POST['date_of_birth'] = addslashes($_POST['date_of_birth']); $_POST['password'] = addslashes($_POST['password']); $_POST['email'] = addslashes($_POST['email']); $_POST['nickname'] = addslashes($_POST['nickname']); } // now we insert it into the database $insert = "INSERT INTO ###### (nickname, email, password, date_of_birth, country, terms) VALUES ('".$_POST['nickname']."', '".$_POST['email']."', '".$_POST['password']."', '".$_POST['date_of_birth']."', '".$_POST['country']."', '".$_POST['terms']."')"; $add_member = mysql_query($insert); } ?&gt; &lt;h1&gt;Registered&lt;/h1&gt; &lt;p&gt;Thank you, you have registered - you may now login &lt;a href="http://##########"&gt; Click here to go to login page&lt;/a&gt;&lt;/p&gt; </code></pre> <p>Thanks for any tips or help you can give me.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJared Farrish
    1. USBones
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour code formatting and spacing is absolutely horrid.
      singulars
      1. POMy php script does not work as it should
      1. USJared Farrish
    2. COYou are doing so many things wrong. All this code is wrong. It's unreadable for starters. I think it's not really safe eater since you are sending $_POST values directly to your database. What you should do is google for PDO and how to use it and then build your site. Also try to build stable database connection, or how it is called in MVC - Model first and when it's all works only then start worrying about your layout.
      singulars
      1. POMy php script does not work as it should
      1. USsed
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload