What You Will Learn
•Prerequisites
•PHP and MySQL Review
•Creating A Database and Table Using PHPMyAdmin
•How To Connect With A Database
•Isset() vs !Empty(): What’s the Difference?
•Isset() vs !Empty(): An Example
•SQL Review
•Using INSERT with Query()
•Using SELECT with Query()
•Using DELETE with Query()
•Using UPDATE with Query()
•Inserting Using Prepared Statements
•Selecting Using Prepared Statements
•Deleting Using Prepared Statements
•Updating Using Prepared Statements
•Closing Your Statements And Connections
•How To Use Session
•Overview Of Auction Site
•Overview Of Database and Tables
•Overview Of PHP Pages
•Turn Off Default CSS
•Turning Off Default CSS
•Add_buyer.php, Part 1
•Add_buyer.php: Overview
•Add_buyer.php: Adding HTML
•Add_buyer.php: Adding Ids, Classes And CSS
•Check_buyer.php
•Check_buyer.php: Overview
•Check_buyer.php: Adding A Connection
•Check_buyer.php: Hashing The Password
•Check_buyer.php: Check For Duplicate Buyers
•Check_buyer.php: Inserting Input Into Buyer Table
•Check_buyer.php: Preventing Direct Access
•Check_buyer.php: Closing The Connection
•Check_buyer.php: Summary
•Add_buyer.php, Part 2
•Add_buyer.php: Display Different Text Using The Same Page
•Add_item.php: Part 1
•Add_item.php: Overview
•Add_item.php: Adding HTML
•Add_item.php: Adding Ids And Classes
•Add_item.php: Adding CSS
•Check_item.php
•Check_item.php: Overview
•Check_item.php: Adding A Connection
•Check_item.php: Checking For Duplicates
•Check_item.php: Insert Item Into Item Table
•Check_item.php: Closing The Connection
•Check_item.php: Preventing Direct Access
•Check_item.php: Summary
•Add_item.php: Part 2
•Add_item.php: Display Different Text Using The Same Page
•Delete_buyer.php: Part 1
•Delete_buyer.php: Overview
•Delete_buyer.php: Adding HTML
•Delete_buyer.php: Adding Ids And Class
•Delete_buyer.php: Adding CSS
•Check_delete_buyer.php
•Check_delete_buyer.php: Overview
•Check_delete_buyer.php: Adding A Connection
•Check_delete_buyer.php: If No Such Buyer Exists
•Check_delete_buyer.php: If Password Is Wrong
•Check_delete_buyer.php: Preventing Direct Access
•Check_delete_buyer.php: Closing A Connection
•Check_delete_buyer.php: Summary
•Delete_buyer.php: Part 2
•Delete_buyer.php: Display Different Text Using The Same Page
•Delete_item.php: Part 1
•Delete_item.php: Overview
•Delete_item.php: Adding HTML
•Delete_item.php: Adding Ids And Classes
•Delete_item.php: Adding CSS
•Check_delete_item.php
•Check_delete_item.php: Overview
•Check_delete_item.php: Adding A Connection
•Check_delete_item.php: Checking For Item In Database
•Check_delete_item.php: Deleting A Found Item
•Checking_delete_item.php: Preventing Direct Access
•Check_delete_item.php: Closing A Connection
•Check_delete_item.php: Summary
•Delete_item.php: Part 2
•Delete_item.php: Display Different Text Using The Same Page
•Login.php
•Login.php: Overview
•Login.php: Adding HTML
•Login.php: Adding Ids And Classes
•Login.php: Adding CSS
•Check_login.php
•Check_login.php: Overview
•Check_login.php: Adding A Connection
•Check_login.php: Check If Username Exists
•Check_login.php: Check If Password Is Correct
•Check_login.php: Prevent Direct Access By Users
•Check_login.php: Closing The Connection
•Check_login.php: Summary
•Relogin.php
•Relogin.php: Adding HTML
•Relogin.php: Adding CSS
•Logout.php
•Display_items.php
•Display_items.php: Overview
•Display_items.php: Adding A Connection
•Display_items.php: Main PHP Code
•Display_items.php: Adding CSS
•Display_items.php: Preventing Direct Access
•Display_items.php: Closing The Connection
•Display_items.php: Summary
•Item_Details.php
•Item_details.php: Overview
•Item_details.php: Adding A Connection
•Item_details.php: Select from Item table
•Item_details.php: Adding The Main Code Of Item Details
•Item_details.php: Adding Select Tag And Form
•Item_details.php: Adding CSS
•Item_details.php: Closing The Connection
•Item_details.php: Summary
•Bid.php
•Bid.php: Overview
•Bid.php: Adding A Connection
•Bid.php: Check For Highest Bidder
•Bid.php: Get Item With Current Item_Id
•Bid.php: Update Current Bid Value
•Bid.php: Update Number Of Bids
•Bid.php: Adding New Bid To Table
•Bid.php: Delete Old Bid From Table
•Bid.php: Prevent Direct Access By User
•Bid.php: Adding CSS
•Bid.php: Closing The Connection
•Bid.php: Summary
•Conclusion
•