טכנולוגיה, מדע ולמידה

Prevent Sending Emails to Unsubscribed Users in PHP

26.02.2016 | The dump | יוסי בן הרוש

When managing email lists, it is essential to respect users requests to unsubscribe. Such requests can be stored in one or more database tables. The following code demonstrates how to prevent sending emails to unsubscribed users by checking their email against these tables.

Safely Converting a MySQL Table to utf8mb4 for Emoji and Multilingual Support

26.03.2016 | The dump | יוסי בן הרוש

If you need to store emojis and multilingual text (such as Hebrew) in a MySQL database, your table must use utf8mb4 instead of utf8. This guide will walk you through safely converting a MySQL table to utf8mb4_unicode_ci while preserving data integrity.

Use jQuery to Prevent Multiple Clicks on a Button

02.08.2019 | The dump | יוסי בן הרוש

When users interact with buttons on your web page, there's always a risk of them clicking multiple times—especially if the action takes time, such as writing to a database or sending an email. This can lead to duplicate actions, errors, or unnecessary strain on your backend.

Insert Records into MySQL Table Directly with Bash

02.08.2019 | The dump | יוסי בן הרוש

If you've ever needed to quickly insert records into a MySQL table, doing it directly from a Bash script can save time and effort. This guide will walk you through the process with a real-world example: inserting coupon codes into a MySQL table.

ואידך זיל גמור...