如何在表上显示mysql结果 [英] How do I display mysql results on a table

问题描述

以下是我的工作搜索代码



如何组织结果？



< b>我尝试了什么：

Below is my working search code

What do i do to organise results?

What I have tried:

<?php
    $query = $_GET['query']; 
     
    $min_length = 3;
     
    if(strlen($query) >= $min_length){
         
        $query = htmlspecialchars($query); 
         
        $query = mysql_real_escape_string($query);
         
        $raw_results = mysql_query("SELECT * FROM avenuedata
            WHERE (`idno` LIKE '%".$query."%') OR (`username` LIKE '%".$query."%')") or die(mysql_error());
         
        if(mysql_num_rows($raw_results) > 0){
             
            while($results = mysql_fetch_array($raw_results)){
				echo "<h3>".$results['idno']."</h3>".$results['username']."<br>".$results['mmc']."<br>";
			}	
		}
		else{ 
			echo "No results";
		}
		
	}
	else{ 
		echo "Minimum length is ".$min_length;
	}
?>

推荐答案

查询 =

query =

_GET [' query' ]。

_GET['query'];

min_length = 3 ;

if（strlen（

min_length = 3; if(strlen(

这篇关于如何在表上显示mysql结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！