MySQL Tutorials

Some Tricks to Sort Out the utf-8 Problem

Some Tricks to Sort Out the utf-8 Problem




Everyone already knows about utf-8 problem, but sometimes the issue still persists even after approaches so many solutions. So in this tutorial I am including some tricks that will surly help you to sort out the utf-8 problem. Like the problem with currency symbols(£, ₹), the solution is based on HTML, PHP and MySQL tricks. In PHP you should use following line: You can set content type using following meta …

Continue reading




MySQL server has gone away in Magento

MySQL server has gone away in Magento




Recently I faced a problem MySQL server has gone away in Magento when I was moved the code from one hosting to another hosting. Actually the problem came into notice when I try to place order sometimes it sends me back to cart page and sometimes after the successful payment via standard PayPal the order status didn’t change and remain as pending payment. Then I trace the problem by checking …

Continue reading




User Signup and Signin with PHP and MySQL

User Signup and Signin with PHP and MySQL




Authentication system is the most important part for the developers to implement in a web application. It is necessary if you want to provide limited access of your application for anonymous user. If you want to create a web application with secure admin area or a user signup and signin with php and mysql this post will help you. Here are the steps to create a simple application that allow …

Continue reading




Difference Between PDO And MySQLi

Difference Between PDO And MySQLi




We have two choices for accessing the database in PHP : MySQLi and PDO. We have already compared them with old mysql extension in Difference between mysql and pdo and Difference between MySQL and MySQLi. In this article, we will discuss difference between PDO and MySQLi on various feature like database support, stability and performance to find which is the better API. Connection : // PDO // mysqli, procedural style …

Continue reading