Hi i need stepwise explanation of following code used here   $id,                 "Product_name" => $Product_name,                 "Price" => $Price,                 "Wireless_carrier" => $Wireless_carrier,                 "Brand" => $Brand,                 "Colour" => $Colour,                 "Memory_storage_capacity" => $Memory_storage_capacity,                 "Screen_size" => $Screen_size,             );         }         $electronics_1 = json_encode($return_arr);         header('Content-Type: application/json; charset=utf-8');         echo json_encode($electronics_1);         ?>

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Hi i need stepwise explanation of following code used here

 

<?php
require_once "../database/dbConnect.php";
$search = $_GET['search_keyword'];
$return_arr = array();
        $query = "SELECT * FROM electronics_1 where (id like '%$search%') OR (Product_name like '%$search%') OR ( price like '%$search%')";
        $result = mysqli_query($conn, $query);
        while ($row = mysqli_fetch_array($result)) {
            $id = $row['id'];
            $Product_name = $row['Product_name'];
            $Price = $row['Price'];
            $Wireless_carrier = $row['Wireless_carrier'];
            $Brand = $row['Brand'];
            $Colour = $row['Colour'];
            $Memory_storage_capacity = $row['Memory_storage_capacity'];
            $Screen_size = $row['Screen_size'];
            $return_arr[] = array(
                "id" => $id,
                "Product_name" => $Product_name,
                "Price" => $Price,
                "Wireless_carrier" => $Wireless_carrier,
                "Brand" => $Brand,
                "Colour" => $Colour,
                "Memory_storage_capacity" => $Memory_storage_capacity,
                "Screen_size" => $Screen_size,
            );
        }
        $electronics_1 = json_encode($return_arr);
        header('Content-Type: application/json; charset=utf-8');
        echo json_encode($electronics_1);




        ?>
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Data Binding
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education