insert php using mysql | Sharp Tutorial

PHP Introduction

Working with Forms

PHP with MySQl

Advanced PHP

Object Oriented PHP

insert into mysql using php

Using php we can fire insert query to insert the data into mysql table.We need to connect php with mysql database .For taking input values we need to create HTML form as below example .

Here we register the student details (few fields only for example) into mysql table.

Student Entry Form using HTML

<html>
<body bgcolor="gray">
<center>
<form name="studentform" action="insert-student.php"  >
Name<input type="text" name="sname"><br>
RollNo<input type="text" name="roll"><br>
Course<input type="text" name="course"><br>
<input type="submit" name="ok" value="submit">
</form>
</center>
</body>
</html>

PHP register page to take input from user and insert into mysql table

 <html>
 <?php
  $host="localhost";
  $dbuser = "root";
  $password = ""; // change password as per your database.
  $dbname=     "sharp_tutorial";
  $conn = mysqli_connect($host, $dbuser, $password,$dbname);
  $sname=$_GET["sname"];
  $rollNo=$_GET["roll"]; 
  $course=$_GET["course"];
  $query="insert into student(sname,rollno,course) values('$sname','$rollNo','$course')";
  mysqli_query($conn,$query);
  echo "student registered successfully";
  ?>
  </html>

Above PHP page gets the input from html form and insert the record into mysql sql table.Above program uses $_GET[] method to get the input values as form has no method so get method by default.

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

insert into mysql using php

Student Entry Form using HTML

PHP register page to take input from user and insert into mysql table

Video/ C Introduction