StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<pre><code><?php if($_POST['username'] && $_POST['password']){ $username = $_POST['username']; // Escape this $password = $_POST['password']; // Escape this $searchQuery = mysql_query("SELECT id FROM onlineformdata WHERE username = '$userName' AND password = '$password' ORDER BY id DESC LIMIT 1"); if(mysql_num_rows($searchQuery)){ header('location:/adminPage.php'); // Go to this page if row exists in DB } else{ header('location:/invalidLoginPage.html'); //Go to this page if row doesn't exist in DB } exit; // So that it quite this page and goes to the desired one set in the "headers" } else{ //Not strictly needed... But you could be useful in some circumstances } ?> <html> <head> <title>Admin Login</title> </head> <body> <form action='' method="post"> username: <input type="text" name="username" /> password: <input type="text" name="password" /> <br/> <input type="submit" value="submit" /> </form> </body> </html> </code></pre> <p>This should get you started in the <em>right</em> direction. Don't forget to escape the username/password fields as you see fit.</p> <p>The <em>action</em> part of the form is where the form is submitted to and so - in your case - that should be the same page. As Hristo said, you can leave it out/blank and it will default to submitting itself.</p> <p>As for Marc B (he did ask a question after all); if you read the code you would see that the PrepSQL function actually adds single quotes around the string... As there are no quotes in the html this isn't wrong in anyway... So I don't see what the problem is there (aside from it not doing what he wanted it to).</p> <p>With regards to multiple user accounts, so long as you don't allow the same <em>username</em> to be used by multiple users then there is only one record returned by the database... So again, there's no problem there.</p>

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