get_results( "select * from $wpdb->prefix" . "apt_appointments" );
$num_rows = count( $ap_fecth );
if ( $num_rows !== 0 ) {
foreach ( $ap_fecth as $value ) {
$id = $value->id;
$client_email = $value->client_email;
$client_name = $value->client_name;
$staff_member = $value->staff_member;
$ap_fecth_staff = $wpdb->get_results( "select * from $wpdb->prefix" . "apt_staff where id='$staff_member'" );
foreach ( $ap_fecth_staff as $ap_fecth_single_staff ) {
$staff_name = $ap_fecth_single_staff->staff_member_name;
$staff_email = $ap_fecth_single_staff->staff_email;
}
$service_type = $value->service_type;
$contact = $value->contact;
$booking_date = $value->booking_date;
$start_time = $value->start_time;
$end_time = $value->end_time;
$status = $value->status;
$results["data"][] = array(
'',
$id,
array( $booking_date, $start_time, "To", $end_time ),
$client_name,
$service_type,
'',
$contact,
array( ' ' )
);
}
} else {
$results["data"][] = array( null, null, null, 'No appointment Add', null, null, null, null );
}
if ( $results != null ) {
wp_send_json( $results ); // encode and send response
} else {
wp_send_json_error(); // {"success":false}
}
?>