PHP - MySQL 접속

[prepared statement 방식]

$dbserver = "localhost";
$dbuser = "username";
$dbpasswd = "userpasswd";
$dbname = "mydb";

$mysqli = new mysqli($dbserver, $dbuser, $dbpasswd, $dbname);

if (mysqli_connect_errno()) {
    die("Connection failed: " . $conn->connect_error);
}



$sql = "select * from board where idx = ?";

$stmt = $__mysqli->stmt_init();
$stmt = $__mysqli->prepare($sql);

$stmt->bind_param("ss", $user_id, $user_passwd);

$stmt->execute();

$result = $stmt->get_result();


while ($data = $result->fetch_assoc()) {
    echo $data['title'];
}

 

 

 

 

 

 

참고: 

https://opentutorials.org/course/3167/19586

PHP와 MySQL의 연동과 SELECT - 생활코딩

http://www.fun25.co.kr/blog/php-mysqli-simple-sample

[PHP] mysqli prepared statement 간단한 샘플 | 퍼니오 호스팅