function updateTicket() { // connect db=> stmt sql => insert => refresh page if (isset($_POST)) { $ticketshowID = $_POST['showid_value']; } $conn = dbConnect(); // start connect db if ($conn) { $insert = " INSERT INTO EMM_ZOO.TICKETSHOW_BUYING (TICKETSHOW_ID, SHOWID, ROUNDID , BUYING_DATE) VALUES (DEFAULT, '{$ticketshowID}',CURRENT TIME, CURRENT DATE);"; echo $insert; $rc = db2_exec($conn, $insert); if ($rc) { header("Refresh:0; url=ShowList.php"); } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } // finish all query statement db2_free_stmt($rc); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function updateTicket() { // connect db=> stmt sql => insert => refresh page if (isset($_POST)) { $tickettourID = $_POST['tourid_value']; } $conn = dbConnect(); // start connect db if ($conn) { $insert = " INSERT INTO EMM_ZOO.TICKETTOUR_TRANSACTION (TICKETTOUR_ID, TOUR_ID, DATE) VALUES (DEFAULT, '{$tickettourID}', CURRENT DATE);"; echo $insert; $rc = db2_exec($conn, $insert); if ($rc) { header("Refresh:0; url=TourTicket.php"); } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } // finish all query statement db2_free_stmt($rc); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function editEquipInfo() { if (isset($_POST)) { $equipid = $_POST['update_equipid']; $equipname = $_POST['edit_equipname']; $equiptype = $_POST['edit_equiptype']; $status = $_POST['edit_status']; } $conn = dbConnect(); if ($conn) { $sql = "UPDATE EMM_ZOO.SANITATION_EQUIP SET EQUIPID = '{$equipid}', EQUIPNAME = '{$equipname}' , EQUIPTYPE = '{$equiptype}', STATUS = '{$status}' WHERE EQUIPID = {$equipid};"; $result = db2_exec($conn, $sql); if ($result) { echo "<script>"; echo "alert('Updated successfully')"; echo "</script>"; header('Location: sani_equip.php#car_list'); exit; } else { $resultMessage = 0; echo "<script>"; echo "alert('Updated unsuccessfully')"; echo "</script>"; return $resultMessage; } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function orderoldfood() { if (isset($_POST)) { $food_id = $_POST['food_id']; $food_name = $_POST['food_name']; $food_type = $_POST['food_type']; $add_amount = $_POST['add_amount']; $price_per = $_POST['price_per']; $total = $add_amount * $price_per; } $conn = dbConnect(); if ($conn) { $sql0 = "SELECT AMOUNT FROM EMM_ZOO.FM_STOCK WHERE FOODID = {$food_id};"; $stm = dbQuery($conn, $sql0); while ($row = dbFetchArray($conn, $stm)) { $amountx = $row[0]; } $amount_now = $amountx + $add_amount; $sql1 = "INSERT INTO EMM_ZOO.FOODANIMAL_EXPENSE (FOODEXPENSE_ID,DATES,FOODID,COST,RESPONPERSONID) VALUES (DEFAULT,CURRENT DATE,{$food_id},{$total},'5678');"; $cb = db2_exec($conn, $sql1); $sql2 = "UPDATE EMM_ZOO.FM_STOCK SET AMOUNT = {$amount_now} WHERE FOODID = {$food_id};"; $cc = db2_exec($conn, $sql2); if ($cc && $cb) { $resultMessage = 1; return $resultMessage; header('Location: FoodStock.php#food_list'); } else { $resultMessage = 0; return $resultMessage; } db2_free_stmt($stmt); db2_close($conn); } }
function editCarPlate() { if (isset($_POST)) { $carid = $_POST['update_carid']; $carplate = $_POST['edit_carplate']; } $conn = dbConnect(); if ($conn) { $sql = "UPDATE EMM_ZOO.SANICAR SET CARID = '{$carid}', CARPLATE = '{$carplate}' WHERE CARID = {$carid};"; $result = db2_exec($conn, $sql); if ($result) { echo "<script>"; echo "alert('Updated successfully')"; echo "</script>"; header('Location: sani_garbage.php#car_list'); exit; } else { $resultMessage = 0; echo "<script>"; echo "alert('Updated unsuccessfully')"; echo "</script>"; return $resultMessage; } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function insertSaniEmp() { //print_r($_POST); if (isset($_POST)) { $empid = $_POST['empid']; $zoneid = $_POST['zoneid']; $jobid = '17'; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $birthdate = $_POST['birthdate']; $sex = $_POST['sex']; $nationality = $_POST['nationality']; $hiredate = $_POST['hiredate']; $address = $_POST['address']; $email = $_POST['email']; $phone = $_POST['phone']; $salary = $_POST['salary']; $bonus = $_POST['bonus']; // an array that want to insert this can be multiple array at the time. $data = array($empid, $zoneid, $jobid, $firstname, $lastname, $birthdate, $sex, $nationality, $hiredate, $address, $email, $phone, $salary, $bonus); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { $sql = 'INSERT INTO EMM_ZOO.EMPLOYEE (EMPID, ZONEID, JOBID, FIRSTNAME, LASTNAME, BIRTHDATE, SEX, NATIONALITY, HIREDATE, ADDRESS, EMAIL, PHONE, SALARY, BONUS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?);'; //$sql2 = 'INSERT INTO EMM_ZOO.EMP_SANI (EMPID) VALUES (?);'; //echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to sanitation employee"; //echo "Successfully added"; echo "<script>"; echo "alert('Added successfully')"; echo "</script>"; header('Location: addEmpHome.php'); exit; } else { $resultMessage = "Failed to query into database"; echo "<script>"; echo "alert('Failed to query into database')"; echo "</script>"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function uploadBioInfo() { if (!isset($_SESSION['current_user_name']) && !isset($_COOKIE[$cookie_name])) { header('Location: ../login.php'); exit; } else { //print_r($_POST); if (isset($_POST)) { $AnimalID = $_POST['AnimalID']; $species = $_POST['species']; $Phylum = $_POST['Phylum']; $Class = $_POST['Class']; $Order = $_POST['Order']; $Family = $_POST['Family']; $Genus = $_POST['Genus']; $warmblooded = $_POST['warmblooded']; $Cover = $_POST['Cover']; $Reproduction = $_POST['Reproduction']; $Habitat = $_POST['Habitat']; $food = $_POST['food']; $BodyTemp = $_POST['BodyTemp']; $EnviTemp = $_POST['EnviTemp']; $LifeSpan = $_POST['LifeSpan']; // an array that want to insert this can be multiple array at the time. $data = array($AnimalID, $species, $Phylum, $Class, $Order, $Family, $Genus, $warmblooded, $Cover, $Reproduction, $Habitat, $food, $BodyTemp, $EnviTemp, $LifeSpan); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } require_once '/var/www/html/app/model/connect.php'; $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = 'INSERT INTO EMM_ZOO.BIOINFO (SPECIESID,SPECIESNAME, PHYLUM, CLASS, ORDER, FAMILY, GENUS, WARMBLOODED, BODYCOVER, REPRODUCTION, HABITAT, COMMONFOOD, BODYTEMP, ENVITEMPRANGE, LIFESPAN) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);'; //echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to Biological information"; echo "Successfully added"; header('Location: BioInfo.php'); exit; } else { $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } } }
/** * closes the cursor, allowing the statement to be executed again */ public function closeCursor() { if (!$this->_stmt) { return false; } db2_free_stmt($this->_stmt); $this->_stmt = false; }
/** * {@inheritdoc} */ public function closeCursor() { if (!$this->_stmt) { return false; } $this->_bindParam = array(); db2_free_result($this->_stmt); $ret = db2_free_stmt($this->_stmt); $this->_stmt = false; return $ret; }
function insertBuilding() { if ($_POST['form_token'] != $_SESSION['form_token']) { header('Location:index.php'); } else { //print_r($_POST); if (isset($_POST)) { $emm = $_POST['BEmp']; $zone = $_POST['BZone']; $build = $_POST['Building']; $floor = $_POST['floor']; $room = $_POST['room']; // an array that want to insert this can be multiple array at the time. $data = array($build, $floor, $room); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = 'INSERT INTO EMM_ZOO.MAINTAINBUILDING (MAINTEGERAINID, BUILDINGNAME, FLOORLEVEL, ROOM) VALUES (DEFAULT,?,?,?);'; //echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added"; //echo "Successfully added"; echo "<script>"; echo "alert('Successfully')"; echo "</script>"; header('Location: index.php'); exit; } else { echo "<script>"; echo "alert('Failed')"; echo "</script>"; $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } } }
function updateTicket() { // connect db=> stmt sql => insert => refresh page if (isset($_POST['id_value'])) { $transID = $_POST['id_value']; } $conn = dbConnect(); // start connect db if ($conn) { $update = "UPDATE EMM_ZOO.TICKETTRANS_TRANSACTION SET TICKETTRANS_TIMEIN = CURRENT TIME WHERE TICKETTRANS_ID = " . $transID . ";"; //echo $update; $rc = db2_exec($conn, $update); if ($rc) { //header("Refresh:0; url=TranspotationIN.php"); } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } // finish all query statement db2_free_stmt($rc); $sql = "SELECT * FROM EMM_ZOO.TICKETTRANS_TRANSACTION JOIN EMM_ZOO.TICKETTRANS_TYPE ON VEHICLETRANS_ID = TRANSTYPE_ID WHERE TICKETTRANS_ID = " . $transID . ";"; $stmt = db2_exec($conn, $sql); while ($row = db2_fetch_assoc($stmt)) { $tran_price = $row['TRANSTYPE_PRICE']; $tran_type = $row['TRANSTYPE_NAME']; $hourOut = (int) substr($row['TICKETTRANS_TIMEOUT'], 0, 2); $hourIn = (int) substr($row['TICKETTRANS_TIMEIN'], 0, 2); $extraOut = (int) substr($row['TICKETTRANS_TIMEOUT'], 3, 2); $extraIn = (int) substr($row['TICKETTRANS_TIMEIN'], 3, 2); $price = ($hourIn - $hourOut) * $tran_price; // ราคาต้องดึงมาจาก trans_Type table if ($extraIn - $extraOut > 0) { $price += $tran_price; } if ($extraIn - $extraOut == 0 && $hourIn - $hourOut == 0 && (int) substr($row['TICKETTRANS_TIMEOUT'], 6, 2) != (int) substr($row['TICKETTRANS_TIMEIN'], 6, 2)) { $price += $tran_price; } if ($stmt) { // echo "Insert successfully!!"; echo "<script>alert('Price of {$tran_type} is {$price}');window.location='TranspotationIN.php';</script>"; //header("Refresh:0; url=TranspotationIN.php"); } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } } db2_free_stmt($rc); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function insertUselog() { //print_r($_POST); if (isset($_POST)) { $equipid = $_POST['equipid']; $equipname = $_POST['equipname']; $empid = $_POST['empid']; $zoneid = $_POST['zoneid']; $borrowdate = $_POST['borrowdate']; $returndate = $_POST['returndate']; // an array that want to insert this can be multiple array at the time. $data = array($equipid, $equipname, $empid, $zoneid); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { $sql = 'INSERT INTO EMM_ZOO.SANI_EQUIPUSELOG (EQUIPID, EMPID, WORKZONEID, BORROWDATE, RETURNDATE) VALUES (?,?,?,?,?);'; //$sql2 = 'INSERT INTO EMM_ZOO.EMP_SANI (EMPID) VALUES (?);'; //echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to Equipment use log"; //echo "Successfully added"; echo "<script>"; echo "alert('Added successfully')"; echo "</script>"; header('Location: addUselogHome.php'); exit; } else { $resultMessage = "Failed to query into database"; echo "<script>"; echo "alert('Failed to query into database')"; echo "</script>"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function insertEmpAtt() { //print_r($_POST); if (isset($_POST)) { $attno = $_POST['attno']; $dates = $_POST['dates']; $empid = $_POST['empid']; $workzoneid = $_POST['workzoneid']; $dutyid = $_POST['carplate']; $starttime = $_POST['starttime']; $endtime = $_POST['endtime']; // an array that want to insert this can be multiple array at the time. $data = array($attno, $dates, $empid, $workzoneid, $dutyid, $starttime, $endtime); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { $sql = 'INSERT INTO EMM_ZOO.SANIEMP_ATTEND (ATTENDNO, DATES, EMPID, WORKZONEID, DUTYID, STARTTIME, ENDTIME) VALUES (?,?,?,?,?,?,?);'; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to sanitation car"; //echo "Successfully added"; echo "<script>"; echo "alert('Added successfully')"; echo "</script>"; header('Location: addCarHome.php'); exit; } else { $resultMessage = "Failed to query into database"; echo "<script>"; echo "alert('Failed to query into database')"; echo "</script>"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function updateTicket() { // connect db=> stmt sql => insert => refresh page if (isset($_POST)) { $type[0] = $_POST['typeC']; $type[1] = $_POST['typeA']; $type[2] = $_POST['typeF']; $num[0] = intval($_POST['TicketNumC']); $num[1] = intval($_POST['TicketNumA']); $num[2] = intval($_POST['TicketNumF']); //$num = $_POST['TicketNum']; } // start connect db $conn = dbConnect(); if ($conn) { //Part one select data from tickettype for ($i = 0; $i <= 2; $i++) { if ($num[$i] == 0) { continue; } $sql = "SELECT * FROM EMM_ZOO.TICKETGATE_TYPE WHERE TICKETGATE_TYPE = '{$type[$i]}';"; $stmt = db2_prepare($conn, $sql); $result = db2_execute($stmt); while ($row = db2_fetch_assoc($stmt)) { $ticket_price = $row['TICKETGATETYPE_PRICE']; $ticket_type = $row['TICKETGATE_TYPE']; $ticket_id = intval($row['TICKETGATETYPE_ID']); //printf ("%-5d %-16s %-32d\n", // $ticket_price, $ticket_type, $ticket_id); } $insert = "INSERT INTO EMM_ZOO.TICKETGATE_TRANSACTION (TICKETGATE_ID, TICKETGATETYPE_ID, TICKETGATE_DATE, TICKETGATE_NUM, TICKETGATE_PRICE) VALUES (DEFAULT, {$ticket_id}, CURRENT DATE, {$num[$i]}" . "," . $ticket_price * $num[$i] . ");"; //echo $insert; $rc = db2_exec($conn, $insert); // ตรงนี้ error ยังไม่เสร็จ if ($rc) { // echo "Insert successfully!!"; echo "<script>alert('{$num[$i]} {$type[$i]} ticket has sole in price " . $ticket_price * $num[$i] . "');window.location='GateTricket.php';</script>"; } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } // finish all query statement db2_free_stmt($stmt); } db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function uploadPubMedInfo() { if (!isset($_SESSION['current_user_name']) && !isset($_COOKIE[$cookie_name])) { header('Location: ../login.php'); exit; } else { //print_r($_POST); if (isset($_POST)) { $PUBMEDID = $_POST['PUBMEDID']; $Title = $_POST['Title']; $Year = $_POST['Year']; $Author = $_POST['Author']; $Journal = $_POST['Journal']; $ResearchType = $_POST['ResearchType']; $data = array($PUBMEDID, $Title, $Year, $Author, $Journal, $ResearchType); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } require_once '/var/www/html/app/model/connect.php'; $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = 'INSERT INTO EMM_ZOO.PUBMEDREFERENCES (PUBMEDID,TITLE,YEAR,AUTHOR,JOURNAL,RESEARCH_TYPE) VALUES (?,?,?,?,?,?);'; //echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to Biological information"; echo "Successfully added"; header('Location: PubMedRef.php'); exit; } else { $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } } }
function insertSaniEquip() { //print_r($_POST); if (isset($_POST)) { $equipid = $_POST['equipid']; $equipname = $_POST['equipname']; $equiptype = $_POST['equiptype']; $status = 'Available'; // an array that want to insert this can be multiple array at the time. $data = array($equipid, $equipname, $equiptype, $status); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { $sql = 'INSERT INTO EMM_ZOO.SANITATION_EQUIP (EQUIPID, EQUIPNAME, EQUIPTYPE, STATUS) VALUES (?,?,?,?);'; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to sanitation equipment"; //echo "Successfully added"; echo "<script>"; echo "alert('Added successfully')"; echo "</script>"; header('Location: addEquipHome.php'); exit; } else { $resultMessage = "Failed to query into database"; echo "<script>"; echo "alert('Failed to query into database')"; echo "</script>"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function carReturn() { $up = "Y"; if (isset($_POST)) { $empID = $_POST['empID']; $carID = $_POST['carID']; // an array that want to insert this can be multiple array at the time. // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $delete = "DELETE FROM EMM_ZOO.CARS_BORROWED WHERE EMM_ZOO.CARS_BORROWED.CARID = '" . $carID . "';"; $update = "UPDATE EMM_ZOO.CARS SET EMM_ZOO.CARS.AVAILABLE = '" . $up . "' WHERE EMM_ZOO.CARS.CARID = '" . $carID . "';"; $guanteen = "SELECT AVAILABLE FROM EMM_ZOO.CARS WHERE EMM_ZOO.CARS.CARID = '" . $carID . "';"; $ans = dbQuery($conn, $guanteen); $row = dbFetchArray($conn, $ans); if ($row[0] == 'Y' || $row[0] == 'y') { echo "<script type='text/javascript'>alert(' This car has not been borrowed yet');</script>"; header("Refresh:0; url=returnCar.php"); } else { $result = db2_exec($conn, $delete); if ($result) { $result2 = db2_exec($conn, $update); if ($result2) { echo "<script type='text/javascript'>alert('CAR RETURNED');</script>"; header("Refresh:0; url=returnCar.php"); } else { echo "<script type='text/javascript'>alert('You need to fill all input OR Your employeeID,carID does not exist');</script>"; header("Refresh:0; url=TransportationEmployee.php"); } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } db2_free_stmt($result); db2_free_stmt($result2); } db2_free_stmt($ans); db2_free_stmt($row); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function CharacterUpload() { if (isset($_POST)) { $AnimalID = $_POST['AnimalID']; $RecordID = $_POST['RecordID']; $EmpID = $_POST['EmpID']; $Height = $_POST['Height']; $Weight = $_POST['Weight']; $Length = $_POST['Length']; $Pattern = $_POST['Pattern']; $BodyTemperature = $_POST['BodyTemperature']; // an array that want to insert this can be multiple array at the time. $data = array($AnimalID, $RecordID, $EmpID, $Height, $Weight, $Length, $Pattern, $BodyTemperature); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = "INSERT INTO EMM_ZOO.ANIMAL_CHARACTORISTICS (ANIMALID, RECORDID, EMPID, HEIGHT, WEIGHT, LENGTH, PATTERN, BODYTEMP) VALUES (?,?,?,?,?,?,?,?);"; echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to Biological information"; echo "Successfully added"; header('Location: AnimalCharacter.php'); exit; } else { $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error()); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function uploadPromotion() { if (isset($_POST)) { $PromoName = $_POST['PromoName']; $PromoID = $_POST['PromoID']; $ProStart = $_POST['ProStart']; $ProEnd = $_POST['ProEnd']; $ProductNO = $_POST['ProductNO']; $PromType = $_POST['PromType']; // an array that want to insert this can be multiple array at the time. $data = array($PromoID, $ProStart, $ProEnd, $ProductNO, $PromType, $PromoName); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = 'INSERT INTO EMM_ZOO.PROMOTION(PROMOID, PROSTART, PROEND, PRODUCTNO, PROTYPE,PROMONAME) VALUES (?,?,?,?,?,?);'; echo $sql; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to parking reserved"; //echo "Successfully added"; header("Refresh:0; url=promotion.php"); // you must refresh page after insert, define specific page you want to refresh , header("Refresh:0"); it mean refresh current page } else { $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function ordernewfood() { if (isset($_POST)) { $food_name = $_POST['food_name']; $food_type = $_POST['food_type']; $add_amount = $_POST['add_amount']; $price_per = $_POST['price_per']; $total = $add_amount * $price_per; $username = $_POST['username']; $data = array($food_name, $food_type, $add_amount, $price_per); } $conn = dbConnect(); if ($conn) { $conn = dbConnect(); $sql0 = "INSERT INTO EMM_ZOO.FM_STOCK (FOODID,FOODNAME,TYPE,AMOUNT,PERAMOUNT) VALUES(DEFAULT,'{$food_name}','{$food_type}',{$add_amount}, {$price_per})"; $ca = db2_exec($conn, $sql0); if ($ca) { $resultMessage = 1; return $resultMessage; } else { $resultMessage = 0; return $resultMessage; } $sql1 = "SELECT FOODID FROM EMM_ZOO.FM_STOCK WHERE FOODNAME = '{$food_name}';"; $stm = dbQuery($conn, $sql); while ($row = dbFetchArray($conn, $stm)) { $foodidx = $row[0]; } $sql2 = "INSERT INTO EMM_ZOO.FOODANIMAL_EXPENSE (FOODEXPENSE_ID,DATES,FOODID,COST,RESPONPERSONID) VALUES (DEFAULT,current date,{$foodidx},{$total},{$username});"; $sc = db2_exec($conn, $sql2); if ($sc) { $resultMessage = 1; return $resultMessage; header('Location: FoodStock.php#order_new'); exit; } else { $resultMessage = 0; return $resultMessage; } db2_free_stmt($stmt); db2_close($conn); } }
function other() { if (isset($_POST)) { $type = $_POST['type']; $empID = $_POST['empID']; $start = $_POST['start']; $end = $_POST['end']; // an array that want to insert this can be multiple array at the time. $data = array($empID, $type, $start, $end); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = 'INSERT INTO EMM_ZOO.VEHICLE_BORROW(BORROWVEHICLEID,VEHICLE_TYPE,STARTDATE,ENDDATE) VALUES (?,?,?,?);'; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added to parking reserved"; //echo "Successfully added"; header("Refresh:0; url=tey.php"); // you must refresh page after insert, define specific page you want to refresh , header("Refresh:0"); it mean refresh current page } else { $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function addempani() { echo "addempani() called"; if (isset($_POST)) { $empid = $_POST['empid']; $aniid = $_POST['aniid']; $start = $_POST['std']; $end = $_POST['end']; // an array that want to insert this can be multiple array at the time. $data = array($empid, $aniid, $start, $end); // print var_dump to display an array of variable data with type that prepare for query. //echo var_dump($data) ."<br>"; } // define $conn from model $conn = dbConnect(); if ($conn) { // DEFAULT if you set generated as identify with specifier this will auto increament for integer. $sql = 'INSERT INTO EMM_ZOO.EMPFORANIMAL (EMPID, ANIMALID, EMPCARESTART, EMPCAREEND) VALUES (?,?,?,?);'; // prepare statement using connection and sql $stmt = db2_prepare($conn, $sql); // If statement is valid execute it to db2 if ($stmt) { //echo "SQL is valid<br>"; $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successfully added employee responsibility"; // header("Refresh:0; url=index.php"); // you must refresh page after insert, define specific page you want to refresh , header("Refresh:0"); it mean refresh current page } else { $resultMessage = "Failed to query into database"; } } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } db2_free_stmt($stmt); // db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function editEmployeeInfo() { if (isset($_POST)) { $empid = $_POST['update_empid']; $jobid = $_POST['edit_jobid']; $firstname = $_POST['edit_firstname']; $lastname = $_POST['edit_lastname']; $birthdate = $_POST['edit_birthdate']; $sex = $_POST['edit_sex']; $nationality = $_POST['edit_nationality']; $hiredate = $_POST['edit_hiredate']; $address = $_POST['edit_address']; $email = $_POST['edit_email']; $phone = $_POST['edit_phone']; $salary = $_POST['edit_salary']; $bonus = $_POST['edit_bonus']; } $conn = dbConnect(); if ($conn) { $sql = "UPDATE EMM_ZOO.EMPLOYEE SET EMPID = '{$empid}', JOBID = '{$jobid}', FIRSTNAME = '{$firstname}', LASTNAME = '{$lastname}', BIRTHDATE = '{$birthdate}', SEX = '{$sex}', NATIONALITY = '{$nationality}', HIREDATE = '{$hiredate}', ADDRESS = '{$address}', EMAIL = '{$email}', PHONE = '{$phone}' , SALARY = '{$salary}', BONUS = '{$bonus}' WHERE EMPID = {$empid};"; $result = db2_exec($conn, $sql); if ($result) { echo "<script>"; echo "alert('Updated successfully')"; echo "</script>"; header('Location: sani_emp.php#emp_list'); exit; } else { $resultMessage = 0; echo "<script>"; echo "alert('Updated unsuccessfully')"; echo "</script>"; return $resultMessage; } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg(); } }
function addRound() { if (isset($_POST)) { $showID = $_POST['showID']; $roundID = $_POST['roundID']; $starttime = $_POST['starttime']; $endtime = $_POST['endtime']; $showdate = $_POST['showdate']; } $conn = dbConnect(); if ($conn) { $insert = "INSERT INTO EMM_ZOO.SHOW_TIMETABLE(SHOWID, ROUNDID, STARTTIME, ENDTIME, DATES) values({$showID}, {$roundID}, '{$starttime}', '{$endtime}', '{$showdate}');"; //$insert = "INSERT INTO EMM_ZOO.SHOW_TIMETABLE(SHOWID, ROUNDID, STARTTIME, ENDTIME, DATES) values(1, 3, '16:00:00', '16:30:00', '11/12/2015');"; $rc = db2_exec($conn, $insert); if ($rc) { echo "Insert Successful"; } else { die('Critical error: ' . db2_stmt_error($rc)); } $sql = "SELECT * from EMM_ZOO.SHOW WHERE SHOWID = {$showID};"; $stmt = db2_prepare($conn, $sql); $result = db2_execute($stmt); while ($row = db2_fetch_assoc($stmt)) { $zone = $row['BUILDINGID']; $name = $row['SHOWNAME']; } $insert = "INSERT INTO EMM_ZOO.SHOW_TICKET(SHOWID, STARTTIME, ENDTIME, DATES, SHOWNAME, ZONEID) values({$showID}, '{$starttime}', '{$endtime}', '{$showdate}', '{$name}', {$zone});"; $rc = db2_exec($conn, $insert); if ($rc) { echo "Insert Successful"; } else { die('Critical error: ' . db2_stmt_error($rc)); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function addemp() { if (isset($_POST)) { $id = $_POST['id']; $fn = $_POST['fn']; $ln = $_POST['ln']; $add = $_POST['add']; $bdate = $_POST['bdate']; $sex = $_POST['sex']; $nat = $_POST['nat']; $email = $_POST['email']; $phone = $_POST['phone']; $hdate = $_POST['hdate']; $salary = $_POST['salary']; $bonus = $_POST['bonus']; $jobid = $_POST['jobid']; $data = array($id, $jobid, $fn, $ln, $bdate, $sex, $nat, $hdate, $add, $email, $phone, $salary, $bonus); } $conn = dbConnect(); if ($conn) { $sql = 'INSERT INTO EMM_ZOO.EMPLOYEE(EMPID, JOBID, FIRSTNAME, LASTNAME, BIRTHDATE, SEX, NATIONALITY, HIREDATE, ADDRESS, EMAIL, PHONE, SALARY, BONUS) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?);'; $stmt = db2_prepare($conn, $sql); if ($stmt) { $result = db2_execute($stmt, $data); if ($result) { $resultMessage = "Successful responsibility"; } else { $resultMessage = "Failed to query into database"; } } else { die('Critical error:' . db2_stmt_error($stmt)); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function exportfood() { if (isset($_POST)) { $food_id = $_POST['food_id2']; $food_name = $_POST['food_name2']; $food_type = $_POST['food_type2']; $out_amount = $_POST['out_amount']; $username = $_SESSION['current_user_name']; } $conn = dbConnect(); if ($conn) { $sql0 = "SELECT AMOUNT FROM EMM_ZOO.FM_STOCK WHERE FOODID = {$food_id};"; $stm = dbQuery($conn, $sql0); while ($row = dbFetchArray($conn, $stm)) { $amountx = $row[0]; } $amount_now = $amountx - $out_amount; if ($amount_now > 0) { $sql1 = "UPDATE EMM_ZOO.FM_STOCK SET AMOUNT = {$amount_now} WHERE FOODID = {$food_id};"; $cz = db2_exec($conn, $sql1); $sql2 = "INSERT INTO EMM_ZOO.FOOD_GIVE(GIVENO,FOODID,EMPID,FOODNAME,FOODTYPE,AMOUNT,GIVETIME,ANIMAL) VALUES (DEFAULT,'{$food_id}','5678','{$food_name}','{$food_type}',{$out_amount},NULL,NULL);"; $cb = db2_exec($conn, $sql2); if ($cb && $cz) { $resultMessage = 1; return $resultMessage; header('Location: FoodStock.php#food_list'); } else { $resultMessage = 0; return $resultMessage; } db2_free_stmt($stmt); db2_close($conn); } else { echo "<script language='javascript'>alert('Not enough food!');</script>"; } } }
function addRound() { if (isset($_POST)) { $showID = $_POST['showID']; $roundID = $_POST['roundID']; $starttime = $_POST['starttime']; $endtime = $_POST['endtime']; $showdate = $_POST['showdate']; } $conn = dbConnect(); if ($conn) { //$insert = "Update"; $rc = db2_exec($conn, $insert); if ($rc) { echo "Insert Successful"; } else { die('Critical error: ' . db2_stmt_error($rc)); } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function updateTicket() { // connect db=> stmt sql => insert => refresh page if (isset($_POST)) { $type = $_POST['type']; } // start connect db $conn = dbConnect(); if ($conn) { //Part one select data from tickettype $sql = "SELECT * FROM EMM_ZOO.TICKETTRANS_TYPE WHERE TRANSTYPE_NAME = '{$type}';"; //echo $sql; $stmt = db2_prepare($conn, $sql); $result = db2_execute($stmt); while ($row = db2_fetch_assoc($stmt)) { $tran_price = $row['TRANSTYPE_PRICE']; $tran_type = $row['TRANSTYPE_NAME']; $tran_id = $row['TRANSTYPE_ID']; // printf ("%-5d %-16s %-32d\n", // $tran_price, $tran_type, $tran_id); } $insert = " INSERT INTO EMM_ZOO.TICKETTRANS_TRANSACTION (TICKETTRANS_ID, VEHICLETRANS_ID, TICKETTRANS_DATE , TICKETTRANS_TIMEIN ,TICKETTRANS_TIMEOUT) VALUES (DEFAULT, '{$tran_id}',CURRENT DATE , NULL, CURRENT TIME);"; $rc = db2_exec($conn, $insert); if ($rc) { echo "<script>alert('1 {$tran_type} has rent');window.location='TranspotationTricket.php';</script>"; } else { // If statement is error why see the code die('Critical error:' . db2_stmt_error($stmt)); } // finish all query statement db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
function addEmp2() { if (isset($_POST)) { $EmpID = $_POST['employeeAdd']; // an array that want to insert this can be multiple array at the time. } $conn = dbConnect(); if ($conn) { $sql = "INSERT INTO EMM_ZOO.MAINTEGERAINPERSON (MPSNO, EMPID, REQUESTID) VALUES ({$EmpID}, {$EmpID} ,0);"; //$sql2 = 'INSERT INTO EMM_ZOO.EMP_SANI (EMPID) VALUES (?);'; //echo $sql; // prepare statement using connection and sql // If statement is valid execute it to db2 //echo "SQL is valid<br>"; $result = db2_exec($conn, $sql); if ($result) { $resultMessage = "Successfully added to maintainance personel"; //echo "Successfully added"; echo "<script>"; echo "alert('Added successfully')"; echo "</script>"; header("Refresh:0; url=team.php"); exit; } else { $resultMessage = "Failed to query into database"; echo "<script>"; echo "alert('Failed to query into database')"; echo "</script>"; header("Refresh:0; url=team.php"); } db2_free_stmt($result); db2_close($conn); } else { echo db2_conn_errormsg(); } }
</div> <?php // include (dirname(__FILE__).'/app/model/connect.php'); require_once '../model/connect.php'; if ($conn) { $sql = "SELECT DISTINCT ea.empid, e.firstname, e.lastname, j.jobtype\n FROM EMM_ZOO.EMPFORANIMAL as ea, EMM_ZOO.EMPLOYEE as e, EMM_ZOO.JOB as j\n WHERE ea.empid = e.empid and e.jobid = j.jobid;"; $stmt = dbQuery($conn, $sql); if ($stmt == FALSE) { die('Critical error: ' . db2_stmt_error($stmt)); } echo "<table id='aniinfo' class='display responsive' cellspacing='0' width='100%' role='grid'>\n"; echo "<thead>\n <tr>\n <th>FIRSTNAME</th>\n <th>LASTNAME</th>\n <th>JOB</th>\n </tr>\n </thead>"; echo "<tbody>"; while ($row = dbFetchArray($conn, $stmt)) { echo "\t<tr>\n \n <td align=\"center\">{$row['1']}</td>\n <td align=\"center\">{$row['2']}</td>\n <td align=\"center\">{$row['3']}</td>\n </tr>\n"; } echo "</tbody>"; echo "</table>\n"; db2_free_stmt($stmt); db2_close($conn); } else { echo "Connection failed" . db2_conn_errormsg($conn); } ?> </body> </html>