PHP Database::NonResultQuery Examples

Example #1

File: delete.applications.php Project: JSiedlecky/LAI_v2.0

<?php

$idList = $_POST['idList'];
require "../classes/Database.php";
$db = new Database();
foreach ($idList as $key => $value) {
    $db->NonResultQuery("DELETE FROM `applications`WHERE `id` =" . $value);
}

Example #2

File: payment.actions.php Project: JSiedlecky/LAI_v2.0

            if ($cntr !== $all) {
                $tmp .= '"' . $v . '",';
            } else {
                $tmp .= '"' . $v . '"';
            }
            $cntr++;
        }
        if ($cnt !== $rows) {
            $tmp .= '),';
        } else {
            $tmp .= ')';
        }
        $cnt++;
    }
    $inserts .= $tmp;
    if ($db->NonResultQuery($inserts)) {
        echo 'OK';
    } else {
        echo 'ERROR';
    }
}
if ($action == 'selectpayment') {
    $names = explode(' ', $_GET['student']);
    $result = "";
    $student = $db->Select('students', ['cisco', 'www', 'cisco_group', 'www_group'], ['name' => $names[0], 'surname' => $names[1]]);
    foreach ($student as $index => $arr) {
        foreach ($arr as $k => $v) {
            if ($k === 'cisco' && $v !== '') {
                $flag1 = true;
            } else {
                if ($k === 'cisco' && $v === '') {