Jump to content

Recommended Posts

Hi all, I am designing a job website at the moment. I need to put a feature in that has "add this to MY JOBS" - whats the best way to do this to even store it for the visit or maybe to their account?

 

Also how can we write a wysiwyg textarea to a db and have to produce the Rich Text Format when the data is called?

 

Thanks,

Leo

Link to comment
https://forums.phpfreaks.com/topic/71884-add-to-basket-opinions-wanted-pls/
Share on other sites

Smoking! 9,000 posts!!!

 

I'm a super novice php guy - I know html and css very well but I'm getting there with php.

 

I need the job to be saved for 30 days to their account! I'm really new to this but I know I can learn it fast and do it. Whats the best way to do this pls?

 

Thats fair enough but I once spent an hr and half writing an extremely complex css floating menu for someone... so maybe just MAYBE someone will give me the pointers and or code needed! Ya never know until ya ask!

 

Ok so I need to write it to a db? Could you elaborate?

All you really need do is create a table (userjobs) with two fields, uname and job. Then, for each job a user adds, add a new record. eg;

 

INSERT INTO userjobs (uname,job) VALUES ('foo','writter');

 

Then, to list all jobs for user foo....

 

SELECT jobs FROM userjobs WHERE uname = 'foo';

You simply have a link that points to the script which executes the query. Something like...

 

<a href='addjob.php?jobid=writter'>add job</a>

 

Assuming your users are already logged in using sessions you would then retrieve the users id from the $_SESSION array and the job id from the $_POST array and place them in your query and execute it.

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.