0

Hello,

I am developing and developed couple of websites in php succeccfully but many times I have seen a query a default function of php which i see in many tutorials it has been used but I am confused about it.

The function is mysqli_inser_id() I mean can anyone explain me what is the pupose and where we have to use it and where and when we need this function?

Thank You

3
Contributors
6
Replies
33
Views
2 Years
Discussion Span
Last Post by UK-1991
0

Yes by viewing it generates ID which is created by the query but if we do not use this function the Auto Increment took place on every query though when ever a new record is added the id also increments is it true right this happens

So why we use this function ??

0

It is used to give you the autoinc field value of the last record manipulated (update or insert). It can be useful if you want to insert data into more than one table. For example if you had this:

users: id | email | username | password

telephones: user_id | telno

If you had a form for adding a new user which had multiple form fields (unlimited) for telephones, you wouldn't store them all in the users table as it may violate 1NF (normalization), if, for example, you thought of storing telephone numbers as a comma separated string. So first you add data to the users table as usual, then, because you need the user_id you just created for adding telephone numbers to the telephones table, you need to call mysqli_insert_id() or the OOP equivalent.

0

Okay now I got it and the use of this function. Many times i do the same if there are two table having same id please correct me if I am wrong.

If I got two tables in my database
users
Orders

on both tables I have used a foreing key of user_id so I have to simply call a function of insert id right?

0

Well, user_id with be a PK in your users table and an FK in your orders table. So, yes, it should be right.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.