How do I display mysql results on a table

Question

0.00/5 (No votes)

See more:

Below is my working search code

What do i do to organise results?

What I have tried:

PHP

<?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;
	}
?>

Posted 31-Dec-16 20:53pm

Member 12929725

Updated 31-Dec-16 21:07pm

Thomas Daniels

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2016-12-31T21:07:00

Solution 2

Apart from solution 1, to organize data into table, you have to create it programmatically in your read row while loop, see one of my previous answer[^].

Posted 31-Dec-16 21:07pm

Peter Leow

Updated 31-Dec-16 21:08pm

v2

Comments

Thomas Daniels 1-Jan-17 3:15am

+5; I had overlooked that part :-)

Peter Leow 1-Jan-17 3:23am

Thank you, and Happy New Year to you!

Thomas Daniels 1-Jan-17 3:24am

Same to you!

Member 12929725 2-Jan-17 4:12am

Hello.. The code did not work. Syntax Error.. Unexpected Else

Peter Leow 2-Jan-17 4:25am

What code? My example does not have "Else". If you encounter a new problem after trying, post it as a new question.

Member 12929725 2-Jan-17 5:29am

My code is as shown above.. it works but results display as a list..(following each other in breaks and there is no titles for the results)

Peter Leow 2-Jan-17 6:02am

Apparently, you did not visit the link that I have provided in my solution.

Member 12929725 2-Jan-17 15:10pm

i did.. and read it and implemented.. would have shown you via team viewer.. plus what happens when i switched the code to the provided one..

Thomas Daniels · Answer 2 · 2016-12-31T21:02:00

Firstly, you appear to use string concatenation to form your queries. Don't do this. You are vulnerable to SQL Injection[^]. Use prepared statements and parameterized queries.[^]. (Edit: ah, you are using mysql_real_escape_string. That should be fine then... nevertheless prepared statements and parameterized queries would still be my recommendation. Aside from safety you also have easier-to-read queries.)

About the organizing of the search results... you probably want to use to sort the rows using "ORDER BY"[^]. If you want to sort the rows based on the username, add this to your query:

ORDER BY username

... or if you want to sort them by "idno":

ORDER BY idno