بحث باليوم

# Delete All Records Today Button بحث باليوم

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT name, age, complain, national, gender, phone, date, location, time, id FROM patients WHERE date = ?"; $stmt = $conn->prepare($sql); if ($stmt) { $stmt->bind_param("s", $date); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { echo "

مرضي يوم " . htmlspecialchars($date) . "

"; echo ""; echo ""; echo ""; while ($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

الاسم	العمر	الشكوي	الرقم القومي	النوع	رقم الهاتف	التاريخ	العنوان	الوقت	حذف المريض
" . htmlspecialchars($row['name']) . "	" . htmlspecialchars($row['age']) . "	" . htmlspecialchars($row['complain']) . "	" . htmlspecialchars($row['national']) . "	" . htmlspecialchars($row['gender']) . "	" . htmlspecialchars($row['phone']) . "	" . htmlspecialchars($row['date']) . "	" . htmlspecialchars($row['location']) . "	" . htmlspecialchars($row['time']) . "	Delete

"; echo "

Total Results: " . $result->num_rows . "

"; echo ""; } else { echo "لا يوجد مرضي في هذا اليوم."; } echo "