Display All Records Using A Link Either Html Or Php

[ianhaney]

Hi

 

I have manged to get the results displayed based on the users input but now I need a link to display all records using either a html or php link and am bit stuck on how to do it

 

Can anyone point me in the right direction please

 

Thank you

 

Ian

[trq]

Your going to need to be more descriptive I'm afraid.

[ianhaney]

Hi trq

 

Thank you for the reply

 

I need something like the following

 

they click on a link and that link then displays all the records in the database table that I have in mysql database

[scootstah]

Your post is a bit vague. You can iterate through multiple database results with a while loop.

 

$mysqli = new mysqli('localhost', 'root', 'root', 'dbname');

$query = "SELECT * FROM table";

// execute query
if ($result = $mysqli->query($query)) {
   // iterate through results
   while($row = $result->fetch_assoc())
   {
       echo $row['column'] . '<br />';
   }
}

[ianhaney]

Sorry am not very good at explaining things

 

I need a HTML link that when a user clicks on the link it will show all the records that are in my database table that is called managers

 

see below

 

<a href="linkname">Show all records</a>

 

I know it won't look like that as will prob be different in PHP but using a HTML link would be better

 

Sorry not sure how else to explain it

[scootstah]

There is no such thing as a "PHP link". You can link to a PHP page, but you would still be using HTML markup.

 

It sounds like all you need to do is make another .php file and then link to it with an anchor tag. So, for example, create "all_results.php", and then create a link with <a href="all_results.php">View All Results</a>

 

But I can't be more specific without knowing more about your environment.

Edited December 29, 2012 by scootstah

[ianhaney]

Hi Scootstah

 

That's works perfect, it will do as does what I need it to do

 

Thank you so much and thank you everyone for helping out