PHP Classes

PHP URLs From Database: Find MySQL database table records to extract URLs

Recommend this page to a friend!
  Info   View files Example   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 170 All time: 8,807 This week: 313Up
Version License PHP version Categories
php-urlsfromdb 1.0.0The PHP License5PHP 5, Databases, Searching
Description 

Author

This package can find MySQL database table records to extract URLs.

It can retrieve the tables of a MySQL database and extract the fields of type text.

The class can find the table records for text fields that may have URLs in them.

Innovation Award
PHP Programming Innovation award nominee
January 2018
Number 8
This package can find MySQL database table records to extract URLs.

It can retrieve the tables of a MySQL database and extract the fields of type text.

The class can find the table records for text fields that may have URLs in them.

Manuel Lemos
Picture of zinsou A.A.E.Mo´se
  Performance   Level  
Name: zinsou A.A.E.Mo´se is available for providing paid consulting. Contact zinsou A.A.E.Mo´se .
Classes: 50 packages by
Country: Benin Benin
Age: 33
All time rank: 6831 in Benin Benin
Week rank: 19 Up1 in Benin Benin Equal
Innovation award
Innovation award
Nominee: 23x

Winner: 2x

Example

<?php
               
// ini_set("max_execution_time",9999);
               
set_time_limit(9999);
               
define("SERVERNAME","localhost");
               
define("USERNAME","root");
               
define("PASSWORD","");
                require_once(
'Urls_From_tables.class.php');
               
               
// $searchFromDatabase=array("sensei");
               
$object=new Urls_From_tables(
               
// $searchFromDatabase
               
); //Enter no parameter to search from the entire database
               
               
               
               
echo'<pre>';
                echo
'<h2>var_dump($object->OnlyUrls());</h2>'; var_dump($object->OnlyUrls());
                echo
'<h2>var_dump($object->get_just_urls());</h2>'; var_dump($object->get_just_urls());
                echo
'<h2>var_dump($object->get_justTrue_Exturls());</h2>'; var_dump($object->get_justTrue_Exturls());
                echo
'<h2>var_dump($object->get_nlinks());</h2>'; var_dump($object->get_nlinks());
               
// echo'<h2> var_dump($object->getBrokens()); for all urls and http status in array</h2>'; var_dump($object->getBrokens());
                // echo'<h2> var_dump($object->getBrokens(true)); for array of just brokens(probably) links</h2>'; var_dump($object->getBrokens(true));
               
echo'</pre>';


  Files folder image Files  
File Role Description
Plain text file mysql2i.class.php Class mysql to mysqli class source
Accessible without login Plain text file mysql2i.func.php Aux. mysql to mysqli api
Accessible without login Plain text file readme.txt Doc. readme
Accessible without login Plain text file testUrlsFT.php Example example script
Plain text file Urls_From_tables.class.php Class class source

 Version Control Unique User Downloads Download Rankings  
 0%
Total:170
This week:0
All time:8,807
This week:313Up