Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $conn = odbc_connect("$dbq","","");
- if($conn){
- echo "Connected";
- }else{
- echo "Failed";
- }
- ?>
- <?php
- include 'Connection.php';
- if(isset($_REQUEST["insert"]))
- {
- $reg = $_GET['reg'];
- $ID = $_GET['ID'];
- $sql = "select a.RegNo,b.RollNo,c.Standard,d.Division,b.Std_Name as StudentName,AttendanceDate,Attendance_Type,Remark
- from (((Attendance_mas as a
- inner join Std_Reg as b on a.RegNo = b.RegNo)
- inner join StandardMaster as c on a.Standard = c.stdid)
- inner join DivisionMaster as d on a.Division =d.DivisionID)
- where a.RegNo= '$reg' and a.yearid = '$ID' Order by AttendanceDate desc";
- //$sql = "select * from Std_Reg";
- $stmt = odbc_exec($conn, $sql);
- //print_r($stmt);
- $result = [];
- do {
- while ($row = odbc_fetch_array($stmt)){
- $result[] = $row;
- }
- } while (odbc_next_result($stmt));
- if(count($result)>0)
- {
- $result1['status']=1;//"Login successfully";
- array_push($result1,$result);
- }
- else
- {
- //$result[]="null";
- $result1['status']=0;//"Record not found";
- array_push($result1,$result);
- }
- odbc_free_result($stmt);
- odbc_close($conn); //Close the connnectiokn first
- echo json_encode($result1); //You will get the encoded array variable
- }
- ?>
Add Comment
Please, Sign In to add comment