API tools faq
paste
Guest User

code

a guest
Aug 30th, 2017
32
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.27 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $db_host = 'localhost'; // Server Name
  3. $db_user = 'root'; // Username
  4. $db_pass = ''; // Password
  5. $db_name = 'nkdb'; // Database Name
  6. $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
  7. if (!$conn)
  8. {
  9.     die ('Failed to connect to MySQL: ' . mysqli_connect_error());  
  10. }
  11. $sql = "SELECT * FROM users";
  12. $query = mysqli_query($conn, $sql);
  13. if (!$query)
  14. {
  15.     die ('SQL Error: ' . mysqli_error($conn));
  16. }
  17.  $count = 1;
  18.  $row = mysqli_fetch_array($query);
  19.  
  20. ?>
  21. <html>
  22. <head>
  23.   <meta charset="utf-8">
  24.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  25.   <title>Admin</title>
  26.   <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  27.   <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
  28.   <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css">
  29.   <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css">
  30.   <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  31.  <link rel="stylesheet" href="dist/css/skins/skin-blue.min.css">
  32.   <link rel="stylesheet"
  33.         href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
  34. </head>
  35. <body class="hold-transition skin-blue sidebar-mini">
  36. <div class="wrapper">
  37.   <header class="main-header">
  38.     <a href="index2.html" class="logo">
  39.    
  40.       <span class="logo-lg"><b>Admin</b></span>
  41.     </a>
  42.     <nav class="navbar navbar-static-top" role="navigation">
  43.       <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">
  44.         <span class="sr-only">Toggle navigation</span>
  45.       </a>
  46.       <div class="navbar-custom-menu">
  47.       </div>
  48.     </nav>
  49.   </header>
  50.   <!-- Left side column. contains the logo and sidebar -->
  51.   <aside class="main-sidebar">
  52.  
  53.     <!-- sidebar: style can be found in sidebar.less -->
  54.     <section class="sidebar">
  55.  
  56.       <!-- Sidebar user panel (optional) -->
  57.       <div class="user-panel">
  58.         <div class="pull-left image">
  59.           <img src="dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
  60.         </div>
  61.         <div class="pull-left info">
  62.           <p>Admin</p>
  63.           <!-- Status -->
  64.          
  65.         </div>
  66.       </div>
  67.  
  68.       <!-- Sidebar Menu -->
  69.       <ul class="sidebar-menu" data-widget="tree">
  70.        
  71.         <!-- Optionally, you can add icons to the links -->
  72.         <li ><a href="home.php"><i class="fa fa-link"></i> <span>Home</span></a></li>
  73.         <li  class="active"><a href="Adduser.php"><i class="fa fa-link"></i> <span>Add User</span></a></li>
  74.          <li    ><a href="listusers.php"><i class="fa fa-link"></i> <span>List Of User</span></a></li>
  75.        
  76.        
  77.       </ul>
  78.       <!-- /.sidebar-menu -->
  79.     </section>
  80.     <!-- /.sidebar -->
  81.   </aside>
  82.  
  83.   <!-- Content Wrapper. Contains page content -->
  84.   <div class="content-wrapper">
  85.    
  86.     <section>
  87.       <div class="box box-primary">
  88.             <div class="box-header with-border">
  89.               <h2>User Info</h2>
  90.             </div>
  91.             <!-- /.box-header -->
  92.             <!-- form start -->
  93.             <form role="form" action="" method="post">
  94.               <div class="box-body">
  95.                 <div class="form-group">
  96.                   <label for="name">Name</label>
  97.                   <input type="text" name="name" class="form-control" id="name" placeholder="Enter User's Name">
  98.                 </div>
  99.                 <div class="form-group">
  100.                   <label for="Email">Email</label>
  101.                   <input type="Email" class="form-control" id="Email"name="email" placeholder="Enter User's Email">
  102.                 </div>
  103.                <div class="form-group">
  104.                <label for="number">Number</label>
  105.                <input type="text" class="form-control" placeholder="Enter Number" name="number">
  106.                </div>
  107.              
  108.               <div class="form-group">
  109.                     <label>Gender</label>
  110.                     <div class="radio">
  111.                         <label><input type="radio" name="gender" checked value="M">Male</label>
  112.                         <div class="radio">
  113.                             <label><input type="radio" name="gender"  value="F">Female</label>
  114.                         </div>
  115.      
  116.                     </div>
  117.                 </div>
  118.                 <div class="form-group">
  119.                     <label>Hobbies</label>
  120.                     <div>
  121.                         <div class="checkbox">
  122.                             <label for="checkbo1">
  123.                             <input type="checkbox" id="checkbo1" name="Hobbies[]" checked value="Swimming">Swimming
  124.                             </label>
  125.                         </div>
  126.                         <div class="checkbox">
  127.                             <label for="checkbox2">
  128.                             <input type="checkbox" id="checkbox2" name="Hobbies[]" value="Singing">Singing
  129.                             </label>
  130.                         </div>
  131.                         <div class="checkbox">
  132.                             <label for="checkbox3">
  133.                             <input type="checkbox" id="checkbox3" name="Hobbies[]" value="Doing Nothing">DoingNothing
  134.                             </label>
  135.                         </div>
  136.                     </div>
  137.                 </div>
  138.                 <div class="form-group">
  139.                     <label for="InputFile">File input</label>
  140.                     <input name="uploadedimage" type="file" multiple>
  141.                     <p class="help-block">Select images for your Profile</p>
  142.                 </div>
  143.                 <div class="form-group">
  144.                     <label for="status">Select Status:</label>
  145.                     <select  id="status" name="status">
  146.                         <option value="1">Active</option>
  147.                         <option value="0">Inactive</option>
  148.                     </select>
  149.                </div>
  150.             </div>
  151.               <!-- /.box-body -->
  152.             <div class="box-footer">
  153.                 <button type="submit" name="submit" class="btn btn-primary">Add User</button>
  154.             </div>
  155.         </form>
  156.     </div>
  157.     </section>
  158.     <!-- /.content -->
  159.   </div>
  160.   <!-- /.content-wrapper -->
  161.   <!-- /.control-sidebar -->
  162.   <!-- Add the sidebar's background. This div must be placed
  163.   immediately after the control sidebar -->
  164.   <div class="control-sidebar-bg"></div>
  165. </div>
  166. <!-- ./wrapper -->
  167.  
  168. <!-- REQUIRED JS SCRIPTS -->
  169.  
  170. <!-- jQuery 3 -->
  171. <script src="bower_components/jquery/dist/jquery.min.js"></script>
  172. <!-- Bootstrap 3.3.7 -->
  173. <script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
  174. <!-- AdminLTE App -->
  175. <script src="dist/js/adminlte.min.js"></script>
  176.  
  177. <!-- Optionally, you can add Slimscroll and FastClick plugins.
  178.      Both of these plugins are recommended to enhance the
  179.      user experience. -->
  180. </body>
  181. </html>
  182. <?php
  183. if(isset($_POST['submit']))
  184. {
  185. $name=$_POST['name'];
  186. $email=$_POST['email'];
  187. $number=$_POST['number'];
  188. $gender=$_POST['gender'];;
  189. $hobbies=implode(",",$_POST['Hobbies']);
  190. $date=date('Y-m-d H:i:s');
  191. $st=$_POST['status'];
  192.  
  193.     $query1 = "INSERT INTO `users`(`name`, `email`, `phone`, `gender`, `Hobbies`, `created`,`status`) VALUES ('".$name."','".$email."','".$number."','".$gender."','".$hobbies."','".$date."','".$st."')";  
  194.    $res=mysqli_query($conn,$query1);
  195.    $q="SELECT `id` FROM `users` WHERE id ORDER BY `id` DESC LIMIT 1";
  196.     $res=mysqli_query($conn,$q);
  197.    
  198.    echo "<div class='alert alert-success'>Inserted successfully</div>";
  199. }
  200. ?>
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!