Lorreign Posted September 22, 2007 Share Posted September 22, 2007 I would like to do something that I know can be done, I just don't know how exactly. I want a page where users can submit an image, text, and links and then what is submitted goes to an administration page where such submitted can be approved or declined. And then another page where all the things that have been approved go into a table where the image, text, and links are displayed in a numbered fashion. Here are some picture examples of what I mean: form.php http://img217.imageshack.us/img217/6228/formphpmh3.gif admin/admin.php http://img146.imageshack.us/img146/1281/adminphpws3.gif entries.php http://img145.imageshack.us/img145/2...riesphphb5.gif Here are my versions: PHP version 4.4.7 MySQL version 4.1.22-standard-log How exactly do I do this? Is there a script somewhere already written that I can modify or use? Quote Link to comment Share on other sites More sharing options...
JJohnsenDK Posted September 22, 2007 Share Posted September 22, 2007 you create a database where you have colums for the picture name, the text and the link... also you have to make a colum that controls if this image have been approved which you could call approved ... if the image is approved you give it the number 1 in the colum ohterwise its = 0. then you make a page where you list all the images that is = 0 which the admin can see... in this page you also make it possible for the admin to change the condition of the approve colum you created in the database... next you make a page where you list all the images from the database where the colum approved is = 1... this page is for the users to see... Quote Link to comment Share on other sites More sharing options...
Lorreign Posted September 22, 2007 Author Share Posted September 22, 2007 ok, I get the making the database part. But how do I code it in the pages the users actually see? Quote Link to comment Share on other sites More sharing options...
gromer Posted September 22, 2007 Share Posted September 22, 2007 Get Beginning PHP 5 and MySQL 5: From Novice to Professional by W. Jason Gilmore. Published by Apress. Awesome book. You basically need a database setup and need to know how to form SQL queries to INSERT, UPDATE, etc. Quote Link to comment Share on other sites More sharing options...
gromer Posted September 22, 2007 Share Posted September 22, 2007 Also, you might want to check out the w3school pages on MySQL in php. http://www.w3schools.com/php/php_mysql_intro.asp Quote Link to comment Share on other sites More sharing options...
JJohnsenDK Posted September 22, 2007 Share Posted September 22, 2007 if you dont know php you cant make this... as gromer writes read some books.... Quote Link to comment Share on other sites More sharing options...
gromer Posted September 22, 2007 Share Posted September 22, 2007 if you dont know php you cant make this... as gromer writes read some books.... That book is ridiculously awesome too. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.