Learning Dynamic Website Design - PHP MySQL and JavaScript

Install WAMP, MAMP, or LAMP, use a plain text editor like Notepad or Textpad, and consult php.net and mysql.com to develop and test PHP and MySQL locally.

Install and configure WampServer on a Windows PC, selecting 64-bit or 32-bit versions, running the setup wizard, and enabling Apache, PHP, and MySQL with phpMyAdmin.

Install the MAMP bundle on macOS to quickly set up Apache, MySQL, and PHP. Launch MAMP, use the free edition, and verify PHPMyAdmin connects to MySQL on non-standard ports.

switch nonstandard ports 8888 and 8889 to standard 80 for Apache and 3306 for MySQL using preferences, restart servers, and verify on the start page.

Deploy your PHP programs and set up a MySQL database using a hosting service, then publish your web app online after developing locally with WAMP or MAMP.

Learn how to use PHP script tags correctly, start WampServer, and run pages on localhost. Keep HTML outside PHP blocks and use multiple PHP blocks for proper execution.

See how PHP outputs HTML to the browser by embedding the date function to display time within static HTML, keep static HTML outside PHP, and use inline styles with spans.

Explore how HTML forms gather user information and send it to a PHP program via a post form, using input fields with names and a submit button.

learn to use a select tag in an html form and process value with php, creating a drop-down for administrator, faculty, or staff and displaying the result in blue text.

Learn to use the textarea tag to capture multi-line input in a form, set rows and columns, post it with PHP, and preserve line breaks.

Learn to use radio buttons in an html form and process the selection with php, grouping by etype, using values fulltime and parttime, default checked, and retrieving via $_POST.

Learn to implement HTML checkboxes and process them with PHP, using BA, MA, and PhD to capture multiple degree options, and handle none, one, or all selections with isset.

Learn how to assign values to PHP variables, concatenate first and last names with interpolation, handle numbers without quotes, and use the date function to compute birth year from age.

Discover appending text in PHP with the dot operator to concatenate strings and variables, using single vs double quotes and literal vs interpolated content.

Master debugging techniques in PHP by identifying parse errors, undefined variables, and missing semicolons; learn how case sensitivity and naming conventions affect variable references and how to fix them.

Develop assignment as a real estate form that collects first name, last name, contact method, city, and comments, and displays the submission with a top logo and a thank-you message.

Demonstrates completing assignment one with HTML, PHP, and CSS, featuring a form for first name, last name, phone or email, city, and comments, plus directory structure and logo assets.

Learn about string delimiters in PHP, handle double and single quotes, use escape characters and concatenation to print mixed quotes without parse errors.

Explore how PHP handles arithmetic operators, unary minus, and number formatting with number_format. The lesson uses PHP.net documentation and examples like apples to illustrate addition, subtraction, multiplication, division, and modulus.

Learn how to build HTML tables and output them from PHP using table, tr, td, and th, with borders and input fields aligned in cells.

Apply the if statement to make decisions in a PHP, MySQL, and JavaScript context by reading a form with name and birth year, computing age, and conditionally displaying retirement messaging.

Learn how the else clause complements the if statement in PHP, selecting the else branch for age-based logic and emphasizing testing of all code blocks.

Explore nested if statements by building a form that computes age and total years slept from birth year and hours slept, then prints retirement or sleep messages.

Learn to format PHP code with consistent indentation and brace alignment, making nested if statements readable and easy to debug by avoiding missing end curly braces and excessive blank lines.

Master PHP comparison operators, including equals versus assignment, not equals, and not identical; use elseif to simplify if statements and evaluate numeric and string literals.

Apply the and operator in PHP within an if statement to require multiple conditions, such as age over 50 and hours slept over 15, using a truth table.

Learn how the or operator in PHP connects two comparisons in an if statement using the double pipe ||, and see how true results arise when either side is true.

Master the not operator to negate conditions and correctly exclude cities. Explore the or logic pitfalls and rewrite expressions with not in to avoid false positives.

