- This topic is empty.
-
Posts
-
I don’t have any experience with these programs since I use Content Management Systems and these scripts have this functionality built-in.
I think you should try the program since it is very easy to install and it will not hurt your site nor interfer with search engines for sure.
MySQL programs are easy too. You do not have to know anything special about SQL. You only need to create a database and user, the program handles the rest. The big difference here is the source for the data storing. CCounter stores the data on a text file and the others on a database.
The only headache you’ll have is to configure all the links you want to track. Don’t know how much you have…
I’m using similar click trackers based on PHP and flat-files. I like working with them, since they are very light (fast) and easy to adjust.
Thanks for the input, guys. This weekend I think I’ll try out the Ccount tracker. Ultimately I would like to learn how to take advantage of MySQL, but not right now.
Ccount seems to return a 302 redirect if you use a server header checker, which means it will interfere with the spidering process. Need something that returns a 301.
Engineer, cowboy,
I’m using Ccount myself over at my main domain xxxhttp://www.wager2win.co.uk (not all URL’s) it works like a charm. Good thing about is it doesn’t require a db it’s all flat files
I had it set-up in under 5min (though you need to know a little php to get it going).
If you need some assistance send me a PM and I’ll help you out!
Cheers
Edit – as far as spidering issues I haven’t experienced any.
You can use Google Analytics to track clicks. http://www.google.com/support/analytics/bin/answer.py?answer=27246&hl=en
Wow… blast from the past.
A little update — I ended up never using Ccount. Instead, I taught myself how to use PHP and MySQL, and I built my own tracking system. Learning PHP and MySQL is by far the best thing I ever did for myself.
I’m a newbie to PHP and MYSQL …
And have written a little bit now … only very simple stuffCare to share the basic code and/or database design?
I’m sure you’ve already learnt and avoid some baisc pitfalls that I’d fall into.
:tongue:Engineer wrote:Wow… blast from the past.
lol…mental note to self check post date :banger:
php is cool programming skill to know, unless there is nothing else around to do what I need I normally just use free GPL scripts. Besides most you can add & change code to anyways
Cheers
TheGooner wrote:I’m a newbie to PHP and MYSQL …
And have written a little bit now … only very simple stuffCare to share the basic code and/or database design?
I’m sure you’ve already learnt and avoid some baisc pitfalls that I’d fall into.
:tongue:1. Most importantly, keep it as simple as possible.2. Use the appropriate data types in your MySQL database — i.e. if you are storing numbers, use number fields; if you’re storing text, use text, etc.
3. Use only as much space as you need for each row, but be careful not to make the length of the field too short. i.e. if you set it to be only 8 characters long, and if you try to insert something larger than that, it will cut off the information after the 8th character.
4. When working with PHP code — if you use if/else statements, make sure to close the statements with a } symbol. I don’t know how many times I’ve tried to debug a script only to find that I forgot to close an if statement with a }.
5. If you are going to allow your visitors to put data in a form and then insert the data into your database, you definitely need to learn about “validation.” If you don’t validate the information someone enters into your form, they can potentially submit data that will corrupt the database. Example — they could enter a ‘ (apostrophe) into one of the fields. Seems harmless, but it could really screw things up. Or they could put =”; into a form field, or perhaps a line of php script. You have to make sure that the visitor can only send alphanumeric characters; or you have to use some php code to convert any non-alphanumeric characters into HTML entities before it hits the database.
Hope that helps a bit…. Obviously there is much more to learn; I suggest reading php.net and/or Kevin Yank’s tutorial about how to build your own database driven website.
