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 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 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(); } } }
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 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 uploadReserve() { if ($_POST['form_token'] != $_SESSION['form_token']) { header('Location:reserved.php'); } else { //print_r($_POST); if (isset($_POST)) { $name = $_POST['reserved_name']; $resered_date = $_POST['reserved_date']; $mobile = $_POST['mobile']; $vehi_type = $_POST['type']; $quantity = $_POST['quantity']; $email = $_POST['email']; // an array that want to insert this can be multiple array at the time. $data = array($name, $resered_date, $mobile, $vehi_type, $quantity, $email); // 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.PARKRESERVETOUR (PARKRESERVENO, RESERVE_NAME, RESERVE_DATE, PHONE, VEHI_TYPE, AMOUNT, EMAIL) 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 = 1; return $resultMessage; header('Location: reserved.php#reserve_list'); exit; } else { $resultMessage = 0; return $resultMessage; } } 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 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 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 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 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); } }
/** * Executes a prepared statement. * * @param array $params OPTIONAL Values to bind to parameter placeholders. * @return bool * @throws Zend_Db_Statement_Db2_Exception */ public function _execute(array $params = null) { if (!$this->_stmt) { return false; } $retval = true; if ($params !== null) { $retval = @db2_execute($this->_stmt, $params); } else { $retval = @db2_execute($this->_stmt); } if ($retval === false) { /** * @see Zend_Db_Statement_Db2_Exception */ require_once PHP_LIBRARY_PATH . 'Zend/Db/Statement/Db2/Exception.php'; throw new Zend_Db_Statement_Db2_Exception(db2_stmt_errormsg(), db2_stmt_error()); } $this->_keys = array(); if ($field_num = $this->columnCount()) { for ($i = 0; $i < $field_num; $i++) { $name = db2_field_name($this->_stmt, $i); $this->_keys[] = $name; } } $this->_values = array(); if ($this->_keys) { $this->_values = array_fill(0, count($this->_keys), null); } return $retval; }
/** * {@inheritdoc} */ public function errorInfo() { return array(0 => db2_stmt_errormsg(), 1 => db2_stmt_error()); }
function _query($sql, $inputarr = false) { global $php_errormsg; if (isset($php_errormsg)) { $php_errormsg = ''; } $this->_error = ''; if ($inputarr) { if (is_array($sql)) { $stmtid = $sql[1]; } else { $stmtid = db2_prepare($this->_connectionID, $sql); if ($stmtid == false) { $this->_errorMsg = isset($php_errormsg) ? $php_errormsg : ''; return false; } } if (!db2_execute($stmtid, $inputarr)) { if ($this->_haserrorfunctions) { $this->_errorMsg = db2_stmt_errormsg(); $this->_errorCode = db2_stmt_error(); } return false; } } else { if (is_array($sql)) { $stmtid = $sql[1]; if (!db2_execute($stmtid)) { if ($this->_haserrorfunctions) { $this->_errorMsg = db2_stmt_errormsg(); $this->_errorCode = db2_stmt_error(); } return false; } } else { $stmtid = @db2_exec($this->_connectionID, $sql); } } $this->_lastAffectedRows = 0; if ($stmtid) { if (@db2_num_fields($stmtid) == 0) { $this->_lastAffectedRows = db2_num_rows($stmtid); $stmtid = true; } else { $this->_lastAffectedRows = 0; } if ($this->_haserrorfunctions) { $this->_errorMsg = ''; $this->_errorCode = 0; } else { $this->_errorMsg = isset($php_errormsg) ? $php_errormsg : ''; } } else { if ($this->_haserrorfunctions) { $this->_errorMsg = db2_stmt_errormsg(); $this->_errorCode = db2_stmt_error(); } else { $this->_errorMsg = isset($php_errormsg) ? $php_errormsg : ''; } } return $stmtid; }
/** * Returns a formatted error message from previous database operation. * DB2 distinguishes between statement and connnection errors so we * must check for both. * * @return string Error message with error number */ function lastError() { if (db2_stmt_error()) { return db2_stmt_error() . ': ' . db2_stmt_errormsg(); } elseif (db2_conn_error()) { return db2_conn_error() . ': ' . db2_conn_errormsg(); } return null; }
/** * Executes a prepared statement. * * @param array $params OPTIONAL Values to bind to parameter placeholders. * @return bool * @throws \Zend\Db\Statement\Db2Exception */ public function _execute(array $params = null) { if (!$this->_stmt) { return false; } $retval = true; if ($params !== null) { $retval = @db2_execute($this->_stmt, $params); } else { $retval = @db2_execute($this->_stmt); } if ($retval === false) { throw new Db2Exception(db2_stmt_errormsg(), db2_stmt_error()); } $this->_keys = array(); if ($field_num = $this->columnCount()) { for ($i = 0; $i < $field_num; $i++) { $name = db2_field_name($this->_stmt, $i); $this->_keys[] = $name; } } $this->_values = array(); if ($this->_keys) { $this->_values = array_fill(0, count($this->_keys), null); } return $retval; }
/** * Prepare sql * * @param string|null $sql * @return Statement */ public function prepare($sql = null) { if ($this->isPrepared) { throw new Exception\RuntimeException('This statement has been prepared already'); } if ($sql == null) { $sql = $this->sql; } $this->resource = db2_prepare($this->db2, $sql); if ($this->resource === false) { throw new Exception\RuntimeException(db2_stmt_errormsg(), db2_stmt_error()); } $this->isPrepared = true; return $this; }
function addShow() { if (isset($_POST)) { $showName = $_POST['showName']; $animalID = $_POST['animalID']; $staffID = $_POST['staffID']; $buildingID = $_POST['buildingID']; $seat = $_POST['seat']; $price = $_POST['price']; } $conn = dbConnect(); if ($conn) { $sql = "SELECT EMPID FROM EMM_ZOO.EMPLOYEE WHERE EMPID = " . $staffID; $stmt = db2_prepare($conn, $sql); $result = db2_execute($stmt); $count = 0; while ($row = db2_fetch_assoc($stmt)) { $count++; } if ($count <= 0) { echo "Wrong Staff ID."; } else { // Query db2_free_stmt($stmt); $sql = "SELECT ANIMALID FROM EMM_ZOO.ANIMAL WHERE ANIMALID = " . $animalID; $stmt = db2_prepare($conn, $sql); $result = db2_execute($stmt); $count = 0; while ($row = db2_fetch_assoc($stmt)) { $count++; } if ($count <= 0) { echo "Wrong Animal ID."; } else { $insert = "INSERT INTO EMM_ZOO.SHOW(SHOWID, SHOWNAME, BUILDINGID, SEAT_AMOUNT, PRICE) values(DEFAULT, '{$showName}', {$buildingID}, {$seat}, {$price});"; $rc = db2_exec($conn, $insert); if ($rc) { db2_free_stmt($stmt); $sql = "SELECT SHOWID from EMM_ZOO.SHOW;"; $stmt = db2_prepare($conn, $sql); $result = db2_execute($stmt); while ($row = db2_fetch_assoc($stmt)) { $show_showID = $row['SHOWID']; } $insert = "INSERT INTO EMM_ZOO.SHOW_ANIMAL (SHOWID, ANIMALID) VALUES ({$show_showID}, {$animalID});"; $rc = db2_exec($conn, $insert); if ($rc) { echo "Insert Successful"; } else { die('Critical error: ' . db2_stmt_error($stmt)); } $insert = "INSERT INTO EMM_ZOO.SHOW_STAFF (SHOWID, EMPID) VALUES ({$show_showID}, {$staffID});"; $rc = db2_exec($conn, $insert); if ($rc) { echo "Insert Successful"; } else { die('Critical error: ' . db2_stmt_error($stmt)); } /* $insert = "INSERT INTO EMM_ZOO.SHOW_TICKET (SHOWID, SHOWNAME, BUILDINGID) VALUES ($show_showID, '$showName', $buildingID);"; $rc=db2_exec($conn, $insert); if($rc) { echo "Insert Successful"; } else { die('Critical error: '. db2_stmt_error($stmt)); }*/ } else { } } } db2_free_stmt($stmt); db2_close($conn); } else { echo db2_conn_errormsg($conn); } }
<div class="container theme-showcase" role="main"> <div class="jumbotron" style="background-color:#FFB266;"> <h1 style="color:white">PERSONNEL</h1> <p style="color:white">We Care for Animals.</p> </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); } ?>
/** * Get the last error number * Return 0 if no error * @return integer */ public function lastErrno() { $connerr = db2_conn_error(); if ($connerr) { return $connerr; } $stmterr = db2_stmt_error(); if ($stmterr) { return $stmterr; } return 0; }