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;

?>

 

 

반응형