SeniorDesignProject/dbcontroller.php at master · itsknob/SeniorDesignProject · GitHub

33 lines (29 loc) · 734 Bytes

<?php

class DBController {

private $host = "localhost";

private $user = "root";

private $password = "root";

private $database = "inventory";

private $conn;

function __construct() {

$this->conn = $this->connectDB();

}

function connectDB() {

$conn = mysqli_connect($this->host,$this->user,$this->password,$this->database);

return $conn;

}

function runQuery($query) {

$result = mysqli_query($this->conn,$query);

while($row=mysqli_fetch_assoc($result)) {

$resultset[] = $row;

}

if(!empty($resultset))

return $resultset;

}

function numRows($query) {

$result = mysqli_query($this->conn,$query);

$rowcount = mysqli_num_rows($result);

return $rowcount;

}

Expand file tree