PHP MySQL Tutorial: Create a Simple View Counter -HD-

In this tutorial, you will learn how to create a simple view counter with PHP and MySQL.

Be sure to SUBSCRIBE because there will be a new tutorial every week.

Follow me on Twitter @RiverCityGraphx

Like us on on facebook: http://on.fb.me/i8UQpt

Suggest tutorials at http://www.rivercitygraphix.com

For project files, help forums, and more check out the website at http://www.rivercitygraphix.com

For business related inquires contact us at rivercitygraphix@yahoo.com

Category:

Education

Tags:

• PHP
• MySQL
• XAMPP
• Database
• View
• Counter
• Hit
• Count
• Query
• Update
• Select
• Print
• Variable
• Var
• Visitor
• Visit
• Table
• Include
• Process
• Receive
• Post
• Information
• Data
• Configuration
• Private
• Testing
• Server
• Webserver
• phpmyadmin
• Admin
• Dreamweaver
• Script
• Code
• Tutorial
• Video
• Voice
• Tut
• Create
• Make
• Style
• Web
• 2.0
• CS2
• CS3
• CS4
• CS5
• Elements
• Creative
• Suite
• Premium
• Flash
• HD
• Widescreen
• Wide
• Screen
• Definition
• How
• To
• Easy
• Beginner
• Quick
• Adobe
• River
• City
• Graphix
• Graphics

[justTVsk]

what kind of web developer uses IE ??? what a joke :D but a great tut

[RiverCityGraphix]

@justTVsk Web developers should use all major browsers to ensure their content looks right on each of them.

[RealityFuzion]

i dont have dreamweaver do u buy it?

[RiverCityGraphix]

@RealityFuzion Yes, you can buy it from Adobe.

[mattz084]

Im having trouble. Ive typed in all the code correctly using Dw and the counter is obviously working because everytime I refresh the page the views on my viewcounter database on myphpadmin increase by 1. However, when I try and open the webpage with firefox it ignores all of the php code and just displays the html, ie. "There are views on the page".. Any ideas what Im doing wrong? thx.

[RiverCityGraphix]

@mattz084 You need to first make sure you are printing out the variables correctly. If all of that checks out your problem might be that you are not using a local server like XXAMP. You will not be able to view the php of a file without either using XXAMP or uploading to a web server. I have a tutorial that shows you how to set everything up if this is the problem. If you are using XAMPP then make sure apache is turned on.

[glonich]

mysql_fetch_array() expects parameter 1 to be resource

[ActiveBassDestroyer]

@vanko1997 you need to put ?> to stop that .

so basically it starts with <?php needs to end with <?

[TottoBennington]

@glonich $sql = mysql_query(" SELECT * FROM visitas WHERE id ='1' ") or die(mysql_error());

It is the solution.

[jossmalo]

Awesome Tutorial! Thanks a lot, very helpful. Easy to understand, and you talk quick. Right too the point. I like that.

Keep up the great work!

[prettyduff24]

Hi, I followed your tutorials. Now I have my own database at my localhost. But, I have a problem how can i publish it with my database on it. so that, Through a Internet connection. My only problem is to create a web server with a database on it. Hope you can help me. I'm really at my shortest time for the project . Please Help me asap. More power

[parutonkaian]

@justTVsk all web developers use IE fyi...

[WhiteShadowVideos]

How can I add more than one to my webpage

[vanko1997]

Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\simplecounter.­php on line 8 need help please

[sunil1286]

I find your tutorials to be extremely useful. Thank you very much. Couldn't just get better than this.