//
if (isset($_POST['sql_statements'])) {
$sql_arr = explode(';', $_POST['sql_statements']);
} else {
print_r('Error - no SQL statments provided');
}
//
if (isset($_POST['return_names'])) {
$name_arr = explode(';', $_POST['return_names']);
}
//
$results = array();
//
for ($i = 0; $i < count($sql_arr); $i++) {
//
$db_res = fetch_db($server, $database, $username, $password, $sql_arr[$i]);
$error = $db_res[1];
$db_res = $db_res[0];
if ($error) {
$name_arr[$i] = "SQL_REQ_ERROR_MSG-{$i}";
}
if ($i < count($name_arr)) {
$results[$name_arr[$i]] = $db_res;
} else {
array_push($results, $db_res);
}
}
//
$json = json_encode($results);
if ($json == '') {
print_r('JSON Encoding Error: ', json_last_error(), ' - ', json_last_error_msg());
$results = array();
//
if (isset($_POST['sql_statements'])) {
$sql_arr = json_decode($_POST['sql_statements']);
}
if (isset($_POST['return_names'])) {
$name_arr = explode(';', $_POST['return_names']);
}
//
// cleaning any empty elements from sql_arr
$sql_arr = array_filter($sql_arr);
$sql_arr = array_values($sql_arr);
//
for ($i = 0; $i < count($sql_arr); $i++) {
//
list($db_res, $error) = fetch_db($sql_arr[$i], [], $conn);
if ($error) {
$name_arr[$i] = "SQL_REQ_ERROR_MSG-{$i}";
}
if ($i < count($name_arr)) {
$results[$name_arr[$i]] = $db_res;
} else {
array_push($results, $db_res);
}
}
//
$json = json_encode($results);
if ($json === '') {
echo 'JSON Encoding Error: ', json_last_error(), ' - ', json_last_error_msg();
} else {
print_r($json);
function fetch_auth_table_data($data_where)
{
//
$args = _fetch_auth_table_data($data_where);
//
// fetching meta_data
$sql = gen_prepared_sql($args['cols_sql_args']);
$cols = fetch_db($sql['statement'], $sql['params'], $args['connection'])[0];
//
$sql = gen_prepared_sql($args['meta_sql_args']);
$meta_data = fetch_db($sql['statement'], $sql['params'], $args['connection'])[0];
//
// fetching table data SQL statement
for ($i = 0; $i < count($cols); $i++) {
array_push($args['data_sql_args']['cols'], $cols[$i]['column_name']);
}
$sql = gen_prepared_sql($args['data_sql_args']);
$users_data = fetch_db($sql['statement'], $sql['params'], $args['connection'])[0];
//
return ['data' => $users_data, 'meta_data' => $meta_data];
}
