[PHP-DB] Please help - Managing relational tables using PHP
hi all, 1. How does phpMyAdmin manage tables with one to many or many to one relation ships. Is there any documentation about this. --or- 2. Does phpMyAdmin support editing data from more than one table that have a one to many or many to one relationship. Thanks and Wish you a happy new year, Phani. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Please help - Managing relational tables using PHP
You need to realize that phpMyAdmin is a database manangement tool, not a database. So I'll answer your questions based on the mySQL database ... 1. MySQL 3.23.43b introduced a table type of InnoDB which is the first to allow foreign key constraints. http://www.mysql.com/doc/en/SEC448.html ... However, you do not need to enforce constraints to have a relationship. I just assume that's what you're getting at. 2. Yes, if you enforce constraints with the CASCADE option it will. ..see same document: http://www.mysql.com/doc/en/SEC448.html ... Now the catch, my version of phpMyAdmin 2.3.0 does not allow me to choose the table type of InnoDB, even though my database is version 3.23.54. So I assume phpMyAdmin does not allow one to manage these attributes. Someone please correct me if I'm wrong. Ryan -Original Message- From: Phanivas Vemuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:50 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Please help - Managing relational tables using PHP hi all, 1. How does phpMyAdmin manage tables with one to many or many to one relation ships. Is there any documentation about this. --or- 2. Does phpMyAdmin support editing data from more than one table that have a one to many or many to one relationship. Thanks and Wish you a happy new year, Phani. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Please help - Managing relational tables using PHP
Dear Mr. Ryan, May be I did not present my question clearly to you. My question in detail is ... -- Does phpMyAdmin supports / allow / interface, editing data from one to many or ,many to many related tables, using a single phpMyAdmin interface( a single HTML page) I have a (primary) table and one of its fields(category) has one or many values , all these values are also listed in another(secondary) table. I would like to know if phpMyAdmin provides any interface such that those values from the secondary table appears(listed) (for example : as a Form) in the field of the primary table. PrimaryTable(X,Y,category,Z) pk:X SecondaryTable(category)pk:category I am not intending to enforce referential integrity. My question is just about the interfacing. Thank you, Phani. From: Ryan Jameson (USA) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Please help - Managing relational tables using PHP Date: Thu, 2 Jan 2003 13:32:15 -0700 You need to realize that phpMyAdmin is a database manangement tool, not a database. So I'll answer your questions based on the mySQL database ... 1. MySQL 3.23.43b introduced a table type of InnoDB which is the first to allow foreign key constraints. http://www.mysql.com/doc/en/SEC448.html ... However, you do not need to enforce constraints to have a relationship. I just assume that's what you're getting at. 2. Yes, if you enforce constraints with the CASCADE option it will. ..see same document: http://www.mysql.com/doc/en/SEC448.html ... Now the catch, my version of phpMyAdmin 2.3.0 does not allow me to choose the table type of InnoDB, even though my database is version 3.23.54. So I assume phpMyAdmin does not allow one to manage these attributes. Someone please correct me if I'm wrong. Ryan -Original Message- From: Phanivas Vemuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:50 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Please help - Managing relational tables using PHP hi all, 1. How does phpMyAdmin manage tables with one to many or many to one relation ships. Is there any documentation about this. --or- 2. Does phpMyAdmin support editing data from more than one table that have a one to many or many to one relationship. Thanks and Wish you a happy new year, Phani. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Please help - Managing relational tables using PHP
Well, you can use the SQL tab to write a sql statement to do whatever you want, but no, the graphical interface doesn't appear to do that. Phanivas Vemuri [EMAIL PROTECTED]To: [EMAIL PROTECTED], [EMAIL PROTECTED] m cc: Subject: RE: [PHP-DB] Please help - Managing relational tables using PHP 01/02/03 04:34 PM Dear Mr. Ryan, May be I did not present my question clearly to you. My question in detail is ... -- Does phpMyAdmin supports / allow / interface, editing data from one to many or ,many to many related tables, using a single phpMyAdmin interface( a single HTML page) I have a (primary) table and one of its fields(category) has one or many values , all these values are also listed in another(secondary) table. I would like to know if phpMyAdmin provides any interface such that those values from the secondary table appears(listed) (for example : as a Form) in the field of the primary table. PrimaryTable(X,Y,category,Z) pk:X SecondaryTable(category)pk:category I am not intending to enforce referential integrity. My question is just about the interfacing. Thank you, Phani. From: Ryan Jameson (USA) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Please help - Managing relational tables using PHP Date: Thu, 2 Jan 2003 13:32:15 -0700 You need to realize that phpMyAdmin is a database manangement tool, not a database. So I'll answer your questions based on the mySQL database ... 1. MySQL 3.23.43b introduced a table type of InnoDB which is the first to allow foreign key constraints. http://www.mysql.com/doc/en/SEC448.html ... However, you do not need to enforce constraints to have a relationship. I just assume that's what you're getting at. 2. Yes, if you enforce constraints with the CASCADE option it will. ..see same document: http://www.mysql.com/doc/en/SEC448.html ... Now the catch, my version of phpMyAdmin 2.3.0 does not allow me to choose the table type of InnoDB, even though my database is version 3.23.54. So I assume phpMyAdmin does not allow one to manage these attributes. Someone please correct me if I'm wrong. Ryan -Original Message- From: Phanivas Vemuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:50 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Please help - Managing relational tables using PHP hi all, 1. How does phpMyAdmin manage tables with one to many or many to one relation ships. Is there any documentation about this. --or- 2. Does phpMyAdmin support editing data from more than one table that have a one to many or many to one relationship. Thanks and Wish you a happy new year, Phani. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Niles Audio Corporation This mail is confidential -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php