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


mysql insert id
13³â Àü
¼³¸í
int mysql_insert_id ([ resource $link_identifier ] )
ÀÌÀüÀÇ INSERT ÁúÀǷκÎÅÍ AUTO_INCREMENT Ä÷³¿¡ ÀÇÇØ »ý¼ºµÈ ID¸¦ ¹ÝȯÇÑ´Ù.



¹Ýȯ°ª
¼º°øÇϸé ÀÌÀüÀÇ INSERT ÁúÀÇ¿¡ ÀÇÇÑ AUTO_INCREMENT Ä÷³À¸·ÎºÎÅÍ »ý¼ºµÈ ID¸¦, ÀÌÀü ÁúÀǷκÎÅÍ AUTO_INCREMENT °ªÀÌ »ý¼ºµÇÁö ¾Ê¾Ò´Ù¸é, 0À», MySQL Á¢¼ÓÀÌ µÇÁö ¾ÊÀº »óÅ¿´´Ù¸é FALSE¸¦ ¹ÝȯÇÑ´Ù.




ÁÖÀÇ
Caution
mysql_insert_id()´Â ¿ø½Ã(native) MySQL C API ÇÔ¼öÀÎ mysql_insert_id()ÀÇ longÇüÅÂÀÇ ¹Ýȯ°ªÀ» PHPÀÇ int·Î º¯È¯ÇÑ´Ù. AUTO_INCREMENT Ä÷³ÀÌ BIGINTÀ̸é, mysql_insert_id()¿¡ ÀÇÇØ ¹ÝȯµÇ´Â °ªÀº À߸øµÉ °ÍÀÌ´Ù. ÀÌ°æ¿ì, MySQL SQL ³»ºÎ ÇÔ¼öÀÎ LAST_INSERT_ID()¸¦ »ç¿ëÇÏ¸é µÈ´Ù.

Note: mysql_insert_id()´Â ÃÖ±Ù ¼öÇàÇÑ ÁúÀÇ¿¡ ´ëÇؼ­ µ¿ÀÛÇϱ⠶§¹®¿¡, »ý¼ºµÈ °ªÀº ÁúÀÇ Á÷ÈÄ¿¡ mysql_insert_id()¸¦ È£ÃâÇØ¾ß µÈ´Ù.


Note: MySQL SQL ÇÔ¼öÀÎ LAST_INSERT_ID()´Â °¡Àå ÃÖ±Ù¿¡ »ý¼ºµÈ AUTO_INCREMENT °ªÀ» ´ã°í ÀÖÀ¸¸ç, ÁúÀÇ °£¿¡ Áö¿öÁöÁö´Â ¾Ê´Â´Ù.

http://docs.php.net/manual/kr/function.mysql-insert-id.php
ÃßõÃßõ : 323 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
1,445
sprintf — Çü½ÄÈ­ÇÑ ¹®ÀÚ¿­À» ¹Ýȯ
1,444
array_merge — Çϳª ÀÌ»óÀÇ ¹è¿­À» º´ÇÕ
1,443
checkdate — ±×·¹°í¸®·Â ³¯Â¥¸¦ È®ÀÎÇÕ´Ï´Ù
1,442
file_get_contents
mysql_insert_id
1,440
implode — ¹®ÀÚ¿­·Î ¹è¿­ ¿ø¼Ò¸¦ °áÇÕ
1,439
stripcslashes — addcslashes()·Î ÀοëÇÑ ¹®ÀÚ¿­À» µÇµ¹¸²
1,438
stripslashes — µû¿ÈÇ¥ ó¸®ÇÑ ¹®ÀÚ¿­À» DZ´Ï´Ù
1,437
addslashes — ¹®ÀÚ¿­À» ½½·¡½Ã·Î Àοë
1,436
mysql_fetch_assoc - ¿¬°ü ¹è¿­·Î °á°ú ÇàÀ» ¹Ýȯ
1,435
array_pop — ¹è¿­ÀÇ ¸¶Áö¸· ¿ø¼Ò »©³»±â
1,434
in_array — °ªÀÌ ¹è¿­ ¾È¿¡ Á¸ÀçÇÏ´ÂÁö È®ÀÎ
1,433
ÆÄÀÏ È®ÀåÀÚ ºñ±³
1,432
À̹ÌÁö ¿¡·¯½Ã ´ëüÀ̹ÌÁö Ç¥Çö
1,431
ÇÁ·ÒÇÁÆ® ·Î±×ÀÎó¸®
1,430
explode - ¹®ÀÚ¿­ ³ª´®
1,429
nl2br (¹®ÀÚ¿­ÀÇ ¸ðµç ÁÙ¹Ù²Þ ¾Õ¿¡ HTML ÁÙ¹Ù²Þ Å±׸¦ »ðÀÔ)
1,428
base64_encode / base64_decode
1,427
urlencode - ¹®ÀÚ¿­À» URL ÀÎÄÚµå
1,426
iconv - ¿øÇÏ´Â ¹®ÀÚ ÀÎÄÚµùÀ¸·Î º¯È¯ÇÑ´Ù
1,425
Á¤±ÔÇ¥Çö½Ä ¸ÅÄ¡¸¦ ¼öÇà (preg_match)
1,424
Á¤±Ô Ç¥Çö½Ä °Ë»ö°ú ġȯ (preg_replace)
1,423
$_FILES
1,422
´ë¼Ò¹®ÀÚ ¹Ù²Ù±â (strtoupper, strtolower)
1,421
¹®ÀÚ¿­ µÚÁý±â (strrev)
1,420
¹®ÀÚ¿­ÀÇ ±æÀÌ (strlen)
1,419
µÎ°³ÀÇ ¹®ÀÚ¿­À» ºñ±³ (strcmp)
1,418
ASCII ÄÚµå °ü·Ã ÇÔ¼ö (chr, ord)
1,417
À̽ºÄÉÀÌÇÁ ÇÔ¼ö (htmlentities)
1,416
Á¤±ÔÇ¥Çö½Ä °Ë»ç µµ±¸ (ereg, eregi)
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.