Create your own guest book or a shout box using php and sql

This tutorial requires some knowledge in php, sql and a little html, if you are new to these you can learn them from here

HTML

Php

SQl

You can find some very simple and short tutorials in the above links, first read these three tutorials. They will not take much of your time if you have a background using C, ASP or another programming language. For beginners it may take some time. Don’t worry if you are struck somewhere, we are always there to help you.

PHP is a robust, server-side, open source scripting language that is extremely flexible and actually fun to learn. PHP is also cross platform, which means your PHP scripts will run on Unix, Linux, or an NT server.

MySQL: SQL is the standard query language for interacting with databases. MySQL is

an open source, SQL database server that is more or less free and extremely fast.

MySQL is also cross platform.

First you need to install a web server, PHP and SQL. For installing instructions you may refer to my previous post
http://techbu.com/2007/10/27/start-a-webserver-with-php-and-mysql-support-on-your-home-computer/

After you have installed the webserver php and sql create a database for the guest book

Creating the database:

Open the command prompt and go to the directory where you installed mysql,then go to bin and type mysql –u username –p password (default user name is root and there is no password). For example my mysql directory is in d:/xampp/.  So this is what I type at the command prompt

Creating a MySql database from command prompt

 To be continued in my next post….

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <span style="">