Deprecated: implode(): Passing glue string after array is deprecated. Swap the parameters in /home/ct33h8azxpia/public_html/wp-content/themes/aquarella-lite/single.php on line 94
How Can I Insert Record into Table Using Mysqli and PDO? - Experts PHP

How Can I Insert Record into Table Using Mysqli and PDO?

When the table is created, this statement ‘INSERT INTO table_name’ is used to insert records into it.

To insert records in a table,The columns are not written under double (“”) or single (”) quotes.When numeric data type values ​​are written then they are not written in double or single quotes.String values ​​are given double or single quotes.NULL value is not written inside double or single quotes.

The insertion of records is done in this way.

INSERT INTO table_name (column 1, column 2, column 2, ..., column n)
VALUES('value 1', 'value 2', 'value 2', ..., 'value n')

Example for Inserting Record in Table using MySQLi

<?php
$server = "localhost";
$user = "root";
$password = "";
$db = "expertstutorials";
$conn = mysqli_connect($server, $user, $password, $db);
if($conn){
echo "Connected successfully.";
}
else{
echo mysqli_connect_error();
}
$table_insert = "INSERT INTO course(course_name, course_year)
VALUES ('b.tech', '4 year')";
if (mysqli_query($conn, $table_insert)) {
echo "Record inserted successfully.";
} else {
echo "Error inserting record : " . mysqli_error($conn);
}
mysqli_close($conn);
?>

Example for Inserting Record in Table using PDO

<?php
$server = "localhost";
$user = "root";
$password = "";
$db = "expertstutorials";
try{
$conn = new PDO("mysql:host=$server;dbname=$db", $user, $password);
echo "Connected successfully.";
$table_insert = "INSERT INTO course(course_name, course_year)
VALUES ('b.tech', '4 year')";
$conn->exec($table_insert);
echo "Record inserted successfully.";
}
catch(PDOException $e){
echo "Error inserting record : " . $e->getMessage();
}
$conn = null;
?>