<?php
/* PROTOTYPE PORK TRACEABILITY SYSTEM
* Copyright © 2014 UPLB.*/
require_once 'dbinfo.inc';
$fxn = new phpork_functions();
if (isset($_POST['feed'])) {
$feed = $_POST['feed'];
$fxn->getFeedType($feed);
$fxn->getFeedProdDate($feed);
}
if (isset($_POST['med'])) {
$med = $_POST['med'];
$fxn->getMedType($med);
}
class phpork_functions
{
private function connect()
{
$link = mysqli_connect(HOSTNAME, USERNAME, PASSWORD, DATABASE) or die('Could not connect: ' . mysqli_error());
mysqli_select_db($link, DATABASE) or die('Could not select database' . mysql_error());
return $link;
}
public function ddl_mainlocation()
{
$link = $this->connect();
$query = "SELECT loc_name,\n\t\t\t\t\tloc_id\n\t\t\t\tFROM location";
$result = mysqli_query($link, $query) or die(mysqli_error($link));
while ($row = mysqli_fetch_row($result)) {
echo "<option value = {$row['1']} >{$row['0']}</option>";
}
