function updatesave($pararray, $listarray, $menu, $show, $chkpreis, $menugrp) { echo "<a href='showtab.php?menu=" . $menu . "&menugrp=" . $menugrp . "' class='btn btn-primary btn-sm active' role='button'>Liste</a>"; $db = dbopen('../', '../data/mysqlitesync.db'); $sql = "UPDATE " . $pararray['dbtable'] . " SET "; $strfld = ""; $strval = ""; foreach ($listarray as $arrelement) { if ($arrelement['fieldsave'] != "NO") { if ($strfld == "") { $strfld = $arrelement['dbfield']; $strval = "'" . $_POST[$arrelement['dbfield']] . "'"; } else { if ($arrelement['type'] != "icon") { $strfld = $strfld . "," . $arrelement['dbfield']; $strval = $strval . ",'" . $_POST[$arrelement['dbfield']] . "'"; } } switch ($arrelement['type']) { case 'text': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'JN': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'zahl': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'selectid': $wert = $_POST[$arrelement['name']]; if ($wert == "(ohne)") { $wert = 0; } $sql = $sql . $arrelement['dbfield'] . "='" . $wert . "', "; break; case 'select': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['name']] . "', "; break; case 'time': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'date': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'calc': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'proz': $sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', "; break; case 'timestamp': $sql = $sql . $arrelement['dbfield'] . "=CURRENT_TIMESTAMP, "; break; case 'prozref': $sqlfil = "SELECT * FROM tblfilter WHERE fldtablename='tblorte' AND fldfeld='fldid_suchobj'"; echo $sqlfil . "<br>"; $resfil = $db->query($sqlfil); if ($rowfil = $resfil->fetchArray()) { if ($rowfil['fldwert'] != "(ohne)") { $sqlsuch = "SELECT * FROM tblsuchobj WHERE fldbez='" . $rowfil['fldwert'] . "'"; $ressuch = $db->query($sqlsuch); if ($rowsuch = $ressuch->fetchArray()) { $refwhere = "fldid_suchobj=" . $rowsuch['fldindex'] . " AND fldid_orte=" . $_POST['id']; $sqlref = "SELECT * FROM tblrefsuchobj WHERE " . $refwhere; $resref = $db->query($sqlref); if ($rowref = $resref->fetchArray()) { $sqlupdref = "UPDATE tblrefsuchobj SET " . $arrelement['dbfield'] . "=" . $_POST[$arrelement['dbfield']] . ",fldtyp='" . $arrelement['reftyp'] . "',fldid_moebel=" . $_POST['moebel'] . ",fldid_zimmer=" . $_POST['zimmer'] . " AND fldid_etage=" . $_POST['etage'] . " WHERE " . $refwhere; } else { $sqlupdref = "INSERT INTO tblrefsuchobj (fldid_suchobj,fldid_orte," . $arrelement['dbfield'] . ",fldtyp) VALUES(" . $rowsuch['fldindex'] . "," . $_POST['id'] . ",'" . $_POST[$arrelement['dbfield']] . "','" . $arrelement['reftyp'] . "')"; } echo "<div class='alert alert-success'>"; echo $sqlupdref . "=prozref"; echo "</div>"; //$reserr = $db->exec($sqlupdref); } } } break; } } } $sql = substr($sql, 0, -2); $sql = $sql . " WHERE fldindex=" . $_POST['id']; $query = $db->exec($sql); if ($pararray['chkpreis'] == "J") { if ($chkpreis == "preis") { $rowid = $_POST['id']; updatepreis($rowid, $show); } } $dscopy = $_POST['dscopy']; //echo $dscopy."=dscopy?<br>"; if ($dscopy == "dscopy") { $qrycopy = "INSERT INTO " . $pararray['dbtable'] . " (" . $strfld . ") VALUES(" . $strval . ") "; echo "<div class='alert alert-success'>"; echo $qrycopy . "<br>"; echo "</div>"; $query = $db->exec($qrycopy); //mysql_query($qrycopy) or die("Error using mysql_query($qrycopy): ".mysql_error()); } if ($show == "anzeigen") { echo "<div class='alert alert-success'>"; echo $db->lastErrorMsg() . "<br>"; echo $sql . "<br>"; echo "</div>"; } $fldbez = "fldbez"; if ($pararray['fldbez'] != "") { $fldbez = $pararray['fldbez']; } echo "<div class='alert alert-success'>"; echo "Daten '" . $_POST[$fldbez] . "' aktualisiert."; echo "</div>"; }
function insertsave($pararray, $listarray, $menu, $show, $autoinc_step, $autoinc_start, $menugrp) { echo "<a href='showtab.php?menu=" . $menu . "&menugrp=" . $menugrp . "' class='btn btn-primary btn-sm active' role='button'>Liste</a>"; $db = dbopen('../', '../data/mysqlitesync.db'); // echo $db->lastErrorMsg()."<br>"; //$sqlid = "select ".$pararray['fldindex']." from ".$pararray['dbtable']." order by ".$pararray['fldindex']." desc limit 1"; $sqlid = "SELECT * FROM tblindex WHERE fldtable='" . $pararray['dbtable'] . "'"; $results = $db->query($sqlid); if ($row = $results->fetchArray()) { $newrowid = $row['fldid'] + $autoinc_step; //echo $newrowid."=newrowid<br>"; } else { $newrowid = $autoinc_start; } $prozref = "N"; $dbtable = $pararray['dbtable']; $sql = "INSERT INTO " . $dbtable . " (" . $pararray['fldindex'] . ","; foreach ($listarray as $arrelement) { if ($arrelement['fieldsave'] != "NO") { switch ($arrelement['type']) { case 'text': $sql = $sql . $arrelement['dbfield'] . ","; break; case 'select': $sql = $sql . $arrelement['dbfield'] . ","; break; case 'selectid': $sql = $sql . $arrelement['dbfield'] . ","; break; case 'time': $sql = $sql . $arrelement['dbfield'] . ","; break; case 'date': $sql = $sql . $arrelement['dbfield'] . ","; break; case 'calc': $sql = $sql . $arrelement['dbfield'] . ","; break; case 'timestamp': $sql = $sql . $arrelement['dbfield'] . ","; break; } } } $sql = substr($sql, 0, -1) . ") VALUES (" . $newrowid . ","; foreach ($listarray as $arrelement) { if ($arrelement['fieldsave'] != "NO") { switch ($arrelement['type']) { case 'text': $sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',"; break; case 'selectid': $sql = $sql . "'" . $_POST[$arrelement['name']] . "',"; break; case 'select': $sql = $sql . "'" . $_POST[$arrelement['name']] . "',"; break; case 'time': $sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',"; break; case 'date': $sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',"; break; case 'calc': $sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',"; break; case 'timestamp': $sql = $sql . "CURRENT_TIMESTAMP,"; break; case 'prozref': $prozref = "J"; $dbfield = $arrelement['dbfield']; break; } } } $sql = substr($sql, 0, -1) . ")"; //echo $sql."<br>"; $db->exec($sql); $sqlid = "SELECT last_insert_rowid() as lastid FROM " . $pararray['dbtable']; $results = $db->query($sqlid); if ($row = $results->fetchArray()) { $rowid = $row[0]; //echo $rowid."=rowid<br>"; } if ($show == "anzeigen") { echo "<div class='alert alert-success'>"; echo $sql . "<br>"; echo $db->lastErrorMsg() . "<br>"; echo "</div>"; } if ($prozref == "J") { $sqlfil = "SELECT * FROM tblfilter WHERE fldtablename='tblorte' AND fldfeld='fldid_suchobj'"; $resfil = $db->query($sqlfil); if ($rowfil = $resfil->fetchArray()) { if ($rowfil['fldwert'] != "(ohne)") { $sqlsuch = "SELECT * FROM tblsuchobj WHERE fldbez='" . $rowfil['fldwert'] . "'"; $ressuch = $db->query($sqlsuch); if ($rowsuch = $ressuch->fetchArray()) { $refwhere = "fldid_suchobj=" . $rowsuch['fldindex'] . " AND fldid_orte=" . $rowid; $sqlref = "SELECT * FROM tblrefsuchobj WHERE " . $refwhere; $resref = $db->query($sqlref); if ($rowref = $resref->fetchArray()) { $sqlupdref = "UPDATE tblrefsuchobj SET " . $dbfield . "=" . $_POST[$dbfield] . " WHERE " . $refwhere; } else { $sqlupdref = "INSERT INTO tblrefsuchobj (fldid_suchobj,fldid_orte," . $dbfield . ") VALUES(" . $rowsuch['fldindex'] . "," . $rowid . ",'" . $_POST[$dbfield] . "')"; } } } } echo "<div class='alert alert-success'>"; echo $sqlupdref . "=prozref"; echo "</div>"; $reserr = $db->exec($sqlupdref); } if ($newrowid == $autoinc_start) { $sqlupd = "INSERT INTO tblindex (fldtable,fldid) VALUES('" . $pararray['dbtable'] . "'," . $newrowid . ")"; } else { $sqlupd = "UPDATE tblindex SET fldid=" . $newrowid . " WHERE fldtable='" . $pararray['dbtable'] . "'"; } //echo $sqlupd."<br>"; $resupd = $db->exec($sqlupd); $db->close(); //echo $pararray['chkpreis']."=chkpreis<br>"; if ($pararray['chkpreis'] == "J") { updatepreis($rowid); } echo "<div class='alert alert-success'>"; echo "Daten '" . $_POST['fldBez'] . "' mit rowid=" . $rowid . " eingefügt."; echo "</div>"; }