//DB¿¡ ¿¬°áÇÏ´Â ºÎºÐÀÔ´Ï´Ù. Ç×»ó ¹Ýº¹µÇ´Â ºÎºÐÀÌ´Ï ²À ¾Ï±â!!!
mysql_connect("localhost", "root", "apmsetup") or die (mysql_error());
mysql_select_db("test");
//PHP¹öÀü º¯È¿¡ µû¸¥ ¸Å°³º¯¼ö(ÆĶó¹ÌÅÍ)°ªÀ» ¹Þ¾Æº¸ÀÚ.
extract($_POST);
extract($_GET);
//º¯¼ö ¼³Á¤ÇÕ´Ï´Ù.
$tablename="test"; //Å×À̺í À̸§
//Å×ÀÌºí¿¡¼ ±ÛÀ» °¡Á®¿É´Ï´Ù.
$query = "select * from $tablename where number='$number'"; // ±Û ¹øÈ£¸¦ °¡Áö°í Á¶È¸¸¦ ÇÕ´Ï´Ù.
$result = mysql_query($query) or die (mysql_error());
$array = mysql_fetch_array($result);
//¹é½½·¡½¬ Á¦°Å, Ư¼ö¹®ÀÚ º¯È¯(HTML¿ë), °³Çà(
)ó¸® µî
$array[name] = stripslashes($array[name]);
$array[subject] = stripslashes($array[subject]);
$array[memo] = stripslashes($array[memo]);
$array[subject] = htmlspecialchars($array[subject]);
$array[memo] = htmlspecialchars($array[memo]);
$array[memo] = nl2br($array[memo]);
// Á¶È¸¼ö Ä«¿îÅÍ Áõ°¡
$query = "update $tablename set count = count + 1 where number='$number'";
mysql_query($query);
?>
º¸±â
³»¿ë º¸±â ȸéÀÔ´Ï´Ù.
|
À̸§
|
echo $array[name]; ?>
|
Á¶È¸¼ö
|
echo $array[count]; ?>
|
ÀüÀÚ¿ìÆí
|
echo $array[email]; ?>
|
ȨÆäÀÌÁö
|
echo $array[homepage]; ?>
|
if ($array[file_name1] != '') {
echo "
÷ºÎÆÄÀÏ
|
{$array[s_file_name1]}({$file_size}KB)
|
";
}
?>
Á¦¸ñ
|
echo $array[subject]; ?>
|
³»¿ë
|
echo $array[memo]; ?>
|
[¸ñ·Ï] [¾²±â] [¼öÁ¤] [»èÁ¦]
|