MicrostockGroup
Microstock Photography Forum - General => Symbiostock => Symbiostock - Development Area => Topic started by: quailrunphoto on July 22, 2013, 12:26
-
It has been a long time since I have done any coding, (Cobol for those old enough to know what that is) so this may be a bad idea. I would like to be able to create my own reports from the databases within SymbioStock.
Can someone point me in the right direction as to the location of the databases, their structure and what I should use to create reports?
Thanks.
-
first the simple answer -- look for phpmyadmin under databases in the cpanel. there are usually other tools there for simple reports also.
the bad news is WP, has one of the worst databases ever designed. it violates just about every rule you can think of, normalization being high on that list. it's really amazing what leo's been able to do with it
I've created a separate sql database of images, sites and keywords at http://symbiostock-search.com (http://symbiostock-search.com) and have been writing different reports. if anyone has a report they'd like to see, I can easily add others.
for this db I use vbscript and sql since its on a MS website. all thatcan also be done with php on a Linux site, and there's lots of code examples available.
a basics report has 2 steps:
--select the records you want to report, and sort them
--read each record and write a line of the report
counts, summaries, etc then come at the end
---
right now i'm experimenting with ways to handle similar images, and looking for better matches wuth multiple keywords. neither is really a problem at this stage since the total # of images is small, but it will be a concern in the future
-
Thank you for the tips. I will check it out and I will also check out what you have created.