This package is a manner to answer a request posted in the PHPCLASSES SPECIALISTS FORUM.
The purpose was: " how to extract all urls from a database and then check for brokens and
not brokens" .
This package not only retrieve urls from a given mysql database but also from all databases
on this server if asked. The package go trought all chosen databases or all databases on server
and for each found table retrieve all urls found in the columns with datatype==string ...
Then user can with another method check for brokens...
The package use the old mysql api but assure the ascending compatibility with all versions of PHP with
the innovative package of Dave Smith mysql to mysqli so for thoses who will get the ugly warning about
deprecated functions don't worry and just turn off error reporting or disable your old mysql extension
in the PHP.ini...
The package is well commented and the functions names talk themselves for more information please
look in the example file or feel free to ask your questions or report issues in the forum or contact
me personally at leizmo@gmail.com...
ps:
be sure to complete the list of protected database in the class source.
private $protectedDatabases=array('information_schema','innodb_index_stats','performance_schema','mysql');
|