Applications in PHP and SQL

Czech flag

Česky
Enter the password to download the source codes

Person Form

The form has a well-resolved validation. If you enter a name shorter than 3 characters, if you enter an age outside the reasonable range, if you enter a height that is too large, etc., the form will not be sent.

Order Form

Validation again at an advanced level. Generate a form through methods in an object. We keep the default values again. When sending, the script sends an email to the "chef" with a detailed order.

Discussion Forum

Applications with PHP7, MySQL, and JS technologies with object-oriented code. Discussion forum, which contains a form whose input is the name, email and text of the post.
The application can also:

  1. provides input validation, all fields are required, email must be in the correct form.
  2. then all posts that are stored in the database are displayed below the form. Posts must be sorted chronologically (the first is the most recent) and will display: name, email, text and the date the post was added.
  3. for each post, the total number of posts that the user has written in total (by email) is also displayed.

Inserting into the Database

Applications with PHP7 technologies, MySQL, with object-oriented code. Menu of dishes stored in the database, where you can add new food from the form.

Database Search

Applications with PHP7 & SQL technologies, with object-oriented code. Menu of dishes stored in the database, which can be searched using the form.

Save the Database to Files

  1. the database used by the above applications will be used
  2. this database is stored in the text file dishes.txt
  3. it is also stored in the CSV file dish-list.csv
  4. these new files are immediately offered for download / opening / saving

Insert Data into Sessions

  1. from the form we load the order of the type and quantity of food.
  2. we can also several times in a row
  3. all data will be stored in the Session field in the form of another field
  4. the program allows you to list all items stored in Sessions
  5. it is possible to clear Session data and order something once more

More Applications

For 4 years I have been teaching a websitemaking group with children in the House of Children and Youth. The external link in the title points to the PHP applications we have created.