Programming problem's Solution's

Search This Blog

Finding duplicate values in a SQL table

May 06, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

SELECT

`id`, COUNT(*)

FROM

`table`

GROUP BY

id

HAVING

COUNT(*) > 1

Get link
Facebook
Twitter
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

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

Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?

very simple solution just run this command sudo service docker start

Powered by Blogger

Finding duplicate values in a SQL table

Comments

Post a Comment