does PHP support foreign key and Rollback?yes or not.if not
then why. how will you done these concept in php?

Answer Posted / praveen

PHP supports Foreign Keys in InnoDB Storage Engine in
version and above 4.0. It checks the foreign key referential
integrities on Delete and Select statements. If you strictly
needed the foreign keys and speed is not a concern then you
can create table structures using InnoDB Storage Engine.


Where as MyISAM Storage Engines does not allow foreign key
concept. But it will parse the table that contains foreign
keys but wont check the referential integreties. So it is
the job of the designer/programmer to check the desired key
and its dependency in multiple tables.

Let us suppose you have a field F1(primary)in Table1 and
this field is referenced in another tables denoted as (F2,
F3) in tables Table2, Table3......(as a foreign key)

and when you want to perform a DELETE operation/query based
on field F1, then
First you need to write a query to Delete the specified row
in Table1
and you also need to write a query to Delete all
dependent/referenced rows in other tables Table2, Table3...

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name and explain five of the PHP error constants?

726


What are the three parts of an http request?

750


How to assigning a new character in a string?

770


What are interfaces in php?

701


What is the difference between array_map () and array_shift ()?

717


Do you know how can php and html interact?

751


Tell me how to strip whitespace (or other characters) from the beginning and end of a string?

724


Which is better mysql or sql?

752


How do you find the length of a string in php?

714


Is php an array?

693


How do you trim spaces in excel?

758


What is the purpose of the '.frm' file extension? What do thes file contain?

714


What are the uses of implode() function?

824


What is php programming used for?

710


What is mean by an associative array?

758