I know a few people around these parts read hacker news, and may have seen Jerry Seinfeld's Productivity Secret
I've really never found a system that really fits my workflow, and wondered how everyone kept track of their days.
$pdo = new Pdo('mysql:host=127.0.0.1;dbname=app', 'root');
$query = $pdo->prepare('SELECT * FROM accounts WHERE id = ?');
$result = $query->execute(array(2));
if (false !== $result) {
foreach ($query->fetchAll(PDO::FETCH_OBJ) as $row) {
echo $row->name, "\n";
}
}
I've been re-writing a lot of queries in the day job lately, and noticed that older queries didn't make use of prepared statements. They either accepted straight user input, or used some custom method that tried to duplicate what mysql_real_escape_string or prepared statements does.
So perhaps there's a lack of education in this, or perhaps developers are lazy (cough).
But either way, here's a basic example of using a prepared statement to find an account.
def self.terms(terms)
return if terms.blank?
composed_scope = scoped
terms.split(' ').map { |term| "%#{term}%" }.each do |term|
composed_scope = composed_scope.where('first_name ILIKE :term OR last_name ILIKE :term OR email ILIKE :term', { :term => term })
end
composed_scope
end
A slightly more ruby way, scopes are obsolete
A nifty little micro framework, in PHP.
Feedback, forks, pull requests welcome
require 'httparty'
module MaxMind
class API
class << self; attr_accessor :key; end
end
class Request
include HTTParty
base_uri 'http://geoip3.maxmind.com/'
def self.find_by_ip(ip)
get '/f', :query => { :i => ip, :l => API.key }
end
end
end
Just a simple little API wrapper for a proof-of-concept application.
Neat git extension for managing your git workflow.