function testSql2()
{
$conn = openConn();
$rs = $conn->query("select * From padmin");
while ($arr = $conn->fetch_array($rs)) {
echo $arr["UserName"] . "<hr>";
}
}
function checkSql($sql)
{
$conn = openConn();
return $GLOBALS['conn']->checkSQL($sql);
}
<?php
// main
$json = json_decode(file_get_contents("php://input"));
//var_dump ( $json );
$conn = openConn();
$id = insertABCChecklist($json);
insertABCChecklistSupport($json->people, 'people', $id);
insertABCChecklistSupport($json->behavior, 'behavior', $id);
insertABCChecklistSupport($json->consequence, 'consequence', $id);
mysqli_commit($conn);
echo "<b>Saved to Database!<b>";
closeConn();
function insertABCChecklistSupport($obj, $type, $id)
{
global $conn;
$i = 1;
$count = count($obj);
$sql = "INSERT INTO abc_checklist_support (id, supportType, supportId, supportValue)\n\t\tVALUES";
foreach ($obj as $single) {
$sql .= "({$id}, '{$type}', {$i}, '{$single}')";
if ($i < $count) {
$sql .= ",";
}
$i += 1;
}
if ($conn->multi_query($sql) === FALSE) {
echo "Error: " . $sql . "<br>" . $conn->error;
closeConn();
die;
}
