prefix . "services"; if($service_flag == "true") { $insert_query = "INSERT INTO $table_name (`service_id`, `service_name`, `service_desc`, `service_durationvalue`, `service_durationunit`, `service_cost`, `service_availability`) VALUES (NULL, '$s_nam', '$s_desc', '$s_dvalue', '$s_dunit', '$s_cost', '$s_avi');"; $wpdb->query($insert_query); } } ?> prefix . "services"; $count = count($_POST['deleteservice']); for($i=0;$i<$count;$i++) { $del_id = $_POST['deleteservice'][$i]; $delete_query = "DELETE FROM $table_name WHERE service_id='$del_id'"; $wpdb->query($delete_query); } $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] ?> prefix . "services"; $update_query = "UPDATE $table_name SET `service_name` = '$up_nam', `service_desc` = '$up_desc', `service_durationvalue` = '$up_dvalue', `service_durationunit` = '$up_dunit', `service_cost` = '$up_cost', `service_availability` = '$up_avi' WHERE `service_id` ='$get_up_id'"; $wpdb->query($update_query); $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] ?>
prefix . "services"; $getdata = $wpdb->get_results("select * from $table_name"); if($getdata == NULL || $_GET['update_service']) { // get update service id and values in fields if($_GET['update_service']) { $up_id = $_GET['update_service']; global $wpdb; $table_name = $wpdb->prefix . "services"; $getdata = $wpdb->get_row("select * from $table_name WHERE service_id='$up_id' "); } ?>

Create Service

Fields   Values
Service Name :
Sevice Description :
Duration :
    ";} else {echo '';} ?>

All Services

prefix . "services"; $services = $wpdb->get_results("select * from $table_name"); $sn = 1; foreach ( $services as $services_data ) { ?> service_id;?>
No. Service Name Duartion Update Service Delete service
service_name;?> service_durationvalue." ".$services_data->service_durationunit;?> Edit