这是search.php的代码-这部分显示搜索文本框和搜索按钮。将从数据库获取数据。
<?php
//Just declaration here for null
$search_term = '';
search_results = false;
//Check if search data was submitted
if (isset($_GET['s'])) {
// Include the search class
require_once( dirname(__FILE__) . '/class-search.php' );
// Instantiate a new instance of the search class
$search = new search();
// Store search term into a variable
$search_term = $_GET['s'];
// Send the search term to our search class and store the result
$search_results = $search->search($search_term);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Search</title>
</head>
<body>
<h1>Search</h1>
<div class="search-form">
<form action="" method="get">
<div class="form-field">
<label for="search-field">Search</label>
<b> <input type="search" name="s" placeholder="Enter your search term..." results="5" value="<?php echo $search_term; ?>"> </b>
<input type="submit" value="Search">
</div>
</form>
</div>
<?php
if ($search_results) :
?>
<div class="results-count">
<p>
<?php
echo $search_results['count'];
?> results found
</p>
</div>
<div class="results-table">
<?php
foreach ($search_results['results'] as $search_result) :
?>
<div class="result">
<p>
<?php
echo $search_result->cust_ic;
?>
</p>
</div>
<?php
endforeach;
?>
</div>
<?php
endif;
?>
</body>
</html>
是class-search.php的代码
class search {
private $mysqli;
public function __construct() {
$this->connect();
}
private function connect() {
$this->mysqli = new mysqli( 'localhost', 'root', 'root', 'abc' );
}
public function search($search_term) {
$sanitized = $this->mysqli->real_escape_string($search_term);
// Run the query
$query = $this->mysqli->query("
SELECT *
FROM customer_info
WHERE cust_name LIKE '%{$sanitized}%'
OR cust_ic LIKE '%{$sanitized}%'
");
// Check results
if ( ! $query->num_rows ) {
return false;
}
// Loop and fetch objects
while( $row = $query->fetch_object() ) {
$rows[] = $row;
}
// Build our return result
$search_results = array(
'count' => $query->num_rows,
'results' => $rows,
);
return $search_results;
}
}
我得到这个错误代码:
通知:未定义变量:search_term in C:'xampp'htdocs'search'search.php on line 28
注意:未定义变量:search_results在C:'xampp'htdocs'search'search.php第34行
当我运行search.php时,我得到2个错误。我试着点击搜索,搜索后没有更多的错误出现。对这个解决方案有什么想法吗?谢谢你
请声明您的变量:
<?php
//Declaration
$search_term = '';
search_results = false;
//Check if search data was submitted
if (isset($_GET['s'])) {
// Include the search class
require_once( dirname(__FILE__) . '/class-search.php' );
// Instantiate a new instance of the search class
$search = new search();
// Store search term into a variable
$search_term = $_GET['s'];
// Send the search term to our search class and store the result
$search_results = $search->search($search_term);
}
?>