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();