THE LOGIN CODE
[php]<?php
session_start();
//connect database
require_once(“db_connect.php”);
$db=mysqli_connect($host,$user,$password,$db);
mysqli_select_db($visa,“job”)or die(mysqli_error($visa));
//username and password sent from the form
$username=$_POST[‘username’];
$password=$_POST[‘password’];
//to protect mysqli injection
$username=mysqli_real_escape_string($username);
$password=mysqli_real_escape_string($password);
$qry=“SELECT * FROM member WHERE username =’$username’ and password = ‘$password’”;
$result=mysqli_query($db,$qry) or die(mysqli_error());
//$row=mysqli_fetch_array($result);
//mysqli_num_row for counting rows
$count=mysqli_num_rows($result);
//if result match username and password
if($count==1){
//register username and password
$_SESSION[‘username’] = $_POST[‘username’];
$_SESSION[‘password’] = $_POST[‘password’];
header(“location:member_page.php”);
} else {
echo"wrong username and password";
}
?>[/php]
PERSONAL PAGE CODE
[php]<?php
session_start();
require_once(“db_connect.php”);
//require_once(“auth.php”);
$sel= “SELECT username, name, occupation, sex ,phone ,email FROM member WHERE username = ‘$_SESSION[username]’”;
$result = mysqli_query($sel) or die(mysqli_error());
?>
YOUR PERSONAL INFORMATION
| ID | USERNAME | NAME | SEX | OCCUPATION | |
|---|---|---|---|---|---|
| '.id.' | '; echo''.username.' | '; echo''.name.' | '; echo''.sex.' | '; echo''.occupation.' | '; echo''.email.' | '; echo'