Jump to content
xisto Community
romeo123

Databases

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.