PHP and MySQL

webapps

Welcome to the tutorial series on PHP and MySQL. These tutorials will help you to build powerful web applications and databases for the web. If you want to build an online store, social network, or any powerful web-based application then PHP and MySQL are great languages to try out. PHP is a server-side language that allows you to build dynamic websites and MySQL is a language that allows your application to talk to a database.

Before starting these tutorials, it is a good idea to be familiar with HTML and CSS as well as JavaScript – luckily, there are plenty of tutorials to help you out there! If you are new to PHP and MySQL then start with the first tutorial, otherwise you can jump ahead if you already have some experience in these languages.

  1. Getting started with PHP and MySQL
  2. Echo statements and adding comments to your code
  3. Using HTML tags in echo statements and string concatenation
  4. Variables 
  5. Constants
  6. Data types
  7. Operators
  8. If statements
  9. Else and if else statements
  10. Switch statements
  11. For loops
  12. While loops
  13. Do while loops
  14. Break and continue
  15. Creating and using functions
  16. Default arguments in a function
  17. Variable scope
  18. String length and indexing (strlen function)
  19. String functions – strpos
  20. String functions – substr
  21. String functions – substr_replace and str_replace
  22. String functions – strtolower and strtoupper
  23. Introduction to arrays
  24. Modifying existing values in an array
  25. Looping through arrays (and counting elements in an array)
  26. Associative arrays
  27. Foreach loops
  28. Array functions – implode and explode
  29. Array functions – extract
  30. Sorting arrays
  31. Slicing (splitting) and merging arrays
  32. Passing an array into a function
  33. Include and require functions
  34. Handling form data
  35. Form data validation
  36. More data validation
  37. Checking set values (radio buttons)
  38. Check boxes in forms
  39. Select lists in forms
  40. Other form elements (text, text area, and password)
  41. The request method (form handling in one file)
  42. Date and time
  43. Ignore or strip HTML tags from strings
  44. Generate unique IDs and random strings
  45. More PHP and MySQL tutorials coming soon!

Other helpful resources