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 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
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
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
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