Older Entries »

Automated Way to Find Google Pagerank

By James Thompson, on June 25th, 2010%
google-pagerank

I was looking for an automated way to get Google Pagerank for a few hours and came up with quite a few things, but not many of them were very elegant.  Essentially, Google doesn’t provide an API and it’s against their terms of service to hit them up in an automated way.  I found quite a . . . → Read More: Automated Way to Find Google Pagerank

2 comments   Programming   , , , , ,  

Tidbit Tuesday: Paginating in MSSQL

By James Thompson, on March 2nd, 2010%

I don’t really work with MSSQL very much and was wondering how to do pagination similar to doing it in MySQL with the LIMIT command.  It’s MUCH harder in MSSQL, but here is how you do it:

SELECT * FROM
(SELECT TOP [size_of_record_set] * FROM
(SELECT TOP [end_record] * FROM [table] ORDER BY [field] ASC) AS tbl1 . . . → Read More: Tidbit Tuesday: Paginating in MSSQL

One comment   Programming, Tutorials   , , , ,  

The Twitter API

By James Thompson, on February 4th, 2010%

I’ve been messing with the Twitter API for the first time in the last few hours, and I’ve learned a TON.  I know – I’m jumping on the bandwagon late, but oh well.  I managed to create a script to retweet “stuff” based on the search functionality and I made a script to automatically follow people . . . → Read More: The Twitter API

2 comments   Insights, Programming, Tutorials   , , , , , , ,  

Tidbit Tuesday on PHP: Simple MySQL Database Insert Function

By James Thompson, on November 10th, 2009%

This builds on a function I did last week: db_query(). You can send any array straight to a MySQL database and it’ll even check to make sure the column actually exists.  Oh, and it returns the id of the record you just added in case you needed it.

<?php
function db_array_insert($cfg_array, $table, $array) {
. . . → Read More: Tidbit Tuesday on PHP: Simple MySQL Database Insert Function

Leave a comment   Programming, Tutorials   , , , , , , , , , , , ,  

Tidbit Tuesday on PHP: Simple MySQL Database Query Function

By James Thompson, on November 3rd, 2009%

It’s always great to create functions for those things you do a lot.  Probably the single most common function I execute is database calls.

Here is a simple script for hitting up your MySQL database with a query:

<?php
if(!function_exists(dbQuery)) {
function db_query($cfg_array, $query) {
. . . → Read More: Tidbit Tuesday on PHP: Simple MySQL Database Query Function

One comment   Programming, Tutorials   , , , , , , , , , , , ,  
 
  Older Entries »

Sponsor:

SponsoredTweets referral badge