Retrieving the Last Auto Increment ID in PHP

Q

How To Get the Last ID Assigned by MySQL in PHP?

✍: FYIcenter.com

A

If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below:

<?php
  include "mysql_connection.php";

  $sql = "INSERT INTO fyi_users (name) VALUES ('John King')";
  if (mysql_query($sql, $con)) {
    print(mysql_affected_rows() . " rows inserted.\n");
    print("Last ID inserted: ".mysql_insert_id()."\n");
  } else {
    print("SQL statement failed.\n");
  }

  mysql_close($con); 
?>

If you run this script, you will get something like this:

1 rows inserted.
Last ID inserted: 3

⇒ Uploading Files to Web Servers in PHP

⇐ Setting ID Column as Auto-Incremented in PHP

⇑ Working with MySQL Database in PHP

⇑⇑ PHP Tutorials

2016-10-17, 1214👍, 0💬

What Is File Upload in PHP
What Is File Upload in PHP? File upload is Web page function which allows visitor to specify a file on the browser's system and submit it to the Web server. This is a very useful function for many interactive Web sites. Some examples are: Web base email systems for users to send attachments. Forums ... 2016-10-17, 1396👍, 0💬

Uploading Files to Web Servers in PHP
Where to find tutorials on how to upload files to Web servers in PHP? A collection of tutorials to answer many frequently asked questions on how to upload files to Web servers in PHP. Clear explanations and tutorial exercises are provided on creating file upload HTML tags, setting encoding type on H... 2016-10-17, 1393👍, 0💬

Setting ID Column as Auto-Incremented in PHP
How To Set the ID Column as Auto-Incremented in PHP? Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow MySQL server to automatically assign a... 2016-10-17, 1339👍, 0💬

Querying Multiple Tables Jointly in PHP
How To Query Multiple Tables Jointly in PHP? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, and "p... 2016-10-17, 1317👍, 0💬

FORM Tag for Uploading Files in PHP
How To Write the FORM Tag Correctly for Uploading Files in PHP? When users clicks the submit button, files specified in the <INPUT TYPE=FILE...> will be transferred from the browser to the Web server. This transferring (uploading) process is controlled by a properly written <FOR... 2016-10-17, 1268👍, 0💬

Performing Key Word Search in PHP
How To Perform Key Word Search in Tables in PHP? The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any number of... 2016-10-17, 1254👍, 0💬

Quoting Text Values in PHP
How To Quote Text Values in SQL Statements in PHP? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one single... 2016-10-19, 1250👍, 0💬

Getting Uploaded File Information in PHP
How To Get the Uploaded File Information in the Receiving Script in PHP? Once the Web server received the uploaded file, it will call the PHP script specified in the form action attribute to process them. This receiving PHP script can get the uploaded file information through the predefined array ca... 2016-10-17, 1246👍, 0💬

INPUT Tag for File Uploading in PHP
Which HTML Tag Allows Users to Specify a File for Uploading in PHP? To present an input field on your Web page to allow users to specify a local file to upload, you need to use the <INPUT TYPE="FILE" ...> tag inside a <FORM ...> tag. The <INPUT TYPE="FILE" ...&... 2016-10-17, 1241👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.