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

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();
?>
ÃßõÃßõ : 481 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
223
sessionStorage.getItem ¿Í sessionStorage.setItem
222
¿©·¯ µµ¸ÞÀÎµé °£ ÄíÅ° °øÀ¯Çϱâ
221
ÄíÅ° »ý¼º,°¡Á®¿À±â,»èÁ¦
220
curl ÇÔ¼ö¸¦ ÀÌ¿ëÇÑ HTTP REFERER º¯°æ
219
4±â°¡ ÀÌ»óÀÇ Å×À̺íÀ» ¸¸µé°í ½Í´Ù¸é(Å×À̺íÀÇ AVG_ROW_LENGTH, MAX_ROWS)
218
[mySql] ´Ù¾çÇÑ db°Ë»ö ½ºÅ³ ÃÑÁ¤¸® (¶ç¿ö¾²±â ¹«½Ã, ´ÙÁß°Ë»ö, Æ÷ÇԵǴ ´Ü¾î °Ë»ö)
217
php sqlÀÎÁ§¼Ç °ø°Ý¸·±â
216
[php] SQL ÀÎÁ§¼Ç °ø°Ý
215
Á¤±ÔÇ¥Çö½Ä - ÆÐÅÏ º¯°æÀÚ
214
fopen ¸·ÇûÀ» ¶§ fsocketopen »ç¿ë¹æ¹ý
213
PHP + MYSQL ¿¬°á Å×½ºÆ® ¿¹Á¦ (mysqli Ŭ·¡½º¹æ½Ä)
212
PHP + MYSQL ¿¬°á Å×½ºÆ® ¿¹Á¦ (pdo ¹æ½Ä)
211
PHP + MYSQL ¿¬°á Å×½ºÆ® ¿¹Á¦ (original)
210
DB Á¢±Ù ¹× Äõ¸®¹®(insert,select,update,delete)
209
[MySQL] Çʵ忡¼­ ƯÁ¤¹®ÀÚ Æ÷ÇÔ ¶Ç´Â Á¦¿ÜÇÑ DB °Ë»ö, LIKE ,NOT
208
SHOUTcast ¸¦ ÀÌ¿ëÇÑ ÀÎÅÍ³Ý ¶óÀÌºê ¹æ¼Û ½Ã½ºÅÛ ±¸Ãà
207
PHP ÀÎÁ§¼Ç°ú file get contentsÀÇ °ü°è
206
DB Á¢±Ù ¹× Äõ¸®¹®(insert,select,update,delete)
205
[MySQL] Çʵ忡¼­ ƯÁ¤¹®ÀÚ Æ÷ÇÔ ¶Ç´Â Á¦¿ÜÇÑ DB °Ë»ö, LIKE ,NOT
204
php5 mysqli µðºñ Á¢¼Ó Ŭ·¡½º ÇÁ·Î±×·¥ ¹× »ç¿ë¹ý
html¿¡¼­ ÀÔ·ÂÇÑ°ª DB¿¡¼­ ¹Þ¾Æ¿À±â (µµ¼­Á¤º¸ °Ë»ö)
202
SQL Äõ¸® Á¤¸®
201
[MySql]DB¿¡¼­ ¼­·Î ´Ù¸¥ Å×À̺íÀÇ µ¥ÀÌÅ͸¦ Çѹø¿¡ ºÒ·¯¿À±â
200
À¥È£½ºÆü­¹ö ±×´ë·Î µû¶ó ¸¸µé±â
199
Fatal error: Allowed memory size of ~~
198
.htaccess ÆÄÀÏÀ» ÀÌ¿ëÇÏ¿© PHP ¾÷·Îµå ¿ë·® Á¦ÇÑ º¯°æ
197
¿ìºÐÅõ php.ini ¼³Á¤
196
CURL »ç¿ë¹ý
195
Mysql DB¿¡¼­ ƯÁ¤´Ü¾îµé ÀÏ°ý ¼öÁ¤ Äõ¸®
194
mysql ÇÔ¼öÀÇ php ¿¬°á ¹× Á¾·ù
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.