12 replies to this topic

[Blimp]

Hi Guys!

I don't think i'v ever actually posted on this forum before, so i'd like to say Hi to everyone!

I've recently created a Arcade style website (ConcaveGaming) but I seem to be lacking a lot of traffic. Well, I get about 200-300 visits a day. This is a great start, however, I'm looking to expand this up to about 1000 in the next month.

I thought of an idea of getting users to compete in getting the most hits on my website - the person with the most hits at the end of the month would win a prize. Now, I thought i'd be best asking you PHP guys about this, seeing as it's pretty much all I can use..

So what am I looking to achieve?

Firstly, I need to create a PHP file that will update a users hits every time somebody visits.
For example, if somebody visited: "http://www.concavestudios.com/refer.php?username=[COLOR="rgb(255, 0, 255)"]blimp[/COLOR]"
then the PHP file would recognize this and increment the username (Highlighted in pink) by one.

Secondly, it would be nice if the users could check how many hits they have actually got. However, I don't think there is any need for passwords with this.

Would anybody be able to help me, or should i say, practically script this for me? I have no knowledge of PHP whatsoever and don't think it's a great idea to learn, seeing as I already have a lot of programming languages in my tiny head.

Also, if this helps, i'll put my database details down...

host:ConcaveGaming
username:alex
databasename:users
password:password11

And no, that's not my real password;)

Thanks for your help in advance!

Blimp

[Blimp]

Looks like the highlighting didn't work.. Sorry about that guys. Also, I can't seen to edit it.

[plb]

Hello Blimp.

Add another table of type int to your database, name it whatever you like (for example, hits). You can simply use MySql update to insert new value there.

[Blimp]

I know that. I need to know how to edit the data via PHP.

[plb]

<?php
$conn = mysql_connect("host", "user", "password");
mysql_select_db("database_name") or die(mysql_error());

mysql_query("UPDATE table_name SET hit = '$new_value' WHERE name = '$user';");

mysql_close($conn);

?>

[Blimp]

And what will this do?

[plb]

this code will be part of a page, when user loads it this will update user's hits with new value. new_value = old_value + 1. I hope you know how to get data from MySql.

[Blimp]

Okay. Well, I'm guessing that using this snippet in my script and replacing the database name,password and table should do the trick?

[plb]

I hope so. If there is something else, I'll try to help you.

[Blimp]

Thanks. Would you be able to email me on:
admin@concavestudios.com

As i'm not sure how to set up the table properly. thanks!

[plb]

You can use phpmyadmin. It is very simple.

[DEViANT]

Actually, the SQL query can be made much easier. This will work :

Quote

UPDATE table_name SET hit = hit+1 WHERE name = '$user';