PHP database::get_field_from_table方法代码示例

<?php

/**
 * Created by PhpStorm.
 * User: wq
 * Date: 12/6/15
 * Time: 1:46 AM
 */
require_once '../database.php';
$email = $_POST['user_email'];
$username = $_POST['user_name'];
$tel = $_POST['user_tel'];
$card = $_POST['user_card'];
$password = $_POST['user_password'];
$succeed = true;
if ($succeed) {
    $db = new database();
    $db->connect_to_db();
    //insert
    $user_re = $db->get_field_from_table('users', 'id', 'id_card', $card);
    if (count($user_re) == 0) {
        $values = array('email' => $email, 'name' => $username, 'tel' => $tel, 'id_card' => $card, 'password' => $password);
        $db->insert_data_into_table('users', $values);
        echo "你的用户";
        echo $username;
        echo "已成功注册！";
    } else {
        echo "注册失败！";
    }
}

<?php

/**
 * Created by PhpStorm.
 * User: whx
 * Date: 2015/12/9
 * Time: 20:25
 */
require_once "../database.php";
$conn = new database();
$username = $_SESSION['username'];
$array = array("name" => $username);
$result = $conn->get_field_from_table("users", "id", $array);
echo $result[0]['id'];

/**
 * Created by PhpStorm.
 * User: whx
 * Date: 2015/12/5
 * Time: 10:40
 */
