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; }