Getting Started With PHP And MySQL For Beginners

Learn how PHP comparison operators compare numbers and strings, and when to use the equality, identical, and not identical operators to respect data types.

Explore how logical operators combine conditions in PHP, including and (&&), or (||), not (!), and xor, with examples showing when both, either, or exactly one condition is true.

Explore how the while loop repeats code while a condition remains true, using a counting example up to 500. Learn various increment methods and how to prevent infinite loops.

Explore how the return statement in a function sends back the computed value and stops execution, demonstrated with a two-parameter addition returning the answer.

Explore how the post method hides form data in the http body, accessed via the PHP post superglobal array, echoed for testing, and suited for passwords.

Understand the PHP session super global, storing data on the server and comparing it to cookies. Start a session, set name and cart, then unset and destroy.

Start the Apache server and MySQL, then open phpMyAdmin at localhost to create a database named php, and prepare to build your first table.

Create data entries in a users table using phpMyAdmin's insert tab, using autoincrement IDs and the insert into users syntax with username and password values.

Learn how to update a user password using the SQL update statement on the users table by setting the password and using where to target the correct username.

Learn how the SQL delete command removes data by deleting from the users table where the username equals matter, and see the single row affected after execution.

Connect to your MySQL database from PHP using the MySQLi extension, declare host, user, password, and database name, and handle success or error messages.

Learn how to read data with a SQL select in PHP, retrieve rows from the users table, and print usernames and passwords using mysqli functions like num_rows and fetch_assoc.

Demonstrate deleting a user in PHP and MySQL with delete from users table where username is Kaylee, including success checks and error handling.