<!DOCTYPE html>
<html>
<head>
<title> Search </title>
</head>
<body>
<h1>Please enter in the desired search criteria</h1>
<form>
Customer's First name:
<br>
<input type="text" name="Fname">
<br>
Customer's Last name:
<br>
<input type="text" name="Lname">
<br> <br>
Order ID:
<br>
<input type="text" name="OrderID">
<br> <br>
Volunteer's First Name:
<br>
<input type="text" name="VolFName">
<br>
Volunteer's Last Name:
<br>
<input type="text" name="VolLName">
<br><br>
Item ID:
<br>
<input type="text" name="ItemName">
<br><br>
<input type="submit" name="submit_search" value="submit_search">
</form>
</body>
<?php
$fName = $_POST['Fname'];
$lName = $_POST['LName'];
$orderID = $_POST['OrderID'];
$VolFName = $_POST['VolFName'];
$VolLName = $_POST['VolLName'];
$itemName = $_POST['ItemName'];
//Connect to server
$conn = new mysqli('localhost', 'user', 'password', 'KittenMittens');
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
/*
$sql = "SELECT * FROM Customer where ('$fName' = fName and '$lName' = lName)";
$rs = $conn->query($sql);
//echo $rs;
echo "<p align='center'><font color='red'><u>Results: </u></font></p>";
echo $rs;
if ($rs -> num_rows > 0){
while($row = $rs -> fetch_assoc($rs)){
echo $rows;
}
}
*/
$sql = "SELECT * FROM KittenMittens.Customer";
$result = $conn->query($sql);
var_dump($result);
while($row = $result->fetch_assoc()){
echo $row['itemname'];
}
$conn->close();
?>
</html>
I've been looking at different tutorials from W3Schools and other helpful guides on how to return the results from a query from the database. When I run var_dump($result) I get: object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(9) ["lengths"]=> NULL ["num_rows"]=> int(1) ["type"]=> int(0) }, but I am not able to get anything to echo on the screen. I have verified there is data within the table I am accessing, and the connection is verified.
Any help in figuring out why I am not able to get any data to be echoed would be much appreciated. Thank you!
