MyTable PHP Code Examples

Example #1

0

Show file

File: gbphistoryadmin.php Project: sigmaroot/GuildBankManager

} else {
    if ($sortorder == "desc") {
        $sortorder = SORT_DESC;
    } else {
        $sortorder = SORT_ASC;
    }
}
// TABELLE HEADER
$tb_header = new MyTableHeader();
$tb_header->setTitle(array("Zeit", "Name", "Typ", "Punkte", "Bemerkung", "ADMIN"));
$tb_header->setCenter(array(false, false, false, true, false));
$tb_header->setWidth(array(150, 150, 100, 100, 300, 100));
$tb_header->setSortindex($sortindex);
$tb_header->setSortorder($sortorder);
// TABELLE DATA
$tb_table = new MyTable();
$tb_table->setHeader($tb_header);
$tb_table->setTemppage(toSaferValue(@$_GET["page"]) . "&name=" . toSaferValue(@$_GET["name"]));
// HISTORY
if ($name == "") {
    $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory ORDER BY timestamp DESC LIMIT 50");
} else {
    $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory WHERE name = '" . $name . "' ORDER BY timestamp DESC");
}
$types = array();
$types[1] = "<img src=\"./images/list_add.png\" alt=\"Einlagern\" title=\"Einlagern\"> Einlagern";
$types[-1] = "<img src=\"./images/list_remove.png\" alt=\"Auslagern\" title=\"Auslagern\"> Auslagern";
while ($row = @mysql_fetch_assoc($result)) {
    $tb_table->addRow(array($row["timestamp"], $row["name"], $row["type"], $row["points"], $row["info"], "[link]"));
    $tb_table->addHtmlrow(array(mysqlDate($row["timestamp"]), "<a href=\"?page=gbphistoryadmin&name=" . $row["name"] . "\">" . $row["name"] . "</a>", $types[$row["type"]], $row["points"], $row["info"], "<a href=\"index.php?page=editgbpentry&id=" . $row["historyid"] . "\">&auml;ndern</a>"));
}

Example #2

0

Show file

File: itemvisibility.php Project: sigmaroot/GuildBankManager

    if ($sortorder == "desc") {
        $sortorder = SORT_DESC;
    } else {
        $sortorder = SORT_ASC;
    }
}
// TABELLE HEADER
$tb_header = new MyTableHeader();
$tb_header->setTitle(array("Itemname", "Sichtbar", "ADMIN"));
$tb_header->setCenter(array(false, true, true));
$tb_header->setWidth(array(400, 100, 100));
$tb_header->setSortindex($sortindex);
$tb_header->setSortorder($sortorder);
$tb_header->setExtrasort(true, 0);
// TABELLE DATA
$tb_table = new MyTable();
$tb_table->setHeader($tb_header);
$tb_table->setTemppage(toSaferValue(@$_GET["page"]));
$tb_table->setExtrasort(true, 0);
// HIDDEN ITEMS
$result = mysql_query("SELECT *FROM " . $databasename . "." . $tableprefix . "hiddenitems");
$counter = 0;
$hiddenitems = array();
while ($row = @mysql_fetch_assoc($result)) {
    $hiddenitems[$counter] = $row["itemid"];
    $counter = $counter + 1;
}
// INVENTAR
$result = mysql_query("SELECT *, " . $databasename . "." . $tableprefix . "guildbank.itemid AS use_itemid FROM " . $databasename . "." . $tableprefix . "guildbank LEFT JOIN " . $databasename . "." . $tableprefix . "itempoints ON " . $databasename . "." . $tableprefix . "guildbank.itemid = " . $databasename . "." . $tableprefix . "itempoints.itemid UNION SELECT *, " . $databasename . "." . $tableprefix . "itempoints.itemid AS use_itemid FROM " . $databasename . "." . $tableprefix . "guildbank RIGHT JOIN " . $databasename . "." . $tableprefix . "itempoints ON " . $databasename . "." . $tableprefix . "guildbank.itemid = " . $databasename . "." . $tableprefix . "itempoints.itemid WHERE " . $databasename . "." . $tableprefix . "guildbank.itemid IS NULL");
$counter = 0;
$inventar = array();

