我是PHP / MySQLi的新手，但我认为这次我已经取得了一些不错的进步。但是，我遇到了一些问题。
在index.php中，我尝试添加一些条件，如果发现显示结果，或者没有找到显示消息的信息，然后显示默认消息，但这没有用，但是我认为这是我对代码的错误处理。
我在表单上有4个字段，所有字段都需要在数据库表中匹配以返回结果，但需要返回*，以便可以显示匹配数据中的其他数据。
class.search.php
<?php
include('config.php');
/**
* Performs a search
*
* This class is used to perform search functions in a MySQL database
*
* @version 1.0
* @author James Brandon
*/
class search {
/**
* MySQLi connection
* @access private
* @var object
*/
private $mysqli;
/**
* Constructor
*
* This sets up the class
*/
public function __construct() {
// Connect to our database and store in $mysqli property
$this->connect();
}
/**
* Database connection
*
* This connects to our database
*/
private function connect() {
$this->mysqli = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
//$this->mysqli = new mysqli( 'localhost', 'reboot_ncddb', 'reboot_ncddb', 'TF69HS-Wm^*F' );
}
/**
* Search routine
*
* Performs a search
*
* @param string $search_term The search term
*
* @return array/boolen $search_results Array of search results or false
*/
public function search($first_name, $last_name, $postcode, $reg) {
// Sanitize the search term to prevent injection attacks
$first_name = $this->mysqli->real_escape_string($first_name);
$last_name = $this->mysqli->real_escape_string($last_name);
$postcode = $this->mysqli->real_escape_string($postcode);
$reg = $this->mysqli->real_escape_string($reg);
// Run the query
$query = $this->mysqli->query("
SELECT *
FROM customers
WHERE first_name = '%{$first_name}%'
AND last_name = '%{$last_name}%'
AND postcode = '%{$postcode}%'
AND reg = '%{$reg}%'
");
// 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;
}
}
index.php
<?php
//Check if search data was submitted
if ( isset( $_GET['search_form'] ) ) {
// 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_first_name = htmlspecialchars($_GET['first_name'], ENT_QUOTES);
$search_last_name = htmlspecialchars($_GET['last_name'], ENT_QUOTES);
$search_postcode = htmlspecialchars($_GET['postcode'], ENT_QUOTES);
$search_reg = htmlspecialchars($_GET['reg'], ENT_QUOTES);
// Send the search term to our search class and store the result
$search_results = $search->search($search_first_name, $search_last_name, $search_postcode, $search_reg);
}
?>
<!doctype html>
<html class="no-js" lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>search customer</title>
<link rel="stylesheet" href="css/foundation.css" />
<link rel="stylesheet" href="css/app.css" />
</head>
<body>
<div class="row">
<div class="large-12 columns center">
<h3>search customer</h3>
</div>
</div>
<div class="row">
<div class="small-6 columns">
<form action="" method="get" class="search-form">
<input type="hidden" name="search_form" id="search_form">
<div class="row">
<h4 class="text-center">Search for a customer</h4>
<div class="small-6 columns">
<label id="first_name">First Name
<input name="first_name" type="text" placeholder="Joe" value="<?php echo $search_first_name; ?>">
</label>
</div>
<div class="small-6 columns">
<label id="last_name">Last Name
<input name="last_name" type="text" placeholder="Bloggs" value="<?php echo $search_last_name; ?>">
</label>
</div>
</div>
<div class="row">
<div class="small-6 columns">
<label id="postcode">Postcode
<input name="postcode" type="text" placeholder="Ex: E2 8AA" value="<?php echo $search_postcode; ?>">
</label>
</div>
<div class="small-6 columns">
<label id="reg">Registration:
<input name="reg" type="text" placeholder="CV58 CVZ" value="<?php echo $search_reg; ?>">
</label>
</div>
</div>
<div class="row">
<button type="submit" class="button expanded">Search</button>
</div>
</form>
</div>
<div class="small-6 columns">
<?php if($search_results['count']){ ?>
<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->first_name; ?> <?php echo $search_result->last_name; ?></p>
<p><?php echo $search_result->postcode; ?></p>
<p><?php echo $search_result->reg; ?></p>
<p><?php echo $search_result->ncd; ?></p>
</div>
<?php endforeach; ?>
</div>
<?php } else if($search_results['count'] == '0') { ?>
<p>nothign found</p>
<?php } else { ?>
<h3>Search for NCD's on the driver database</h3>
<p>Please use the search form to the left to search and find records for that persons no claims discount on their car insurance record.</p>
<?php } ?>
</div>
</div>
<script src="js/vendor/jquery.min.js"></script>
<script src="js/vendor/what-input.min.js"></script>
<script src="js/foundation.min.js"></script>
<script src="js/app.js"></script>
</body>
</html>
最佳答案
由于搜索方法返回一个数组，因此您可以执行以下操作以查看是否存在返回值，并确定要显示或不显示的内容
if (count($search_results) > 0) {
// process the content
} else {
// search return content
}
关于php - PHP/MySQLi类似乎不起作用，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/35786349/