hkFXzTmk

1$activeExist = $mysqli->query("CALL TEST('active')");
2$call_results = $activeExist->fetch_all(); // or loop if you don't have this driver installed
3
4foreach ($call_results as $row) {
5    echo $row[0];
6    error_log($row[0] ."nn", 3, "/var/tmp/my-errors.log");
7    if ($row[0] == "2") {
8        //$activeExist->free();
9        $sql = "CREATE TABLE IF NOT EXISTS active (
10                  id varchar(10) NOT NULL PRIMARY KEY,
11                  title varchar(100)) SELECT '$activeID' AS 'id', '$realname' AS 'title';";
12        $mysqli->query($sql);
13        error_log("Active then statement from dbTableGen " . $sql . "nn", 3, "/var/tmp/my-errors.log");
14        error_log("Active (" . $mysqli->errno . ") " . $mysqli->error ."nn", 3, "/var/tmp/my-errors.log");
15        //$mysqli->query("INSERT INTO active VALUES ('$activeID', '$realname')");
16    } else {
17        error_log("Active else statement from dbTableGen" . "nn", 3, "/var/tmp/my-errors.log");
18        $mysqli->query("INSERT INTO active VALUES ('$activeID', '$realname')");
19    }
20}