MySQL help

sonny1515 · Jul 11, 2009

Hi, im Sonny, and this is my first post...

At begin this is:

Index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Title</title>
<link href="stuff/style.css" rel="stylesheet" type="text/css" />
<script src="stuff/SpryValidationTextField.js" type="text/javascript"></script>
<link href="stuff/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
</head>

<body>

<div class="banner"><img src="stuff/banner.jpg" /></div>
<div class="contaner">

<a href=index.php>index.php</a>
<A HREF=login.php><img src="stuff/login.gif" /></A>
<A HREF=register.php><img src="stuff/register.gif" /></A>
<br/>
</div>
</body>
</html>

And here is:

Register.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Title</title>
<link href="stuff/style.css" rel="stylesheet" type="text/css" />
<? require"config.php" ?>
<script src="stuff/SpryValidationTextField.js" type="text/javascript"></script>
<link href="stuff/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div class="banner"><img src="stuff/banner.jpg" /></div>
<div class="contaner">

<a href=index.php>index.php</a>
<A HREF=login.php><img src="stuff/login.gif" /></A>
<A HREF=register.php><img src="stuff/register.gif" /></A>
<br/>
  <form id="form1" name="form1" method="post" action="validation.php">
    <span id="username">
    <label for="text1">Username</label>
    <input type="text" name="username" id="text1"  class="inputbox" />
    <span class="textfieldRequiredMsg">You need to enter here your Username.</span><span class="textfieldMinCharsMsg">Minimum number of characters not met.</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span>
    <p><span id="password">
    <label for="text2">Password</label>
    <input type="password" name="password" id="text2" class="inputbox" />
    <span class="textfieldRequiredMsg">You need to enter here your Password.</span><span class="textfieldMinCharsMsg">Minimum number of characters not met.</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span></p>
    <p>
      <input name="button" type="submit" class="submit" id="button" value="Submit" />
    </p>
  </form>
  </div>
<script type="text/javascript">
<!--
var sprytextfield1 = new Spry.Widget.ValidationTextField("username", "none", {validateOn:["change"], minChars:3, maxChars:15});
var sprytextfield2 = new Spry.Widget.ValidationTextField("password", "none", {validateOn:["change"], minChars:3, maxChars:15});
//-->
</script>
</body>
</html>

i want to create login.php

but i dont know how to read an single record

here is code what i writed already

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Title</title>
<link href="stuff/style.css" rel="stylesheet" type="text/css" />
<? require"config.php" ?>
<script src="stuff/SpryValidationTextField.js" type="text/javascript"></script>
<link href="stuff/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div class="banner"><img src="stuff/banner.jpg" /></div>
<div class="contaner">

<a href=index.php>index.php</a>
<A HREF=login.php><img src="stuff/login.gif" /></A>
<A HREF=register.php><img src="stuff/register.gif" /></A>

  <form id="form1" name="form1" method="post" action="get_ini.php">

<span id="username">
<label for="text1">Username</label>
<input type="text" name="username" id="text1"  class="inputbox" />
<span class="textfieldRequiredMsg">Did you enter something here :?</span><span class="textfieldMinCharsMsg">Minimum number (3) of characters not met.</span><span class="textfieldMaxCharsMsg">Exceeded maximum (15) number of characters.</span></span>
<p>

<span id="password">
<label for="text2">Password</label>
<input type="password" name="password" id="text2" class="inputbox" />
<span class="textfieldRequiredMsg">Did you enter something here :?</span><span class="textfieldMinCharsMsg">Minimum number (3) of characters not met.</span><span class="textfieldMaxCharsMsg">Exceeded maximum (15) number of characters.</span></span></p>
<p>

  <input name="button" type="submit" class="submit" id="button" value="Submit" />
</p>
  </form>
  </div>
<script type="text/javascript">
<!--
var sprytextfield1 = new Spry.Widget.ValidationTextField("username", "none", {validateOn:["change"], minChars:3, maxChars:15});
var sprytextfield2 = new Spry.Widget.ValidationTextField("password", "none", {validateOn:["change"], minChars:3, maxChars:15});
//-->
</script>
<br/>
</div>
</body>
</html>

sonny1515 · Jul 11, 2009

Ahh... sry i forget about:

Validation.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Trebuchet Gaming EE > SQL</title>
<link href="stuff/style.css" rel="stylesheet" type="text/css" />
<? require"config.php" ?>
</head>
<?
$username = $_POST['username'];
$password = $_POST['password'];
?>
<body>
<div class="banner"><img src="stuff/banner.jpg" /></div>
<div class="contaner">

<a href=index.php>index.php</a>
<A HREF=login.php><img src="stuff/login.gif" /></A>
<A HREF=register.php><img src="stuff/register.gif" /></A>

<?


$res=mysql_query("SELECT * FROM `$users` WHERE `username`='$username'"); 
		  if(mysql_num_rows($res) > 0){ 
		  echo("This username has already been taken please <a href=index.php>click here</a> and try again");
		  die();
		  }
		  else{
		  $file = fopen("$gameroot/$username.ini","x+");
fwrite($file,"[GENERAL]
Login=$username
Password=$password
");
fclose($file);
		  mysql_query("INSERT INTO `$users` (`username`, `password`) VALUES ('$username', '$password')"); 

	  echo("Congratultions User Registered");
	  }
	  ?>

</div>
</body>
</html>

MySQL help

Ssonny1515

Ssonny1515