Honesty Rocks! truth rules.


HOME      >>       Programming


How do you access databases?Even though i don't have a hosting account yet i want to think ahead. Please help thx,romeo123


It depends on what you want to do with them. Many people use server software packages such as MediaWiki (to make a clone of WikiPedia), or phpBB for bulletin boards. In each case, these programs use databases to store and retrieve the contents of their web pages.

As a result, they take care of using the database themselves. Usually, to set up such a program, you first need to create a database account on the server, then tell the MediaWiki or phpBB software what the userid and password are for that account. Many "free" or low-cost hosting services limit users to very few database accounts. Xisto does not. :P That is one of the reasons I am here.

If you really want to use one of these databases "barefoot," you need to study SQL. I really do not recommend that, as you will see here and here. If you are determined, have at it! :(

Otherwise, find an application that is already built, and close to what you want. In Windows, look at Ms Access, Writer's Project Organizer or Album Shaper. In Linux, look at Beagle or GnuCash, which you may find more of a challenge to install.

On most modern operating systems, the "database engine" understands SQL commands, but the typical user finds an application that generates the SQL commands for him.


More precisely, when you are hosted at Xisto (like on most of modern host offering cpanel), once you clicked in "create a database" you are asked a lot of questions about the database name and the user name, and then you are provided with the connection strings for connecting to your database. The informations are like these, they explain how to connect depending if you connect from a perl program, or from php, or from JDBC :Connection StringsPerl $dbh = DBI->connect("DBI:mysql:myname_mydatabase:localhost","myname_mydatabase","<PASSWORD HERE>");PHP $dbh=mysql_connect ("localhost", "myname_mydatabase", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());mysql_select_db ("myname_mydatabase"); JDBC (may not be available) <%@ page import="java.sql.*" %> Connection connection = null; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); connection = DriverManager.getConnection( "jdbc:mysql://localhost/myname_mydatabase?user=myname_mydatabase&password=<PASSWORD HERE>"); Of course, here at Xisto, you will probably use pre-installed script. For instance the php installation and configuration scirpt will ask your for the database server (you enter "localhost"), the database name (the database name you just entered when creating the database) and the database administrator name.Hope this helped.Yordan