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

Recommend this page to a friend!

Download .zip

Info

Example

View files (5)

Download .zip

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 170		All time: 8,807 This week: 313

Version		License		PHP version		Categories
`php-urlsfromdb` 1.0.0		The PHP License		5		PHP 5, Databases, Searching

Description

Author

zinsou A.A.E.Mo�se

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

January 2018
Number 8

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 zinsou A.A.E.Mo�se
Country:	Benin
Age:	33
All time rank:	683	1 in Benin
Week rank:	19	1 in Benin

Level 5

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

File	Role	Description
`mysql2i.class.php`	Class	mysql to mysqli class source
`mysql2i.func.php`	Aux.	mysql to mysqli api
`readme.txt`	Doc.	readme
`testUrlsFT.php`	Example	example script
`Urls_From_tables.class.php`	Class	class source