Udemy - PHP for Beginners 2021 Part 5 - PHP, PDO, MySQL, jQuery AJAX

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size327.5 MB
  • Uploaded Byfreecoursewb
  • Downloads82
  • Last checkedOct. 31st '21
  • Date uploadedOct. 28th '21
  • Seeders 16
  • Leechers1
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 22A3442D94C2A9A31CBCD0178DBC2F703F065331

PHP for Beginners 2021 Part 5: PHP, PDO, MySQL, jQuery AJAX



https://TutGee.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 15 lectures (50m) | Size: 282.1 MB
This is a short course designed to introduce you to how to use the jQuery AJAX method to populate a dropdown list
What you'll learn:
You will be able to use jQuery AJAX calls to the server in order to update a HTML page
Create database tables and populate using CSV files
Use Emmet to quickly write HTML code
Connect to a MySQL database using a PDO connection
Read data from a database table

Requirements
You should be familiar with HTML, CSS, PHP, and MySQL
You will need a PHP code editor and access to a MySQL database. I use Visual Studio Code and MAMP in the course. Any equivalent for your computer setup should be OK. Feel free to ask if unsure.

Description
This is a short course designed to get you started using the jQuery AJAX method to post data to a PHP script and work with the retrieved database records. It is a follow along style course, not one to teach you every aspect of PHP, jQuery or MySQL...there are other courses for that. This course is quite specific in its focus.

In the course you will learn how to create the database tables and populate with CSV files before learning how to use the jQuery AJAX method to post data to a PHP script to retrieve database records and populate a dropdown list. This is commonly seen when completing HTML forms and you have to select the country and the state will auto-populate from the selection.

Files:

[ TutGee.com ] Udemy - PHP for Beginners 2021 Part 5 - PHP, PDO, MySQL, jQuery AJAX
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction
    • 1. Overview of the Development Environment.mp4 (12.3 MB)
    2. The Database
    • 1. How to Create the MySQL Database Connection using PDO.mp4 (19.0 MB)
    • 2. Populating the Database with the CSV Files.mp4 (25.6 MB)
    • 2.1 countries.csv (0.1 KB)
    • 2.2 states.csv (5.2 KB)
    3. The Frontend
    • 1. Creating the index page.mp4 (10.8 MB)
    • 2. Creating the HTML form using Emmet.mp4 (40.9 MB)
    • 3. Hiding the State dropdown.mp4 (5.5 MB)
    • 4. Populating the countries dropdown.mp4 (34.8 MB)
    • 5. Picking up the ID of the selected country.mp4 (26.1 MB)
    • 6. Posting data using the jQuery AJAX method.mp4 (45.8 MB)
    4. The Backend
    • 1. Testing the jQuery AJAX data.mp4 (7.9 MB)
    • 2. Reading the States from the Database.mp4 (19.1 MB)
    • 3. Populating the States dropdown.mp4 (10.5 MB)
    5. The next steps
    • 1. Security considerations.mp4 (21.3 MB)
    • 2. Code used in the course.html (0.1 KB)
    • 3. Bonus Lecture.mp4 (47.7 MB)
    • 3.1 Udemy Course Links - Bonus Lecture (1).pdf (55.6 KB)
      • __MACOSX
      • _countries.csv (0.7 KB)
      • _states.csv (0.7 KB)
      • _style.css (0.2 KB)
    • countries.csv (0.1 KB)
    • dbConfig.php (0.3 KB)
    • getStates.php (0.6 KB)
    • index.php (2.3 KB)
    • states.csv (5.2 KB)
    • style.css (0.0 KB)
      • Bonus Resources.txt (0.3 KB)

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce