Advertisement
Guest User

Untitled

a guest
Apr 1st, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.70 KB | None | 0 0
  1. mysqli_query(connection,query,resultmode);
  2.  
  3. <?php include('dbConnection.php') ?> # this, I added to avoid retyping
  4. <?php
  5. if( isset($_POST['searchkeyword']) ){
  6. $var = $_POST['searchkeyword'];
  7. $query = "SELECT * FROM student_info WHERE (STUD_NO LIKE '%$var%' OR NAME LIKE '%$var%' )";
  8. $resultSet = mysqli_query($query); # gets the result set returned by SELECT statement
  9.  
  10. while($rsArray = mysqli_fetch_assoc($resultSet)){
  11. $studno = $rsArray['stud_no'];
  12. $lastName = $rsArray['lname'];
  13. $firstName = $rsArray['fname'];
  14. $middleName = $rsArray['mname'];
  15. $address = $rsArray['address'];
  16. $city = $rsArray['city'];
  17. $gender = $rsArray['gender'];
  18. $enrolled = $rsArray['enrollment_stat'];
  19. echo $studno."<br/>";
  20. echo $lastName.", ".$firstName." ".$middleName."<br/>";
  21. echo $address."<br/>";
  22. echo $city."<br/>";
  23. echo $gender."<br/>";
  24. echo $enrolled."<br/>";
  25. }
  26. }
  27. ?>
  28.  
  29. <?php
  30. # this it the connection php file to include
  31. $dbhost = "localhost";
  32. $dbuser = "root";
  33. $dbpassword = "";
  34. $dbname = "stud_data";
  35. $connection = mysqli_connect($dbhost,$dbuser,$dbpassword,$dbname); # connection to mysql
  36.  
  37. if(mysqli_connect_errno() > 0){
  38. echo "<script>window.alert('Failed To Connect To Database')</script>";
  39. }
  40.  
  41.  
  42. ?>
  43.  
  44. Warning: mysqli_query() expects at least 2 parameters, 1 given in C:xampphtdocs...on line 7
  45.  
  46. Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in C:xampphtdocs...on line 9
  47.  
  48. mysqli_query($connection,"Your query here");
  49.  
  50. <?php include('dbConnection.php') ?> # this, I added to avoid retyping
  51. <?php
  52. if( isset($_POST['searchkeyword']) ){
  53. $var = $_POST['searchkeyword'];
  54. $query = "SELECT * FROM student_info WHERE (STUD_NO LIKE '%$var%' OR NAME LIKE '%$var%' )";
  55.  
  56. $resultSet = mysqli_query($connection , $query); # gets the result set returned by SELECT statement
  57.  
  58. while($rsArray = mysqli_fetch_assoc($resultSet)){
  59. $studno = $rsArray['stud_no'];
  60. $lastName = $rsArray['lname'];
  61. $firstName = $rsArray['fname'];
  62. $middleName = $rsArray['mname'];
  63. $address = $rsArray['address'];
  64. $city = $rsArray['city'];
  65. $gender = $rsArray['gender'];
  66. $enrolled = $rsArray['enrollment_stat'];
  67. echo $studno."<br/>";
  68. echo $lastName.", ".$firstName." ".$middleName."<br/>";
  69. echo $address."<br/>";
  70. echo $city."<br/>";
  71. echo $gender."<br/>";
  72. echo $enrolled."<br/>";
  73. }
  74. }
  75. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement