Ajax and Ajax Frameworks

I have been a developer for nearly 20 years and a web developer for about 10 years. Over the years, I have considered creating a blog to share the things I have learned (and am learning) about web design and development, but I never seemed to have the time. When I began learning about web development using Ajax and Ajax Frameworks, I decided to take the time to create this blog.

My intention for this blog is to focus primarily on Ajax Frameworks, but since web development requires knowledge of many technologies, I will occasionally write about things such as CSS, Javascript, PHP, MySQL, Flash, etc.

Lately, I have been using JQuery as my primary Ajax tool. Although I have used other Ajax Frameworks in the past (Dojo Toolkit, Yahoo! User Interface Library, Scriptaculous/Prototype), JQuery has thus far been the easiest to learn. In my first few posts I will discuss some of the JQuery Plugins that I have created. Some of these include: a plugin for Google Maps (jquery.imGoogleMaps), Form validation and submission (jquery.imValidateForm), Page Populater (jquery.imPagePopulate), and a plugin to create lists (jquery.imList).

While I am still learning about some of the other Ajax Frameworks, I hope that what I have learned will be helpful to others. Just remember, “When you can pull the pebbles from my hand…”

Using CodeIgniter to get the Last Inserted ID

Sunday, June 14th, 2009

I often need to know the id of the last inserted record into a table. In the past, I’ve used a PHP function:

^?View Code PHP

function getLastInserted($table, $id) {
	$query = "SELECT $id as maxID from $table where $id = LAST_INSERT_ID()";
	$result = $this-&gt;runQuery($query);
	$row = mysql_fetch_row($result);
	return $row[0];
 }

To duplicate this using CodeIgniter’s Active Record, I could write:

^?View Code PHP

function getLastInserted($table, $id) {
	$this->db->select_max($id);
	$Q = $this->db->get($table);
	$row = $Q->row_array();
	return $row[$id];
 }

But, I learned that there is an even faster way that uses one of CodeIgniter’s Helper functions. Immediately after a record has been inserted into the database, I simply call:

^?View Code PHP

$id = $this->db->insert_id();

Although, I am not sure how CodeIgniter knows which field is the primary key, it seems to work.

Categories: Codeigniter
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.

4 Responses to “Using CodeIgniter to get the Last Inserted ID”

Joe Says:
June 27th, 2009 at 5:11 pm

It works because MySQL has built-in support for this. In the PHP MySQL module, there is a function called mysql_insert_id() that will return the last inserted primary key for the last insert.

CodeIgniter is simply wrapping around this functionality.
superposts Says:
January 11th, 2011 at 12:33 pm

thanks for the post, $id = $this->db->insert_id(); is really easy and nice.
Regs Says:
January 28th, 2011 at 12:24 pm

Thanks guys.. specially Joe for enlightening about called mysql_insert_id()
Thyago Says:
March 31st, 2011 at 10:17 am

Thanks for this dude, really helpful

Using CodeIgniter to get the Last Inserted ID

4 Responses to “Using CodeIgniter to get the Last Inserted ID”

Home Business Ads

Categories

Archives

Tags

Comments

Blogroll