GetStartPhp

Prev charpter-> 1.Php back to index

---

2 Get Start MySql

2.1 install MySql

• Option 1: (Recommend for beginner) Download and install XAMPP the popular PHP-MySql development environment
  • download from: https://www.apachefriends.org/
  • for more check How to Use XAMPP
• Option 2: Download Mysql community version
  • https://dev.mysql.com/downloads/installer/
• Option 3: MariaDB is MySql open source fork
  • https://www.mariadbtutorial.com/getting-started/install-mariadb/

2.2 install MySql Admin UI

• 1. If you installed with XAMPP, it come with a MySql admin UI phpMyAdmin
     • for how to start mysql and mysql admin please check: How to Use XAMPP
• 1. or you could install another my sql UI you like ex.
     • MySql workbench https://www.mysql.com/products/workbench/
     • phpMyAdmin is a web UI https://www.phpmyadmin.net/downloads/

2.3 Connect MySql DB from PHP

• 1. you need a MySql driver for PHP to use MySql DB
     • XAMPP already include the MySQLi, you could just use it
     • For non XAMPP user you need manually install php mysql connection
       • Check https://www.w3schools.com/php/php_mysql_connect.asp
       • MySqli http://php.net/manual/en/mysqli.installation.php
       • PDO https://www.php.net/manual/en/pdo.installation.php
• 1. MySql default root username is root
     • to change pwd of mySql use XAMPP please check https://kinsta.com/knowledgebase/xampp-mysql-password/
• 1. Try below code to check sql connection

<?php
$server_name = "localhost"; //where is your mysql server server
$username = "root";   // the MySql username
$password = "";      // the Mysql password

// Create a mysqli connection
$conn = new mysqli($server_name, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}else{
    echo "Connected successfully";
}
?>

• 1. Enable mysqli extension
     • if you got error like ‘Fatal error: Uncaught Error: Class “mysqli” not found in’, please go to C:\php, update php.ini or rename php.ini-development to php.ini, remove ‘;’ in front of extension=mysqli to enable it like below

php.ini

extension=mysqli
;extension=oci8_12c  ; Use with Oracle Database 12c Instant Client
;extension=oci8_19  ; Use with Oracle Database 19 Instant Client
;extension=odbc
;extension=openssl
;extension=pdo_firebird

2.4 php mysql examples

1. Check mySql connection code sample: mySqlConnect
2. Create a separate db connection files dbConfig.php file for test.php page to use.
3. Use Php to create a new table to Test database createNewTable_test.php
4. A From to insert new rows to database table insertRow_test.php
5. Test page to load table row from database getData_test.php
6. Html and Table example GetStudents

2.5 MySql Query example

1. Create a Table

---

Prev chapter-> 1.Php back to index