예제 #1
0
 private function _fillEmployeeHistoryTable($dbName)
 {
     mysql_selectdb($dbName);
     /* Get employee data from `hs_hr_employee` and `hs_hr_job_title` tables */
     $query = "SELECT a.`emp_number` , a.`job_title_code` , a.`joined_date` , b.`jobtit_name` FROM hs_hr_employee a, hs_hr_job_title b WHERE a.`job_title_code` IS NOT NULL AND a.`job_title_code` = b.`jobtit_code`";
     $result = mysql_query($query);
     if (mysql_num_rows($result) > 0) {
         while ($row = mysql_fetch_array($result)) {
             if (isset($insertSqlSub)) {
                 $insertSqlSub = $insertSqlSub . ' , ' . '(' . "'" . $row['emp_number'] . "'" . ' , ' . "'" . $row['job_title_code'] . "'" . ' , ' . "'" . $row['jobtit_name'] . "'" . ' , ' . "'" . $row['joined_date'] . "'" . ' ) ';
             } else {
                 $insertSqlSub = '(' . "'" . $row['emp_number'] . "'" . ' , ' . "'" . $row['job_title_code'] . "'" . ' , ' . "'" . $row['jobtit_name'] . "'" . ' , ' . "'" . $row['joined_date'] . "'" . ' ) ';
             }
         }
         /* Insert data to hs_hr_emp_jobtitle_history table  */
         $insqrtSql = "INSERT INTO hs_hr_emp_jobtitle_history (`emp_number` , `code` , `name` , `start_date`) VALUES {$insertSqlSub}";
         if (!mysql_query($insqrtSql)) {
             $this->errorArray[] = "Filling Employee History table failed";
             return false;
         }
         return true;
     } else {
         return true;
     }
 }
예제 #2
0
파일: Mysql.php 프로젝트: godboko/modules
 private function initialize()
 {
     $this->_ensureModuleExistance();
     /* Initializes link to MySql */
     $this->link = mysql_connect("{$this->host}:{$this->port}", $this->user, $this->pass);
     if (mysql_error($this->link)) {
         throw new WURFL_Storage_Exception("Couldn't link to {$this->host} (" . mysql_error($this->link) . ")");
     }
     /* Initializes link to database */
     $success = mysql_selectdb($this->db, $this->link);
     if (!$success) {
         throw new WURFL_Storage_Exception("Couldn't change to database {$this->db} (" . mysql_error($this->link) . ")");
     }
     /* Is Table there? */
     $test = mysql_query("SHOW TABLES FROM {$this->db} LIKE '{$this->table}'", $this->link);
     if (!is_resource($test)) {
         throw new WURFL_Storage_Exception("Couldn't show tables from database {$this->db} (" . mysql_error($this->link) . ")");
     }
     // create table if it's not there.
     if (mysql_num_rows($test) == 0) {
         $sql = "CREATE TABLE `{$this->db}`.`{$this->table}` (\r\n\t\t\t\t\t  `{$this->keycolumn}` varchar(255) collate latin1_general_ci NOT NULL,\r\n\t\t\t\t\t  `{$this->valuecolumn}` mediumblob NOT NULL,\r\n\t\t\t\t\t  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,\r\n\t\t\t\t\t  PRIMARY KEY  (`{$this->keycolumn}`)\r\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci";
         $success = mysql_query($sql, $this->link);
         if (!$success) {
             throw new WURFL_Storage_Exception("Table {$this->table} missing in {$this->db} (" . mysql_error($this->link) . ")");
         }
     }
     if (is_resource($test)) {
         mysql_free_result($test);
     }
 }
예제 #3
0
function selectDb($config)
{
    if (connectDb($config)) {
        return mysql_selectdb($config['db']['dbname']);
    }
    return false;
}
예제 #4
0
 function SelectDatabase($p_sDatabase)
 {
     $this->m_bFileRead = false;
     if ($this->m_oLink && strlen($p_sDatabase)) {
         if (is_dir($p_sDatabase)) {
             $this->m_oLink = 0;
             $this->m_bFileRead = true;
             $this->m_sDatabase = $p_sDatabase;
             return true;
         } else {
             if (mysql_selectdb($p_sDatabase)) {
                 $this->m_sDatabase = $p_sDatabase;
                 return true;
             } else {
                 $this->m_oLink = 0;
                 $this->m_sDatabase = "";
                 return false;
             }
         }
     } else {
         if (is_dir($p_sDatabase)) {
             $this->m_oLink = 0;
             $this->m_bFileRead = true;
             $this->m_sDatabase = $p_sDatabase;
             return true;
         } else {
             $this->m_oLink = 0;
             $this->m_sDatabase = "";
             return false;
         }
     }
 }
