DBInteraction

DBInteraction.php

<?php

/*
 * DBInteraction
 */

class DBInteraction
{

    public function getReturnVisitByUserId($user_id, $db) {
        
        $query = $db->prepare('SELECT * FROM return_visits WHERE user_id = :user_id');

        $query->bindParam(':user_id', $user_id);
        
        $query->execute();

        $result = $query->fetchAll(PDO::FETCH_ASSOC);

        return $result;
        
    }

    public function getReturnVisits($db) {
        
        $query = $db->prepare('SELECT * FROM return_visits');
        
        $query->execute();

        $result = $query->fetchAll(PDO::FETCH_ASSOC);

        return $result;

    }

    public function getReturnVisit($db, $rVId) {
        
        $query = $db->prepare('SELECT * FROM return_visits WHERE id = :rVId');

        $query->execute(array(':rVId' => $rVId));

        $result = $query->fetchAll(PDO::FETCH_ASSOC);

        return $result;

    }

    public function updateReturnVisitInfo($db, $column, $value, $rVId) {

        $query = $db->prepare("UPDATE return_visits SET $column=:value WHERE id = :rVId");

        return $query->execute(array(':value' => $value, ':rVId' => $rVId));

    }

    public function createReturnVisit($db, $firstName, $lastName, $company, $email, $phone, $address1, $address2, $city, $state, $country, $lastVisit, $notes) {

        $query = $db->prepare('
                INSERT INTO `return_visits`
                (`firstName`, `lastName`, `company`, `email`, `phone`, `address1`, `address2`, `city`, `state`, `country`, `lastVisit`, `notes`) 
                VALUES
                (:firstName, :lastName, :company, :email, :phone, :address1, :address2, :city, :state, :country, :lastVisit, :notes)
            ');

        $query->bindParam(':firstName', $firstName);
        $query->bindParam(':lastName', $lastName);
        $query->bindParam(':company', $company);
        $query->bindParam(':email', $email);
        $query->bindParam(':phone', $phone);
        $query->bindParam(':address1', $address1);
        $query->bindParam(':address2', $address2);
        $query->bindParam(':city', $city);
        $query->bindParam(':state', $state);
        $query->bindParam(':country', $country);
        $query->bindParam(':lastVisit', $lastVisit);
        $query->bindParam(':notes', $notes);

        return $query->execute();

    }

}