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'; // Имя базы данных
- // Ругаемся, если соединение установить не удалось
- if (!$link) {
- echo 'Не могу соединиться с БД. Код ошибки: ' . mysqli_connect_errno() . ', ошибка: ' . mysqli_connect_error();
- exit;
- }
- //Если переменная Name передана
- //Если это запрос на обновление, то обновляем
- $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 {
- }
- }
- //Если передана переменная 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>