Inserting Data into a MySQL Database Table

 

Inserting Data into a MySQL Database Table, in this article i will step through how  to insert data into mySQL Table.

Prior to that you need to complete  the items listed Below

1. Mamp or xampp with phpMyAdmin install into your Computer , check out here
2.  A Sample Database created Check out Here
3.  New User Created . Check out Here
4. A New table created , check out Here

Step 1

Start your My SQL and Apache Server

 

Step 2

Create a new Script

(1) First to connect to the Database

(2) Then insert data into “mytable “ reside in  “janedb”

<?php

/* Declare User connecting Credential*/

$hostName ="localhost";
$userName ="jane";
$userPassword ="jane";
$database ="janedb";

/* return connection status through $dbConnectionStatus Boolean Variable*/

/* using mysqli Object*/

$dbConnectionStatus = new mysqli($hostName, $userName, $userPassword,$database);

/* Check whether the User Succesfully connect to localhost and mydata Database*/
/* -> Access the instance "$dbConnectionStatus" variable property "connect_error " boolean */

if ($dbConnectionStatus->connect_error){

die("Connection failed: " . $dbConnectionStatus->connect_error);

}
/* SQL Script to insert data */

$sql ="INSERT INTO mytable (id,firstname,lastname, email,reg_date) VALUES (2, 'Jane','lian', 'jane85@hotmail.com','17/03/2020')";


$insertdata = $dbConnectionStatus -> query($sql);


if ($insertdata) {
echo "Data inserted into table ";
} else {
echo "Error inserting data into table: " . $dbConnectionStatus->error;

}

$dbConnectionStatus->close();




?>

Step 3

Save this File as “.php” extension in

C:\xampp\htdocs

 

If you want to change the root Location of the mySQL file check out this  article at step 3

 

Step 4

Test it

(1)Click Admin

(2) Click the  PHP File you have just created  in this example i name it  ” insertData.php”