Orphy Posted March 24, 2006 Share Posted March 24, 2006 Dear all, Will someone be kind enough to point me to the right examples to do the following: (I can follow examples and tweak it but can not write codes from scratch as it's been less than 2 days of php for me). I will forever be indebted to you.My "database base" is a bunch of pdf files (let say 1K) and each pdf file will be named this way:Subject_date_authorI want to set up the site in a way, so that all I have to do is place new pdf files into the folder and the prgoram (php and mysql?) will automatically generate a webPAGE with each SUBJECT. and under subject - there will be the list of authors w/ date which will be a clickable pdf .Please advise on how I can tackle this project. I spent hour after hours searching the net to find similar examples. No luck!!Thank you Quote Link to comment https://forums.phpfreaks.com/topic/5703-building-a-website-from-scratch/ Share on other sites More sharing options...
keeB Posted March 24, 2006 Share Posted March 24, 2006 Thats a lot of pdf files.Can you give us the structure of your database, please? With that I could help you a little more ;) Quote Link to comment https://forums.phpfreaks.com/topic/5703-building-a-website-from-scratch/#findComment-20343 Share on other sites More sharing options...
Orphy Posted March 24, 2006 Author Share Posted March 24, 2006 dear keeb, thank you for replying. It seems to me after reading a bit that I need to make a database. Forget my original question for now....Is there a way to automatically create the database with Columns of Publisher, Date and subjectgiven the file names are this way: Publlisher_Date_Subject.pdf Quote Link to comment https://forums.phpfreaks.com/topic/5703-building-a-website-from-scratch/#findComment-20371 Share on other sites More sharing options...
draxxus Posted March 25, 2006 Share Posted March 25, 2006 Maybe write a local script to gather all the names? You can split the file names up into seperate strings wherever a "_" is. Then have another script append any neccessary info so that you could just copy/paste into sql. Only way I can think of :) Quote Link to comment https://forums.phpfreaks.com/topic/5703-building-a-website-from-scratch/#findComment-20507 Share on other sites More sharing options...
Orphy Posted March 25, 2006 Author Share Posted March 25, 2006 [!--quoteo(post=358177:date=Mar 25 2006, 03:54 AM:name=draxxus)--][div class=\'quotetop\']QUOTE(draxxus @ Mar 25 2006, 03:54 AM) [snapback]358177[/snapback][/div][div class=\'quotemain\'][!--quotec--]Maybe write a local script to gather all the names? You can split the file names up into seperate strings wherever a "_" is. Then have another script append any neccessary info so that you could just copy/paste into sql. Only way I can think of :)[/quote]Hello draxxus, I do have a program to spit out the file name....So for example, I can easily convert Publisher_Author_Date.pdfto the text Publisher_Author_DATE.Now what? I am totally new at this...has been only 2 days.. and already feel like giving up!How will I change Publisher_Author_Date to something something which then I can import to mysql table.Please tell me a step by step process. Quote Link to comment https://forums.phpfreaks.com/topic/5703-building-a-website-from-scratch/#findComment-20534 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.