prefix . "apt_appointments"; $staff_table = $wpdb->prefix . "apt_staff"; $clients_table = $wpdb->prefix . "apt_clients"; $payment_table = $wpdb->prefix . "apt_payment"; $services_table = $wpdb->prefix . "apt_services"; ?>

get_results( "select * from $appointments_table where status='approved'" ); $approved_appointments = count( $approved_appointment_details ); ?>
get_results( "select * from $appointments_table where status='pending'" ); $pending_appointments = count( $pending_appointment_details ); ?>
get_results( "select * from $appointments_table where status='cancelled'" ); $cancelled_appointments = count( $cancelled_appointment_details ); ?>
get_results( "select * from $appointments_table where status='completed'" ); $completed_appointments = count( $completed_appointment_details ); ?>

get_col( "Select id from $clients_table" ); $regular_clients = count( $customer_email_id ); ?>
get_col( "Select id from $services_table" ); $total_services = count( $service_id ); ?>
get_col( "Select id from $appointments_table" ); $total_appointments = count( $appointments ); ?>