PHP MySQL Insert Data

PHP-MySQLi Tutorial � PHP MySQL Insert Data

How to insert records in a MySQL table using PHP?

Insert Data Into MySQL Using MySQLi and PDO

After we have create a table named "Students", with six columns as: "id", "first_name", "last-name", "email", "password" and "date", we can start adding data in them.

The�INSERT INTO�statement is used to insert new rows into database table,( to add new records to a MySQL table)

Syntax:

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

In the previous chapter we have creat an empty table "Students", with six columns as: "id", "first_name", "last-name", "email", "password" and "date". Now, we fill the table with datas.

PHP MySQL Insert Data ( MySQLi Object-oriented ) - example

Open a Connection to MySQL

Before we can access data in MySQL database, we need to be able to connect to the server:

The following examples add a new record to "Students" table:

Example: (MySQLi Object-Oriented)

<?php

  $server_name = "localhost";

  $user_name = "username";

  $password = "password";

$db_name = "myDB";
// Create connection

  $con = new mysqli($server_name, $user_name, $password, $db_name);

  // Check connection

  if ($con->connect_error) {

  die("Connection failed: " . $con->connect_error);

  }
$sql = "INSERT INTO Students (first_name, last_name, email, password)

  VALUES ('Nicky', 'Camora', 'nica@example.com', '123456')";
if ($con->query($sql) === TRUE) {

  echo "Records inserted successfully.";

  } else {

  echo "Error: " . $sql . "<br>" . $con->error;

  }
$con->close();

  ?>

Note:
If you remember from the preceding chapter, id field was marked with AUTO_INCREMENT flag. This modifier tells the MySQL to automatically assign a value to this field if it is left unspecified, by incrementing the previous value by 1.

PHP MySQL Insert Data (MySQLi Procedural)

Example (MySQLi Procedural)

Example: (MySQLi Procedural)

<?php

  $server_name = "localhost";

  $user_name = "username";

  $password = "password";

$db_name = "myDB";
// Create connection

  $con = new mysqli($server_name, $user_name, $password, $db_name);

  // Check connection

  if (!$con) {

  die("Connection failed: " . mysqli_connect_error());

  }
$sql = "INSERT INTO Students (first_name, last_name, email, password)

  VALUES ('Nicky', 'Camora', 'nica@example.com', '123456')";
if (mysqli_query($con, $sql)) {

  echo "Records inserted successfully.";

  } else {

  echo "Error: " . $sql . "<br>" . mysqli_error($con);

  }
mysqli_close($con);

  ?>

How to insert data from a form into database using PHP, How to insert data into database using php, PHP script to insert data into MySQL database from form, How to add data to database with php, Php mysql insert from form, Php add entry to mysql, Php execute sql insert
php insert data into mysql from form, pdo, table, code, from array, using, ajax, database
Insert Data Into MySQL using php, using python, table using php form, workbench, table from csv file, using java, database using djamgo, using php form, using node js, php code to insert data, php cannot, script to, php code to insert data into mysql database from html form

PHP MySQL Insert Data (PDO) - example

Example (PDO)

Example: (PDO)

<?php

  $server_name = "localhost";

  $user_name = "username";

  $password = "password";

$db_name = "myDB_PDO";
try {

  $con = new PDO("mysql:host=$server_name;dbname=$dbn_ame", $user_name, $password);

  // set the PDO error mode to exception

  $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  $sql = "INSERT INTO Students (first_name, last_name, email, password)

  VALUES ('Nicky', 'Camora', 'nica@example.com', '123456')";

  // use exec() because no results are returned

  $con->exec($sql);

  echo "Records inserted successfully.";

  } catch(PDOException $e) {

  echo $sql . "<br>" . $e->getMessage();

  }
$conn = null;

  ?>

Note: In the PDO example above we have also specified a database (myDB_PDO).

Insert Data into a Database from an HTML Form

Let's create an HTML form that can be used to insert new records to�persons�table.

Here's a simple HTML form that has three text <input> fields and a submit button.

Example:

 
<!DOCTYPE html>

  <html lang="en">

  <head>

  <meta charset="UTF-8">

  <title>Add Record Form</title>

  </head>

  <body>

  <form action="insert.php" method="post">

<p>

<label for="firstName">First Name:</label>

<input type="text" name="first_name" id="firstName">

</p>

<p>

<label for="lastName">Last Name:</label>

<input type="text" name="last_name" id="lastName">

</p>

<p>

<label for="emailAddress">Email Address:</label>

<input type="text" name="email" id="emailAddress">

</p>

<p>

<label for="password">Password:</label>

<input type="text" name="password" id="password">

</p>

<input type="submit" value="Submit">

</form>

</body>

</html>

Output:

Insert Data Into MySQL using php, using python, table using php form, workbench, table from csv file, using java, database using djamgo, using php form, using node js, php code to insert data, php cannot, script to, php code to insert data into mysql database from html form
PHP MySQL Insert Data - php mysqli

Online Editor

ONLINE EDITOR

news templates

COLOR PICKER

news templates

This tool makes it easy to create, adjust, and experiment with custom colors for the web.

HTML Templates

Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.

CSS HTML Layout

Find here examples of creative and unique website layouts.

Free CSS HTML Menu

Find here examples of creative and unique website CSS HTML menu.