willy ze great
JF-Expert Member
- Apr 30, 2013
- 1,026
- 1,179
<?php
session_start();
$servername="localhost";
$username="root";
$password="";
$dbname="hms";
$conn=mysqli_connect($servername,$username,$password,$dbname);
if($_SERVER["REQUEST_METHOD"] == "POST"){
//username and password sent from form
$account = mysqli_real_escape_string($conn,$_POST['account']);
$pword = mysqli_real_escape_string($conn,$_POST['pword']);
$sql="select id from hospital where account='$account' and pword='$pword'";
$result= mysqli_query($conn,$sql);
$row= mysqli_fetch_array($result,MYSQLI_ASSOC);
$count= mysqli_num_rows($result);
//if result matched surname and password table row must be 1 row
if ($count==1){
$_SESSION['pharmacist'] = $account;
header ("location: pharmacy.php");
}elseif($count==1) {
$_SESSION['doctor'] = $account;
header ("location: doctor.php");
}elseif($count==1){
$_SESSION['receptionist'] = $account;
header ("location: reception.php");
}elseif($count==1){
$_SESSION['lab Technician'] = $account;
header ("location: lbtechncian.php");
}elseif($count==1){
$_SESSION['manager/admin'] = $account;
header ("location: index.php");
}else{
echo "<script>alert('wrong password , Try again!!!')</script>";
}
}
?>
user wako registred tayari tatizo nataka waingilie aina za account inayotakiwa na password tu. na impeleke kwenye page husika nimejaribu hizo inakubali kwa header ya kwanza tu.. msaada
problem solved nilifanya hivi ikakubali
<?php
session_start();
$servername="localhost";
$username="root";
$password="";
$dbname="hms";
$conn=mysqli_connect($servername,$username,$password,$dbname);
if($_SERVER["REQUEST_METHOD"] == "POST"){
//username and password sent from form
$account = mysqli_real_escape_string($conn,$_POST['account']);
$pword = mysqli_real_escape_string($conn,$_POST['pword']);
$sql="select id from hospital where account='$account' and pword='$pword'";
$result= mysqli_query($conn,$sql);
$row= mysqli_fetch_array($result,MYSQLI_ASSOC);
$count= mysqli_num_rows($result);
//if result matched surname and password table row must be 1 row
if ($count==1){
$_SESSION['account'] = $account;
if($account=='Doctor'){
echo"<script>window.open('doctor.php','_self')</script>";
}elseif($account=='Receptionist'){
echo"<script>window.open('reception.php','_self')</script>";
}elseif($account=='Lab Technician'){
echo"<script>window.open('lbtechnician.php','_self')</script>";
}elseif($account=='Pharmacist'){
echo"<script>window.open('pharmacist.php','_self')</script>";
}else{
echo"<script>window.open('index.php','_self')</script>";
}
}else{
echo "<script>alert('wrong password , Try again!!!')</script>";
}
}
?>
session_start();
$servername="localhost";
$username="root";
$password="";
$dbname="hms";
$conn=mysqli_connect($servername,$username,$password,$dbname);
if($_SERVER["REQUEST_METHOD"] == "POST"){
//username and password sent from form
$account = mysqli_real_escape_string($conn,$_POST['account']);
$pword = mysqli_real_escape_string($conn,$_POST['pword']);
$sql="select id from hospital where account='$account' and pword='$pword'";
$result= mysqli_query($conn,$sql);
$row= mysqli_fetch_array($result,MYSQLI_ASSOC);
$count= mysqli_num_rows($result);
//if result matched surname and password table row must be 1 row
if ($count==1){
$_SESSION['pharmacist'] = $account;
header ("location: pharmacy.php");
}elseif($count==1) {
$_SESSION['doctor'] = $account;
header ("location: doctor.php");
}elseif($count==1){
$_SESSION['receptionist'] = $account;
header ("location: reception.php");
}elseif($count==1){
$_SESSION['lab Technician'] = $account;
header ("location: lbtechncian.php");
}elseif($count==1){
$_SESSION['manager/admin'] = $account;
header ("location: index.php");
}else{
echo "<script>alert('wrong password , Try again!!!')</script>";
}
}
?>
user wako registred tayari tatizo nataka waingilie aina za account inayotakiwa na password tu. na impeleke kwenye page husika nimejaribu hizo inakubali kwa header ya kwanza tu.. msaada
problem solved nilifanya hivi ikakubali
<?php
session_start();
$servername="localhost";
$username="root";
$password="";
$dbname="hms";
$conn=mysqli_connect($servername,$username,$password,$dbname);
if($_SERVER["REQUEST_METHOD"] == "POST"){
//username and password sent from form
$account = mysqli_real_escape_string($conn,$_POST['account']);
$pword = mysqli_real_escape_string($conn,$_POST['pword']);
$sql="select id from hospital where account='$account' and pword='$pword'";
$result= mysqli_query($conn,$sql);
$row= mysqli_fetch_array($result,MYSQLI_ASSOC);
$count= mysqli_num_rows($result);
//if result matched surname and password table row must be 1 row
if ($count==1){
$_SESSION['account'] = $account;
if($account=='Doctor'){
echo"<script>window.open('doctor.php','_self')</script>";
}elseif($account=='Receptionist'){
echo"<script>window.open('reception.php','_self')</script>";
}elseif($account=='Lab Technician'){
echo"<script>window.open('lbtechnician.php','_self')</script>";
}elseif($account=='Pharmacist'){
echo"<script>window.open('pharmacist.php','_self')</script>";
}else{
echo"<script>window.open('index.php','_self')</script>";
}
}else{
echo "<script>alert('wrong password , Try again!!!')</script>";
}
}
?>