onclick

[nuttynibbles]

hi, i've got a page where it fills with images which link to individual website. so when a user click on one of those, i actually wanna do a count on how many user visited tt website. any idea how do i go about doing ti

[Weedpacket]

However it's done, I'm willing to bet that use of the shift key would be required....

[nuttynibbles]

huh? what was tt "weedpacket"

[nuttynibbles]

this is how i display the image that link to other website:

<?php

$index=1;
include ("dbmsCon.inc");
$strSql =  mysql_query('SELECT * FROM customer ORDER BY Count DESC'); //orderby descending 

while($row = mysql_fetch_array($strSql, MYSQL_ASSOC))
{					 
	echo $index;					 
?>
</td>
<td>
<?php						
	$website = $row['URL'];
	$click = $row['Count'];
	$image = $row['Image'];						
	/*print out data */
	echo"<A href='$website'><img src='Upload/$image' height=25 width=100 border=0></A> ";
?>

I tho of mayb count the number of onClick in the link. But well not successful. any idea guys?? or ladies?

[ChrisBoden]

Your best bet is to use a redirect rather than linking directly to the website. Instead of just echoing $website, echo something like redir.php?site=$website where redir.php contains something like:

$sql = "UPDATE customer SET count = count + 1 WHERE URL = '".$_GET['site']."'";

@mysql_query($sql); // surpress mysql errors so it'll still redirect

header('Location: ' . $_GET['site']);

[chrislive]

I think I remember some security issues regarding linking to sites from your sites in the way ChrisBoden mentioned.. I would suggest storing the URL in the database.. then you Select * FROM url WHERE id = '$_GET[id]' and your your link will be sites.php?url=1 (url_id)

[nuttynibbles]

hi chrislive,
Any example? im a little confuse..I have actually store the website url in database and put into the

echo "<A href='$website'><img src='Upload/$image' height=25 width=100 border=0></A> ";

so your url_id is the sql query?

[chrislive]

yeah the url_id is the row id.

so you will have a php script that prints your image and link.

echo "<A href='loadurl.php?id=$url_id'><img src='Upload/$image' height=25 width=100 border=0></A> "; 

then have your loadurl.php get the id $GET['id']
and then query the database SELECT url FROM imageurls WHERE id = '$GET['id']
then get your real URL from the query (say $url)

then header('Location: ' . $url);

[nuttynibbles]

erm are u saying there is a php file between index.php and the actually url page?

[hagen00]

that's exactly what he's saying...

[chrislive]

yes this is the only way to track how many times it was viewed

[nuttynibbles]

hey when i wanna extract the URL by comparing the rowID, i actually did :

$getUrl=mysql_query("SELECT URL FROM customer WHERE ID='$id'");
while($row = mysql_fetch_array($getUrl, MYSQL_ASSOC))
{
$url=$row['URL'];
header("Location:$url");
}

Is there anyway whereby i can remove the while loop and it still works??

[mrfritz379]

you dont need the loop to fetch a result row.

//update row count
mysql_query("UPDATE customer SET count = count + 1 WHERE ID=$id");

//execute select query
$getUrl=mysql_query("SELECT URL FROM customer WHERE ID='$id'");

//fetch the first row returned from select query
$row = mysql_fetch_array($getUrl, MYSQL_ASSOC);
$url=$row['URL'];
header("Location:$url");