예제 #5
0
 public function init()
 {
     define('DBPATH', 'localhost');
     define('DBUSER', 'root');
     define('DBPASS', 'root');
     define('DBNAME', 'bdpinos');
     // session_start();
     global $dbh;
     $dbh = mysql_connect(DBPATH, DBUSER, DBPASS);
     mysql_selectdb(DBNAME, $dbh);
     if ($_GET['action'] == "chatheartbeat") {
         chatHeartbeat();
     }
     if ($_GET['action'] == "sendchat") {
         sendChat();
     }
     if ($_GET['action'] == "closechat") {
         closeChat();
     }
     if ($_GET['action'] == "startchatsession") {
         startChatSession();
     }
     if (!isset($_SESSION['chatHistory'])) {
         $_SESSION['chatHistory'] = array();
     }
     if (!isset($_SESSION['openChatBoxes'])) {
         $_SESSION['openChatBoxes'] = array();
     }
 }
function Global_Init()
{
    //session_start();
    Load_Configs();
    if (!strnatcasecmp(trim($GLOBALS['db']['type']), "LB")) {
        require_once 'inc/dbmodule_LB.php';
    }
    if (!strnatcasecmp(trim($GLOBALS['db']['type']), "GD")) {
        require_once 'inc/dbmodule_GD.php';
    }
    //echo "GLOBALS: <BR>"; print_r($GLOBALS['db']); echo "<BR>";
    $source_db_ok = SQL_DB_OK("source");
    if ($source_db_ok['error'] === false) {
        $GLOBALS['db']['s_resource'] = @mysql_connect($GLOBALS['db']['s_host'], $GLOBALS['db']['s_user'], $GLOBALS['db']['s_pass']) or die($_SERVER["SCRIPT_FILENAME"] . "Could not connect to Source MySQL Server. : " . mysql_error());
        @mysql_selectdb($GLOBALS['db']['s_base']) or die("Could not connect to Source database [" . $GLOBALS['db']['s_base'] . "] : " . mysql_error());
        $GLOBALS['db']['x_resource'] = @mysql_connect($GLOBALS['db']['x_host'], $GLOBALS['db']['x_user'], $GLOBALS['db']['x_pass']) or die($_SERVER["SCRIPT_FILENAME"] . "Could not connect to X-Ray  MySQL Server. : " . mysql_error());
        @mysql_selectdb($GLOBALS['db']['x_base']) or die("Could not connect to X-Ray database [" . $GLOBALS['db']['x_base'] . "] : " . mysql_error());
        $GLOBALS['db']['s_link'] = mysqli_connect($GLOBALS['db']['s_host'], $GLOBALS['db']['s_user'], $GLOBALS['db']['s_pass'], $GLOBALS['db']['s_base']) or die($_SERVER["SCRIPT_FILENAME"] . "Could not connect to Source MySQL Server (multilink). : " . mysqli_error($GLOBALS['db']['s_link']));
        mysqli_select_db($GLOBALS['db']['s_link'], $GLOBALS['db']['s_base']) or die("Could not connect to Source database (multilink) [" . $GLOBALS['db']['s_base'] . "] : " . mysqli_error($GLOBALS['db']['s_link']));
        $GLOBALS['db']['x_link'] = mysqli_connect($GLOBALS['db']['x_host'], $GLOBALS['db']['x_user'], $GLOBALS['db']['x_pass'], $GLOBALS['db']['x_base']) or die($_SERVER["SCRIPT_FILENAME"] . "Could not connect to X-Ray MySQL Server (multilink). : " . mysqli_error($GLOBALS['db']['x_link']));
        mysqli_select_db($GLOBALS['db']['x_link'], $GLOBALS['db']['x_base']) or die("Could not connect to X-Ray database (multilink) [" . $GLOBALS['db']['x_base'] . "] : " . mysqli_error($GLOBALS['db']['x_link']));
    } else {
        $config_error .= $source_db_ok['message'] . "<BR>";
    }
    //	array_key_exists('form', $_POST) && $_POST['form']!="" ? $_GET = $_POST : NULL;
    //	array_key_exists('force', $_GET) && $_GET['force']!="" ? $_POST = $_GET : NULL;
    if (count($_GET) > 0) {
        $_POST = $_GET;
    }
    //	if($_POST['form']!=""){$_GET = $_POST;}
    //	if($_GET['force']!=""){$_POST = $_GET;}
    if (!FixOutput_Bool($GLOBALS['config_settings']['settings']['first_setup'], true, false, true)) {
        $GLOBALS['worlds'] = Get_Worlds_Enabled();
    }
}
예제 #7
0
 function __construct()
 {
     $this->con = mysql_connect("localhost", "wemake_db", "Dsquare@123");
     if (!$this->con) {
         die('Could not connect: ' . mysql_error());
     }
     mysql_selectdb("admin", $this->con);
 }
