Open in app

Sign In

Write

Sign In

Ian Arman
Ian Arman

2 Followers

Home

About

Dec 22, 2022

How to round down to nearest integer in MySQL?

To round down to nearest integer, use FLOOR() function from MySQL. The syntax is as follows − SELECT FLOOR(yourColumnName) from yourTableName; Let us first create a table − mysql> create table FloorDemo -> ( -> Price float -> ); Query OK, 0 rows affected (0.57 sec) Insert records to column…

My SQL

1 min read

My SQL

1 min read


Jan 22, 2021

Extract URL from Excel Links

Here’s a great #Hack for Microsoft Excel fanatics! Let’s say you have a large range of data with embedded hyperlinks. Like this range: Assuming for the moment that someone else created these links — and you the excel fanatic would have obviously created the adjacent column in the first…

Microsoft Excel Training

2 min read

Microsoft Excel Training

2 min read


Jan 12, 2021

Copy Data from S3 Object Storage to Different S3 Object Storage Provider

MinIO is an Amazon S3 compatible server-side software storage stack, it can handle unstructured data such as photos, videos, log files, backups, and container images with currently the maximum supported object size of 5TB. In this example, this is a perfect simple script to either backup or migrate your s3…

1 min read

1 min read


Jul 22, 2020

Monit.php WordPress Malware

One of the most common malware black-hat SEO campaigns comes from an upgraded version of the WP-VCD virus, which I conducted a detailed analysis. The Malware is contained in the monit.php file located in the wp-content/plugins/ directory. This particular type of malware uses some of the same functionality as the…

Monit

2 min read

Monit.php WordPress Malware
Monit.php WordPress Malware
Monit

2 min read


Jan 14, 2020

WordPress WP-VCD malware attack — Comprehensive Guide & Solution

Howdy, This is my first Medium post. My name is Ian Arman, I’m a professional WordPress Designer/Developer. I’m mostly self-taught having learned about WordPress by simply taking it apart, and putting it back together (hundreds of times)! If you find this post useful, bookmark this story, and be sure to…

Word Press

7 min read

WordPress WP-VCD malware attack — Comprehensive Guide & Solution
WordPress WP-VCD malware attack — Comprehensive Guide & Solution
Word Press

7 min read

Ian Arman

Ian Arman

2 Followers

Hey I'm @ianarman, I only clap about the cool stuff on @Medium!

Following
  • React Developer

    React Developer

  • Zaid Daba'een

    Zaid Daba'een

  • Ryan Shrout

    Ryan Shrout

  • Johny Vino

    Johny Vino

  • Gwendolyn Faraday

    Gwendolyn Faraday

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech