Join Ray Villalobos for an in-depth discussion in this video Preparing your database, part of Validating and Processing Forms with JavaScript and PHP.
Sometimes, you don't want to send the information to an email address. …It can be unreliable and it's not easy to aggregate the data. …In that case, it's better to push the information to a database. …Most servers come with some implementation of the popular My SQL database. …And it's pretty easy to use since the commands are fairly readable. …This isn't designed to be a full database course. …We'll just be talking about form implementation. …So for more information, make sure you check out PHP with my SQL Essential …Training, and for more SQL information, check out My SQL Essential Training.…
So, we've got a do a little bit of set-up. …You're going to need to get credentials that give you access to the database. …That usually involves creating the database, which you can do either through …SSH or your host control panel. There's a lot of different control …panels, and how you get to this varies from server to server. …So I'm going to assume you already created a database. …If you want to learn how to do that in some popular control panels, like C …
Author
Released
4/23/2013- Understanding forms
- Adding required fields and placeholders
- Accepting multiple entries
- Limiting uploads
- Handling focus changes
- Validating with regular expressions
- Working with older browsers
- Building jQuery validation
- Using server-side validation
- Sanitizing form input
- Uploading files
- Sending form data to a database
Skill Level Intermediate
Duration
Views
Related Courses
-
CSS: Styling Forms
with Ray Villalobos4h 1m Beginner -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Appropriate for all
-
Introduction
-
Welcome1m 5s
-
What you should know1m 2s
-
Using the exercise files1m 25s
-
-
1. Getting Started
-
Understanding forms2m 2s
-
Working with form fields7m 4s
-
Using the form tag3m 44s
-
-
2. Validating with HTML5
-
Using input validation2m 10s
-
Accepting multiple entries1m 41s
-
-
3. Validating Forms with JavaScript
-
Accessing forms3m 57s
-
Looking up form elements3m 35s
-
Handling focus changes2m 47s
-
Detecting the onchange event4m 31s
-
-
4. jQuery Form Validation
-
Understanding jQuery3m 47s
-
-
5. Working with PHP
-
Using server-side validation4m 59s
-
Adding in-page validation5m 22s
-
Sanitizing form input4m 5s
-
6. Processing Form Data
-
Mailing form data8m 28s
-
Uploading files9m 20s
-
Preparing your database5m 50s
-
Pushing data8m 36s
-
-
Conclusion
-
Next steps1m 17s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Preparing your database