Sometimes I need to clean a mysql server so I can re-import it clean from the backups. A DROP ALL DATABASES; would have been nice, but the following does the trick. It will drop all databases except for mysql, test… Read moreHow to Drop all Databases from Mysql?
Modify mysql database, add a field called ‘categories_footer’ at the table of ‘categories_description’, same field names and description of the field called ‘categories_description’. Add the function at admin panel, to create or modify a category, we need to modify categories.php… Read moreZen Cart V1.5.5 Add Extra Text at Category Footer
This mod assumes that you use the WordPress blogging software and uses the same database as your xcart software. If your wordpress and x-cart use separate database then use this code for blog_headlines.php
We often need to change all our mysql database table prefix. If there are only one or three tables, that would be very easy for us to change. If there are too many, say 100 mysql tatabase tables. It will… Read moreBulk Change Mysql Database Table Prefix
If you have a lot of articles, and there some hyperlinks here and there, it will be very difficult for us to remove them one by one. For example, you have about 10,000 articles, if you check each articles, I… Read moreHow to use mysql to remove the hyperlink and remain with the text?
Especially at the end of every month, we need to know how many orders we have. Here are 2 method you may like when you use Zen-Cart. First, if you need to know certain latest new orders, say 2000, how… Read moreSkills on Display Orders of Zen-Cart.
Sometimes there are thousands wordpresss comments there, it is too difficult to delete them. Any method to delete them one time without login phpmyadmin? The answer is yes, the follow code can help you. include(‘wp-config.php’); mysql_query(“truncate table wp_comments;”); Copy the… Read moreHow to using PHP to delete wordpress coments?
Q:I want to mass delete my trash with 2000+ Posts in it. Is there a mysql command to do so? A: Please backup before running the query, i’ll not take responsibility if something goes wrong as a result.. DELETE p… Read moreMass Delete trash post from WordPress
After install zen cart v1.3.9h, the front page show: #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM’ at line… Read moreZen Cart Install – #1064 – You have an error in your SQL syntax
Â <?phpÂ $DB_Server = “localhost”;Â Â Â $DB_Username = “put your user name here”;Â Â Â $DB_Password = “put your password here”;Â Â Â $DB_DBName = “put your database name here”;Â Â Â $DB_TBLName = “put your table name here”;Â Â Â Â Â $savename = date(“YmjHis”);Â // excel file name… Read moreUsing PHP to Export Mysql Data to Excel