Location: PHPKode > scripts > Quotations Database > quotations-database/readme.txt
:::: Quotations Database ::::
PHP & MySQL application that stores quotations and author information, 
allows scheduling for 'quote of the day' and weekly themes.
Includes an administration interface to allow for easy updates and maintenance.
Copyright (C) 2009  Robert Temple

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.

You can contact the author at hide@address.com


1) Create a new MySQL database called 'quotations' using your Website control panel (i.e. cPanel)

2) Create a new user for the MySQL database and give this user full access to the quotations database. Make a note of the username and password.

2) Import the 'Quotations.sql' file to the new database. If you're using phpMyAdmin, click on the quotations database. There will be a tab labeled "Import". Click on this tab and browse to the Quotations.sql file. Six new tables will be created. (If you're not using phpMyAdmin, MySQLAdministrator is a free alternative.)

3) In a text editor, open connect.php in the 'admin/include' folder and change line 12 to the correct database name. Change the username and password to the MySQL user you created in step 2: 
function dbconnect ($dbname="quotations",$user="username",$password="password",$server="localhost")

4) Upload the entire contents of the "quotations" folder, including the "admin" and "include" folders, to your Web server.
Open a Web browser and go to the URL of the authors.php page on your Website (ex: http://www.mywebsite.com/quotations/authors.php). You should see a list of 15 authors names. If you see an error page, confirm the information on the 'admin/include/connect.php' page is correct.

5) Go to the URL of the admin login page (ex: http://www.mywebsite.com/quotations/admin/include/login.php). Log in using the username 'admin' and password 'password'. You should see the Quotations Administration page. If you see an error page, confirm the information on the connect.php page is correct.

5) The very first thing you should do is edit the password for the admin user. Under the USER ADMINISTRATION section of the admin page, click on the "Edit/Delete Users" link and then the "edit" link next to the admin user. If you prefer, you can create a new user and delete the admin user. (WARNING: Only delete the admin user after creating at least one other user or you won't be able to log back in!)


Return current item: Quotations Database