Our Blog

Get your web site designed and hosted in 30 days or less!
Click Here to get started

Thank you for visiting the South Bay Media weblog. Here you will find site news & events, various posts related to our core service offerings and other topics such as programming tips and techniques or downloadable source code.

Archive for December, 2009

Codeigniter 1.7.2 Adds a New Class Library (Shopping Cart Class)

Tuesday, 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);

Querying Data From a WordPress Blog

Saturday, 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

Integrated WordPress Blogs

Saturday, 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.

South Bay Media Gets a New Design For 2010

Sunday, 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.