예제 #8
0
function connectDb()
{
    global $conn;
    $conn = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("can't connect to mysql=>" . mysql_error());
    mysql_selectdb(DB_NAME, $conn);
    mysql_query("SET NAMES utf8", $conn);
    //set utf8
}
예제 #9
0
 function __construct()
 {
     $this->con = mysql_connect("localhost", "root", "");
     if (!$this->con) {
         die('Could not connect: ' . mysql_error());
     }
     mysql_selectdb("wemakesc_wemakescholars", $this->con);
 }
예제 #10
0
function connectDB()
{
    $conn = mysql_connect('localhost', 'root', '');
    if (!$conn) {
        echo "connection failed";
    }
    mysql_selectdb('softwareProject', $conn);
    return $conn;
}
예제 #11
0
 public function dbconnect()
 {
     global $db_username;
     global $db_password;
     global $db_database;
     global $db_host;
     $conn = mysql_connect($db_host, $db_username, $db_password);
     mysql_selectdb($db_database);
 }
예제 #12
0
파일: fun.php 프로젝트: Vagor/practice
function connectDB()
{
    $conn = mysql_connect('localhost', 'root', '123456');
    if (!$conn) {
        echo "connection failed";
    }
    mysql_selectdb('test', $conn);
    return $conn;
}
예제 #13
0
 public static function switchToEcontent()
 {
     global $configArray;
     if (!SwitchDatabase::$changedDB) {
         if (SwitchDatabase::isVuFindDatabase()) {
             mysql_selectdb($configArray['Database']['database_econtent_dbname']);
             SwitchDatabase::$changedDB = true;
         }
     }
 }
예제 #14
0
 public function __construct()
 {
     $this->db_host = "localhost";
     $this->db_db = "xing_contacts";
     $this->db_username = "******";
     $this->db_password = "******";
     mysql_connect($this->db_host, $this->db_username, $this->db_password);
     mysql_selectdb($this->db_db);
     mysql_query("INSERT INTO zugriffe (name) VALUE ('" . $_SESSION['mode'] . "')");
 }
예제 #15
0
function connectToDB()
{
    $userName = "******";
    $password = "******";
    $server = "localhost";
    $db = mysql_connect($server, $userName, $passwork);
    if ($db != false) {
        mysql_selectdb("PushNotification");
        mysql_set_charset('utf-8');
    }
    return $db;
}
예제 #16
0
 public function connect()
 {
     if (!self::$link) {
         self::$link = mysql_connect(self::$host, self::$user, self::$password);
         mysql_set_charset('UTF8');
         if (!self::$link) {
             die('mysql connect error' . mysql_error());
         }
         mysql_selectdb(self::$db, self::$link);
     }
     return self::$link;
 }
예제 #17
0
파일: db.php 프로젝트: batnyam/shop
function connectDb()
{
    require 'config.php';
    $db = mysql_connect($cfg['dbServer'], $cfg['dbuser'], $cfg['dbpass']);
    if ($db === false) {
        die("Can't connect to database");
    }
    if (mysql_selectdb($cfg['dbname'], $db) === false) {
        die("Can't connect to database");
    }
    mysql_query("SET NAMES utf8");
    return $db;
}
예제 #18
0
 public function __construct($host, $username, $password, $database, $storage)
 {
     if (!mysql_selectdb($database, mysql_connect($host, $username, $password))) {
         die('Database connection failed.');
     } elseif ($this->caching) {
         if (!is_dir($this->storage)) {
             die('The cache directory not exists.');
         } elseif (!is_writable($this->storage)) {
             die('The cache directory is not writable. You should fix the permissions.');
         } else {
             $this->storage = $storage;
         }
     }
 }
