TypeError: PhpMyAdmin\Export::getFilenameAndMimetype(): Argument #5 ($filenameTemplate) must be of type string, null given, called in /libraries/classes/Controllers/Export/ExportController.php on line 397 The above error was coming when exporting the MySql with a fresh installation of phpMyAdmin. Solution Go to php.ini and change the max_input_vars to a higher value as the default would be 1000.
MySql
Reset “Use Secure in Front End or Admin” in Database – Magento 2
If you ran into a problem like you have changed the secure admin URL back to non secure URL and you forgot to change the or Admin to zero -means disable. It’s total mess that you cannot access the admin side again as all the JavaScript and CSS urls will have https prefix and all…Continue Reading
MySQL vs MySQLi in PHP
MySQL and MySQli are APIs to connect a MySQL database server in PHP. Each has it’s advantages and disadvantages. Note: By now MySQL extension is deprecated and it is not safe to use in future applications. It will be there for sometime for backward compatibility. MySQL Original extension designed to allow you to interact PHP…Continue Reading
How to change the default collation of a database?
To Change the entire database’s collation, just run the below query. Or Change collation of just one table Laravel date set timezoneHow to create console command in laravel ?Show a number in two decimal places in PHPPHP str_replace() FunctionHow to delete file from public folder in Laravel?How to run Laravel validation if the field is…Continue Reading
Create Simple Complete Login Script in PHP and MySql
This is a simple and complete login system in PHP and MySql. Most of the web applications it is necessary to have an authentication system. Latest frameworks such as Laravel, Symfony have bundles(modules) to do this job with the most advanced secure method. But this tutorial is intended for a beginners who wants to understand an…Continue Reading
Changing Table Engine in MySQL
We can change single table’s engine, using a single query. For example, here I am changing a table engine from MyIsam to Innodb You can read more details in here