Advertisement
rootUser

project 0 - insert value (html+php)

Oct 23rd, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.26 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.  
  4. <head>
  5.     <title>MY World</title>
  6.     <meta charset="utf-8">
  7.     <meta name="viewport" content="width=device-width, initial-scale=1">
  8.  
  9.     <!--
  10.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  11.     <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  12.     <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  13.     -->
  14.  
  15.  
  16.     <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.css">
  17.     <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css">
  18.     <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap-theme.css">
  19.     <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap-theme.min.css">
  20.  
  21.     <link rel="stylesheet" type="text/css" href="ok.css">
  22.  
  23.     <!--
  24.     <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  25.     <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  26.     -->
  27.  
  28. </head>
  29.  
  30. <body>
  31. <!--
  32. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  33. -->
  34. <script src="bootstrap/js/jquery.min.js"></script>
  35. <script src="bootstrap/js/bootstrap.min.js"></script>
  36.  
  37.  
  38. <!--
  39. <link rel="javascript" src="bootstrap/js/bootstrap.js>
  40. <link rel=" javascript " src="bootstrap/js/bootstrap.min.js ">
  41. <link rel="javascript " src="bootstrap/js/jquery.js>
  42. <link rel="javascript" src="bootstrap/js/jquery.min.js">
  43. -->
  44.  
  45. <div class="container">
  46.     <h1 align="center">Welcome to our site</h1>
  47.     <p align="center">Please Login or Sign up to continue </p>
  48. </div>
  49.  
  50. <form>
  51.     <!-- action="action_page.php" -->
  52.     <div class="container">
  53.         <label><b>Username</b>
  54.         </label>
  55.         <input type="text" placeholder="Enter Username" name="uname" required>
  56.  
  57.         <label><b>Password</b>
  58.         </label>
  59.         <input type="password" placeholder="Enter Password" name="psw" required>
  60.  
  61.         <!--  <button type="submit">Login</button> -->
  62.         <button type="submit">Sign up</button>
  63.     </div>
  64. </form>
  65.  
  66. <div class="container">
  67.     <?php $db_connection=new mysqli( "localhost", "root", "", "ok");
  68.     if($db_connection->connect_error)
  69.     {
  70.         die("Error connecting to MySQL server.".$db_connection->connect_error);
  71.     }
  72.     if(isset($_GET["uname"])&&isset($_GET["psw"]))
  73.     {
  74.         $getUname=$_GET["uname"];
  75.         $getPass=$_GET["psw"];
  76.         /* $query = (" INSERT INTO user0(Dname, Dpassword)
  77.                        VALUES (
  78.                                 "."
  79.                                 '".$getUname."',
  80.                                 '".$getPass."'
  81.                               ) "
  82.                     ); */
  83.         $query =
  84.             (" INSERT INTO user0(Dname, Dpassword)
  85.               VALUES (
  86.                       "."
  87.                       '".$getUname."',
  88.                       '".SHA1($getPass)."'
  89.                       )"
  90.             );
  91.  
  92.         if($db_connection->query($query)==TRUE)
  93.         {
  94.             echo "Successfully inserted";
  95.         }
  96.         else
  97.         {
  98.             echo "Error : ".$query."<br>".$db_connection->error;
  99.         }
  100.     }
  101.     ?>
  102. </div>
  103. </body>
  104.  
  105. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement