Database tables hold data associated with your website. MySQL has basic commands for working with database tables including SHOW TABLES, CREATE TABLE, SHOW COLUMNS FROM and DROP TABLE. This video presents best practices for creating a database table such as always providing an id column, dealing with nulls, setting auto increment columns and creating keys.
- View Offline
- Exercise Files
Now that we've created our first database we're ready to add our first table to …that database. And to do that we're going to need to …learn just a little bit more MySQL. The first is Show Tables. …That's just going to show us all of the tables on the current database that we're using. …Remember that we had show databases to show us the list of all the databases? …Well it makes sense that show tables will show us all the tables. …Well, we're not going to have any tables there to start with. …We're going to need to create one and we're going to do that with the create …table command. So create table, followed by the name of …our table, followed by paranthesis, we're going to put the table definitions.…
So that's going to be a list of all the columns that we have followed by …definition for that column, then at the end we can put some options. …Now the definitions can be complex, so we're not going to try to cover …everything about them exhaustively, but I'm going to walk you through the basics …
- What is PHP?
- Installing and configuring PHP and MySQL
- Exploring data types
- Controlling code with logical expressions and loops
- Using PHP's built-in functions
- Writing custom functions
- Building dynamic webpages
- Working with forms and form data
- Using cookies and sessions to store data
- Connecting to MySQL with PHP
- Creating and editing database records
- Building a content management system
- Adding user authentication
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- 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.Cancel
Take 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.