Course (6-1) PHP & MySQL Programming

zoom

pre 1 of 1 next

Location: New York - Map

Date posted: June 21, 2013

Price: Please contact

Ad ID: 91869

Views: 17

Reply by email

close X
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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

  • Share this ad: pictute pictute pictute pictute
  • Print: pictute
  • Add to favorites: pictute
  • Report: pictute