Cytanet Official Website | F.A.Qs - Advanced Web Hosting

<?php
$dbhost = 'mysql-hosted.cytanet.com.cy';
$dbuser = 'username';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass)
or die ('Error connecting to mysql');
$dbname = 'username';
mysql_select_db($dbname);

$query = "SELECT name, subject FROM contact";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

echo "Name : {$row['name']} <br>" .
"Subject: {$row['subject']} <br><br>" .
}
?>

To connect from a Perl/CGI script, put this in your file:

#!/usr/bin/perl
use DBI;

$database = "username";
$hostname = "mysql-hosted.cytanet.com.cy";
$username = "username";
$password = 'password';

$dsn = "DBI:mysql:database=$database;host=$hostname";

$dbh = DBI->connect($dsn, $username, $password) or die("Could not connect!");

$sql = "SELECT * FROM mytable";

$sth = $dbh->prepare($sql);
$sth->execute;

while(($column1, $column2) = $sth->fetchrow_array)
{
print "C1 = $column1, C2 = $column2";
}

$dbh->disconnect;

Connect from an ASP / ASP.NET script:
Here is the actual code connection to the MySQL database

<%@ LANGUAGE = "VBSCRIPT" %>
<%
connect_string = "Driver={Mysql}; Server=mysql-hosted.cytanet.com.cy; Database=username;
Uid=username; Password=password"
set dbConn=server.createObject("ADODB.connection")
set rs=server.createObject("ADODB.RecordSet")
dbConn.open connect_string

SQL="Select field1,field2 from table_name "
rs.open SQL,dbConn,3,1
'Response.write rs.Fields(0)
If Not rs.EOF then
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
<br><Hr>
<% Response.Write rs.Fields("field1") %>
<% Response.Write rs.Fields("field2") %>
<% else%>
<BODY>
NO RESULT IN QUERY
<% End if %>
</BODY>
</HTML>

Comment: Where username, and password are your username and database password provided by Cytanet. In our solution we use the same username and database name.

17.

For any other question/clarification, who can help me?

Top of page