PHP PROGRAM TO INSERT DATA IN MYSQL DATABASE OR TABLES

At first, create a MySql database named "Database1" inside that create a table named "tbl1". Inside that table, create "name","age" table fields. That's all the things you need to do in database section. 

Now copy the coding provided below and save as in .php extension inside servers root folder. If worked properly , it will display success or else failed.

Insert Data into database Program in PHP

<?php $con = mysqli_connect("localhost","root","","Database1") or die ("connection error"); //Establishing connection $query = "insert into tab1 (name,age) values ('subeesh','22')"; // query to execute $result = mysqli_query($con,$query) or die("query error"); // query execution /* Checking Query execution */ if($result == 1) { echo "Success"; } else { echo "Failed"; } $con->close(); ?>

---

Click Here to get -- > Php Tutorials by Studentsblog100

---