Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ARGENT in 30 min Complete the Four missing steps in reserve.php file, which is activated when the form in BooksForm.html page is submitted. BooksForm.html page
ARGENT in 30 min
Complete the Four missing steps in reserve.php" file, which is activated when the form in "BooksForm.html" page is submitted. BooksForm.html" page with a sample input is shown in the figure below: Book Request Form: User Name: Farha Al-Khanjari Password: ... Quantity: 6 Book subject: Literature Literature Buy Islamic Mystery When User click on "Buy" button, "reserve.php" file is called producing the following html page: Signed in successfully 6 books of type Mystery reserved for user Farha Al-Khanjari Total price : 24 Riyals Would you like to reserve another book? YES The entered user's data will also be stored into bookshop database named: "BooksDB": specified as follow: Server. 127.0.0.1 Database: booksdb > Table: books uname bookID subject price Edit hiCopy Delete Khamis 6 Islamic 0 Edit B Copy Delete Khamis 7 Islamic 9 Edit HiCopy Delete Salim 8 Mystery 16 Edit - Copy Delete Farha Al-Khanjari 9 Mystery 24 DODO Server: 127.0.0.1 Database: booksdb Table books Table structure # 1 Name uname bookID 2 Type Extra varchar(20) int(11) AUTO_INCREMENT varchar(20) float 3 subject price 4 Complete "reserve.php" code as described in comments: Complete reserve.php" code as described in comments: Signed in successfully"; echo Stotalprice = // Give 25% discount on total price for those who buy more than 2 Mystery books, update Stotalprice accordingly Stotalprice : echo " Total price :" Stotalprice. "Riyals"; //step2: insert new book request into booksDB (table name books) using PHP-mySQL commands: mysqli_close($conn); //close sql connection ?>
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started