Q&A
  • PHPÇÔ¼ö Q&A
ÃֽűÛÀ» ¸ÞÀÎÀ¸·Î »Ñ¸®´Â ¼Ò½º ¼öÁ¤Á» ºÎʵå·Á¿ä
±Û¾´ÀÌ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÃÊÂ¥Çñ׷¡¸Ó ³¯ Â¥ 12-06-15 10:19 Á¶ ȸ 304
°£ÆíURL http://phpschool.com/link/qna_function/358007 º¹»ç

SyntaxHighlight·Î º¸±â

´äº¯Ã¤ÅÃÀ² 100 %
<?
##### ¼³Á¤ ÆÄÀÏ ¿¬°á #####
include "technology/config.inc";

##### µ¥ÀÌÅͺ£À̽º ¿¬°á #####
include "technology/dbconn.inc";

##### ÆÄÀÏÀÌ ÀúÀåµÉ µð·ºÅ丮 ¿¬°á #####
$savedir = "admin/technology/data";

##### °¶·¯¸® ¶ç¿ì±â #####
$query = "select uid,userfile1,subject,contents from $db order by uid desc limit 2";
$result= mysql_query($query,$dbconn);
if (!$result) {
echo ("
<script>
window.alert('Äõ¸® ¿¡·¯ÀÔ´Ï´Ù.')
history.go(-1);
</script>
");
}

while($row = mysql_fetch_row($result)) {
$uid=$row[0];
$userfile=$row[1];
$subject=$row[2];
$contents=$row[3];

##### ³»¿ë ±ÛÀÚ¼ö ÀÚ¸£±â #####
$max = 218;
$count = strlen($contents);
if($count >= $max) {
for ($pos=$max;$pos>0 && ord($contents[$pos-1])>=127;$pos--);
if (($max-$pos)%2 == 0)
$contents = sprintf("%s...", substr($contents, 0, $max));
else
$contents = sprintf("%s...", substr($contents, 0, $max+1));
}
else {
$contents = "$contents";
}

##### À̹ÌÁö Å©±â ÁÙÀ̱â #####
define("__LIMIT_WIDTH__", 245);
define("__LIMIT_HEIGHT__", 151);

##### À̹ÌÁö Å©±â±¸ÇÔ #####
$size = GetImageSize($savedir. "/" ."$userfile");

##### Width ±æÀ̰¡ Ŭ °æ¿ì #####
if (__LIMIT_WIDTH__ < $size[0]) {
$height = (int)(($size[1] / $size[0] ) * __LIMIT_WIDTH__);
$width = __LIMIT_WIDTH__;
}

##### Height ±æÀ̰¡ Ŭ °æ¿ì #####
else if (__LIMIT_HEIGHT__ < $size[1]) {
$width = (int)(($size[0] / $size[1]) * __LIMIT_HEIGHT__);
$height = __LIMIT_HEIGHT__;
}

##### À̹ÌÁö Å©±â°¡ ¸ÂÀ» °æ¿ì #####
else {
$width = $size[0];
$height = $size[1];
}
echo("
<td width='245' valign='top'>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td width='245' style='border:1px #9EABBC solid; border-collapse:collapse;'><a href='technology/viewbody.php?db=$db&number=$uid' onfocus='this.blur();'><img src='admin/technology/data/$userfile' width='245' height='151'></a></td>
</tr>
<tr>
<td height='12'></td>
</tr>
<tr>
<td height='40' class='new_title' valign='top'>$subject</td>
</tr>
<tr>
<td valign='top'>$contents</td>
</tr>
<tr>
<td height='10'></td>
</tr>
<tr>
<td align='right'><a href='technology/viewbody.php?db=$db&number=$uid' onfocus='this.blur();'><img src='image/icon_more.gif'></a></td>
</tr>
</table>
</td>
<td width='60'></td>
" );
}
?>

±â¼úÀÚ·á 2°³¸¦ ¸ÞÀÎÀ¸·Î ´ó±â´Â °Çµ¥...
ù¹øÂ° ´ó±â´Â °Å´Â <td width='60'></td> ÀÌ°Ô ºÙ¾î¾ß Çϰí
µÎ¹øÂ° ´ó±â´Â °Å´Â ºÙÁö ¾Ê¾Æ¾ß Çϴµ¥ ¾î¶»°Ô 󸮸¦ ÇØ¾ßÇÒÁö ¸ð¸£°Ú¾î¿ä.

Àüü´ñ±Û¼ö 4

  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§AKB48 12-06-15 10:26

    ¼Ò½ºº¸±â

  • while($row = mysql_fetch_row($result)) {
    µé¾î°¡±âÀü¿¡ ÇöÀç $row¿¡ ÀúÀåµÈ µ¥ÀÌÅͰ¡ 2°³Áß Ã¹¹øÂ°ÀÎÁö µÎ¹øÂ°ÀÎÁö ÀúÀåÇØµÎ´Â º¯¼ö¸¦ Çϳª µÎ°í
    while¹® ù ȸÀü½Ã¿¡ º¯¼ö¸¦ üũÇÏ¿© ù¹øÂ°Àϰæ¿ì <td¸¦ ºÙÀ̰í, üũº¯¼ö¸¦ 2·Î ¹Ù²Û´ÙÀ½,
    µÎ¹øÂ° ȸÀü½Ã¿¡ º¯¼ö¸¦ üũÇϸé 2¸é <td¸¦ ¾ÈºÙÀ̰í....ÇÏ½Ã¸é µÇÁö ¾ÊÀ»±î¿ä.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÃÊÂ¥Çñ׷¡¸Ó 12-06-15 11:00

    ¼Ò½ºº¸±â

  • if ($row = 1) {
    echo "<td></td>";
    }
    else {
    echo "";
    }

    ¹¹ ÀÌ·±½ÄÀΰ¡¿ä? ¾ÈµÇ´Âµ¥... TT;
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§AKB48 12-06-15 15:19

    ¼Ò½ºº¸±â

  • $isFirst = true;
    while($row = mysql_fetch_row($result)) {
    if($isFirst){
        ù¹øÂ°ÀÚ·áÀϰæ¿ì Çϰí½ÍÀºµ¿ÀÛ(td¸¦ ºÙ¿©¼­ Ãâ·Â)
        $isFirst = false;
    }else{
        µÎ¹øÂ°ÀÚ·áÀϰæ¿ì Çϰí½ÍÀºµ¿ÀÛ(td¾ÈºÙÀ̰í Ãâ·Â)
    }
    }

    ÀÌ·±½ÄÀ» ¸»ÇѰ̴ϴÙ.
  • ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÃÊÂ¥Çñ׷¡¸Ó 12-06-15 15:35

    ¼Ò½ºº¸±â

  • ÇØ°áµÇ¾ú¾î¿ä. Á¤¸» °¨»çÇÕ´Ï´Ù.
  • °Ô½Ã¹° 130,927°Ç RSS
¹øÈ£´äº¯Á¦¸ñ±Û¾´À̳¯Â¥Á¶È¸
°øÁö - [Çʵ¶»çÇ×]Q&A °Ô½ÃÆÇ ±ÔÄ¢ [53] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Ä¿ÇÇÇÑÀÜ 08-10-01 150425
130,707 ´äº¯¿Ï·á Linux¿¡¼­ php_openssl À» ¾î¶»°Ô enable ½ÃŰ³ª¿ä?? [2] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¾ÆÀÌ³Í 13-06-06 101
130,706 ´äº¯¿Ï·á Á¦¸ñ ±ÛÀÚ¼öÁ¦ÇÑ¿¡ ´ëÇØ [3] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§À̳ª¶óÇлý 13-06-06 109
130,705 - °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [1] µ¥À̺ø¿ì 13-06-06 66
130,704 ´äº¯¿Ï·á °Ô½ÃÆÇ view ±â´ÉÁß.. [6] ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ÁÖ¼ö¸® 13-06-06 86
130,703 ´äº¯¿Ï·á ÆÄÀϾ÷·Îµå½Ã ÆÄÀÏÀÌ Á¦´ë·Î ¾÷·Îµå°¡ ¾ÈµÇ´Âµ¥¿ä ¾Æ½Ã´ÂºÐ^^;; [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§gstaroncom 13-06-06 77
130,702 ´äº¯¿Ï·á ajax ¿¡¼­ °ªÀº ±¸Çߴµ¥.. [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Áö´Ï29 13-06-06 73
130,701 ´äº¯¿Ï·á include ÇÔ¼ö¸¦ ½ÇÇàÇßÀ» ¶§¿Í file read ¸¦ ÇßÀ» °æ¿ìÀÇ ¼Óµµ ¡¦ [9] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§ºñÁìÆæ 13-06-06 102
130,700 ¹Ì´äº¯ ÆÑÅ丮 Ŭ·¡½º¿¡ ´ëÇØ¼­ Áú¹®Çصµ µÇ°Ú½À´Ï±î? ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ÅÀç 13-06-06 83
130,699 ´äº¯ÁøÇà imagemagick¸¦ ÀÌ¿ëÇÑ png->jpg ¹æ¹ý ¹®ÀÇ [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§SuperY 13-06-06 61
130,698 ´äº¯¿Ï·á ƯÁ¤½Ã°£¿¡ 10ºÐÈĸ¦ ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ Áú¹® [4] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ÅÀç 13-06-06 90
130,697 ´äº¯ÁøÇà error_reporting °ü·Ã Áú¹®.. [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§Á¤¹Î½º 13-06-06 81
130,696 ´äº¯ÁøÇà º¯¼ö°ª¿¡¼­ ƯÁ¤ ¹®ÀÚ¸¸ ÃßÃâÇÏ°í ½ÍÀ»°æ¿ì ¾î¶»°Ô Çϳª¿ä? [4] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¶¯±×¸® 13-06-06 80
130,695 ´äº¯¿Ï·á °í¼ö´Ôµé Á˼ÛÇÕ´Ï´Ù ´Ù½Ã Á¤±Ô½Ä Áú¹® [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§½ÅÀç 13-06-06 72
130,694 ´äº¯¿Ï·á imagemagick À» »ç¿ëÇßÀ» ¶§ png ÆÄÀÏÀÌ ¿ë·®ÀÌ Áõ°¡ÇÏ´Â Çö»ó [2] ÷ºÎÆÄÀÏ ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§SuperY 13-06-06 89
130,693 ´äº¯ÁøÇà header ("Pragma: no-cache");°¡ ¹«½¼ ¸í·É¾î Àΰ¡¿ä? [1] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¸ðµµ 13-06-06 96
130,692 ´äº¯ÁøÇà À̹ÌÁö ¾÷·Îµå °úÁ¤¿¡¼­ ¿À·ù ÇØ°áÁ»¿ä¤Ð µµ¿ÍÁÖ¼¼¿© [2] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§altls 13-06-05 85
130,691 - °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [1] dsk1103 13-06-05 55
130,690 ´äº¯¿Ï·á ±¸ºÐÀÚ(?)¿¡ ´ëÇØ¼­ [3] ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¶ó¿ÂÁ¦³ª 13-06-05 78
130,689 ´äº¯ÁøÇà ¾Ïȣȭ °ü·ÃÇØ¼­ ~ .. [8] Àα⠱â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§¸¶·ç¸¶·ç 13-06-05 134
130,688 ¹Ì´äº¯ json »ç¿ë Áß ¿¡·¯ÀÔ´Ï´Ù. ±â¼ú·¹º§Ä¿¹Â´ÏƼ·¹º§³Êµµ°¨µ¿ÀÌ´Ù 13-06-05 79
 
11121314151617181920