|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 15th, 2001, 01:32 PM
|
|||
|
|||
|
cool
this works cool thanks ...whats next?
|
|
#2
July 17th, 2001, 05:47 PM
|
|||
|
|||
|
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?
|
|
#3
July 20th, 2001, 12:03 PM
|
|||
|
|||
|
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> <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 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> <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=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
|
|
#4
July 26th, 2001, 02:18 PM
|
|||
|
|||
|
Re: date function ,here it is.....
What happened
|
|
#5
July 26th, 2001, 02:20 PM
|
|||
|
|||
|
Re: here it is.....
Pretty Strange
|
|
#6
August 10th, 2001, 04:35 AM
|
|||
|
|||
|
'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.
|
|
#7
September 18th, 2001, 11:54 PM
|
|||
|
|||
|
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.
|
|
#8
September 22nd, 2001, 12:14 PM
|
|||
|
|||
|
Re: cool
hey aiden mine is on win 98 and does not work yet any chance of some hepl please !
|
|
#9
September 28th, 2001, 06:40 AM
|
|||
|
|||
|
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,
|
|
#10
November 5th, 2001, 10:18 PM
|
|||
|
|||
|
'The Perfect Job'
The article was nicely done. It's provided an excellent blueprint/HOWTO that covers a broad area of application. Well done!
|
|
#11
January 28th, 2002, 07:04 AM
|
|||
|
|||
|
|
#12
February 22nd, 2002, 04:53 AM
|
|||
|
|||
|
|
#13
November 14th, 2002, 10:55 AM
|
|||
|
|||
|
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. :-)
|
|
#14
May 29th, 2003, 11:22 AM
|
|||
|
|||
|
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 .
|
|
| Viewing: Dev Shed Forums > Other > Development Articles > The Perfect Job (part 2) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
