๋‚˜๋งŒ์˜ ์˜ค๋ž˜๋‹ฌ๋ฆฌ๊ธฐ๋ฅผ ํ•˜๋Š” ์‚ฌ๋žŒ

Become a ghost

Programming - Language/PHP

[PHP] mysql์—์„œ ๋ฐฉ๊ธˆ insert ํ•œ row์˜ AUTO_INCREMENT ๊ฐ’ ๊ฐ€์ ธ์˜ค๊ธฐ

jennnnna 2024. 6. 12. 13:59

์•ˆ๋“œ๋กœ์ด๋“œ ์•ฑ์„ ๋งŒ๋“œ๋Š” ์ค‘์ด๋‹ค. 
๊ฒŒ์‹œ๊ธ€ ๋‚ด์šฉ(์ œ๋ชฉ, ๋‚ด์šฉ, ์นดํ…Œ๊ณ ๋ฆฌ)์„ DB์— ๋„ฃ์€ ๋‹ค์Œ 
๊ฐ™์€ ๊ฒŒ์‹œ๊ธ€์— ์ถ”๊ฐ€๋œ ์ด๋ฏธ์ง€๋ฅผ ์ด๋ฏธ์ง€ ํ…Œ์ด๋ธ”์— ๋”ฐ๋กœ ๋„ฃ์–ด์ค˜์•ผ ํ•˜๋Š”๋ฐ 
์ด๋•Œ ๊ฒŒ์‹œ๊ธ€ ๋ฒˆํ˜ธ๋ฅผ ์™ธ๋ž˜ํ‚ค๋กœ ์‚ฌ์šฉํ•ด์•ผํ•˜๊ธฐ ๋•Œ๋ฌธ์— ๊ฒŒ์‹œ๊ธ€ ๋‚ด์šฉ์„ insert ํ•˜์ž๋งˆ์ž ๊ฒŒ์‹œ๊ธ€ ๋ฒˆํ˜ธ๋ฅผ ์•Œ์•„๋‚ด์•ผ ํ•œ๋‹ค. 

 

// my sql  connection 
$conn = new mysqli($servername, $username, $password, $dbname);


$๋ณ€์ˆ˜์ด๋ฆ„ = $conn->insert_id;

 

insert ์ฟผ๋ฆฌ๋ฌธ์„ ์‹คํ–‰ ์‹œํ‚จ ๋’ค insert_id ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค.