Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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() {
- //Пример использования (через свойство)
- $query = $this->mysqli->prepare("SELECT `date_add`, `date_out` FROM `vkb_bans_ip` WHERE `active`='1' AND `ip`=?");
- $query->bind_param('s', $ip);
- $query->execute();
- }
- function __destruct() {
- $mysqli->close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement