Create a Relationship Example
Consider the following tables (and SQL insert statements):
CREATE TABLE tblGenres( pkGenreID INT PRIMARY KEY AUTO_INCREMENT, fldGenre VARCHAR(40) ); CREATE TABLE tblMyMp3CollectionDemo2( pkMP3ID INT PRIMARY KEY AUTO_INCREMENT, fldFilename VARCHAR(150), fldTitle VARCHAR(60), fldArtist VARCHAR(60), fkGenreID INT ); INSERT INTO tblGenres (fldGenre) VALUES ("Rock"); INSERT INTO tblGenres (fldGenre) VALUES ("Pop"); INSERT INTO tblGenres (fldGenre) VALUES ("Euro Trash"); INSERT INTO tblGenres (fldGenre) VALUES ("Sweedish HipHop");
fldFilename | fldTitle | fldArtist | fkGenreID | Action |
---|---|---|---|---|
x | x | x | Euro Trash | |
-- | -- | -- | -- | |
-- | -- | -- | -- | |
-- | -- | -- | -- | |
-- | -- | -- | -- | |
-- | -- | -- | -- | |
-- | -- | -- | -- |
Class Implementation:
#include the class
include ('ajaxCRUD.class.php');
#this one line of code is how you implement the class
$tblDemo = new ajaxCRUD(
"MP3 File", "tblMyMp3CollectionDemo2", "pkMP3ID");
$tblDemo->defineRelationship("fkGenreID", "tblGenres", "pkGenreID",
"fldGenre");
$tblDemo->omitPrimaryKey();
#actually show to the table
$tblDemo->showTable();
View Example by Itself
Click here to view example outside of the template.
Recent Feedback
Amigo" - Posted by Horacio from méxico on Tuesday Aug 12th, 2008 at 3:23pm
Are you still working on it?" - Posted by Omar on Monday May 11th, 2009 at 1:03am