admin panel settings

dcj1978

Right now i'm working on an admin panel for a site. the basic idea is the main page ha sa list of items like this..

Date - Title

Text goes here

The data is taken from a mysql db. There are multiple record from this database and the people who own the site want no more than 6 listings on the front page and the rest go to an archive.. but they also want to be able to select how many show on the main page so I can't just use LIMIT.

My question is, should I, in the admin panel, have a drop down box with options like "1, 2, 3, 4, 5, 6 etc" and store that in the database as well and then just use that data in the code to limit the number of items? Then whenever they change it it just updates that record in the database.

Is there an easier way? I would think there would be but i'm pretty new to this type of thing..

any help would be great

kinglouie

Well, you can set the LIMIT clause dynamic, too, depending on the selected value of a <SELECT>, for example.
Or did I get you wrong?
Best regards,

King Louie

dcj1978

I'm not exatcly sure how that would work. What I want to do exactly is have a spot in the admin panel that allows the owner to change the number of rows that are displayed on the main page. If they only want 3, they click "3" and until they go in and change it, the main page only shows 3 records.

How would I go about saving that value so that it doesn't change until the owner changes it?

Moonglobe

  $query = "INSERT INTO table1 (disp_num) VALUES ('$disp_num')

?
i'm new to MySQL, so i don't know if this would work.

dcj1978

Ok, but I want it to keep that setting perm until the owner changes it so... that var will be gone as soon as the script is done running.

Unless this actually stores it in the database somehow? It should work so that anyone who goes to the page can see 3 records if they chose 3 or 4 if they chose 4 etc..

Moonglobe

yes, it would stor it in the database:

$disp = $_POST['disp_num'];
$query = "INSERT INTO global_settings (disp) VALUES ('$disp');

the above code takes the value from any form input named disp_num (in this case
a SELECT box), and inserts it into the disp field in the global_settings table of the db
you're connected to.

(😕 I think? i am new to this...... can anyone back me up here?)