This was one of my first script that I made using php and mysql. It’s pretty short and straight forward. It’s a simple counter script. I know if you google it, you will get thousands of them.
Well, Lets get started.
Step 1: Creating a Table for your counter in MySQL
First thing you need to do is to have a database and have a MySQL table for your counter. I’m going to assume you already have a database to work with so I’ll take it from creating a table for your database. I use PHPmyAdmin to manage my databases.
In your database, run this SQL syntax;
CREATE TABLE mycounter (
counter int )
This will create a table named “mycounter” and a column named “counter“. Next step is to set your counter zero or to some other number you want. Here is SQL Syntax for it;
INSERT INTO mycounter (counter)
VALUES (0)
This will set counter column in your “mycounter” table to “0″. If you want your counter start with a different number, replace “0″. You can also use this SQL syntax to reset or change it.
Step 2: Getting the Value and Updating it
Next thing to do is to get the current value and update it every time your page reloads.
Here is the PHP code, put this in your PHP file;
//configs $dbhost = 'yourhost'; $dbuser = 'yourusername'; $dbpass = 'yourpass'; $dbname = 'yourdb';//connects to your database $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql'); mysql_select_db($dbname); //gets current value $query = "SELECT * FROM mycounter"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($result) or die(mysql_error()); $cont=$row['counter']; $new = $cont + 1; //prints out the updated value from last update echo$new; //updates your column with the new value mysql_query("UPDATE mycounter SET counter = '$new'"); //close connection mysql_close($conn);
That’s it you are done. Save your file and run it. If you did everything correct, it should work properly. It does for me. Again, I’m not a PHP Master or anything like it. I don’t guarantee anything. This is what I have for my website. It works fine. As said above, there are tons of ways to accomplish something using PHP. I did one of them.
I have changed our blog theme one more time. I think it looks better. I’m going to keep it with this way for a while and see what happens. Theme name is “Daleri Selection 1.0″. It’s available at wordpress theme site. You can also visit the maker’s website to download or see demo. Both links are available at the bottom of this site. Scroll down.
One of the leading forum software. It has a lot of neat features. SMF Team has released a beta version about a month ago. There are a lot of changes from its previous version 1.1.4, Soon they will be releasing a stable version for SMF 2.0. SMF offers wide range of add-ons and themes that you can download from their site. There is also a mod called “tinyportal” which gives you the option to make a portal out of your SMF Forum.
One of the first PHP and MYSQL driven forum software also the most popular forum software. PHP 2.0 was big success and it’s been around the web for long time. But time has done its job. A lot of people had the chance to use this software at least once in their web experience. As time went by, a lot of bots were developed and started to spam boards all over web. After a year of waiting, PHPBB team released its latest version PHPBB3. They made a lot of changes and some still claims that new Admin Panel is hard to manage it. But still, it’s great software.
MyBB is another software that has been receiving good reviews from a lot of people. It provides some good features beside its wide range of themes and modifications. MYBB community growing fast. Detailed stats are available at the site. MYBB has been around for sometime now. MYBB developers started XMB. They left and started MYBB. They are certainly in the race with larger systems like PHPBB.
XMB team has been lost after its team left working for this project. Some took over and tried to continue and but never got on the road. I have used one of their last version. Product they provide is not bad. Unlike many others, It’s easy to edit. For instance, their theme is very user friendly and file free. However, XMB team has been little slow fixing their security holes. There are some known bugs need to be fixed.
This is my top four, I have used all of them for some time and I still use SMF for my other website. Also, I have been reading reviews on other free forum softwares. Phorum is one of the software I look forward to use.
We have had our problems with our old theme. It was needed to be changed. I found this theme at Wordpress. I have made couple of small changes and uploaded new theme. Everything is working properly now. I’m also designing a custom theme for Randomgap. Until then, we are going to keep this one as our default theme. It hasn’t been long since we switched to Wordpress. So we are still learning.
With the help of AJAX, you can search domain names to see if they are taken or not in seconds. There are websites that provide this service. Here is couple of them.
I just discovered this website through Google search. It provides instant domain search with .com, .net, .org, .biz, .info, .us extensions. It works properly. Unlike some other websites, it doesn’t crash your browser. What I like about this web site is that they provide bunch of other tools that can help you come up with a good domain name. If you are having problems finding a new name for your project that you want to start, this web site can certainly help. It has tools like listing all available three or four character domain names.
Bustaname is another site that provides instant domain search with .com, .net, .org extensions. You get a tool called “word combiner” which puts all of the words you type in together in all possible ways and checks if that combined name is available. It’s useful when you already have a specific word that you want to have in your domain, but that word is probably taken. So what you can do is that you can go to this site and add suffixes and prefixes to find a domain and still have that word you wanted to have.
Yet another site provides the same service with different purpose. You can check domain names with .com, .net, .org extensions. The neat part of the service they provide is that you can have the tool on your own website or on your google home page. Links are avaliable at the site. You can visit “/widget” dot com to get the HTML code to put it on your web site.
Instantly check your domain name (.com, .net, .org, .info, .biz, .us). This site allows you to download the script for this tool. So you can have your own service at your own site.
The part that is being discussed on a lot of blogs of this service is that whether these sites steal your domain name or not? Sites that provides this service are associated with popular hosting sites. Even though, they say that they don’t save your names in their database. You never know. So what I’d suggest is that you register your name right away. You can get up next morning and see your domain name registered by someone else.
Well, Scrubs is having its last season on TV. It’s been seven seasons since it started. I always liked watching Scrubs especially “Bob Kelso” character, the Chief of Medicine at Sacred Heart. He is one of my favorite character in the show. But he is leaving Scrubs. You can watch the whole episode at “nbc.com/scrubs” or
We have had our problems with our old theme. It was needed to be changed. I found