Create An Auction Site From Scratch: PHP and MySQLi
4.6 (9 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,449 students enrolled

Create An Auction Site From Scratch: PHP and MySQLi

Use PHP, MySQLi, HTML and CSS To Create Your Very Own Auction Website
4.6 (9 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,449 students enrolled
Created by Eric Tam
Last updated 9/2019
English
English [Auto]
Current price: $132.99 Original price: $189.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to create an authentication system
  • How to display items from a database
  • How to create the code to allow buyers to bid on an item
  • How to create screens to add and delete items from a database
  • How to create screens to add and delete buyers from a database
  • How to create a logout screen
Course content
Expand all 111 lectures 07:29:35
+ Introduction
3 lectures 10:10
What You Will Learn
03:02
Prerequisites
05:20
+ PHP and MySQL Review
15 lectures 02:05:02
Isset() vs !Empty(): What's the Difference?
07:38
Isset() vs !Empty(): An Example
10:39
SQL Review
05:41
Using INSERT with Query()
05:42
Using SELECT with Query()
09:13
Using DELETE with Query()
05:23
Using UPDATE with Query()
06:42
Inserting Using Prepared Statements
11:35
Selecting Using Prepared Statements
13:27
Deleting Using Prepared Statements
08:14
Updating Using Prepared Statements
11:08
Closing Your Statements And Connections
01:06
How To Use Session
13:29
+ Overview Of Auction Site
2 lectures 16:13
Overview Of Database and Tables
06:31
Overview Of PHP Pages
09:42
+ Turn Off Default CSS
1 lecture 01:06
Turning Off Default CSS
01:06
+ Add_buyer.php, Part 1
3 lectures 12:48
Add_buyer.php: Overview
05:07
Add_buyer.php: Adding HTML
05:11
Add_buyer.php: Adding Ids, Classes And CSS
02:30
+ Check_buyer.php
8 lectures 27:52
Check_buyer.php: Overview
03:15
Check_buyer.php: Adding A Connection
03:31
Check_buyer.php: Hashing The Password
03:33
Check_buyer.php: Check For Duplicate Buyers
06:07
Check_buyer.php: Inserting Input Into Buyer Table
06:56
Check_buyer.php: Preventing Direct Access
03:43
Check_buyer.php: Closing The Connection
00:21
Check_buyer.php: Summary
00:26
+ Add_buyer.php, Part 2
1 lecture 05:07
Add_buyer.php: Display Different Text Using The Same Page
05:07
+ Add_item.php: Part 1
4 lectures 17:27
Add_item.php: Overview
05:12
Add_item.php: Adding HTML
08:12
Add_item.php: Adding Ids And Classes
03:12
Add_item.php: Adding CSS
00:51
+ Check_item.php
7 lectures 25:03
Check_item.php: Overview
02:09
Check_item.php: Adding A Connection
02:23
Check_item.php: Checking For Duplicates
07:56
Check_item.php: Insert Item Into Item Table
07:37
Check_item.php: Closing The Connection
00:26
Check_item.php: Preventing Direct Access
04:08
Check_item.php: Summary
00:24
+ Add_item.php: Part 2
1 lecture 05:01
Add_item.php: Display Different Text Using The Same Page
05:01
Requirements
  • Some familiarity with HTML
  • Some familiarity with CSS
  • Some familiarity with PHP
  • Some familiarity with MySQLI
  • How to use XAMPP
  • Knowledge of prepared statements is recommended by not required
Description

Do you want to become an expert backend web developer?

Or maybe you’ve got a solid understanding of HTML and CSS but still aren't sure how all this PHP and MySQLi relates to the real world?

If so, this course is perfect for you! In this course, I will teach you step by step how to create an auction site COMPLETELY from scratch using PHP and MySQLi.


Okay, so what’s the course about?

In this course, we will create an auction website from scratch using HTML, CSS, PHP and MySQLi.

After completing this website, you can be certain:

  • you are proficient with HTML and CSS

  • you are familiar with PHP and MySQLi and how they work together with frontend programming.

  • you know how to use all the above to build a real project

  • and much more!


Line by line explanation:

I'll actually explain to you why I'm writing each line of code.


Support:

By enrolling in this course, you will have my COMPLETE support. I love helping students out and am ready to answer any question you may have: programming issues, errors, general programming advice - it doesn't matter!


Fun!

Finally, you’ll discover that programming  is actually a lot of fun! 


What are you waiting for?

Who this course is for:
  • Web developers curious about how to use PHP and MySQLI to create a real project