Course (6-1) PHP & MySQL Programming
- 1. Introduction to PHP and MySQL
- 1.1. What Is a Web Database Application?
- 1.1.1. The database
- 1.1.2. The application: Moving data into and out of the database
- 1.2. MySQL, My Database
- 1.2.1. Advantages of MySQL
- 1.2.2. How MySQL works
- 1.2.3. Communicating with the MySQL server
- 1.3. PHP, a Data Mover
- 1.3.1. Advantages of PHP
- 1.3.2. How PHP works
- 1.4. MySQL and PHP, the Perfect Pair
- 1.4.1. Advantages of the relationship
- 1.4.2. How MySQL and PHP work together
- 1.5. Keeping Up with PHP and MySQL Changes
- 1.1. What Is a Web Database Application?
- 2. Setting Up Your Work Environment
- 2.1. The Required Tools
- 2.2. Finding a Place to Work
- 2.2.1. A company Web site
- 2.2.2. A Web hosting company
- 2.2.3. Setting up and running a Web site on your local computer
- 2.3. Testing, Testing, 1, 2, 3
- 2.3.1. Understanding PHP/MySQL functions
- 2.3.2. Testing PHP
- 2.3.3. Testing MySQL
- 3. Developing a Web Database Application
- 3.1. Planning Your Web Database Application
- 3.1.1. Identifying what you want from the application
- 3.1.2. Taking the user into consideration
- 3.1.3. Making the site easy to use
- 3.1.4. Leaving room for expansion
- 3.1.5. Writing it down
- 3.2. Presenting the Two Running Examples in This Book
- 3.2.1. Stuff for Sale
- 3.2.2. Members Only
- 3.3. Designing the Database
- 3.3.1. Choosing the data
- 3.3.2. Organizing the data
- 3.4. Designing the Sample Databases
- 3.4.1. Pet Catalog design process
- 3.4.2. Members Only design process
- 3.5. Types of Data
- 3.5.1. Character data
- 3.5.2. Numerical data
- 3.5.3. Date and time data
- 3.5.4. Enumeration data
- 3.5.5. MySQL data type names
- 3.5.6. Writing it down
- 3.6. Taking a Look at the Sample Database Designs
- 3.6.1. Stuff for Sale database tables
- 3.6.2. Members Only database tables
- 3.7. Developing the Application
- 3.7.1. Building the database
- 3.7.2. Writing the programs
- 3.1. Planning Your Web Database Application
- 4. Building the Database
- 4.1. Communicating with MySQL
- 4.1.1. Building SQL queries
- 4.1.2. Sending SQL queries
- 4.2. Building a Database
- 4.2.1. Creating a new database
- 4.2.2. Deleting a database
- 4.2.3. Adding tables to a database
- 4.2.4. Changing the database structure
- 4.3. Moving Data Into and Out of the Database
- 4.3.1. Adding information
- 4.3.2. Retrieving information
- 4.3.3. Combining information from tables
- 4.3.4. Updating information
- 4.3.5. Removing information
- 4.1. Communicating with MySQL
- 5. Protecting Your Data
- 5.1. Controlling Access to Your Data
- 5.1.1. Understanding account names and hostnames
- 5.1.2. Finding out about passwords
- 5.2. Taking a look at account permissions
- 5.2.1. Setting Up MySQL Accounts
- 5.2.2. Identifying what accounts currently exist
- 5.2.3. Adding accounts
- 5.2.4. Adding and changing passwords
- 5.2.5. Changing permissions
- 5.2.6. Removing accounts and permissions
- 5.3. Backing Up Your Data
- 5.4. Restoring Your Data
- 5.5. Upgrading MySQL
- 5.1. Controlling Access to Your Data
- 6. General PHP
- 6.1. Adding a PHP Section to an HTML Page
- 6.2. Writing PHP Statements
- 6.3. Using PHP Variables
- 6.3.1. Naming a variable
- 6.3.2. Creating and assigning values to variables
- 6.3.3. Dealing with notices
- 6.4. Using PHP Constants
- 6.5. Working with Numbers
- 6.6. Working with Character Strings
- 6.6.1. Single-quoted strings versus double-quoted strings
- 6.6.2. Joining strings
- 6.7. Working with Dates and Times
- 6.7.1. Setting local time
- 6.7.2. Formatting a date
- 6.7.3. Storing a timestamp in a variable
- 6.7.4. Using dates with MySQL
- 6.8. Comparing Values
- 6.8.1. Making simple comparisons
- 6.8.2. Matching character strings to patterns
- 6.9. Joining Comparisons with and/or/xor
- 6.10. Adding Comments to Your Program
- 7. PHP Building Blocks for Programs
- 7.1. Useful Simple Statements
- 7.1.1. Using echo statements
- 7.1.2. Using assignment statements
- 7.1.3. Using increment statements
- 7.1.4. Using exit
- 7.1.5. Using function calls
- 7.2. Using PHP Arrays
- 7.2.1. Creating arrays
- 7.2.2. Viewing arrays
- 7.2.3. Removing values from arrays
- 7.2.4. Sorting arrays
- 7.2.5. Getting values from arrays
- 7.2.6. Walking through an array
- 7.2.7. Multidimensional arrays
- 7.3. Useful Conditional Statements
- 7.3.1. Using if statements
- 7.3.2. Using switch statements
- 7.4. Using Loops
- 7.4.1. Using for loops
- 7.4.2. Using while loops
- 7.4.3. Using do..while loops
- 7.4.4. Infinite loops
- 7.4.5. Breaking out of a loop
- 7.5. Using Functions
- 7.5.1. Using variables in functions
- 7.5.2. Passing values between a function and the main program
- 7.5.3. Using built-in functions
- 7.1. Useful Simple Statements
- 8. Data In, Data Out
- 8.1. PHP and MySQL Functions
- 8.2. Making a Connection
- 8.2.1. Connecting to the MySQL server
- 8.2.2. Selecting the right database
- 8.2.3. Sending SQL queries
- 8.3. Getting Information from a Database
- 8.3.1. Sending a SELECT query
- 8.3.2. Getting and using the data
- 8.3.3. Using functions to get data
- 8.4. Getting Information from the User
- 8.4.1. Using HTML forms
- 8.4.2. Making forms dynamic
- 8.4.3. Using the information from the form
- 8.4.4. Checking the information
- 8.4.5. Giving users a choice with multiple submit buttons
- 8.6. Putting Information into a Database
- 8.6.1. Preparing the data
- 8.6.2. Adding new information
- 8.6.3. Updating existing information
- 8.7. Getting Information in Files
- 8.7.1. Using a form to upload the file
- 8.7.2. Processing the uploaded file
- 8.7.3. Putting it all together
- 9. Moving Information from One Web Page to the Next
- 9.1. Moving Your User from One Page to Another
- 9.2. Moving Information from Page to Page
- 9.2.1. Adding information to the URL
- 9.2.2. Storing information via cookies
- 9.2.3. Passing information with HTML forms
- 9.3. Using PHP Sessions
- 9.3.1. Opening sessions
- 9.3.2. Using PHP session variables
- 9.3.3. Sessions without cookies
- 9.3.4. Making sessions private
- 9.3.5. Closing PHP sessions
- 10. Putting It All Together
- 10.1. Organizing the Application
- 10.1.1. Organizing at the application level
- 10.1.2. Organizing at the program level
- 10.2. Keeping It Private
- 10.2.1. Ensure the security of the computer
- 10.2.2. Don’t let the Web server display filenames
- 10.2.3. Hide things
- 10.2.4. Don’t trust information from users
- 10.2.5. Use a secure Web server
- 10.3. Completing Your Documentation
- 10.1. Organizing the Application
- 11. Building an Online Catalog
- 11.1. Designing the Application
- 11.1.1. Showing pets to the customers
- 11.1.2. Adding pets to the catalog
- 11.2. Building the Database
- 11.2.1. Building the Pet table
- 11.2.2. Building the PetType table
- 11.2.3. Building the Color table
- 11.2.4. Adding data to the database
- 11.3. Designing the Look and Feel
- 11.3.1. Showing pets to the customers
- 11.3.2. Adding pets to the catalog
- 11.4. Writing the Programs
- 11.4.1. Showing pets to the customers
- 11.4.2. Adding pets to the catalog
- 11.1. Designing the Application
- 12. Building a Members Only Web Site
- 12.1. Designing the Application
- 12.2. Building the Database
- 12.2.1. Building the Member table
- 12.2.2. Building the Login table
- 12.2.3. Adding data to the database
- 12.3. Designing the Look and Feel
- 12.3.1. Storefront page
- 12.3.2. Login page
- 12.3.3. New Member Welcome page
- 12.3.4. Members Only section
- 12.4. Writing the Programs
- 12.4.1. Writing PetShopFront
- 12.4.2. Writing Login
- 12.4.3. Writing New_member
- 12.4.4. Writing the Members Only section
- 12.5. Planning for Growth
- 13. Ten Things You Might Want to Do Using PHP Functions
- 13.1. Communicate with MySQL
- 13.2. Send E-Mail
- 13.3. Use PHP Sessions
- 13.4. Stop Your Program
- 13.5. Handle Arrays
- 13.6. Check for Variables
- 13.7. Format Values
- 13.8. Compare Strings to Patterns
- 13.9. Find Out about Strings
- 13.10. Change the Case of Strings
- 14. Ten PHP Gotchas
- 14.1. Missing Semicolons
- 14.2. Not Enough Equal Signs
- 14.3. Misspelled Variable Names
- 14.4. Missing Dollar Signs
- 14.5. Troubling Quotes
- 14.6. Invisible Output
- 14.7. Numbered Arrays
- 14.8. Including PHP Statements
- 14.9. Missing Mates
- 14.10. Confusing Parentheses and Brackets
- 15. Installing MySQL
- 15.1. On Windows
- 15.1.1. Downloading and installing MySQL
- 15.1.2. Running the MySQL configuration wizard
- 15.1.3. Starting and stopping the MySQL server
- 15.2. On Linux and Unix
- 15.2.1. Using RPM (Linux only)
- 15.2.2. From source files
- 15.3. On Mac
- 15.4. Verifying a Downloaded File
- 15.5. Configuring MySQL
- 15.1. On Windows
- 16. Installing PHP
- 16.1. Installing PHP on Unix, Linux, or Mac with Apache
- 16.1.1. On Unix and Linux
- 16.1.2. On Mac OS X
- 16.1.3. Installation options
- 16.1.4. Configuring Apache for PHP
- 16.2. Installing PHP on Windows
- 16.2.1. Configuring your Web server for PHP
- 16.3. Configuring PHP
- 16.1. Installing PHP on Unix, Linux, or Mac with Apache
- 17. Installing and Configuring Apache
- 17.1. Selecting a Version of Apache
- 17.2. Installing Apache on Linux and Unix
- 17.2.1. Before installing
- 17.2.2. Installing
- 17.2.3. Starting and stopping Apache
- 17.2.4. Getting information from Apache
- 17.3. Installing Apache on Windows
- 17.3.1. Installing
- 17.3.2. Starting and stopping Apache
- 17.3.3. Getting information from Apache
- 17.4. Installing Apache on Mac
- 17.5. Configuring Apache
- 17.5.1. Changing settings
- 17.5.2. Changing the location of your Web space
- 17.5.3. Changing the port number
Online LIVE Training Programming Course offered by INCAPROG ONLINE - www.incaprog.com - contacto@incaprog.com - Phone : (954) 727-3141