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 #181991 is a reply to message #181988]

Fri, 28 June 2013 23:16

David Robley
Messages: 23
Registered: March 2013

Karma:

Junior Member

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";
>
> ?>

Read the documentation for mysql_query again especially the arguments.

Note that the mysql_* functions are deprecated and you should consider using
mysqli_* - see the warning at the top of the documentation page.
--
Cheers
David Robley

Useless Invention: Waterproof teabags.

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: Fri Nov 22 03:26:33 GMT 2024

Total time taken to generate the page: 0.06920 seconds