PHP Tutorial

A web server programming language.

Chapter Quiz Exercises
Course Topics
PHP Intro PHP Syntax PHP Variables PHP Echo / Print PHP Data Types PHP Strings PHP Numbers PHP Math PHP Constants PHP Operators PHP If...Else...Elseif PHP Switch PHP Loops PHP Functions PHP Arrays PHP Superglobals PHP Form Handling PHP Date and Time PHP File Handling PHP Cookies PHP Sessions PHP Exceptions PHP OOP Classes & Objects PHP Constructor MySQL Connect MySQL Insert Data MySQL Select Data PHP JSON PHP Regular Expressions PHP Include & Require

MySQL Insert Data

MySQL Insert Data Using PHP

After a database and a table have been created, we can start adding data in them.

Here are some syntax rules to follow:

  • The SQL query must be quoted in PHP
  • String values inside the SQL query must be quoted
  • Numeric values must not be quoted
  • The word NULL must not be quoted

Try It Yourself

Edit the code below and click Run to see the result live.

Source Code
Result
Topics
PHP Intro PHP Syntax PHP Variables PHP Echo / Print PHP Data Types PHP Strings PHP Numbers PHP Math PHP Constants PHP Operators PHP If...Else...Elseif PHP Switch PHP Loops PHP Functions PHP Arrays PHP Superglobals PHP Form Handling PHP Date and Time PHP File Handling PHP Cookies PHP Sessions PHP Exceptions PHP OOP Classes & Objects PHP Constructor MySQL Connect MySQL Insert Data MySQL Select Data PHP JSON PHP Regular Expressions PHP Include & Require