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 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.

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 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 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 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.

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.

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.

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.

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.

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.

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.

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.

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.