require_once "../database.php";
$province = $_GET['province'];
$city = $_GET['city'];
$hospital = $_GET['hospital'];
//$keshi = $_GET['keshi'];
$conn = new database();
if ($province != null && strcmp($province, "") != 0) {
    $keys = array("province" => $province);
    $result = $conn->get_field_from_table("city", "name", $keys);
    echo json_encode($result);
}
if ($city != null && strcmp($city, "") != 0) {
    $keys = array('name' => $city);
    $city_id = $conn->get_field_from_table("city", "id", $keys);
    $city_id_s = $city_id[0]['id'];
    $keys1 = array('city' => $city_id_s);
    $result = $conn->get_field_from_table("hospital", "name", $keys1);
    echo json_encode($result);
}
if ($hospital != null && strcmp($hospital, "") != 0) {
    $keys = array('name' => $hospital);
    $hospital_id = $conn->get_field_from_table("hospital", "id", $keys);
    $hospital_id_s = $hospital_id[0]['id'];
    $keys1 = array('hospital_id' => $hospital_id_s);

    echo $html_error_a . "医院详细地址" . $html_error_b;
    $succeed = false;
}
if (strlen($htel) < 1) {
    echo $html_error_a . "医院联系方式" . $html_error_b;
    $succeed = false;
}
if (strlen($hintr) < 1) {
    echo $html_error_a . "医院介绍" . $html_error_b;
    $succeed = false;
}
if ($succeed) {
    $db = new database();
    //search city
    $city_id = 0;
    $city_re = $db->get_field_from_table('city', 'id', 'name', $hcity);
    if (count($city_re) == 0) {
        $valuesci = array('name' => $hcity);
        $db->insert_data_into_table('city', $valuesci);
        $city_re = $db->get_field_from_table('city', 'id', 'name', $hcity);
    }
    $city_id = $city_re[0]['id'];
    //search grade
    $grade_id = 0;
    $grade_re = $db->get_field_from_table('grade', 'id', 'detail', $hgrade);
    if (count($grade_re) == 0) {
        $valuesci = array('detail' => $hgrade);
        $db->insert_data_into_table('grade', $valuesci);
        $grade_re = $db->get_field_from_table('grade', 'id', 'detail', $hgrade);
    }
    $grade_id = $grade_re[0]['id'];

<?php 
//登录
require_once '../database.php';
$username = $_POST['username'];
$password = $_POST['password'];
$errmsg = '';
if (!empty($errmsg)) {
    if (empty($username)) {
        $errmsg = "数据输入不完整";
    }
}
if (empty($errmsg)) {
    $db = new database();
    $db->connect_to_db();
    if (mysqli_connect_errno()) {
        $errmsg = "shu ju ku lian jie shi bai!<br>\n";
    } else {
        $realusername = $db->get_field_from_table('users', 'name', 'id_card');
        $realpassword = $db->get_field_from_table('users', 'password', 'id_card');
        if ($username == $realusername && $password == $realpassword) {
            $errmsg = "deng lu cheng gong";
            session_start();
            $_SESSION['uid'] = $username;
            if (empty($_SESSION['uid'])) {
                echo "你还没有登录";
            }
        } else {
            $errmsg = "deng lu shi bai!";
        }
    }
}

    echo $html_error_a . "缺少科室名称" . $html_error_b;
    $succeed = false;
}
if (strlen($hbelong) < 1) {
    echo $html_error_a . "缺少科室所属医院" . $html_error_b;
    $succeed = false;
}
if (strlen($hintr) < 1) {
    echo $html_error_a . "缺少科室介绍" . $html_error_b;
    $succeed = false;
}
if ($succeed) {
    $db = new database();
    //search hospital
    $hospital_id = 0;
    $hos_re = $db->get_field_from_table('hospital', 'id', 'name', $hbelong);
    if (count($hos_re) == 0) {
        echo $html_error_a . "未在数据库中发现所属医院信息（请确认信息正确或先添加所属医院信息）" . $html_error_b;
        echo $html_error_return;
    } else {
        $hospital_id = $hos_re[0]['id'];
        $values = array('name' => $hname, 'hospital_id' => $hospital_id, 'intro' => $hintr);
        $db->insert_data_into_table('department', $values);
        echo $html_successa . $hname . "添加成功！" . $html_successb;
    }
} else {
    echo $html_error_return;
}
?>
 
		</body>

    echo $html_error_a . "缺少所属医院" . $html_error_b;
    $succeed = false;
}
if (strlen($office) < 1) {
    echo $html_error_a . "缺少所属科室" . $html_error_b;
    $succeed = false;
}
if (strlen($hintr) < 1) {
    echo $html_error_a . "缺少医生介绍" . $html_error_b;
    $succeed = false;
}
if ($succeed) {
    $db = new database();
    //search grade
    $grade_id = 0;
    $grade_re = $db->get_field_from_table('grade', 'id', 'detail', $hlevel);
    if (count($grade_re) == 0) {
        $valuesci = array('detail' => $hlevel);
        $db->insert_data_into_table('grade', $valuesci);
        $grade_re = $db->get_field_from_table('grade', 'id', 'detail', $hlevel);
    }
    $grade_id = $grade_re[0]['id'];
    //search major
    $major_id = 0;
    $major_re = $db->get_field_from_table('major', 'id', 'name', $hmajor);
    if (count($major_re) == 0) {
        $valuesci = array('name' => $hmajor);
        $db->insert_data_into_table('major', $valuesci);
        $major_re = $db->get_field_from_table('major', 'id', 'name', $hmajor);
    }
    $major_id = $major_re[0]['id'];

<?php

/**
 * Created by PhpStorm.
 * User: whx
 * Date: 2015/12/8
 * Time: 23:36
 */
require_once "../database.php";
$conn = new database();
$hospital = $_GET['hospital'];
//"北京大学第三医院";
$department = $_GET['department'];
//"骨科";
$keys = array('name' => $hospital);
$hospital_id = $conn->get_field_from_table("hospital", "id", $keys);
$hospital_id_s = $hospital_id[0]['id'];
$keys1 = array('name' => $department);
$department_id = $conn->get_field_from_table("department", "id", $keys1);
$department_id_s = $department_id[0]['id'];
$keys2 = array('hospital_id' => $hospital_id_s, 'department_id' => $department_id_s);
$doctor = $conn->get_field_from_table("doctor", "*", $keys2);
echo json_encode($doctor);
//echo $doctor[0]['name'];

<?php

header("Content-type: text/html; charset=utf-8");
require_once 'database.php';
$db = new database();
$values = array('name' => "GuanFuHe", 'password' => "123456");
$db->insert_data_into_table('users', $values);
$key_values = array('province' => '北京市');
print_r($key_values);
$results = $db->get_field_from_table('city', '*', $key_values);
print_r($results);