PHP

• Installing PHP on IIS7 Fast-CGI
• PHP Array Tutorial
• 3 Functions to create an Array from a DB Table
• PHP-MySql beginners intruduction
• PHP-MySql beginners Create database
• PHP-MySql beginners inserting
• PHP-MySql beginners retrieving
• PHP-MySql beginners updating
• PHP-MySql beginners deleting
• How to add days to a date
• How to find the end of month
• Today's date with time zone
• Find your age
• Installing IIS7 on Windows7
• Installing PHP on IIS7 Windows7
• Installing PHP on IIS7 Windows7 pag2
• How to get Screen Resolution with JS and PHP
• Installing Apache on Win 2003 64bit
• Installing PHP on Win 2003 64bit
• Installing PHP on win 2003 64bit 2pag
• Installing PHP on IIS 6.0 win 2003 64bit
• Installing MySql on Win 2003 64bit
• Configuring MySql on Win 2003 64bit
• Installing Apache on Vista
• Installing PHP on Apache and Vista
• Installing IIS7 on VISTA
• Installing PHP on IIS
• Installing PHP on Apache
• Installing IIS7 on Vista
• Installing PHP on IIS7 VISTA
• Set IIS7 to Handle PHP in Static pages
• Installing MySql on Vista
• PHP Include
• PHP on HTML pages
• Installing MySql


• Installing Apache on Windows

Useful

Links

Free technical Tutorials At techtutorials.net

Link Exchange at iWEBTOOL.com

 

Added on   13.11.09

Clicks     8961

Rating:   4.65   out of 5 from   11   raters

5 Excellent 4 Very Good 3 Good 2 Fair 1 Poor          rate this page

Not rated yet.Be the first one to vote!!

rapid prototyping

PCoIP

There are N. 1 Comments for this Article
Ask any relevant question in the Comments or leave your valuable feed-back

  Print version of this article

  Add it to your favourite!

 email this page to a frend

MySql and PHP Tutorial

• Intruduction to MySql
• Create Database and Tables
• Inserting Data
• Retrieving Data
• Updating
• Deleting

Learning and using PHP language without interacting with a Database doesn't have much sense at all,and specifically MySql,and ,while you learning you'll be delighted to discover how simple it is.I'll show you how to crate a Database and Tables where to store your data and then how to retrieve and manipulate the data you stored. Obviously, I assume you have a basic knowledge of PHP and SQL before you start this tutorial.If you don't ,it may be better if you improve your PHP before you start. You can have a look at the PHP Manual and the SQL Manual

As I said briefly before, there is not reason to have a PHP based dynamic webpage without a Database but,I can show you some of the hundreds of reasons   for having Php and MySql working hands by hands

1. You can build your own Forum.Hundreds of forums or message boards)\ on the internet are run using PHP and MySQL. You can store thousands of messages in a MySql Database,with not hassle
2. Rating System. You can have a rating system and store all the votes in a MySql database and be updated instantly.
3. Login system,where all your members will be stored in a table and theyr details can be retrieved for all your needs
4. A Traffic Analyzing System, you can use the database to store lots of important info's regarding your visitors, such as how many hits, where they came from, whether they referred from a search engine  or no, and tens of useful information
5. Your visitors Comments on all the pages,and,even in this case all the messages and sender info such as IP address may be stored in a MySql database.
6. You may also run the entire website with few scripts that retrieve all data from a database

Things you need

If you are thinking to host your website using a hosting service  on the net, make sure they have PHP and MySql , or else, if you have only a small website you can have a look at this article that explains how to host a website at home with your own computer .I can ensure you it's easier to do it than what you ever thought it was.Also,if your option is hosting your website at home,you will have to install PHP and MySql as well,on your computer.You can learn how to do it following these tutorials:

There is not comments for this page yet.Be the first to post one   add a comment