[APM] PHP와 Mysql 연동하기

0. MySQL Workbench 설치 

https://hello-bryan.tistory.com/251

Windows MySQL 5 .x 설치

 

1. php.ini 수정 

php 경로에 php.ini를 텍스트 에디터로 열어서 

;extension=mysqli → extension=mysqli 로 수정 ( ; 빼기)

 

저장후 서비스 들어가서 apache24 재시작 

2. php 파일로 connection 테스트 

$host = 'localhost';
$user = 'root';
$pw = 'password';
$dbName = 'dbname';

$conn = mysqli_connect($host, $user, $pw, $dbName);
if (mysqli_connect_errno())
{
    echo "MySQL 접속 실패". mysqli_connect_error();
    exit;
}else{
    echo "MySQL 접속 성공";
}

 

3. SELECT 

$sql = "SELECT * FROM tb_user ORDER BY userId DESC";
echo "$sql<br/>";
$result = mysqli_query($conn, $sql);
var_dump($result->num_rows);

while($row = mysqli_fetch_array($result)) {
    echo $row['userId'].':'.$row['userName'].'<br/>';
}

4. INSERT 

$sql  = "INSERT INTO tb_user (userId,userName) VALUES ('$id','$name')";
$result = mysqli_query($conn, $sql);
if($result === false){
    echo mysqli_error($conn);
}else{
    echo "입력성공<br/>";
}

5. UPDATE 

$servername = "localhost";
$username = "root";
$password = "passwd";
$dbname = "dbName";

// Create connection
$mysqli = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($mysqli->connect_error) {
  die("Connection failed: " . $mysqli->connect_error);
}

// sql to update a record
$sql = "UPDATE tb_user set userName = '관리자님' WHERE idx=0";

if ($mysqli->query($sql) === TRUE) {
  echo $mysqli->affected_rows."건 업데이트 되었습니다.";
} else {
  echo "Error updated record: " . $mysqli->error;
}

$mysqli->close();

6. DELETE

$sql = "DELETE FROM tb_user WHERE userId = 'hello' ";
echo "$sql<br/>";
$result = mysqli_query($conn, $sql);
var_dump($result->num_rows);

while($row = mysqli_fetch_array($result)) {
    echo $row['userId'].':'.$row['userName'].'<br/>';
}