PHP DB_CONNECT::getlink方法代码示例

<?php

/*
 * Following code will get single job details
 * A job is identified by job id (jobid)
 */
// array for JSON response
$response = array();
// check for post data
if (isset($_GET['jobid'])) {
    // include db connect class
    require_once __DIR__ . '/db_connect.php';
    // connecting to db
    $con = new DB_CONNECT();
    $jobid = safe($con->getlink(), $_GET['jobid']);
    // get a job from products table
    $result = mysqli_query($con->getlink(), "SELECT * FROM roster WHERE jobid = '{$jobid}'");
    if (!empty($result)) {
        // check for empty result
        if (mysqli_num_rows($result) > 0) {
            $row = mysqli_fetch_array($result);
            $job = array();
            $job["jobid"] = $row["jobid"];
            $job["jobstatus"] = $row["jobstatus"];
            $job["comments"] = $row["comments"];
            // user node
            $response["job"] = array();
            array_push($response["job"], $job);
            // success
            $response["success"] = 1;
            // echoing JSON response

<?php

/*
 * Following code will delete a job from table
 * A job is identified by request id (jobid)
 */
// array for JSON response
$response = array();
// check for required fields
if (isset($_POST['jobid'])) {
    // include db connect class
    require_once __DIR__ . '/db_connect.php';
    // connecting to db
    $con = new DB_CONNECT();
    $jobid = safe($con->getlink(), $_POST['jobid']);
    // mysql update row with matched jobid
    $result = mysqli_query($con->getlink(), "DELETE FROM roster WHERE jobid = '{$jobid}'");
    // check if row deleted or not
    if ($result) {
        // successfully updated
        $response["success"] = 1;
        $response["message"] = "Job successfully deleted";
        // echoing JSON response
        echo json_encode($response);
    } else {
        // no job found
        $response["success"] = 0;
        $response["message"] = "No job found";
        // echo no users JSON
        echo json_encode($response);
    }

<?php

/*
 * Following code will list all the products
 */
// array for JSON response
$response = array();
// include db connect class
require_once __DIR__ . '/db_connect.php';
// connecting to db
$con = new DB_CONNECT();
// get all products from products table
$result = mysqli_query($con->getlink(), "SELECT * FROM roster");
// check for empty result
if (mysqli_num_rows($result) > 0) {
    // looping through all results
    // jobs node
    ////////*****$response["jobs"] = array();
    //$response["jobs"] = array();
    while ($row = mysqli_fetch_array($result)) {
        // temp user array
        $job = array();
        $job["rid"] = $row["rid"];
        $job["fname"] = $row["fname"];
        $job["lname"] = $row["lname"];
        $job["mphone"] = $row["mphone"];
        $job["hphone"] = $row["hphone"];
        $job["jobid"] = $row["jobid"];
        $job["sch_start_date"] = $row["sch_start_date"];
        $job["sch_start_time"] = $row["sch_start_time"];
        $job["jobduration"] = $row["jobduration"];

<?php

/*
 * Following code will update a job information
 * A job is identified by job id (jobid)
 */
// array for JSON response
$response = array();
// check for required fields
if (isset($_POST['jobid']) && isset($_POST['jobstatus']) && isset($_POST['comments'])) {
    // include db connect class
    require_once __DIR__ . '/db_connect.php';
    // connecting to db
    $con = new DB_CONNECT();
    $jobid = safe($con->getlink(), $_POST['jobid']);
    $jobstatus = safe($con->getlink(), $_POST['jobstatus']);
    $comments = safe($con->getlink(), $_POST['comments']);
    // mysql update row with matched jobid
    $result = mysqli_query($con->getlink(), "UPDATE roster \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSET jobstatus = '{$jobstatus}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tcomments  = '{$comments}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t  WHERE jobid     = '{$jobid}'");
    // check if row inserted or not
    if ($result) {
        // successfully updated
        $response["success"] = 1;
        $response["message"] = "Job successfully updated.";
        // echoing JSON response
        echo json_encode($response);
    } else {
        //
    }
} else {
    // required field is missing

<?php

/*
 * Following code will create a new product row
 * All product details are read from HTTP Post Request
 */
// array for JSON response
$response = array();
// check for required fields
if (isset($_POST['fname']) && isset($_POST['lname']) && isset($_POST['mphone']) && isset($_POST['hphone']) && isset($_POST['jobid']) && isset($_POST['sch_start_date']) && isset($_POST['sch_start_time']) && isset($_POST['jobduration']) && isset($_POST['act_start_date']) && isset($_POST['act_start_time']) && isset($_POST['act_end_date']) && isset($_POST['act_end_time']) && isset($_POST['jobstatus']) && isset($_POST['address']) && isset($_POST['comments'])) {
    // include db connect class
    require_once __DIR__ . '/db_connect.php';
    // connecting to db
    $con = new DB_CONNECT();
    $fname = safe($con->getlink(), $_POST['fname']);
    $lname = safe($con->getlink(), $_POST['lname']);
    $mphone = safe($con->getlink(), $_POST['mphone']);
    $hphone = safe($con->getlink(), $_POST['hphone']);
    $jobid = safe($con->getlink(), $_POST['jobid']);
    $sch_start_date = safe($con->getlink(), $_POST['sch_start_date']);
    $sch_start_time = safe($con->getlink(), $_POST['sch_start_time']);
    $jobduration = safe($con->getlink(), $_POST['jobduration']);
    $act_start_date = safe($con->getlink(), $_POST['act_start_date']);
    $act_start_time = safe($con->getlink(), $_POST['act_start_time']);
    $act_end_date = safe($con->getlink(), $_POST['act_end_date']);
    $act_end_time = safe($con->getlink(), $_POST['act_end_time']);
    $jobstatus = safe($con->getlink(), $_POST['jobstatus']);
    $address = safe($con->getlink(), $_POST['address']);
    $comments = safe($con->getlink(), $_POST['comments']);
    // mysql inserting a new row
    $result = mysqli_query($con->getlink(), "INSERT INTO roster (fname, lname, mphone, hphone, jobid, sch_start_date, sch_start_time, jobduration, act_start_date, act_start_time, act_end_date, act_end_time, jobstatus, address, comments) VALUES('{$fname}','{$lname}', '{$mphone}', '{$hphone}', '{$jobid}', '{$sch_start_date}', '{$sch_start_time}', '{$jobduration}', '{$act_start_date}', '{$act_start_time}', '{$act_end_date}', '{$act_end_time}', '{$jobstatus}', '{$address}', '{$comments}')");