| 1. | Q. | What is Front Page Extensions?
Front page extensions are a set of server-side applications that enable you to incorporate advanced features to your WebPages without having to write the complex server-side programs typically required. Front page extensions allow you to:Create a Web page directly on a Web server. Save directly to a Web server when using Office programs. Include these FrontPage components on a webpage: link bars, top 10 lists, form handlers, discussions, full text searches, hit counters and categories.
For more information go to http://office.microsoft.com/en-gb/default.aspx |
| 2. | Q. | What is PHP (Hypertext Pre-processor)?
PHP is a server-side scripting language that facilitates the creation of dynamic Web pages by embedding PHP-coded logic in HTML documents. It combines many of the finest features of Perl, C and Java and adds its own elements to the concoction to give Web programmers great flexibility and power in designing and implementing dynamic, content-oriented Web pages.
For more information go to www.php.net
|
| 3. | Q. | What is ASP (Active Server Pages)?
ASP is a specification for a dynamically created Web page with an ASP extension that utilizes ActiveX scripting, usually VB Script or Jscript code. When a browser requests an ASP, the Web server generates a page with HTML code and sends it back to the browser. So ASPs are similar to CGI scripts, but they enable Visual Basic programmers to work with familiar tools.
For more information go to www.asp.net
|
| 4. | Q. | What is SSI (Server Side Includes)?
SSIs are directives that are placed in HTML pages, and evaluated on the server while the pages are being served. They let you add dynamically generated content to an existing HTML page, without having to serve the entire page via a CGI program, or other dynamic technology. |
| 5. | Q. | What is CGI (Common Gateway Interface)?
CGI is a standard for interfacing external applications with information servers, such as HTTP or Web servers. A plain HTML document that the Web daemon retrieves is static, which means it exists in a constant state: a text file that doesn't change. A CGI program, on the other hand, is executed in real-time, so that it can output dynamic information. |
| 6. | Q. | What is Perl (Practical Extraction and Reporting Language)?
Perl is an interpreted language optimized for scanning arbitrary text files, extracting information from those files, and printing reports based on that information. It embodies powerful operations such as regular expression substitution, and an expression syntax that corresponds quite closely to that in C. It also supports dynamically scoped variables and functions, nested data structures and exception handling. Although optimized for scanning text, Perl can also deal with binary data.
For more information go to www.perl.com |
| 7. | Q. | What is Mysql?
MySQL is an open source database management system. A database is a collection of data that is organized so that its contents can easily be accessed, managed and updated. Is structured to facilitate the search and retrieval of information contained in the database. A database can be used to organise and enrich the content of a webpage.
For more information go to www.mysql.com |
| 8. | Q. | Is .net platforms supported?
.net platforms are not supported at the moment. |
| 9. | Q. | Is jsp supported?
Jsp is not supported at the moment. |
| 10. | Q. | How can I change my ftp/ front page extensions password?
Contact the Cytanet Call Center at 8000 8080.
|
| 11. | Q. | How can I change Mysql password?
Contact the Cytanet Call Center at 8000 8080. |
| 12. | Q. | Which Perl modules are installed?
Click here to see all Perl modules. |
| 13. | Q. | Which PHP modules are installed?
Click here to see all PHP modules.
|
| 14. | Q. | The module I need is not installed how can it be installed?
Fill in the Request Form. |
| 15. | Q. | How can I upgrade my html service?
Contact the Cytanet Call Center at 8000 8080. |
| 16. | Q. | How can I connect to the database?
Opening a connection to MySQL database from PHP is easy. Just use the mysql_connect() function like this:
<?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. | Q. | For any other question/clarification, who can help me?
Contact the Cytanet Call Center at 8000 8080.
|
Hide All
Show All Answers