function syncempfangen($database, $nuranzeigen, $datcntremote, $dbtable, $fldindex, $timestamp)
{
$db = new SQLite3('../data/' . $database);
$dbtyp = "MYSQL";
$dbase = "dbjoorgportal";
$dbuser = "******";
$dbpassword = "******";
$dbremote = dbopentyp($dbtyp, $dbase, $dbuser, $dbpassword);
echo "<div class='alert alert-success'>";
echo $datcntremote . " Datensätze empfangen am " . $timestamp . "<br>";
for ($i = 1; $i <= $datcntremote; $i++) {
echo "<div class='alert alert-success'>";
$index = $_POST['index' . $i];
$qryval = "SELECT * FROM " . $dbtable . " WHERE " . $fldindex . "=" . $index;
echo $qryval . "<br>";
// $results = $db->query($qryval);
$results = dbquerytyp($dbtyp, $dbase, $qryval);
if ($linval = dbfetchtyp($dbtyp, $results)) {
$sql = $_POST['updsql' . $i];
} else {
$sql = $_POST['inssql' . $i];
}
$sql = str_replace("#", "'", $sql);
echo $sql . "<br>";
echo "</div>";
if ($nuranzeigen != "anzeigen") {
//$query = $db->exec($sql);
dbexecutetyp($dbtyp, $dbremote, $sql);
}
}
echo "</div>";
syncfertig($database, $nuranzeigen, $dbtable, $timestamp);
}
bootstrapbegin("Datenaustausch");
echo "<a href='showtab.php?menu=" . $menu . "' class='btn btn-primary btn-sm active' role='button'>Zurück</a> ";
$fldindex = $pararray['fldindex'];
//$pfad="localhost:8080/own/mysync/classes/";
switch ($status) {
case 'local':
$urladr = $_POST['urladr'];
$nuranzeigen = $_POST['nuranzeigen'];
synclocal($database, $menu, $urladr, $pfad, $nuranzeigen);
break;
case 'senden':
syncsenden();
break;
case 'empfangen':
$datcntremote = $_POST['datcntremote'];
$nuranzeigen = $_POST['nuranzeigen'];
$dbtable = $_POST['dbtable'];
$fldindex = $_POST['dbindex'];
$timestamp = $_POST['timestamp'];
syncempfangen($database, $nuranzeigen, $datcntremote, $dbtable, $fldindex, $timestamp);
break;
case 'fertig':
$nuranzeigen = $_POST['nuranzeigen'];
$dbtable = $_POST['dbtable'];
$timestamp = $_POST['timestamp'];
syncfertig($database, $nuranzeigen, $dbtable, $timestamp);
break;
default:
syncauswahl($database, $menu);
}
bootstrapend();
