<?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>"; }