Untitled

<?php

$db = mysql_connect('localhost', 'user', 'password');
mysql_select_db('bdname', $db);
$result = mysql_query('SELECT * FROM таблица WHERE id=2', $db);
$row = mysql_fetch_array($result);
echo $row[image];

?>

$server = "localhost";
$user = "admin";
$pass = "demo";
$database = "my_database";

include("db-info.php");
$link = mysql_connect($server, $user, $pass);
if(!mysql_select_db($database)) die(mysql_error());

$result = mysql_query("SELECT * FROM `users`");
$r = mysql_fetch_array($result);

$name = $r['name'];

<?php
    include("db-info.php");
    $link = mysql_connect($server, $user, $pass);
    if(!mysql_select_db($database)) die(mysql_error());

    $result = mysql_query("SELECT * FROM `users`");
    $r = mysql_fetch_array($result);

    $name = $r['name'];
?>
<html>
    <head>
        //сдесь содержимое хэдэра
    </head>
<body>
     <p><?php echo $name; ?></p>
</body>
</html>

class Base {
      function conn() { // подключение к БД
        mysql_connect('localhost','user','password');
        mysql_select_db('bdname');
      }
}

$object = new Base(); // создаем объект
$object->conn(); // подключаемся к БД
$result = mysql_query('SELECT * FROM таблица WHERE id=2 ');
$row =  mysql_fetch_array($result);
echo $row[image];

class main {

    function __construct() {
        //Создаем свойство содержащее объект MySQLi
        $this->mysqli = new mysqli($host, $user, $password, $database, $port, $socket);
    }

    //Некий метод
    public function someMethod() {
        //Пример использования (через свойство)
        $sql = "SELECT
                  `date_add`,
                  `date_out`
                FROM
                  `vkb_bans_ip`
                WHERE
                  `active`='1' AND `ip`=?";
        $query = $this->mysqli->prepare($sql);
        $query->bind_param('s', $ip);
        $query->execute();
    }
    function __destruct() {
        $mysqli->close();
    }
}