Jump to content

job search


jakebur01

Recommended Posts

Hey I have a client who is requesting this on their website:

 

"A visitor does a job search, listings come up, then, at the bottom it

has a place to submit your email if you want to be notified when more

jobs that meet your search criteria are posted."

 

I've search on Google to try to find out what you would connect to to pull the job listings. Does anyone have any ideas on how I could go about doing this?

Link to comment
https://forums.phpfreaks.com/topic/57512-job-search/
Share on other sites

well if you stored all the jobs in a database then you could search the database for matching or similar jobs. or you could add a keywords column and check if any of the keywords match the searched keywords. for the email, you could just make a seperate table and add there email along with what they searched. then when a new job is added in the admin panel simply run a query to check the emails if any of the keywords in the email matches the keywords for the new job. if so, dispatch an email, if not, check the other emails and so on...

 

there is one way...

Link to comment
https://forums.phpfreaks.com/topic/57512-job-search/#findComment-284566
Share on other sites

do it with a timestamp from mysql.

 

somthink like this if the time stamp of the current job they selected is less then the requested

job they want.

 

i am guessing here but makes sence.

 

 

<?php
$query="SELECT `jobs.critera` , `jobs.timestamp` , `requist.requst_time
stamp` FROM `jobs`,`requist`  where  `jobs.timestamp` < 'requist.requist_tim
estamp' and jobs.critera='requist.critera' ";
?>

Link to comment
https://forums.phpfreaks.com/topic/57512-job-search/#findComment-284587
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.