web service for show list in php

<?php
include 'config.php';
$t=array();
$arr = array();

$doctor_id = $_REQUEST['doctor_id'];
$date = $_REQUEST['date'];

 $sql="SELECT * FROM  `appointment` WHERE appoinment_date ='".$date."'  AND doctor_id='".$doctor_id."' ORDER BY appointment_id DESC";



//$sql="SELECT * FROM  `appointment` WHERE doctor_id='".$doctor_id."' ORDER BY appointment_id DESC";


$query=mysql_query($sql);
$num_rows=mysql_num_rows($query);
if($num_rows > 0)
{
   $t=array('status'=>'1',
'message'=>'success'
);

 while ($result=mysql_fetch_array($query)) {
 
 $arr['doctor_all_appoinment'][]=array(
        'appointment_id'=>$result['appointment_id'],
        'patient_id'=>$result['patient_id'],
        'patient_age'=>$result['patient_age'],
        'gender'=>$result['gender'],
         'health_issue'=>$result['health_issue'],
         'appoinment_purpose'=>$result['appoinment_purpose'],
         'who_is_patient'=>$result['who_is_patient'],
'patient_name'=>$result['patient_name'],
'patient_number'=>$result['patient_number'],
'appoinment_date'=>$result['appoinment_date'],
'appoinment_time'=>$result['appoinment_time'],
'created_date'=>$result['created_date'],
'appointment_status'=>(int)$result['status']
);
 }
 
  $array_merge=array_merge($t,$arr);
  echo json_encode($array_merge);

}
else
{
    $t=array('status'=>'0',
'message'=>'no record found'
  );
echo json_encode($t);
}

?>

Comments

Post a Comment

Popular posts from this blog

dynamic create multiple ckeditor onclick event using jquery

<!DOCTYPE html> <html> <head> <title>New Ckeditor Instance Dynamically</title> <script type="text/javascript" src="ckeditor_3.5/ckeditor/ckeditor.js"></script> <script type="text/javascript" src="scripts/jquery-1.4.4.js"></script> <script type="text/javascript" src="ckeditor_3.5/ckeditor/adapters/jquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $('.jquery_ckeditor').ckeditor(); }); </script> <script> function newCkeditor(){ $('<div><textarea><\/textarea><\/div>') .appendTo('#body').find('textarea').ckeditor(); } function clicked(){ for ( instance in CKEDITOR.instances ){ alert("ckeditor values : " + CKEDITOR.instances[instance].getData()); } } </script> </head> <body...
Read more

Fatal error: Can't use method return value in write context in ci

Replace the first if statement with if( ! $this->session->userdata('user_id') ) . The empty function check if a variable is empty but userdata is a function. Additionally, for your information, according to the CodeIgniter documentation , the userdata function returns FALSE if the item doesn't exist, which means that if user_id doesn't exist in your session, the code in the else will be executed. ref: https://stackoverflow.com/questions/6730216/cant-use-method-return-value-in-write-context
Read more

online visitor counter

   <?php session_start();      function getUsersOnline() {    $count = 0;         $handle = opendir(session_save_path());    if    ($handle == false) return -1;         while (($file = readdir($handle)) != false) {          if (ereg("^sess", $file)) $count++;    }    closedir($handle);         return $count; } ?> then just call it using this <?php echo $usercount = getUsersOnline(); ?>
Read more