PHP Mysql Tutorials, Function, mysql_insert_id()

Licensed Scripts

Licensed Scripts

HTML Tutorials	CSS Tutorials
Photoshop Tutorials	Flash Tutorials
JavaScript Tutorials	Jquery Tutorials
JSP Topics	Php Tutorials
MYSQL Tutorials	Regular Expression
Perl Tutorial	Domain & Dns
Unix Commands	C++
Vista Services	Linux Services
Web Building	Seo Tutorial
Powerpoint	VB.Net Tutorial
Rss Feed	GIMP

Clipart Pictures

Signs

Country Emblems

Background Images

Logos

Menu Builder	Button Creator
Link Analyzer	DNS Lookup
Website Popularity	Color Chooser
Apache Ver Lookup	Page Rank Checker
Case Converter	Form Generator
Statistics	Epoch-GMT Converter
Hours Calculator	Htpasswd Generator
Favicon Generator	Backlink Checker
Image Crop Tool	Chart and Graph Tools
Multiple Drop Down Menu	Email Verification Tool
If Modified Since	Language Subtags
FBLike Count Calculator	SEO Text Browser

PHP Tutorial

Portuguese

Outsource Servers

Online Calculator

Hosting Companies

Home

Home

Scripts

Scripts

Tutorials

Tutorials

Images

Images

Tools

Tools

Purchase

Purchase

Snippets

Snippets

PHP Topics

Data Types

Operators

Control Structures

Functions

Pre-defined Function

Calendar Functions

Date and Time

Array Functions

Array Functions List1

Array Functions List2

Math Functions

PHP Mysql Functions

File Handling

Error Handling

PHP Mail

String Functions

String Functions List1

String Functions List2

Session Functions

Cookies Functions

Form Variables

Running PHP from JS

Ask Your Doubts

track, manage link submission status

mysql_insert_id() function in PHP

Tutorials »Php »

Topic

What is mysql_insert_id() function in PHP?
How does mysql_insert_id() works?

Explanation

The mysql_insert_id() function returns the AUTO_INCREMENT ID generated from the previous INSERT operation.

Syntax

int mysql_insert_id ( [resource link_identifier])

Returns ID generated for an AUTO_INCREMENT column by the previous INSERT query on success, 0 if the previous query does not generate an AUTO_INCREMENT value, or FALSE if no MySQL connection was established.

mysql_insert_id() returns the ID generated for an AUTO_INCREMENT column by the previous INSERT query using the given link_identifier. If link_identifier is not specified, the last opened link is assumed for connection.

Example

<?php

//Attempt to connect to the default database server

$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");

//select database

mysql_select_db('database',$link);

$query = "insert into my_table values('','Bill',2000,'Germany')";

//execute query

$result = mysql_query($query);

//print AUTO_INCREMENT ID generated from the previous INSERT operation

printf("Last inserted record has id :%d\n", mysql_insert_id());

?>

RESULT:

Last inserted record has id : 10

See also: mysql_query().

Other Links

web hosting