Home >Backend Development >PHP Tutorial >PHP array implements multi-condition query PHP string splitting

PHP array implements multi-condition query PHP string splitting

WBOY
WBOYOriginal
2016-07-25 09:12:441113browse
";
  • echo "
  • ";
  • echo "
  • ";
  • echo "
  • ";
  • echo "
  • ";
  • }
  • }
  • else echo "
  • ";
  • }
  • $prev_page=$page-1;
  • $next_page=$page 1;
  • echo "
    ";
  • echo " 第".$page."/".$page_count."页 ";
  • if ($page<=1){
  • echo "|第一页|";
  • }
  • else{
  • echo "|第一页|";
  • }
  • echo " ";
  • if ($prev_page<1){
  • echo "|上一页|";
  • }
  • else{
  • echo "|上一页|";
  • }
  • echo " ";
  • if ($next_page>$page_count){
  • echo "|下一页|";
  • }
  • else{
  • echo "|下一页|";
  • }
  • echo " ";
  • if ($page>=$page_count){
  • echo "|最后一页|";
  • }
  • else{
  • echo "|最后一页|";
  • }
  • echo "";
  • }
  • else{
  • echo "

    现在还没有房屋租赁信息!

    ";
  • }
  • echo "
    ";
  • ?>
  • Example, php string splitting:

    1. $keyword="asp php,jsp";
    2. $keyword=str_replace(" "," ",$keyword);
    3. $keyword=str_replace(" ",",", $keyword);
    4. $keyarr=explode(',',$keyword);
    5. for($index=0;$index{
    6. $whereSql .= " And (arc. title like '%$keyarr[$index]%' Or arc.keywords like '%$keyarr[$index]%') ";
    7. }
    8. echo $whereSql;
    Copy code

    In order to support both spaces and Commas need to be replaced with unified commas in advance, that is, first replace all spaces with commas, then split the string by commas, and then splice the sql query statement in a loop.

    str_replace is the commonly used string replacement function in php. explode is a function commonly used in PHP to split strings into arrays.

    PHP implementation of multi-condition query example code

    Multi-condition query is often used, and I will share an example of second-hand house query. In this example, it is necessary to query the information required by customers through multiple conditions such as geographical location, property type, house price, house area, and information release date.

    Query file (search.php) 1. Generate query statements:

    1. $conn=mysql_connect("localhost","root","");
    2. $db=mysql_select_db("lingyun");
    3. $query="select * from message where tradetype= '".$tradetype."'"; //Transaction type, such as renting, selling
    4. $SQL=$SQL . "wuye='" . $wuye . "'";
    5. if($housetype!="No limit" ){
    6. $query.=" && housetype='".$housetype."'"; //House type, such as two bedrooms and one living room, three bedrooms and two living rooms
    7. }
    8. if($degree!="No limit"){
    9. $query.=" && degree='".$degree."'"; //The degree of old and new
    10. }
    11. if($wuye!="No limit"){
    12. $query.=" && wuye='". $wuye."'"; //Property type such as housing, shops
    13. }
    14. if($price2!=""){
    15. switch($price1){
    16. case "greater than":
    17. $query.=" && price> '".$price2."'"; //Price
    18. break;
    19. case "equal to":
    20. $query.=" && price='".$price2."'";
    21. break;
    22. case "less than":
    23. $query.=" && price<'".$price2."'";
    24. break;
    25. }
    26. }
    27. if($area2!=""){
    28. switch($area1){
    29. case "greater than":
    30. $query.=" && area>'".$area2."'"; //area
    31. break;
    32. case "equal to":
    33. $query.=" && area='".$area2."'";
    34. break;
    35. case "less than":
    36. $query.=" && area<'".$area2."'";
    37. break;
    38. }
    39. }
    40. switch($pubdate){ //Publish date
    41. case "this Within the week":
    42. $query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=7";
    43. break;
    44. case "Within the month":
    45. $query.=" && TO_DAYS(NOW( )) - TO_DAYS(date)<=30";
    46. break;
    47. case "within three months":
    48. $query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=91";
    49. break;
    50. case "within six months":
    51. $query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=183";
    52. break;
    53. }
    54. if($address!="") {
    55. $query.=" && address like '%$address%'"; //Address
    56. }
    57. if(!$page){
    58. $page=1;
    59. }
    60. ?>
    Copy code

    二、输出查询结果:

    1. if ($page){
    2. $page_size=20;
    3. $result=mysql_query($query);
    4. #$message_count=mysql_result($result,0,"total");
    5. $message_count=10;
    6. $page_count=ceil($message_count/$page_size);
    7. $offset=($page-1)*$page_size;
    8. $query=$query." order by date desc limit $offset, $page_size";
    9. $result=mysql_query($query);
    10. if($result){
    11. $rows=mysql_num_rows($result);
    12. if($rows!=0){
    13. while($myrow=mysql_fetch_array($result)){
    14. echo "
    $myrow[id] $myrow[tradetype] $myrow[address] $myrow[wuye]($myrow[housetype])[$myrow[date]]";
  • echo "
  • 详细内容


    没有找到满足你条件的记录
    & lt;/td>
    复制代码


    Statement:
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Previous article:A small example of getting the radio button value using JSNext article:A small example of getting the radio button value using JS

    Related articles

    See more