Sunday, 29 September 2013

PHP Oracle Prevent Double Submit Data With My Case

PHP Oracle Prevent Double Submit Data With My Case

I want to prevent submit data with double data with 2 parameters, model_no
and date_added.
Here is my code :
$query_2 = "SELECT M.MODEL_NO, M.MODEL_NAME, P.MODEL_NO, P.DATE_ADDED FROM
SEIAPPS_MODEL M, SEIAPPS_PRODUCTION_STATUS P WHERE M.MODEL_NO = P.MODEL_NO
AND P.MODEL_NO='$model'";
$result2 = oci_parse($c1, $query_2);
oci_execute($result2);
while ($data_1 = oci_fetch_array($result2))
{
$date_added_a = $data_1['DATE_ADDED'];
$model_a = $data_1['MODEL_NO'];
$model_name = $data_1['MODEL_NAME'];
}
if
((!empty($model)) &&
(!empty($production_status)) &&
(!empty($remarks)))
{
if($model_a == "$model" && $date_added_a ==
"$date_added")
{
echo "<div class='error'>Duplicate data
information not allowed!</div>";
}
else
{
$submit_query = "INSERT INTO
SEIAPPS_PRODUCTION_STATUS(FORM_NO, MODEL_NO,
PRODUCTION_STATUS, REMARKS, QTY_PLAN, DATE_ADDED,
TIME, IP_ADDRESS)
VALUES('$form_no', '$model',
'$production_status', '$remarks',
'$qty_plan', '$date_added',
'$time', '$ip_address')
";
$result_query = oci_parse($c1, $submit_query);
oci_execute($result_query);
if($result_query)
{
echo "<div class='success'>Data production
plan and status for <b>$model_name</b> has
been added.</div>";
}
}
}
else
{
echo "<div class='error'>All field are required!</div>";
}
I tried this code, but when I try to submit with the same data, it will
saved the data. So the data will double in table.
Any advice how to prevent double submit with my case ?

No comments:

Post a Comment