dbconn.php Won't let me post bookstore due to emails. Table Name: BOOK Field Name bookID booktitle ISBN price genre edition language quantity publishID Data Type

dbconn.php

$dbConn = new mysqli('localhost', 'root', '', 'bookstore'); if($dbConn->connect_error) { exit("Failed to connect to database " . $dbConn->connect_error); } ?>

Won't let me post bookstore due to emails.

Table Name: BOOK Field Name bookID booktitle ISBN price genre edition language quantity publishID Data Type CHAR(6) CHAR(30) CHAR(30) DECIMAL(8,2) CHAR(15) INT(2) CHAR(15) INT(4) CHAR(7) Description unique identifier for a book title of a book ISBN of a book Selling price of a book Category of a book Current edition of a book Written language of a book Stock level for a book PublisherID for a book a Table Name: AUTHOR Field Name authorID firstname lastname birthdate Iphone email address country Data type CHAR(7) CHAR(15) CHAR(15) DATE CHAR(10) CHAR(20) CHAR(36) CHAR(16) Description Unique identifier for an author First name for an author Last name for an author DOB for an author Contact phone Email address Postal address Country Table Name: WRITES Field Name Data type Description authorld bookID CHAR(7) CHAR(6) Unique identifier for an author unique identifier for a book Table Name: PUBLISHER Field Name lpublishID name Ipostaddress Iphone email region Data type CHAR(7) CHAR(15) CHAR(35) CHAR(10) CHAR(20) CHAR(16) Description Unique identifier for a publisher Name for a publisher Postal address Phone contact Email address Region for a publisher Exercise 2 Create exercise2.php which uses an include statement to establish the connection object via dbConn.php in the week 9 tasks folder. In exercise2.php, write an SQL statement that extracts records from the BOOK table with a price between 20 dollars and 60 dollars. Display the results in an HTML table. Save exercise2.php in C:/TWA/Practicals/PracSet2/week9Tasks folder after validating the script under C:/XAMPP/htdocs folder