예제 #19
0
 function __construct()
 {
     $this->list_error = array();
     $this->link = @mysql_connect(DB_HOST, DB_USER, DB_PASS);
     if (mysql_error($this->link)) {
         $this->list_error[] = mysql_error($this->link);
     } else {
         @mysql_selectdb(DB_NAME, $this->link);
         if (mysql_error($this->link)) {
             $this->list_error[] = mysql_error($this->link);
         } else {
             mysql_set_charset('utf8', $this->link);
         }
     }
 }
예제 #20
0
function db_connect() {
  global $DBI_DATABASE, $DBI_USERNAME, $DBI_PASSWORD, $DBI_HOST, $DBI_ERROR, $DBI_HANDLE;
  if (!$DBI_HANDLE) {
    if (!($DBI_HANDLE = mysql_connect($DBI_HOST, $DBI_USERNAME, $DBI_PASSWORD))) {
      db_set_error(mysql_error());
      return 0;
    }

    if (!mysql_selectdb($DBI_DATABASE, $DBI_HANDLE)) {
      db_set_error(mysql_error());
      mysql_close($DBI_HANDLE);
      $DBI_HANDLE=undef;
      return 0;
    }
  }
  return 1;
};
예제 #21
0
 function mysql_dump($database)
 {
     $query = '';
     $c = mysql_connect('localhost', 'monitor', 'monitor');
     mysql_selectdb($database);
     $tables = mysql_list_tables($database);
     while ($row = mysql_fetch_row($tables)) {
         $table_list[] = $row[0];
     }
     for ($i = 0; $i < count($table_list); $i++) {
         $results = mysql_query('SHOW ' . $database . '.' . $table_list[$i]);
         $query .= 'DROP TABLE IF EXISTS `' . $database . '.' . $table_list[$i] . '`;' . lnbr;
         $query .= lnbr . 'CREATE TABLE `' . $database . '.' . $table_list[$i] . '` (' . lnbr;
         $tmp = '';
         while ($row = mysql_fetch_assoc($results)) {
             $query .= '`' . $row['Field'] . '` ' . $row['Type'];
             if ($row['Null'] != 'YES') {
                 $query .= ' NOT NULL';
             }
             if ($row['Default'] != '') {
                 $query .= ' DEFAULT \'' . $row['Default'] . '\'';
             }
             if ($row['Extra']) {
                 $query .= ' ' . strtoupper($row['Extra']);
             }
             if ($row['Key'] == 'PRI') {
                 $tmp = 'primary key(' . $row['Field'] . ')';
             }
             $query .= ',' . lnbr;
         }
         $query .= $tmp . lnbr . ');' . str_repeat(lnbr, 2);
         $results = mysql_query('SELECT * FROM ' . $database . '.' . $table_list[$i]);
         while ($row = mysql_fetch_assoc($results)) {
             $query .= 'INSERT INTO `' . $database . '.' . $table_list[$i] . '` (';
             $data = array();
             while (list($key, $value) = each($row)) {
                 $data['keys'][] = $key;
                 $data['values'][] = addslashes($value);
             }
             $query .= join($data['keys'], ', ') . ')' . lnbr . 'VALUES (\'' . join($data['values'], '\', \'') . '\');' . lnbr;
         }
         $query .= str_repeat(lnbr, 2);
     }
     return $query;
 }
