|
| Q&A | |
| Áú¹®°ú ´äº¯ °Ô½ÃÆÇÀÔ´Ï´Ù ¸ð¸£¸é ¹°¾îº¸°í ¾Ë¸é °¡¸£ÃÄÁÖ°í. °£´ÜÇÏÁÒ? :) |
|
![]() |
| ![]() |
| Ç÷¡½¬¿¡¼ DB ¹Þ¾Æ¿À±â | 671 views , 6 Comments |
| kaistac.info [+] |
|
| ¸·È÷´Â ºÎºÐÀÌ ÀÖ¾î Áú¹®µå¸³´Ï´Ù. °ø°³Ãß÷ ÇÁ·Î±×·¥À» ¸¸µé°í Àִµ¥¿ä. PHP, MYSQL 5.x¸¦ ¾²°í ÀÖ±¸¿ä. ´ç÷ÀÚ µ¥ÀÌÅ͵éÀ» Ç÷¡½¬¿¡¼ °¡Á®¿À°Ô ÇÒ·Á¸é ¾î¶»°Ô ÇØ¾ßµÇ´ÂÁö¿ä? ±×³É php³»¿¡¼¸¸ »Ñ·ÁÁÖ´Ï Ç¥ÇöÀÇ ÇѰ谡 À־ä¤Ð ´äº¯ ºÎʵ叱²²¿ä~ |
| preview viewsource copy |
µ¥ÀÌÅͺ£À̽º "); $SEL_DB=@mysql_select_db("bmcom",$DB_CONN) or die("µ¥ÀÌÅͺ£À̽º"); $result=mysql_query("select *from event_member_test where cid=1 and draw<8388607 order by draw asc;"); echo mysql_error(); $i=1; while($row=mysql_fetch_array($result)) { $list[$i]=$row; $i++; } ?> =$list[1]["name"]?> //À̸§ =substr($list[1]["jumin1"],0,6)?> //ÁֹιøÈ£ ¾ÕÀÚ¸® =cutstr($list[1]["address"],20,"...") ?> //ÁÖ¼Ò |
|
|||||
| Posted at 2008/7/14, 2:45 pm |
°á°úÀûÀ¸·Î´Â Ç÷¡½Ã¿¡¼ PHP¸¦ ½ÇÇà½Ã۰í PHP¿¡¼´Â ÇØ´ç°ªÀ» ȸ鿡 »Ñ·ÁÁÖ´Â °úÁ¤ÀÌ ÇÊ¿äÇÕ´Ï´Ù.
(&º¯¼ö=°ª& Çü½ÄÀ¸·Î ³ªÅ¸³ª¸é µË´Ï´Ù.)
´ÙÀ½ ¼Ò½º´Â Ç÷¡½Ã(AS2)¿¡¼ POST·Î ƯÁ¤ÇÑ °ªÀ» PHP·Î Àü¼ÛÇϰí ÇØ´ç °ªÀÌ Àü´ÞµÇ¾úÀ» ¶§, PHP¿¡¼ DB¸¦ ½ÇÇà, °ªÀ» ºÒ·¯¿Í¼
echo·Î °ªÀ» »Ñ·ÁÁÖ°í, ±× °ªÀ» Ç÷¡½Ã¿¡¼ ºÒ·¯¿É´Ï´Ù. (´«À¸·Î´Â ¾È º¸ÀÌÁö¸¸, È¸é µÚÂÊ¿¡¼ ÀϾ´Â °úÁ¤ÀÔ´Ï´Ù.)
----- flash -----
var res_name:String = new String();
var res_jumin:String = new String();
var res_addr:String = new String();
// °á°ú¸¦ ÀúÀåÇÒ ¿ÀºêÁ§Æ® »ý¼º
var get_result:LoadVars = new LoadVars();
// php¿¡¼ °á°ú°¡ ·ÎµùµÇ¸é
get_result.onLoad = function(success:Boolean) {
if (success) { // ¼º°øÇßÀ¸¸é
res_name = get_result.result_name;
res_jumin = get_result.result_jumin;
res_addr = get_result.result_addr;
trace("À̸§ : "+res_name);
trace("Áֹεî·Ï¹øÈ£ : "+res_jumin);
trace("ÁÖ¼Ò : "+res_addr);
} else { // ½ÇÆÐÇßÀ¸¸é
trace("°ªÀ» ºÒ·¯¿ÀÁö ¸øÇß½À´Ï´Ù.");
}
};
// °á°ú¸¦ ºÒ·¯¿Ã ¿ÀºêÁ§Æ®¸¦ »ý¼º
var send_flash:LoadVars = new LoadVars();
// ¾ÈÀüÀ» À§Çؼ 02.php¿¡ POST·Î flash_val º¯¼ö¿¡ getResult °ªÀ» º¸³½´Ù.
send_flash.flash_val = "getResult";
send_flash.sendAndLoad("02.php", get_result, "POST");
----- PHP -----
<?php
// ¸¸¾à POST·Î flash_val º¯¼ö¿¡ getResult¶ó´Â °ªÀÌ ÀÖ´Ù¸é
if ($_POST['flash_val'] == "getResult") {
/* DB¿¡¼ Á¤º¸ ºÒ·¯¿Í¼ $list¿¡ º¸Á¸ ÇÏ´Â ÄÚµå */
//À̸§
echo "&result_name=".$list[1]["name"]."&";
//ÁֹιøÈ£ ¾ÕÀÚ¸®
echo "&result_jumin=".substr($list[1]["jumin1"],0,6)."&";
//ÁÖ¼Ò
echo "&result_addr=".cutstr($list[1]["address"],20,"...")."&";
}
?>
-----
Ç÷¡½Ã¿¡¼´Â res_name, res_jumin, res_addr¿¡ °¢°¢ÀÇ °ªÀÌ µé¾î°©´Ï´Ù.
±×·³, ¼ö°íÇϼ¼¿ä.