The App we are discussing today is the Web-Developer Server suite and the suite- its aptly named! Trust me when I tell you, configuring this web server is 100 times easier than configuring Apache to run your php and MySql files.
On downloading this suite, various components such as Joomla, drupal, mediawiki, phpbb2 and wordpress are installed with the web server capable of running all of this! So you can forget manually downloading everything and configuring, as the interface provided in the above mentioned app is one of the easiest I have ever used!
So for all you geeks who have just begun to program on the above mentioned platforms, after installing this software
You just have to click on the icon on your desktop and the above window will open.
In order to be able to run your pages, you only need to start the relevant services, instead of opening windows services!
Once your services are running, log onto your browser and type in “http://localhost” to see if the server is running.
If your machine as IIS installed, you need to stop the IIS service before you start the Apache service as both of them use the same port.
As far as the performance is concerned, its a well developed application and easily one of the best out there! So check this app out, make your life & code easier!
This is post post in new series started by PHP Tutorials for Beginners by Gautam. This post provides general introduction to PHP and some historical facts about it! As PHP if language top-blogging platform WordPress uses, it is good to have little understanding of PHP. This will help you for sure in your blogging carrier even if programming is not your prime occupation. (Added by Editor)
Below I am posting some MySql queries for power WordPress bloggers. This queries will come handy if you are planning to write annual summary and analysis posts like most bloggers do at the end of year.
All queries are direct SQL and assumes standard table prefix ‘wp_’ for tables. If you are using different table prefix, please modify queries accordingly.
We strongly suggest you to back up your database as we will not be responsible for any loss or damage caused by using our code directly or indirectly. I also assume you know PhpMyAdmin or any other interface to execute MySql queries, because if you send me any question like how to use following MySql queries, I will simply reply – “Google it!” 😉
I guess I have scared you enough by now, so enjoy real stuff before you make your mind to go away…
Yearly Stats…
To get number of posts published in entire year…
SELECT * FROM `wp_posts` WHERE `post_date` <= '2008-12-31 23:59:59' AND `post_date` >= '2008-01-01 00:00:00' AND `post_status` = 'publish'
To get number of comments approved in entire year…
SELECT * FROM `wp_comments` WHERE `comment_date` <= '2008-12-31 23:59:59' AND `comment_date` >= '2008-01-01 00:00:00' AND `comment_approved` = 1 AND `comment_type` = ''
Change comment_type equal to ‘pingback’ or ‘trackback’ to get number of pingbacks and trackback respectively.
To get number of users registered in entire year…
SELECT * FROM `wp_users` WHERE `user_registered` <= '2008-12-31 23:59:59' AND `user_registered` >= '2008-01-01 00:00:00'
This is useful for only blogs who allows user to register, like Devils Workshop!
WARNING: Following query performs WRITE operation on database!
Cleanup Time!
Starting from WordPress 2.5, a revision featured was introduced which eats up lots of space in database. In case you want to perform some clean-up which is good idea, you can shoot following query!
To Delete Post Revision from WordPress Database…
DELETE FROM `wp_posts` WHERE `post_type` = ‘revision’ AND `post_date` <= '2008-12-20 23:59:59'
This will delete all post revisions created before December 21, 2008. This is to retain revisions created in last 10 days. If you remove AND post_date <= ‘2008-12-20 23:59:59’ from above query it will delete all revisions.
On executing this query, it removed 758 revisions from our database. I forgot to calculate how much space it freed, but its always good to have unwanted data out of database.
To Delete All Comments awaiting moderation…
Yes, this may sound crazy, but if for some reason your blog has been hit by comment spam, just when you forgot to put anti-spam measures in place, you must be needing something like. Its really good idea delete all unmoderated comment for one-time so you can start-over again… 🙂
DELETE from `wp_comments` WHERE `comment_approved` = '0';
You can also add DATE range to above query, in case you have idea about when comment spam hit your blog.
Thats All! If you want any particular MySQL query, please send details via following comments. 🙂
