Jump to content

Execute a Mysql Query when hyperlink clicked


Vivid Lust

Recommended Posts

The ideal way would be to use ajax (I prefer xajax).  Otherwise the best way is to have it refresh the page with a get variable attached, and then run the query based off of the $_GET Variable.

 

Example:

 


<?
if(isset($_GET['command'])){
$command = $_GET['command'];

$query = "SELECT ... WHERE `field` = '$command'";
$run = mysql_query($query);

}
?>

<a href="#" onclick="window.location='filename.php?command=runQuery; return false;">Run Query</a>

 

You'd have to write the query to do whatever it is you need.  But that shows you an example of having a link run a php command.

Could you give an example with the following code to add +1 to hits?? Thanks

 

//connects to mysql .... then
$query = mysql_query( "SELECT id, image, url FROM banner WHERE id = '{$_GET['id']}'" )
or die(mysql_error());
$row = mysql_fetch_assoc($query);

echo( "<a target=_blank href=" );
echo $row['url'];
echo( ">" );
echo( "<img border=0 src=" );
echo $row['image'];
echo( ">" );
echo( "</a>" );
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.