Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqli_query(connection,query,resultmode);
- <?php include('dbConnection.php') ?> # this, I added to avoid retyping
- <?php
- if( isset($_POST['searchkeyword']) ){
- $var = $_POST['searchkeyword'];
- $query = "SELECT * FROM student_info WHERE (STUD_NO LIKE '%$var%' OR NAME LIKE '%$var%' )";
- $resultSet = mysqli_query($query); # gets the result set returned by SELECT statement
- while($rsArray = mysqli_fetch_assoc($resultSet)){
- $studno = $rsArray['stud_no'];
- $lastName = $rsArray['lname'];
- $firstName = $rsArray['fname'];
- $middleName = $rsArray['mname'];
- $address = $rsArray['address'];
- $city = $rsArray['city'];
- $gender = $rsArray['gender'];
- $enrolled = $rsArray['enrollment_stat'];
- echo $studno."<br/>";
- echo $lastName.", ".$firstName." ".$middleName."<br/>";
- echo $address."<br/>";
- echo $city."<br/>";
- echo $gender."<br/>";
- echo $enrolled."<br/>";
- }
- }
- ?>
- <?php
- # this it the connection php file to include
- $dbhost = "localhost";
- $dbuser = "root";
- $dbpassword = "";
- $dbname = "stud_data";
- $connection = mysqli_connect($dbhost,$dbuser,$dbpassword,$dbname); # connection to mysql
- if(mysqli_connect_errno() > 0){
- echo "<script>window.alert('Failed To Connect To Database')</script>";
- }
- ?>
- Warning: mysqli_query() expects at least 2 parameters, 1 given in C:xampphtdocs...on line 7
- Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in C:xampphtdocs...on line 9
- mysqli_query($connection,"Your query here");
- <?php include('dbConnection.php') ?> # this, I added to avoid retyping
- <?php
- if( isset($_POST['searchkeyword']) ){
- $var = $_POST['searchkeyword'];
- $query = "SELECT * FROM student_info WHERE (STUD_NO LIKE '%$var%' OR NAME LIKE '%$var%' )";
- $resultSet = mysqli_query($connection , $query); # gets the result set returned by SELECT statement
- while($rsArray = mysqli_fetch_assoc($resultSet)){
- $studno = $rsArray['stud_no'];
- $lastName = $rsArray['lname'];
- $firstName = $rsArray['fname'];
- $middleName = $rsArray['mname'];
- $address = $rsArray['address'];
- $city = $rsArray['city'];
- $gender = $rsArray['gender'];
- $enrolled = $rsArray['enrollment_stat'];
- echo $studno."<br/>";
- echo $lastName.", ".$firstName." ".$middleName."<br/>";
- echo $address."<br/>";
- echo $city."<br/>";
- echo $gender."<br/>";
- echo $enrolled."<br/>";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement