|
Total related article : 2 |
|
µî·ÏÀÏ: | 2000-12-26 |
½Ã°£: | 17:56:07 |
Á¶È¸¼ö: | 2037 |
from: | 210.219.164.248 |
|
À̹ø¿£ MYSQL... |
±Û¾´ÀÌ : Anonymous |
|
¾È³çÇϼ¼¿ä. WHITE ´ÔÀÇ ¾Æ·¡ ´äº¯ Àß º¸¾Ò½À´Ï´Ù.
°¨»çÇϱ¸¿ä.
À̹ø¿£ MYSQL ¿¡ °üÇÑ Áú¹® ÀÔ´Ï´Ù.
WHITE ´ÔÀÌ ¸ð¸£½Ã¸é ¿·¿¡ÀÖ´Â VOPOS ´ÔÀÌ¶óµµ ±¦Âú½À´Ï´Ù.
¿ì¼± µ¥ÀÌÅ͸¦ ã½À´Ï´Ù.
select * from Å×À̺í where Ç׸ñ= ³ª
¿ä·¸°Ô Çß½À´Ï´Ù.
À̹ø¿£ ...
select * from Å×À̺í where comment like %$query% order by id desc
ÄÚ¸àÆ®¿¡¼ $query ¶õ°Ô ÀÖ³ª ã½À´Ï´Ù.
¿©±â±îÁø ¹®Á¦°¡ ¾ø½À´Ï´Ù.
±×·±µ¥ ¸¸¾à comment ¿¡ ¾ø°í subject ¿¡ ÀÖ´Â °æ¿ì ¾î¶»°Ô ÇØ¾ß Çϳª¿ä.
select * from Å×À̺í where comment,url like ...
±øÀ¸·Î ÀÌ·¸°Ô ¸¸µé¾î º¸¾Ò´õ´Ï ¿¡·¯°¡ ³ª´õ±º¿ä....
¾î¶»°Ô ÇØ¾ß ÇÒ±î¿ä µÎ Ç׸ñ ÀÌ»óÀ» ¸ðµÎ °Ë»ö ÇÏ´Â ¹æ¹ýÀÌ ±Ã±ÝÇÕ´Ï´Ù.
(±×·±°Ô ÀÖ´ÂÁö ¾ø´ÂÁöµµ ¸ð¸£Áö¸¸...)
HAPPYCGI ´Â °í¼ö´ÔµéÀÌ ¸¹À¸½Ã´Ï±ñ °¥ÄÑ ÁֽǰŶó°í »ý°¢ÇÕ´Ï´Ù.
Å©¸®½º¸¶½ºµµ ³¡³µ´Âµ¥¿ä...
»õÇØ º¹ ¸¹ÀÌ ¹ÞÀ¸¼¼¿ä.
|
|
   |
|
µî·ÏÀÏ: | 2000-12-26 |
½Ã°£: | 19:03:29 |
Á¶È¸¼ö: | 1964 |
from: | 211.110.186.12 |
|
[´äº¯] À̹ø¿£ MYSQL... |
±Û¾´ÀÌ : white |
|
¾È³çÇϽʴϱî? HappyCGIÆÀ¿¡ whiteÀÔ´Ï´Ù.
Âù¿µ´ÔÀÌ Áú¹®ÇϽŠ°Ë»ö Áß¿¡¼ µÎÇ׸ñ ÀÌ»óÀ» ¸ðµÎ °Ë»öÇÏ´Â ¹æ¹ýÀº
$query°ªÀ» º¸³¾¶§ Ç׸ñÀ» üũÇϴ üũ¹Ú½º¸¦ ¸¸µå½Ã´Â °ÍÀÌ ÁÁÀ» µí Çϱº¿ä.
±×·¡¼ üũ¹Ú½º¿¡ comment¿Í subject¿¡ üũ°¡ µÇ¾î ÀÖ´Ù¸é
$search="select * from Å×À̺í";
if ($comment or $subject){
if($comment == "on"){
$search .= "where";
$search .= " comment like %$query% ";
}
if($subject == "on"){
$search .= " and subject like %$query% ";
}
}
$search.=" order by id desc";
ÀÌ·± ½ÄÀ¸·Î ºÙ¿© ÁÖ½Ã¸é µË´Ï´Ù.
°¨»çÇÕ´Ï´Ù. ÁÁÀº ÇÏ·ç º¸³»¼¼¿ä.^^*
|
|
   |