realEscapeSingle($_POST['new_code']); $new_name = $db->realEscapeSingle($_POST['new_name']); $new_discount = $db->realEscapeSingle($_POST['new_discount']); $new_count = $db->realEscapeSingle($_POST['new_count']); $new_expires = $db->realEscapeSingle($_POST['new_expires']); $id = $db->realEscapeSingle($_POST['id']); //Create INSERT query $qry_change_url = "UPDATE OGP_DB_PREFIXbilling_coupons SET code ='".$new_code."', name = '".$new_name."', discount ='".$new_discount."', count = '".$new_count."', expires = '".$new_expires."' WHERE id=".$id; $db->query($qry_change_url); } //Querying INSERT new coupon INTO DB if(isset($_POST['add_coupon'])) { $id = $_POST['id']; $code = $_POST['code']; $name = $_POST['name']; $discount = $_POST['discount']; $count= $_POST['count']; $expires = $_POST['expires']; $query = "INSERT INTO OGP_DB_PREFIXbilling_coupons(code, name, discount, count, expires) VALUES('".$code."', '".$name."', '".$discount."', '".$count."', '".$expires."')"; $db->query($query); } //Querying REMOVE coupon FROM DB if (isset($_POST['del_coupon'])) { $db->query( "DELETE FROM OGP_DB_PREFIXbilling_coupons WHERE id=" . $db->realEscapeSingle($_POST['id']) ); } ?>
resultQuery("SELECT * FROM OGP_DB_PREFIXbilling_coupons"); if ($result > 0) { ?>