$db =
new
SQLite3(
'oedb.db'
);
$sql =
'insert into mem values('
.
$_POST[
"WE1712bc53f7"
] .
',"'
.
$_POST["WE2016dab330
"] .'"
,'.
$_POST[
"WEb32b7ea66b"
] .
')'
;
$results = $db->exec($sql);
echo
"insert : "
;
if
($results) echo
"completely"
;
else
echo
"fail : "
. $sql;
$db->close();
$db =
new
SQLite3(
'oedb.db'
);
$sql =
'delete from mem where myid='
. $_POST[
"WE82ca78d056"
];
$results = $db->exec($sql);
echo
"delete : "
;
if
($results) echo
"completely"
;
else
echo
"fail : "
. $sql;
$db->close();
$db =
new
SQLite3(
'oedb.db'
);
$sql =
'update mem set myname="'
.
$_POST["WE2fcfae5e61
"] . '"
, mysalary='.
$_POST[
"WE25afcdfada"
] .
' where myid='
.
$_POST[
"WEb1414d6fdc"
];
$results = $db->exec($sql);
echo
"update : "
;
if
($results) echo
"completely"
;
else
echo
"fail : "
. $sql;
$db->close();
$db =
new
SQLite3(
'oedb.db'
);
$results = $db->query(
'SELECT *FROM mem'
);
$o =
'<table style="margin-left:auto;margin-right:auto;width:700px;border:1px solid;">'
;
while
($row = $results->fetchArray()) {
$o .=
"<tr><td> $row[0]</td><td> $row[1] </td><td> $row[2]</td></tr>"
;
}
$o .=
"</table>"
;
$db->close();
echo
"<script>document.getElementById('WE32599ecd42').innerHTML += '"
. $o .
"';</script>"
;