Новичок
Покинул форум
Сообщений всего: 5
Дата рег-ции: Июль 2019
Помог: 0 раз(а)
|
Вот код php
PHP:
скопировать код в буфер обмена
<!doctype html> <html lang="ru"> <head> <meta charset="utf-8"> <title>Админ-панель</title> <style> .demotable { border-collapse: collapse; counter-reset: schetchik; } .demotable tbody tr:nth-child(n+2) { counter-increment: schetchik; } .demotable td, .demotable tbody tr:before { padding: .1em .5em; border: 1px solid #111111; } .demotable tbody tr:before { display: table-cell; vertical-align: middle; } .demotable tbody tr:before, .demotable b:after { content: counter(schetchik); color: #111111; } .demotable tbody tr:nth-child(-n+1):before { content: "№"; } #zatemnenie { width: 100%; height: 100%; position: relative; top: 0; left: 0; display: none; } #okno { width: 750px; height: 100%; text-align: relative; padding: 15px; border: 3px solid #35a764; border-radius: 10px; color: #111111; position: relative; top: 0; right: 0; bottom: 0; left: 0; margin: auto; background: #fff; } #zatemnenie:target {display: block;} .close { position: relative; display: inline-block; font-family: Arial,Helvetica,FreeSans,"Liberation Sans","Nimbus Sans L",sans-serif; font-size: 1.5em; font-weight: 700; color: rgb(245,245,245); text-shadow: 0 -1px rgba(0,0,0,.1); text-decoration: none; user-select: none; padding: .3em 1em; outline: none; border: none; border-radius: 3px; background: #0c9c0d linear-gradient(#82d18d, #0c9c0d); box-shadow: inset #72de26 0 -1px 1px, inset 0 1px 1px #98ff98, #3caa3c 0 0 0 1px, rgba(0,0,0,.3) 0 2px 5px; -webkit-animation: pulsate 1.2s linear infinite; animation: pulsate 1.2s linear infinite; } .close:hover { -webkit-animation-play-state: paused; animation-play-state: paused; cursor: pointer; } .close:active { top: 1px; color: #fff; text-shadow: 0 -1px rgba(0,0,0,.3), 0 0 5px #ffd, 0 0 8px #fff; box-shadow: 0 -1px 3px rgba(0,0,0,.3), 0 1px 1px #fff, inset 0 1px 2px rgba(0,0,0,.8), inset 0 -1px 0 rgba(0,0,0,.05); } @-webkit-keyframes pulsate { 50% {color: #fff; text-shadow: 0 -1px rgba(0,0,0,.3), 0 0 5px #ffd, 0 0 8px #fff;} } @keyframes pulsate { 50% {color: #fff; text-shadow: 0 -1px rgba(0,0,0,.3), 0 0 5px #ffd, 0 0 8px #fff;} } .close:hover {background: #e6e6ff;} </style> </head> <body> <?PHP $host = '192.168.77.88'; // Хост, у нас все локально $user = 'root'; // Имя созданного вами пользователя $pass = '59GtomaK18'; // Установленный вами пароль пользователю $db_name = 'register_db'; // Имя базы данных $link = mysqli_connect($host, $user, $pass, $db_name); // Соединяемся с базой // Ругаемся, если соединение установить не удалось if (!$link) { } //Если переменная Name передана if (isset($_POST["Card_number"])) { //Если это запрос на обновление, то обновляем if (isset($_GET['red_id'])) { $sql = mysqli_query($link, "UPDATE `data_db` SET `Card_number` = '{$_POST['Card_number']}',`Card_Date` = '{$_POST['Card_Date']}',`Card_Time` = '{$_POST['Card_Time']}',`Card_Department` = '{$_POST['Card_Department']}',`Card_Category` = '{$_POST['Card_Category']}',`Card_The_Service_Crew` = '{$_POST['Card_The_Service_Crew']}',`Card_Head_Of_The_Brigade` = '{$_POST['Card_Head_Of_The_Brigade']}',`Card_Time_Admission` = '{$_POST['Card_Time_Admission']}',`Card_Time_Car_Exits` = '{$_POST['Card_Time_Car_Exits']}',`Card_Time_Of_Arrival_Of_The_Car` = '{$_POST['Card_Time_Of_Arrival_Of_The_Car']}',`Card_Time_Is_Too_Late` = '{$_POST['Card_Time_Is_Too_Late']}',`Card_Post_Dispatcher_Support` = '{$_POST['Card_Post_Dispatcher_Support']}',`Card_Cause_Of_Delay` = '{$_POST['Card_Cause_Of_Delay']}',`Card_Cause_Of_Call_Diagnosis_Hospitalization` = '{$_POST['Card_Cause_Of_Call_Diagnosis_Hospitalization']}',`Card_Surname_And_Name_Of_The_Patient_And_Year` = '{$_POST['Card_Surname_And_Name_Of_The_Patient_And_Year']}',`Card_Calling_Address` = '{$_POST['Card_Calling_Address']}',`Card_Where_Delivered` = '{$_POST['Card_Where_Delivered']}',`Card_Destination` = '{$_POST['Card_Destination']}',`Card_Who_Is_Destination` = '{$_POST['Card_Who_Is_Destination']}',`Card_The_Cause_Of_Death` = '{$_POST['Card_The_Cause_Of_Death']}',`Card_Notes` = '{$_POST['Card_Notes']}' WHERE `ID`={$_GET['red_id']}"); } else { //Иначе вставляем данные, подставляя их в запрос $sql = mysqli_query($link, "INSERT INTO `data_db` (`Card_number`, `Card_Date`, `Card_Time`, `Card_Department`, `Card_Category`, `Card_The_Service_Crew`, `Card_Head_Of_The_Brigade`, `Card_Time_Admission`, `Card_Time_Car_Exits`, `Card_Time_Of_Arrival_Of_The_Car`, `Card_Time_Is_Too_Late`, `Card_Post_Dispatcher_Support`, `Card_Cause_Of_Delay`, `Card_Cause_Of_Call_Diagnosis_Hospitalization`, `Card_Surname_And_Name_Of_The_Patient_And_Year`, `Card_Calling_Address`, `Card_Where_Delivered`, `Card_Destination`, `Card_Who_Is_Destination`, `Card_The_Cause_Of_Death`, `Card_Notes`) VALUES ('{$_POST['Card_number']}','{$_POST['Card_Date']}', '{$_POST['Card_Time']}', '{$_POST['Card_Department']}', '{$_POST['Card_Category']}', '{$_POST['Card_The_Service_Crew']}', '{$_POST['Card_Head_Of_The_Brigade']}', '{$_POST['Card_Time_Admission']}', '{$_POST['Card_Time_Car_Exits']}', '{$_POST['Card_Time_Of_Arrival_Of_The_Car']}', '{$_POST['Card_Time_Is_Too_Late']}', '{$_POST['Card_Post_Dispatcher_Support']}', '{$_POST['Card_Cause_Of_Delay']}', '{$_POST['Card_Cause_Of_Call_Diagnosis_Hospitalization']}', '{$_POST['Card_Surname_And_Name_Of_The_Patient_And_Year']}', '{$_POST['Card_Calling_Address']}', '{$_POST['Card_Where_Delivered']}', '{$_POST['Card_Destination']}', '{$_POST['Card_Who_Is_Destination']}', '{$_POST['Card_The_Cause_Of_Death']}', '{$_POST['Card_Notes']}')"); } //Если вставка прошла успешно if ($sql) { echo '<p>Успешно!</p>'; } else { echo '<p>Произошла ошибка: ' . mysqli_error($link) . '</p>'; } } //Если передана переменная red_id, то надо обновлять данные. Для начала достанем их из БД if (isset($_GET['red_id'])) { $sql = mysqli_query($link, "SELECT `ID`, `Card_number`, `Card_Date`, `Card_Time`, `Card_Department`, `Card_Category`, `Card_The_Service_Crew`, `Card_Head_Of_The_Brigade`, `Card_Time_Admission`, `Card_Time_Car_Exits`, `Card_Time_Of_Arrival_Of_The_Car`, `Card_Time_Is_Too_Late`, `Card_Post_Dispatcher_Support`, `Card_Cause_Of_Delay`, `Card_Cause_Of_Call_Diagnosis_Hospitalization`, `Card_Surname_And_Name_Of_The_Patient_And_Year`, `Card_Calling_Address`, `Card_Where_Delivered`, `Card_Destination`, `Card_Who_Is_Destination`, `Card_The_Cause_Of_Death`, `Card_Notes` FROM `data_db` WHERE `ID`={$_GET['red_id']}"); } ?> <form action="" method="post"> <table class="table table-bordered gantry-center"> <tr> <td>З Дата и час картки:</td> <td>ПО Дата и час картки:</td> <tr> <td align="left" valign="top"><input type="date" size="20" name="with_Card_Date"><input type="time" size="10" name="with_Card_Time"></td> <td align="left" valign="top"><input type="date" size="20" name="on_Card_Date"><input type="time" size="10" name="on_Card_Time"></td> </tr> </tr> <tr> <td align="left" valign="top"><input type="submit" value="Ввести данні" class="close"></td> </tr> </table> </form> </div> </div> <table width="100%" cellspacing="0" cellpadding="4" border="1" class="demotable"> <center>Информация по опозданиях бригад на вызов з <?PHP echo "". $_POST['with_Card_Date']; ?> <?PHP echo " ". $_POST['with_Card_Time']; ?> по <?PHP echo "". $_POST['on_Card_Date']; ?> <?PHP echo " ". $_POST['on_Card_Time']; ?> <tr> <td> ID </td> <td> ID_Time </td> <td> № Картки </td> <td> Дата Картки и Час </td> <td> Отдел Картки </td> <td> Категория картки </td> <td> Картка Служба бригады </td> <td> Картка глава бригады </td> <td> Время регистрации / Времени выезда автомобиля / время прибытия / время опоздания </td> <td> Поддержка диспетчеров почтовых карточек </td> <td> Карточка причина задержки </td> <td> Карточка Причина диагностики вызовов Госпитализация </td> <td> Фамилия карты и имя пациента и год </td> <td> Адрес вызова карточки </td> <td> Карточка, где проставляется </td> <td> Назначение карточки </td> <td> Карточка, которая является назначением </td> <td> Карточка Причина смерти </td> <td> Заметки с карты </td> </tr> <?PHP $sql = mysqli_query($link, "SELECT `ID`, `ID_Time`, `Card_number`, `Card_Date`, `Card_Time`, `Card_Department`, `Card_Category`, `Card_The_Service_Crew`, `Card_Head_Of_The_Brigade`, `Card_Time_Admission`, `Card_Time_Car_Exits`, `Card_Time_Of_Arrival_Of_The_Car`, `Card_Time_Is_Too_Late`, `Card_Post_Dispatcher_Support`, `Card_Cause_Of_Delay`, `Card_Cause_Of_Call_Diagnosis_Hospitalization`, `Card_Surname_And_Name_Of_The_Patient_And_Year`, `Card_Calling_Address`, `Card_Where_Delivered`, `Card_Destination`, `Card_Who_Is_Destination`, `Card_The_Cause_Of_Death`, `Card_Notes` FROM `data_db` WHERE `Card_Date`>='{$_POST['with_Card_Date']}' AND `Card_Time`>='{$_POST['with_Card_Time']}' AND `Card_Date`<='{$_POST['on_Card_Date']}' AND `Card_Time`<='{$_POST['on_Card_Time'] }' "); echo '<tr>' . "<td> {$result['ID']} </td>" . "<td> {$result['ID_Time']} </td>" . "<td> {$result['Card_number']}</td>" . "<td> {$result['Card_Date']} {$result['Card_Time']} </td>" . "<td> {$result['Card_Department']} </td>" . "<td> {$result['Card_Category']} </td>" . "<td> {$result['Card_The_Service_Crew']} </td>" . "<td> {$result['Card_Head_Of_The_Brigade']} </td>" . "<td> {$result['Card_Time_Admission']} / {$result['Card_Time_Car_Exits']} / {$result['Card_Time_Of_Arrival_Of_The_Car']} / {$result['Card_Time_Is_Too_Late']} </td>" . "<td> {$result['Card_Post_Dispatcher_Support']} </td>" . "<td> {$result['Card_Cause_Of_Delay']} </td>" . "<td> {$result['Card_Cause_Of_Call_Diagnosis_Hospitalization']} </td>" . "<td> {$result['Card_Surname_And_Name_Of_The_Patient_And_Year']} </td>" . "<td> {$result['Card_Calling_Address']} </td>" . "<td> {$result['Card_Where_Delivered']} </td>" . "<td> {$result['Card_Destination']} </td>" . "<td> {$result['Card_Who_Is_Destination']} </td>" . "<td> {$result['Card_The_Cause_Of_Death']} </td>" . "<td> {$result['Card_Notes']} </td>" . '</tr>'; } ?> </table> <A HREF="javascript:window.print()" , class="close">Друк</a> </body> </html>
Вот база MySql
CODE ( SQL):
скопировать код в буфер обмена
-- -------------------------------------------------------- -- Сервер: 192.168.77.88 -- Версія сервера: 10.3.13-MariaDB - mariadb.org binary distribution -- ОС сервера: Win64 -- HeidiSQL Версія: 10.1.0.5464 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- Dumping database structure for register_db DROP DATABASE IF EXISTS `register_db`; CREATE DATABASE IF NOT EXISTS `register_db` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `register_db`; -- Dumping structure for таблиця register_db.data_db DROP TABLE IF EXISTS `data_db`; CREATE TABLE IF NOT EXISTS `data_db` ( `ID_Time` datetime DEFAULT current_timestamp(), `ID` int(11) NOT NULL AUTO_INCREMENT, `Card_number` char(50) DEFAULT NULL, `Card_Date` date DEFAULT current_timestamp(), `Card_Time` time DEFAULT current_timestamp(), `Card_Department` char(200) DEFAULT NULL, `Card_Category` char(200) DEFAULT NULL, `Card_The_Service_Crew` char(200) DEFAULT NULL, `Card_Head_Of_The_Brigade` char(200) DEFAULT NULL, `Card_Time_Admission` time DEFAULT NULL, `Card_Time_Car_Exits` time DEFAULT NULL, `Card_Time_Of_Arrival_Of_The_Car` time DEFAULT NULL, `Card_Time_Is_Too_Late` time DEFAULT NULL, `Card_Post_Dispatcher_Support` char(200) DEFAULT NULL, `Card_Cause_Of_Delay` char(200) DEFAULT NULL, `Card_Cause_Of_Call_Diagnosis_Hospitalization` char(200) DEFAULT NULL, `Card_Surname_And_Name_Of_The_Patient_And_Year` char(200) DEFAULT NULL, `Card_Calling_Address` char(200) DEFAULT NULL, `Card_Where_Delivered` char(200) DEFAULT NULL, `Card_Destination` char(200) DEFAULT NULL, `Card_Who_Is_Destination` char(200) DEFAULT NULL, `Card_The_Cause_Of_Death` char(200) DEFAULT NULL, `Card_Notes` char(255) DEFAULT NULL, `Join_Card_Date_And_Time` datetime DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8; -- Dumping data for table register_db.data_db: ~12 rows (приблизно) DELETE FROM `data_db`; /*!40000 ALTER TABLE `data_db` DISABLE KEYS */; INSERT INTO `data_db` (`ID_Time`, `ID`, `Card_number`, `Card_Date`, `Card_Time`, `Card_Department`, `Card_Category`, `Card_The_Service_Crew`, `Card_Head_Of_The_Brigade`, `Card_Time_Admission`, `Card_Time_Car_Exits`, `Card_Time_Of_Arrival_Of_The_Car`, `Card_Time_Is_Too_Late`, `Card_Post_Dispatcher_Support`, `Card_Cause_Of_Delay`, `Card_Cause_Of_Call_Diagnosis_Hospitalization`, `Card_Surname_And_Name_Of_The_Patient_And_Year`, `Card_Calling_Address`, `Card_Where_Delivered`, `Card_Destination`, `Card_Who_Is_Destination`, `Card_The_Cause_Of_Death`, `Card_Notes`, `Join_Card_Date_And_Time`) VALUES ('2019-07-08 12:23:39', 111, '123', '2019-08-02', '12:03:00', 'Город', 'ДТП.', '123', '13', '23:21:00', '23:01:00', '21:12:00', '03:13:00', '2132', '213', '123', '213123', '123', '123321', '231', '312', '213', '123', NULL), ('2019-07-08 12:24:51', 112, '1111', '2020-07-03', '12:03:00', 'Город', 'ДТП.', '123', '13', '23:21:00', '23:01:00', '21:12:00', '03:13:00', '2132', '213', '123', '213123', '123', '123321', '231', '312', '213', '123', '2019-07-15 11:20:07'), ('2019-07-08 12:27:01', 113, '123', '2019-07-02', '12:03:00', 'Город', 'ДТП.', '123', '13', '23:21:00', '23:01:00', '21:12:00', '03:13:00', '2132', '213', '123', '213123', '123', '123321', '231', '312', '213', '123', NULL), ('2019-07-08 12:29:53', 114, '4321', '2018-07-02', '12:03:00', 'Город', 'ДТП.', '123', '13', '23:21:00', '23:01:00', '21:12:00', '03:13:00', '2132', '213', '123', '213123', '123', '123321', '231', '312', '213', '123', NULL), ('2019-07-08 12:30:37', 115, '123', '2019-10-02', '12:03:00', 'Город', 'ДТП.', '123', '13', '23:21:00', '23:01:00', '21:12:00', '03:13:00', '2132', '213', '123', '213123', '123', '123321', '231', '312', '213', '123', NULL), ('2019-07-08 12:31:05', 116, '123', '2019-05-02', '12:03:00', 'Город', 'ДТП.', '123', '13', '23:21:00', '23:01:00', '21:12:00', '03:13:00', '2132', '213', '123', '213123', '123', '123321', '231', '312', '213', '123', NULL), ('2019-07-08 15:00:19', 119, '132', '2019-06-05', '12:12:00', 'Город', 'ГКС.', '12321', '123', '12:03:00', '12:03:00', '12:03:00', '12:23:00', '213', '123', '123', '4321', '123', '123', '123', '123', '1234', '123', NULL), ('2019-07-11 08:15:34', 172, '123', '2018-03-13', '12:23:00', 'Город', 'ДТП.', '123123', '123', '12:12:00', '12:03:00', '12:03:00', '21:03:00', '123', '123', '123', '123', '123', '1231', '12312', '123', '213', '123', NULL), ('2019-07-11 13:32:13', 195, '23', '2019-06-05', '12:13:00', 'Город', 'ДТП.', '123', '123', '21:03:00', '12:03:00', '12:03:00', '12:03:00', '12321', '123', '123', '123', '213', '213', '213', '12312', '123', '123', NULL), ('2019-07-11 14:19:40', 196, '123', '2019-10-08', '15:00:00', 'Город', 'ГКС.', '123', '123', '12:03:00', '12:03:00', '12:03:00', '12:03:00', '', '', '', '123', '', '', '', '', '', '', NULL), ('2019-07-11 16:22:27', 197, '123', '2019-01-09', '15:00:00', 'Город', 'ДТП.', '123', '123', '12:03:00', '12:03:00', '12:03:00', '12:03:00', '', '', '', '123', '', '', '', '', '', '', NULL), ('2019-07-12 14:45:31', 198, '123', '2019-02-01', '11:11:00', 'Город', 'ГКС.', '111111111', '111111111', '01:01:00', '01:01:00', '01:01:00', '01:01:00', '1111', '1111', '11111', '11111', '1111', '1111', '1111', '1111', '1111', '1111', NULL), ('2019-07-15 11:27:10', 205, '12', '1111-01-01', '01:01:00', 'Город', 'ДТП.', '12', '', '12:12:00', '12:12:00', '12:12:00', '12:12:00', '', '', '', '', '', '', '', '', '', '', NULL), ('2019-07-15 11:58:05', 207, '1111', '1111-11-11', '11:11:00', 'Город', 'ДТП.', '', '', '11:11:00', '11:11:00', '11:11:00', '11:11:00', '', '', '', '', '', '', '', '', '', '', NULL), ('2019-07-15 12:07:41', 209, '33333', '3333-03-31', '03:33:00', 'Город', 'ДТП.', '', '', '03:33:00', '03:33:00', '03:33:00', '03:33:00', '', '', '', '', '', '', '', '', '', '', NULL); /*!40000 ALTER TABLE `data_db` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Здесь формируется запрос в mysql
PHP:
скопировать код в буфер обмена
$sql = mysqli_query($link, "SELECT `ID`, `ID_Time`, `Card_number`, `Card_Date`, `Card_Time`, `Card_Department`, `Card_Category`, `Card_The_Service_Crew`, `Card_Head_Of_The_Brigade`, `Card_Time_Admission`, `Card_Time_Car_Exits`, `Card_Time_Of_Arrival_Of_The_Car`, `Card_Time_Is_Too_Late`, `Card_Post_Dispatcher_Support`, `Card_Cause_Of_Delay`, `Card_Cause_Of_Call_Diagnosis_Hospitalization`, `Card_Surname_And_Name_Of_The_Patient_And_Year`, `Card_Calling_Address`, `Card_Where_Delivered`, `Card_Destination`, `Card_Who_Is_Destination`, `Card_The_Cause_Of_Death`, `Card_Notes` FROM `data_db` WHERE `Card_Date`>='{$_POST['with_Card_Date']}' AND `Card_Time`>='{$_POST['with_Card_Time']}' AND `Card_Date`<='{$_POST['on_Card_Date']}' AND `Card_Time`<='{$_POST['on_Card_Time'] }' ");
И сама проблема в логике запроса вот здесь
PHP:
скопировать код в буфер обмена
WHERE `Card_Date`>='{$_POST['with_Card_Date']}' AND `Card_Time`>='{$_POST['with_Card_Time']}' AND `Card_Date`<='{$_POST['on_Card_Date']}' AND `Card_Time`<='{$_POST['on_Card_Time'] }' ");
Дело том что как не крутил Card_Time получается отделенным диапазоном от Card_Date.
Если вести з 2000-01-01 00:00 по 2020-01-01 23:59 то оно будет работать
так позволяет диапазон времени.
[img]https://i[dot]ibb[dot]co/3hqgxgh/1[dot]jpg[/img]
Но если написать 2000-01-01 00:00 по 2020-01-01 00:00. то оно не будет работать так как время з 00:00 по 00:00 не видит как сутки, если дата другая.
[img]https://i[dot]ibb[dot]co/9yTDkBH/2[dot]png[/img]
Какие есть варианты?(Отредактировано автором: 15 Июля, 2019 - 13:41:35)
|