ȸ¿ø°¡ÀԡžÆÀ̵ð/ºñ¹øã±â
ȨÀ¸·Î

5¹øÀÇ SQLÀ» ¾èº¸Áö ¸¶¶ó
13³â Àü
OOO ùȭ¸éÀÇ ÅÇ Ãֽűۿ¡´Â ÅÇ¿¡ »ç¿ëµÇ´Â 5°³ÀÇ °Ô½ÃÆÇ À̸§À» ¾ò±â À§Çؼ­

5¹øÀÇ SQLÀ» ¼öÇà ÇÏ°Ô µÇ¾î ÀÖ½À´Ï´Ù. ÀÌ·± ÅÇÀÌ 3°³ »ç¿ëµÇ¾úÀ¸´Ï, ±âº»À¸·Î

1ÆäÀÌÁö¿¡ 15°³ÀÇ SQLÀÌ »ç¿ëµÈ °ÍÀÌÁÒ. ÀÌ°ÍÀ» 3¹ø¸¸ Çϸé È¿°ú°¡ ¾î´ÀÁ¤µµ Àϱî¿ä?



Çغ¸´Ï±î ¿µÇâÀÌ ¾ÆÁÖ ¾ÆÁÖ ¸¹ÀÌ Å®´Ï´Ù. ¤¾¤¾


12°³ÀÇ SQLÀº Á¢¼Ó·®ÀÌ ¸¹Àº »çÀÌÆ®¿¡¼­´Â ¼ø°£ÀûÀÎ ÆøźÀÌ µÉ ¼ö ÀÖ½À´Ï´Ù.


(¿øº»)

// ¾Æ·¡ ºÎºÐ Å×À̺í¸í
$my_table1 = 'myinfo';
$my_table2 = 'btr';
$my_table3 = 'bed';
$my_table4 = 'bed_gh';
$my_table5 = 'eat';



$sql1 = "select bo_subject from $g4[board_table] where bo_table='$my_table1'";
$sql2 = "select bo_subject from $g4[board_table] where bo_table='$my_table2'";
$sql3 = "select bo_subject from $g4[board_table] where bo_table='$my_table3'";
$sql4 = "select bo_subject from $g4[board_table] where bo_table='$my_table4'";
$sql5 = "select bo_subject from $g4[board_table] where bo_table='$my_table5'";
$bo_name_sql1 = sql_query($sql1);
$bo_name1 = sql_fetch_array($bo_name_sql1);
$bo_name_sql2 = sql_query($sql2);
$bo_name2 = sql_fetch_array($bo_name_sql2);
$bo_name_sql3 = sql_query($sql3);
$bo_name3 = sql_fetch_array($bo_name_sql3);
$bo_name_sql4 = sql_query($sql4);
$bo_name4 = sql_fetch_array($bo_name_sql4);
$bo_name_sql5 = sql_query($sql5);
$bo_name5 = sql_fetch_array($bo_name_sql5);




(¼öÁ¤)



$sql = " select bo_table, bo_subject from $g4[board_table] where bo_table in('$my_table1','$my_table2','$my_table3','$my_table4','$my_table5') ";
$result = sql_query($sql);
$arr = array();
while ($row = sql_fetch_array($result))
{
    $bo_table = $row[bo_table];
    $arr[$bo_table] = $row[bo_subject];
};

$bo_name1[bo_subject] = $arr[$my_table1];

$bo_name2[bo_subject] = $arr[$my_table2];
$bo_name3[bo_subject] = $arr[$my_table3];
$bo_name4[bo_subject] = $arr[$my_table4];
$bo_name5[bo_subject] = $arr[$my_table5];
ÃßõÃßõ : 239 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
2,885
input ÀÔ·Â ÇÊµå ¾ÕµÚ °ø¹é ½Ç½Ã°£ Á¦°Å
2,884
Placeholder Æ÷Ä¿½º½Ã °¨Ãß±â
2,883
MySQL Áߺ¹µÈ µ¥ÀÌÅ͸¦ »èÁ¦
2,882
MySQL Áߺ¹ µ¥ÀÌÅÍ È®ÀÎ
2,881
sessionStorage.getItem ¿Í sessionStorage.setItem
2,880
Á¦ÀÌÄõ¸® ·£´ýÀ¸·Î ¹è°æ»ö º¯°æ
2,879
preg match¿¡ °üÇÑ Á¤±Ô½Ä
2,878
Stream an audio file with MediaPlayer ¿Àµð¿À ÆÄÀÏ ½ºÆ®¸®¹Ö Çϱâ
2,877
Audio Streaming PHP Code
2,876
PHP $ SERVER ȯ°æ º¯¼ö Á¤¸®
2,875
Vimeo (ºñ¸Þ¿À) API ¸¦ »ç¿ëÇÏ¿© Ç÷¹À̾î ÄÁÆ®·ÑÇϱâ
2,874
iframe »ç¿ë½Ã ÇÏ´Ü¿¡ ¹ß»ýÇÏ´Â °ø¹é Á¦°Å¹æ¹ý
2,873
¾ÆÀÌÇÁ·¹ÀÓ(iframe) Àüüȭ¸é °¡´ÉÇÏ°Ô Çϱâ
2,872
ºÎÆ®½ºÆ®·¦(bootstrapk)¿¡¼­ »ç¿ëÇÏ´Â class¸í Á¤¸®
2,871
ºÎÆ®½ºÆ®·¦ CSS
2,870
Å©·Ò¿¡¼­ ¸¶Áø Á¶Àý
2,869
PHP ÇöÀç ÆäÀÌÁöÀÇ µµ¸ÞÀθíÀ̳ª urlµîÀÇ Á¤º¸ ¾Ë¾Æ¿À±â
2,868
PHP preg match all()
2,867
PHP ·Î À¥ÆäÀÌÁö ±Ü¾î¿À±â ¸ðµç ¹æ¹ý ÃÑÁ¤¸®!
2,866
[PHP] ¿ø°ÝÁö ÆÄÀÏ ÁÖ¼Ò ³ëÃâ ¾ÈÇÏ°í curl·Î ´Ù¿î·Îµå ¹Þ±â
2,865
PHP ÇÔ¼ö Á¤¸®
2,864
¾ÆÀÌÇÁ·¹ÀÓ(iframe) ºñÀ² À¯ÁöÇϸ鼭 Å©±â Á¶ÀýÇÏ´Â ¹æ¹ý
2,863
PHP ¹è¿­¿¡¼­ ¹«ÀÛÀ§·Î Çϳª »Ì¾ÆÁÖ´Â array rand() ÇÔ¼ö
2,862
PHP Á¤±Ô½Ä Á¤¸®
2,861
PHP Á¤±Ô½ÄÀ» È°¿ëÇÑ ÅÂ±× ¹× ƯÁ¤ ¹®ÀÚ¿­ Á¦°Å ¹× ÃßÃâ ¹æ¹ý
2,860
php Å©·Ñ¸µ ¶Ç´Â ÆÄ½Ì ÇÔ¼ö, Á¤±Ô½Ä ¸ðÀ½
2,859
Á¦ÀÌÄõ¸® ±âº» ¸í·É¾î
2,858
À¥ÆäÀÌÁö °¡·Î ¸ðµå¼¼·Î ¸ðµå ÀνÄÇϱâ
2,857
¸ð¹ÙÀÏ À¥ È­¸é °­Á¦ ȸÀü(°¡·Î¸ðµå °íÁ¤)
2,856
[HTML5]¿¡¼­ frameset ´ëü ¹æ¹ý°ú iframe ¼Ó¼º
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.