[PHP] mysqli

PHP MYSQLI 연결하기

$hostName="default_host";
$DBuserName="default_user";
$dbName="default_db";
$userPassword="default_pw";

// error 발생 시에 출력
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli($hostName, $DBuserName, $userPassword, $dbName) or die("db connect error");
$mysqli->query("set session character_set_connection=utf8;");
$mysqli->query("set session character_set_results=utf8;");
$mysqli->query("set session character_set_client=utf8;");

query 실행

$query = "SELECT * ,a.loginTime FROM memberHistory AS a JOIN member AS b ON a.userID = b.userID WHERE b.userID = ?";

$stmt = $mysqli->prepare($query);
$stmt->bind_param("s",$userID);
$stmt->execute();

$result = $stmt->get_result();

if ($result->num_rows === 0) {
    echo '{"result":"none"}';
} else {
    $data = array();
    while($row = $result->fetch_assoc()){
        $data[] = $row;
    }
    echo json_encode($data);
}

$stmt->close();
$mysqli->close();