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
Post a Comment