Foreign Key

[qadeer_ahmad]

I want to handle foreign key using php script.
Can i handle this run time using php script?

Thanks

[laserlight]

Yes, it can be handled by a PHP script, but you are better off letting the database engine do its job. If you happen to be using say, an older version of SQLite that does not enforce foreign key relationships, then you should consider using triggers to simulate them.

[qadeer_ahmad]

I could not see mostly used phpadmin so that i use these to handle can do these locally but when move on server a lot issue come 🙁

[laserlight]

So what exactly are those issues that you are facing?

[qadeer_ahmad]

First of all i could not get the way how i apply Foreign Key in phpmyadmin normally there is only way to make a field as key.
Thanks for replying.

[bradgrafelman]

Which DB engine are you using? InnoDB?

If so, open up the table you're wanting to create a FK in. Make sure you're on the Structure tab, and look for a link underneath the table structure labeled "Relation view." Clicking on that link brings you to a page where you can set foreign keys on that table.