public static function dbClient()
{
$stdout = "";
// ============================================
// SELECT
// ============================================
if (0) {
$table = "lime_survey_57939";
$table = "orcasearch";
$sqlStmt = "SELECT * " . "FROM " . $table;
//$sqlStmt = "SHOW CHARACTER SET";
$result = client_safeMysqlQuery($sqlStmt, "FIX-2");
$antal_rader = @mysql_num_rows($result);
$stdout .= "<p><strong>" . $antal_rader . "</strong> records found in table <strong>" . $table . "</strong></p>";
if ($antal_rader > 0) {
for ($rad = 0; $rad < $antal_rader; $rad++) {
$res = @mysql_fetch_assoc($result);
}
// end for
}
// end if
@mysql_free_result($result);
}
// --------------------------------------------
if (0) {
$sqlStmt = "SELECT Telekatalog_id,Titel_id FROM Telekatalog WHERE Titel_id != ''";
$result = client_safeMysqlQuery($sqlStmt, "FIX-2");
$antal_rader = @mysql_num_rows($result);
if ($antal_rader > 0) {
for ($rad = 0; $rad < $antal_rader; $rad++) {
$res = @mysql_fetch_assoc($result);
$val[] = "(" . $res["Telekatalog_id"] . "," . $res["Titel_id"] . ")<br>";
}
// end for
}
// end if
@mysql_free_result($result);
}
// ============================================
// DELETE
// ============================================
if (0) {
$sqlStmt = "DELETE FROM Telekatalog_TitelData WHERE Grupp_id='1'";
$stdout .= client_submitQuery("1", "DELETE FROM Telekatalog_TitelData", $sqlStmt);
}
// ============================================
// UPDATE
// ============================================
if (0) {
$sqlStmt = "UPDATE Telekatalog_TitelData SET Grupp_id='ADM' WHERE Grupp_id='1'";
$stdout .= client_submitQuery("1", "UPDATE Telekatalog_TitelData", $sqlStmt);
}
// --------------------------------------------
if (0) {
$gc = array("ALB", "BIO", "DBB", "AST", "FYS", "FKM");
foreach ($gc as $idx) {
$sqlStmt = "UPDATE Telekatalog_TitelData SET Status_excelkod='ƒ' WHERE Grupp_id='" . $idx . "'";
$stdout .= client_submitQuery("1", "UPDATE Telekatalog_TitelData", $sqlStmt);
}
}
// --------------------------------------------
if (0) {
$gc = array('ELPARS' => 'bub', 'ATOMFY' => 'atom', 'SYSFYS' => 'sip');
foreach ($gc as $old => $new) {
$sqlStmt = "UPDATE Telekatalog_TitelData SET Status_excelkod='" . $new . "' WHERE Status_excelkod='" . $old . "'";
$stdout .= client_submitQuery("1", "UPDATE Telekatalog_TitelData", $sqlStmt);
}
}
// ============================================
// INSERT
// ============================================
if (0) {
$val = array("", "");
$sqlStmt = "INSERT INTO Telekatalog_TitelData " . " (Telekatalog_id,Titel_id) " . "VALUES " . "('" . implode("','", $val) . "')";
$stdout .= client_submitQuery("1", "INSERT Telekatalog_TitelData", $sqlStmt);
}
// --------------------------------------------
if (0) {
$sqlStmt = "INSERT INTO Telekatalog_InstitutionTyp " . " (,,) " . "VALUES " . "('','','')," . "('','','')," . "('','','')," . "('','','')";
$stdout .= client_submitQuery("1", "INSERT Telekatalog_InstitutionTyp", $sqlStmt);
}
// --------------------------------------------
if (0) {
//lime_old_survey_57939_20120518132733
//lime_old_survey_57939_20120518135027
//lime_old_survey_57939_20120627183014
//lime_old_survey_57939_20120627184652
$table1 = "lime_survey_57939";
$table2 = "lime_old_survey_57939_20120627183014";
$sqlStmt = "INSERT INTO " . $table1 . " " . "SELECT * " . "FROM " . $table2;
$stdout .= client_submitQuery("1", "INSERT INTO " . $table1, $sqlStmt);
$sqlStmt = "SELECT * " . "FROM " . $table1;
$result = client_safeMysqlQuery($sqlStmt, "SELECT FROM" . $table1);
$antal_rader = @mysql_num_rows($result);
$stdout .= "<p><strong>" . $antal_rader . "</strong> records found in table <strong>" . $table1 . "</strong></p>";
}
// ============================================
// CREATE TABLE
// ============================================
if (0) {
$sqlStmt = "CREATE TABLE IF NOT EXISTS Telekatalog_TitelData ( " . " Telekatalog_id SMALLINT NOT NULL REFERENCES Telekatalog (Telekatalog_id), " . " Titel_id VARCHAR(30) NOT NULL REFERENCES Titel (Titel_id), " . " PRIMARY KEY (Telekatalog_id,Titel_id) " . ")";
$stdout .= client_submitQuery("1", "CREATE Telekatalog_TitelData", $sqlStmt);
}
// ============================================
// ALTER TABLE
// ============================================
if (0) {
mysql_select_db("");
$sqlStmt = "ALTER IGNORE TABLE Telekatalog " . " CHANGE COLUMN Grupp_id " . " Grupp_id CHAR(10) NULL";
$stdout .= client_submitQuery("1", "ALTER CHANGE Telekatalog", $sqlStmt);
}
// --------------------------------------------
if (0) {
$db = "nordita_test";
$tbl = "publications";
$sqlStmt = "ALTER IGNORE TABLE " . $db . "." . $tbl . " " . " ADD COLUMN " . " publ_year varchar(200) DEFAULT NULL " . " AFTER PublIn";
echo "<br>{$sqlStmt}";
//$stdout .= client_submitQuery("1","ALTER ADD publ_year TO nordita_test",$sqlStmt);
$sqlStmt = "ALTER IGNORE TABLE " . $db . "." . $tbl . " " . " ADD COLUMN " . " `label` char(1) default NULL REFERENCES pp_category (label) " . " AFTER publ_year";
echo "<br>{$sqlStmt}";
//$stdout .= client_submitQuery("2","ALTER ADD label TO nordita_test",$sqlStmt);
$sqlStmt = "ALTER IGNORE TABLE " . $db . "." . $tbl . " " . " ADD COLUMN " . " `slask3` char(1) default NULL REFERENCES pp_category (label) " . " AFTER label";
//$stdout .= client_submitQuery("3","ALTER ADD slask TO nordita_test",$sqlStmt);
}
// --------------------------------------------
if (0) {
$sqlStmt = "ALTER IGNORE TABLE kalendarium_details " . " DROP COLUMN Kolumn";
$stdout .= client_submitQuery("1", "ALTER DROP kalendarium_details", $sqlStmt);
}
// ============================================
// SHOW
// ============================================
if (0) {
$db = "nordita_test";
$sqlStmt = "SHOW TABLES " . "FROM " . $db;
//$sqlStmt = "SHOW CHARACTER SET";
$result = client_safeMysqlQuery($sqlStmt, "FIX-2");
$antal_rader = @mysql_num_rows($result);
$stdout .= "<p><strong>" . $antal_rader . "</strong> tables found in database <strong>" . $db . "</strong></p>";
if ($antal_rader > 0) {
$stdout .= "<ul>\r\n";
for ($rad = 0; $rad < $antal_rader; $rad++) {
$res = @mysql_fetch_assoc($result);
$stdout .= " <li>" . $res["Tables_in_" . $db] . "</li>\r\n";
}
// end for
$stdout .= "</ul>\r\n";
}
// end if
@mysql_free_result($result);
}
if (0) {
$db = "nordita_test";
$tbl = "publications";
$sqlStmt = "SHOW COLUMNS " . "FROM " . $db . "." . $tbl;
//$sqlStmt = "SHOW CHARACTER SET";
$result = client_safeMysqlQuery($sqlStmt, "FIX-2");
$antal_rader = @mysql_num_rows($result);
$stdout .= "<p><strong>" . $antal_rader . "</strong> columns found in table <strong>" . $db . "." . $tbl . "</strong></p>";
if ($antal_rader > 0) {
$stdout .= "<ul>\r\n";
for ($rad = 0; $rad < $antal_rader; $rad++) {
$res = @mysql_fetch_assoc($result);
debug::rr($res);
$stdout .= " <li>" . $res["Field"] . "</li>\r\n";
}
// end for
$stdout .= "</ul>\r\n";
}
// end if
@mysql_free_result($result);
}
// ============================================
@mysql_close();
// ============================================
return $stdout;
}
public static function AnewseditSelectDb()
{
$stdout = "";
$tables = array();
if (!class_exists("fromdb_client", FALSE)) {
require_once PATH_CLASSES . "/fromdb/client.php";
}
$dbClient = new fromdb_client();
// includes connect to "nordita" database
// ---------------------------------------
$sqlStmt = "SHOW TABLES FROM nordita";
$result = client_safeMysqlQuery($sqlStmt, "");
if ($result) {
$numrows = @mysql_num_rows($result);
while ($res = @client_safeMysqlFetchRow($result)) {
if (preg_match("/^" . NEWS_DB_PREFIX . "/i", $res[0])) {
$tables[] = $res[0];
}
}
// end while
}
@mysql_free_result($result);
// ---------------------------------------
if (empty($tables)) {
return "<p class='red'><strong>»SORRY</strong>. Could not find any tables in database 'nordita'</p>\r\n\r\n";
}
$stdout .= "<style type='text/css'>\r\n" . " h3+.b_zebra {margin-top:1em}\r\n" . " .b_zebra {width:auto}\r\n" . " .b_zebra td {padding:0 1em}\r\n" . " .b_zebra td+td {border-left:1px solid #666}\r\n" . "</style>\r\n" . "\r\n";
$stdout .= "<div class='box blackborder padding' style='max-width:752px'><strong>» </strong><a href='" . $_SERVER["PHP_SELF"];
if (isset($_REQUEST["test"])) {
$stdout .= "'>Show <strong>public</strong>";
} else {
$stdout .= "?test=1'>Show <strong>test</strong>";
}
$stdout .= " database instead</a></div>\r\n\r\n";
foreach ($tables as $table) {
$sqlSats = "SELECT * FROM " . $table;
$result = client_safeMysqlQuery($sqlSats);
$numrows = @mysql_num_rows($result);
$numcols = @mysql_num_fields($result);
$stdout .= "<h3>TABLE '" . $table . "'</h3>\r\n";
if ($numrows > 0) {
$stdout .= "<table class='b_zebra'>\r\n" . " <tr>\r\n" . " <td class='b_zebra0'> </td>\r\n";
for ($kol = 0; $kol < $numcols; $kol++) {
$stdout .= " <td class='b_zebra0'><strong>" . @mysql_field_name($result, $kol) . "</strong></td>\r\n";
}
$stdout .= " </tr>\r\n";
for ($row = 0; $row < $numrows; $row++) {
$en_rad = client_safeMysqlFetchRow($result);
$stdout .= " <tr>\r\n" . " <td class='b_zebra" . ($row % 2 + 1) . "'><em style='color:#999;'>" . ($row + 1) . "</em></td>\r\n";
for ($kol = 0; $kol < $numcols; $kol++) {
$stdout .= " <td class='b_zebra" . ($row % 2 + 1) . "'>" . substr(strip_tags($en_rad[$kol]), 0, 50) . "</td>\r\n";
}
$stdout .= " </tr>\r\n";
}
$stdout .= "</table>\r\n\r\n";
} else {
$stdout .= "<p class='red'><strong>» <em>This table is empty</em></strong></p>\r\n\r\n";
}
// end if
}
// end foreach
return $stdout;
}