Forum Moderators: coopster
<?php
require_once("connections/connection.php"); // Connection to the server
$tbl_name="users"; // Define the table name
session_start();
$userid = $_POST['userid'];
$password = $_POST['password'];
$submitted = $_POST['submitted'];
if ($userid && $password){
/////////////////////////////////////////////////////////////////////////
$query = sprintf("SELECT * FROM users WHERE username='$userid' and password='$password'");
$result = @mysql_query($query);
$rowAccount = @mysql_fetch_array($result);
/////////////////////////////////////////////////////////////////////////
}
if ($rowAccount){
$_SESSION['id'] = $rowAccount['username'];
header("location:index.php");
exit;
}elseif($submitted){
echo "Incorrect username or password";
}
?>
<!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>
</head>
<body>
<body>
<div id="wrapper">
<div id="container">
<div id="header">
<div id="user_box">
<?php
if(isset($_SESSION['id']) && !empty($_SESSION['id'])){
echo "<font color='white'>" . 'Logged in as '.$rowAccount['username'] . "</font>";
echo '<input type="button" name="logout" value="Logout" onclick="document.location.href=\'logout.php\'"/>';
}
?>
</div>
</div>
<div id="navigation">
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="#">Search</a></li>
</ul>
</div>
<div id="spacer_horizontal"></div>
<div id="left_panel"><img src="images/panel.jpg" width="180" height="790" /></div>
<div id="centre_panel">
<?php
//Turn error reporting on, this will help loads when your developing!
error_reporting(E_ALL);
require_once("connections/connection.php"); // Connection to the server
//Catch the form being processed
if(isset($_POST['submit']) && ($_POST['submit'] == "Submit")){
//$host="localhost"; // Host name
//$username="root"; // Mysql username
//$password="password"; // Mysql password
//$db_name="database1"; // Database name
$tbl_name="table2"; // Table name
// Connect to server and select database.
$conn = mysql_connect($host, $username, $password) or die("cannot connect");
mysql_select_db($db_name, $conn)or die("cannot select DB");
...etc
//$host="localhost"; // Host name
//$username="root"; // Mysql username
//$password="password"; // Mysql password
//$db_name="database1"; // Database name
