[RESOLVED] Next Phase of website php needs..

IceRegent

Help.. I have a frontend on my website, php and MySql, that is just what I need, but I am desperately seeking for a solution to the rest of the website. I need to be able to create a data storage/retreival setup where my users can post thier projects, and have other users download, review, add to and re-upload back to the project as a new update to that project. My brain is so overloaded with stuff I have a hard time learning all the codes to use in php. Can anyone suggest where to begin? I wouuld like to incorporate the section into the exhisting structure so that the registered users are the only ones who can use the 'project studio'. My website is : http://www.iceregent.com .

help!

Popcorn

That can be done with php and mysql so i don't think you are going to need another language for it.

For starters i would code a form page which would submit your project into the mysql database, information etc.. You could even upload a file and then store it in the db if you wanted.

Then for people who want to edit and re-upload it i would suggest the mysql query UPDATE which simply updates all the information in the db. I would make sure that you backup the data in the db before it's updated so you can resolve any issues which may arrise.

Then you can simply output the database information into a new page where people can search projects etc....

Sorry for not having any code, i'm not that advanced yet but i can give you some resources which greatly helped me.

http://tinyurl.com/7ufp6

IceRegent

Thank you for the reply. I wish I knew how to use the login and passwords from my front end, but I am having a hard time figuring out how and where they stored the info. I am using "E107" for the frontend, and my projects section is setup as a menu item on the site. I suppose I can just set up the project studio as another login and password setup, but that would be double duty for my users. At any rate, Thank you for the info, I will try to follow your suggestions best I can..🙂
🙂

IceRegent

I need to poulate my database with test data, and I can figure out how to enter text into the tables, but how do I get a file into it?

okphp

Managing MySQL database using phpMyAdmin
http://www.phpeasystep.com/mysqlview.php?id=2

IceRegent

Actually, what I need to do is to be able to figure out how to get the file into the database from a php page. If I can learn to do this, then I can incorporate it into the actual website itself, as that is the intent of what I want to do. However, now, I am not sure if storing the files in the MySQL DB is best or storing files in flatfile mode in a directory is best. Any recommendations? I need to be able to have the files searchable and associated with the poster, along with the info about the file, such as file name, description, and contributions needed. I need to be able to have a 3rd party user download the file, modify it, and reupload it in association with the old file, but not overwriting it. So, would storing it in the database be best or would storing the files in a directory be best? Files are only going to be about 300k in size to start out with max. 😕

thorpe

You would probably be best to store the files themselves in the filesystem, and at the same time, store the filepath, owner and any other related (searchable) data in the database.

From reading your posts however, It seems to me you dont really understand php as yet. Maybe you want to start by learning that. There is a good (free) book here that should get you started.

IceRegent

unfortunately, your link to a "good book" was an invalid link.

shonuff

IceRegent wrote:
unfortunately, your link to a "good book" was an invalid link.

Try this one: http://www.hudzilla.org/phpbook/ :-)