www.webdeveloper.com
Results 1 to 9 of 9

Thread: Novice needs help...

  1. #1
    Join Date
    Oct 2006
    Posts
    148

    Smile Novice needs help...

    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>

  2. #2
    Join Date
    Mar 2007
    Location
    Orlando
    Posts
    670
    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.

  3. #3
    Join Date
    Oct 2006
    Posts
    148
    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

  4. #4
    Join Date
    Oct 2006
    Posts
    148
    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?

  5. #5
    Join Date
    Oct 2006
    Posts
    148
    <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

  6. #6
    Join Date
    Mar 2007
    Location
    Orlando
    Posts
    670
    Did you do what it says in your instructions?

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

  7. #7
    Join Date
    Dec 2006
    Location
    Escaz˙ (Costa Rica) and Mallorca (Spain)
    Posts
    3,234
    Is this correct?
    Code:
    <server>http://localhost/jobs/jobs/</server>

  8. #8
    Join Date
    Oct 2006
    Posts
    148
    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

  9. #9
    Join Date
    Dec 2006
    Location
    Escaz˙ (Costa Rica) and Mallorca (Spain)
    Posts
    3,234

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles