PHP MySQL Insert Record

PHP mysql_query() function is used to insert record in a table. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

mysqli_query()
PDO::__query()

PHP MySQLi Insert Record Example

Example

<?php
$host = 'localhost:3306';
$user = '';
$pass = '';
$dbname = 'test';

$conn = mysqli_connect($host, $user, $pass,$dbname);
if(!$conn){
  die('Could not connect: '.mysqli_connect_error());
}
echo 'Connected successfully<br/>';

$sql = 'INSERT INTO emp4(name,salary) VALUES ("sonoo", 9000)';
if(mysqli_query($conn, $sql)){
 echo "Record inserted successfully";
}else{
echo "Could not insert record: ". mysqli_error($conn);
}

mysqli_close($conn);
?>

Output:

Connected successfully
Record inserted successfully

Next TopicPHP MySQL Update Record

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

PHP Tutorial

Control Statement

PHP Programs

PHP Functions

PHP Arrays

PHP Strings

PHP Math

PHP Form

PHP Include

State Management

PHP File

Upload Download

PHP Misc

PHP Mail

PHP MySQLi

PHP JSON

PHP OOPs Concepts

PHP Topics

PHP MCQ

Related Tutorials

Interview Questions

PHP FTP

PHP MySQL Insert Record

PHP MySQLi Insert Record Example

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler