php - Retrieve record ID after insert -


admittedly, bit out of league here, attempting project anyway.

background:
i developing page allow users enter data database. database has multiple tables have data inserted , updated. first action user takes select option drop down , click "create". clicking create button create record in 1 of tables. also, upon clicking "create" larger form displayed. once larger form complete, user can "save" work. planning on using update query allow user save work.
question:
using ajax post data (see example below), want return record id (primary key) page when visitor saves additional information, database knows record update.

//script

$(function(){   $('#create').click(function(event) {      event.preventdefault();       $.ajax({        type: "post",        url: "url",        data: {"optimizationtype": $("#optimizationtype").val()},         success: function(results){         $("#mvt-experimentdetails").css("display", "inline-block");         $("#create").attr('value', 'save');         $("#create").attr('id', 'save');          }      });    });  }); 

//php includes

$expid = mysqli_insert_id($con); 


know suppose return in success area of ajax, not sure how that...any appreciated.

on php side, after run insert, you'll want last_insert_id , echo that.

for example (using pdo , pseudocode):

insert table values (x,y) $id = $db->lastinsertid(); echo $id; 

on client side, let me recommend $.post instead of $.ajax - find easier use. however, theory same both.

$.post('url', {         data-key: data-value,         next-data-key: next-data-value     },      //now callback     function (recordid) {        //do recordid         alert(recordid); }); 

Comments

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

SQL: Divide the sum of values in one table with the count of rows in another -