";
$tablemidbit="| " . $formbits;
}
} else if (sizeof($ddlb) > 1) {
if (strlen(str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0]))) > 0) {
$initialrec="";
if ((sizeof($ddlis) > 1) && strpos(str_replace("http:","",str_replace("https:","",$hshr)),$hrvs) !== false) {
$xddl_table=explode("(",explode(",",explode(";",explode(" ",$ddlis[1])[0])[0])[0])[0];
$xddl_owner=str_replace("http:","",str_replace("https:","",$hshr));
if (sizeof($ddlb) >= 4 && $xddl_table == $ddl_table && $xddl_owner == $ddl_owner) {
$tnis=$xddl_table;
$initialrec=str_replace("`","",str_replace("`'","",str_replace("'`","",str_replace("','",",",("`" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[-1 + sizeof($ddlb)])[0])) . "`")))));
$ddlis=explode("(", " ");
}
}
$ndelim="";
//if (str_replace("\n","",$bits[3]) != "") $ndelim="~";
if (isset($_POST['listddl'])) {
if (strlen($_POST['listddl']) == 0) {
$pp=rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|" . "" . "\n`";
$ppb=rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|";
file_put_contents($fis, rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|" . lastmapping("",rtrim($dbrecs[$i]),$ndelim,$initialrec,str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0]))) . "\n`");
} else {
$pp=rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";" . urldecode($_POST['listddl']) . "\n|" . "" . "\n`";
$ppb=rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";" . urldecode($_POST['listddl']) . "\n|";
file_put_contents($fis, rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";" . urldecode($_POST['listddl']) . "\n|" . lastmapping("",rtrim($dbrecs[$i]),$ndelim,$initialrec,str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0]))) . "\n`");
}
} else {
$pp=rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|" . "" . "\n`";
$ppb=rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|";
file_put_contents($fis, rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|" . lastmapping("",rtrim($dbrecs[$i]),$ndelim,$initialrec,str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0]))) . "\n`");
}
//file_put_contents($fis, rtrim($datais) . "\n" . $ddl_table . "\n|" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n|" . $ddl_owner . "^" . $_SERVER['REMOTE_ADDR'] . ";\n|" . lastmapping(rtrim($dbrecs[$i]) . $ndelim . $initialrec,rtrim($dbrecs[$i]),$ndelim,$initialrec,str_replace("\n","",$bits[1])) . "\n`");
//file_put_contents($fis, $ppb . lastmapping("",rtrim($ppb),$ndelim,$initialrec,str_replace("\n","",str_replace("'","",explode(")",$ddlb[1])[0])) . "\n`"));
if ($initialrec != "") {
$initialrec="";
$insql="SELECT * FROM " . $ddl_table;
if (str_replace("\n","",$bits[0]) == explode(" ",$tnis)[0] && sizeof($bits) == 4 && strpos($insql,"SELECT * FROM ") !== false && strpos($insql,"_poll") !== false) {
$themes=explode(" ",str_replace("moviegenre","Favourite Movie Genre",str_replace("_"," ",str_replace("_poll","",str_replace("\n","",$bits[0])))));
$htitle="";
$hdelim="";
for ($ih=0; $ih 1) {
$htitle.=$hdelim . strtoupper(substr($themes[$ih],0,1)) . strtolower(substr($themes[$ih],1));
} else {
$htitle.=$hdelim . $themes[$ih];
}
$hdelim=" ";
}
$bonload=" onload=\" document.getElementById('mys').click();\" ";
$hdatas=explode("~",str_replace("\n","",$bits[3]));
$hdata="";
$hdelim=",";
for ($ih=0; $ih
";
$tablemidbit=" | " . $formbits;
}
}
$datais=@file_get_contents($fis);
$dbrecs=explode("`", $datais);
$ddl_exists=true;
}
}
}
if ((sizeof($ddlis) > 1) && strpos(str_replace("http:","",str_replace("https:","",$hshr)),$hrvs) !== false) {
$ddl_table=explode("(",explode(",",explode(";",explode(" ",$ddlis[1])[0])[0])[0])[0];
$tnis=$ddl_table;
$ddl_owner=str_replace("http:","",str_replace("https:","",$hshr));
for ($ij=0; $ij can not be processed without a preceeding CREATE TABLE " . $ddl_table . " (colname1,colname2,colname3) type of Flat File DDL SQL statement.";
$insql="SELECT * FROM " . $ddl_table;
if (str_replace("\n","",$bits[0]) == explode(" ",$tnis)[0] && sizeof($bits) == 4 && strpos($insql,"SELECT * FROM ") !== false && strpos($insql,"_poll") !== false) {
$themes=explode(" ",str_replace("moviegenre","Favourite Movie Genre",str_replace("_"," ",str_replace("_poll","",str_replace("\n","",$bits[0])))));
$htitle="";
$hdelim="";
for ($ih=0; $ih 1) {
$htitle.=$hdelim . strtoupper(substr($themes[$ih],0,1)) . strtolower(substr($themes[$ih],1));
} else {
$htitle.=$hdelim . $themes[$ih];
}
$hdelim=" ";
}
$bonload=" onload=\" document.getElementById('mys').click();\" ";
$hdatas=explode("~",str_replace("\n","",$bits[3]));
$hdata="";
$hdelim=",";
for ($ih=0; $ih
";
$tablemidbit=" | " . $formbits;
}
} else if (sizeof($ddlb) >= 3) {
$initialrec=str_replace("`","",str_replace("`'","",str_replace("'`","",str_replace("','",",",("`" . str_replace("\n","",str_replace("'","",explode(")",$ddlb[-1 + sizeof($ddlb)])[0])) . "`")))));
}
}
}
for ($i=0; $i 1) {
$htitle.=$hdelim . strtoupper(substr($themes[$ih],0,1)) . strtolower(substr($themes[$ih],1));
} else {
$htitle.=$hdelim . $themes[$ih];
}
$hdelim=" ";
}
$bonload=" onload=\" document.getElementById('mys').click();\" ";
$hdatas=explode("~",str_replace("\n","",$bits[3]));
$hdata="";
$hdelim=",";
for ($ih=0; $ih
";
$tablemidbit=" | " . $formbits;
}
}
}
}
$ucollistbit="";
$uwcollistbit="";
$collistbit="";
$blanks="";
$dl="";
$cdl="'";
$acdl="";
$aacdl="";
$eqetc="";
$andor="";
$selgen="";
$colblanks=explode(",",str_replace("\n","",$bits[1]));
if (str_replace("\n","",$bits[0]) == explode(" ",$tnis)[0] && sizeof($bits) == 4 && strpos($insql,"SELECT * FROM ") !== false && strpos($insql,"_poll") !== false) {
$themes=explode(" ",str_replace("moviegenre","Favourite Movie Genre",str_replace("_"," ",str_replace("_poll","",str_replace("\n","",$bits[0])))));
$htitle="";
$hdelim="";
for ($ih=0; $ih 1) {
$htitle.=$hdelim . strtoupper(substr($themes[$ih],0,1)) . strtolower(substr($themes[$ih],1));
} else {
$htitle.=$hdelim . $themes[$ih];
}
$hdelim=" ";
}
$bonload=" onload=\" document.getElementById('mys').click();\" ";
$hdatas=explode("~",str_replace("\n","",$bits[3]));
$hdata="";
$hdelim=",";
for ($ih=0; $ih
";
$tablemidbit=" | " . $formbits;
}
if (sizeof($bits) == 4 && isset($_POST['isql']) && str_replace("\n","",$bits[0]) == $tnis) {
$insql.=" (" . str_replace("\n","",$bits[1]) . ") VALUES (";
$rows=explode("~",rtrim($bits[3]));
if (str_replace("\n","",$bits[3]) != "") {
if ($irecord == "") $irecord="~";
}
}
$idelim="";
for ($ii=0; $ii","",$selgen);
if ($ii == 0) { // update where
if (!isset($_POST['nw' . $colblanks[$ii]]) && isset($_POST['usql']) && str_replace("\n","",$bits[0]) == $tnis) {
$updatenow=0;
} else if (isset($_POST['eqq' . $colblanks[$ii]]) && isset($_POST['nw' . $colblanks[$ii]]) && isset($_POST['usql']) && str_replace("\n","",$bits[0]) == $tnis) {
if (isset($_POST['ao' . $colblanks[$ii]])) $cwhereao=urldecode($_POST['ao' . $colblanks[$ii]]);
$cwherefld=urldecode($_POST['nw' . $colblanks[$ii]]);
$cwhereeq=urldecode($_POST['eqq' . $colblanks[$ii]]);
$cwhereval=urldecode($_POST['ux_' . $colblanks[$ii]]);
$cwhereset=" SET " . urldecode($_POST['un' . $colblanks[$ii]]) . "='" . urldecode($_POST['u' . $colblanks[$ii]]) . "'";
$cwheretrues="0";
$cwheretrue=true;
$cwheredelim=",";
$bitsd=str_replace("\n","",$bits[3]);
$insql=str_replace(" SET 1=1 WHERE 1=1","",$insql) . " WHERE " . $cwherefld . $cwhereeq . "'" . $cwhereval . "'";
}
} else if ($cwheredelim != "" && isset($_POST['nw' . $colblanks[$ii]]) && isset($_POST['usql']) && str_replace("\n","",$bits[0]) == $tnis) {
if (isset($_POST['ao' . $colblanks[$ii]])) $cwhereao.=$cwheredelim . urldecode($_POST['ao' . $colblanks[$ii]]);
$cwherefld.=$cwheredelim . urldecode($_POST['nw' . $colblanks[$ii]]);
$cwhereeq.=$cwheredelim . urldecode($_POST['eqq' . $colblanks[$ii]]);
$cwhereval.=$cwheredelim . urldecode($_POST['ux_' . $colblanks[$ii]]);
$cwheretrues.=$cwheredelim . "0";
$cwheretrue=true;
$cwheredelim=",";
$bitsd=str_replace("\n","",$bits[3]);
if (isset($_POST['un' . $colblanks[$ii]])) $cwhereset.=$cwheredelim . urldecode($_POST['un' . $colblanks[$ii]]) . "='" . urldecode($_POST['u' . $colblanks[$ii]]) . "'";
$insql.=" " . urldecode($_POST['ao' . $colblanks[$ii]]) . " " . urldecode($_POST['nw' . $colblanks[$ii]]) . urldecode($_POST['eqq' . $colblanks[$ii]]) . "'" . urldecode($_POST['ux_' . $colblanks[$ii]]) . "'";
} else if ($cwheredelim != "" && isset($_POST['un' . $colblanks[$ii]]) && isset($_POST['usql']) && str_replace("\n","",$bits[0]) == $tnis) {
$cwhereset.=$cwheredelim . urldecode($_POST['un' . $colblanks[$ii]]) . "='" . urldecode($_POST['u' . $colblanks[$ii]]) . "'";
$bitsd=str_replace("\n","",$bits[3]);
}
if ($ii == 0) { // delete where
if (!isset($_POST['ynw' . $colblanks[$ii]]) && isset($_POST['dsql']) && str_replace("\n","",$bits[0]) == $tnis) {
$deletenow=true;
} else if (isset($_POST['yeqq' . $colblanks[$ii]]) && isset($_POST['ynw' . $colblanks[$ii]]) && isset($_POST['dsql']) && str_replace("\n","",$bits[0]) == $tnis) {
if (isset($_POST['yao' . $colblanks[$ii]])) $cwhereao=urldecode($_POST['yao' . $colblanks[$ii]]);
$cwherefld=urldecode($_POST['ynw' . $colblanks[$ii]]);
$cwhereeq=urldecode($_POST['yeqq' . $colblanks[$ii]]);
$cwhereval=urldecode($_POST['yux_' . $colblanks[$ii]]);
$cwheretrues="0";
$cwheretrue=true;
$cwheredelim=",";
$insql.=" WHERE " . $cwherefld . $cwhereeq . "'" . $cwhereval . "'";
$bitsd=str_replace("\n","",$bits[3]);
}
} else if ($cwheredelim != "" && isset($_POST['ynw' . $colblanks[$ii]]) && isset($_POST['dsql']) && str_replace("\n","",$bits[0]) == $tnis) {
if (isset($_POST['yao' . $colblanks[$ii]])) $cwhereao.=$cwheredelim . urldecode($_POST['yao' . $colblanks[$ii]]);
$cwherefld.=$cwheredelim . urldecode($_POST['ynw' . $colblanks[$ii]]);
$cwhereeq.=$cwheredelim . urldecode($_POST['yeqq' . $colblanks[$ii]]);
$cwhereval.=$cwheredelim . urldecode($_POST['yux_' . $colblanks[$ii]]);
$cwheretrues.=$cwheredelim . "0";
$cwheretrue=true;
$cwheredelim=",";
$insql.=" " . urldecode($_POST['yao' . $colblanks[$ii]]) . " " . urldecode($_POST['ynw' . $colblanks[$ii]]) . urldecode($_POST['yeqq' . $colblanks[$ii]]) . "'" . urldecode($_POST['yux_' . $colblanks[$ii]]) . "'";
$bitsd=str_replace("\n","",$bits[3]);
}
if ($ii == 0) { // select where
if (!isset($_POST['knw' . $colblanks[$ii]]) && isset($_POST['ssql']) && str_replace("\n","",$bits[0]) == $tnis) {
$shownow=0;
} else if (isset($_POST['keqq' . $colblanks[$ii]]) && isset($_POST['knw' . $colblanks[$ii]]) && isset($_POST['ssql']) && str_replace("\n","",$bits[0]) == $tnis) {
if (isset($_POST['kao' . $colblanks[$ii]])) $cwhereao==urldecode($_POST['kao' . $colblanks[$ii]]);
$cwherefld=urldecode($_POST['knw' . $colblanks[$ii]]);
$cwhereeq=urldecode($_POST['keqq' . $colblanks[$ii]]);
$cwhereval=urldecode($_POST['kux_' . $colblanks[$ii]]);
$cwheretrues="0";
$cwheretrue=true;
$cwheredelim=",";
$insql.=" WHERE " . $cwherefld . $cwhereeq . "'" . $cwhereval . "'";
}
} else if ($cwheredelim != "" && isset($_POST['knw' . $colblanks[$ii]]) && isset($_POST['ssql']) && str_replace("\n","",$bits[0]) == $tnis) {
if (isset($_POST['kao' . $colblanks[$ii]])) $cwhereao.=$cwheredelim . urldecode($_POST['kao' . $colblanks[$ii]]);
$cwherefld.=$cwheredelim . urldecode($_POST['knw' . $colblanks[$ii]]);
$cwhereeq.=$cwheredelim . urldecode($_POST['keqq' . $colblanks[$ii]]);
$cwhereval.=$cwheredelim . urldecode($_POST['kux_' . $colblanks[$ii]]);
$cwheretrues.=$cwheredelim . "0";
$cwheretrue=true;
$cwheredelim=",";
$insql.=" " . urldecode($_POST['kao' . $colblanks[$ii]]) . " " . urldecode($_POST['knw' . $colblanks[$ii]]) . urldecode($_POST['keqq' . $colblanks[$ii]]) . "'" . urldecode($_POST['kux_' . $colblanks[$ii]]) . "'";
}
if (isset($_POST[$colblanks[$ii]]) && isset($_POST['isql']) && str_replace("\n","",$bits[0]) == $tnis) {
$irecord.=($idelim . str_replace('`','',str_replace('~','',str_replace(',','',str_replace('|','',urldecode($_POST[$colblanks[$ii]]))))));
$insql.=($idelim . "'" . str_replace('`','',str_replace('~','',str_replace(',','',str_replace('|','',urldecode($_POST[$colblanks[$ii]])))))) . "'";
$idelim=",";
}
}
if (isset($_POST['isql']) && sizeof($iwhatisleft) == 2 && str_replace("\n","",$bits[0]) == $tnis) {
$insql.=")";
$newdatais=str_replace(rtrim($dbrecs[$i]), rtrim($dbrecs[$i]) . $irecord, $datais);
file_put_contents($fis, rev_filter($newdatais));
}
if (isset($_POST['dsql']) && sizeof($dwhatisleft) == 2 && str_replace("\n","",$bits[0]) == $tnis && ($deletenow || $bitsd != "")) {
if ($bitsd != "") {
$gotridof="; /* ... got rid of the following record(s) ... */";
$jnum=0;
for ($qi=0; $qi 1) {
$htitle.=$hdelim . strtoupper(substr($themes[$ih],0,1)) . strtolower(substr($themes[$ih],1));
} else {
$htitle.=$hdelim . $themes[$ih];
}
$hdelim=" ";
}
$bonload=" onload=\" document.getElementById('mys').click();\" ";
$hdatas=explode("~",str_replace("\n","",$bits[3]));
$hdata="";
$hdelim=",";
for ($ih=0; $ih
";
$tablemidbit=" | " . $formbits;
}
if (sizeof($bits) == 4) {
$yellow="orange";
$results.=$tableprefix . "
";
$cols=explode(",",$bits[1]);
for ($j=0; $j", "" . str_replace("\n","",$cols[$j]) . " | ", $results);
}
$rows=explode("~",rtrim($bits[3]));
if (rtrim($bits[3]) != "") {
for ($j=0; $j", "| " . ($jnum + 1) . " | ", $results);
$jnum++;
}
for ($jj=0; $jj", "" . reverse_filter($rowcols[$jj]) . " | ", $results);
}
}
}
if ($jnum == 1) {
$results.="" . $jnum . " row selected." . $tablemidbit . $tablesuffix;
} else {
$results.="" . $jnum . " rows selected." . $tablemidbit . $tablesuffix;
}
if ($shownow < 0) $results="No rows found with " . rev_filter($qinsql) . "" . $tablemidbit . $tablesuffix;
} else {
$results="Data table called " . explode(" ",$whatisleft[1])[0] . " found in flat file database has invalid data content.
" . $tablemidbit . $tablesuffix;
}
}
}
//echo $bitsd . "
";
}
$deletenow=true;
if (rtrim($bits[3]) != "") {
if ($bitsd != "") {
//if (strpos(rtrim($dbrecs[$i]),rtrim($bits[3])) !== false) echo "is " . rtrim($bitsd) . " in " . rtrim($dbrecs[$i]);
$newdatais=str_replace(rtrim($dbrecs[$i]), str_replace(rtrim($bits[3]),rtrim($bitsd),rtrim($dbrecs[$i])), $datais);
} else {
$newdatais=str_replace(rtrim($dbrecs[$i]), str_replace(rtrim($bits[3]),"",rtrim($dbrecs[$i])), $datais);
}
file_put_contents($fis, rev_filter($newdatais));
}
}
if (isset($_POST['usql']) && sizeof($uwhatisleft) == 2 && str_replace("\n","",$bits[0]) == $tnis && ($updatenow >= 0 || $bitsd != "")) {
if ($bitsd != "") {
$gotridof="; /* ... updated the following record(s) ... */";
$jnum=0;
for ($qi=0; $qi| # |
|---|
";
$cols=explode(",",$bits[1]);
for ($j=0; $j", "" . str_replace("\n","",$cols[$j]) . " | ", $results);
}
$rows=explode("~",rtrim($bits[3]));
if (rtrim($bits[3]) != "") {
for ($j=0; $j", "| " . ($jnum + 1) . " | ", $results);
$jnum++;
}
for ($jj=0; $jj", "" . reverse_filter($rowcols[$jj]) . " | ", $results);
}
}
}
if ($jnum == 1) {
$results.="" . $jnum . " row selected." . $tablemidbit . $tablesuffix;
} else {
$results.="" . $jnum . " rows selected." . $tablemidbit . $tablesuffix;
}
if ($shownow < 0) $results="No rows found with " . rev_filter($qinsql) . "" . $tablemidbit . $tablesuffix;
} else {
$results="Data table called " . explode(" ",$whatisleft[1])[0] . " found in flat file database has invalid data content.
" . $tablemidbit . $tablesuffix;
}
}
}
//echo $bitsd . "
";
}
$updatenow=0;
if (rtrim($bits[3]) != "") {
if ($bitsd != "") {
//if (strpos(rtrim($dbrecs[$i]),rtrim($bits[3])) !== false) echo "is " . rtrim($bitsd) . " in " . rtrim($dbrecs[$i]);
$newdatais=str_replace(rtrim($dbrecs[$i]), str_replace(rtrim($bits[3]),rtrim($bitsd),rtrim($dbrecs[$i])), $datais);
} else {
$newdatais=str_replace(rtrim($dbrecs[$i]), str_replace(rtrim($bits[3]),"",rtrim($dbrecs[$i])), $datais);
}
file_put_contents($fis, rev_filter($newdatais));
}
}
for ($ii=0; $ii" . str_replace(",","",str_replace(",'","'",$cdl));
$uwcollistbit.=$acdl . str_replace(" value=" . $colblanks[$ii], " selected value=" . $colblanks[$ii], str_replace("?","w" . $colblanks[$ii],$selgen)) . str_replace("?","q" . $colblanks[$ii],$eqetc) . str_replace(",","",$cdl) . "" . str_replace(",","",str_replace(",'","'",$cdl));
$collistbit.=$cdl . "" . str_replace(",","",$cdl);
$dl=",";
$cdl=",'";
if ($ii < (-1 + sizeof($colblanks))) {
$acdl=" " . str_replace("?",$colblanks[1 + $ii],$andor) . " ";
$aacdl=" ";
}
}
$insideoptions.=" ";
if ($thisallowed) $allowed_insideoptions.=" ";
}
}
$ask=" ";
if ($cwhereset != "") {
$insql=str_replace(" WHERE ", " " . $cwhereset . " WHERE ",$insql);
$cwhereset="";
}
if ($datais != "") {
if ($insql != "") {
if (strpos(rev_filter($insql), "UPDATE ") !== false) {
$whatisleft=["",$tnis];
} else {
$whatisleft=explode("SELECT * FROM ", str_replace("DELETE FROM ","SELECT * FROM ",rev_filter($insql)));
}
if (sizeof($whatisleft) > 1) {
if ($whatisleft[1] == "") {
$results=" Nothing much to do. ";
} else if (strpos($insideoptions,">" . explode(" ",$whatisleft[1])[0] . "<") === false) {
$results=" No data table called " . explode(" ",$whatisleft[1])[0] . " found in flat file database. ";
} else {
$results=" Results for ... " . rev_filter($insql) . $gotridof . "";
$jnum=0;
for ($i=0; $i | # |
|---|
";
$cols=explode(",",$bits[1]);
for ($j=0; $j", "" . str_replace("\n","",$cols[$j]) . " | ", $results);
}
$rows=explode("~",rtrim($bits[3]));
if (rtrim($bits[3]) != "") {
for ($j=0; $j", "| " . ($jnum + 1) . " | ", $results);
$jnum++;
}
for ($jj=0; $jj", "" . reverse_filter($rowcols[$jj]) . " | ", $results);
}
}
}
if ($jnum == 1) {
$results.="" . $jnum . " row selected." . $tablemidbit . $tablesuffix;
} else {
$results.="" . $jnum . " rows selected." . $tablemidbit . $tablesuffix;
}
if ($shownow < 0) $results="No rows found with " . rev_filter($insql) . "" . $tablemidbit . $tablesuffix;
} else {
$results="Data table called " . explode(" ",$whatisleft[1])[0] . " found in flat file database has invalid data content.
" . $tablemidbit . $tablesuffix;
}
}
}
}
} else if (isset($_POST['dsql']) && sizeof($dwhatisleft) == 2 && deletenow) {
$results="Record(s) deleted via " . rev_filter($insql) . ";
";
} else if (isset($_POST['usql']) && sizeof($uwhatisleft) == 2) {
if ($cwhereset != "") {
$insql=str_replace(" WHERE ", " " . $cwhereset . " WHERE ",$insql);
$cwhereset="";
}
$results="Record(s) updated via " . rev_filter($insql) . ";
";
} else if (isset($_POST['isql']) && sizeof($iwhatisleft) == 2) {
$results="Record inserted via " . rev_filter($insql) . ";
";
} else {
$results="Nothing to do for " . rev_filter($insql) . ";
";
}
}
echo "Flat file data source engine - RJM Programming - April, 2017 var ltitle='ClickDeletes'; " . $cfilter . " function oc(othis) { if (ltitle == 'ClickDeletes') { othis.innerHTML=String.fromCharCode(32); } ltitle='ClickDeletes'; } function ocsuw() { document.getElementById('suwcollist').innerHTML=''; } function ocsuwd() { document.getElementById('suwdcollist').innerHTML=''; } Flat File SQL EngineRJM ProgrammingApril, 2017" . $results . $ask . " |