Jump to content

A script that will allow writers to claim article titles?


Novice@PHP

Recommended Posts

I have a website but managing writers is HARD.

 

I need a project management script that assigns articles to a list, that the writers then claim from and submit.

 

I have no idea what kind of script I'm looking for. Quick process:

 

1. Add a bunch of article titles across a number of categories.

2. Registered writers can claim which titles they want to write but are only allowed to claim in their own topic.

3. Writers write articles, mark as done and submit for review.

 

No idea what to look for but any help hugely appreciated.

 

Thanks.

Link to comment
Share on other sites

It's quite simple, actually.

 

You need a script that writes the article title and user ID to the database, after setting a unique index on the title. If the query fails, you need to check why it failed. If it was because of an already existing title, then you tell the user that the title is already taken.

For any other reason, give the user a message telling him that there was some other error, and log it for yourself. (Remember to log it to someone you check often.)

 

That's part 1, for part 2 you just check if the user ID for the title is the same as the user ID that's saved to the title in the DB. If they aren't, then the user does not have the proper access to write/edit it.

 

The last part is even simpler, and basic database interaction stuff. I suggest that you start with a basic PHP & MySQL tutorial, to get to grips with the basics. Then sit down and plan the specifics, and then I'm talking about the specifics, of your application. Once you've got it all down in a simple step-by-step list, and feel confident that you've solved all of the logic, then it's time to actually write the code.

Link to comment
Share on other sites

It's quite simple, actually.

 

You need a script that writes the article title and user ID to the database, after setting a unique index on the title. If the query fails, you need to check why it failed. If it was because of an already existing title, then you tell the user that the title is already taken.

For any other reason, give the user a message telling him that there was some other error, and log it for yourself. (Remember to log it to someone you check often.)

 

That's part 1, for part 2 you just check if the user ID for the title is the same as the user ID that's saved to the title in the DB. If they aren't, then the user does not have the proper access to write/edit it.

 

The last part is even simpler, and basic database interaction stuff. I suggest that you start with a basic PHP & MySQL tutorial, to get to grips with the basics. Then sit down and plan the specifics, and then I'm talking about the specifics, of your application. Once you've got it all down in a simple step-by-step list, and feel confident that you've solved all of the logic, then it's time to actually write the code.

 

Wew I don't want to build it. No time for that.

 

I guess something already exists, I just don't know what to look for.

 

Thanks for the detailed reply though.

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.