Skip to content

Instantly share code, notes, and snippets.

View mmikhan's full-sized avatar

Md Mazedul Islam Khan mmikhan

View GitHub Profile
@mmikhan
mmikhan / wp-forum-scrapper.py
Created June 4, 2023 21:45
Scrapes discussions from WordPress forum and export the URLs to CSV files
"""
This script scrapes discussions from the Yoast SEO plugin's public forum on
WordPress (https://wordpress.org/support/plugin/wordpress-seo/). The script
fetches discussion titles and URLs from all available pages.
The script also features lazy loading by adding a delay between requests. This
helps ensure responsible web scraping by not overwhelming the server.
The fetched URLs are then saved to multiple CSV files, each containing a
specified number of URLs (default is 500). The CSV files are saved in the 'dist/'
@mmikhan
mmikhan / workday_random_numbers.py
Last active June 4, 2023 21:20
Workday Random Numbers Generator
#!/usr/bin/env python3
"""
Workday Random Numbers Generator
This script generates random floating-point numbers between 8 and 10,
rounded to 2 decimal places, only for workdays in a specified month and year.
Since the script usually runs from the first week of the following month, the
default month and year are set to the previous month and year. The script also
highlights weekends in red. The output is printed to the console and copied to
your clipboard.
@mmikhan
mmikhan / default
Created December 27, 2021 09:29
Nginx default configuration file
##
# You should look at the following URL's in order to grasp a solid understanding
# of Nginx configuration files in order to fully unleash the power of Nginx.
# https://www.nginx.com/resources/wiki/start/
# https://www.nginx.com/resources/wiki/start/topics/tutorials/config_pitfalls/
# https://wiki.debian.org/Nginx/DirectoryStructure
#
# In most cases, administrators will remove this file from sites-enabled/ and
# leave it as reference inside of sites-available where it will continue to be
# updated by the nginx packaging team.
@mmikhan
mmikhan / php-fpm.conf
Created December 26, 2021 10:12
PHP 8.1 default configuration
;;;;;;;;;;;;;;;;;;;;;
; FPM Configuration ;
;;;;;;;;;;;;;;;;;;;;;
; All relative paths in this configuration file are relative to PHP's install
; prefix (/usr). This prefix can be dynamically changed by using the
; '-p' argument from the command line.
;;;;;;;;;;;;;;;;;;
; Global Options ;
@mmikhan
mmikhan / settings.json
Last active January 29, 2022 10:46
GitHub Light Default Visual Studio Code settings
{
"editor.fontSize": 13,
"editor.fontFamily": "JetBrains Mono",
"workbench.colorTheme": "GitHub Light Default",
"breadcrumbs.enabled": false,
"editor.codeLens": false,
"editor.formatOnSave": true,
"editor.formatOnPaste": true,
"editor.fontLigatures": true,
"editor.minimap.enabled": false,
@mmikhan
mmikhan / index.py
Created October 31, 2021 23:15
Control traffic LEDs through IR Sensors to dynamically turn green light on or off based on the number of vehicles using Python on Raspberry Pi
from time import sleep
from signal import pause
from gpiozero import LED, MotionSensor
ledNorthRed = LED(21)
ledNorthYellow = LED(20)
ledNorthGreen = LED(16)
ledSouthRed = LED(26)
ledSouthYellow = LED(19)
@mmikhan
mmikhan / tailwind.config.js
Created June 17, 2020 14:12
Tailwind CSS `grid-template-columns: auto-fit; grid-template-columns: auto-fill;` and `grid-template-rows: auto-fit; grid-template-rows: auto-fill;`
module.exports = {
purge: [],
theme: {
extend: {
gridTemplateColumns: {
'auto-fit': 'repeat(auto-fit, minmax(0, 1fr))',
'auto-fill': 'repeat(auto-fill, minmax(0, 1fr))',
},
gridTemplateRows: {
'auto-fit': 'repeat(auto-fit, minmax(0, 1fr))',
@mmikhan
mmikhan / 143010200006_final_lab.sql
Created August 8, 2017 04:58
Database Management System Lab Final
CREATE DATABASE `dbms`;
USE `dbms`;
-- 1
CREATE TABLE `college`(
`cname` varchar(50),
`state` varchar(10),
`enrollment` INT
);
@mmikhan
mmikhan / 143010200006.sql
Created August 7, 2017 21:30
CSE 3110, Lab 4
-- 1
CREATE TABLE `teachers` (
`teacher_id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL,
`designation` VARCHAR(50) NOT NULL,
`department` VARCHAR(50) NOT NULL,
`phone_number` INT NOT NULL,
PRIMARY KEY(`teacher_id`)
);
@mmikhan
mmikhan / gpg.md
Created February 21, 2017 12:19 — forked from LauLaman/gpg.md
Use GPG to sign commits using git & PHPStorm

1 - install GPG tools : https://gpgtools.org/

2 - Create new key for your github email

3 - Add key to git on your local machine: git config --global user.signingkey YOURKEY

4 - configure git to sign all commits: git config --global commit.gpgsign true

5 - add to the bottom of ~/.gnupg/gpg.conf: