Get last insert id after insert query CodeIgniter framework

-

 In this example i am going to show you how to get the last insert id after insert data in database.

function save_data($student_data){
$this->db->insert('student_db', $student_data);
$insert_id = $this->db->insert_id();
return $insert_id;
}

Comments

Post a Comment

Popular posts from this blog

Codeigniter Pro Level Tips and Tricks

-
  Codeigniter is my all time favorite php framework in my life. So here I want to share few codeigniter tips and tricks to you. feel free to ask any doubts about this tips. CodeIgniter is very easy me to install. It requires PHP version 4.3.2 or newer and one of the following databases: MySQL, MySQLi, MS SQL, ODBC, Oracle, Postgre or SQLite. Most people (myself included) use MySQL, but it’s good to know it supports some of the other big names. Best of all, CodeIgniter is available as freeware so there is no charge for  downloading  and using this software! Even though EllisLab Network offers the CodeIgniter software free of charge, they still provide user forums, a wiki and a bug tracker to help support the application and its community of users. If you are looking for the best way to streamline your PHP web development process, then CodeIgniter may be just the application that you need – I know it was for me. I have more than 7 years exp in codeigniter. Always try to fol...
Read more

Login with Facebook in CodeIgniter

-
  In the example CodeIgniter Facebook OAuth application, we will implement user authentication with   Facebook PHP Graph SDK   v5.x and store the user’s profile information in the MySQL database. Before you begin to integrate Facebook Login in CodeIgniter, take a look at the files structure of the application. codeigniter_facebook_login / ├── application / │ ├── config / │ │ └── facebook.php │ ├── controllers / │ │ └── User_authentication.php │ ├── libraries / │ │ └── Facebook.php │ ├── models / │ │ └── User.php │ ├── third_party / │ │ └── facebook-php-graph-sdk / │ └── views / │ └── user_authentication / │ └── index.php └── assets / ├── css / │ └── style.php └── images / └── fb-login-btn.png Create Facebook App To getting started to implement Facebook login in  CodeIgniter 3 using PHP SDK , you need to create a Facebook App in the Facebook developers panel and get the App ID and App S...
Read more

PHP - File Uploading

-
Image
A PHP script can be used with a HTML form to allow users to upload files to the server. Initially files are uploaded into a temporary directory and then relocated to a target destination by a PHP script. Information in the  phpinfo.php  page describes the temporary directory that is used for file uploads as  upload_tmp_dir  and the maximum permitted size of files that can be uploaded is stated as  upload_max_filesize . These parameters are set into PHP configuration file  php.ini The process of uploading a file follows these steps − The user opens the page containing a HTML form featuring a text files, a browse button and a submit button. The user clicks the browse button and selects a file to upload from the local PC. The full path to the selected file appears in the text filed then the user clicks the submit button. The selected file is sent to the temporary directory on the server. The PHP script that was specified as the form handler in the form's actio...
Read more