//Get Services and save to database first.
for($i = 0; $i < count($_POST["wc_service_id"]); $i++) {
$wc_service_id = $_POST["wc_service_id"][$i];
$wc_service_name = $_POST["wc_service_name"][$i];
$wc_service_code = $_POST["wc_service_code"][$i];
$wc_service_qty = $_POST["wc_service_qty"][$i];
$wc_service_price = $_POST["wc_service_price"][$i];
$insert_query = "INSERT INTO `".$computer_repair_items."` VALUES(NULL, '".$wc_service_name."', 'services', '".$post_id."')";
$wpdb->query(
$wpdb->prepare($insert_query)
);
$order_item_id = $wpdb->insert_id;
$insert_query = "INSERT INTO `".$computer_repair_items_meta."`
VALUES(NULL, '".$order_item_id."', 'wc_service_code', '".$wc_service_code."'),
(NULL, '".$order_item_id."', 'wc_service_id', '".$wc_service_id."'),
(NULL, '".$order_item_id."', 'wc_service_qty', '".$wc_service_qty."'),
(NULL, '".$order_item_id."', 'wc_service_price', '".$wc_service_price."')";
$wpdb->query(
$wpdb->prepare($insert_query)
);
}//Services Processed nicely
With code above its working completely fine only problem i am getting this Notice: when debug mode is on. And i shouldn't have any notices.
Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder.
Is there any suggestion? I know removing prepare( would take away the problem. But i want to keep the query prepared if you think its not necessary please explain.
Also adding %s, %d for first query, is good. But what for 2nd Query where i have 3 values?
Thanks in advance for reply.