PHP file for syllabus

October 27,2016

<?php
$con=new mysqli(“localhost”,”root”,””,”login”);
//$con=new mysqli(“mysql.hostinger.in”,”u847280056_erp”,”123456789″,”u847280056_login”);
if($con->connect_errno){
echo”connection error”;
}
$query1=” INSERT INTO syllabus VALUES (‘null’,’Syllabus(Sem 3-4)’,’1′,’CSE’,’http://192.168.0.101/Notices/CSE_IT_3_4sem_2011_11042012.pdf&#8217;)”;
$result=$con->query($query1);
if($result)
{
$response=’OK’;
}
else{
$response=’ERROR’;
}
echo json_encode(array(‘result’=>$response));
?>

 

PHP file for Notification

October 26,2016

<?php
//$roll=’1001′;
$roll=$_POST[‘Rollno’];
$con=new mysqli(“localhost”,”root”,””,”login”);
//$con=new mysqli(“mysql.hostinger.in”,”u847280056_erp”,”123456789″,”u847280056_login”);
$res3=’none’;
if($conn->connect_errno)
{
$response=”db_err”;
}
else
{
$query1=”select Date from user_info where Rollno=’$roll'”;
$result=$conn->query($query1);
if($result->num_rows>0){
$sql_arr=mysqli_fetch_array($result);
$date=$sql_arr[‘Date’];
$res=’ok’;
$query2=”select Date from upload_notice where Date >’$date’ “;
$result2=$conn->query($query2);
if($result2->num_rows>0){
$sql_arr2=mysqli_fetch_array($result2);
$date2=$sql_arr2[‘Date’];
$res2=’ok’;
$query3=”update user_info set Date=’$date2′ where Rollno=’$roll’ “;
$result3=$conn->query($query3);
$res3=’ok’;
}
}
else
{
$res=’error’;
}

}
echo json_encode(array(‘result’=>$res3));
?>