Hi all, I'm a newbie to PHP and MySQL, but here's what I'm trying to do: I have MySQL, Apache, and PHP dev tools all set up. I made a database and a user to manage that database in mySQL. I have a PHP page to access my database. I want to be able to read the tables and display relevant data. The data in this case would be entire files (available for download). I hope to store the data as references to files (security issue, as well as easy to maintain) local to the server. The Problem: How do I add data to my mySQL database without a publicly accessible page? I would rather not have a PHP page to make links and references. I don't mind editing the database manually (is this possible?), but preferably I would like to edit a single text file to manage what files and local references I want to include in my tables. Any help and advice appreciated.
Do you have access to phpMyAdmin? You can manually insert/delete/update data in any table that exists in your database.
Thanks for the reply. I decided to use MySQL workbench to manage my databases and tables. However, I'm having trouble printing the contents ( forums.digitalpoint.com/showthread.php?t=2218144 ). Could really use some advice over there, still trying to get used to MySQL and PHP.
^ Fixed the problem above. My website is up and running. Now I'm back to my original issue. How do I store symlinks in the database? I tried creating symlinks and placing them in the database as longblobs, but this causes the data to be written to the database--meaning you have to upload revisions to the files each time. I want to be able to tell the database that there is (or will be) a file at x/sample/sampledoc.pdf, and have it point there every time I submit a query. The result should be that I can edit sampledoc.pdf (which may or may not actually be stored in x/sample/) and have the changes be live on my website. Any ideas folks?