December 29th, 2009
The latest release of Codeigniter 1.7.2 adds a new shopping cart class to the library which permits items to be added to a session that stays active while a user is browsing the site.
Like all Codeigniter libraries, initilization is done as follows:
$this->load->library('cart');
And items are added to the cart as follows:
$data = array(
'id' => 'sku_123ABC',
'qty' => 1,
'price' => 39.95,
'name' => 'T-Shirt',
'options' => array('Size' => 'L', 'Color' => 'Red')
);
$this->cart->insert($data);
Tags: Codeigniter, PHP, Shopping Cart
Posted in Programming | No Comments »
December 26th, 2009
Some of the latest versions of Wordpress use a new taxonomy database schema which can make it a bit tricky to get at and display posts data from MySQL. Here is a query we use to display the latest news and events throughout our site:
SELECT wp_posts . *
FROM wp_posts
LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id
LEFT JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id )
LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id )
WHERE wp_postmeta.meta_key = "_edit_last"
AND wp_posts.post_status = "publish"
AND wp_term_taxonomy.taxonomy = "category"
AND wp_term_taxonomy.term_id
IN ( [Put your category ID here] )
ORDER BY wp_posts.post_date DESC
The IN clause is where you would want to put the ID from the category you want displayed. This query has been tested and works with Wordpress version 2.9
Tags: Database, MySQL, Query, SQL, Taxonomy, Wordpress
Posted in Programming | No Comments »
December 26th, 2009
Some of our clients have never before heard of Wordpress or do not have much experience with blogging systems. In short, Wordpress is an open source (free) blogging platform that allows you to easily create new content on your web site such as company news or other information you would like updated and posted immediately on your web site. Wordpress is by far one of the most popular and easy to use blogging systems available today.
This blog currently uses an integrated installation of Wordpress 2.9 with our own custom theme applied and gives the appearance of a seamless transition between our regular web site and our blog/news and events section. The purpose of this post is to let our current and prospective clients know that we can easily integrate Wordpress into your existing or new web site.
Adding a blog to your existing or new web site is a great way to increase traffic since each new post you add creates a new page for search engines to index. If you would like to learn more about Wordpress click here.
If you would like to add a custom integrated Wordpress blog to your new or existing web site, please click here to contact us.
Tags: Blog, Wordpress
Posted in News & Events, Related Offers | 3 Comments »
December 20th, 2009
We like to keep things fresh, which is why we have updated our site with a new design for 2010. Aside from the new design layout, the most significant new addition features an integrated installation of the latest version of Wordpress which we now use for our blogging and news and events platform. In addition to Wordpress, we are now using jQuery and a handful of custom plug-ins.
One of our goals with the new design is to streamline the way we interact and do business with our clients. We want to make it as easy and straightforward as possible from the initial steps of first contact to delivering a functional web site that meets or exceeds your business objectives.
Stay tuned for our new and improved quoting system which will take you step by step through the process of defining requirements and gathering all pertinent information we need to quickly get started on designing you a new site or re-designing your existing web site.
Thanks for visiting and feel free to provide any feedback on the latest design.
Posted in News & Events | No Comments »