Links using php and mysql

Billett

Im a little confused, i have various links on one page and i want them to each run a different MYSQL query but i want them to all display the results on a specific page (not all at once), other wise i will end up with many pages of code for each different link.

How can i do this?

Could anyone give me an example code?

Cheers

Chris

travelbuff

I think I understand what you are asking - if my answer doesn't help, please post more specifics.

The normal way to do what you are asking is to pass some values through a session variable or throught the URL that tell the destination page what action to take.

For example, the link could be:

mysite.com/detail.php?action=post&uid=somename

Then detail php would check the value of the variables and take some action:

if ($action=='post'){
require_once ('post.php');
} elseif ($action=='retrieve') {
require_once ('retrieve.php')
} else {
require_once ('default.php')
}

Billett

i think know what you mean but i dont really know how to use it

zudo

When you make the links send the variables. Make a mysql query to grab the information from the database acording to the variables. Then just display it.

mogster

Or you could do a switch:

<?PHP
$top = "<html><head><title>My page</title></head><body>"; 
$bottom = "</body></html>"; 
$page = $_GET['page']; 

switch($page) {
case "view":
echo $top;
echo "I'm the view-state<br>";
echo "<a href=\"".$_SERVER['PHP_SELF']."\">Link to default</a>";
echo $bottom; 
break; 

case "search": 
echo $top;
echo "I'm the search-state<br>";
echo "<a href=\"".$_SERVER['PHP_SELF']."\">Link to default</a>";
echo $bottom;
break;

default:
echo $top;
// example links would be
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=view\">Link to view-state</a><br>";
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=search\">Link to search-state</a>";
echo $bottom;
}
?>

knutm :-)

Billett

eh?

travelbuff

Good call mogster!! A switch would be by far the most efficient way to do what he wants. I don't know why I always seem to overlook it....

Billet, if none of this is making sense to you, I would suggest finding a tutorial on the type of application you are trying to build and following it. It may make life a lot easier for you. try doing a search here: http://www.hotscripts.com/PHP/index.html

The way I started learning was finding scripts that were close to what I needed, installing them and the customizing them to be precisely what I needed. I did this with 3 or 4 different apps (forums, classifieds, formmailers, etc) before I started writing my own.

Good luck!