September 5,2016
Today i continue with my first login activity.Today i have worked on php script used in login activity.
<?php
$usrnm=$_POST[‘Username’];
$pwd=$_POST[‘Password’];
//$usrnm=’1001′;
//$pwd=’jaspreet123′;
$con=new mysqli(“localhost”,”root”,””,”login”);
if($con->connect_errno)
{
$response=”db_err”;
}
else
{
$loginquery=”select * from user_login where Username=’$usrnm’ and Password=’$pwd’ “;
$result_login=$con->query($loginquery);
if($result_login->num_rows>0)
{
while($sql_fetch_array=mysqli_fetch_array($result_login))
{
$type=$sql_fetch_array[‘Type’];
if($type==’Student’)
{
$query1=”select * from user_info where Username=’$usrnm'”;
$result1=$con->query($query1);
if($result1->num_rows>0)
{
while($sql_fetch_array=mysqli_fetch_array($result1))
{
$name=$sql_fetch_array[‘Name’];
$roll=$sql_fetch_array[‘Rollno’];
$stream=$sql_fetch_array[‘Stream’];
$sem=$sql_fetch_array[‘Semester’];
$response=’ok’;
echo json_encode(array(‘response’=>$response,’type’=>$type,’name’=>$name,’roll’=>$roll,’stream’=>$stream,’semester’=>$sem));
}
}
}
else
{
$query2=”select * from tchr_info where Username=’$usrnm'”;
$result2=$con->query($query2);
if($result2->num_rows>0)
{
while($sql_fetch_array=mysqli_fetch_array($result2))
{
$dept=$sql_fetch_array[‘Department’];
$tch_name=$sql_fetch_array[‘Name’];
$response=’ok’;
echo json_encode(array(‘response’=>$response,’type’=>$type,’dept’=>$dept,’tch_name’=>$tch_name));
}
}
}
}
$response=’ok’;
}
else
{
$response=’error’;
}
}
//echo json_encode(array(‘response’=>response));
$con->close();
?>