douhuibo5635 2015-03-11 15:38
浏览 95
已采纳

php pdo具有多个参数的搜索代码

Below is my code...

I am trying to create search with multiple parameters in php pdo....with Multiple if else condition...in singlw query...

plz help ...to make this...how can i do this with php pdo...

  <?php
$db=new PDO('mysql:host=localhost;dbname=circulation_scheme_prepaid','root','');
if(isset($_POST['Submit']))
{   
$result=$db->prepare('SELECT * FROM receipt_entry WHERE');
    if($_POST['book']!='')
    {
         $result->bindParam(':book',$_POST['book']);
    }    
$result->execute(); 
$data = $result->fetchAll();
}
?>

I nned to make above code like this..

<?php
require_once("includes/config.php");
if(isset($_POST['search']))
{   
    $sql = "SELECT * FROM properties WHERE";

    if($_POST['location']!='')
    {
        $location = $_POST['location'];
        $sql .= " location = '$location' AND";
    }

    if($_POST['purpose']!='')
    {
        $purpose = $_POST['purpose'];
        $sql .= " purpose = '$purpose' AND";
    }
    $sql = substr($sql, 0 ,-3); 

$query = mysql_query($sql);
while($row = mysql_fetch_array($query,MYSQL_ASSOC))
        {
            $rows[] = $row;
        }

}
?>
  • 写回答

1条回答 默认 最新

  • dongmeng0317 2015-03-11 17:51
    关注

    You can try something like this :

    if (isset($_POST['search'])) {
      $sql = 'SELECT * FROM properties';
      $where = array();
      $params = array();
    
      if (!empty($_POST['location'])) {
        $where[] = "location = :location";
        $params[':location'] = $_POST['location'];
      }
    
      if (!empty($_POST['purpose'])) {
        $where[] = "purpose = :purpose";
        $params[':purpose'] = $_POST['purpose'];
      }
    
      if(count($where) > 0)
          $sql .= ' WHERE ' . implode(' AND ', $where);
    
      $stmt = $db->prepare($sql);
    
      foreach($params as $param => $value) {
        $stmt->bindParam($param, $value);
      }
    
      $stmt->execute();
      $data = $stmt->fetchAll();
    
      print_r($data);
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?