Submission Permission ?

[TTVN]

Hello,

I'm trying to build a Submission page so users can add lyrics to my database, but what I need is that, the lyric has to be approved by the admintrator first before granting its permission to add to the database. So, basically what my question is, how to write such code?

thank you,
TTVN

[ir4z0r]

I suggest, using another table where to put these lyrics temporarily

after admin has read them, he could click on a button to transmit it to
the real table

but I recommend to limit the allowed input, maybe check with strlen()
that the input doesn't extend a certain length, resulting in a huge spammed DB

[TTVN]

Hehe I'm totally new at PHP. Could you kindly give me the basic code to work around with?

thanks,
vntt

[ir4z0r]

hmm, some steps:

1st file: a html form whose "action" points to next script
--> (see html tutorials concerning forms)

2nd file: a php-script which stores the entered lyrics into a table
--> (search a tutorial about mysql usage or php.net's examples)
- check input length:

if (strlen($_POST['lyrics']) < 1000)
{
// lyrics' length shorter than 1000 chars
}
else
{
// deny, too long, risk of spamming
}

3rd file: a php script which lists all lyrics in large (html-) table
- every row contains a form with the lyric and additional info and a submit button
-> if clicked, it will be saved to the final mysql table which is used by the
display script for the homepage
(only admin should have access to this page)

4th file: saves data in final table (see 3.)

note: all these "files" can be put in 1, but for the beginning I suggest
to divide them into tasks

--> if you have problems to handle everything now, try test scripts
for each section, to learn it step by step 😉