php - How do I join tables from two different PDO object? -


i don't know how must join tables 2 different pdo object. hope of can me solve problem. respons.

$dbsql = new pdo('mysql:host=localhost;dbname=dbpenggajian', $user='root', $pass='');  $dbaccess = new pdo("odbc:driver={microsoft access driver (*.mdb)};dbq=d:\\kepegawaian arto moro\back_up_absensi\tj_main_data.mdb; uid=username;pwd=everyday;"); 

and experiment code

$acc=$dbaccess+$dbsql->query("select *                     dbaccess.hr_personnel h                     right join dbaccess.ta_record_info                     on h.id=a.per_id                     inner join dbsql.pegawai_tetap p                     on h.per_code=p.nip ;");     while($k=$acc->fetch(pdo::fetch_assoc)){ 

but still error

fatal error: call member function fetch() on non-object

please me. thanks

that's impossible, of course.

you have import odbc table in mysql first.


Comments

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

gcc - Calling fftR4() in c from assembly -

Function that returns a formatted array in VBA -