API tools faq
paste
basart1

Untitled

basart1
Apr 18th, 2019
75
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.69 KB | None | 0 0
raw download clone embed print report
  1.  
  2. <html>
  3. <head>
  4.     <meta charset="utf-8">
  5.     <title>My Form</title>
  6. </head>
  7. <body>
  8. <table class="tab2" border="1">
  9.     <tbody id="body">
  10.     <tr>
  11.         <th><a href="?id">№</th></a>
  12.         <th><a href="?name1">Имя</th></a>
  13.         <th><a href="?surn">Фамилия</th></a>
  14.         <th><a href="?phone1">Номер телефона</th></a>
  15.     </tr>
  16.     <?php
  17. const HOST_NAME = '127.0.0.1';
  18. const DB_NAME = 'address_book';
  19. const LOGIN_DB = 'basart';
  20. const PASSWORD_DB = "megusta";
  21. const PORT = 3306;
  22. $mysqlConnection = new mysqli(HOST_NAME, LOGIN_DB, PASSWORD_DB, DB_NAME, PORT);
  23. function addcheck ($mysqlConnection){
  24.     $query1 = "SELECT * FROM `users` WHERE `check`= 1";
  25.     $result = mysqli_query($mysqlConnection,$query1 );
  26.      if ($ew1 =  mysqli_fetch_all($result)) {
  27.         return $ew1;
  28.     }
  29. }
  30. addcheck($mysqlConnection);
  31. if(!isset($_GET['id']) && !isset($_GET['name1']) && !isset($_GET['surn']) && !isset($_GET['phone1'])) {
  32.     echo "1";
  33.  
  34.         foreach (addcheck($mysqlConnection) as $key => $value) {
  35.          echo
  36.     "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  37.    <tr  style='color: chartreuse'>
  38.    <tr>
  39.    <td>", $value[0], "</td>
  40.    <td>", $value[1], "</td>
  41.    <td >", $value[2], "</td>
  42.    <td>", $value[3], "</td>
  43.    </table>";
  44.     }
  45. } elseif (isset($_GET['id']) && $_GET['id'] == 0) {
  46.     echo "2";
  47.      $order = $_GET['id'] == 'ASC' ? 'DESC' : 'ASC';
  48.         $query = "SELECT * FROM `users` WHERE `check` = 1  ORDER BY `id` " .$order;
  49. $result0 = mysqli_query($mysqlConnection,$query);
  50.    while ($row = mysqli_fetch_array($result0)) {
  51.     echo
  52.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  53.    <tr  style='color: chartreuse'>
  54.    <tr>
  55.    <td>", $row[0], "</td>
  56.    <td>", $row[1], "</td>
  57.    <td >", $row[2], "</td>
  58.    <td>", $row[3], "</td>
  59.    </table>";
  60.  
  61. }
  62. if(isset($_GET['id']) && isset($_GET['id']) && $order = 'ASC') {
  63.     echo "6";
  64.  $order = 'DESC';
  65.             $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `id` " .$order;
  66. $result0 = mysqli_query($mysqlConnection,$query);
  67.    while ($row = mysqli_fetch_array($result0)) {
  68.     echo
  69.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  70.    <tr  style='color: chartreuse'>
  71.    <tr>
  72.    <td>", $row[0], "</td>
  73.    <td>", $row[1], "</td>
  74.    <td >", $row[2], "</td>
  75.    <td>", $row[3], "</td>
  76.    </table>";
  77.     }
  78. }
  79. }
  80. /*elseif (isset($_GET['id']) && !empty($_GET['id']) && $order == 'ASC') {
  81.     echo "6";
  82.     $order = 'DESC';
  83.               $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `id` " .$order;
  84. $result0 = mysqli_query($mysqlConnection,$query);
  85.    while ($row = mysqli_fetch_array($result0)) {
  86.     echo
  87.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  88.     <tr  style='color: chartreuse'>
  89.     <tr>
  90.     <td>", $row[0], "</td>
  91.     <td>", $row[1], "</td>
  92.     <td >", $row[2], "</td>
  93.     <td>", $row[3], "</td>
  94.     </table>";
  95.     }
  96. }*/ elseif (isset($_GET['name1']) && $_GET['name1'] == 0){
  97.     echo "3";
  98.     $order = 'ASC';
  99.             $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `first_name` " .$order;
  100. $result0 = mysqli_query($mysqlConnection,$query);
  101.    while ($row = mysqli_fetch_array($result0)) {
  102.     echo
  103.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  104.    <tr  style='color: chartreuse'>
  105.    <tr>
  106.    <td>", $row[0], "</td>
  107.    <td>", $row[1], "</td>
  108.    <td >", $row[2], "</td>
  109.    <td>", $row[3], "</td>
  110.    </table>";
  111.    }
  112.    if ($order = "ASC"){
  113.     echo "7";
  114.     $order = 'DESC';
  115.       $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `first_name` " .$order;
  116. $result0 = mysqli_query($mysqlConnection,$query);
  117.    while ($row = mysqli_fetch_array($result0)) {
  118.     echo
  119.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  120.    <tr  style='color: chartreuse'>
  121.    <tr>
  122.    <td>", $row[0], "</td>
  123.    <td>", $row[1], "</td>
  124.    <td >", $row[2], "</td>
  125.    <td>", $row[3], "</td>
  126.    </table>";
  127.    }
  128. }
  129.  
  130. }
  131.  
  132. elseif (isset($_GET['surn']) && $_GET['surn'] == 0) {
  133.     echo "4";
  134.     $order = 'ASC';
  135.             $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `surname` " .$order;
  136. $result0 = mysqli_query($mysqlConnection,$query);
  137.    while ($row = mysqli_fetch_array($result0)) {
  138.     echo
  139.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  140.    <tr  style='color: chartreuse'>
  141.    <tr>
  142.    <td>", $row[0], "</td>
  143.    <td>", $row[1], "</td>
  144.    <td >", $row[2], "</td>
  145.    <td>", $row[3], "</td>
  146.    </table>";
  147.     }
  148.     if ($order = 'ASC'){
  149.     echo "8";
  150.     $order = 'DESC';
  151.             $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `surname` " .$order;
  152. $result0 = mysqli_query($mysqlConnection,$query);
  153.    while ($row = mysqli_fetch_array($result0)) {
  154.     echo
  155.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  156.    <tr  style='color: chartreuse'>
  157.    <tr>
  158.    <td>", $row[0], "</td>
  159.    <td>", $row[1], "</td>
  160.    <td >", $row[2], "</td>
  161.    <td>", $row[3], "</td>
  162.    </table>";
  163. }
  164. }
  165. } elseif (isset($_GET['phone1'])&& $_GET['phone1'] == 0) {
  166.     echo "5";
  167.      $order = 'ASC';
  168.             $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `phone_number` " .$order;
  169. $result0 = mysqli_query($mysqlConnection,$query);
  170.    while ($row = mysqli_fetch_array($result0)) {
  171.     echo
  172.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  173.    <tr  style='color: chartreuse'>
  174.    <tr>
  175.    <td>", $row[0], "</td>
  176.    <td>", $row[1], "</td>
  177.    <td >", $row[2], "</td>
  178.    <td>", $row[3], "</td>
  179.    </table>";
  180.     }
  181.     if ($order = 'ASC'){
  182.      echo "9";
  183.      $order = 'ASC';
  184.             $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `phone_number` " .$order;
  185. $result0 = mysqli_query($mysqlConnection,$query);
  186.    while ($row = mysqli_fetch_array($result0)) {
  187.     echo
  188.      "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
  189.    <tr  style='color: chartreuse'>
  190.    <tr>
  191.    <td>", $row[0], "</td>
  192.    <td>", $row[1], "</td>
  193.    <td >", $row[2], "</td>
  194.    <td>", $row[3], "</td>
  195.    </table>";
  196. }
  197. }
  198. }
  199. /*else if (isset($_GET['name1'])) {
  200.     $order = $_GET['id'] == 'ASC' ? 'ASC' : 'DESC';
  201. }{
  202. $order = 'DESC';
  203.         $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `id` " .$order;
  204. $result0 = mysqli_query($mysqlConnection,$query);
  205.    while ($row = mysqli_fetch_array($result0)) {
  206.     echo
  207.      "<table class='tab2' border='2'  bgcolor='red' width='15%'>
  208.     <tr  style='color: chartreuse'>
  209.     <tr>
  210.     <td>", $row[0], "</td>
  211.     <td>", $row[1], "</td>
  212.     <td >", $row[2], "</td>
  213.     <td>", $row[3], "</td>
  214.     </table>";
  215.  
  216. }
  217.     }*/
  218.    /* $sort = isset($_GET['surn']) ? $_GET['surn'] : 'desc';
  219.     $order = "ORDER BY $sort";*/
  220. /*$key = isset($_GET['key']) ? $_GET['key'] : 'number';*/
  221.  
  222. /*  if(isset($_GET['id'])) {
  223.     $qr_result = mysql_query("SELECT * from `users` ORDER BY `id` ASC limit 1");
  224. }
  225.         elseif(isset($_GET['name1'])) {
  226.             $qr_result = mysql_query("SELECT * from `users` ORDER BY `first_name` DESC");}
  227.         elseif(isset($_GET['surn'])) {
  228.             $qr_result = mysql_query("SELECT * from `users` ORDER BY `surname` DESC");
  229.         }
  230.         elseif(isset($_GET['phone1'])) {
  231.             $qr_result = mysql_query("SELECT * from `users` ORDER BY `phone_number` DESC");
  232.         } */
  233.         /*while($data = mysqli_fetch_array($result0))
  234.         {
  235.           echo "<table class='tab2' border='3'  bgcolor='#ff7f50' width='15%'>
  236.     <tr  style='color: chartreuse'>
  237.              <tr>
  238.              <td>$data[0]</td>
  239.              <td>$data[1]</td>
  240.              <td>$data[2]</td>
  241.              <td>$data[3]</td>
  242.             </tr>
  243.             </table>";
  244.         }*/
  245.     ?>
  246.    
  247.     </tr>
  248.     </tbody>
  249. </table>
  250. <input type="button" value="Добавить" id="btnTrigger"/>
  251. <input type="button" value="Удалить всё" id="deleteAllRows"/>
  252. <form class="form" action="form.php" method="post" id="form">
  253.     <p>My form</p>
  254.     <fieldset>
  255.         <legend>Запись данных</legend>
  256.         <p><label for="name">Имя <em>*</em></label><input  type="text" id="name" name="name"></p>
  257.         <p><label for="surname">Фамилия<em>*</em></label><input  type="text" id="surname"
  258.                                                                 name="surname"></p>
  259.         <p><label for="phonenumber">Номер телефона<em>*</em></label><input  type="text" id="pn"
  260.                                                                            name="pn"></p>
  261.         <input type="submit" value="Добавить"  id="btnAdd"/>
  262.  
  263.     </fieldset>
  264. <!--<script src="ajax.js" charset="utf-8"></script>-->
  265. </body>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!