Novice needs help...

[le007]

Hey all I found this free job php script on the net - I really could do with implementing it into my site. Can someone tell me how exactly to do this? I have WAMP set up on my machine. I have phpmyadmin up and running fine. It says to run admin/jobs.sql against my database - what should I call the db and tables etc?

Can anyone please just give me direct instructions as to what to do? Thanks! Even give examples of what username and password to use etc.

http://localhost/jobs/
Thats where I have the folder in jobs. Thanks!!!!!!


-use phpmyadmin or your mysql interface to run admin/jobs.sql against your database.
-open site.xml and edit the database section with your database details.
-go to admin/ and login with username of admin with a password of test.
-be sure to change the passwords for the admin and regular user.

Setup the site.xml file with your database settings as follows.

<database type="mysql">
<server>database server address</server>
<login>database login</login>
<password>database password</password>
<default>mysql database name</default>
</database>

Add this to your htaccess file to prevent viewing of the xml config file.
<Files ~ ".xml">
Order allow,deny
Deny from all
Satisfy All
</Files>

[jasonahoule]

You can run the jobs.sql script from phpMyAdmin. There is a button on the left that says "SQL" (Query Window not documentation) and you can import the file from there. It will most likely create every thing you need. Ther rest of it is pretty straight forward. Just follow the instructions you listed above.

[le007]

Hi Jason - thanks for your reply!

What DB should I create / have created?

Error
SQL query:

# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 15, 2004 at 09:35 PM
# Server version: 4.0.18
# PHP Version: 4.3.6
#
# Database : `db91876756`
#
# --------------------------------------------------------
#
# Table structure for table `job_categories`
#
CREATE TABLE `job_categories` (

`category_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`category_title` varchar( 200 ) NOT NULL default '',
PRIMARY KEY ( `category_id` )
) TYPE = MYISAM AUTO_INCREMENT =5;



MySQL said:

#1046 - No database selected

[le007]

Hey - I set up a db called leo and it imported fine! I don't know how to set up the username and password etc though?

[le007]

<database type="mysql">
<server>http://localhost/jobs/jobs/</server>
<login>root</login>
<password></password>
<default>jobs2</default>
</database>

I tried this - everytime I go into jobs it just goes to index.php I cant access the admin folder - I'm completely and utterly lost here, ANY help to get this working would be great. Thanks

[jasonahoule]

Did you do what it says in your instructions?

-go to admin/ and login with username of admin with a password of test.

[NightShift58]

Is this correct?

<server>http://localhost/jobs/jobs/</server>

[le007]

Hey all -
yeah that was correct NightShift58, however a friend told me the script in general is all messed up. Does anyone know of a good stable (usable) FREE CMS php script? I need to be able to upload pics and delete them HOPEFULLY by connecting to MySQL. Thanks,
Le007

[NightShift58]

http://www.supersimple.org/