krishan5420

Untitled

Jun 13th, 2017
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.27 KB | None | 0 0
  1. i'am trying to insert data in database ..what is the problem inside my code
  2. this is my code
  3. dbConnect.php
  4. <?php
  5.  
  6. class DB
  7. {
  8. function __construct()
  9. {
  10. $conn = mysqli_connect('localhost','root','iws123#','register') or die('connection problem'.mysqli_error());
  11.  
  12.  
  13. }
  14. public function insert($username,$email,$password)
  15. {
  16. $re=mysqli_query($conn,"insert into table2(username,email,password) values('".$username."','".$email."','".$password."')");
  17. return $re;
  18. }
  19. }
  20. ?>
  21.  
  22. index.php
  23.  
  24. <?php
  25. include('dbConnect.php');
  26. ini_set('display_errors', 1);
  27. ini_set('display_startup_errors', 1);
  28. error_reporting(E_ALL);
  29.  
  30. $obj= new DB();//Creating object
  31.  
  32. if(isset($_Post['submit']))
  33. {
  34. $username =$_Post['username'];
  35. $email =$_Post['email'];
  36. $password =$_Post['password'];
  37. $confirmPassword = $_POST['confirm_password'];
  38. if($password == $confirmPassword)
  39.  
  40. {
  41.  
  42. $re=$obj->insert($username,$email,$password);
  43.  
  44.  
  45. if($re)
  46. {
  47. echo "<script>alert('data insert')</script>";
  48. }
  49.  
  50. else
  51. {
  52.  
  53. echo "<script>alert('data not insert')</script>";
  54. }
  55. }
  56. else
  57. {
  58. echo "<script>alert('Password Not Match')</script>";
  59.  
  60. }
  61. }
  62. ?>
  63.  
  64. <!DOCTYPE html>
  65. <html lang="en">
  66. <head>
  67. <script type="text/javascript" src="jqy.js"></script>
  68. <script type="text/javascript">
  69. /*function myfunction(){
  70. alert("ok");
  71. var email= $("#em1").val();
  72. $.ajax({
  73. type:'post',
  74. url:'test3.php',
  75. data:{email: email},
  76. success:function(data){
  77. //alert(data);
  78. $('.emailid').html(data);
  79. }
  80. });
  81. }*/
  82.  
  83. </script>
  84. </script>
  85.  
  86. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  87. <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0, user-scalable=no">
  88. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  89. <!-- CORE CSS-->
  90.  
  91. <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.1/css/materialize.min.css">
  92.  
  93. <style type="text/css">
  94. html,
  95. body {
  96. height: 100%;
  97. }
  98. html {
  99. display: table;
  100. margin: auto;
  101. }
  102. body {
  103. display: table-cell;
  104. vertical-align: middle;
  105. }
  106. .margin {
  107. margin: 0 !important;
  108. }
  109. </style>
  110.  
  111. </head>
  112.  
  113. <body class="blue">
  114.  
  115.  
  116. <div id="login-page" class="row">
  117. <div class="col s12 z-depth-6 card-panel">
  118. <form action="" class="login-form" method="post" >
  119. <div class="row">
  120. <div class="input-field col s12 center">
  121. <p class="center login-form-text">SignUp Form</p>
  122. </div>
  123. </div>
  124. <div class="row margin">
  125. <div class="input-field col s12">
  126. <i class="mdi-social-person-outline prefix"></i>
  127. <input id="username" type="text" name="username" class="validate" required/>
  128. <label for="username" class="center-align">Username</label>
  129. </div>
  130. </div>
  131. <div class="row margin">
  132. <div class="input-field col s12">
  133. <i class="mdi-communication-email prefix"></i>
  134. <input id="em1" type="email" name="email" class="validate" onblur="myfunction()" required/>
  135. <label for="em1" class="center-align">Email</label>
  136. </div>
  137. </div>
  138. <div class="row margin">
  139. <div class="input-field col s12">
  140. <i class="mdi-action-lock-outline prefix"></i>
  141. <input id="password" type="password" name="password" class="validate" required/>
  142. <label for="password">Password</label>
  143. </div>
  144. </div>
  145. <div class="row margin">
  146. <div class="input-field col s12">
  147. <i class="mdi-action-lock-outline prefix"></i>
  148. <input id="password-again" type="password" name="confirm_password" required/>
  149. <label for="password-again">Confirm password</label>
  150. </div>
  151. </div>
  152. <div class="row">
  153. <div class="input-field col s12">
  154. <input type="submit" name="submit" value="Register" />
  155. </div>
  156. <div class="input-field col s12">
  157. <p class="margin center medium-small sign-up">Already have an account? <a href="login.php">Login</a></p>
  158. </div>
  159. </div>
  160. </form>
  161. </div>
  162. </div>
  163.  
  164. <!-- jQuery Library -->
  165. <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
  166. <!--materialize js-->
  167. <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.1/js/materialize.min.js"></script>
  168.  
  169.  
  170.  
  171. <script>
  172. (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  173. (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  174. m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  175. })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
  176.  
  177. ga('create', 'UA-27820211-3', 'auto');
  178. ga('send', 'pageview');
  179.  
  180. </script><script src="//load.sumome.com/" data-sumo-site-id="1cf2c3d548b156a57050bff06ee37284c67d0884b086bebd8e957ca1c34e99a1" async="async"></script>
  181.  
  182.  
  183.  
  184. </body>
  185.  
  186. </html>
Add Comment
Please, Sign In to add comment