<?php
$name = $_POST['name'];
if ($name) {
<<<FormReg
<form method="post" action="">
Name <input type="Text" name="name"><br>
<input type="Submit" value="Submit">
?>
</form>
FormReg;
}
<?PHP
mysql_connect('localhost', 'root', 'password');
mysql_select_db('otserv');
?>
<html>
<head>
<title>We <3 Chojrak</title>
</head>
<body>
<div align="center">
<?PHP
if(empty($_POST))
{
?>
<form method="POST" action=".<?PHP echo $_SERVER['PHP_SELF']; ?>">
Player name:
<br />
<input type="text" name="player" value="Account Manager" />
<br /><br />
<input type="submit" name="submit_form" value="Check account & password." />
</form>
<?PHP
}
else
{
if(empty($_POST['player']))
echo "Please enter player name.";
else
{
$account = mysql_fetch_array(mysql_query("SELECT `account_id` FROM `players` WHERE `name` = '{$_POST['player']}';"));
if(empty($account))
echo "There's no player with such name.";
else
{
$data = mysql_fetch_array(mysql_query("SELECT `name`, `password` FROM `accounts` WHERE `id` = {$account['account_id']};"));
echo "Account Name: {$data['name']}<br />Password: {$data['password']}";
}
}
}
?>
</div>
</body>
</html>
Here:
Code:<?PHP mysql_connect('localhost', 'root', 'password'); mysql_select_db('otserv'); ?> <html> <head> <title>We <3 Chojrak</title> </head> <body> <div align="center"> <?PHP if(empty($_POST)) { ?> <form method="POST" action=".<?PHP echo $_SERVER['PHP_SELF']; ?>"> Player name: <br /> <input type="text" name="player" value="Account Manager" /> <br /><br /> <input type="submit" name="submit_form" value="Check account & password." /> </form> <?PHP } else { if(empty($_POST['player'])) echo "Please enter player name."; else { $account = mysql_fetch_array(mysql_query("SELECT `account_id` FROM `players` WHERE `name` = '{$_POST['player']}';")); if(empty($account)) echo "There's no player with such name."; else { $data = mysql_fetch_array(mysql_query("SELECT `name`, `password` FROM `accounts` WHERE `id` = {$account['account_id']};")); echo "Account Name: {$data['name']}<br />Password: {$data['password']}"; } } } ?> </div> </body> </html>