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

html¿¡¼­ ÀÔ·ÂÇÑ°ª DB¿¡¼­ ¹Þ¾Æ¿À±â (µµ¼­Á¤º¸ °Ë»ö)
8³â Àü
book_search.html(µµ¼­Á¤º¸)
book_insert.php
book_list.php


1. book_search.html(µµ¼­Á¤º¸)  (html¿¡¼­ µµ¼­Á¤º¸ ÀÔ·Â)

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<title>µµ¼­°Ë»ö</title>
</head>
<body>
<p><h3>µµ¼­Á¤º¸ °Ë»öÇϱâ</h3></p>
<form action='book_search.php' method='post'>
  <select name='searchtype'>
    <option value='title'>µµ¼­¸í</option>
    <option value='author'>ÀúÀÚ</option>
    <option value='publisher'>ÃâÆÇ»ç</option>
    <option value='isbn'>ÀϷùøÈ£</option>
  </select>
  <br/>
  <input type='text' name='searchterm' size='40'/>
  <input type='submit' value='°Ë»ö' />
  </form>

</body>
</html>

----------------




2. book_search.php (html¿¡¼­ ÀÔ·ÂÇÑ°ª DB¿¡¼­ ºÒ·¯¿Í¼­ php·Î »Ñ·ÁÁÖ±â
  
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<?
$connect = mysql_connect("localhost","wooin","1234");
$db_con=mysql_select_db("wooin_db",$connect);
$query = "select * from book where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query, $connect);
$records = mysql_num_rows($result); // mysql_num_rows ÀÎÀÚÀÇ ·¹ÄÚµå °³¼ö¸¦ ¾Ë·ÁÁØ´Ù
$fields=mysql_num_fields($result); // mysql_num_fieldsÀÎÀÚÀÇ Çʵ尳¼ö¸¦ ¾Ë·ÁÁØ´Ù
echo "<p> °ü·Ãµµ¼­¸¦ ".$records."°³ ã¾Ò½À´Ï´Ù.</p>";
$number=1;
?>

<h2> µµ¼­Á¤º¸ °Ë»ö°á°ú</h2>
<table width ="800" border="1" cellspacing="0" cellpadding="5">
<tr align="center">
<td bgcolor="#cccccc">¼ø¹ø</td>
<td bgcolor="#cccccc">µµ¼­¸í</td>
<td bgcolor="#cccccc">ÀúÀÚ</td>
<td bgcolor="#cccccc">ÃâÆÇ»ç</td>
<td bgcolor="#cccccc">ÁÖ¼Ò</td>
<td bgcolor="#cccccc">°¡°Ý</td>
<td bgcolor="#cccccc">ÀϷùøÈ£</td>
</tr>
<?
for($i =0; $i < $records; $i++){

echo"<tr align='center'>>";
echo"<td>$number </td>";
for($j=0; $j< $fields; $j++){
$data = mysql_result ($result, $i, $j); // ·¹ÄÚµåÀ§ ƯÁ¤À§Ä¡¿¡ ÀúÀåµÈ °ªÀ» °¡Á®¿Â´Ù
echo "<td> $data</td>";
}
echo"<tr>";
$number++;
}
mysql_close();
?>
ÃßõÃßõ : 480 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
2,735
[jQuery]toggleClass() ¸Þ¼­µå·Î CSS Ŭ·¡½º¿¡ ´ëÇÑ Åä±×¸µ
2,734
JQuery ¸Þ¼­µå Çѹø¸¸ ½ÇÇà ( One() )
2,733
jQuery Event(À̺¥Æ®¿¡ »ý¸íÀ»)
2,732
jQuery Event - bind() ¸Þ¼­µå¸¦ ÅëÇÑ À̺¥Æ® ¿¬°á
2,731
escapeshellcmd
2,730
passthru
2,729
system
2,728
exec
2,727
proc_open
2,726
popen
2,725
fgetc
2,724
fgets
2,723
fclose
2,722
fopen
2,721
fsockopen
2,720
stream_set_timeout
2,719
JQUERY Ŭ¸¯ À̺¥Æ® °­Á¦ ¹ß»ý
2,718
ajaxComplete() Ajax°¡ ¿Ï·áµÇ¸é È£Ãâ
2,717
ajaxError() Ajax ¿¡·¯°¡ ¹ß»ýµÇ¸é È£Ãâ
2,716
jQuery.ajaxPrefilter() $.ajax() ÇÔ¼ö È£Ãâ Àü Ajax ¿É¼Ç ¼öÁ¤
2,715
ajaxSend() Ajax ¿äûÀ» º¸³»±â Àü¿¡ È£ÃâµÇ´Â À̺¥Æ®
2,714
jQuery.ajaxSetup() Ajax ¿É¼Ç °ªÀ» ¼³Á¤ÇÏ´Â ÇÔ¼ö
2,713
ajaxStart() Ajax ¿äûÀÌ ½ÃÀÛµÉ ¶§ È£ÃâµÇ´Â ÇÔ¼ö
2,712
ajaxStop() Ajax ¿äûÀÌ ¿Ï·áµÇ¸é È£Ãâ
2,711
ajaxSuccess() Ajax ¿äûÀÌ ¼º°øÀûÀ¸·Î ¿Ï·á ¶§¸¶´Ù È£Ãâ
2,710
jQuery.getScript, JavaScript ÆÄÀÏÀ» ·ÎµåÇÏ°í ½ÇÇà
2,709
load(), Ajax·Î ¹ÞÀº HTMLÀ» ÀÏÄ¡ÇÏ´Â ¿ä¼Ò ¾È¿¡ Ãß°¡
2,708
jQuery.param(), Ajax µ¥ÀÌÅÍ¿ë ¹è¿­À̳ª °´Ã¼¸¦ Á÷·ÄÈ­
2,707
jQuery.get() HTTP GET ¹æ½Ä Ajax ¿äû
2,706
jQuery.post(), Ajax HTTP POST ¹æ½Ä ¿äû
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.