hello
my problem is
i have two different databases but the same table and fields
dbname1: headoffice-----------------dbname2: branch
tblname: tblemployees---------------tblname: tblemployees
the dbname1(headoffice) is the updated table.
my problem is how to code so that my dbname2(branch) will be also updated…
note:
the branch will be the one who update their database not the headoffice tnx
AFAIK u can’t run one query over to databases, so u have to run the query twice. running mysql_select_db in between.
i got it Q1712
this is what i do
<?
# DB sa HO
$ho=mysql_connect("headoffice","user","pass") or die (mysql_error());
mysql_select_db ("hr");
$branch_code='CTM'; /// branch code..
$branch_name='CITI HARDWARE MATINA'; /// branch name
$department_id='33'; /// department ID
$department_desc='Z-Citihardware matina';
$hr_q=mysql_query("SELECT * FROM tblemployees WHERE deptID='$department_id' ORDER BY ndex",$ho);
while ($data=mysql_fetch_array($hr_q)){
$myempid=$data['EmpID'];
$mylname=$data['lname'];
$myfname=$data['fname'];
$mymi=$data['mi'];
$mydeptid=$data['deptID'];
$mymanleave=$data['manleave'];
$mysickleave=$data['sickleave'];
$myvacleave=$data['vacleave'];
$mytayp=$data['tayp'];
$mybasicpay=$data['basicpay'];
$mypaytype=$data['paytype'];
$myemployed=$data['employed'];
$myempexprd=$data['empexprd'];
$mycstatus=$data['cstatus'];
$mydependents=$data['dependents'];
$myb_date=$data['b_date'];
$myhomeadd=$data['homeadd'];
$mycontactno=$data['contactno'];
$myrestday=$data['restday'];
$myempstat=$data['empstat'];
$mysssno=$data['sssno'];
$mytinno=$data['tinno'];
$mypagibigno=$data['pagibigno'];
$myphilhno=$data['philhno'];
$mybloodtype=$data['bloodtype'];
$mymbaccntnum=$data['mbaccntnum'];
$mymbbrcode=$data['mbbrcode'];
$mydesignation=$data['designation'];
$myemp_class=$data['emp_class'];
$ndex=$data['ndex'];
# DB sa BRANCH
$branch=mysql_connect("branch","user","pass") or die (mysql_error());
mysql_select_db ("dtrb");
$hr_q2=mysql_num_rows(mysql_query("SELECT * FROM tblemployees WHERE ndex='$ndex'",$branch));
if ($hr_q2==0){ ## copy employee to branch table....
$instobranch=mysql_query("INSERT INTO tblemployees(EmpID,lname,fname,mi,deptID,manleave,sickleave,vacleave,tayp,basicpay,paytype,employed,empexprd,cstatus,dependents,b_date,homeadd,contactno,restday,empstat,sssno,tinno,pagibigno,philhno,bloodtype,mbaccntnum,mbbrcode,designation,emp_class,ndex) VALUES('$myempid','$mylname','$myfname','$mymi','$mydeptid','$mymanleave','$mysickleave','$myvacleave','$mytayp','$mybasicpay','$mypaytype','$myemployed','$myempexprd','$mycstatus','$mydependents','$myb_date','$myhomeadd','$mycontactno','$myrestday','$myempstat','$mysssno','$mytinno','$mypagibigno','$myphilhno','$mybloodtype','$mymbaccntnum','$mymbbrcode','$mydesignation','$myemp_class','$ndex')",$branch);
} else {
$updbranch=mysql_query("UPDATE tblemployees SET EmpID='$myempid',lname='$mylname',fname='$myfname',mi='$mymi',deptID='$mydeptid',manleave='$mymanleave',sickleave='$mysickleave',vacleave='$myvacleave',tayp='$mytayp',basicpay='$mybasicpay',paytype='$mypaytype',employed='$myemployed',empexprd='$myempexprd',cstatus='$mycstatus',dependents='$mydependents',b_date='$myb_date',homeadd='$myhomeadd',contactno='$mycontactno',restday='$myrestday',empstat='$myempstat',sssno='$mysssno',tinno='$mytinno',pagibigno='$mypagibigno',philhno='$myphilhno',bloodtype='$mybloodtype',mbaccntnum='$mymbaccntnum',mbbrcode='$mymbbrcode',designation='$mydesignation',emp_class='$myemp_class' WHERE ndex='$ndex'",$branch);
}
echo "<script language=JavaScript>window.close()</script>";
}
?>