FUDforum: comp.lang.php » page "hit" counter

Home » Imported messages » comp.lang.php » page "hit" counter

Show: Today's Messages :: Polls :: Message Navigator

Re: page "hit" counter [message #181990 is a reply to message #181988]

Fri, 28 June 2013 23:00

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 6/28/2013 6:46 PM, richard wrote:
> I am attempting to create a simple hit counter so I know how many times the
> page was actually viewed.
> The table is a simple 3 column deal.
> 1) id (key)
> 2) name
> 3) hits
>
>
> the code I have tried below returns the following error:
> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
> resource
>
> What do I need to do to make this work right?
>
>
> <?php
> $con = mysql_connect('localhost','user','pass');
> if (!$con){die("can not connect: " . mysql_error());}
> mysql_select_db('richbull_top100',$con);
>
> mysql_query($con,"UPDATE counter1 SET hits=hits++
> WHERE name='pickhit' ");
>
> mysql_close($con);
>
> echo "done";
>
> ?>
>

Look up the mysql_query() function in the doc.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		page "hit" counter By: richard on Fri, 28 June 2013 22:46
		Re: page "hit" counter By: Jerry Stuckle on Fri, 28 June 2013 23:00
		Re: page "hit" counter By: David Robley on Fri, 28 June 2013 23:16
		Re: page "hit" counter By: Scott Johnson on Fri, 28 June 2013 23:36
		Re: page "hit" counter By: David Robley on Fri, 28 June 2013 23:51
		Re: page "hit" counter By: richard on Fri, 28 June 2013 23:31
		Re: page "hit" counter By: Beauregard T. Shagnas on Sat, 29 June 2013 00:31

Previous Topic:	$referrer = $_SERVER['HTTP_REFERER'] echo
Next Topic:	DIY finger tip typin - pace and code, (PHP open source)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 18:48:59 GMT 2024

Total time taken to generate the page: 0.03766 seconds