Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>So you include the first "form" page in the second php file after the code right?</p> <p>First of all in the PHP file you should add all the </p> <pre><code>if(isset($_POST['submit'])){ </code></pre> <p>segments into one:</p> <pre><code>if(isset($_POST['submit'])){ $r_username = $_POST['r_username']; $r_password = $_POST['r_password']; $confirm_r_password = $_POST['confirm_r_password']; $r_name = $_POST['r_name']; $r_surname = $_POST['r_surname']; $r_birth = $_POST['r_dateofbirth']; $r_mail = $_POST['r_mail']; } </code></pre> <p>Your problem is most probably in $_POST['submit'] since you have two checks, one for $_POST['submit'] and another for $_POST['r_submit']</p> <p>Unless you send it both ways i suggest you change the PHP file to check for 'r_submit'</p> <h1>Update:</h1> <p>Try putting the form inside the register.php page so it looks like this:</p> <pre><code>&lt;?php if(isset($_POST['r_submit'])){ $r_username = $_POST['r_username']; $r_password = $_POST['r_password']; $confirm_r_password = $_POST['confirm_r_password']; } ?&gt; &lt;form action="register.php" method="post"&gt; &lt;td&gt;Username&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="text" name="r_username" value="&lt;?php if(isset($r_username)){ print $_POST['r_username']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($_POST['r_submit'])){ if(!isset($r_username)){ echo "&lt;td&gt;Error: No Username has been entered!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Password&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="password" name="r_password" value="&lt;?php if(isset($r_password)){ print $_POST['r_password']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($_POST['r_submit'])){ if(!isset($r_password)){ echo "&lt;td&gt;Error: No Password has been entered!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Confirm Password&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="password" name="confirm_r_password" value="&lt;?php if(isset($confirm_r_password)){ print $_POST['confirm_r_password']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($confirm_password)){ if($confirm_r_password != $r_password){ echo "&lt;td&gt;Error: The passwords don't match!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;input name="r_submit" type="submit" value="Submit" /&gt; &lt;/form&gt; </code></pre> <h1>Solution:</h1> <pre><code>&lt;html&gt; &lt;head&gt; &lt;title&gt;Music Database&lt;/title&gt; &lt;link rel="stylesheet" href="layout.css" type="text/css" /&gt; &lt;?php // Verbinden met de database // include('connect.php'); // Registreer data verkrijgen en in variabelen zetten // if(isset($_POST['r_submit'])){ $r_username = $_POST['r_username']; $r_password = $_POST['r_password']; $confirm_r_password = $_POST['confirm_r_password']; $r_name = $_POST['r_name']; $r_surname = $_POST['r_surname']; $r_birth = $_POST['r_dateofbirth']; $r_mail = $_POST['r_mail']; } ?&gt; &lt;/head&gt; &lt;body&gt; &lt;div id="login"&gt; &lt;form name="login" action="login.php" method="post"&gt; &lt;p&gt;Login: &lt;input class="input" type="text" name="username" value="Username" /&gt; &lt;input id="password" type="password" name="password" value="Password" /&gt;&lt;/p&gt; &lt;div&gt;&lt;a class="link" href="register.php"&gt;Register here!&lt;/a&gt;&lt;/div&gt; &lt;p align="center"&gt;&lt;input class="submit" type="submit" name="login_submit" value="Submit" /&gt;&lt;/p&gt; &lt;/form&gt; &lt;/div&gt; &lt;div id="header"&gt; &lt;a class="link" href="index.php"&gt;Music Database&lt;/a&gt; &lt;/div&gt; &lt;div id="search"&gt; &lt;form name="search" action="search.php" method="post"&gt; &lt;p&gt;Search for: &lt;input class="input" type="text" name="search" value="&lt;?php if(isset($_POST['search'])) print $_POST['search']; ?&gt;" /&gt; &lt;input class="submit" type="submit" name="search_submit" value="Submit" /&gt;&lt;/p&gt; &lt;p&gt;Artist: &lt;input type="checkbox" name="artistsearch" checked /&gt; Album: &lt;input type="checkbox" name="albumsearch" /&gt; Song: &lt;input type="checkbox" name="songsearch" /&gt; Genre: &lt;input type="checkbox" name="genresearch" /&gt;&lt;/p&gt; &lt;/form&gt; &lt;/div&gt; &lt;div id="wrapper"&gt;&lt;br /&gt;&lt;/div&gt; &lt;div id="content"&gt; &lt;h1&gt;Register down here please:&lt;/h1&gt; &lt;table id="wrap_table"&gt; &lt;tr&gt; &lt;td&gt; &lt;div id="reg_content"&gt; &lt;div id="reg_form"&gt; &lt;form name="register_login" action="register.php" method="post"&gt; &lt;fieldset&gt; &lt;legend&gt;Login Data: &lt;/legend&gt; &lt;table class="r_table"&gt; &lt;tr&gt; &lt;td&gt;Username&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="text" name="r_username" value="&lt;?php if(isset($r_username)){ print $_POST['r_username']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($_POST['r_submit'])){ if(!isset($r_username)){ echo "&lt;td&gt;Error: No Username has been entered!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Password&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="password" name="r_password" value="&lt;?php if(isset($r_password)){ print $_POST['r_password']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($_POST['r_submit'])){ if(!isset($r_password)){ echo "&lt;td&gt;Error: No Password has been entered!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Confirm Password&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="password" name="confirm_r_password" value="&lt;?php if(isset($confirm_r_password)){ print $_POST['confirm_r_password']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($confirm_password)){ if($confirm_r_password != $r_password){ echo "&lt;td&gt;Error: The passwords don't match!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/fieldset&gt; &lt;/div&gt; &lt;/td&gt; &lt;td&gt; &lt;div id="reg_form"&gt; &lt;fieldset&gt; &lt;legend&gt;Personal Data: &lt;/legend&gt; &lt;table class="r_table_personal"&gt; &lt;tr&gt; &lt;td&gt;Name: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="text" name="r_name" value=""/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Surname: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="text" name="r_surname" value=""/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Date of Birth: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="text" name="r_dateofbirth" value=""/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;E-mail&lt;sup&gt;*&lt;/sup&gt;: &lt;/td&gt; &lt;td&gt;&lt;input class="input" type="text" name="r_mail" value="&lt;?php if(isset($r_mail)){ print $_POST['r_mail']; } ?&gt;"/&gt;&lt;/td&gt; &lt;?php if(isset($_POST['r_submit'])){ if(!isset($r_mail)){ echo "&lt;td&gt;Error: No E-mail has been entered!&lt;/td&gt;"; } } ?&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/fieldset&gt; &lt;/div&gt; &lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Fields with an asterisk&lt;sup&gt;*&lt;/sup&gt; are required for registry! &lt;div id="reg_content"&gt; &lt;input class="submit" type="submit" name="r_submit" value="Submit!" /&gt; &lt;/div&gt; &lt;/form&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;div id="footerbreak"&gt;&lt;br /&gt;&lt;/div&gt; &lt;div id="footer"&gt; &amp;copy; Jorik ter Molen &amp;amp; Camiel Collet, 2011.&lt;/div&gt; &lt;/body&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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