Links

[Billett]

Ok this should be simple but im stupid

I have a link, i wish once this link is clicked that it displays information from my database!

I DONT want the php code to be based in the page it opens if this is possible as the page will be used by other links?

Any ideas?

[nemonoman]

Your PHP script lives on the server.

It PRINTS or ECHOs output data that gets displayed as a standard HTML web page.

Unlike Javascript, PHP code NEVER appears in your web page.

example.

Save this script to the server in a file called 'info.php'

<? echo phpinfo(); ?>

now make a link like <a href=info.php>Click me</a>

The outpage returned will contain a boatload of html code and will display in your browser as a very fancy webpage. It won't contain the script "<? echo phpinfo(); ?>" anywhere.

[Billett]

i understand this, but i have a list of links on one page, and i want them all to go to the same page but depending on what link u click depends on what mysql command is run other wise i will end up with way to many pages of php on my server for me to keep track of

[nemonoman]

<a href=myscript.php?action=1>Click here to do action 1</a>
<a href=myscript.php?action=2>Click here to do action 2</a>

myscript.php says
<?
$dothis=$_REQUEST['action'];

if($dothis==1){echo 'You clicked action 1';}
if($dothis==2){echo 'You clicked action 2';}

?>

OR for a database query:
<?
$dothis=$_REQUEST['action'];
//your database access stuff goes here
if($dothis==1){
$result=mysql_query("SELECT NOW()");
$row=mysql_fetch_array($result);
echo "The time now is $row[0]";
}
if($dothis==2){echo 'You clicked action 2';}

?>

[Billett]

the last line of the code "if($dothis==2){echo 'You clicked action 2';} " would this be a repeat of what i have put in bold but obviously using '2' in stead of '1'?

<a href=myscript.php?action=1>Click here to do action 1</a>
<a href=myscript.php?action=2>Click here to do action 2</a>

myscript.php says
<?
$dothis=$_REQUEST['action'];

if($dothis==1){echo 'You clicked action 1';}
if($dothis==2){echo 'You clicked action 2';}

?>

OR for a database query:
<?
$dothis=$_REQUEST['action'];
//your database access stuff goes here
if($dothis==1){
$result=mysql_query("SELECT NOW()");
$row=mysql_fetch_array($result);
echo "The time now is $row[0]";
}
if($dothis==2){echo 'You clicked action 2';}

?>

[Billett]

Ok i did what u put and it worked thanks, i was also told i can use 'switch' in stead of 'if', how does this work?

[nemonoman]

[man]switch[/man]

switch ($dothis){
case 1:
//code
break;
case 2:
//more code
break;
//etc.
}

[Billett]

ta got that working now 🙂

[Billett]

ok for some reason it doesn;t show my results my code looks like this and my MYSQL command is correct as ive tested it in MYSQL command prompt but i cant seem to see whats wrong

My link to this page is this

<a href="products.php?action=0>Acer</a>

<?php
require_once('./config.inc');
$page_title = 'Digital Eye';
include_once('./header.html');
?>
<div id="pagecel1">
<? 
$dothis=$_REQUEST['action']; 
	require_once ('./mysql_connect.php');

switch ($dothis){ 

case 0:
$result=mysql_query("SELECT * FROM make, products, type WHERE make.make_id = products.make_id AND type.type_id = products.type_id AND make.make='Acer'")  or die(mysql_error()); 
echo "<div align=center>
  <table border=0 width=340 height=68>
    <tr>
      <td width=286 height=68><b>Product ID</b></td>
      <td width=286 height=68><b>Product Name</b></td>
	  <td align=left width=30%><b><font color=#000066>Description</font></b></td>
      <td width=340 height=68><b>Price</b></td>
    </tr>";

$row=mysql_fetch_array($result); 
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo "    <tr>
      <td width=286 height=68>{$row['product_id']}</td>
      <td width=286 height=68>{$row['product_name']}</td>
	  <td align=\"left\"><a href=\"view_product.php?pid={$row['product_id']}\">Click here for details</td>
      <td width=340 height=68>£{$row['price']}</td>
    </tr>\n";
	}
echo "</table>
</div>"; 
break;
} 

?>

</div>
<?php
include_once('./footer.html');
?>