} 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"] . "\">ändern</a>")); }
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();
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;
* 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());
} 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);
$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();
} 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"])); }