October 2025

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: