- PHP Basics
- Learn PHP
- PHP Comments
- PHP Data Types
- PHP Variables
- PHP Operators
- PHP echo
- PHP print
- PHP echo vs. print
- PHP if else
- PHP switch
- PHP for Loop
- PHP while Loop
- PHP do...while Loop
- PHP foreach Loop
- PHP break and continue
- PHP Arrays
- PHP print_r()
- PHP unset()
- PHP Strings
- PHP Functions
- PHP File Handling
- PHP File Handling
- PHP Open File
- PHP Create a File
- PHP Write to File
- PHP Read File
- PHP feof()
- PHP fgetc()
- PHP fgets()
- PHP Close File
- PHP Delete File
- PHP Append to File
- PHP Copy File
- PHP file_get_contents()
- PHP file_put_contents()
- PHP file_exists()
- PHP filesize()
- PHP Rename File
- PHP fseek()
- PHP ftell()
- PHP rewind()
- PHP disk_free_space()
- PHP disk_total_space()
- PHP Create Directory
- PHP Remove Directory
- PHP Get Files/Directories
- PHP Get filename
- PHP Get Path
- PHP filemtime()
- PHP file()
- PHP include()
- PHP require()
- PHP include() vs. require()
- PHP and MySQLi
- PHP and MySQLi
- PHP MySQLi Setup
- PHP MySQLi Create DB
- PHP MySQLi Create Table
- PHP MySQLi Connect to DB
- PHP MySQLi Insert Record
- PHP MySQLi Update Record
- PHP MySQLi Fetch Record
- PHP MySQLi Delete Record
- PHP MySQLi SignUp Page
- PHP MySQLi LogIn Page
- PHP MySQLi Store User Data
- PHP MySQLi Close Connection
- PHP Misc Topics
- PHP Object Oriented
- PHP new Keyword
- PHP Cookies
- PHP Sessions
- PHP Date and Time
- PHP GET vs. POST
- PHP File Upload
- PHP Image Processing
PHP MySQLi Setup
Before start storing, fetching, updating, or deleting the data/information of your user in/from the database, you need to setup the environment first.
To run a PHP script, you need a web server. And to work with database, you need a database server.
In this series of PHP MySQLi tutorial, I am going to use XAMPP, that comes with both, a web server (Apache), as well as a database server (MySQL).
Reason behind, why I am going to use XAMPP, is:
Both Windows as well as Linux
system supports XAMPP. Also, it is too easy to setup and use.
PHP MySQLi XAMPP Setup
Download and install the XAMPP from Internet. Then open it (XAMPP Control Panel), the window you will see:
Click on the Start button, next to Apache, to start the Apache web server. Now we can execute PHP script.
Click on the Start button, next to MySQL, to start the MySQL database server. Now we can work with database using PHP script.
Here is the snapshot, after starting both:
Everything got set. From next, you will get to learn, how to create a database.
« Previous Tutorial Next Tutorial »