Guest User

Untitled

a guest
Jan 22nd, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.24 KB | None | 0 0
  1. add.js
  2. function addSession()
  3. {
  4. var tmp = document.querySelector('input[name = SessionNumber]');
  5. var tmp1 = document.querySelector('input[name = data]');
  6. var tmp2 = document.querySelector('input[name = Time]');
  7. var params = 'SessionNumber=' + tmp.value + '&' + 'data=' + tmp1.value + '&' + 'Time=' + tmp2.value;
  8. ajaxPost('addSessionSQL.php',params).then(resolve =>
  9. {
  10. var request = new XMLHttpRequest();
  11. request.open('POST', 'addSessionSQL.php', true);
  12. }).catch(reject =>
  13. {
  14. alert(reject);
  15. })
  16. }
  17.  
  18.  
  19. function ajaxPost(url, params)
  20. {
  21. return new Promise(function(resolve, reject)
  22. {
  23. var request = new XMLHttpRequest();
  24. request.open('POST',url,true);
  25. request.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded; charset=utf-8')
  26. request.addEventListener("load", function()
  27. {
  28. if(request.readyState == 4)
  29. {
  30. resolve(request.responseText);
  31. }
  32. else
  33. {
  34. reject(Error("Ошибка получения данных"));
  35. }
  36. });
  37. request.send(params);
  38. });
  39. }
  40. addManager.js
  41. function add()
  42. {
  43. var tmp = document.querySelector('input[name = managerName]');
  44. var tmp1 = document.querySelector('input[name = managerPassword]');
  45. var params = 'managerName=' + tmp.value + '&' + 'managerPassword=' + tmp1.value;
  46. ajaxPost('addManagerSQL.php',params).then(resolve =>
  47. {
  48. var request = new XMLHttpRequest();
  49. request.open('POST', 'addManagerSQL.php', true);
  50. }).catch(reject =>
  51. {
  52. alert(reject);
  53. })
  54. }
  55.  
  56.  
  57. function ajaxPost(url, params)
  58. {
  59. return new Promise(function(resolve, reject)
  60. {
  61. var request = new XMLHttpRequest();
  62. request.open('POST',url,true);
  63. request.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded; charset=utf-8');
  64. request.addEventListener("load", function()
  65. {
  66. if(request.readyState == 4)
  67. {
  68. resolve(request.responseText);
  69. }
  70. else
  71. {
  72. reject(Error("Ошибка получения данных"));
  73. }
  74. });
  75. request.send(params);
  76. });
  77. }
  78. addManager.php
  79. <!DOCTYPE html>
  80. <html>
  81. <head>
  82. <meta charset = "utf-8">
  83. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  84. </head>
  85. <body>
  86. <style type="text/css">
  87. body
  88. {
  89. background: url(https://avatanplus.com/files/resources/original/578659e361cb5155e4cf2049.jpg) no-repeat;
  90. background-size: 100%;
  91. }
  92. #l1 {
  93. width: 200px;
  94. }
  95. #l2{
  96. width: 200px
  97. }
  98. #l3{
  99. padding: 300px;
  100. }
  101. </style>
  102. <form>
  103. <div align="center" id="l3">
  104. <h4>Enter Manager Name:</h4>
  105. <input type = "text" name="managerName" class="form-control" id="l1">
  106. <h4>Enter Manager Password:</h4>
  107. <input type = "text" name="managerPassword" class="form-control" id="l2"><br>
  108. <input type="button" id = "send" value = "Add" onclick = "add()" class="btn btn-primary">
  109. </div>
  110. </form>
  111. <script src="addManager.js"></script>
  112.  
  113. </body>
  114. </html>
  115. <?php
  116. include("bd.php");
  117. $managerName = $_POST['managerName'];
  118. $managerPassword = $_POST['managerPassword'];
  119. echo $managerName;
  120. echo $managerPassword;
  121. mysql_query("INSERT INTO chackmanager (managername, password) VALUES ('$managerName', '$managerPassword')");
  122.  
  123.  
  124. ?>
  125. addSession.php
  126. <?php
  127. include("bd.php");
  128. session_start();
  129. $tableName = "SELECT * FROM byebilet";
  130. $result = mysql_query($tableName);
  131. ?>
  132. <!DOCTYPE html>
  133. <html>
  134. <head>
  135. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  136. <meta charset = "utf-8">
  137. </head>
  138. <body>
  139. <style type="text/css">
  140. #l1{
  141. width: 200px;
  142. }
  143. #l2{
  144. width: 200px;
  145. }
  146. #l3{
  147. width: 200px;
  148. }
  149. body
  150. {
  151. background: url(http://nevseoboi.com.ua/uploads/posts/2011-06/1307725562_wallpapers-by-famdoc-56_www.nevseoboi.com.ua.jpg) no-repeat;
  152. background-size: 100%;
  153. }
  154. </style>
  155. <form >
  156. <div align="center">
  157. Session Number:<br>
  158. <div id="l1">
  159. <input type = "text" name="SessionNumber" id="dir" class="form-control"><br>
  160. </div>
  161. Data:<br>
  162. <div id="l2"><input type = "date" name="data" id="dat" class="form-control"><br>
  163. </div>
  164. Time:<br>
  165. <div id="l3"> <input type = "time" name="Time" id="Ti" class="form-control"><br>
  166. </div>
  167. <input type="button" id = "send" value = "Add" onclick = "addSession()" class="btn btn-success" >
  168. </div>
  169. </form>
  170. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  171. <tr>
  172. <th>Date</th>
  173. <th>Time</th>
  174. <th>Cost</th>
  175. <th>Visitor</th>
  176. </tr>
  177. <?php
  178. while($row = mysql_fetch_assoc($result))
  179. {
  180. echo "<tr>";
  181. echo "<td> {$row['Date']}</td> ";
  182. echo "<td> {$row['Time']}</td> ";
  183. echo "<td> {$row['Cost']}</td> ";
  184. echo "<td> {$row['visitor']}</td> ";
  185. }
  186. ?>
  187. <script src="add.js"></script>
  188.  
  189. </body>
  190. </html>
  191. addSessionSQL
  192. <?php
  193. include("bd.php");
  194. $session = $_POST['SessionNumber'];
  195. $date = $_POST['data'];
  196. $time = $_POST['Time'];
  197. $res = mysql_query("INSERT INTO byebilet (Date, Time, Number_session) VALUES ('$date', '$time', '$session')");
  198.  
  199. ?>
  200. Admin.php
  201.  
  202. <!DOCTYPE html>
  203. <html>
  204. <head>
  205. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  206. <meta charset="utf-8">
  207. </head>
  208. <header>
  209. </header>
  210. <body>
  211. <style type="text/css">
  212. #l1{
  213. width: 200px;
  214. }
  215. #l2{
  216. width: 200px;
  217. }
  218. body
  219. {
  220. background: url(http://nevseoboi.com.ua/uploads/posts/2012-04/1335177760-166416-0071762_www.nevseoboi.com.ua.jpg) no-repeat;
  221. background-size: 100%;
  222. }
  223. #l4{
  224. padding: 100px;
  225. }
  226. </style>
  227. <form method="POST" action = /chackAdmin.php>
  228. <div align="center" id="l4">
  229. <h4><label for = "adminname">Enter your login</label></h4>
  230. <input type="text" name="adminname" id="l1" class="form-control">
  231. <h4><label for = "password">Enter your password</label></h4></form>
  232. <input type="password" name="password" id="l2" class="form-control">
  233. <h4><button name = "submit" class="btn btn-primary">Go Home</button></h4>
  234. </div>
  235. </form>
  236. }
  237. </body>
  238. </html>
  239. bd.php
  240. <?php
  241. $db = mysql_connect('127.0.0.1','root', '');
  242. mysql_select_db('lab1', $db);
  243. ?>
  244. bye_bilet.php
  245.  
  246. <!DOCTYPE html>
  247. <html>
  248. <meta charset="utf-8">
  249. <header>
  250. </header>
  251. <body>
  252. <input id="shop_ip" type="submit" value="Bye Bilet" >
  253. <div id="myByes"></div>
  254.  
  255. <script src="ajax.js"></script>
  256. </body>
  257. </html>
  258. bye_Bilet.php
  259. <?php
  260. include("bd.php");
  261. $message = $_POST['add'];
  262. $command = $_POST['command'];
  263. $name = $_POST['Name'];
  264. $surname = $_POST['Surname'];
  265. $res = mysql_query("SELECT visitor FROM byebilet WHERE Number_session = '$message'");
  266. $row = mysql_fetch_assoc($res);
  267. $result = $row['visitor'] + 1;
  268. mysql_query("UPDATE byebilet SET visitor = '$result' WHERE Number_session = $message", $db);
  269. mysql_query("INSERT INTO purchase_information (Name, Surname, Number_session) VALUES ('$name', '$surname', '$message')");
  270. ?>
  271. Chack_manager.php
  272. <?php
  273.  
  274. session_start();
  275. include("bd.php");
  276. if(empty($_POST['managername']) || empty($_POST['password']))
  277. {
  278. exit("Sorry");
  279. }
  280. $managername = $_POST['managername'];
  281. $password = $_POST['password'];
  282.  
  283.  
  284. $result = mysql_query("SELECT * FROM chackmanager WHERE managername='$managername'", $db);
  285. $re = mysql_fetch_array($result);
  286. if($re['managername'] != null)
  287. {
  288. if($password == $re['password'])
  289. {
  290. header("Location: /museumForManager.php");
  291. exit;
  292. }
  293. else
  294. exit("sorry");
  295. }
  296. else
  297. exit("sor");
  298.  
  299. ?>
  300. chackAdmin.php
  301. <?php
  302.  
  303. session_start();
  304. include("bd.php");
  305. if(empty($_POST['adminname']) || empty($_POST['password']))
  306. {
  307. exit("Sorry");
  308. }
  309. $adminname = $_POST['adminname'];
  310. $password = $_POST['password'];
  311.  
  312.  
  313. $result = mysql_query("SELECT * FROM check_admin WHERE adminname='$adminname'", $db);
  314. $re = mysql_fetch_array($result);
  315. if($re['adminname'] != null)
  316. {
  317. if($password == $re['password'])
  318. {
  319. header("Location: /mainAdmin.php");
  320. exit;
  321. }
  322. else
  323. exit("sorry");
  324. }
  325. else
  326. exit("sor");
  327.  
  328. ?>
  329. Check_admin_button.php
  330. <?php
  331. $add = $_POST['Change_Session'];
  332. $addManager = $_POST['AddManager'];
  333. $deleteSession = $_POST['Delete_Session'];
  334. $deleteManager = $_POST['DeleteManager'];
  335. if($add == '2')
  336. {
  337. header('Location: /addSession.php');
  338. }
  339. if($addManager == '3')
  340. {
  341. header('Location: /addManager.php');
  342. }
  343. if($deleteSession == '4')
  344. {
  345. header('Location: /deleteSession.php');
  346. }
  347. if($deleteManager == '5')
  348. {
  349. header('Location: /deleteManager.php');
  350. }
  351. ?>
  352. check_button.php
  353. <?php
  354. $museum = $_POST['Museum'];
  355. $dateSession = $_POST['date_Session'];
  356. if($museum == '2')
  357. {
  358. header('Location: /museumExhibit.php');
  359. }
  360. if($dateSession == '3')
  361. {
  362. header('Location: /dateSession.php');
  363. }
  364. ?>
  365. Check_button_manager.php
  366. <?php
  367. $add = $_POST['add'];
  368. $delete = $_POST['delete'];
  369. if($add == '2')
  370. {
  371. header('Location: /addSession.php');
  372. }
  373. if($delete == '3')
  374. {
  375. header('Location: /deleteSession.php');
  376. }
  377. ?>
  378. check_user.php
  379. <?php
  380.  
  381. session_start();
  382. include("bd.php");
  383. if(empty($_POST['username']) || empty($_POST['password']))
  384. {
  385. exit("Sorry");
  386. }
  387. $username = $_POST['username'];
  388. $password = $_POST['password'];
  389.  
  390.  
  391. $result = mysql_query("SELECT * FROM signup WHERE username='$username'", $db);
  392. $re = mysql_fetch_array($result);
  393. if($re['username'] != null)
  394. {
  395. if($password == $re['password'])
  396. {
  397. $_SESSION['id'] = $re['user_id'];
  398. $_SESSION['username'] = $re['username'];
  399. header("Location: /museum.php");
  400. exit;
  401. }
  402. else
  403. exit("sorry");
  404. }
  405. else
  406. exit("sor");
  407.  
  408. ?>
  409. Comment.js
  410. var form = document.getElementById("commentForm");
  411.  
  412. form.onsubmit = function (e){
  413. e.preventDefault();
  414. var comment = document.getElementById("comment").value;
  415. var xhr = new XMLHttpRequest();
  416.  
  417. var body = "comment=" + encodeURIComponent(comment);
  418.  
  419. xhr.open("POST", 'Comment.php', true);
  420. xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
  421. xhr.send(body);
  422.  
  423. xhr.onreadystatechange = function () {
  424. if (xhr.readyState == 4 && xhr.status == 200){
  425.  
  426. var res = JSON.parse(xhr.responseText);
  427. console.log(xhr.responseText);
  428.  
  429.  
  430. for (prop in res){
  431. var div = document.createElement("div");
  432. var p = document.createElement("p");
  433. var parentEl = document.getElementById("comments");
  434. div.className = 'commentItem';
  435. p.innerHTML = res[prop];
  436. div.appendChild(p);
  437. parentEl.appendChild(div);
  438. }
  439. }
  440.  
  441. }
  442. }
  443. Comment.php
  444. <?php
  445. include("bd.php");
  446.  
  447. $comment = $_POST['comment'];
  448.  
  449. $result=mysql_query("INSERT INTO `comments`( `user_comment`) VALUES ('$comment')");
  450.  
  451. echo json_encode(getComments($db));
  452.  
  453. function getComments($db) {
  454. $result=mysql_query("SELECT * FROM `comments` WHERE `id` = (SELECT MAX(id) FROM `comments`)",$db);
  455. $res = array();
  456. while($r = mysql_fetch_array($result)){
  457. $res[$r['id']] = $r['user_comment'];
  458. }
  459. return $res;
  460. }
  461.  
  462. ?>
  463. dateSession.php
  464. <?php
  465. include("bd.php");
  466. session_start();
  467. $tableName = "SELECT * FROM byebilet";
  468. $result = mysql_query($tableName);
  469. ?>
  470. <!DOCTYPE html>
  471. <html>
  472. <head>
  473. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  474. <meta charset="utf-8">
  475. </head>
  476. <header>
  477. </header>
  478. <body>
  479. <style >
  480. body
  481. {
  482. background: url(https://w-dog.ru/wallpapers/12/16/345088709296079/polyarnoe-siyanie-yasno-sinij.jpg) no-repeat;
  483. background-size: 100%;
  484.  
  485. }
  486. #Bye{
  487. width: 200px;
  488. }
  489. #Name{
  490. width: 200px;
  491. }
  492. #Surname{
  493. width: 200px;
  494. }
  495. </style>
  496. <div align="center">
  497. <h3><p id = "number_session" >Enter session number</p></h3>
  498. <input type="value" name="Bye" id="Bye" class="form-control" >
  499. <h3> <p>Enter your name</p></h3>
  500. <input type="value" name="name" id="Name" class="form-control">
  501. <h3><p>Enter your surname</p></h3>
  502. <input type="value" name="surname" id="Surname" class="form-control"> <br>
  503. <input type="button" value="Bye" id="bye_session" name="Bye Bilet" onclick="add()" class="btn btn-primary"><br>
  504. <div id="Ent"></div>
  505. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  506. <tr>
  507. <th>Дата</th>
  508. <th>Время</th>
  509. <th>Стоимость</th>
  510. <th>Статус</th>
  511. <th>Номер сессии</th>
  512. </tr>
  513. </div>
  514. <?php
  515. while($row = mysql_fetch_assoc($result))
  516. {
  517. echo "<tr>";
  518. echo "<td> {$row['Date']}</td> ";
  519. echo "<td> {$row['Time']}</td> ";
  520. echo "<td> {$row['Cost']}</td> ";
  521. echo "<td> {$row['status']}</td> ";
  522. echo "<td> {$row['Number_session']}</td> ";
  523. }
  524. ?>
  525. <script src="Enter.js"></script>
  526. </body>
  527. </html>
  528. deleteManager.js
  529. function delSession()
  530. {
  531. var tmp = document.querySelector('input[name = managerPassword]');
  532. var params = 'managerPassword=' + tmp.value;
  533. ajaxPost('deleteManagerSQL.php',params).then(resolve =>
  534. {
  535. var request = new XMLHttpRequest();
  536. request.open('POST', 'deleteManagerSQL.php', true);
  537. }).catch(reject =>
  538. {
  539. alert(reject);
  540. })
  541. }
  542.  
  543.  
  544. function ajaxPost(url, params)
  545. {
  546. return new Promise(function(resolve, reject)
  547. {
  548. var request = new XMLHttpRequest();
  549. request.open('POST',url,true);
  550. request.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded; charset=utf-8');
  551. request.addEventListener("load", function()
  552. {
  553. if(request.readyState == 4)
  554. {
  555. resolve(request.responseText);
  556. }
  557. else
  558. {
  559. reject(Error("Ошибка получения данных"));
  560. }
  561. });
  562. request.send(params);
  563. });
  564. }
  565. deleteManager.php
  566. <?php
  567. include("bd.php");
  568. session_start();
  569. $tableName = "SELECT * FROM chackmanager";
  570. $result = mysql_query($tableName);
  571. ?>
  572. <!DOCTYPE html>
  573. <html>
  574. <head>
  575. <meta charset = "utf-8">
  576. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  577. </head>
  578. <body>
  579. <style type="text/css">
  580. #dir{
  581. width: 200px;
  582. }
  583. #l2{
  584. padding: 100px;
  585. }
  586. body
  587. {
  588. background: url(https://avatanplus.com/files/resources/original/578659e361cb5155e4cf2049.jpg) no-repeat;
  589. background-size: 100%;
  590. }
  591. </style>
  592. <form align = "center" id="l2">
  593. Enter Manager Password:<br>
  594. <div align="center">
  595. <input type = "text" name="managerPassword" id="dir" class="form-control" ><br>
  596. </div>
  597. <input type="button" id = "send" value = "Delete" onclick = "delSession()" class="btn btn-primary" >
  598. </form>
  599. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  600. <tr>
  601. <th>Name</th>
  602. <th>Password</th>
  603. </tr>
  604. <?php
  605. while($row = mysql_fetch_assoc($result))
  606. {
  607. echo "<tr>";
  608. echo "<td> {$row['managername']}</td> ";
  609. echo "<td> {$row['password']}</td> ";
  610. }
  611. ?>
  612. <div id = "resulte"></div>
  613. <script src="deleteManager.js"></script>
  614.  
  615. </body>
  616. </html>
  617. deleteManagerSQL.php
  618. <?php
  619. include("bd.php");
  620. $password = $_POST['managerPassword'];
  621. echo $_POST['managerPassword'];
  622. mysql_query("DELETE FROM chackmanager WHERE password = '$password'");
  623.  
  624. ?>
  625. deleteSession.js
  626. function delSession()
  627. {
  628. var tmp = document.querySelector('input[name = SessionNumber]');
  629. var params = 'SessionNumber=' + tmp.value;
  630. ajaxPost('deleteSessionInJS.php',params).then(resolve =>
  631. {
  632. var request = new XMLHttpRequest();
  633. request.open('POST', 'deleteSessionInJS.php', true);
  634. }).catch(reject =>
  635. {
  636. alert(reject);
  637. })
  638. }
  639.  
  640.  
  641. function ajaxPost(url, params)
  642. {
  643. return new Promise(function(resolve, reject)
  644. {
  645. var request = new XMLHttpRequest();
  646. request.open('POST',url,true);
  647. request.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded; charset=utf-8');
  648. request.addEventListener("load", function()
  649. {
  650. if(request.readyState == 4)
  651. {
  652. resolve(request.responseText);
  653. }
  654. else
  655. {
  656. reject(Error("Ошибка получения данных"));
  657. }
  658. });
  659. request.send(params);
  660. });
  661. }
  662. deleteSession.php
  663. <?php
  664. include("bd.php");
  665. session_start();
  666. $tableName = "SELECT * FROM byebilet";
  667. $result = mysql_query($tableName);
  668. ?>
  669. <!DOCTYPE html>
  670. <html>
  671. <head>
  672. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  673. <meta charset = "utf-8">
  674. </head>
  675. <body>
  676. <style type="text/css">
  677. body
  678. {
  679. background: url(https://million-wallpapers.ru/wallpapers/6/37/291342595391423.jpg) no-repeat;
  680. background-size: 100%;
  681. }
  682. </style>
  683. <form>
  684. <h4><div align="center">
  685. Enter Session Number:<br>
  686. </div> </h4>
  687. <div align="center">
  688. <input type = "text" name="SessionNumber" id="dir" ><br>
  689. </div>
  690. <div align="center">
  691. <input type="button" id = "send" value = "Delete" onclick = "delSession()" class="btn btn-primary" >
  692. </div>
  693. </form>
  694. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  695. <tr>
  696. <th>Date</th>
  697. <th>Time</th>
  698. <th>Cost</th>
  699. <th>Visitor</th>
  700. <th>Session Number</th>
  701. </tr>
  702. <?php
  703. while($row = mysql_fetch_assoc($result))
  704. {
  705. echo "<tr>";
  706. echo "<td> {$row['Date']}</td> ";
  707. echo "<td> {$row['Time']}</td> ";
  708. echo "<td> {$row['Cost']}</td> ";
  709. echo "<td> {$row['visitor']}</td> ";
  710. echo "<td> {$row['Number_session']}</td> ";
  711. }
  712. ?>
  713. <div id = "resulte"></div>
  714. <script src="deleteSession.js"></script>
  715.  
  716. </body>
  717. </html>
  718. deleteSessionInJS.php
  719. <?php
  720. include("bd.php");
  721. $session = $_POST['SessionNumber'];
  722. echo $_POST['SessionNumber'];
  723. mysql_query("DELETE FROM byebilet WHERE Number_session = '$session'");
  724.  
  725. ?>
  726. Enter.js
  727.  
  728.  
  729. function add()
  730. {
  731. let tmp = document.getElementById('Bye').value;
  732. let tmp1 = document.getElementById('Name').value;
  733. let tmp2 = document.getElementById('Surname').value;
  734. let params = 'command=add&&add='+ tmp + '&' + 'Name=' + tmp1 + '&' + 'Surname=' + tmp2;
  735. ajaxPost('byeBilet.php',params).then(resolve =>
  736. {
  737. var request = new XMLHttpRequest();
  738. request.open('POST', 'byeBilet.php', true);
  739. }).catch(reject =>
  740. {
  741. alert(reject);
  742. })
  743. }
  744.  
  745.  
  746. function ajaxPost(url, params)
  747. {
  748. return new Promise(function(resolve, reject)
  749. {
  750. var request = new XMLHttpRequest();
  751. request.open('POST',url,true);
  752. request.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded; charset=utf-8')
  753. request.addEventListener("load", function()
  754. {
  755. if(request.readyState == 4)
  756. {
  757. resolve(request.responseText);
  758. }
  759. else
  760. {
  761. reject(Error("Ошибка получения данных"));
  762. }
  763. });
  764. request.send(params);
  765. });
  766. }
  767. exit.php
  768. <?php
  769. session_start();
  770. unset($_SESSION['username']);
  771.  
  772.  
  773. header("Location: index.php");
  774. exit();
  775. ?>
  776. extibit.js
  777.  
  778. window.onload = function()
  779. {
  780. document.querySelector('#extp').onclick = function()
  781. {
  782. ajaxPOST();
  783. }
  784. document.querySelector('#del').onclick = function()
  785. {
  786. ajaxDel();
  787. }
  788. }
  789. function ajaxPOST()
  790. {
  791.  
  792. var request = new XMLHttpRequest();
  793. request.onreadystatechange = function()
  794. {
  795. if(request.readyState == 4)
  796. {
  797. document.querySelector('#showExtp').innerHTML = request.responseText;
  798. }
  799. }
  800.  
  801. request.open('POST', 'ExtibitionJs.php');
  802. request.send();
  803.  
  804. }
  805. function ajaxDel()
  806. {
  807.  
  808. var request = new XMLHttpRequest();
  809. request.onreadystatechange = function()
  810. {
  811. if(request.readyState == 4)
  812. {
  813. document.querySelector('#showExtp').innerHTML = "";
  814. }
  815. }
  816.  
  817. request.open('POST', 'ExtibitionJs.php');
  818. request.send();
  819.  
  820. }
  821.  
  822.  
  823. ExtibitionJs.php
  824. <!DOCTYPE html>
  825. <html>
  826. <head>
  827. <meta charset="utf-8">
  828. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  829. </head>
  830. <header>
  831. </header>
  832. <body id="body">
  833. <style type="text/css">
  834. #l1{
  835. padding: 3px;
  836. }
  837. </style>
  838. <div id="myByes">
  839. <h4><div>
  840. The rest can be seen in the museum</div></h4>
  841.  
  842. <img src="http://ancbs.ucoz.ru/Nyus/Nyus/eksponat_iz_ermitazha.jpg" class="rounded"><br>
  843. <div align="center left" id="l1">
  844. <img src="http://www.sobaka.ru/images/post/00/03/09/30/_large.jpg" class="rounded">
  845. </div>
  846. </div>
  847. </body>
  848. </html>
  849. formforBilet.php
  850. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  851. <tr>
  852. <th>Дата</th>
  853. <th>Время</th>
  854. <th>Стоимость</th>
  855. <th>Статус</th>
  856. <th>Номер сессии</th>
  857. </tr>
  858. <script src="Enter.js"></script>
  859. <?php
  860. $_SESSION['bil'] = $_POST['Bye'];
  861. while($row = mysql_fetch_assoc($result))
  862. {
  863. echo "<tr>";
  864. echo "<td> {$row['Date']}</td> ";
  865. echo "<td> {$row['Time']}</td> ";
  866. echo "<td> {$row['Cost']}</td> ";
  867. echo "<td> {$row['status']}</td> ";
  868. echo "<td> {$row['Number_session']}</td> ";
  869. }
  870. ?>
  871. Index.php
  872. <?php
  873. session_start();
  874. ?>
  875. <!DOCTYPE html>
  876. <html>
  877. <head>
  878. <meta charset="utf-8">
  879. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  880. <title>Main page</title>
  881. </head>
  882. <body>
  883. <style >
  884. body
  885. {
  886. background: url(https://i.pinimg.com/originals/b6/45/21/b645213afd23b2954a00e11afe35515d.jpg) no-repeat;
  887. background-size: 100%;
  888. }
  889. </style>
  890. <h1>
  891. <div align="center">Main page</div>
  892. </h1>
  893. <form method="POST" action="check_user.php">
  894. <div id="l1">
  895. <h4 align="center">
  896. <p>
  897. <label >Your login</label><br>
  898. <div align="center">
  899. <input type="text" name="username" class="form-control" id="l3">
  900. </div>
  901. </p>
  902. <p>
  903. <label>Your password</label><br>
  904. <div align="center">
  905. <input type="password" name="password" class="form-control" id="l2">
  906. </div>
  907. </p>
  908. </h4>
  909. <h4 align = "center">
  910. <p>
  911. <button id="button" class="btn btn-outline-info">Enter to website</button><br>
  912. <a href="/signup.php">Registration</a><br>
  913. <a href="manager.php">log in as manager</a><br>
  914. <a href="admin.php">
  915. log in as administrator</a>
  916. </p>
  917. </h4>
  918. </div>
  919. </form>
  920. <style type="text/css">
  921. #l1 {
  922. padding: 100px;
  923. }
  924. #l2 {
  925. width: 300px;
  926. }
  927. #l3 {
  928. width: 300px;
  929. }
  930. </style>
  931. <?php
  932. if(!empty($_SESSION['username']))
  933. echo "<h3 align = 'center'<br>HELLO ".$_SESSION['username']." <form method = 'POST' action = 'exit.php'><h2 align = 'center'><button>Exit</h2></form>";
  934. ?>
  935. </body>
  936. </html>
  937. mainAdmin.php
  938.  
  939. <!DOCTYPE html>
  940. <html>
  941. <head>
  942. <meta charset="utf-8">
  943. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  944. </head>
  945. <header>
  946. </header>
  947. <body>
  948. <style type="text/css">
  949. body
  950. {
  951. background: url(http://elitefon.ru/pic/201211/1920x1200/elitefon.ru-10091.jpg) no-repeat;
  952. background-size: 100%;
  953. }
  954. </style>
  955. <form method="POST" action="check_admin_button.php" align = "center">
  956. <h3><p>Welcome to the home Admin</p></h3>
  957. <button type="submit" name="Change_Session" value="2" class="btn btn-primary">Change Session</button>
  958. <button type="submit" name="Delete_Session" value="4" class="btn btn-primary">Delete Session</button>
  959. <button type="submit" name="AddManager" value="3" class="btn btn-primary">Add Manager</button>
  960. <button type="submit" name="DeleteManager" value="5" class="btn btn-primary">Delete Manager</button>
  961. </form>
  962. </div>
  963. </body>
  964. </html>
  965. Manager.php
  966.  
  967. <!DOCTYPE html>
  968. <html>
  969. <meta charset="utf-8">
  970. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  971. <header>
  972. </header>
  973. <body>
  974. <style type="text/css">
  975. body
  976. {
  977. background: url(http://bgfons.com/upload/light_texture2254.jpg) no-repeat;
  978. background-size: 100%;
  979. }
  980. #l1{
  981. padding: 200px;
  982. }
  983. #l2{
  984. width: 200px;
  985. }
  986. #l3{
  987. width: 200px;
  988. }
  989. </style>
  990. <form method="POST" action = /chack_manager.php>
  991. <div align="center" id="l1">
  992. <label for = "managername">Enter your login</label> <br>
  993. <div id="l2">
  994. <input type="text" name="managername" class="form-control"><br>
  995. </div>
  996. <label for = "password">Enter your password</label><br>
  997. <div id="l3">
  998. <input type="password" name="password" class="form-control"><br>
  999. </div>
  1000. <button name = "submit" class="btn btn-primary">
  1001. login to account</button>
  1002. </div>
  1003. </form>
  1004. }
  1005. </body>
  1006. </html>
  1007. museum.php
  1008. <!DOCTYPE html>
  1009. <html lang="en">
  1010. <head>
  1011. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  1012.  
  1013. <meta charset="UTF-8">
  1014. <title>Title</title>
  1015. </head>
  1016. <style >
  1017. body
  1018. {
  1019. background: url(https://image.freepik.com/free-photo/no-translate-detected_1962-94.jpg) no-repeat;
  1020. background-size: 100%;
  1021. }
  1022. #l1{
  1023. padding: 100px;
  1024. }
  1025. </style>
  1026. <form method = "POST" action="check_button.php" align = "center">
  1027. <button type="submit" name = "Museum" value="2" class="btn btn-secondary btn-lg active">What is in our Museum</button><br><br>
  1028. <button type="submit" name = "date_Session" value="3" class="btn btn-secondary btn-lg active">View the date of the session</button>
  1029. </form>
  1030. <body>
  1031. <div align="center" id="l1">
  1032. <div id="posts">
  1033. <div>
  1034. <form id="commentForm">
  1035. <div>
  1036. <h2><label for="comment">
  1037. leave your review about the museum</label></h2>
  1038. </div>
  1039. <div>
  1040. <textarea name="comment" id="comment"></textarea>
  1041. </div>
  1042. <button type="submit" name="button" class="btn btn-secondary btn-lg active">Send</button>
  1043. </form>
  1044. </div>
  1045. <div id="comments">
  1046. <h2>
  1047. User Comments</h2>
  1048. <div class="commentItem">
  1049. <h4><p class="commentText">
  1050. Your comments will be displayed here:
  1051. </p></h4>
  1052. </div>
  1053.  
  1054. </div>
  1055. </div>
  1056. <input id="showAll" type="submit" value="showAllComments" class="btn btn-secondary btn-lg active">
  1057. <div id="SHOW"></div>
  1058. <script src="showAll.js"></script>
  1059.  
  1060. <script src="Comment.js"> </script>
  1061.  
  1062. </body>
  1063. </html>
  1064. museumExhibit.php
  1065.  
  1066. <!DOCTYPE html>
  1067. <html>
  1068. <head>
  1069. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  1070. <meta charset="utf-8">
  1071. </head>
  1072. <header>
  1073. </header>
  1074. <body>
  1075. <style type="text/css">
  1076. #l1{
  1077. padding: 2px
  1078. }
  1079. body
  1080. {
  1081. background: url(https://www.passionforum.ru/upload/181/u18120/012/004f5f20.jpg) no-repeat;
  1082. background-size: 100%;
  1083.  
  1084. }
  1085. </style>
  1086. <div align="center" id="l1">
  1087. <input id="extp" type="submit" value="Our exhibit" class="btn btn-primary"></div>
  1088. <div align="center" >
  1089. <input id="del" type="submit" value="DELETE" class="btn btn-primary">
  1090. </div>
  1091. <div><p>Текст из сайта.</p></div>
  1092. <div id="di">
  1093. <div id="showExtp"></div>
  1094. </div>
  1095. </body>
  1096. <script src="extibit.js"></script>
  1097. </html>
  1098. museumForManager.php
  1099. <?php
  1100. include("bd.php");
  1101. session_start();
  1102. $tableName = "SELECT * FROM byebilet";
  1103. $result = mysql_query($tableName);
  1104. $user_info = "SELECT * FROM purchase_information";
  1105. $info = mysql_query($user_info);
  1106. ?>
  1107. <!DOCTYPE html>
  1108. <html>
  1109. <head>
  1110. <meta charset="utf-8">
  1111. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  1112. </head>
  1113. <header>
  1114. </header>
  1115. <body>
  1116. <style type="text/css">
  1117. #l1{
  1118. padding: 150px;
  1119. }
  1120. body
  1121. {
  1122. background: url(http://gdefon.org/_ph/1/782908514.jpg) no-repeat;
  1123. background-size: 100%;
  1124. }
  1125. </style>
  1126. <form method = "POST" action="check_button_manager.php" align = "center" id="l1">
  1127. <button type="submit" name = "add" value="2" class="btn btn-primary">Add Session</button>
  1128. <button type="submit" name = "delete" value="3" class="btn btn-primary">Delete Session</button>
  1129. </form>
  1130. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  1131. <h4><p align = "center">Info about Session</p></h4>
  1132. <tr>
  1133. <th>Date</th>
  1134. <th>Time</th>
  1135. <th>Cost</th>
  1136. <th>Visitor</th>
  1137. </tr>
  1138. <?php
  1139. while($row = mysql_fetch_assoc($result))
  1140. {
  1141. echo "<tr>";
  1142. echo "<td> {$row['Date']}</td> ";
  1143. echo "<td> {$row['Time']}</td> ";
  1144. echo "<td> {$row['Cost']}</td> ";
  1145. echo "<td> {$row['visitor']}</td> ";
  1146. }
  1147. ?>
  1148. <table border = "2" align = "center" width = "50%" bgcolor = "#00fefb">
  1149. <h4><p align = "center">Info about User</p></h4>
  1150. <tr>
  1151. <th>Name</th>
  1152. <th>Surname</th>
  1153. <th>Number Session</th>
  1154. </tr>
  1155. <?php
  1156. while($user = mysql_fetch_assoc($info))
  1157. {
  1158. echo "<tr>";
  1159. echo "<td> {$user['Name']}</td> ";
  1160. echo "<td> {$user['Surname']}</td> ";
  1161. echo "<td> {$user['Number_session']}</td> ";
  1162. }
  1163. ?>
  1164. </body>
  1165. </html>
  1166. newComment.php
  1167. <?php
  1168. include("bd.php");
  1169. $comment = $_POST['ToSend'];
  1170.  
  1171. $res = mysql_query("INSERT INTO user_comment (comment) VALUES ('$comment')");
  1172.  
  1173.  
  1174. ?>
  1175.  
  1176. save_user.php
  1177. <?php
  1178. include("bd.php");
  1179. if(empty($_POST['username']) || empty($_POST['password1']) || empty($_POST['password2']))
  1180. {
  1181. exit("Sorry");
  1182. }
  1183. $username = $_POST['username'];
  1184. $password1 = $_POST['password1'];
  1185. $password2 = $_POST['password2'];
  1186.  
  1187. if($password1 != $password2)
  1188. {
  1189. exit("Sorry-password");
  1190. }
  1191.  
  1192. $result = mysql_query("SELECT * FROM signup WHERE username='$username'", $db);
  1193. $re = mysql_fetch_array($result);
  1194. if($re['username'] == 0)
  1195. {
  1196. $res = mysql_query("INSERT INTO signup (username, password) VALUES ('$username', '$password1')");
  1197. header("Location: /index.php");
  1198. exit();
  1199. }
  1200. else
  1201. {
  1202. exit("sor");
  1203. }
  1204.  
  1205. ?>
  1206. showAll.js
  1207.  
  1208. window.onload = function()
  1209. {
  1210. document.querySelector('#showAll').onclick = function()
  1211. {
  1212. ajaxPOST();
  1213. }
  1214. }
  1215. function ajaxPOST()
  1216. {
  1217.  
  1218. var request = new XMLHttpRequest();
  1219. request.onreadystatechange = function()
  1220. {
  1221. if(request.readyState == 4)
  1222. {
  1223. document.querySelector('#SHOW').innerHTML = request.responseText;
  1224. }
  1225. }
  1226.  
  1227. request.open('POST', 'showAllcomment.php');
  1228. request.send();
  1229.  
  1230. }
  1231.  
  1232.  
  1233. showAllcomment.php
  1234. <?php
  1235. include("bd.php");
  1236. $tableName = "SELECT * FROM comments";
  1237. $result = mysql_query($tableName);
  1238. while($row = mysql_fetch_assoc($result))
  1239. {
  1240. echo "<td> {$row['user_comment']}</td><br> ";
  1241. }
  1242. ?>
  1243. signup.php
  1244.  
  1245. <!DOCTYPE html>
  1246. <html>
  1247. <head>
  1248. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  1249. <meta charset="utf-8">
  1250. </head>
  1251. <header>
  1252. </header>
  1253. <body>
  1254. <style >
  1255. body
  1256. {
  1257. background: url(https://im0-tub-ru.yandex.net/i?id=af5252439ad0317e820919e2fee948b7&n=13) no-repeat;
  1258. background-size: 100%;
  1259. }
  1260. #l1{
  1261. padding: 100px;
  1262. }
  1263. #l2{
  1264. background-color: #F8AAAA;
  1265. width: 200px;
  1266. }
  1267. #l3{
  1268. background-color: #F8AAAA;
  1269. width: 200px;
  1270. }
  1271. #l4{
  1272. background-color: #F8AAAA;
  1273. width: 200px;
  1274. }
  1275. </style>
  1276. <div id="l1">
  1277. <form method="POST" action = /save_user.php align = "center">
  1278. <h5><label for = "username">Enter your login</label></h5>
  1279. <input type="text" name="username" id="l2">
  1280. <h5><label for = "password">Enter your password</label></h5>
  1281. <input type="password" name="password1" id="l3">
  1282. <h5><label for = "password">Enter your password</label></h5>
  1283. <input type="password" name="password2" id="l4"><br>
  1284. <button name = "submit" class="btn btn-success">To register</button>
  1285. </div>
  1286. </form>
  1287. </body>
  1288. </html>
Add Comment
Please, Sign In to add comment