Table Demo

#### What Will I Learn? - You will learn how to create a simple table - You will learn how to retrieve data from mysql database record and show in html table #### Requirements - XAMPP application - basic html, php, sql programming - web browser (mozilla firefox, google chrome, etc) #### Difficulty Basic #### Tutorial Contents MySQL application is an open-source application for database management system which using sql command such as DDL (Data Definition Language : create, alter, drop), DML (Data Manipulation Language: select, insert, update, delete) and many others command. MySQL can be integrated to any programming language such as Java, .Net, C, C++, PHP, and many others. In this tutorial, we will discussed the way creating mysql record data and how to display it in html table using **mysqli** function in php language. For more details, let's follow this steps: - create folder in C:/xampp/htdoc/your_folder_name in this case, i named the folder with 'utopian_tutorial' ![folder.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519057298/ogheimrfkj0uufk4lov9.png) - create html table - create simple mysql record at least 3 records - write php language which has mysql-native command to retrieve record #### Create a Simple HTML Table For example, i just create a table by 3 cells and 3 rows. don't forget to put a filename **table.php** or another filename using php extension (*.php) and save it to **C:/xampp/htdoc/utopian_tutorial** ``` Table Demo

Name	Address	Email
Sayed Khaidir Ali	Lhokseumawe	said_khaidirali@yahoo.com
Example2	Example2	example2@example.com
Example3	Example3	example3@example.com

``` and we can see the result on the picture below ![table.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519058638/xfjgtsuxa49milh9gpkl.png) now, we have to create a simple mysql database record using mysql command line as the follow ``` create database utopian_tutorial; use utopian_tutorial; create table sample_one( name varchar(20), address varchar(50), email varchar(40), primary key(name) ); insert into sample_one values("Sayed Khaidir Ali","Lhokseumawe","said_khaidirali@yahoo.com"); insert into sample_one values("Ardi Fitra","Lhokseumawe","ardifitra@yahoo.com"); insert into sample_one values("Wais Alqarni","Lhokseumawe","wais07@yahoo.com"); ``` and we can see the picture below to practice directly ![mysql.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519058505/askvef0trcapclvblkpd.png) Now it's time to display mysql record to html table using php language, use the code as follow : - create database connection first and named the file as **db.php** ``` connect_error) { die("Connection failed: " . $conn->connect_error); } ?> ``` and then modify **table.php** file as follow ``` Table Demo query("select * from sample_one"); while($row=$result->fetch_array()){ ?>

Name	Address	Email

``` here is the explanation of the code ``` $result=$db->query() is function to call a query of mysql command that support on php version 7.x and the query result is stored to $result variable $row=$result->fetch_array() is a function to retrieve data from the query that has been stored in $result variable and the record is stored in array object $row['name'],$row['address'],$row['email'] contains record data according to field name of the mysql table data and we can display using echo command in php language ``` and we can see the result of table data that has been retrieved from mysql record and displayed in html table ![hasil.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519061413/tbyxrzqlaqj5esedvags.png)

Posted on Utopian.io - Rewarding Open Source Contributors

abuthalib