PHP Notes

All keywords (e.g. if, else, while, echo, etc.), classes, functions, and user-defined functions are NOT case-sensitive, but all variable names are case-sensitive.

A variable starts with the $ sign, followed by the name of the variable
A variable name must start with a letter or the underscore character
A variable name cannot start with a number
A variable name can only contain alpha-numeric characters and underscores (A-z, 0-9, and _ )
Variable names are case-sensitive ($age and $AGE are two different variables)

Continue reading “PHP Notes”

PHP MySQL Inserting Records Reference

First up there are three examples for inserting records into a MySQL database, one for each of the three following techniques:

  • Using mysqli in a procedural manner.
  • Using mysqli in an object-oriented fashion.
  • Using PDO.

After that there is an example of the same three approaches, but with the addition of using prepared statements for improved security and efficiency.

Continue reading “PHP MySQL Inserting Records Reference”