MySQL is an open source database that can greatly expand the functionality of your website. It is an advanced feature active and running on the UCI Spirit Server for clubs and organizations and is available by request. We will set up and configure a MySQL database for you, but the rest is up to you. If you are not interested in coding/scripting, this feature is probably not for you.
To use your MySQL database, we recommend using PHP code in your web pages to handle processes between the database and the web user, but we do not have the resources to provide any support for this, so you will have to do your own research.
*
http://www.mysql.com *
http://www.php.netAfter your MySQL database has been set up, you will be given a MySQL login and password which should be the same as your group's UCI Spirit account. The HOST name you use in your PHP code is "localhost", NOT "spirit.dos.uci.edu". Here is an example from php.net modified for use with the UCI Spirit Server...
<?php
/* Connecting, selecting database */
$link = mysql_connect("localhost", "SpiritUsername", "SpiritPassword")
?Ç ?Ç or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("DBnameUsuallyJustSpiritUserName") or die("Could not select database");
/* Closing connection */
mysql_close($link);
?>
?Ç
*If you would like more informations on MySQL tags, please
click here
