While dealing with phpMyAdmin for novice user, sometime you unable to login into mysql using the mysql console. It throws #1045 - Access denied for user 'root'@'localhost' (using password: YES) error on screen. If root@localhost wasn't granted the necessary rights to access the database or you provided the wrong password, you will then encounter this error.
convert-php-mysql-to-json-format When we are dealing with web services, we are received the server side data into the JSON format or other. When it comes at PHP, then transforming the MySQL data to JSON Format becomes very important task for developer. In very less time JSON has gained its popularity over the XML format in terms
The mysqli and mysql are the database extension which allows you to access the functionality provided by MySQL 4.1 and above. The PHP code consists of a core, with optional extensions to the core functionality. PHP's MySQL-related extensions, such as the MySQLi extension, and the MySQL extension, are implemented using the PHP extension framework. An
In this post we will try to find out that what is the best/fastest way to upload a large excel csv data into a MySQL table. In one of my present projects there is a requirement to upload of millions of records from several csv files into a database. The files are uploaded to the server
CodeIgniter (CI) is one of popular PHP framework. If you are already building PHP Application, CodeIgniter will help you to do it better and more easily. For example, they can create web page (that to do basic Create, Read, Update, and Delete ) CRUD automatically. In this post, we are going to create simple CRUD