Another php/sql question about categorizing rows
 

Specifically, I'm wanting to add a 'bulk' categorizing section to my CRUD system and I'm thinking that using checkboxes may be the simplest way of doing this? My question is this, what would be the most simple (and secure) way of adding a bunch of predefined categories to a page and going through a list, clicking each checkbox that matches the rows data?

Should I also have another area in the CRUD that will allow me to add extra categries as the need arises or, just hardcode them in the edit.php page?

Any thoughts on this vs. any other options you might be able to suggest?

You would probably be best to table your categories. Then have an add/change/delete screen for maintenance of the categories.

Then you can just loop through the categories table to make your checkbox screen.

Disclaimer: If you only have 1 or 2 categories then by all means hardcode them into the file but if you are going to have a fairly large list and expect to be adding to and changing them then what I said stands.


.

Awesome, thank you!

I dunno what you're coding, but your questions make me wonder if you've considered using something like laravel ?

Most of your questions, are things this framework will easily take the difficulty out of.

It's really better if he learn the fundamentals before using a framework. We've interviewed guys that only coded with frameworks and when you put them in front of 'real' PHP they freeze like a deer in front of headlights.

This.

I honestly I have only been playing with php for about 4-6 months, that’s why so many questions about errors and how-to do certain things.