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

Fri, 28 June 2013 23:36

Scott Johnson
Messages: 196
Registered: January 2012

Karma:

Senior Member

On 6/28/2013 4:16 PM, David Robley wrote:
> 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.
>

David

As i had to learn, Richard will not take notes or read manuals. He has
been warned numerous times to switch to mysqli and in particular how to
use the mysql_query function previously.

Just so you do not get frustrated.

Scotty

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 10:02:14 GMT 2024

Total time taken to generate the page: 0.04408 seconds