个人中心
gpt4 book ai didi

PHP/MySQLi 类似乎不起作用

转载 作者：行者123 更新时间：2023-11-29 21:19:11 25 4
gpt4 key购买 nike

我是 PHP/MySQLi 的新手，但我认为这次我已经取得了一些不错的进步。但是，我遇到了一些问题。

  1. 在index.php中，如果发现显示结果，如果没有发现显示消息，则添加一些条件，然后添加默认消息，但这不起作用，但我认为这归因于我在代码。
  2. 我的表单上有 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>

最佳答案

由于 search 方法返回一个数组，因此您可以执行类似的操作来查看是否有返回并决定显示或不显示什么

if (count($search_results) > 0) {
     // process the content
} else {
    // search return content
}

关于PHP/MySQLi 类似乎不起作用，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/35786349/

25 4 0
文章推荐： mysql - 多个表的共享主键
文章推荐： mysql - 如何通过 java jdbc 连接到位于 Namecheap 服务器上的 MySQL 数据库？
文章推荐： mysql - 使用 IN 时比较两个 SQL 查询
文章推荐： mysql - 如何使用 mysqli_real_escape_string 转义单引号？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com