Interested to Buy Any Domain ? << Click Here >> for more details...
does PHP support foreign key and Rollback?yes or not.if not
then why. how will you done these concept in php?
- 1 Answers
- 6445 Views
- Avanigoradia, Primus Global, I also Faced
- E-Mail Answers
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 |
Is php developer in demand?
Maine 12th ke bad 2 years ka web designing ka course kiya hai. Php me achcha hu. Ek fresher ko is field me kitna mil sakta hai ?
If there are 10 text boxes in a form having same name, their value are different. Value of which textbox will be received on action script?
20 Answers A1 Technology, Bajaj, DG, Genpact,
What is the difference between $name and $$name?
How can I reverse sort an array keeping the correlation between the index and value?
2 Answers Rushmore Consultancy,
Distinguish between urlencode and urldecode?
What is PEAR?
what do you mean by webserver's document root?
Tell me how to create a session? How to set a value in session? How to remove data from a session?
What is singleton pattern in php?
How can I retrieve values from one database server and store them in other database server using PHP?
hi! i am tushar. i am trying to insert digital signature in a pdf file using PHP. i create a digital signature jpg image using imagecreatefromjpeg() function, but whenever i trying to insert it into my pdf file it shown this error. "FPDF error: Not a JPEG file: signature.jpg". could some one help me? how can i insert a digital signature in a pdf file using PHP?
PHP 
