prepare("UPDATE citycostscalc SET citcalc_active = 1 WHERE citcalc_id = $adid "); $stmt->execute(array()); header('location:citycalc.php'); exit(); }?> prepare("UPDATE citycostscalc SET citcalc_active = 0 WHERE citcalc_id = $adid "); $stmt->execute(array()); header('location:citycalc.php'); exit(); }?> prepare("DELETE FROM citycostscalc WHERE citcalc_id = :zid"); $stmt->bindparam(":zid", $id); $stmt->execute(); header('location:citycalc.php'); exit(); } ?> Empty '; } //loop into errors array and echo it foreach($formErrors as $error){ echo '
' . $error . '
' ; } if (empty($formErrors)){ $stmt = $conn->prepare("INSERT INTO citycostscalc(citcalc_name, citcalc_arname, citcalc_ordernum, citcalc_type, citcalc_plusnumber, citcalc_active) VALUES (:zname, :zarname, :zordnum,:ztype,:zplusnum, 1 ) "); $stmt->execute(array( 'zname' => $cityname, 'zarname' => $cityarname, 'zordnum' => $cityordnum, 'ztype' => $cityacctype, 'zplusnum' => $plusnumber )); header('location:citycalc.php'); exit(); } else{ $msg=urlencode("البيانات المدخلة تحتوي على مشكلة" . "، أعد المحاولة"); header('location:ac_workshops.php?Message='. $msg); exit(); } } ?> Empty '; } //loop into errors array and echo it foreach($formErrors as $error){ echo '
' . $error . '
' ; } if (empty($formErrors)){ $editwsh = $conn->prepare("UPDATE citycostscalc SET citcalc_name =?, citcalc_arname =?, citcalc_ordernum =?, citcalc_type =?, citcalc_plusnumber =? WHERE citcalc_id = $cityid "); $editwsh->execute(array($cityname ,$cityarname,$cityordnum,$cityacctype,$plusnumber)); header('location:citycalc.php'); exit(); } else{ $msg=urlencode("البيانات المدخلة تحتوي على مشكلة" . "، أعد المحاولة"); header('location:ac_workshops.php?Message='. $msg); exit(); } } ?>

إضافة مدينة جديدة

prepare("SELECT * FROM citycostscalc WHERE citcalc_id = $cityid"); // execute Query $stmacc->execute(); // fetch the data $cityinfo = $stmacc->fetch(); ?>

تعديل مدينة