FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » page "hit" counter
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
page "hit" counter [message #181988] Fri, 28 June 2013 18:46 Go to next message
richard is currently offline  richard   
Messages: 213
Registered: June 2013
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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";

?>
Re: page "hit" counter [message #181990 is a reply to message #181988] Fri, 28 June 2013 19:00 Go to previous messageGo to next message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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
==================
Re: page "hit" counter [message #181991 is a reply to message #181988] Fri, 28 June 2013 19:16 Go to previous messageGo to next message
David Robley is currently offline  David Robley
Messages: 23
Registered: March 2013
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: page "hit" counter [message #181993 is a reply to message #181988] Fri, 28 June 2013 19:31 Go to previous messageGo to next message
richard is currently offline  richard   
Messages: 213
Registered: June 2013
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On Fri, 28 Jun 2013 18:46:16 -0400, 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";
>
> ?>

Heh.
Found a script on youtube that does the job I want.

Re: page "hit" counter [message #181994 is a reply to message #181991] Fri, 28 June 2013 19:36 Go to previous messageGo to next message
Scott Johnson is currently offline  Scott Johnson
Messages: 196
Registered: January 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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
Re: page "hit" counter [message #181996 is a reply to message #181994] Fri, 28 June 2013 19:51 Go to previous messageGo to next message
David Robley is currently offline  David Robley
Messages: 23
Registered: March 2013
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Scott Johnson wrote:

> 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

Thanks - I've seen previous dialogues with OP. Or perhaps that should be
monologues :-)
--
Cheers
David Robley

REALITY.SYS corrupted: Reboot universe? (Y/N/A)
Re: page "hit" counter [message #181997 is a reply to message #181993] Fri, 28 June 2013 20:31 Go to previous message
Beauregard T. Shagnas is currently offline  Beauregard T. Shagnas
Messages: 154
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
richard the sto0pid wrote:

> Heh.
> Found a script on youtube that does the job I want.

Lucky you, because you've never ever written a script of your own in your
life.

--
-bts
-This space for rent, but the price is high
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Sat Oct 21 21:13:49 EDT 2017

Total time taken to generate the page: 0.00744 seconds