Jump to content

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.