MYSQL
MYSQL Query Optimization – nLevel categories(Parent-Child,recursive) with single query
I was working on site optimization for one of my client. My client wants to reduce the loading time of the page and i found that most of the time is taken by database queries. At many places i need to fire mulitple queries like parent child relation.
UCFIRST-Make first character Capital using MYSQL
MySQL database is the world's most popular open source database because of its fast performance, high reliability, ease of use, and dramatic cost savings. As i am using MYSQL with developing my PHP web application, i need to make a simple String operation in MYSQL and i would like to share it with you guys. I need to make a table field values to uppercase first charactor and than lowercase all other charactors.
Adding user to phpbb3 during registration from site
If you are looking for adding user into phpbb3 forum when any user register into your site, than i might help you as i faced the same situation. Today i faced this situation where my client needs the same user in phpbb forum(auto entry) whenever user register into website. This is an external script using which you can make entry into users table of phpbb3 forum. Also if you want to transfer all your site users into forum than also this will works.
Export MYSQL data into Excel/CSV via php
Today i came across a functionality where i need to Export the MYSQL data into CSV/Excel file via PHP function/script. There are such requirement where client needs to Export the MYSQL data (Order data,Member data,Newsletter emails etc) into Excel sheet or CSV file for future reference or need to send to other team for future work. You can give a button or link from where client can click on it and get a Excel or CSV file with all data from MYSQL database tables using(through) PHP.
Import CSV/Excel data into MYSQL database via PHP
Today i came across a functionality where i need to import the CSV/Excel file in to MYSQL database via PHP script. There is a special requirement from client where he can upload the CSV/Excel file in file upload field in HTML form and all data from CSV/Excel must import into MYSQL database table through PHP.
How to get number of days between two dates using MySQL
While developing web application , in many many places we face the problem where we can use only MYSQL and get the number of number of days between two given dates using MySQL.
I am