Backend/PHP
PHP에서 긴 문자열 처리 [EOT]
romeoh
2021. 8. 23. 09:33
반응형
SELECT 문
<?php
$conn = mysql_connect('localhost', 'server_name', 'password');
$id = 100;
$sql = <<<EOT
SELECT
NAME
, JOB
FROM TABLE
WHERE ID = $id
ORDER BY DATE ASC
EOT;
$dbdata = array();
$result = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($result)) {
$dbdata[] = $row;
}
echo json_encode($dbdata);
?>
INSERT 문
<?php
$sql = <<<END
INSERT INTO TABLE (
title
,reg_date
) VALUES (
$title
,now()
);
END;
if (!mysql_query($sql, $conn)) {
die('Error: ' . mysql_error());
}
$insert_id = mysql_insert_id();
echo $insert_id;
?>
UPDATE 문
<?php
$sql = <<<END
UPDATE TABLE SET
title = $title
,modify_date = now()
WHERE idx = $idx
END;
$result = mysql_query($sql, $conn);
echo $result;
?>
반응형