Create database class

[beumerr]

Location: src/admin/classes/quaco-db.php

Requirements:

• Use mysqli
• Always prepare values

Tips:

• WordPress created a pretty genius database class, check it out

Globals for db connection:

• $db_name
• $db_host
• $db_pass
• $db_charset

'*' = method contains parameters

Methodes:

• constructor -> check / create connection to DB
• get_last_id -> returns ID from last insert
• _construct -> set db vars
• db_connect -> Init db connection
• prepare -> Prepares a SQL query for safe execution. Uses sprintf()-like syntax.
  • placeholder_escape ->Generates and returns a placeholder escape string for use in queries
    returned by ::prepare()
  • add_placeholder_escape ->Adds a placeholder escape string, to escape anything that
    resembles a printf()
  • remove_placeholder_escape ->Removes the placeholder escape strings from a query.
• get_var -> execute select query, returning 1 value *
• get_row -> execute select query, returning row *
• get_table -> execute select query, returning table *
• delete -> execute delete query *
• update -> execute update query *
• insert -> execute insert query *
• query -> execute any query *