Problems with code
Posted: Fri Feb 10, 2006 10:44 pm
this code works pefectly fine on my localhost but when i upload it every thing seems to go wrong. It seems to have a lot of problems with this line of code "mysql_fetch_array ($result, MYSQL_NUM);". Can any one help?
And i have changed the database details.
And i have changed the database details.
Code: Select all
<?php
session_start();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Admin Login</title>
<link rel="stylesheet" type="text/css" href="style.css" media="all" title="StyleSheet"/>
</head>
<body>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999">
<tr>
<td><table width="400" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><img src="images/banner.jpg"></div></td>
</tr>
<tr>
<td height="145">
<br><p align="center">
<?
if($_POST['submit']){
require_once('mysql_connect.php');
$username = $_POST['username'];
$password = md5($_POST['password']);
$query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = @mysql_query ($query);
$row = mysql_fetch_array ($result, MYSQL_NUM);
if ($row) {
session_register("username");
session_register("user_id");
$_SESSION['username'] = $row[1];
$_SESSION['user_id'] = $row[0];
echo "<font face=\"verdana\" size=\"1\" color=\"#000000\">Login Complete<META HTTP-EQUIV=\"refresh\" CONTENT=\"2; URL=menu.php\"></font>";
} else {
echo "<font face=\"verdana\" size=\"1\" color=\"#000000\">Login Failed<META HTTP-EQUIV=\"refresh\" CONTENT=\"2; URL=index.php\"></font>";
}
} ?>
</p>
<br><form name="form1" method="post" action="index.php">
<div align="center"><span class="style1">Username:</span><br>
<input name="username" type="text" class="style1" id="username">
<br>
<span class="style1">Password:</span> <br>
<input name="password" type="password" class="style1" id="password">
<br>
<br>
<input name="submit" type="submit" class="style1" id="submit" value="Login">
<br>
<br>
</div>
</form></td>
</tr>
<tr>
<td align="center"><?php include('copyright.php'); ?></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>