PHP MySQL: Introduction

This entry is part 1 of 17 in the series PHP & MySQL

Now that we have learnt some basic PHP and gone through CRUD functions in SQL, we will now move to learning how to retrieve and store data into database using PHP.

It’s been said that PHP works very well with MySQL.

That is mainly because of the many functions available in PHP for manupulating MySQL database.

A learning of PHP & MySQL is a learning of those PHP functions.

In PHP 5.3, a new mysqli class was introduced allowing persistent connection support.  This is to reduce overhead created by multiple connections.

We will use this new mysqli class in this tutorial.

MySQL Clients: Toad for MySQL

This entry is part 3 of 8 in the series MySQL Clients

Now that we have created a database and a table artist using PHPMyAdmin, we will move on to using Toad for MySQL to access the database we have created.

Please download Toad for MySQL here.

Launch Toad for MySQL.

toad

Make sure that WAMP server is also started in your PC.  From Toad, we need to make a connection to the database allartist.

Click on File -> New -> Connection.  Type in the necessary information as shown in the screenshot.

toadconnection

Click on connect and you should be able to see the database allartist on the left column.

toadconnection1

You now have made a successful connection to the database allartist.

MySQL Clients: Client Access

This entry is part 1 of 8 in the series MySQL Clients

This series is a short introduction to using PHPMyAdmin or Toad for MySQL to access MySQL DB.

In an earlier post, I have mentioned about downloading WAMP server and install it into your PC.  With WAMP, you will get an Apache web server, PHP, MySQL and also PHPMyAdmin.

PHPMyAdmin is a web based client access to MySQL.  As it is web based, it is not as user-friendly as other client access programs such as HeidiSQL and Toad for MySQL.

We will use Toad for MySQL throughout this tutorial but first, let’s go through some simple steps where you could create a database and a table using PHPMyAdmin.

SQL: Database and tables

This entry is part 2 of 20 in the series SQL Tutorial

In a database, the main thing that we need to know is that database can contain many tables.

For learning purposes, the examples that we are going to use will contain only one or two tables.

In a table, there are rows and columns just like an Excel sheet.

Below is a screenshot of using SQL Advantage to access a Sybase database.

sql_advantage

Sybase and Oracle are two big corporations making database related products.  MySQL database is also an Oracle product.

MySQL is open source and it powers many web sites and blogs including this codecrawl.com.