EN 
Register

hosting: ValueHost 2.0
           

Help


Working with PHP

Here 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.
$db_login —  database user for connection, is being created simultaneously with database
$db_pass — password for database connection, is being set up on database creation. You can always retrieve it in corresponding section of service Control Panel.
$db_name — database name - equal to $db_login

 

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); 
?>