PHP MySQL tutorial - Insert, update, delete records

Home - Tutorials - Databases

In this PHP MySQL tutorial I will show you how to use basic database manipulation features in PHP.

Tutorial info:

---

Name:	PHP MySQL tutorial
Total steps:	5
Category:	Databases
Level:	Beginner

Bookmark PHP MySQL tutorial

---

Step 4 - Insert, update, delete records

PHP MySQL tutorial

Inserting data into the database 

In this topic we will create a code to insert new records into our MySQL database. This is very similar to the select version. Also in this case we need to build up a database connection and we will use the mysql_query() function again. However in this case we will use it with an insert sql statement. Now let's try to insert a new user to our table. The sql statement is the following:
 
INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',44);
 
Now store this SQL statements in a variable and pass this as parameter of mysql_query like this:
 

Code: 
$sql = "INSERT INTO users (name,city,web,age) VALUES ('Tom','Vegas','www.tom.com',5)";
$result = mysql_query($sql);
 
PHP F1

Code: 
$sql = "UPDATE users SET age=45 WHERE name='Tom'";
$result = mysql_query($sql);
 
PHP F1

Code: 
$sql = "DELETE FROM users WHERE name='Tom'";
$result = mysql_query($sql);
PHP F1

Tags: php mysql tutorial, php mysql, php database, php, mysql, tutorial