Roger Stringer   About ▾

I'm Roger Stringer: a father, writer, developer, consultant, chef, speaker. Founder of TheInterviewr.

Monthly Archives: May 2009


Just released: newsPage 1.8

 

A couple days ago, I added some news features to newsPage and fixed a couple of bugs. Bugs fixed: Mostly, the main bug was a display one, now, if you mouse over a story, it will only show the CSS-controlled summary instead of also showing the URL’s title on top of that. New features: We’ve added some more shortcode functionality, so you can now go:

[newspage limit=5 topic="web design"]

and have it show all topics under the web design topic, and show 5 stories by page. Web design is just an example here, you can use it for which ever topic you have. Also, you can simply call

[newspage limit=10]

And you will display all links, 10 stories per link just as always. This was one of the most requested features from newsPage’s users and now that things have finally settled a little around here, I was able to get the time I needed to add it. At the same time, all other methods of displaying newsPages still work as they did before, I just added onto the functionality a little. There are some more features coming shortly, I just have to get Friendz finished first (the delays have been unfortunate and not my fault, and I promise everyone will see the final version very soon).

download files

Filed Under: Articles

~•~

Quick Function: Always make sure you close your mysql connections in PHP

 

I spend a lot of time working in PHP, and one thing I run into a lot, is garbage collection.

It’s important to make sure you DB connections are closed when the script finishes excution, or it can cause other problems (like memory, resources, etc).

So I handle my DB connection through a very simple class that is set up to do a mysql disconnect at the end of the script’s execution.

class DbConn {
    public $conn;
    public function __construct($host,$user,$pass,$db) {
        $this->conn = mysql_connect($host, $user, $pass) or die("Couldn't connection to $host");
        mysql_select_db($db,$this->conn);
    }
    public function __destruct(){
        mysql_close($this->conn);
    }   
}
$dbconn = new DbConn("localhost","mydbuser","mydbpass","mydbname");
define( "DBH", $dbconn->conn );

Then when you do your database queries, you just make sure to include the DBH handle in the code.

$result = mysql_query("Select * from people",DBH);

When the script ends, the code makes sure it closes your database connections. This can be built on quite a bit to include handling of mysql queries, but I wanted to at least share this simple class that has gotten a lot of use in various projects and has come in handy several times.

Filed Under: Code

~•~

SurveyTime launched

 

surveytime-launched.txt

SurveyTime has been in the works for a few months. Working on exactly how I wanted the site to be done. The idea was simple, I wanted to give people a fast way to create polls and surveys. And that’s exactly what I did. There are more features I’ll add as I go, but for now, SurveyTime is pretty fun. It’s got a full reporting suite, that shows some custom analytics complete with where in the world people are from when they answer your questions. As the site builds, there are a few things I’ll do to add on to it, including the abilility to group  questions into projects.

Filed Under: Articles

~•~

Some updates…

 

As I previously posted, I was away all last week, vacationing with my wife and daughter. Now, I am back and I am getting some projects done. Friendz is almost finished, mostly what is left is documentation, and that will be getting finished up over this weekend. Surveyti.me is also almost ready to launch, it is a quick free survey builder that lets you create fast surveys to add to your websites. Just a few more tweaks left to do and I’ll be talking more about it’s launch. Foodizu.com is enjoying growing it’s recipe base and there will be new recipes getting added very shortly. Finally, DBStract will be seeing some new additions to it’s report builder in the next couple weeks, followed by a newly redesigned backend area.

Filed Under: Articles

~•~

Vacation…

 

For the past week, my wife and I have been enjoying showing our daughter around Banff and Calgary. We’ve taken our 14 month old for her first visit to the zoo, her first swim in a pool, her first (and second and third) ice cream at Cows and her first gondolla ride. It’s been fun, and I’ve also been using the time to draw up ideas. Ideas for some new sites, ideas for existing sites and ideas for where to put my focus for the next half of 2009. Once we get home, I’ll have some more updates about these ideas, but suffice it to say they should be fun.

Filed Under: Articles

~•~

Manage your blog

 

I thought I’d mention on here that I’ve recently started using OIOPublisher for some of my ads on a few of my sites. Why? Because I wanted to handle ad sales myself for those sites in question. I wanted to handle collecting ad payments myself and not have to lose money for commissions. Here are some Key Features this ad manager

  • OIO can be used as a standalone platform, or as a WordPress plugin
  • sell text ads, banner ads, in-content ads and paid reviews
  • sell custom items; from custom ads to digital downloads
  • entirely automated; purchases and expirations.
  • your own ad server; javascript output lets you display ads on any website
  • break ads into zones; display ads easily over multiple sites
  • click and impression tracking; weekly ad reports emailed to advertisers
  • no empty ad slots; show your own default ads until slots are purchased
  • ad status management; approve / reject / expire / renew / validate ads
  • setup your own affiliate program; reward people for selling your ads
  • easily extend functionality; modules let developers go further
  • integrated marketplace; let us help you advertise your ads I looked around first, before making the purchase and decided to go with OIO.

There were quite a few features that sold me on this ad manager. When you download OIO Publisher, you’ll receive a WordPress plugin and be able to get an API key for each blog you want to use it on.

The plugin will create an OIO Publisher tab in your dashboard where you can manage your blogs advertisements (designate how many links, paid reviews, inline ads, banners, or custom advertising your blog will have available), create and manage an affiliate program for products or services on your blog from your dashboard, and even see statistics regarding your advertisements! Possibly my favorite feature of this plugin is that you can even set the plugin to send weekly reports to your advertisers or place your statistical information into their marketplace.

The best part about this premium plugin is that it will just about manage everything for you for a one-time fee of $47.00 (see below for a coupon link).

Once purchased, you then have access to use the plugin on as many blogs as you would like, as well as get access to their downloadable sales platform, marketplace, and all of the other features mentioned above! You also get free updates each time the plugin is updated.

I also like that you can use your one-time copy of OIOPublisher on any website you own. So you buy one copy and you can use that copy across all your sites or blogs. OIOPublisher normally sells for $47 dollars, but I have a coupon for $8 dollars off for the month of May, So that will get you OIOPublisher for $39 dollars.

Click here for $8 dollars off

Filed Under: Articles

~•~