Solve in html and PHP. Must Separate code between HTML and PHP...
- Write an SQL statements to perform the following operations
- To display all the books title in an ascending order.
- To display all information about the books under the Text Book category.
- To update records for Bawang Merah Bawang Putih book.
- To remove data about Panchatantra book as it is no longer needed.
- To add a new record with certain information to the books table
QUESTIONS 2
Solve using PHP code with css and HTML
- The collection of books obtained from table books is shown in Figure 1. Write PHP codes (with CSS and HTML) to display the book collection as shown. You DO NOT have to display the details of the book when the Details button is clicked.
(All the data displayed on this page is obtained from table books)
Hints: You may require to use % operation in this PHP source codes
You are given a Table as below: id title picture category author 1 The Bed Book of Short Stories book1.jpg Fiction Joanne Hichens 2 Timeless tales from Panchatantra book2.jpg Fiction Robert Johnson 3 Bedtime Stories book4.jpg Fiction Razali Ayob 4 Gemma book5.jpg Fiction Daniel Errico 5 Anak Gagak Berdikari book6.jpg Fiction Intan Mawardah Ali 6 Sang Kancil dan Anjing Pemburu book7.jpg Text book Nur Mazni Ibrahim 7 Ayam dengan Cincin Ajaib book8.jpg Fiction Azidah Aziz 8 Bawang Merah Bawang Putih book9.jpg Fiction Mohd Izhair Abdullah Kisah Awang Tangan Besar book 10.jpg Fiction Muadz Aliman 10 Apa yang Bergerak book 11.jpg Text book Alia Nina 11 Amazing Kimia book3.jpg Text book Loh Wai Long The source code to generate the books table on MYSQL server is given below: phpMyAdmin SQL Dump version 5.0.3 https://www.phpmyadmin.net/ Host: 127.0.0.1 Generation Time: Jan 08, 2021 at 06:20 AM Server version: 10.4.14-MariaDB PHP Version: 7.4.11 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time zone "+00:00"; /* !40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /* !40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; Database: mashitoh -- Table structure for table books CREATE TABLE `books ( "id" int(11) NOT NULL, 'title' varchar(100) NOT NULL, "picture varchar(100) NOT NULL, category varchar(20) NOT NULL, "author" varchar(100) NOT NULL ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; Dumping data for table books INSERT INTO `books ('id', `title`, `picture", "category , `author`) VALUES (1, 'The Bed Book of short stories', 'book1.jpg', 'Fiction', 'Joanne Hichens') (2, 'Timeless tales from Panchatantra', 'book2.jpg', 'Fiction', 'Robert Johnso n'), (3, 'Bedtime Stories', 'book4.jpg', 'Fiction', 'Razali Ayob'), (4, 'Gemma', 'book5.jpg', 'Fiction', 'Daniel Errico'), (5, 'Anak Gagak Berdikari', 'book6.jpg', 'Fiction', 'Intan Mawardah Ali'), (6, 'Sang Kancil dan Anjing Pemburu', 'book7.jpg', 'Text book', 'Nur Mazni Ibr ahim'), (7, 'Ayam dengan Cincin Ajaib', 'book8.jpg', 'Fiction', 'Azidah Aziz'), (7, 'Ayam dengan cincin Ajaib', 'book8.jpg', 'Fiction', 'Azidah Aziz'), (8, 'Bawang Merah Bawang Putih', 'book9.jpg', 'Fiction', 'Mohd Izhair Abdullah '), (9, 'Kisah Awang Tangan Besar', 'book10.jpg', 'Fiction', 'Muadz Aliman'), (10, 'Apa yang Bergerak', 'book11.jpg', 'Text book', 'Alia Nina'), (11, 'Amazing Kimia ', 'book3.jpg', 'Text book', 'Loh Wai Long'); Indexes for dumped tables Indexes for table books ALTER TABLE `books | ADD PRIMARY KEY ( id ); AUTO_INCREMENT for dumped tables AUTO_INCREMENT for table "books ALTER TABLE "books MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; COMMIT; /* !40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /* !40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; The folder consisting of all the images of the books is given here: https://drive.google.com/drive/folders/1024rgr4LXIm9HYT9DQ9yPbgy2QXIDOyE?usp=sha ring Koleksi Buku Peribadi The Bed Book Short Ftories TMELESS TALES FROM PANCHATANTRA BEST OF Bedtime STORIES LARGE PRINT Edited by Joanne Gichens Penulis: Robert Johnson Fiction Penulis: Joanne Hichens Fiction Penulis: Razali Ayob Fiction Details Details Details geinma Sang Kancil Anjing Pemburu ANAK GAGAK BERDIKARI Theodeco BONUS Daniel Errico Penulis: Intan Mawardah Ali Fiction Penulis: Daniel Errico Fiction Details Penulis: Nur Mazni Ibrahim Text book Details Details SIRI HIKAYAT TELADAN OLEH CERTA MELAYU BLANK am Winn
