|
EN
|
Register |
|
Help |
Working with PHPHere you can find examples of PHP-scripts which will help you to start working with our servers. $db_server — database server address for your account. Can be retrieved in service Control Panel.
Connect to MySQL (mysql):
<?php
$db_server = 'db*.valuehost.ru'; $db_login = 'adminlogin_test'; $db_pass = 'MsBs1sT0'; $db_name= 'adminlogin_test'; $dbh = mysql_connect($db_server,$db_login,$db_pass); if(!$dbh) die('Could not connect to database'); mysql_select_db($db_name,$dbh) || die('Could not select database: '.mysql_error($dbh)); $query = 'SELECT VERSION()'; $result = mysq_query($query) || die('Could not execute query ('.$query.'): '.mysql_error($dbh)); echo 'MySQL Server version: '.reset(mysql_fetch_row($result)); mysql_close($dbh); ?>
Connect to MySQL (mysqli):<?php
$db_server = 'db*.valuehost.ru'; $db_login = 'adminlogin_test'; $db_pass = 'MsBs1sT0'; $db_name= 'adminlogin_test'; $dbh = $mysqli = new mysqli($db_server,$db_login,$db_pass,$db_name); if($dbh->connect_error) die('Could not connect to database: '.$dbh->connect_error); $query = 'SELECT VERSION()'; $result = $dbh->query($query) ||die('Could not execute query ('.$query.'): '.$dbh->error); echo 'MySQL server version: '.reset($result->fetch_row()); $dbh->close(); ?>
Connect to PostgreSQL:
<?php
$db_server = 'db*.valuehost.ru'; $db_login = 'adminlogin_test'; $db_pass = 'MsBs1sT0'; $db_name= 'adminlogin_test'; $dbh = pg_connect('host='.$db_server.' port=5432 dbname='.$db_name.' user='.$db_login.' password='.$db_pass); if(!$dbh) die('Could not connect to database'); $query = 'SELECT VERSION()'; $result = pg_query($query) ||die('Could not execute query ('.$query.'): '.pg_last_error($dbh)); echo ' PostgreSQL server version: '.reset(pg_fetch_row($result)); pg_close($dbh); ?> |