Exemplos de dbLayer::queryTable em PHP

Exemplo n.º 1

Arquivo: edit.php Projeto: alexushakov74/Access-Control-Intrusion-Detection-Administration-Tool

<?php

include_once 'db.php';
$myDB = new dbLayer();
$id = $_POST['id'];
$sql = "SELECT * FROM {$myDB->table} where ID = '{$id}'";
$result = $myDB->queryTable($sql);
$row = $result->fetch_array();
$sql2 = "SELECT `Name` FROM Profiles";
$result2 = $myDB->queryTable($sql2);
$sql3 = "SELECT `Name` FROM Departments";
$result3 = $myDB->queryTable($sql3);
?>
 
<style>
#editData {
    border: 0px;
    width: 100%;
}
td {
    padding: 8px;
}
#saveEdit {
	border-radius: 5px;
	width: 120px;
}
input {
	padding: 4px;
}
select {
	padding: 4px;

Exemplo n.º 2

Arquivo: edit.php Projeto: alexushakov74/Access-Control-Intrusion-Detection-Administration-Tool

<?php

include_once 'db.php';
$myDB = new dbLayer();
$sql = "SELECT * FROM " . $myDB->table . " where ID = '" . $_POST['id'] . "'";
$result = $myDB->queryTable($sql);
$row = $result->fetch_array();
?>
 
<style>
#editData {
    border: 0px;
    width: 100%;
}
td {
    padding: 8px;
}
#saveEdit {
	border-radius: 5px;
	width: 120px;
}
input {
	padding: 4px;
}
#delete {
	border-radius 5px;
}
</style>
<table id="editData">
<tr>
<td>ID</td>

Exemplo n.º 3

Arquivo: edit.php Projeto: alexushakov74/Access-Control-Intrusion-Detection-Administration-Tool

<?php

include_once 'db.php';
$myDB = new dbLayer();
$sql = "SELECT * FROM " . $myDB->table . " where ID = '" . $_POST['id'] . "'";
$result = $myDB->queryTable($sql);
$row = $result->fetch_array();
$sql2 = "SELECT * FROM Users";
$result2 = $myDB->queryTable($sql2);
?>
 
<style>
#editData {
    border: 0px;
    width: 100%;
}
td {
    padding: 8px;
}
#saveEdit {
	border-radius: 5px;
	width: 120px;
}
input {
	padding: 4px;
	width: 220px;
}
select {
	padding: 4px;
	width: 220px;
}

Exemplo n.º 4

Arquivo: edit.php Projeto: alexushakov74/Access-Control-Intrusion-Detection-Administration-Tool

<?php

include_once 'db.php';
$myDB = new dbLayer();
$sql = "SELECT * FROM " . $myDB->table . " where ID = '" . $_POST['id'] . "'";
$result = $myDB->queryTable($sql);
$row = $result->fetch_array();
$sql2 = "SELECT * FROM Profiles";
$result2 = $myDB->queryTable($sql2);
$sql3 = "SELECT * FROM Areas";
$result3 = $myDB->queryTable($sql3);
?>
 
<style>
#editData {
    border: 0px;
    width: 100%;
}
td {
    padding: 8px;
}
#saveEdit {
	border-radius: 5px;
	width: 120px;
}
input {
	padding: 4px;
	width: 256px;
}
select {
	padding: 4px;