Programming problem's Solution's

Search This Blog

Check your Database Size

June 04, 2018

Get link
Facebook
X
Pinterest
Email
Other Apps

SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema;

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

This is a simple PHP script to lookup for blacklisted IP against multiple DNSBLs at once.

<html> <head> <title>DNSBL Lookup Tool - IP Blacklist Check Script</title> </head> <body> <form action="" method="POST"> <input type="text" value="" name="ip" /> <input type="submit" value="LOOKUP" /> </form> <?php if (isset($_POST['ip']) && $_POST['ip'] != null) { $ip = $_POST['ip']; if (filter_var($ip, FILTER_VALIDATE_IP)) { echo dnsbllookup($ip); } else { echo "<h2>Please enter a valid IP</h2>"; } } function dnsbllookup($ip){ $listed; $dnsbl_lookup=array("dnsbl-1.uceprotect.net","dnsbl-2.uceprotect.net","dnsbl-3.uceprotect.net","dnsbl.dronebl.org","dnsbl.sorbs.net","zen.spamhaus.org","cbl.abuseat.org","access.redhawk.org","b.barracudac...

Difference between Const and Define in PHP

you can create constant with " define" keyword at run time. for example: $a = 10; if( $a == 10 ) { define('key','value'); // you can create constant at run time witg " define " keywrord . } $a = 10; if( $a == 10 ) { Const Key = 'value'; // it will genrate an error warning because you can't create contant with " Const " Keyword at run time. } for "Const" you need to intialize it first like Const Key = 'Value'; /* rest code here */

Asynchronous PHP

PHP code is blocking, meaning that one block of code will not run until the block prior to it has finished. It wasn't built with asynchronous execution in mind like Go, NodeJs, and other languages. That's a very simple implementation but I wanted to show you how easily it can be done. For more advanced use cases, Spatie has built a package called spatie/async which runs and manages several PHP processes to run your code in an asynchronous fashion. Follow this article details

Powered by Blogger

Check your Database Size

SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema;

Comments

Post a Comment