WIRKING WITH TWO DATABASES TOGETHER IN ONE PLACE USING PHP
output of using two databases together Hi everyone working with two database is relay easy and quite impotent. In this case i just take example of teacher and student. At first we make two tables 1 for student and other for teacher. create a database and paste the following sql command to create the two tables ***************************************************************************** Student table CREATE TABLE IF NOT EXISTS `student` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT, `student_id` int ( 11 ) NOT NULL , `name` varchar ( 50 ) NOT NULL , `teacher_id` int ( 20 ) NOT NULL , `visibality` int ( 5 ) NOT NULL , ` image ` varchar ( 100 ) NOT NULL , PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 46 ; -- -- Dumping data for table `student` -- INSERT INTO `student` (`id`, `student_id`, `name`, `teacher_id`, `visibality`, ` image `) VALUES ( 1 , 1 , 'Rahul Sen' , 1 , 1 , '' ), ( 2 , 2 , ...
Comments
Post a Comment