Tuesday, 27 August 2013

Error syncing MSSQL to MySQL

Error syncing MSSQL to MySQL

I want to synchronize my database from MSSQL to Mysql, but I'm getting the
following error:
Fatal error: Only variables can be passed by reference in php on line 36
Here is my code:
// connect to MSSQL
$koneksi=mssql_connect($server,$username,$password);
$sqldb=mssql_select_db($database,$koneksi);
// connect to MySQL
$koneksi2 = mysqli_connect($server2,$username2,$password2,$database2,$port);
// copy data from MSSQL to MySQL
$query2 = mssql_query("Select Jabatan, Nama, NIP from
PejabatPenetap",$koneksi);
while($r=mssql_fetch_array($query2)) {
$jabatan = $r['Jabatan'];
$nama = $r['Nama'];
$nip = $r['NIP'];
$stmt = mysqli_prepare($koneksi2, 'StoreProcedure');
mysqli_bind_param($stmt, '@jabatan', $jabatan, SQLVARCHAR, false,
false, 255); <-- this is line 36
mysqli_bind_param($stmt, '@nama_input', $nama, SQLVARCHAR, false,
false, 100);
mysqli_bind_param($stmt, '@nip', $nip, SQLVARCHAR, false, false, 25);
$res = mysqli_stmt_execute($stmt);
}

No comments:

Post a Comment