Jump to content

search function and alert service


jaffacake

Recommended Posts

Hi,

I'm new in the forum and new in the world of PHP and SQL. I know HTML, but only the very basics of PHP. I'm trying to teach myself PHP and SQL through books and tutorials, but I don't know where to start for my new project, so I'm hoping that you might be able to help me out.

I'm planning on making a website that allows users to search a database of events that includes basic data such as locations and dates. The database will be maintained manually.

Once that is set up, I'm also planning on adding a customized alert service that lets users choose from a set of parameters such as frequency or locations and allows them to add keywords (for example, they can choose to be notified on a monthly basis about events in their area, or on a weekly basis about events with a certain theme, or whenever there is a new entry in the database that matches their keywords, and so on). The alerts should be sent out automatically, and users should be able to set up more than one of these alerts for the same email address (I would like to avoid requiring them to login or set up a user account though, if possible, but that's not too important).

I hope this description makes sense. My problem is now that I don't know how to go about this project. Which topics do I need to look into to start settig up my database and coding the search function? Is there a tutorial about this? (I have searched, but I couldn't figre out which keywords give me the results I need.) And how would I set up the automated alert service?

I would really appreciate your help!

Link to comment
Share on other sites

This is a large project for a beginner, but having a project is the best way to learn to code. 

 

Anyway, most of concepts you mentioned are pretty basic. Just breakup the features you want into smaller parts and start building.

 

Don't worry about the automated alert part yet, save that for last. You can accomplish the automation using cron jobs which basically just runs a php script every x minutes.

 

Post some code if you get stuck

Link to comment
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.