Build Your IT Skills, Grow Your Wealth with Maher Sakka

Primary keys in Database are essential for many reasons; they maintain entity integrity and help the database work faster when searching or linking data.

Sometimes, the primary keys aren't set for some tables. It's better to create the keys for these tables for better performance and integrity.

The following SQL query list all tables without Primary Key in a specific Database (<database_name>):

To listt all the ini configuration files loaded with PHP in command line, you have to type the command:

php --ini

All the configuration files will be listed. ex :

Here are the configurations to prevent search engines (Google, Bing, etc.) from indexing all websites on your server using global configuration for both web servers Apache and Nginx:

Prevent search engines indexing in Apache

Add the following line in httpd.conf or apache2.conf:

To export Database with time-stamped file name in phpMyAdmin, you have to change the parameter  Output: > Save output to a file > File name template from :

@DATABASE@

to :

We can use Tinker to change a Laravel user password from the console using theses instructions.

Start Tinker

php artisan tinker

The shell is launched

Psy Shell v0.12.9 (PHP 8.2.4 — cli) by Justin Hileman
>

Select the concerned user by email

You can you use tinker to check if email are sent correctly in a Laravel project.

Launch Tinker using this command

php artisan tinker

The shell is launched

Psy Shell v0.12.9 (PHP 8.2.4 — cli) by Justin Hileman
>

Now add the following code:

As a Linux user or administrator, you often need to track file changes—whether to debug an application, monitor system activity, or investigate a security breach. The find command is a powerful tool for this, and one of its useful options is -ctime n, which helps locate files modified within a specific timeframe.

When connecting to a Linux server, we need to know the name of the running Linux distribution, its version number, and the kernel version number.

This is often done to determine:

It is usually not possible to clear the Drupal cache via the site administration or via the command:

 drush cache-rebuild

In this case the only way available is to clear the cache via the database with the command

 TRUNCATE

The question now is which tables should be flushed and which ones are cached?

If you want to send an email to multiple recipients at once, you can enter all recipient addresses, separated by commas (“,”), in one of the following fields:

• "To"
• "Carbon Copy" (Cc)
• "Blind Carbon Copy" (Bcc).

In all cases, all addresses entered in these fields receive a copy of the message without retyping or re-creating it. But what is the difference between a carbon copy and a blind carbon copy?