cafe24 Server

FTP Server

DB MySQL Server

insert example

insert sensor_heartrate ( user, wmac, heart, train, status, ctime ) values ( 1, '00:00:00:00:00:33', 100, 3, "running", now());

<?php
$conn = mysqli_connect('localhost', 'cherrychance', 'Winning22!', 'cherrychance');
switch($_GET['mode']){
    case 'insert':
		$sql = "INSERT INTO sensor_heartrate ( user, wmac, heart, train, status, sec, ctime ) VALUES (".($_POST['user']).", '".($_POST['wmac'])."', ".($_POST['heart']).", ".($_POST['train']).", '".($_POST['status'])."', ".($_POST['sec']).", now());";
		echo $sql;
		
        $result = mysqli_query($conn, $sql);
		echo "<br>result= ".$result;
        //header("Location: list.php"); 
        break;
    case 'delete':
        mysqli_query('DELETE FROM topic WHERE id = '.mysqli_real_escape_string($_POST['id']));
        header("Location: list.php"); 
        break;
    case 'modify':
        mysqli_query('UPDATE topic SET title = "'.mysqli_real_escape_string($_POST['title']).'", description = "'.mysqli_real_escape_string($_POST['description']).'" WHERE id = '.mysqli_real_escape_string($_POST['id']));
        header("Location: list.php?id={$_POST['id']}");
        break;
}
?>

Mysql 접속

C:\Users\yc253>mysql -u cherrychance -p --host 210.114.6.202

참고사이트

blog.iotinfra.net/?p=1835

콘솔에서 mysql 서버 접속방법