Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Get the MySQL ID of record insertion

Get the MySQL ID of record insertion

Thread began 2/12/2016 12:19 pm by Steve | Last modified 4/27/2020 2:51 pm by Ray Borduin | 1763 views | 5 replies |

2/12/2016 12:19 pm | #1 Steve

Get the MySQL ID of record insertion

Hello,
How do we return the record id of an auto-incremented Insert record with MySQLi Insert behavior?

...
...
...
   $InsertQuery->execute();
  // added mysql_insert_id to catch insertion #
  $last_id = mysqli_insert_id($wildwater_i);
  $last_id2 = $mysqli->insert_id;
  $InsertGoTo = "";
  if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
  $InsertQuery->redirect($InsertGoTo);
}
?>

This is not working in either case tested so maybe a clash with WA function?

2/12/2016 5:14 pm | #2 Ray BorduinWebAssist

$InsertQuery->InsertID

Did this help? Tips are appreciated...

2/12/2016 5:16 pm | #3 Steve

Thanks Ray!!!

2/12/2016 5:23 pm | #4 Steve

FYI if you append ANYTHING into the MySQLi Insert routine DW goes into a beachball loop that times out until you stop the process :-(

2/12/2016 5:29 pm | #5 Ray BorduinWebAssist

Yes, you should avoid adding code to the end of a code chunk like that. It will also break inspection. It is best to find a way to add the necessary code below using the same IF statement.

Did this help? Tips are appreciated...

4/27/2020 2:40 pm | #6 PaulBeta Tester

The session created in the insert wizard worked for me.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.