Excel to MySQL Web App PHP | PDO| MySQL |AJAX |Bootstrap
3.3 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
62 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel to MySQL Web App PHP | PDO| MySQL |AJAX |Bootstrap to your Wishlist.

Add to Wishlist

Excel to MySQL Web App PHP | PDO| MySQL |AJAX |Bootstrap

An Essential Approach to Online Database Development
3.3 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
62 students enrolled
Created by Paul Amissah
Last updated 8/2016
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn to convert Excel (over 1500) records to MySQL
  • Create an Online Database
  • Perform CRUD Functionality on Database
  • Learn PHP Data Object Abstraction Layer PDO
  • Learn AJAX and Perform Dynamic Search on your Web Real Time
View Curriculum
Requirements
  • Basic PHP
  • Excel Basic
  • HTML Knowledge is Required
Description

In this course, We shall learn how to convert an Excel Sheet (over 1500 Records) to a Database. We then upload the file to MySQL with PHPMyAdmin and build a cool One Page Database Web Application by making the records accessible online via the Web Interface with PHP and Bootstrap. We gonna be using PHP to process Login, Delete Users, Update Users. We gonna learn the Basics of PDO to the Advance Level and Build a Database Class what we gonna be using with PHP to Perform CRUD Functionality. You'll learn to create Pagination like Google Search Pagination for our Over 1500 Records. We gonna be using AJAX to create dynamic search that returns instant results as we type just like Google Search. We shall be doing everything on one page so as to give you a better understanding of how Web Applications Work and how you can confidently create one using PHP, PDO, AJAX, Bootstrap and MySQL. 

Wish you a Successful Learning. 

Who is the target audience?
  • Student Looking Forward to Creating an Online Database Web Application
  • PHP Learners
  • PDO Learners
  • Beginers Looking Forward to Becoming Freelance Web Developers
  • Anyone Interested in Building a One Page Web Application
Students Who Viewed This Course Also Viewed
Curriculum For This Course
24 Lectures
05:51:02
+
Setting Up and Conversion
5 Lectures 01:08:00


Converting Excel to MySQL
14:55

Bootstrap Overview
14:55

Creating Our Single Page Application Page
20:42
+
PDO Class
8 Lectures 02:03:22

Understanding PDO class and its Methods
16:36

Understanding PDO Statement Class and its Methods
18:29

Understanding PDO Statement Class Cont.. & Exception Class
09:03

Exercise: Creating our Database Class and Testing Connection
19:36

Creating our Database Helper functions and Instantiating our Class
18:08

Securing Our Web App with Login & Sessions
17:21

Completing our Front End Web App
09:27
+
Creating Pagination
4 Lectures 01:05:46
Building Functions with PDO Database Class
19:49

Getting, Offset, Current and Ending Pages
19:38

Building Pagination Controls
19:58

Implementing Pagination Function
06:21
+
Editing and Searching Records
3 Lectures 54:44
Updating & Deleting Records in our Database
19:36

Setting up AJAX Search
19:51

+
Bonus Lecture on How to Upload Projects to Your Live Server
3 Lectures 30:47
Hosting Overview
06:42

Using FileZilla to upload files
09:58

Importing our Database Tables and Exporting to Online Database
14:07
+
Testing Our App On Live Server
1 Lecture 08:23
About the Instructor
Paul Amissah
4.2 Average rating
351 Reviews
15,986 Students
6 Courses
WEB APP DEVELOPER | IT TRAINER

Paul currently lives in Dubai UAE working as an IT Contractor in Web  and Business Development. Having spent over 5 years teaching at college level, He understands the challenges students face and aims to address it with his unique style of "Straight To The Point" teaching methods. He has been teaching ever since he was 17. He is currently working on his MBA in IT Security Management and is Microsoft & Cisco Certified.