Learn to implement field validations in PHP forms by checking for empty and non-numeric inputs, validating birth year as four digits with strlen, and controlling flow with exit.

Learn to use the div tag to create styled rectangles with IDs. Apply CSS for absolute positioning, padding, and the box model to build two offset boxes on a page.

Discover placing multiple forms inside divisions on a webpage, with separate submissions to fruits.php and yourage.php, and styling controlled by basic_3.css.

Identify and fix errors in a PHP form by tracing an undefined index, correcting HTML input names, and adding deliberate debug statements and break points to inspect variables.

Create independent forms in separate divisions: the guest list form from assignment 1 and a mortgage calculator that computes monthly payments from amount financed and interest rate, with PHP validation.

Explore the assignment 2 solution as it shows a form with multiple divs, numeric validation, and calculation of amount financed, interest rate, and monthly payment with formatted output.

Learn how to implement a for loop in PHP to process form data and print repeated lines using a counter variable like $ii, generating team member1, member2, and so on.

Explore the while loop in PHP, compare it to the for loop, and manage a manual counter to generate grocery list outputs, using break and continue for flow control.

Read a text file with PHP and dynamically display its city list in a browser, using fopen, fgets, and a loop.

Write user-submitted grocery list items from a form to a file using PHP, demonstrating writing vs appending with fopen modes, fwrite, and newline handling.

Display data from a file in a PHP-powered HTML table by appending names, delimiting with pipes, and using explode and list to render alternating row colors.

Debug PHP and HTML by spotting syntax errors, missing semicolons, and unbalanced braces. Use the line_ctr variable and explode for parsing and proper file read/write.

Learn how assignment three builds a php-driven guestbook by reading city options from cities.txt, appending entries to guestbook.txt, and displaying them in an HTML table with alternating row colors.

This assignment 3 solution demonstrates building a file-based guest book in PHP, with a city select list, viewing the guest book, and appending entries using a delimited text file.

Define a custom PHP function displayMsg, learn to call it to process form input from $_POST and print hi first name.

Learn to define a PHP function that receives a filename, reads a cities file, counts lines, and prints each trimmed city with a for loop.

Define a custom PHP function and return its value to the caller, illustrating how the right side of the assignment is evaluated first and the returned data is used.

Learn to define a PHP function that receives data from a form (first name, hours slept, birth year), validates inputs, concatenates error messages, and returns them for display.

Examine variable scope in PHP, tracing how variables are declared, assigned, and accessed inside and outside functions, and how encapsulation and global declarations shape visibility and data flow.

Learn to return multiple values from a PHP function by appending to a file with pipes, then reading and exploding to build a table.

Learn to use include files to store PHP functions and include them in multiple programs, centralizing code in commonFunctions.php so updates propagate automatically and avoid copying.

Master the basics of PHP arrays, defining a named list of items, understanding zero-based indices, and building a team list with for loops and array_push for scalable data.

Sort arrays in PHP by in-place sort and display sorted team member names; compare index-based loops and foreach, then apply reverse sort with rsort and note case sensitivity.

Learn how to load an array from a file in PHP by reading each line with fgets, trimming it, pushing to an array, sorting, and displaying with foreach.

Load an array from a directory's file names to display house images on a webpage using PHP, skipping dot and dot-dot entries with opendir, dirhandle, and foreach with image sources.

Explore recursive programming in PHP by building a self-calling form handler that totals item amounts, validates numeric input, and displays errors or a final total via the PHP_SELF action.

Explore finding text inside other text with PHP, using foreach on an array, cleaning with str_replace and trim, removing colon and hyphen, and performing case-insensitive searches via strpos and substr.

Use regular expressions in PHP to search strings with preg_match, matching at the start with a caret and at the end with a dollar sign, demonstrated on a name list.

Explore how to perform a directory-based text search to list real estate records by city, using PHP to read index files, extract city, price, beds, and baths, and filter results.

