11-2-5 °Ñ¤©°Q½×ªº¤å³¹³B²zµ{¦¡
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1187
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-10-31
|
11-2-5 °Ñ¤©°Q½×ªº¤å³¹³B²zµ{¦¡
11-2-5 °Ñ¤©°Q½×ªº¤å³¹³B²zµ{¦¡
·íÂsÄýªÌ¦b¶i¤J¬Y¤@°Q½×¥DÃD¨Ãµoªí°Ñ»P°Q½×ªº·N¨£«á¡]join.php¡^¡A¨ä©Òµoªíªº¸ê®Æ´N·|°e¥æ°Ñ¤©°Q½×¤å³¹ªºµ{¦¡joinnew.php³B²z¡A¦¹µ{¦¡²Ä¤@¥ón°µªº¨Æ¬O±N°Q½×¤å³¹ªº¤º®e¼g¤J¨ìSubTitle¡]¦¸¼ÐÃD¡^¸ê®Æªí¤¤¡G- $ID=$_REQUEST["ID"];
- //³sµ²MySQL Server
- $conn = mysql_connect("localhost", "root", "12345a");
- //¿ï¾Ü¸ê®Æ®w
- mysql_select_db("BBS", $conn);
- //«ü©w´£¨ú¸ê®Æªº®Õ¹ï¦r¤¸ªí
- mysql_query("set character set big5");
- //±N³æ¤Þ¸¹¸m´«¬°Âù¤Þ¸¹
- Function chgStr($data)
- {
- $chgStr = "'" . str_replace("'", "''", $data) . "'";
- return $chgStr;
- }
- //±N¸ê®Æ¼g¤J¸ê®Æ®w
- $sql = "Insert Into SubTitle (©m¦W, Email, ¥DÃD, ¤º®e, ¥D½s¸¹, µoªí¤é´Á) Values (";
- $sql = $sql . chgStr($_REQUEST["©m¦W"]) . ",";
- $sql = $sql . chgStr($_REQUEST["Email"]) . ",";
- $sql = $sql . chgStr($_REQUEST["¥DÃD"]) . ",";
- $sql = $sql . chgStr(nl2br($_REQUEST["¤º®e"])) . ",";
- $sql = $sql . $ID . ",'";
- $sql = $sql . date("Y-m-j H:i:s") . "')";
- mysql_query($sql);
½Æ»s¥N½X ½Ð¹ï·Ó¤W¦Cªºµ{¦¡½X¡G
- µ{¦¡½X²Ä18»P23¦æ¡A¥D½s¸¹»P$ID¡G$ID´N¬O§Ú̦b°Ñ»P¥Ø«e¥DÃD°Q½×ªºµo¨¥ªí³æ©Ò¶Ç°e¥Ø«e°Q½×¥DÃDªº¡y¥D½s¸¹¡zÁôÂÃÄæ¦ìÈ¡A¨ä¥Øªº¬O¥Î¨Ó§@¬°MainTitle¡]¥D¼ÐÃD¡^»PSubTitle¡]¦¸¼ÐÃD¡^¸ê®Æªíªº¡y¥D±q¯Á¤Þ¡z¡C
- µ{¦¡½X²Ä22¦æ¡A±N°Q½×¤º®e§Q¥Îmysql_query()¨ç¼Æ¼g¤J¸ê®Æ®w¡C
¹Ï11-36 ¡y½g¼Æ¡zÄæ¦ì¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1187
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-10-31
|
§ÚÌ¥´¶}¥D¼ÐÃD¸ê®Æªín§ó·s¡u½g¼Æ¡vÄæ¦ìªº¸ê®ÆÈ¡A·íµMn¥ý§ä¥X¯S©w¥DÃDªº¸ê®Æ¿ý¹Æ¡I¦]¦¹¡A§ÚÌn¦b¶}±Ò¸ê®Æªíªº¦P®É¡A¥[¤W¡y"Where ¥D½s¸¹¡×" . $ID¡z¤~¦æ¡]ID´N¬Oµo¨¥ªí³æ¤¤ªºÁôÂÃÄæ¦ìÈ¡^¡A¦pªG§Ų́S¦³¥[¤W³oÓ±ø¥ó¦¡¡A«hMainTitle¡]¥D¼ÐÃD¡^¸ê®Æªí¤¤©Ò¦³¸ê®Æ¿ýªº¡y½g¼Æ¡zÄæ¦ì³£·|³Q§ó·s¸ê®Æ³á¡I- //§ó·s¦^Âнg¼Æ
- $SQL = "Update MainTitle set ½g¼Æ=½g¼Æ+1 Where ¥D½s¸¹=" . $ID;
- mysql_query($SQL);
½Æ»s¥N½X joinnew.php- <?
- $ID=$_REQUEST["ID"];
- //³sµ²MySQL Server
- $conn = mysql_connect("localhost", "root", "12345a");
- //¿ï¾Ü¸ê®Æ®w
- mysql_select_db("BBS", $conn);
- //«ü©w´£¨ú¸ê®Æªº®Õ¹ï¦r¤¸ªí
- mysql_query("set character set big5");
- //±N³æ¤Þ¸¹¸m´«¬°Âù¤Þ¸¹
- Function chgStr($data)
- {
- $chgStr = "'" . str_replace("'", "''", $data) . "'";
- return $chgStr;
- }
- //±N¸ê®Æ¼g¤J¸ê®Æ®w
- $sql = "Insert Into SubTitle (©m¦W, Email, ¥DÃD, ¤º®e, ¥D½s¸¹, µoªí¤é´Á) Values (";
- $sql = $sql . chgStr($_REQUEST["©m¦W"]) . ",";
- $sql = $sql . chgStr($_REQUEST["Email"]) . ",";
- $sql = $sql . chgStr($_REQUEST["¥DÃD"]) . ",";
- $sql = $sql . chgStr(nl2br($_REQUEST["¤º®e"])) . ",";
- $sql = $sql . $ID . ",'";
- $sql = $sql . date("Y-m-j H:i:s") . "')";
- mysql_query($sql);
- //§ó·s¦^Âнg¼Æ
- $SQL = "Update maintitle set ½g¼Æ=½g¼Æ+1 Where ¥D½s¸¹=" . $ID;
- mysql_query($SQL);
-
- header("Location: join.php?ID=" . $ID);
- ?>
½Æ»s¥N½X |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|