AppStateESS/InternshipInventory

View on GitHub
class/Command/MajorRest.php

Summary

Maintainability
A
0 mins
Test Coverage
<?php
/**
 * This file is part of Internship Inventory.
 *
 * Internship Inventory is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.

 * Internship Inventory is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License version 3
 * along with Internship Inventory.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Copyright 2011-2018 Appalachian State University
 */

namespace Intern\Command;

use Intern\PdoFactory;

class MajorRest {
    public static function getMajorDesc($num){
        $pdo = PdoFactory::getPdoInstance();

        $sql = "SELECT description
                FROM intern_major
                WHERE id = :num";

        $sth = $pdo->prepare($sql);
        $sth->execute(array('num' => $num));
        $result = $sth->fetchColumn(0);

        return $result;
    }
}