Get ID of a line that was just created in PHP

Question

Get ID of a line that was just created in PHP

Navigation

#1 by (8 votes)
#2 by (1 votes)

3

Hey guys, So I have a problem that is as follows, I have a table players , a table training and a helper table treadmill (where will I see if some player is currently training) The question is, how can I do that by the time I create a workout, this auxiliary table is populated with the workout ID I just created and the id of the players. For example, in my interface I select a training and select players that will participate, clicking on the button "Start workouts" I want that, besides creating a column in the table training , with auto-increment ID , I want you to create a line with the ID that has just been generated in the player_treater table. I hope I have illustrated well haha. In java it would be using Statement.RETURN_GENERATED_KEYS, but in PHP I no longer handle it. Does anyone know how to do it?

php sql web-service

asked by anonymous 10.11.2015 / 19:44

2 answers

1

You can use the following SQL:

SELECT LAST_INSERT_ID() as id FROM tabela

10.11.2015 / 19:51

Cordova Retrieve Phone Number and IMEI Android and iOS How do I call an activity from a click on an item in an ExpandableListView?

score 8 · Accepted Answer

If you are using the MySQLi extension:

mysqli_query( $con,"INSERT INTO jogadores(nome, idade) VALUES ('Pedro',35)" );
$id = mysqli_insert_id( $con ); // Aqui obtemos o ID do registro inserido

For PDO:

$id = $con->lastInsertId();

If you are using the MySQL extension, is not recommended :

>

$id = mysql_insert_id();