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

PHP - SELECT·Î ¹ÝȯµÈ ·¹ÄÚµå °¹¼ö¿Í Ä÷³ÀÇ °¹¼ö¸¦ ¾Ë·ÁÁÖ´Â ÇÔ¼ö
12³â Àü
php¸¦ ÇѹøÀÌ¶óµµ ´Ù·ç¾î º» ºÐÀ̶ó¸é ´Ù ¾Ë°í °è½Ç ÇÔ¼öÀÌÁö¸¸, ASP, JSPµî ´Ù¸¥ ±â¹Ý ±â¼ú·Î ÀÛ¾÷À» ÇϽôø ºÐÀÌ
°©Àڱ⠴ýÅÊÀÌ ¾²°í, php ·Î ÀÛ¾÷À» ÇÏ°Ô µÇ¾ú´Ù¸é, ÇѹøÀº ²À ã°ÔµÇ´Â ÇÔ¼öÀ̱⵵ ÇÕ´Ï´Ù.


1. mysql_num_rows
mysql_num_rows ÇÔ¼ö´Â SELECT Äõ¸®ÀÇ ½ÇÇà °á°ú·Î ¹ÝȯµÈ ·¹ÄÚµåÀÇ °¹¼ö¸¦ ¾Ë·ÁÁÝ´Ï´Ù.

¿øÇü: int mysql_num_rows ( resource $result )


¾Æ·¡´Â mysql_num_rows ÇÔ¼öÀÇ ÂªÀº ¿¹Á¦·Î µ¥ÀÌÅͺ£À̽º(testdb)¿¡ ÀÖ´Â Å×À̺í(tbl_test)ÀÇ Àüü ·¹ÄÚµå ¼ö¸¦ ¹ÝȯÇÏ°í ÀÖ½À´Ï´Ù.

<?php
   $hostname = "localhost"; // È£½ºÆ®¸í ¶Ç´Â IP
   $user = "testUser"; // MySQL »ç¿ëÀÚ
   $pwd = "123456"; // MySQL Á¢±Ù ºñ¹Ð¹øÈ£
   $database = "testdb"; // µ¥ÀÌŸº£À̽º¸í
   $connect = mysql_connect ($hostname, $user, $pwd);
   mysql_select_db ($database, $connect);

   $result = mysql_query("SELECT * FROM tbl_test", $connect);
   $rows = mysql_num_rows($result);

   echo "SELECT·Î ¹ÝȯµÈ ·¹ÄÚµåÀÇ °¹¼ö´Â:$rows";
?>



2. mysql_affected_rows
mysql_num_rows ÇÔ¼ö°¡ SELECT Äõ¸®ÀÇ ½ÇÇà °á°ú °ªÀ» ¹ÝȯÇÑ´Ù¸é mysql_affected_rows ÇÔ¼ö´Â INSERT, UPDATE, DELETE Äõ¸®ÀÇ ½ÇÇà °á°ú·Î º¯È­µÈ(¿µÇâÀ» ¹ÞÀº) ·¹ÄÚµåÀÇ °¹¼ö¸¦ ¹ÝȯÇØ ÁÝ´Ï´Ù. À̸§¿¡¼­ ºÎÅÍ ³¿»õ°¡ ǮǮ ³ª°í ÀÖÁö ¾Ê½À´Ï±î?

¿øÇü: int mysql_affected_rows ([ resource $link_identifier ] )


¾Æ·¡´Â mysql_affected_rows ÇÔ¼öÀÇ ÂªÀº ¿¹Á¦·Î µ¥ÀÌÅͺ£À̽º(testdb)¿¡ ÀÖ´Â Å×À̺í(tbl_test)¿¡¼­ seq °¡ 2ÀÎ ·¹Äڵ带 »èÁ¦ÇÏ°í ÀÖ½À´Ï´Ù. ÇÑ°³ÀÇ ·¹Äڵ带 »èÁ¦ÇßÀ¸´Ï ¹ÝȯµÈ °ªÀº 1ÀÔ´Ï´Ù.

<?php
   $hostname = "localhost"; // È£½ºÆ®¸í ¶Ç´Â IP
   $user = "testUser"; // MySQL »ç¿ëÀÚ
   $pwd = "123456"; // MySQL Á¢±Ù ºñ¹Ð¹øÈ£
   $database = "testdb"; // µ¥ÀÌŸº£À̽º¸í
   $connect = mysql_connect ($hostname, $user, $pwd);
   mysql_select_db ($database, $connect);

   $result = mysql_query("DELETE FROM tbl_test WHERE seq = 2", $connect);
   $rows = mysql_affected_rows();

   echo "DELETE·Î »èÁ¦µÈ ·¹ÄÚµåÀÇ °¹¼ö´Â:$rows";
?>



2. mysql_num_fields
mysql_num_fields ÇÔ¼ö´Â °ÅÀÇ º¸³Ê½º °°Àº ÇÔ¼öÀÔ´Ï´Ù. Å×À̺íÀÇ Ä÷³ÀÇ °¹¼ö¸¦ ¹ÝȯÇØ ÁÝ´Ï´Ù.

¿øÇü: int mysql_num_fields ( resource $result )


¾Æ·¡´Â mysql_num_fields ÇÔ¼öÀÇ ÂªÀº ¿¹Á¦·Î µ¥ÀÌÅͺ£À̽º(testdb)¿¡ ÀÖ´Â Å×À̺í(tbl_test)ÀÇ Ä÷³¼ö¸¦ ¾Ë·ÁÁÝ´Ï´Ù.

<?php
   $hostname = "localhost"; // È£½ºÆ®¸í ¶Ç´Â IP
   $user = "testUser"; // MySQL »ç¿ëÀÚ
   $pwd = "123456"; // MySQL Á¢±Ù ºñ¹Ð¹øÈ£
   $database = "testdb"; // µ¥ÀÌŸº£À̽º¸í
   $connect = mysql_connect ($hostname, $user, $pwd);
   mysql_select_db ($database, $connect);

   $result = mysql_query("SELECT * FROM tbl_test", $connect);
   $cols = mysql_num_fields($result);

   echo "Ä÷³ÀÇ °¹¼ö´Â:$cols";
?>


ÃßõÃßõ : 432 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
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.