MySQL Database Creation using wampserver PhpMyAdmin

PhpMyAdmin is web base software used for creating and maintaining MySQL databases.
This tutorial is designed to get you starting with the basics of phpMyAdmin. Select the phpMyAdmin from the wampserver menu as shown below.

phpMyAdmin: Create new database

1. Create a new database. Provide the database name and set the connect type as utf8_bin

2. Create a new table for the database.

3. Add the data members in the table. Make sure to set the first data member index as primary.

4. Click on the Save button. The following screen should appear

phpMyAdmin: Create PHP code

$sql = "CREATE TABLE `_apachenet_`.`members` (`id` INT(255) NOT NULL, `firstname` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `lastname` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `email` VARCHAR(126) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin;";

Click on export tab and generate the SQL table.