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 […]
MySql
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 […]
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
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 […]
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