How to compare two dates in PHP (with DateTime)

If you want to compare two dates in PHP using DateTime, you can use math operators (>, <, ==)

An example:

$date1 = new DateTime('2022-09-26 16:12:20');

$date2 = new DateTime('2022-01-11 10:13:30');

var_dump($date1 == $date2); //false

var_dump($date1 > $date2); // true

var_dump($date1 < $date2); // false

How to solve an error "Type mismatch. Required: Editable Found: String" in Android Studio (Kotlin)

This  problem appears when you try to write a string instead of an Editable into an EditText element .

Wrong usage example: 

 binding.myEdit.text = "12345"

The solution is to write text using the setText method:

 binding.myEdit.setText("12345")

If you do not use View Binding, then see this example:

val txt = findViewById (R.id.my_text) as EditText

txt.text =  "12345" // an error

txt.setText("12345")  //correct

How to enable View Binding in Android Studio (Kotlin)

To enable View Binding in Android Studio, you need to open the build.gradle (module) file in the Gradle Scripts section.

You need to add the following code to the android block:

android {

    buildFeatures {

        viewBinding = true

    }

}

 Then you can click on the link Sync Now in the top right corner or run the project.

INSTALL_FAILED_USER_RESTRICTED error in Android Studio & Redmi

If you encounter the INSTALL_FAILED_USER_RESTRICTED error on your Redmi device, you need to follow a few steps to fix it:

In the developer settings (Settings -> Additional Settings -> Developer options)

1. Check that USB debugging mode is enabled
2. Enable MIUI optimization
3. Enable installation of applications via USB

How to call parent constructor in PHP

How to call parent class constructor in PHP:

class MyClass extends OtherClass

{

    public function __construct()

    {

        // your custom code

        parent::__construct(); // parent constructor call

    }

}

How to convert timestamp to DateTime in PHP

Timestamp conversion to  DateTime in PHP is simple:

$date = new DateTime();

$date->setTimestamp($timestamp);   // $timestamp - this is date in unix timestamp format

Laravel: how to add a foreign key reference for user

If you need to add a foreign key reference to the user in the foreign table, you should know that id column formats must match  in users & new tables.

Example:

Create a user table (by default in Laravel 8):

Schema::create('users', function (Blueprint $table) {

    $table->id();

    $table->string('name');

    $table->string('email')->unique();

    $table->timestamp('email_verified_at')->nullable();

    $table->string('password');

    $table->rememberToken();

    $table->timestamps();

});

In this case, we see that the type of id is not clearly specified, but if you look in the database, you can see that it is bigint(20)

Laravel migration error Blueprint::bigint does not exist

If in Laravel migration you have this error:

Method Illuminate\Database\Schema\Blueprint::bigint does not exist.

Replace this line of code:

$table->bigint('column_name')->nullable();

With this:

 $table->bigInteger('column_name')->nullable();

How to disable directory listing with htaccess

To prevent  file and directory listing, you can add just one line to the htaccess file:

Options-Indexes

If you don't have this htaccess file, just create it in the root directory of your site. If the file already exists - do not delete anything in it - just add this line from a new line and save.

How to count the number of days between two dates (PHP)

If you need to count the number of days between two PHP dates, it is convenient to use DateTime.

Example:

$date1 = DateTime::createFromFormat('d-m-Y', '15-02-2022');

$date2 = DateTime::createFromFormat('d-m-Y', '19-02-2022');



$difference =  date_diff($date1, $date2);

$differenceDayCount = $difference->days;

var_dump($differenceDayCount);  // 4

How to delete an index in MySQL

Deleting an index in MySQL is quite simple, one query is enough.

Example:

ALTER TABLE `table_name` DROP INDEX `index_name`;

where:

table_name - table name
index_name - the name of the index to be removed

JavaScript - how to trim spaces for all strings of an array

If there is a situation when you need to get rid of spaces at the beginning and end of the string for array elements, then it could be done in this way:

let testArray = ['Riga', 'Moscow ', ' London '];

let resultArray = testArray.map(str => str.trim());

console.log(resultArray); // Result: ['Riga', 'Moscow', 'London']

How to fix stream_set_chunk_size(): The chunk size cannot be larger than 2147483647

If you have this error:

stream_set_chunk_size(): The chunk size cannot be larger than 2147483647

there are 2 options how to fix it, one of the mentioned options should work.

What to do if sql-mode setting doesn't work in my.ini

If you need to change the default sql-mode values, but they do not work after restarting the server, then make sure that you have entered this setting in the section under mysqld heading

[mysqld]

If you wrote it elsewhere, sql-mode changes wouldn't be applied. 

How to debug cURL connection

You can debug cURL request by setting CURLOPT_VERBOSE = true

For example:

$ch = curl_init();

curl_setopt($ch, CURLOPT_VERBOSE, true);

//... other cURL settings

$data = curl_exec($ch);

var_dump($data);

How to prevent link click default action or form submission (jQuery)

If you want to change link click default behavior, you could use jQuery for this purpose. 

Let's assume we have a link:

<a href="/link" id="example-link">Link</a>

jQuery code, which will prevent link click default action:

$('#example-link').click(function(e) {

        e.preventDefault();

        //your code

    });

The key thing here is the e parameter, which is passed to the function and the e.preventDefault()  

How to debug mail sending in Laravel

To troubleshoot email sending errors in Laravel you can:

1. Set up:

MAIL_DRIVER=log

in the mail settings in the ENV file.

E-mails wouldn't be sent, but will be written to the  logs folder -where you can check email parameters.

2. To display configuration data for email sending:

dd(config('mail'));

Backslash in Laravel database requests

If you write \ in the Laravel database request incorrectly, you won't get the expected result.

The point is that \ is an escape character.

For example, if you need to get a model from the database with the App\Picture type:

ModelName::where('type', 'like', 'App\\\\Picture')->get()

As you can see from the code above, the single slash is replaced with 4: \\\\

How to calculate SHA256 hash (PHP)

To calculate a hash using SHA256 format for a string in PHP, you need to use the hash function:

$myString = 'test';

$result = hash('sha256', $myString);

where

$myString - is the string to be encoded.

The first parameter passed to the hash function is the hashing algorithm, it can be different, for example "md5", "sha1", "haval160,4", etc.

You can find out all available algorithms using the hash_algos() function

Mobile navigation SVG icon

SVG navigation icon for mobile website design:

Code:  

<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" aria-hidden="true" role="img" width="1.2em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 1536 1280"><path d="M1536 1088v128q0 26-19 45t-45 19H64q-26 0-45-19t-19-45v-128q0-26 19-45t45-19h1408q26 0 45 19t19 45zm0-512v128q0 26-19 45t-45 19H64q-26 0-45-19T0 704V576q0-26 19-45t45-19h1408q26 0 45 19t19 45zm0-512v128q0 26-19 45t-45 19H64q-26 0-45-19T0 192V64q0-26 19-45T64 0h1408q26 0 45 19t19 45z" fill="currentColor"/></svg>