query("SELECT SUM(CASE WHEN type='cr' THEN amount ELSE -amount END) as balance FROM tbl_wallet WHERE user_id = '$center_id' AND user_type='center'"); if($wallet_query && $wallet_row = $wallet_query->fetch_assoc()) { $wallet_balance = $wallet_row['balance'] ?? 0; } // Define constant for use in template if (!defined('WALLET_BALANCE')) { define('WALLET_BALANCE', $wallet_balance); } $admissionFee = paymentConfig('set_amount1'); if(isset($_POST['status']) && $_POST['status'] == 'insert') { $chk = $con->query("SELECT * FROM students where mobile = '".$_POST['mobile']."' AND email = '".$_POST['email']."'"); if(!($chk->num_rows)) { if($wallet_balance >= $admissionFee) { $img = photo_upload('image','students'); if($img['status']) { $image = $img['file_name']; } else { $image = ''; } $signature = photo_upload('sign','students'); if($signature['status']) { $sign = $signature['file_name']; } else { $sign = ''; } $data = $con->query("INSERT INTO `students` (`dur_start`,`dur_ends`,`id`, `timestamp`, `enrollment_no`, `name`, `gender`, `father`, `mother`, `dob`, `mobile`, `email`,`address`, `state`, `distric`, `exam_pass`, `marks`, `board`, `year`, `username`, `password`, `course_id`, `center_id`, `photo`, `sign`, `status`) VALUES ('".$_POST['dur_start']."','".$_POST['dur_ends']."',NULL, CURRENT_TIMESTAMP, '".$_POST['enrollment_no']."', '".$_POST['name']."', '".$_POST['gender']."', '".$_POST['father']."', '".$_POST['mother']."', '".$_POST['dob']."', '".$_POST['mobile']."', '".$_POST['email']."', '".$_POST['address']."','".$_POST['state']."', '".$_POST['distric']."', '".$_POST['exam_pass']."', '".$_POST['marks']."', '".$_POST['board']."', '".$_POST['year']."', '".$_POST['username']."', '".$_POST['password']."', '".$_POST['course_id']."', '".$_SESSION['center']['id']."', '".$image."', '".$sign."', '0')"); $id = mysqli_insert_id($con); $con->query("INSERT INTO `tbl_wallet`(`type`, `amount`, `user_id`, `user_type`,`message`) VALUES ('dr','".$admissionFee."','".$_SESSION['center']['id']."','center','student_register generated.')"); echo ''; } else { echo ''; } } else { echo ''; } } $max_id_query = $con->query("SELECT MAX(id) AS max_id FROM students"); $max_id_row = $max_id_query->fetch_assoc(); $new_id_no = $max_id_row['max_id'] + 1; ?>