/    Sign up×
Community /Pin to ProfileBookmark

Novice needs help…

Copy linkTweet thisAlerts:
Mar 09.2007

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.

[url]http://localhost/jobs/[/url]
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>

to post a comment
PHP

8 Comments(s) ↴

Copy linkTweet thisAlerts:
@jasonahouleMar 09.2007 — 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.
Copy linkTweet thisAlerts:
@le007authorMar 09.2007 — 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
Copy linkTweet thisAlerts:
@le007authorMar 09.2007 — 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?
Copy linkTweet thisAlerts:
@le007authorMar 09.2007 — <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
Copy linkTweet thisAlerts:
@jasonahouleMar 09.2007 — Did you do what it says in your instructions?

-go to admin/ and login with username of admin with a password of test.[/QUOTE]
Copy linkTweet thisAlerts:
@NightShift58Mar 09.2007 — Is this correct?&lt;server&gt;http://localhost/jobs/jobs/&lt;/server&gt;
Copy linkTweet thisAlerts:
@le007authorMar 13.2007 — 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
×

Success!

Help @le007 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...