예제 #22
0
 function __construct()
 {
     $this->list_error = array();
     //$this->link=@mysql_connect("mysql16.000webhost.com", "a1062527_admin", "admin123");
     $this->link = @mysql_connect("localhost", $this->dbUser, $this->dbPassword);
     //$this->link=@mysql_connect("localhost", "kijam_ray", "abc123"/*"root1234"*/);
     if (mysql_error($this->link)) {
         $this->list_error[] = mysql_error($this->link);
     } else {
         //@mysql_selectdb("a1062527_censo", $this->link);
         @mysql_selectdb("Censo", $this->link);
         //@mysql_selectdb("kijam_ray", $this->link);
         if (mysql_error($this->link)) {
             $this->list_error[] = mysql_error($this->link);
         } else {
             mysql_set_charset('utf8', $this->link);
         }
     }
 }
 function connect()
 {
     if (!$this->connection) {
         $this->getConnectionSettings();
         if ($this->connection = @mysql_connect($this->host, $this->username, $this->password)) {
             if (@mysql_selectdb($this->database, $this->connection)) {
                 return true;
             } else {
                 $this->trace("Could not find database: ('{$this->database}')");
                 return false;
             }
         } else {
             $this->trace("Could not connect to '{$this->host}' with username '{$this->username}'");
             return false;
         }
     } else {
         return true;
     }
 }
예제 #24
0
function db_init()
{
    global $gl_db_init;
    global $gl_db_system;
    if (!$gl_db_init) {
        $config = parse_ini_file(dirname(__FILE__) . '/../../vacationblog.ini');
        if (isset($_ENV['DB_NAME'])) {
            $dbname = $_ENV['DB_NAME'];
        } else {
            $dbname = $config['dbname'];
        }
        if (isset($_ENV['DB_HOST']) && isset($_ENV['DB_PORT'])) {
            $hostname = $_ENV['DB_HOST'] . ':' . $_ENV['DB_PORT'];
        } else {
            if (isset($_ENV['DB_HOST'])) {
                $hostname = $_ENV['DB_HOST'];
            } else {
                $hostname = $config['hostname'];
            }
        }
        if (isset($_ENV['DB_USERNAME'])) {
            $username = $_ENV['DB_USERNAME'];
        } else {
            $username = $config['username'];
        }
        if (isset($_ENV['DB_PASSWORD'])) {
            $password = $_ENV['DB_PASSWORD'];
        } else {
            $password = $config['password'];
        }
        // echo "Connect to $hostname as $username with password $password<br/>\n";
        // echo "dbname = '$dbname'<br/>\n";
        if (!mysql_connect($hostname, $username, $password)) {
            echo "Could not connect: " . mysql_error() . '<br/>\\n';
        }
        mysql_selectdb($dbname);
        $gl_db_init = true;
    }
}
예제 #25
0
 function __construct()
 {
     parent::__construct();
     if (isset($_GET['idmanga'])) {
         $id = $_GET['idmanga'];
         $conn = mysql_connect("localhost", "root", "") or die("Khong ket noi duoc toi server");
         $db = mysql_selectdb("manga", $conn) or die("Khong ket noi duoc toi CSDL");
         $sql = "delete from manga where idmanga = '{$id}' ";
         mysql_query($sql) or die("Loi truy van 1 ");
         mysql_close($conn);
         header('location:admin');
     }
     if (isset($_GET['idchap'])) {
         $id = $_GET['idchap'];
         $conn = mysql_connect("localhost", "root", "") or die("Khong ket noi duoc toi server");
         $db = mysql_selectdb("manga", $conn) or die("Khong ket noi duoc toi CSDL");
         $sql = "delete from chap where idchap = '{$id}' ";
         mysql_query($sql) or die("Loi truy van 2");
         mysql_close($conn);
         header('location:admin');
     }
 }
예제 #26
0
/**
 * 创建连接
 */
function db($name = 'default')
{
    if (PRODUCTION == false) {
        $config = $GLOBALS['config']['db']['test'];
    } else {
        $config = $GLOBALS['config']['db'][$name];
    }
    $host = $config['host'];
    $port = $config['port'];
    $user = $config['user'];
    $password = $config['password'];
    $db_name = $config['db_name'];
    $db_key = MD5($host . '-' . $port . '-' . $user . '-' . $password . '-' . $db_name);
    if (!isset($GLOBALS['DB_' . $db_key])) {
        $con = mysql_connect($host . ':' . $port, $user, $password, true);
        if ($con && mysql_selectdb($db_name)) {
            @mysql_query('SET NAMES UTF8');
            $GLOBALS['DB_' . $db_key] = $con;
        } else {
            throw new Exception("Cannot connect to db");
        }
    }
    return $GLOBALS['DB_' . $db_key];
}
예제 #27
0
		$xmlcode .= "<content>$content</content>\n";
		$xmlcode .= "</node>\n"; //DB쿼리로 받아낸 title과 content값을 xml파일에 출력하기 위한 코드
	}
	 
	$dir = "C:/APM_Setup/htdocs"; //board_searchresult.xml 파일을 저장할 경로
	$filename = $dir."/board_searchresult.xml";
	 
	file_put_contents($filename, $xmlcode); //xmlcode의 내용을 xml파일로 출력
	mysql_close($connect);
	