Example #3

0

Show file

File: test_table.php Project: pro100ravil/test

		width:320px;
		height:auto;
	}
	#search_form p{
		padding:0;
		margin:0;
		margin-bottom:5px;
	}

	</style>
</head>
<body>
<div id="search_form">
	<p class='mycolor'>поиск по столбцу</p>
	<?php 
$test = new MyTable();
if (isset($_POST['text'])) {
    $test->getSearchForm($_POST['select'], $_POST['text']);
} else {
    $test->getSearchForm(NULL, '');
}
?>
</div>
<div id="table" align="center">
<?php 
if ($test->connectDB('localhost', 'root', '', 'orders')) {
    //получаем имя колонки
    if (isset($_GET['sorted'])) {
        $sorted = $_GET['sorted'];
    } else {
        $sorted = NULL;

Example #4

0

Show file

File: index.php Project: Gelembjuk/db

 * This example is part of gelembjuk/db package by Roman Gelembjuk (@gelembjuk)
 */
// path to your composer autoloader
require 'vendor/autoload.php';
// simple example to show how to work with 2 DB parelelly in a PHP script
$dbsettings1 = array('user' => 'dbuser', 'password' => 'dbuserpassword', 'database' => 'mydb', 'host' => 'localhost', 'connectioncharset' => 'utf8', 'namescharset' => 'utf8');
// different DB
$dbsettings2 = array('user' => 'dbuser', 'password' => 'dbuserpassword', 'database' => 'mydb2', 'host' => 'localhost', 'connectioncharset' => 'utf8', 'namescharset' => 'utf8');
$dbengine1 = new Gelembjuk\DB\MySQL($dbsettings1);
$dbengine2 = new Gelembjuk\DB\MySQLi($dbsettings2);
// connection will be established on a first request to a DB
class MyTable extends Gelembjuk\DB\Base
{
    public function getUsers()
    {
        return $this->getRows('SELECT * FROM users');
    }
    public function addUser($name, $email)
    {
        $sql = "INSERT INTO users (name,email) VALUES " . "('" . $this->quote($name) . "','" . $this->quote($email) . "')";
        $this->executeQuery();
        return getLastInsertedId();
    }
}
$mytable = new MyTable($dbengine1);
$userid1 = $mytable->addUser('User 1', '*****@*****.**');
$userid2 = $mytable->addUser('User 2', '*****@*****.**');
print_r($mytable->getUsers());
// this will do same but with different DB
$mytable2 = new MyTable($dbengine2);
print_r($mytable2->getUsers());

Example #5

0

Show file

File: members.php Project: sigmaroot/GuildBankManager

} else {
    if ($sortorder == "desc") {
        $sortorder = SORT_DESC;
    } else {
        $sortorder = SORT_ASC;
    }
}
// TABELLE HEADER
$tb_header = new MyTableHeader();
$tb_header->setTitle(array("Platz", "Name", "Level", "Klasse", "Gildenbank-Konto", "Diese Woche (KW)"));
$tb_header->setCenter(array(true, false, true, false, true, true));
$tb_header->setWidth(array(50, 150, 100, 200, 150, 150));
$tb_header->setSortindex($sortindex);
$tb_header->setSortorder($sortorder);
// TABELLE DATA
$tb_table = new MyTable();
$tb_table->setHeader($tb_header);
$tb_table->setTemppage(toSaferValue(@$_GET["page"]));
// WOCHEN-PUNKTE
$monday = strtotime('last monday', strtotime('tomorrow'));
$sqlstring = date("Y-m-d H:i:s", $monday);
$weekpoints = array();
$result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory WHERE type = 1 AND timestamp >= '" . $sqlstring . "'");
while ($row = @mysql_fetch_assoc($result)) {
    if (!array_key_exists($row["name"], $weekpoints)) {
        $weekpoints[$row["name"]] = $row["points"];
    } else {
        $weekpoints[$row["name"]] = $weekpoints[$row["name"]] + $row["points"];
    }
}
@mysql_free_result($result);

Example #6

0

Show file

File: guildbank.php Project: sigmaroot/GuildBankManager

$onlychar = toSaferValue(@$_GET["filter"]);
$onlycharwhere = "";
if ($onlychar != "") {
    $onlycharwhere = " WHERE bankchar = '" . $onlychar . "'";
}
// TABELLE HEADER
$tb_header = new MyTableHeader();
$tb_header->setTitle(array("Menge", "Itemname", "Bankchar", "Punkte*"));
$tb_header->setCenter(array(true, false, false, true));
$tb_header->setWidth(array(100, 400, 200, 100));
$tb_header->setSortindex($sortindex);
$tb_header->setSortorder($sortorder);
$tb_header->setExtrasort(true, 1);
$tb_header->setFilter($onlychar);
// TABELLE DATA
$tb_table = new MyTable();
$tb_table->setHeader($tb_header);
$tb_table->setTemppage(toSaferValue(@$_GET["page"]));
$tb_table->setExtrasort(true, 1);
// HIDDEN ITEMS
$result = mysql_query("SELECT *FROM " . $databasename . "." . $tableprefix . "hiddenitems");
$counter = 0;
$hiddenitems = array();
while ($row = @mysql_fetch_assoc($result)) {
    $hiddenitems[$counter] = $row["itemid"];
    $counter = $counter + 1;
}
// NOTES
$result = mysql_query("SELECT *FROM " . $databasename . "." . $tableprefix . "itemnotes");
$counter = 0;
$itemnotes = array();

Example #7

0

Show file

File: gbphistory.php Project: sigmaroot/GuildBankManager

} else {
    if ($sortorder == "desc") {
        $sortorder = SORT_DESC;
    } else {
        $sortorder = SORT_ASC;
    }
}
// TABELLE HEADER
$tb_header = new MyTableHeader();
$tb_header->setTitle(array("Zeit", "Name", "Typ", "Punkte", "Bemerkung"));
$tb_header->setCenter(array(false, false, false, true));
$tb_header->setWidth(array(150, 150, 100, 100, 300));
$tb_header->setSortindex($sortindex);
$tb_header->setSortorder($sortorder);
// TABELLE DATA
$tb_table = new MyTable();
$tb_table->setHeader($tb_header);
$tb_table->setTemppage(toSaferValue(@$_GET["page"]) . "&name=" . toSaferValue(@$_GET["name"]));
// HISTORY
if ($name == "") {
    $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory ORDER BY timestamp DESC LIMIT 50");
} else {
    $result = mysql_query("SELECT * FROM " . $databasename . "." . $tableprefix . "gbphistory WHERE name = '" . $name . "' ORDER BY timestamp DESC");
}
$types = array();
$types[1] = "<img src=\"./images/list_add.png\" alt=\"Einlagern\" title=\"Einlagern\"> Einlagern";
$types[-1] = "<img src=\"./images/list_remove.png\" alt=\"Auslagern\" title=\"Auslagern\"> Auslagern";
while ($row = @mysql_fetch_assoc($result)) {
    $tb_table->addRow(array($row["timestamp"], $row["name"], $row["type"], $row["points"], $row["info"]));
    $tb_table->addHtmlrow(array(mysqlDate($row["timestamp"]), "<a href=\"?page=gbphistory&name=" . $row["name"] . "\">" . $row["name"] . "</a>", $types[$row["type"]], $row["points"], $row["info"]));
}

PHP MyTable Examples