MySQL class

• Select row :

  • $array_data = $database->select(DBTABLE_NAME,fields array(), array(" WHERE field=\"value_field\"")) 

    • inputs:
      • DBTABLE_NAME, the variable you have set in the config file
      • fields array(), the fields you have to select, if the array is empty it will select all the fields
      • additional request array(” WHERE field=\”value_field\””), here you can use any additional code of mysql, if you don’t want to add leave an empty array, this array has to have only one element
    • result will be an array of array, to obtain the ID of the third element you have to write $array_data[2][“ID”]
• Update row:

  • $result = $database->update(DBTABLE_NAME,fields array(),values array(),array(" WHERE field=field_value")) 

  • inputs:
    • DBTABLE_NAME, the variable you have set in the config file
    • fields array(), the fields you have to update
    • values array(), this array has to have the same length of the fields array, and also the same order
    • array(” WHERE id=1″), this array has to have one element and it has to be where the database has to modify
  • result can be 0 if there have been an error, 1 in case of success
• Delete row:

  • $result = $database->delete(DBTABLE_NAME,fields array(),values array()) 

  • inputs:
    • DBTABLE_NAME, the variable you have set in the config file
      • fields array(), the fields where you have to delete the row
      • values array(), this array has to have the same length of the fields array, and also the same order

• result is 1 in fase off success, otherwise 0

To use this class remember to include include the php file as in the following:

include_once("config.php");
include_once("databaseManager.php");
$database = new DatabaseManager();