Murach PHP and MySQL 1st Edition by Joel Murach, Ray Harris ISBN 1890774561 9781890774561
Original price was: $50.00.$35.00Current price is: $35.00.
Murach PHP and MySQL 1st Edition by Joel Murach, Ray Harris – Ebook PDF Instant Download/Delivery: 1890774561, 9781890774561
Full download Murach PHP and MySQL 1st Edition after payment
Product details:
ISBN 10: 1890774561
ISBN 13: 9781890774561
Author: Joel Murach, Ray Harris
Murach PHP and MySQL 1st Table of contents:
Section 1: Get started fast with PHP and MySQL
1: Introduction to web development with PHP
The architecture of a web application
How a client-server architecture works
Figure 1-1: How a client-server architecture works
The architecture of a web application
The architecture of the Internet
Description
How static web pages are processed
Figure 1-2: How static web pages are processed
How a web server processes a static web page
A simple HTTP request
A simple HTTP response
Two protocols that web applications depend upon
Description
How dynamic web pages are processed
Figure 1-3: How dynamic web pages are processed
How a web server processes a dynamic web page with PHP
Description
A survey of web application software
Figure 1-4: A survey of web application software
Web browsers
Web servers
Server-side languages
Database servers
Highlights in the history of PHP
Highlights in the history of MySQL
Figure 1-5: Highlights in the history of PHP and MySQL
Highlights in the history of PHP
Highlights in the history of MySQL
Description
The Product Discount application
The user interface
Figure 1-6: The user interface for the Product Discount application
The first page (index.html)
The second page (the response)
The HTML file
Figure 1-7: The HTML file for the Product Discount application
The HTML file (index.html)
The CSS file
Figure 1-8: The CSS file for the Product Discount application
The CSS file (main.css)
The PHP file
Figure 1-9: The PHP file for the Product Discount application
The PHP file (display_discount.php)
How to edit and test a PHP application
How to edit a PHP page with a text editor
Figure 1-10: How to edit a PHP file with a text editor
Notepad++ with three tabs open
How to open, save, close, and start files
How to change the style for comments
Description
How to start and stop Apache and MySQL on your own computer
Figure 1-11: How to start and stop Apache and MySQL on your own computer
The XAMPP Control Panel
How to start the XAMPP control panel
How to start and stop Apache or MySQL
Description
How to deploy a PHP application
Figure 1-12: How to deploy a PHP application
The file structure for a PHP application on a local server
The file structure for the book applications and exercise starts
How to deploy a PHP application on a local server
How to deploy the downloadable applications on a local server
How to deploy an application on an Internet server
Description
How to run a PHP application
Figure 1-13: How to run a PHP application
The components of an HTTP URL
What happens if you omit parts of a URL
URLs for requesting pages from an Internet web server
URLs for requesting applications from a local web server
An index of the applications in the book_apps directory
Description
How to test and debug a PHP page
Figure 1-14: How to test and debug a PHP page
The Product Discount application in the Firefox browser
An error displayed in the Firefox browser
How to test a PHP page for the first time
How to retest a PHP page after you change the source code
Description
How to view the source code for a web page
Figure 1-15: How to view the source code for a web page
The source code for a PHP page
How to view the source code for a page in Firefox
How to view the source code for a page in Internet Explorer
Description
How to use NetBeans to develop a PHP application
How to work with PHP projects and files
Figure 1-16: How to use NetBeans to work with projects and files
NetBeans with three files in the main project open
How to work with projects
How to work with files
Description
Mac OS X note
How to edit and test a PHP application
Figure 1-17: How to use NetBeans to edit and test a PHP application
NetBeans with an auto-completion list and an error marker displayed
How to edit a PHP file
How to test a PHP application
Description
How to import and configure a PHP project
Figure 1-18: How to use NetBeans to import and configure a PHP project
The dialog box for starting a new project
The dialog box for configuring a project
How to check the run configuration for an existing project
How to import a project
Description
Perspective
Terms
Summary
Before you do the exercises for this book…
Exercise 1-1: Test the Product Discount application
Exercise 1-2: Run the book and exercise applications
Exercise 1-3: Check out your text editor
Exercise 1-4: Check out NetBeans
2: How to code a PHP application
Basic PHP skills
How to embed PHP in HTML
Figure 2-1: How to embed PHP in HTML
A PHP file that includes HTML and embedded PHP
The PHP file displayed in a browser
Description
How to code comments and statements
Figure 2-2: How to code comments and statements
PHP code that includes comments and statements
Another way to code single-line comments
Syntax rules
Description
The six PHP data types
Figure 2-3: The six PHP data types
The six PHP data types
Integer values (whole numbers)
Double values (numbers with decimal positions)
The two Boolean values
String values
Double values that use scientific notation
Description
How to declare variables and constants
Figure 2-4: How to declare variables and constants
The assignment operator
How to declare a variable
Rules for creating variable names
How to declare a constant
Description
How to get data from a request
How to use the built-in $_GET array
Figure 2-5: How to use the built-in $_GET array
The built-in $_GET array
An HTML form that performs an HTTP GET request
The URL for the HTTP GET request with appended key/value pairs
The $_GET array that’s created when the GET request is received
PHP code that gets the data from the array and stores it in variables
An tag that performs an HTTP GET request
Description
How to use the built-in $_POST array
When to use the HTTP GET and POST methods
Figure 2-6: When and how to use the built-in $_POST array
The built-in $_POST array
A PHP page for an HTTP POST request
An HTML form that specifies the POST method
PHP code that gets the data from the $_POST array
When to use the HTTP GET method
When to use the HTTP POST method
The Firefox dialog box that’s displayed if the user tries to refresh a post
Description
How to work with data
How to code string expressions
How to code echo statements
Figure 2-7: How to code string expressions and echo statements
How assign string expressions
How to use the concatenation operator (.) to join strings
The syntax for the echo statement
Description
How to code numeric expressions
Figure 2-8: How to code numeric expressions
Common arithmetic operators
Some simple numeric expressions
Statements that calculate a discount
The order of precedence for arithmetic expressions
Examples of precedence and the use of parentheses
Description
How to use the compound assignment operators
Figure 2-9: How to use the compound assignment operators
The compound assignment operators
Two ways to append string data to a variable
Three ways increment a counter variable
More examples
Description
How to use some built-in functions
Figure 2-10: How to use some built-in functions
A function for formatting numbers
Statements that format numbers
A function for getting the current date
Commonly used characters for formatting a date
Statements that format a date
Three functions for checking variable value s
Function calls that check variable values
Description
The Product Discount application
The user interface
The form in the HTML file
Figure 2-11: The user interface and HTML page for the Product Discount application
The first page (index.html)
The second page (product_discount.php)
The code for the form on the first page
The PHP file
Figure 2-12: The PHP file for the Product Discount application
The PHP file (display_discount.php)
How to code control statements
How to code conditional expressions
Figure 2-13: How to code conditional expressions
The relational operators
The logical operators in order of precedence
How the logical operators work
Description
How to code if statements
Figure 2-14: How to code if statements
An if statement with no other clauses
An if statement with an else clause
An if statement with else if and else clauses
An if statement with a compound conditional expression
A nested if statement
Description
How to code while and for statements
Figure 2-15: How to code while and for statements
A while loop that stores the numbers from 1 through 5 in a string
A for loop that stores the numbers from 1 through 5 in a string
A while loop that calculates the future value of a one-time investment
A for loop that calculates the future value of a one-time investment
Description
How to pass control to another page
Figure 2-16: How to pass control to another page
Built-in functions that you can use to pass control to another page
The include function
The require function
The exit function
How to pass control to another PHP file in the current directory
How to navigate up and down directories
Description
The Future Value application
The user interface
Figure 2-17: The user interface
The first page
The second page
The first page with an error message
The code for the index.php file
Figure 2-18: The code for the index.php file
The index.php file
The code for the displayresults.php file
Figure 2-19: The code for the display_results.php file (part 1 of 2)
The display_results.php file
Figure 2-19: The code for the display_results.php file (part 2 of 2)
The display_results.php file (continued)
How to use the PHP documentation
How to access the PHP manual
How to find the documentation you need
Figure 2-20: How to use the PHP documentation
The URL for the PHP documentation
Documentation for the if statement
How to access the PHP manual
How to use the PHP manual
How to find the documentation for a function when you know its name
Description
Perspective
Terms
Summary
Before you do the exercises for this chapter
Exercise 2-1: Build the Product Discount application
Exercise 2-2: Enhance the Future Value application
3: Introduction to relational databases and MySQL
An introduction to relational databases
How a database table is organized
Figure 3-1: How a database table is organized
A products table
Concepts
How the tables in a relational database are related
Figure 3-2: How the tables in a relational database are related
The relationship between two tables in a database
Concepts
How the columns in a table are defined
Figure 3-3: How the columns in a table are defined
The columns of the products table
Common MySQL data types
Description
The SQL statements for data manipulation
How to select data from a single table
Figure 3-4: How to select data from a single table
The syntax for a SELECT statement that gets all columns
The syntax for a SELECT statement that gets selected columns
Description
How to select data from multiple tables
Figure 3-5: How to select data from multiple tables
The syntax for a SELECT statement that joins two tables
Description
How to insert, update, and delete data
Figure 3-6: How to insert, update, and delete data
The syntax for the INSERT statement
The syntax for the UPDATE statement
The syntax for the DELETE statement
Description
An introduction to MySQL
What MySQL provides
Figure 3-7: An introduction to MySQL
MySQL is…
MySQL provides…
Description
Two ways to work with MySQL
Figure 3-8: Two ways to work with MySQL
A command-line client
A web-based client
How to use phpMyAdmin
How to start phpMyAdmin
How to log in, log out, and change your password
Figure 3-9: How to start phpMyAdmin, log in, log out, and change your password
The Welcome page
How to start phpMyAdmin on a local computer and log in
How to log out and return to the Welcome page
How to change your password
Description
How to import and run a SQL script that creates a database
Figure 3-10: How to import and run a SQL script that creates a database
An Import tab that imports and runs a SQL script that creates a database
How to import and run a SQL script
The script for creating the databases used by this book
Description
How to review the data and structure of a table
Figure 3-11: How to review the data and structure of a table
The Databases tab
The Structure tab for the my_guitar_shop1 database
The Browse tab for the categories table
Description
How to run SQL statements
Figure 3-12: How to run SQL statements
The SQL tab with a SQL statement that’s ready to be executed
The SQL tab after a SQL statement has been executed
Description
How to create users with limited privileges
Figure 3-13: How to create users with limited privileges
How to create a user with limited privileges on a single table
How to create a user with limited privileges on all tables in a database
Common privileges
The SQL tab for mgs_tester after an UPDATE statement failed
Description
Perspective
Terms
Summary
Exercise 3-1: Use phpMyAdmin with a database
4: How to use PHP with a MySQL database
PHP for working with MySQL
How to connect to a MySQL database
Figure 4-1: How to connect to a MySQL database
The syntax for creating an object from any class
The syntax for creating a database object from the PDO class
The syntax for a DSN (Data Source Name) for a MySQL database
How to connect to a MySQL database named my_guitar_shop1
Description
How to execute SELECT statements
Figure 4-2: How to execute SELECT statements
A method of the PDO class for executing a SELECT statement
The syntax for executing a method of any object
The syntax for executing the query method of the database object
A query method with the SELECT statement coded in a variable
A query method with the SELECT statement coded as the argument
Description
How to execute INSERT, UPDATE, and DELETE statements
Figure 4-3: How to execute INSERT, UPDATE, and DELETE statements
A method of the PDO class for modifying the database
How to execute an INSERT statement
How to execute an UPDATE statement
How to execute a DELETE statement
How to display the row counts
Description
How to use a try/catch statement to handle exceptions
Figure 4-4: How to use a try/catch statement to handle exceptions
The syntax for a try/catch statement
How to handle a PDO exception
How to handle any type of exception
Description
How to get data from a result set
How to work with arrays
Figure 4-5: How to work with arrays
Two of the built-in functions for working with arrays
How to create an array that doesn’t contain any elements
How to work with numeric indexes
How to work with string indexes
Description
How to get the data from the first row of a result set
Figure 4-6: How to get the data from the first row of a result set
A method of the PDOStatement class for getting an array for a ro w
Code that returns a result set that contains one row
Code that uses a string index to access each column
Code that uses a numeric index to access each column
Description
How to get the data from all the rows of a result set
Figure 4-7: How to get the data from all the rows of a result set
A query method that returns a result set of two or more rows
How to use a foreach statement to display the result set in an HTML table
Another syntax for the foreach statement that works better within PHP tags
Description
The Product Viewer application
The user interface
Figure 4-8: The Product Viewer application (part 1 of 4)
The user interface
The user interface after the user selects a new category
The code
Figure 4-8: The Product Viewer application (part 2 of 4)
The database.php file
The database_error.php file
Figure 4-8: The Product Viewer application (part 3 of 4)
The index.php file
Figure 4-8: The Product Viewer application (part 4 of 4)
The index.php file (continued)
The Product Manager application
The user interface
Figure 4-9: The Product Manager application (part 1 of 5)
The Product List page
The Add Product page
The code
Figure 4-9: The Product Manager application (part 2 of 5)
The index.php file
Figure 4-9: The Product Manager application (part 3 of 5)
The index.php file (continued)
Figure 4-9: The Product Manager application (part 4 of 5)
The delete_product.php file
The add_product_form.php file
Figure 4-9: The Product Manager application (part 5 of 5)
The add_product_form.php file (continued)
The add_product.php file
Perspective
Terms
Summary
Exercise 4-1: Enhance the Product Manager application
5: How to use the MVC pattern to organize your code
How to use the MVC pattern
An introduction to the MVC pattern
Figure 5-1: An introduction to the MVC pattern
The MVC pattern
Description
How to code functions
Figure 5-2: How to code functions
How to code a function
How to call a function
Description
How to redirect requests
Figure 5-3: How to redirect requests
A built-in function that you can use to redirect a request
The header function
How to redirect a request
How to redirect a request that includes a parameter
Description
The Product Manager application
The user interface
Figure 5-4: The Product Manager application (part 1 of 6)
The Product List page
The Add Product page
The model
Figure 5-4: The Product Manager application (part 2 of 6)
The model/category_db.php file
The model/product_db.php file
The controller
Figure 5-4: The Product Manager application (part 3 of 6)
The product_manager/index.php file (the controller)
The view
Figure 5-4: The Product Manager application (part 4 of 6)
The view/header.php file
The view/footer.php file
Figure 5-4: The Product Manager application (part 5 of 6)
The product_manager/product_list.php file (a view)
Figure 5-4: The Product Manager application (part 6 of 6)
The product_manager/product_add.php file (another view)
The Product Catalog application
The user interface
Figure 5-5: The Product Catalog application (part 1 of 4)
The Product List page
The Product page
The model
The controller
Figure 5-5: The Product Catalog application (part 2 of 4)
The product_catalog/index.php file (the controller)
The view
Figure 5-5: The Product Catalog application (part 3 of 4)
The product_catalog/product_list.php file (a view)
Figure 5-5: The Product Catalog application (part 4 of 4)
The product_catalog/product_view.php file (another view)
Perspective
Terms
Summary
Exercise 5-1: Enhance the Guitar Shop application
6: How to test and debug a PHP application
An introduction to testing and debugging
Typical test phases for a PHP application
The three types of errors that can occur
Figure 6-1: An introduction to testing and debugging
The Product Discount application with a logic error
The goal of testing
The goal of debugging
Three test phases
The three types of errors that can occur
Description
Common PHP errors
Figure 6-2: Common PHP errors
PHP code that contains errors
The PHP code that contains errors in NetBeans
Common syntax errors
Problems with variable names
Problems with values
An easy way to trace the execution of your PHP code
Figure 6-3: An easy way to trace the execution of your PHP code
PHP with echo statements that trace the execution of the code
The data displayed in a browser
Description
How to debug with xDebug and NetBeans
How to set and remove breakpoints
Figure 6-4: How to set and remove breakpoints
A code editor window with a breakpoint
Description
How to step through code
How to inspect variables
Figure 6-5: How to step through code and inspect variables
A debugging session with variables displayed
The toolbar buttons and shortcut keys for stepping through the code
Description
How to inspect the stack trace
Figure 6-6: How to inspect the stack trace
A debugging session with a stack trace displayed
Description
Perspective
Terms
Summary
Exercise 6-1: Trace with echo statements
Exercise 6-2: Use NetBeans to step through the Future Value application
Exercise 6-3: Use NetBeans to step through the Guitar Shop application
Section 2: Master PHP programming
7: How to work with form data
How to get data from a form
How to get data from text boxes, password boxes, and hidden fields
Figure 7-1: How to get data from text boxes, password boxes, and hidden fields
Attributes of the HTML tag for getting text input
The HTML for three types of fields
The text and password fields in the browser
The URL when using the GET method
The PHP for the GET method
The URL when using the POST method
The PHP for the POST method
Description
How to get data from a radio button
Figure 7-2: How to get data from a radio button
Attributes of the HTML tag for radio buttons
The HTML for three radio buttons in a group
The radio buttons in the browser
The PHP to access a radio button group that has a default button
The PHP to access a radio button group that doesn’t have a default button
Description
How to get data from a check box
Figure 7-3: How to get data from a check box
Attributes of the HTML tag for check boxes
The HTML for three check boxes
The check boxes in the browser
The PHP to access the check box data
Description
How to get data from an array of check boxes
Figure 7-4: How to get data from an array of check boxes
The HTML that stores three related check boxes in an array
The check boxes in the browser
PHP that accesses the array and its values
PHP that uses a loop to process the array
The message displayed by the browser
Description
How to get data from a drop-down list
Figure 7-5: How to get data from a drop-down list
Attributes of the HTML tag for drop-down lists
Attributes of the HTML tag
The HTML for a drop-down list
The drop-down list in a browser
The PHP to access the drop-down list data
Description
How to get data from a list box
Figure 7-6: How to get data from a list box
Attributes of the HTML tag for list boxes
The HTML for a list box that doesn’t allow multiple options
A list box that doesn’t allow multiple options to be selected
The HTML for a list box that allows multiple options to be selected
A list box that allows multiple options to be selected
The PHP for a list box that allows multiple options to be selected
Description
How to get data from a text area
Figure 7-7: How to get data from a text area
Attributes of an HTML