Introduction This is very simple article to set the mysql mode permanently inside your Mysql Server 5.7 or above versions. I tried some articles and finally found this to helpfull for someone who came with same issue. Usually some queries needs to change the sql mode permanently, Otherwise you need to write  set mode everytime. I got stressed to set sql_mode on every query. So ...

Introduction How to Create Secure Login System With PHP And MySQL. Secure PHP Login Script With Downloadable Source code. An Advanced Login Script requires to keep the system maintained safely. With Help of PHP and MySQL, we have lot of doubts and bugs to provide a better login system. Here I am going to make you a secure login system. For the secure login system, ...

MySQL Concat Multiple Columns into One. There are two possibilities while writing query to combine multiple columns. Two columns More than Two columns Let’s see each one in detail. Two Columns Suppose,  if you have the need to combine two columns into one and with some concatenation thing. Say for example, sometimes we need to show first and last name of an user from the ...

Introduction PHP Import XML File Into Database is my another article to handle the exported XML file and import it on to  another MySQL database. In my Previous Article, I wrote about how to Generate XML File Using PHP And MySQL. After Creating XML from your database.  You can carry the file to another host or another server to process the import and get the ...

MySQL Concat Multiple Rows Into A Single Row is less needy thing while querying. sometimes we have an easy solution for a complex problems. This is also like that, You might need to combine few rows for a single column, which is more complicated until you came to know about GROUP_CONCAT. Let’s code our query with GROUP_CONCAT. Our situation will be like this, We have ...

Introduction XML files are the best way to handle the export and imports or data’s. Generate XML file using PHP and MySQL is not much complicated. Also which is good to handle backups and external site duplicate with the contents and settings.  Mainly you can keep the demo data’s and settings to keep your theme or plugin demo can show the full features with the ...

API service is one of a important service or feature to every dynamic website. Which will also helps you to share your data’s Among other Website and Devices as well. Creating An API Service is easy to make and provide access to outsiders with help of my code. Creating A RESTful API With PHP and MySQL is quite easy,if you follow the steps. Introduction When ...

Uploading Multiple Files Together in one time is a bit advanced than single file upload. My Previous Article File Upload in PHP With Database, Describes you to handle single file upload. Here I am going to use that article and create Multiple File Upload in PHP with Database. The Previous one, you can’t select multiple files with the form, the  form doesn’t allow you to select multiple ...

File Upload in PHP With Database. This is really necessary feature for every website. Most of us build a site with images and other downloadable files. And we need to collect images and files from users for further reference.  Let’s create a html form to handle file upload option from your website. 1. Introduction PHP helps to handle the file uploads and keep it in ...

Resetting or Changing PHPMyAdmin Password On Linux. Sometimes you might have the problem of resetting your phpmyadmin password. Everytime it makes you to feel big to work.  And some tutorials are not nice to read and follow. because they may suggested the final step mainly. Let me elaborate you in detail. Just goto your Terminal. Just do the following steps. Stop the MySQL server to ...