WordPress 3.5 Plugin Update Errors

I have a blog installed under xampp, and I am using windows 7 system. Today I updated my wordpress based blog to wordpress 3.5. There are some errors, all about wordpress plug-in.

I met the following errors:

Updating Plugin Akismet

Downloading update from http://downloads.wordpress.org/plugin/akismet.2.5.7.zip…

An error occurred while updating Akismet: Download failed. Could not open handle for fopen() to http://downloads.wordpress.org/plugin/akismet.2.5.7.zip.
(more…)

Posted in WordPress. Comments Off on WordPress 3.5 Plugin Update Errors »

How to Get Customers Full Name from Magento?

We can use mysql to get customers’ full name, you can add customer’s email also by using mysql clause, for example, we need to search 10,000 customers from Canada, and save the result a to a new table, say aaa_ca_custoemr, here the code: (more…)

Posted in Magento. Comments Off on How to Get Customers Full Name from Magento? »

3useful skills of Vbulletin Version 4

Here let me share my 3 useful skills about Vbulletin Version 4.
1. members that have visited the forum today for unregistered users also;
2. Similar Threads not show up
3. Reset “Most Users Ever Online”

For first question, do as follows: (more…)

Posted in Vbulletin. Comments Off on 3useful skills of Vbulletin Version 4 »

2 SEO Skills on WordPress

Here let me share 2 skills on wordpress seo. The default method of a post read more is usally shows as “read more…”, or “Continue reading”. This is very bad for our seo purpose. We all know that we’d bette use our keywords as text link or at least the text link should contain our main keywords.  How to do then? We can use each post title instead “read more…” as default text link. (more…)

Posted in WordPress. Comments Off on 2 SEO Skills on WordPress »

How to use mysql to remove the hyperlink and remain with the text?

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 am sure you will have to cost several days to remove the hyperlinks and keek the text.

There are 2 method to do this, one is using php code, we can read the article from mysql database, and using php to replace; another method, we can control mysql directly. For example, as we know, there are many people using dede cms to build sites, and all the articles is stored under body of dede_addonarticle.

Here, let share the second method with you, log in your mysql database via phpmyadmin, and choose your database, run the following sql:

update dede_addonarticle set body = replace(body,substring(body,locate(“<a “, body),locate(“>”, body,locate(“<a “, body))+1-locate(“<a “, body)),””);

Posted in MySQL. Comments Off on How to use mysql to remove the hyperlink and remain with the text? »

How to remove the title attribute using dreamweaver?

Here are some html code:

<A title=”mens glasses” href=”http://www.cheapglasses123.com/men-glasses”>Men’s Glasses</A>
<A title=”womens glasses” href=”http://www.cheapglasses123.com/women-glasses”>Women’s Glasses</A>
<A title=”kids glasses” href=”http://www.cheapglasses123.com/kids-glasses”>Kids Glasses</A>

If we do not need title attribute in these href code, and let them be: (more…)

Posted in Php Skills. Comments Off on How to remove the title attribute using dreamweaver? »

How to Get URL of Current WordPress Page or Post?

We often need to know how to get url of current wordpress page or post if we re-programming wordpress. Here I will share 2 methods with you. One is via PHP code, and the other is using wordpress function.

First, let me intruduce how to use PHP to achieve our demands. We can add the code to suitable pages, say footer.php. Go to your wordpress template, and edit footer.php. Here we use http://kingphp.com/15.html as an example. (more…)

Posted in Php Skills, WordPress. Comments Off on How to Get URL of Current WordPress Page or Post? »

How to WordPress Show Latest Posts under Certain Category?

Sometimes we need to modify wordpress templates to meet our demands, for example, we need to show latest posts under certain category only, say category id is 11. How to do then? Here is the code I have used for www.xuyi365.org

<?php query_posts('showposts=5&cat=29'); while(have_posts()) : the_post(); ?> <ul> <li><a href="<?php the_permalink() ?>" rel="bookmark"><?php the_title(); ?></a></li> </ul> <?php endwhile;?>

I have add the above code for www.xuyi365.org right bar, the complete code is:

<aside id="categories-3"><div><h3>Housing News</h3><div></div></div>  <?php query_posts('showposts=5&cat=29'); while(have_posts()) : the_post(); ?> <ul> <li><a href="<?php the_permalink() ?>" rel="bookmark"><?php the_title(); ?></a></li> </ul> <?php endwhile;?> </aside>

The code will show 5 lates posts under category 29.

Posted in WordPress. Comments Off on How to WordPress Show Latest Posts under Certain Category? »

Skills on Display Orders of Zen-Cart.

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 to do then, you can use the following mysql command:
SELECT * FROM `orders` order by orders_id desc limit 0,2000;  //show latest orders;

Second is we can use the following mysql code to show all the products with a month, say display all products within March, 2012:

SELECT date_purchased, SUM(order_total) FROM `orders` where date_purchased between “2012-03-01” and “2012-03-30”;

For some phpmyadmin or mysql version, we need to use the followng code:

SELECT date_purchased, SUM(order_total) FROM orders where date_purchased between “2012-03-01” and “2012-03-31”;
If we need to know all orders in a year, say 2011, how to then? Simple:

SELECT date_purchased, SUM(order_total) FROM `orders` where date_purchased between “2011-01-01” and “2011-12-31”;

Here we can use SUM(order_total) to caculate total value within a period.

Show orders, not include unpaid and canceled orders within a month:

SELECT date_purchased, SUM(order_total) FROM orders where date_purchased between “2012-08-01” and “2012-08-31” and  order_status <> “1”  and order_status <> “9”

Posted in MySQL, Zen Cart. Comments Off on Skills on Display Orders of Zen-Cart. »

Skills on How to Show different Adsense Ads at WordPress

More and more people love to use wordpress to setup blogs and place adsense ads, and many people still love the use the theme of Classic, by Dave Shea. Can we show different adsense code at the same place, but different pages then? For example, we want to show 2 adsense block at the main body of detailed pages, but only show 1 adsense block at other page’s main body.
(more…)

Posted in Php Code, Php Skills, Php Study, WordPress. Comments Off on Skills on How to Show different Adsense Ads at WordPress »
King Php Science Designed by:KingPhp.com Welcome, you are from: 54.205.172.57