by Shashi Dhar Kumar | May 30, 2014 | MySQL, Programming
It is possible to reset the auto increment value of a MySQL auto incremental primary key to a new value, either higher or lower than what it would otherwise next be. This post looks at how to do this using a MySQL query and also with phpMyAdmin. The following example...
by Shashi Dhar Kumar | Apr 22, 2013 | MySQL, PHP, Programming
There are a couple of ways to export data from MySQL to a XML file. This post looks at how to export the data from MySQL into a XML file with PHP. The example code below uses the raw mysql_* functions but it should be easy enough to substitute a database...
by Shashi Dhar Kumar | Apr 8, 2013 | PHP, Programming
There are a couple of ways to export data from MySQL to a CSV file but some of them never supports adding a header row to the CSV which contains the column names. This post looks at how to export the data from MySQL into a CSV file with PHP including a header row. The...
by Shashi Dhar Kumar | Mar 2, 2011 | Open-Source, PHP, Programming, SQL Server
How to create new user in PhpMyAdmin at localhost? Go to phpmyadmin at your localhost if you are using xampp server than go with http://localhost/phpmyadmin or if you are using easyphp than go with http://127.0.0.1/phpmyadmin Now you can see different links related to...
by Shashi Dhar Kumar | Jan 29, 2011 | PHP, Unix OS
How to increase my website speed through .htaccess in LAMP Technology Many LAMP(Linux Apache MySQL PHP) driven websites today could easily decrease their bandwidth output and increase their speed through implementing caching and compressing their content. Even with...
