Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Week 3 - PHP Mysql Json

    Uploaded by

    gerrygohil
    The document discusses converting data from a MySQL database to JSON format. It provides steps to create a MySQL table, connect to the database from PHP, fetch data from the table, convert the result set to a PHP array, then encode the array as a JSON string. Code examples are given for each step.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Week 3 - PHP Mysql Json

    Uploaded by

    gerrygohil
    5 views14 pages
    The document discusses converting data from a MySQL database to JSON format. It provides steps to create a MySQL table, connect to the database from PHP, fetch data from the table, convert the result set to a PHP array, then encode the array as a JSON string. Code examples are given for each step.

    Original Title

    Week 3 - Php Mysql Json

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses converting data from a MySQL database to JSON format. It provides steps to create a MySQL table, connect to the database from PHP, fetch data from the table, convert the result set to a PHP array, then encode the array as a JSON string. Code examples are given for each step.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    5 views14 pages

    Week 3 - PHP Mysql Json

    Uploaded by

    gerrygohil
    The document discusses converting data from a MySQL database to JSON format. It provides steps to create a MySQL table, connect to the database from PHP, fetch data from the table, convert the result set to a PHP array, then encode the array as a JSON string. Code examples are given for each step.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 14

    MYSQL, PHP, JSON

    LESSON 3
    WHAT IS MYSQL DATABASE?

    • MySQL is an open source SQL database, which is developed by a


    Swedish company – MySQL AB. MySQL is pronounced as "my ess-
    que-ell," in contrast with SQL, pronounced "sequel”.
    • MySQL is supporting many different platforms including Microsoft
    Windows, the major Linux distributions, UNIX, and Mac OS X.
    • Development of MySQL by Michael Widenius & David Axmark
    beginning in 1994.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    1. Open PhpMyAdmin using
    XAMMP
    • Open your XAMPP Controller and click START
    button on Apache and Mysql.

    • Click ADMIN button in MySQL row to open


    MyPhpAdmin

    • Create a database.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    2. Create a table and insert data
    Here is a SQL script. Encode and run these SQL commands to create a table named tbl_employee and insert data into the
    table.
    See SCRIPT at the NOTES section.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    3. Create a PHP File and make
    connection to mysql database
    • Create a Project in Netbeans/PHPStorm

    • Create a PHP file named it


    connection.php

    • Encode the codes at the NEXT SLIDE to


    establish connection to mysql database
    using mysqli_connect() function.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    4. Create a PHP File and make connection to mysql database
    Encode these codes into your connection.php file

    IMPORTANT NOTE: Change the value of localhost, username, password and database
    name according to your settings.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    5. Fetch Data from MySQL Database
    After opening the connection, fetch the required table data from mysql db. Using the php function mysqli_query(),
    I'm going to fetch all the rows from the table 'tbl_employee’. Just copy the following codes highlighted in box.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    6. Convert MySQL Result Set to PHP Array
    Next loop through the mysql result set we got from step-5 and convert it to php array. Just copy the
    following codes highlighted in box.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    7.  Convert PHP Array to JSON String
    Next use the PHP function json_encode() to convert the php array to json string. Learn about using php
    json_decode() function here.
    CONVERTING DATA FROM MYSQL TO JSON
    FORMAT 
    8.  Close the mysqli connection
    You should always close the connection after fetching all the information from the database.
    Complete Code
    Run the code and you get an output something like this:
    CONVERT MYSQL TO JSON FILE IN PHP
    If you want to write the data from mysql to json file, add this piece of code at the end instead of
    'echo' statement.
    ACTIVITY #3 LINK:

    https://forms.gle/g5Qpwcj8ttdZ7MtH6

    DEADLINE: MAY 18, 2021

    You might also like