?>
<?

	$connect = mysql_connect('localhost', 'root', 'apmsetup');
	
	mysql_selectdb("mydb");
	mysql_query("set names utf8");
	$qry = "SELECT * FROM board";
	$result = mysql_query($qry);
	$total_record = mysql_num_rows($result);
	echo "total_record=".$total_record."<p>";
	while($row_array = mysql_fetch_array($result)){
		echo("$row_array[uid] | $row_array[title] | $row_array[content] | 
		<a href='board_fix.php?uid=$row_array[uid]'>수정</a> <a href='board_delete.php?uid=$row_array[uid]'>삭제</a><br>");
	}
	
	
	
	mysql_close($connect);
	
?> 
예제 #28
0
<?php

define('DB_SERVER', 'oraserv.cs.siena.edu');
define('DB_PORT', '3306');
define('DB_USERNAME', 'perm_alphabit');
define('DB_PASSWORD', 'dour=punish-guild');
define('DB_NAME', 'perm_alphabit');
$dbh = mysql_connect(DB_SERVER . ':' . DB_PORT, DB_USERNAME, DB_PASSWORD);
if (!$dbh) {
    echo "Oops! Something went horribly wrong.";
    exit;
}
mysql_selectdb(DB_NAME, $dbh);
//session_start();
#!/usr/bin/php
<?php 
$SQL = "select * from settings where name like 'weathermap_%'";
require dirname(__FILE__) . '/../../../include/config.php';
$link = mysql_connect($database_hostname, $database_username, $database_password) or die('Could not connect: ' . mysql_error());
mysql_selectdb($database_default, $link) or die('Could not select database: ' . mysql_error());
$nmaps = 0;
$warnings = 0;
$result = mysql_query($SQL) or die(mysql_error());
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $values[$line['name']] = $line['value'];
}
$nmaps = $values['weathermap_last_map_count'];
$SQL = "select sum(warncount) as c from weathermap_maps where active='on'";
$result = mysql_query($SQL) or die(mysql_error());
$line = mysql_fetch_array($result, MYSQL_ASSOC);
$warnings = $line['c'];
$duration = $values['weathermap_last_finish_time'] - $values['weathermap_last_start_time'];
if ($duration < 0) {
    $duration = "U";
}
print "duration:{$duration} nmaps:{$nmaps} warnings:{$warnings} ";
if (isset($values['weathermap_final_memory']) && isset($values['weathermap_initial_memory']) && $values['weathermap_loaded_memory'] && isset($values['weathermap_highwater_memory'])) {
    print "initmem:" . $values['weathermap_initial_memory'] . " ";
    print "loadedmem:" . $values['weathermap_loaded_memory'] . " ";
    print "finalmem:" . $values['weathermap_final_memory'] . " ";
    print "highmem:" . $values['weathermap_highwater_memory'] . " ";
} else {
    print "initmem:U loadedmem:U finalmem:U highmem:U";
}
if (isset($values['weathermap_final_memory'])) {
예제 #30
0
<?php

session_start();
if (!$_SESSION['id']) {
    header('location:index.php');
}
$con = mysql_connect('localhost', 'root', '');
mysql_selectdb("zndb", $con);
$sql = "SELECT * FROM posts order by postdate desc";
$result = mysql_query($sql);
echo '<center><img src="zinnah_overseas_144.png" alt="Zinnah Admin"></center>';
echo "<br/>";
echo "<center><a href='homer.php'>Go back to home page</a></center>";
while ($row = mysql_fetch_array($result)) {
    echo $row['postname'];
    echo "<br/>";
    echo $row['postcontent'];
    echo "<br/>";
    echo $row['postdate'];
    echo "<br/>";
    echo "<br/>";
}
?>



<html>
<style>
body {
    background-image: url("22.jpg");
}