$errors['year_month'] = "* year month cannot be empty."; } elseif (!preg_match("/^[0-9]{6}\$/", $_POST['year_month'])) { $errors['year_month'] = "* Invalied year month."; } if (empty($_POST['date'])) { $errors['date'] = "* Date cannot be empty."; } if (empty($_POST['weight'])) { $errors['weight'] = "* weight cannot be empty."; } if (empty($errors)) { $cus_id = trim(mysql_prep($_POST['cuz_id'])); $year_month = trim(mysql_prep($_POST['year_month'])); $weight = trim(mysql_prep($_POST['weight'])); $date = trim(mysql_prep($_POST['date'])); $td = new T_data(); $td->cus_id = $cus_id; $td->year_month = $year_month; $td->date = $date; $td->weight = $weight; global $database; $result = mysql_query("SELECT * FROM user WHERE id='{$cus_id}' AND privilege='Customer'"); $rowExist = mysql_num_rows($result) > 0; $rslt = ""; if (!$rowExist) { echo '<script language="javascript">'; echo 'alert("error! Invalied Customer ID!")'; echo '</script>'; } else { $rslt = $td->enter_t_data(); }
if (isset($_POST['submit'])) { if (empty($_POST['year_month'])) { $errors['year_month'] = "* year month cannot be empty."; } elseif (!preg_match("/^[0-9]{6}\$/", $_POST['year_month'])) { $errors['year_month'] = "* Invalied year month."; } if (empty($_POST['rate'])) { $errors['rate'] = "* Rate cannot be empty."; } if (empty($errors)) { $year_month = trim(mysql_prep($_POST['year_month'])); $rate = trim(mysql_prep($_POST['rate'])); $bill = new Bill(); $bill->year_month = $year_month; $bill->rate = $rate; $td = new T_data(); $td->year_month = $year_month; $td->cal_totals(); $rslt = $bill->cal_bill(); /* $result = mysql_query("SHOW TABLES LIKE '$year_month'"); $tableExist = mysql_num_rows($result) > 0; if(!$tableExist){ echo '<script language="javascript">'; echo 'alert("error! First calculate the total weights!")'; echo '</script>'; }else{ $td->cal_totals();