<?php
/*
 * John L. Kotos
 * PHP33 Final Project
 * MIS 126-270 Fall 2016 Semester
 * Introduction to PHP
 * Instructor: Mike Pavlak
 * Date: December 02, 2016
 * Filename: type_db.php
 * Code based 'My Guitar Shop' from: Harris, R. & Murach, J. (2014). Murach's php and mysql. Fresno, CA: Mike Murach and Associates.
 */

function get_types()
{
    global $db;
    $query = 'SELECT * FROM types
              ORDER BY typeID';
    try 
    {
        $statement = $db->prepare($query);
        $statement->execute();
        $types = $statement->fetchAll();
        $statement->closeCursor();
        return $types;
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}

function get_type_name($type_id)
{
    global $db;
    $query = 'SELECT * FROM types
              WHERE typeID = :type_id';
    try 
    {
        $statement = $db->prepare($query);
        $statement->bindValue(':type_id', $type_id);
        $statement->execute();
        $type = $statement->fetch();
        $statement->closeCursor();
        $type_name = $type['typeName'];
        return $type_name;
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}
?>