Get ID Of The Last Inserted Row

2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€94.10
List Price:  €131.75
You save:  €37.64
£77.97
List Price:  £109.16
You save:  £31.19
CA$139.59
List Price:  CA$195.43
You save:  CA$55.84
A$152.81
List Price:  A$213.94
You save:  A$61.13
S$133.81
List Price:  S$187.35
You save:  S$53.53
HK$777.87
List Price:  HK$1,089.05
You save:  HK$311.18
CHF 88.25
List Price:  CHF 123.55
You save:  CHF 35.30
NOK kr1,105.40
List Price:  NOK kr1,547.61
You save:  NOK kr442.20
DKK kr701.91
List Price:  DKK kr982.70
You save:  DKK kr280.79
NZ$168.16
List Price:  NZ$235.43
You save:  NZ$67.27
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.91
৳11,965.03
List Price:  ৳16,751.52
You save:  ৳4,786.49
₹8,438.50
List Price:  ₹11,814.24
You save:  ₹3,375.73
RM443.70
List Price:  RM621.20
You save:  RM177.50
₦167,914.20
List Price:  ₦235,086.60
You save:  ₦67,172.40
₨27,820.24
List Price:  ₨38,949.45
You save:  ₨11,129.21
฿3,479.40
List Price:  ฿4,871.30
You save:  ฿1,391.90
₺3,438.07
List Price:  ₺4,813.44
You save:  ₺1,375.36
B$575.47
List Price:  B$805.68
You save:  B$230.21
R1,807.17
List Price:  R2,530.11
You save:  R722.94
Лв183.84
List Price:  Лв257.39
You save:  Лв73.54
₩140,765.83
List Price:  ₩197,077.80
You save:  ₩56,311.96
₪375.06
List Price:  ₪525.10
You save:  ₪150.04
₱5,861.60
List Price:  ₱8,206.47
You save:  ₱2,344.87
¥15,409.04
List Price:  ¥21,573.27
You save:  ¥6,164.23
MX$2,045.29
List Price:  MX$2,863.49
You save:  MX$818.20
QR364.92
List Price:  QR510.90
You save:  QR145.98
P1,347.64
List Price:  P1,886.76
You save:  P539.11
KSh12,911.70
List Price:  KSh18,076.90
You save:  KSh5,165.20
E£4,921.87
List Price:  E£6,890.82
You save:  E£1,968.94
ብር12,340.83
List Price:  ብር17,277.65
You save:  ብር4,936.82
Kz91,125.91
List Price:  Kz127,579.93
You save:  Kz36,454.01
CLP$96,906.30
List Price:  CLP$135,672.70
You save:  CLP$38,766.40
CN¥723.42
List Price:  CN¥1,012.82
You save:  CN¥289.40
RD$6,049.41
List Price:  RD$8,469.42
You save:  RD$2,420
DA13,340.47
List Price:  DA18,677.19
You save:  DA5,336.72
FJ$226.02
List Price:  FJ$316.44
You save:  FJ$90.41
Q773.94
List Price:  Q1,083.55
You save:  Q309.60
GY$20,947.72
List Price:  GY$29,327.65
You save:  GY$8,379.92
ISK kr13,916.60
List Price:  ISK kr19,483.80
You save:  ISK kr5,567.20
DH993.43
List Price:  DH1,390.84
You save:  DH397.41
L1,799.36
List Price:  L2,519.17
You save:  L719.81
ден5,784.17
List Price:  ден8,098.07
You save:  ден2,313.90
MOP$801.80
List Price:  MOP$1,122.56
You save:  MOP$320.75
N$1,785.27
List Price:  N$2,499.45
You save:  N$714.18
C$3,680.37
List Price:  C$5,152.66
You save:  C$1,472.29
रु13,514.93
List Price:  रु18,921.44
You save:  रु5,406.51
S/377.01
List Price:  S/527.83
You save:  S/150.82
K402.10
List Price:  K562.96
You save:  K160.85
SAR375.63
List Price:  SAR525.89
You save:  SAR150.26
ZK2,720.99
List Price:  ZK3,809.49
You save:  ZK1,088.50
L468.27
List Price:  L655.60
You save:  L187.32
Kč2,387.60
List Price:  Kč3,342.73
You save:  Kč955.13
Ft38,566.64
List Price:  Ft53,994.84
You save:  Ft15,428.20
SEK kr1,088.61
List Price:  SEK kr1,524.10
You save:  SEK kr435.49
ARS$99,837.19
List Price:  ARS$139,776.06
You save:  ARS$39,938.87
Bs694.40
List Price:  Bs972.19
You save:  Bs277.79
COP$437,433.09
List Price:  COP$612,423.82
You save:  COP$174,990.73
₡51,281.98
List Price:  ₡71,796.82
You save:  ₡20,514.84
L2,526.99
List Price:  L3,537.89
You save:  L1,010.89
₲782,424.02
List Price:  ₲1,095,424.93
You save:  ₲313,000.91
$U4,216.01
List Price:  $U5,902.59
You save:  $U1,686.57
zł410.18
List Price:  zł574.28
You save:  zł164.09
Already have an account? Log In

Transcript

Hello, in this video, I am going to cover how to get the ID of the last inserted row. So what we've got here just insert a row and qaddafi the Sith Lord. So it's got a bunch of them here. And we want to get the ID. So this is useful for several different things. One, we might be inserting it then navigating to another page.

And for example, let's say to do, you're on a website, you are blogging, or it's a blog website, you click enter, or you click Submit, for the blog post, and it's common practice for the website to take you to that new blog post has been successfully inserted. And it would based on the ID so you could have a blog post page, which takes maybe you know, a get variable that you're passing through, you know, the form would be done as an action and a method and then the data ID can be used to retrieve The data to get is really simple. All you do is a connection or you know, whatever the name of the connection is last insert ID function. And then that's it. We're going to assign that to last i do and i think that you just added a row ID, then dollar sign, like so.

And I will a new line tab there. So as you can see, it should be 13. So if I reload it, we get you have just added a new row with the ID of 13. We load as you can see right there, and if I keep reloading it will just keep incrementing it because he keeps adding rows. So that is how you get the ID of the last insert. wrote, you can do whatever you want with it.

You could send the user to another page, send that Id with the user. You could maybe insert that into another area of your database. Another table, for example. There's a lot of stuff you can do. You can retrieve the data from it. And yeah, planning stuff.

So thanks for watching any questions, feel free to pop me, you know a message and I look forward to seeing you in the next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.