PHP db2_stmt_error函数代码示例

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);
    }
}