Home
C
Java
PHP
MySQL
HTML
CSS
Bootstrap
JavaScript
jQuery
jQuery UI
XML
Ajax
Node.js
SQL
Python
Quiz
Projects
Interview Q
Comment
Forum
Training

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 →

PHP Tutorial

Control Statement

PHP Functions

PHP Arrays

PHP Strings

PHP Math

PHP Form

PHP Include

State Management

PHP File

Upload Download

PHP Mail

PHP MySQLi

PHP JSON

MySQL Tutorial

Interview Questions

PHP MySQL Insert Record

PHP MySQLi Insert Record Example