Dreevoo.com | Online Learning and Knowledge Sharing
Home | Programs | Programming languages | PHP & MySQL | All in one PHP and MySql tutorial
Click to view your profile

All in one PHP and MySql tutorial

This tutorial will show you how to quickly learn basics of PHP and MySql and start developing PHP applications.

  Author: podtalje | Version: PHP and MySql | 10th June 2013 |  

If you want to start learning PHP and MySql, the first step is to setup complete environment on your local computer.

This will include Apache web server with PHP support, MySql database server and phpMyAdmin tool for managing database.


In the following first lesson you will learn some very basic steps in PHP which will be enough for you to write your first PHP program.


Often in PHP you want the same block of code to run over and over again.

Instead of adding several almost equal lines, you can use loops to perform this task much easier.


You will now need to learn how to handle user input.

In tutorial below you will see how to create a simple form in HTML and how to use this data in PHP.


Conditional statements if and switch are something that you will use in almost every PHP program.

They are used to perform different actions based on different conditions.


Functions in PHP are a block of code that can be executed whenever we need it, without the need to write the same code again.


To store data you will need a database.

The tutorial will show how to create MySql database with phpMyAdmin, one of the most popular applications for managing MySql databases.


SQL (Structured Query Language) is the most widely used language for interacting with databases.

This tutorial will show you how you can use SQL to insert or update data into MySql database.


Using SELECT SQL queries is the most common way to retrieve data from MySql and most of other databases.


In this lesson it will be shown how to use PHP to connect, run SQL query to retrieve data and insert a new record into MySql database.


To make general PHP knowledge from this tutorial useful, see the following example where you will learn how to create simple forum in PHP from scratch.

This tutorial will cover all the PHP knowledge from the steps in this tutorial.

  Please login to post a comment
  Click to open user profile  
thefansbuzz, 19th Feb 2023, 7:33 PM
Cheap SMM Panel Social Media Marketing is a huge field with a lot of competition. If you want to stand out from the crowd, you need to know how to find ways to make your content go viral. If you are interested in using social media to market your product, this service is perfect for you. The panel gives you access to hundreds of different social media sites, so that you can find new ways to market your business. Visit our website at: https://thefansbuzz.com/
online learning made for people