LPH
Well-known member
Hi,
I'm learning php and mysql - slowly. XenForo has sparked my interest but this is indirectly related to XF. I'm tinkering with an idea - it's an idea being drawn up on paper. An empty database is set for the idea and I have not built any tables.
The idea
A php / mysql script which allows me to collect snippets and quotes from websites (in my network or some other site). These notes should be searchable so that I may re-use them. I want access to these so that I can quickly add via an iPhone, iPad, Notebook, or Desktop.
MySQL db
-- Site_ID (incremented)
-- Site Name
-- RSS Feed URL
-- Note ID (incremented)
-- Topic_ID (Tied to table below)
-- Category_ID (Tied to table below)
-- Date viewed
-- Publication date
-- Site_ID (Tied to above table)
-- Note
-- Story link
-- Keywords
-- Category_ID (incremented)
-- Category
--Topic_ID
-- Category_ID
-- Topic Title
PHP Files
There should be a page to easily add notes and another to retrieve notes. There should also be something to allow me to edit the notes
There should be a separate config.php file.
Would you mind taking a moment to ponder and let me know if there is something really missing in the basic idea. What pitfalls should I avoid?
I'm learning php and mysql - slowly. XenForo has sparked my interest but this is indirectly related to XF. I'm tinkering with an idea - it's an idea being drawn up on paper. An empty database is set for the idea and I have not built any tables.
The idea
A php / mysql script which allows me to collect snippets and quotes from websites (in my network or some other site). These notes should be searchable so that I may re-use them. I want access to these so that I can quickly add via an iPhone, iPad, Notebook, or Desktop.
MySQL db
-- Site_ID (incremented)
-- Site Name
-- RSS Feed URL
-- Note ID (incremented)
-- Topic_ID (Tied to table below)
-- Category_ID (Tied to table below)
-- Date viewed
-- Publication date
-- Site_ID (Tied to above table)
-- Note
-- Story link
-- Keywords
-- Category_ID (incremented)
-- Category
--Topic_ID
-- Category_ID
-- Topic Title
PHP Files
There should be a page to easily add notes and another to retrieve notes. There should also be something to allow me to edit the notes
There should be a separate config.php file.
Would you mind taking a moment to ponder and let me know if there is something really missing in the basic idea. What pitfalls should I avoid?