public static function installWithoutDemo(JO_Db_Adapter_Abstract $db)
{
mysql_connect($db->getConfig('host'), $db->getConfig('username'), $db->getConfig('password'));
mysql_select_db($db->getConfig('dbname'));
mysql_set_charset('utf8');
$structure = APPLICATION_PATH . '/modules/install/structure.sql';
if (!file_exists($structure)) {
return false;
}
$queryes = self::getQueryes(file($structure));
$results = array();
foreach ($queryes as $query) {
if (trim($query)) {
try {
/*$results[] = */
(bool) mysql_query($query);
} catch (JO_Exception $e) {
/*$results[] = false;*/
}
}
}
$request = JO_Request::getInstance();
$results[] = $db->insert('users', array('user_id' => 1, 'username' => $request->getPost('username'), 'password' => md5(md5($request->getPost('password'))), 'register_datetime' => new JO_Db_Expr('NOW()'), 'status' => 'activate', 'groups' => 'a:1:{i:2;s:2:"on";}'));
/*$results[] = */
$db->update('system', array('value' => $request->getPost('admin_mail')), array('`key` = ?' => 'admin_mail'));
/*$results[] = */
$db->update('system', array('value' => $request->getPost('report_mail')), array('`key` = ?' => 'report_mail'));
if (!in_array(false, $results)) {
$db_set = "\r\r\n\tdb.adapter = \"MYSQLi\"\r\r\n\tdb.params.host = \"" . $db->getConfig('host') . "\"\r\r\n\tdb.params.username = \"" . $db->getConfig('username') . "\"\r\r\n\tdb.params.password = \"" . $db->getConfig('password') . "\"\r\r\n\tdb.params.dbname = \"" . $db->getConfig('dbname') . "\"\r\r\n\tdb.params.charset =\"utf8\"";
$results[] = (bool) @file_put_contents(APPLICATION_PATH . '/config/config_db.ini', $db_set);
}
return !in_array(false, $results);
}
protected function connect()
{
if (!function_exists('mysql_connect')) {
// We have to '@' the actual call since it can spew all sorts of silly
// noise, but it will also silence fatals caused by not having MySQL
// installed, which has bitten me on three separate occasions. Make sure
// such failures are explicit and loud.
throw new Exception("About to call mysql_connect(), but the PHP MySQL extension is not " . "available!");
}
$user = $this->getConfiguration('user');
$host = $this->getConfiguration('host');
$database = $this->getConfiguration('database');
$pass = $this->getConfiguration('pass');
if ($pass instanceof PhutilOpaqueEnvelope) {
$pass = $pass->openEnvelope();
}
$conn = @mysql_connect($host, $user, $pass, $new_link = true, $flags = 0);
if (!$conn) {
$errno = mysql_errno();
$error = mysql_error();
throw new AphrontQueryConnectionException("Attempt to connect to {$user}@{$host} failed with error " . "#{$errno}: {$error}.", $errno);
}
if ($database !== null) {
$ret = @mysql_select_db($database, $conn);
if (!$ret) {
$this->throwQueryException($conn);
}
}
mysql_set_charset('utf8', $conn);
return $conn;
}
function db_connect($host, $username, $password)
{
if ($r = mysql_connect($host, $username, $password)) {
mysql_set_charset('cp1251', $r);
}
return $r;
}
function OpenConnection()
{
global $mysqlAuthentication;
global $sqlserverAuthentication;
$host = null;
$options = null;
if (isset($mysqlAuthentication)) {
$host = $mysqlAuthentication["host"];
$options = $mysqlAuthentication;
}
if ($this->databaseType == 'mySql' || $this->databaseType == 'both') {
$this->mysqlConnection = @mysql_connect($host, $options["username"], $options["password"]);
}
if (isset($this->mysqlConnection)) {
@mysql_set_charset("utf8");
@mysql_select_db($options["database"], $this->mysqlConnection);
}
if (isset($sqlserverAuthentication)) {
$host = $sqlserverAuthentication["host"];
$options = array("Database" => $sqlserverAuthentication["database"], "CharacterSet" => "UTF-8", "UID" => $sqlserverAuthentication["username"], "PWD" => $sqlserverAuthentication["password"]);
}
if ($this->databaseType == 'sqlServer' || $this->databaseType == 'both') {
$this->sqlserverConnection = sqlsrv_connect($host, $options);
}
}
public function save3()
{
//获取数据库主机
$host = $_POST['host'];
//获取用户帐号
$user = $_POST['user'];
//获取用户密码
$pass = $_POST['pass'];
//获取数据库名
$name = $_POST['name'];
//获取字段前缀
$prefix = $_POST['prefix'];
$str = "<?php" . "\r\n";
$str .= " define('Sql_type', 'mysql'); //数据库类型" . "\r\n\r\n";
$str .= " define('Sql_host', '{$host}'); //服务器地址" . "\r\n\r\n";
$str .= " define('Sql_name', '{$name}'); //数据库名 " . "\r\n\r\n";
$str .= " define('Sql_user', '{$user}'); //用户名" . "\r\n\r\n";
$str .= " define('Sql_pwd', '{$pass}'); //密码" . "\r\n\r\n";
$str .= " define('Sql_port', '3306'); //端口" . "\r\n\r\n";
$str .= " define('Sql_prefix', '{$prefix}'); //数据库表前缀" . "\r\n\r\n";
$str .= " define('Sql_charset', 'utf8'); //数据库编码默认采用utf8";
file_put_contents(APP_PATH . 'Lib/tm_db.php', $str);
$lnk = @mysql_connect($host, $user, $pass);
mysql_set_charset('utf8');
mysql_query("CREATE DATABASE {$name}");
mysql_query("USE {$name}");
$arr = file_get_contents(APP_PATH . '/Lib/tongmeng.sql');
$res = explode(';', $arr);
foreach ($res as $Res) {
$Sql = $Res . ';';
mysql_query($Sql);
}
$this->display('temp_4');
}
function connect()
{
$this->_action = 'connect';
if (false === ($this->_link = @mysql_connect($this->_config['host'], $this->_config['user'], $this->_config['pass']))) {
$this->_throwException();
}
$this->_action = 'select database';
if (false === @mysql_select_db($this->_config['path'], $this->_link)) {
$this->_throwException();
}
if (isset($this->_config['params']['charset'])) {
$this->_action = 'set charset';
$success = false;
if (function_exists('mysql_set_charset')) {
// MySQL 5.0.7 and PHP 5.2.3
$success = @mysql_set_charset($this->_config['params']['charset'], $this->_link);
} else {
$success = @mysql_query('SET NAMES "' . $this->_config['params']['charset'] . '"', $this->_link);
}
if (!$success) {
$this->_throwException();
}
}
return $this;
}
/**
* 连接数据库
* @return resource
*/
function connect()
{
$link = mysql_connect(DB_HOST, DB_USER, DB_PWD) or die("数据库连接失败Error:" . mysql_errno() . ":" . mysql_error());
mysql_set_charset(DB_CHARSET);
mysql_select_db(DB_DBNAME) or die("指定数据库打开失败");
return $link;
}
function mcm_open_db()
{
global $mcm;
mysql_connect($mcm['db_server'], $mcm['db_username'], $mcm['db_password']) or die("Unable to connect to database server.\n");
mysql_select_db($mcm['db_database']) or die("Unable to open database.\n");
mysql_set_charset('utf8');
}
public function connect($host = '', $user = '', $pass = '', $dbname = '', $port = '3066')
{
$this->dbname = $dbname;
if (!$this->con) {
$myconn = @mysql_connect($host . ':' . $port, $user, $pass);
// mysql_connect() with variables defined at the start of Database class
if ($myconn) {
mysql_set_charset('utf8', $myconn);
$this->mysql_link = $myconn;
$seldb = @mysql_select_db($this->dbname, $myconn);
// Credentials have been pass through mysql_connect() now select the database
if ($seldb) {
$this->con = true;
return true;
// Connection has been made return TRUE
} else {
array_push($this->result, mysql_error($this->mysql_link));
return false;
// Problem selecting database return FALSE
}
} else {
array_push($this->result, 'Something unexpected has gone wrong');
return false;
// Problem connecting return FALSE
}
} else {
return true;
// Connection has already been made return TRUE
}
}
/**
* Created by PhpStorm.
* User: Administrator
* Date: 16-1-19
* Time: 下午9:54
*/
function connect()
{
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('数据库连接失败！');
mysql_set_charset(DB_CHARSET);
mysql_select_db(DB_DBNAME) or die('指定数据库打开失败');
return $link;
}
function db_connect($dbhost, $dbname, $dbuser, $dbpass)
{
global $DB_DIE_ON_FAIL, $DB_DEBUG, $CFG;
if (!($dbh = mysql_connect($dbhost, $dbuser, $dbpass))) {
if ($DB_DEBUG) {
echo "<h2>Can't connect to {$dbhost} as {$dbuser}</h2>";
echo "<p><b>MySQL Error</b>: ", mysql_error();
} else {
echo "<h2>Database error encountered</h2>";
}
if ($DB_DIE_ON_FAIL) {
echo "<p>This script cannot continue, terminating.";
echo "<a href=\"./\">Click here</a> to return to the homepage.";
die;
}
}
if (!$CFG->dont_select_db) {
if (!mysql_select_db($dbname)) {
if ($DB_DEBUG) {
echo "<h2>Can't select database {$dbname}</h2>";
echo "<p><b>MySQL Error</b>: ", mysql_error();
} else {
echo "<h2>Database error encountered</h2>";
db_error_mail("{$_SERVER['HTTP_HOST']} DB Select Failed", "Page: {$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}");
}
if ($DB_DIE_ON_FAIL) {
echo "<p>This script cannot continue, terminating.";
echo "<a href=\"./\">Click here</a> to return to the homepage.";
die;
}
}
}
mysql_set_charset('utf8');
return $dbh;
}
function conectar()
{
$li = mysql_connect("localhost", "artes_cotizacion", "Cotizaciones_1209");
mysql_set_charset('utf8');
mysql_select_db("artes01_Cotizaciones", $li) or die("Conexión no hecha");
return $li;
}
/**
* Etablit la connexion à la base de données
* @param array $aErreurs Le tableau contenant les messages d'erreurs rencontrées
*/
function connecter(&$aErreurs)
{
// Connexion
$this->link = @mysql_connect($this->host, $this->login, $this->password);
mysql_select_db($this->database);
mysql_set_charset('utf8', $this->link);
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
// En cas d'erreur
if (!$this->link) {
ajouterErreurDansTableau("Impossible de se connecter à la base de données !", $aErreurs);
if (MODE_DEBUG) {
ajouterErreurDansTableau(' -> ' . mysql_error(), $aErreurs);
}
return false;
}
// Sélection de la base de données
if (!@mysql_select_db($this->database, $this->link)) {
ajouterErreurDansTableau("Impossible de sélectionner la base '" . BD_BASE . "' !", $aErreurs);
if (MODE_DEBUG) {
ajouterErreurDansTableau(' -> ' . mysql_error(), $aErreurs);
}
return false;
}
return true;
}
function db_conn()
{
require __DIR__ . "/../config/config.php";
$connect = mysql_connect($host, $user, $pass) or die("Ошибка соединения: " . mysql_error());
mysql_set_charset('utf8', $connect);
mysql_select_db($db_name);
}
/**
* Connect to database
* @return resource
*/
function connect()
{
$link = mysql_connect(HOST, USER, PWD) or die("Error:" . mysql_errno() . ":" . mysql_error());
mysql_set_charset(DB_CHARSET);
mysql_select_db(DATABASE) or die("Connect MySQL failed!");
return $link;
}
function db_connect($db_host, $db_name, $db_user, $db_pass)
{
$conn = mysql_connect($db_host, $db_user, $db_pass) or die("MySQL-servern är okontaktbar.");
$databas = mysql_select_db($db_name) or die("Databasen {$db_name} fungerar inte.");
mysql_set_charset('utf8', $conn);
return $conn;
}
function connect($zf_host, $zf_user, $zf_password, $zf_database, $zf_pconnect = 'false', $zp_real = false)
{
//@TODO error class required to virtualise & centralise all error reporting/logging/debugging
$this->database = $zf_database;
if ($zf_pconnect != 'false') {
$this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);
} else {
// pconnect disabled ... leaving it as "connect" here instead of "pconnect"
$this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);
}
if ($this->link) {
//Check MySQL version and set character_set
$mysql_version = function_exists('mysql_get_server_info') ? @mysql_get_server_info() : '';
if ($mysql_version >= '4.1') {
$character_set_name = 'ujis';
if (function_exists('mysql_set_charset')) {
@mysql_set_charset($character_set_name);
} else {
@mysql_query("set names '" . $character_set_name . "';");
}
}
if (@mysql_select_db($zf_database, $this->link)) {
$this->db_connected = true;
return true;
} else {
$this->set_error(mysql_errno(), mysql_error(), $zp_real);
return false;
}
} else {
$this->set_error(mysql_errno(), mysql_error(), $zp_real);
return false;
}
}
function db_connect()
{
if (defined('CONN')) {
return;
}
define('CONN', @mysql_pconnect(DBHOST, DBUSER, DBPASS));
$db = @mysql_select_db(DBDATE, CONN);
if (!CONN) {
die('Verbindung nicht möglich, bitte prüfen Sie ihre mySQL Daten wie Passwort, Username und Host<br />');
}
if (!$db) {
die('Kann Datenbank "' . DBDATE . '" nicht benutzen : ' . mysql_error(CONN));
}
if (function_exists('mysql_set_charset') and version_compare(mysql_get_server_info(CONN), '5.0.7') !== -1) {
//Für ältere Installation die init.php nachladen
if (!defined('ILCH_DB_CHARSET') && file_exists('include/includes/init.php')) {
require_once 'include/includes/init.php';
}
mysql_set_charset(ILCH_DB_CHARSET, CONN);
}
$timeZoneSetted = false;
if (function_exists('date_default_timezone_get')) {
$timeZoneSetted = mysql_query('SET time_zone = "' . date_default_timezone_get() . '"');
}
if (!$timeZoneSetted && version_compare(PHP_VERSION, '5.1.3')) {
$timeZoneSetted = mysql_query('SET time_zone = "' . date('P') . '"');
}
}
public function getConnectionLocal()
{
try {
$ini = parse_ini_file("config.ini", TRUE);
$this->setLoginBanco(base64_decode($ini['local']['usuario']));
$this->setSenhaBanco(base64_decode($ini['local']['senha']));
$this->setServidorBanco(base64_decode($ini['local']['server']));
$this->setPortaBanco(base64_decode($ini['local']['porta']));
$this->setDatabase(base64_decode($ini['local']['database']));
// if(!isset(self::$instance)){
// self::$instance = new PDO('mysql:host=$this->servidor;dbname=$this->database', $this->loginBanco, $this->senhaBanco, array(PDO::MYSQL_ATTR_INIT_COMMAND=>"SET NAMES utf8"));
// self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// self::$instance->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_EMPTY_STRING);
// }
$conecta = mysql_connect($this->servidor, $this->loginBanco, $this->senhaBanco) or die("Erro ao conectar o banco de dados. Especificação técnica: " . mysql_connect_error());
mysql_select_db($this->database, $conecta);
mysql_set_charset('utf8', $conecta);
// $mysql = new mysqli($this->servidor, $this->loginBanco, $this->senhaBanco, $this->database, $this->porta);
// echo "Servidor: ".$this->servidor."\n";
// echo "Usuário: ".$this->loginBanco."\n";
// echo "Senha: ".$this->senhaBanco."\n";
// echo "Database: ".$this->database."\n";
return $conecta;
// return self::$conecta;
// return self::$instance;
} catch (Exception $ex) {
echo "Ocorreu um erro na conexão. Erro: " . $ex->getMessage();
}
}
private function drawList()
{
$html = '<div style="width:100%;clear:both;float:left;height:40px;"><hr></div><table style="clear:both;float:left;">';
$html .= '<thead><th></th><th>Redigeret</th><th>Tekst</th><th>Søgning</th><th>Aktiv</th><th></th></thead><tbody>';
//mysql_set_charset('Latin1');
//$SQL='select id, changed, substr(content,1,60) as content, target, active from promos';
$SQL = 'select id, changed, content, target, active from promos';
mysql_set_charset('utf8');
$result = $this->query($SQL);
while ($row = mysql_fetch_array($result)) {
$selected = $row['id'] == $this->selected_id ? ' class="selected"' : '';
$html .= '<tr id="' . $row['id'] . '"' . $selected . '>';
$html .= '<td><input type="button" value="Red." style="font-size:11px;" onclick="Promo.edit(' . $row['id'] . ');"/></td>';
$html .= '<td>' . $row['changed'] . '</td>';
$html .= '<td><div style="width:440px;overflow:hidden;white-space:nowrap;text-overflow:ellipsis;">' . strip_tags($row['content']) . '</div></td>';
$html .= '<td>' . $row['target'] . '</td>';
$html .= '<td style="text-align:center;">';
if ($row['active'] == '1') {
$html .= '●';
}
$html .= '</td>';
$html .= '<td><input type="button" value="Slet!" style="font-size:11px;" onclick="Promo.deletePromo(' . $row['id'] . ');"/></td>';
$html .= '</tr>';
}
$html .= '</tbody></table>';
echo $html;
}
/**
* Establece una coneccion con la DB
* @return recurso MySql en exito
* @return bool FALSE si hubo errores
*/
function conectarDB()
{
global $_serverHost;
global $_userName;
global $_password;
global $_schema;
global $_char_set;
global $archivoPHP;
$retorno = false;
$conn = @mysql_connect($_serverHost, $_userName, $_password);
if ($conn == false) {
gestionarError($archivoPHP, mysql_error());
$retorno = false;
} else {
$esquema = mysql_select_db($_schema, $conn);
if ($esquema == false) {
gestionarError($archivoPHP, mysql_error());
$retorno = false;
} else {
mysql_set_charset($_char_set, $conn);
$retorno = $conn;
}
}
return $retorno;
}
function connect()
{
$link = mysql_connect(DB_HOST, DB_USER, DB_PWD) or die("连接数据库失败");
mysql_set_charset(DB_CHARSET);
mysql_select_db(DB_DBNAME) or die("指定数据库打开失败");
return $link;
}
private function open()
{
$confDb = $this->confDb;
$this->connection = mysql_connect($confDb['host'], $confDb['user'], $confDb['pass']);
mysql_set_charset('utf8', $this->connection);
mysql_select_db($confDb['dbname']);
}
function SQLConnect()
{
$db_server = "localhost";
$db_username = "******";
$db_password = "";
$db_database = "pjj_chats";
if (file_exists(__DIR__ . '/mysql-secret.php')) {
include __DIR__ . '/mysql-secret.php';
}
$GLOBALS['handler'] = @mysql_pconnect($db_server, $db_username, $db_password);
if ($GLOBALS['handler'] === FALSE) {
echo '<b>MySQL connection failed. Trying to recover...</b><p>';
usleep(200000);
$GLOBALS['handler'] = @mysql_pconnect($db_server, $db_username, $db_password);
if ($GLOBALS['handler'] === FALSE) {
header('Refresh: 10; URL=' . $_SERVER['REQUEST_URI']);
echo '<meta http-equiv="Refresh" content="10; URL=' . $_SERVER['REQUEST_URI'] . '">';
echo '<p><b>The MySQL server is down or temporarily malfunctioning. <a href="javascript:history.go(0);">Reload the page.</a></b><p>';
// echo '<br><p><b><a href="http://board.projectjj.com/viewtopic.php?t=625">Read Me: Power Outage</a></b></p>';
die;
}
}
mysql_set_charset('utf8');
mysql_select_db($db_database, $GLOBALS['handler']);
}
/**
* DB Connect
* this method is private
* @param array $connection connection's value is db_hostname, db_port, db_database, db_userid, db_password
* @return resource
*/
function __connect($connection)
{
// Ignore if no DB information exists
if (strpos($connection['host'], ':') === false && $connection['port']) {
$connection['host'] .= ':' . $connection['port'];
}
// Attempt to connect
$result = @mysql_connect($connection['host'], $connection['user'], $connection['pass']);
if (!$result) {
exit('Unable to connect to DB.');
}
if (mysql_error()) {
$this->setError(mysql_errno(), mysql_error());
return;
}
// Error appears if the version is lower than 4.1.13
if (version_compare(mysql_get_server_info($result), '4.1.13', '<')) {
$this->setError(-1, 'Rhymix requires MySQL 4.1.13 or later. Current MySQL version is ' . mysql_get_server_info());
return;
}
// Set charset
$this->charset = isset($connection['charset']) ? $connection['charset'] : 'utf8';
mysql_set_charset($this->charset, $result);
// select db
@mysql_select_db($connection['database'], $result);
if (mysql_error()) {
$this->setError(mysql_errno(), mysql_error());
return;
}
return $result;
}
private function drawStatistik()
{
global $html;
echo '<table class="stat"><thead>';
$this->th('Artsgruppe');
$this->th('Artsgruppe (dk)');
$this->th('Arter');
$this->th('Underarter');
$this->th('Varieteter');
$this->th('Former');
$this->th('Hybrider');
$this->th('Ikke accepterede arter');
echo '</thead></tbody>';
mysql_set_charset('utf8');
$SQL = 'select distinct Artsgruppe from allearter order by Artsgruppe';
// asc limit 1';
$result = $this->query($SQL);
$odd = false;
while ($row = mysql_fetch_array($result)) {
$this->drawStatistikItem($row['Artsgruppe'], $odd);
$odd = $odd == false ? true : false;
}
echo '<tr><td colspan="2" class="total">Total</td>';
echo '<td class="right total">' . $this->total['art'] . '</td>';
echo '<td class="right total">' . $this->total['underart'] . '</td>';
echo '<td class="right total ">' . $this->total['varietet'] . '</td>';
echo '<td class="right total">' . $this->total['form'] . '</td>';
echo '<td class="right total">' . $this->total['hybrid'] . '</td>';
echo '<td class="right total">' . $this->total['accepteret'] . '</td>';
echo '</tr>';
echo '</tbody></table>';
}
/**
* 创建数据库连接
* @param string $k 配置文件key
* @return resource
*/
function db($k = 'default')
{
$conf = conf('db', $k);
if (!$conf) {
trigger_error('Can\'t find $GLOBALS[\'db\'][\'' . $k . '\'] - in database.conf.php');
}
$db_key = md5("{$conf['hostname']}-{$conf['username']}-{$conf['password']}-{$conf['database']}");
if (!isset($GLOBALS[$db_key])) {
$server = $conf['hostname'] . ':' . $conf['port'];
$link = mysql_connect($server, $conf['username'], $conf['password'], TRUE);
if (!$link) {
trigger_error('Connect database be fail, Pealse inspect yours database setting!');
}
if (!mysql_select_db($conf['database'], $link)) {
trigger_error("Can't select database - {$conf['database']}, Pealse inspect yours database setting");
}
if (function_exists('mysql_set_charset')) {
$is_set_charset = mysql_set_charset($conf['char_set']);
} else {
if (function_exists('mysqli_character_set_name')) {
$is_set_charset = mysqli_character_set_name($conf['char_set']);
} else {
$is_set_charset = mysql_query("SET names '{$conf['char_set']}'");
}
}
if ($is_set_charset != TRUE) {
exit('charset error!');
}
//mysql_query( "SET names = '{$conf['char_set']}'" );
mysql_query("SET CHARACTER SET '{$conf['char_set']}'");
$GLOBALS[$db_key] = $link;
}
return $GLOBALS[$db_key];
}
/**
* Initial start params.
*/
private function __construct()
{
$params = (include_once 'bootstrap.php');
$connect = mysql_connect($params['db']['host'], $params['db']['user'], $params['db']['password']);
mysql_set_charset($params['db']['charset'], $connect);
mysql_select_db($params['db']['database']);
}
function connect_db()
{
global $myserv;
$myserv = mysql_connect("localhost", MYSQL_USER, MYSQL_PASSWD);
mysql_select_db(MYSQL_DATABASE);
mysql_set_charset('utf8');
}
private function drawReferences()
{
//$SQL='select distinct Referencenavn from allearter order by Referencenavn asc';
$SQL = 'select distinct Referencetekst, Referencenavn from allearter order by Referencenavn asc';
echo '<table class="stat" id="stat-referencer"><thead>';
$this->th('Referencenavn', 200);
$this->th('År', 30);
$this->th('Referencetitel', 600);
$this->th('Arter', 30);
echo '</thead><tbody>';
mysql_set_charset('utf8');
$result = $this->query($SQL);
$odd = false;
$processed = array();
while ($row = mysql_fetch_array($result)) {
//$ref=$row['Referencenavn'];
$ref = $row['Referencetekst'];
if (!in_array($ref, $processed)) {
if ($ref != '') {
$this->drawRow($ref, $odd);
$odd = $odd == false ? true : false;
}
$processed[] = $ref;
}
}
echo '</tbody></table>';
}
