Cacher is the code snippet organizer for pro developers

<?php

// instantiate database instance
$statement = Database::getInstance()->query(
       "SELECT
           *
        FROM 
           table_name"
   );

$results = $statement->fetchAll(PDO::FETCH_ASSOC);

<?php

// insert to database
$statement = Database::getInstance()->prepare(
    "INSERT INTO 
        table_name(field1, field2) 
    VALUES
        (:field1, :field2)"
    );

// assign variables to each place holder, indexed 1-3
$statement->execute(array(':field1' => $field1, ':field2' => $field2));