MySQL
- Quick Start Guide
Before installing wimpy you
should have the following already set up:
- A MySQL username and password. The user should have all priviliages.
- A MySQL database name (i.e. a database must already exist -- wimpy will
create and use a table on this database, you do NOT have to establish
the table before installation. The only thing that needs to be established
is a database.)
Step 1 - Set configuration
variables
Open wimpy_mysql_config.php
in a text editor and set the variables to match the username, password
and database settings for your MySQL connection.
Step 2 - Upload
wimpy + a couple MP3 files
Upload all of the MySQL connection script files to the same directory
that contains your MP3 files. The directory that contains your mp3 files
will be refered to as "your wimpy directory" and we will assume
that your "wimpy directory" is named "mp3s."
Example: www.yoursite.com/mp3s/
- wimpy.php
- wimpy.swf
- myWimpy.php <-- the HTML code
in this file was generated using the online customization tool at wimpyplayer.com
- wimpy_mysql_config.php
- wimpy_mysql_get.php
- wimpy_mysql_update.php
For testing purposes,
only upload a couple MP3 files + the example.mp3 file that came in the
demo package... You can download the demo package again by http://www.wimpyplayer.com/downloads.
- example.mp3
- one_of_yours.mp3
- two_of_yours.mp3
Step 3 - Add
files to the Database
Access the following page with your browser: wimpy.php
with the following command: ?action=updateMySQL.
Example:
www.yoursite.com/mp3s/wimpy.php?action=updateMySQL
Step 4 - Test Your
MySQL Connection
Access the following page with your browser: wimpy_mysql_get.php
Example:
www.yoursite.com/mp3s/wimpy_mysql_get.php
The first line of the
resulting page should display a long string of text that will look similiar
to:
&item0=http://www...etc...
If you receive an
error, check your wimpy_mysql_config.php settings and make sure that the
variables are all correct. Also make sure that the user your defined is
associated with your database and has full proviledges to modify the database.
If you do not receive
an error, upload a couple more mp3 files, don't go crazy just yet, only
upload about 5 or so. After the new mp3 file have been uploaded, repeat
step 3 (above) to update the database with the new files.
Step 5 - Use
the online customization tool
Got to the following link to generate code for the myWimpy.php page on
your web site.
http://www.wimpyplayer.com/customize/
When entering the last couple
of questions: "Where is wimpy.swf? and "Where is your wimpy
PHP file?" - be sure to use a full URL path to the files.
Example:
http://www.yoursite.com/mp3s/wimpy.swf
and
http://www.yoursite.com/mp3s/wimpy.php
Copy and paste the
resulting code into the myWimpy.php page, then upload it to your server.
Step 6 - Load
Wimpy
Access the following page with your browser: myWimpy.php
Example:
www.yoursite.com/mp3s/myWimpy.php
The resulting page should show wimpy and ALL of the songs located in your
database. Since no search criteria was sent in, wimpy display's all of
the songs in the database.
Step 7 - Load
a Playlist / Specifying Search Criteria
Access myWimpy.php with
your browser again, but this time tack on the the following
command to the URL:
?queryWhere=artist&QueryValue=Mike
Gieson
Example:
www.yoursite.com/mp3s/myWimpy.php?queryWhere=artist&QueryValue=Mike
Gieson
The resulting page should only load a single file. The file that loads
is the example.mp3 file that shipped with wimpy. In the playlist, you
will see the id3 information for that file, not the file name.
|