What's new
  • Welcome to PHCorner forums. Take a moment to sign up and gain unlimited access and extra privileges that guests are not entitled to, such as: All that and more! Registration is quick, simple and absolutely free. Join our community today!

Help Student record system using codeigniter framework

vortex78

Addict
Joined
Apr 14, 2017
Messages
433
Reaction
92
Age
23
mga idol nagawa po kasi ako ng system ngayon about student record management system. tapos po yung student information at student record ay magkabukod ang database table. ask ko lang po mga idol. pano po kaya madidisplay yung laman nung 2 database table through ID para makita ang record ng bawat student. maraming salamat po mga idol. sana matulongan nyu ako.
 

La Freak

Forum Expert
Using mysql

Code:
SELECT <...>
FROM A.table1 t1 JOIN B.table2 t2 ON t2.column2 = t1.column1;

*Depende na po sa ID ng table at ID ng item kung specific ang pag display nyo
 
Comment

vortex78

Addict
Using mysql

Code:
SELECT <...>
FROM A.table1 t1 JOIN B.table2 t2 ON t2.column2 = t1.column1;

*Depende na po sa ID ng table at ID ng item kung specific ang pag display nyo
naka foreign key yung id idol. pwede kaya sa codeigniter yan?
 
Comment

landz20

Leecher
try this code:

$this->db->join('table1', 'table1.id' = 'table2.id');
$query = $this->db->get();

return $query->result_array();
 
Comment

vortex78

Addict
try this code:

$this->db->join('table1', 'table1.id' = 'table2.id');
$query = $this->db->get();

return $query->result_array();
yan yung way para magsamahin sila diba idol? pano yung pagdidisplay ng laman nan. na yung bawat id lang ang didisplay
 
Comment

Online statistics

Members online
650
Guests online
1,833
Total visitors
2,483

Forum statistics

Threads
1,069,401
Messages
18,092,120
Members
1,515,071
Comments
1,068,325
Attachments
1,382,909
Profile posts
97,553
Top