Learn practical debugging techniques to identify and fix infinite loops, trace program flow with print statements, validate variables, and use view page source to diagnose html output.

Create assignment 4 by building a King Real Estate listings page with city search, guest book validation, and directory-based realtor images, using include files and king4.css.

Demonstrates building a dynamic PHP and CSS real estate page using divs like featuredhouse and realtorlist to display homes and listings, reading data from files, and preparing for database integration.

Discover SQL, the standard language for querying, defining, and manipulating data in relational databases. Learn about tables, keys, null values, and the SQL statements for data manipulation, definitions, and security.

Examine the example database showing publishers, books, and authors linked by a bridging association table, illustrating one-to-many and many-to-many relationships with primary and foreign keys.

Run mysql interactively using phpMyAdmin and a custom MySQL_interface for Wamp to test connections, browse tables like author, and execute SQL statements with live results.

Explore creating tables for publisher, book, author, and book_author with create table statements, define data types, and enforce primary keys, and null constraints, including a composite primary key.

Master a simple select statement using select and from, with a select list or star, and filter rows with a where clause. Understand case-insensitive data and ending statements with semicolons.

Explore how SQL comparison operators work with numbers, text, and dates using the where clause. Learn about quotes, data types, and examples like year-to-date sales and pubdate to filter results.

Explore how to use logical operators and, or, and not to filter book data and build a single result set with combined price and advance conditions, including handling nulls.

Filter null values in SQL using is null and is not null, avoiding equals and quotes. Combine with and/or to fetch rows with nulls and with other conditions.

Learn to sort data with the order by clause, arranging by title or price, perform multi level sorts, and apply descending order where needed in SQL.

Master aggregate functions in SQL to summarize data with sum, avg, min, max, and count. Use separate statements for detail versus summary results and note where clauses affect counts.

Learn pattern matching in sql with like, percent, and underscore wildcards to match begins with, ends with, or contains patterns, and filter last names by specific character positions.

Insert new rows into a table with the insert into statement, manage primary key constraints, and handle nulls and syntax errors to ensure successful database updates.

use the update statement to modify existing data in a table, setting columns such as type and price, while using a where clause to target a specific row.

Delete rows with the delete statement using a where clause and pattern matching like 'NEW%', deleting one or all; use the drop statement to remove the table.

Learn to debug sql statements by inserting into the publisher table, recognize primary key constraints and duplicate entries, and use update or delete carefully to avoid column count mismatches.

Create and query a MySQL database by building employee and department tables, inserting data, displaying results, calculating the average salary, and updating, deleting, and dropping the department table.

Review the assignment five solutions, covering creation of employee and department tables, data types and constraints, inserts, queries, salary averages, salary updates, deletions, and table drops.

Connect a PHP program to a MySQL database on localhost and display California authors by building a select statement, executing it with mysqli_query, and rendering an HTML table.

Learn how to pass data to a select statement in PHP by filtering authors by state code, using an all states option, and displaying results in a dynamic HTML table.

Learn how to add author rows to MySQL table with PHP using a form for social security number, last name, and first name, with validation and handling of duplicate keys.

Learn how to delete author rows from a MySQL table using PHP, with checkboxes wired to the primary key, POST request handling, and a delete function that confirms removal.

Learn how to update author data in a php-driven table by submitting a social security number through a form and performing an sql update with a where clause.

Populate a select option list on a web page by fetching city names from a MySQL city table with PHP, building options in a loop. Verify Chicago, Detroit, Toronto appear.

Validate a user login by querying the MySQL valid users table with the entered user id and password in a PHP program. Then display list of book titles and types.

Master relative referencing in PHP by using ../ to move up directories, ensuring CSS, images, and realtor names load correctly when deploying from root to a subdirectory.

Learn to create a realtor table in phpMyAdmin with an auto increment primary key and fields for last name, first name, phone, email, and image file.

Learn how to insert data into a realtor table with phpMyAdmin, leverage auto-incremented ids, edit, copy, and export SQL for structure and data.

