PHP MySQL Insert Data

Insert Data Into MySQL Using MySQLi

After making a database and a table, we can start putting information in them.

Here are some rules about how to use language:

PHP needs to quote the SQL query.
Quotes must be used around string values in the SQL query.
Numeric values must not be quoted
The word NULL can\’t be used in a quote.

Adding new records to a MySQL table is done with the INSERT INTO statement:

INSERT INTO table_name (column1, column2, column3,…)
VALUES (value1, value2, value3,…)

Visit our SQL tutorial to learn more about SQL.

In the last chapter, we made a table called \”Student\” that was empty and had four columns: \”id,\” \”firstname,\” \”lastname,\” and \”email.\” Now, let\’s put the information into the table.

Example

<?php
$servername = \”localhost\”;
$username = \”username\”;
$password = \”password\”;
$dbname = \”school\”;

// Create connection
$link = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$link) {
die(\”Connection failed: \” . mysqli_connect_error());
}

$sql = \”INSERT INTO student (firstname, lastname, email)
VALUES (\’ram\’, \’lal\’, \’ramlal@example.com\’)\”;

if (mysqli_query($link, $sql)) {
echo \”New record insert successfully\”;
} else {
echo \”Error: \” . $sql . \”<br>\” . mysqli_error($link);
}

mysqli_close($link);
?>

Related Posts
50+ PHP Interview Questions and Answers 2023

1. Differentiate between static and dynamic websites. Static Website The content cannot be modified after the script is executed The Read more

All We Need to Know About PHP Ecommerce Development

  Many e-commerce sites let you search for products, show them off, and sell them online. The flood of money Read more

PHP Custom Web Development: How It Can Be Used, What Its Pros and Cons Are,

PHP is a scripting language that runs on the server. It uses server resources to process outputs. It is a Read more

PHP Tutorial

Hypertext Preprocessor (PHP) is a programming language that lets web developers make dynamic content that works with databases. PHP is Read more

Introduction of PHP

PHP started out as a small open source project that grew as more and more people found out how useful Read more

Syntax Overview of PHP

This chapter will show you some of PHP\'s very basic syntax, which is very important for building a strong PHP Read more

Environment Setup in PHP

To develop and run PHP on your computer, you need to instal three important parts. Web server PHP can almost Read more

Variable Types in PHP

Using a variable is the main way to store information in the middle of a PHP program. Here are the Read more

Scroll to Top