#1
  1. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    cool


    this works cool thanks ...whats next?
  2. #2
  3. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    here it is.....


    Code:
    <html><head>
    <title>recruitment</title>
    </head>
    <body bgcolor=whitesmoke>
    <? $image="details.jpg"; ?>
    <? include("scripts/header.inc.php"); 
    include("scripts/config.php"); 
    include("scripts/functions.php"); 
    ?>
    <table width="600" border="0" cellspacing="1">
    <tr><td><b>Job title</b></td><td><b>location</b></td><td><b>Salary</b></td><td><b>Posted</b></td><td></td></tr>
    <?php
    
    $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
    
    $query = "SELECT listing.designation, listing.jcode, location.location, salary.salary, listing.posted from listing, location, salary WHERE checked= 1 AND location.id = listing.fk_location AND salary.id = listing.fk_salary ";
    $result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
    while (list($designation, $jcode, $location, $salary, $posted) = mysql_fetch_row($result)) {
        print ("<tr>\n".
               "<td><a href=\"job_details.php?jcode=$jcode\"><b>$designation</b></a></td><td>$location</td><td>$salary</td><td>$posted</td><td><a href=\"apply.php?jcode=$jcode\"><img src=images/apply.gif width=50 height=16 border=0></a></td>\n".
               "</tr>\n");
    }
    
    mysql_close($connection);
    ?>
    </table>
    <? include("scripts/footer.inc.php"); ?>
    </body></html>
    this is kind of what i was talking about any ones you got?

  4. #3
  5. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: date function ,here it is.....


    Code:
    <html><head>
    <title>recruitment</title>
    <link rel="STYLESHEET" type="text/css" href="aidan.css">
    </head>
    <body background="images/background.gif">
    <? $image="details.jpg" ?>
    <? include("scripts/header.inc.php"); 
    include("scripts/config.php"); 
    include("scripts/functions.php"); 
    ?>
    <table width="600" border="0" cellspacing="2">
    <tr bgcolor="whitesmoke"><td>&nbsp;&nbsp;<b>Job title</b></td><td>&nbsp;&nbsp;<b>location</b></td><td>&nbsp;&nbsp;<b>Salary</b></td><td>&nbsp;&nbsp;<b>Posted</b></td><td>&nbsp;</td></tr>
    <?php
    $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
    $query = "SELECT listing.designation, listing.jcode, location.location, salary.salary, listing.posted from listing, location, salary WHERE checked= 1 AND location.id = listing.fk_location AND salary.id = listing.fk_salary  order by posted desc";
    $result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
    while (list($designation, $jcode, $location, $salary, $posted) = mysql_fetch_row($result)) {
        print ("<tr height=14>\n".
               "<td>&nbsp;&nbsp;<a href=\"job_details.php?jcode=$jcode\"><b>$designation</b></a></td><td>&nbsp;&nbsp;$location</td><td>&nbsp;&nbsp;$salary</td><td>&nbsp;&nbsp;$posted</td><td>&nbsp;&nbsp;<a href=\"apply.php?jcode=$jcode\"><img src=images/apply.gif width=50 height=14 border=0></a></td>\n".
               "</tr>\n");
    }
    mysql_close($connection);
    ?>
    </table>
    <? include("scripts/footer.inc.php"); ?>
    </body></html>
    with this code i was wondering if any one knows how i can display the date diferently. the $posted displays the date in 2001-06-17 and not thu 17th july 2001.
    how do i do it?

    thanks
  6. #4
  7. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: date function ,here it is.....


    What happened
  8. #5
  9. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: here it is.....


    Pretty Strange
  10. #6
  11. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    'The Perfect Job' 1&2


    Article '1' excellent, just looked brifly at '2'. Source code is mentioned, where is it please? Thanks in advance, Graham.
  12. #7
  13. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Error in sample data


    Don't know if was intentional or not, but FK_coutry = 98 in the sample resume and there are only 96 coutries in the country table. When you go to look at the resume details the code errors out.
  14. #8
  15. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: cool


    hey aiden mine is on win 98 and does not work yet any chance of some hepl please !
  16. #9
  17. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: cool


    yeah sorry dude i took so long i have made a better version of this now called phprofession 1.5

    download it here http://www.nerens.com/downloads/phprofession1.5.zip

    you will need postnuke to run it [oyu going to like post nuke it rules]

    www.postnuke.com

    or just have a look at the files and change it to suite you .

    later,
  18. #10
  19. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    'The Perfect Job'


    The article was nicely done. It's provided an excellent blueprint/HOWTO that covers a broad area of application. Well done!
  20. #11
  21. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)
  22. #12
  23. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)
  24. #13
  25. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Where's the Code


    There was some mention of downloading source code? It would be incredibly awesome to get the complete source code. I'm kinda new at PHP and need all the help I can get. :-)
  26. #14
  27. No Profile Picture
    Ducani
    Guest
    Devshed Newbie (0 - 499 posts)

    The Perfect Job (part 2)


    The Perfect Job \(part 2\)

    In the first part of this article, you built the architecture necessary to accept and store resumes online. In this concluding part, find out how to make use of the stored data to find suitable candidates for a particular job, and also read about the functions available to maintain and update the job listings.

    Please discuss this article in this thread. You can read the article here .

IMN logo majestic logo threadwatch logo seochat tools logo