Learn to use include files to share PHP functions across programs, connect to a database, and display author data in an HTML table with a selectResults function.

Learn to debug SQL statements inside a PHP program by validating syntax, inspecting generated queries, fixing table names, misspellings, spacing, and proper quoting while testing by state codes.

Learn to replace file-based data handling with MySQL relational databases for assignment six, using SQL statements and include files to manage home, guestbook, and realtor data.

Convert assignment 4 to a database-driven solution, replacing file data with MySQL queries and a dedicated insert-delete-update function; fetch realtors and homes, and enable city searches with LIKE.

This is part 2 of the assignment six solution, detailing the guest book and mortgage calculator, populating city options from the database, and handling insert, view, and validation.

Learn to format and manipulate dates in MySQL using date_format and adddate, update publication dates, and understand server-side date handling for reliable results.

Learn how to create and use database indexes to speed up queries, including single and multi-column indexes like the author's last name, full name, and unique book titles.

Group data with the group by clause to summarize by one or more columns using aggregate functions, while understanding where, order by, null handling, and the upcoming having clause.

Explore how the having clause filters groups after aggregation, acting as a where clause for groups. Apply aggregates with having to limit groups, noting that where cannot filter aggregates.

Master explicit join syntax in the from clause to combine two tables, then chain joins for multiple tables using on or using clauses, and apply aliases.

Join three tables—author, book, and book author—to retrieve authors of a given book using SSN and ISBN keys, with equality joins and where title matches Secrets of Silicon Valley.

Join three tables via a bridging table (association table) to connect author and book data, then use group by book title and having count of authors greater than one.

Explore how subqueries nest a select inside another to drive the outer statement. Compare inner and outer selects, self joins, and use of in and equals with books and prices.

Explore subqueries, including inner selects to identify the third author, using aggregates to compare sales and advances, and updating prices with subqueries and the in operator.

Practice SQL in PHP, MySQL, and JavaScript with Assignment 7, solving problems on average author positions, publisher price groups, city-based author lists, and subqueries to filter authors.

Solves assignment seven with sql: avg author_order by ssn using group by and having; count ssn; use subquery to exclude Maryland/Illinois and four-table joins for publisher name like 'Bin%'.

Compare a PHP program and its JavaScript counterpart that validate the entered name and display instructor or student messages. Highlight differences in security, getElementById, and using id versus name attributes.

Validate a form on the client with JavaScript by checking first name and age, ensuring non-empty inputs and a numeric age, and display errors with innerHTML.

Learn how to position a div with JavaScript by using absolute positioning, updating left and top coordinates, and toggling visibility on image hover to create dynamic, interactive web pages.

Parse multiple values from a delimited string with JavaScript, preparing for Ajax with PHP. Split a pipe-delimited name, build HTML, and display the red text in a message div.

Learn how a simple ajax example connects a page to a server with the XML HTTP Request Object. See how a request object posts data and handles the server response.

Learn to update a web form in place using Ajax, converting Fahrenheit to Celsius with a PHP backend and dynamic input field updates.

Learn to use AJAX to run a select statement and display the results inline on a web page, updating the valid users division with a generated table.

Apply Ajax to insert new users into a MySQL database and verify updates by viewing the users list, using PHP to process insert operations and report results.

Debug JavaScript and PHP by isolating each language, test on localhost, and use alerts and the error console to fix form validation, type checks, and PHP-JS concatenation errors.

Master dynamic PHP, MySQL, and Ajax-driven features, including live form validation, a guest book, mortgage calculator, and a searchable homes catalog.

Discover how assignment eight is organized with modular PHP and JavaScript to display realtor details, using database queries, string concatenation, and onMouseOver events to show a positioned yellow info box.

Explore part two of the assignment eight solution, featuring ajax-driven guest book, form validation, and PHP, MySQL, and JavaScript integration.

Validate the form and display validation messages via a hidden div, then process guest book entries with ajax, PHP, and a mortgage calculator demo.