I am a rank beginner on PHP, but with some reasonable programming knowledge, most recently in Perl.
I want to build a number of websites that need a search and retrieval function from a MySQL database. The search should include Boolean, excluded words, "contains matches", exact matches, date and number matches (including relative i.e. <, >), etc. as well as the ability to sort the resulting retrieval by almost any field, including multiple fields (i.e. sort by Field 1, then by Field 2). The database will consist of only around a dozen fields. The ability to show a page of only "n" records at a time, with a "next page" choice will also be important.
Database management will not be necessary, as the entire database will be refreshed from a flat character delimited text file each time it is changed (the data comes from other applications). Only this function of "dump and refresh" will be needed.
My reading to date indicates that PHP is the preferred method of carrying out this project, but this is currently beyond my own capabilities to write from scratch. I have searched PHP Resources website for scripts or programs but I have found nothing that seems to fit the bill.
These websites will be "sold", so the script does not need to be free, although reasonable licensing terms that allow for a "payment per implementation" will be important.
It is possible that I am suffering from a misconception of PHP, stemming from my Perl experience. In Perl, this sort of functionality is provided by a call to a specific script which can be edited and modified. Is this the case with PHP, or are PHP code snippets typically scattered throughout HTML pages?
Can anyone point me to existing code, or to code archives, where I might find what I need?
Thanks in advance
Roy Lingen
I want to build a number of websites that need a search and retrieval function from a MySQL database. The search should include Boolean, excluded words, "contains matches", exact matches, date and number matches (including relative i.e. <, >), etc. as well as the ability to sort the resulting retrieval by almost any field, including multiple fields (i.e. sort by Field 1, then by Field 2). The database will consist of only around a dozen fields. The ability to show a page of only "n" records at a time, with a "next page" choice will also be important.
Database management will not be necessary, as the entire database will be refreshed from a flat character delimited text file each time it is changed (the data comes from other applications). Only this function of "dump and refresh" will be needed.
My reading to date indicates that PHP is the preferred method of carrying out this project, but this is currently beyond my own capabilities to write from scratch. I have searched PHP Resources website for scripts or programs but I have found nothing that seems to fit the bill.
These websites will be "sold", so the script does not need to be free, although reasonable licensing terms that allow for a "payment per implementation" will be important.
It is possible that I am suffering from a misconception of PHP, stemming from my Perl experience. In Perl, this sort of functionality is provided by a call to a specific script which can be edited and modified. Is this the case with PHP, or are PHP code snippets typically scattered throughout HTML pages?
Can anyone point me to existing code, or to code archives, where I might find what I need?
Thanks in advance
Roy Lingen