Example #1
0
<?php

require_once dirname(__FILE__) . '/../function/func_transport.php';
echo '<pre>';
print_r($_POST);
echo '</pre>';
$code_transport = $_POST['code_transport'];
$name_transport = $_POST['name_transport'];
$tel_transport = $_POST['tel_transport'];
$address_transport = $_POST['address_transport'];
if (!checkDuplicateTranport($name_transport, $code_transport)) {
    $transportID = addTransport($code_transport, $name_transport, $tel_transport, $address_transport);
    if ($transportID > 0) {
        header("location: ../transport.php?action=addTransportCompleted");
    } else {
        header("location: ../transport.php?action=addTransportError");
    }
} else {
    header("location: ../transport.php?action=addTransportDuplicateError");
}
Example #2
0
$transportSubtypeId = $params["transportSubtypeId"];
$id;
$con1 = oci_connect('purchases', 'PURCHASES', '192.168.50.52/ORCLWORK', 'AL32UTF8');
if (!$con1) {
    $err = oci_error($con1);
    var_dump($con1);
    print "Error code = " . $err[code];
    print "Error message = " . $err[message];
    print "Error position = " . $err[offset];
    print "SQL Statement = " . $err[sqltext];
    oci_close($con1);
    die('Не удалось подключиться к БД');
}
switch ($action) {
    case "add":
        addTransport();
        break;
    case "edit":
        editTransport();
        break;
}
function addTransport()
{
    global $con1;
    global $id;
    global $departmentId;
    global $transportTypeId;
    global $transportSubtypeId;
    global $model;
    global $gid;
    $query = "SELECT sq_request_all.nextval FROM DUAL";