[SOLVED] Increase image views count

[MaDSEGA]

Hi there, if someone could help, it would be much appreciated  I'm trying to make a script to increase the views count of an image and I just can't seem to get around it (i'm a noob  ). I tried to search the forum but i cannot find any relevant solutions. Here it goes:

 

mysql_select_db();

$query_Banners = "SELECT * FROM bannners_image ORDER BY im_id DESC";

$Banners = mysql_query($query_Banners, $username) or die(mysql_error());

$totalRows_Banners = mysql_num_rows($Banners);

 

and when i click the image link, should increase the views count (im_count)

 

while ($row_Banners2=mysql_fetch_array($Banners))

 

$div_output.=<<<END

<div>

  <a href="images/{$row_Banners2['im_image']}" rel="lightbox" title="{$row_Banners2['im_description']}" target="_blank">

  <img src=images/thumbnail/{$row_Banners2['im_thumbnail']} alt="" /></a>

  <p align="middle">Views:{$row_Banners2['im_count']}</p>

</div>

END;

echo $div_output;

 

Thank you in advance  The page is http://www.madeofstars.org/banners.php

[JasonLewis]

Look up UPDATE for MySQL.

 

$update = mysql_query("UPDATE `bannners_image` SET `im_count`=(`im_count`+1) WHERE `im_id`='{$idvar}'");

[MaDSEGA]

Well, i tried every possible combination, put the line in the <a href> still nothing  Someone suggested using javascript. But that's another dead end 

[DeanWhitehouse]

so you want it for when they on the image to add a count? not when it loads the page with the image?

[MaDSEGA]

Exactly. When the image is clicked, it should increase the count.

[JasonLewis]

You would need to use AJAX, if you want it done client-side. You'll end up using the code I've supplied above. Search around for AJAX.

[MaDSEGA]

Thanks guys... i'll try and figure it out  :-\

[DeanWhitehouse]

you don't need ajax, you just need javascript, something like

<script type="text/javascript">

function AddCount()

{

?>

$i++;

mysql_query("UPDATE table SET count='{$i}'");

<?php

}

</script>

<img src="" onClick="AddCount()">

 

that should do the trick

[wildteen88]

no it wont, You cannot mix PHP and Javascript like that. The only way is AJAX.

[DeanWhitehouse]

i've mixed php and js before and it works fine.

[wildteen88]

I fail to see how. PHP is long done before JavaScript is called.

If the following is your PHP script:

<script type="text/javascript">
function AddCount()
{
<?php
$i++;
mysql_query("UPDATE table SET count='{$i}'");
?>
}
</script>
<img src="" onClick="AddCount()">

 

This will be the output (when you view the source code):

<script type="text/javascript">
function AddCount()
{
}
</script>
<img src="" onClick="AddCount()">

When you click the image, it'll call the AddCount javascript function but nothing else will happen.

 

Yes you can use PHP set JavaScript variables, but you cannot get JavaScript to run snippets of PHP code. The only way is AJAX.

 

PHP is parsed server side, JavaScript is client side (web browser).

[DeanWhitehouse]

yer, what i realised was that the php i use in javascript are static variables. like echo date(); to get the time .

[MaDSEGA]

Guys nevermind. It's too much trouble. I don't want to see view count anymore )  Thank you all