LATEST ENTRY
Making Stuff Online
A few basics I've picked up in the last few months of building websites.
April 25, 2008 |
RSS |
EMAIL | 
PRINT | 
3 COMMENTS 
I've been spending a lot of time learning PHP/MySQL lately (which is part of the reason I haven't been blogging all that much). I've managed to teach myself to be somewhat proficient with the stuff fairly quickly and I thought maybe it would be fun to share a few tips to getting started. I'm sure many aren't that interested in learning this stuff, but for those that are, I hope these will help get you over the hump and give it a try.
So, here are a few things you need to know/understand (and if you understand this stuff better than I do, please feel free to correct me).
Databases
They're basically just big excel spreadsheets. Each table is the equivalent of a sheet in excel. Your goal with a database is to not have a lot of empty cells, so it's important to separate related data into different tables. For instance, on a blogging platform, you need to separate out comments and entries into different tables. That's because different entries can and likely will have different amounts of comments. Therefore, if one gets 100 comments and another gets 3, you'd still need to have 100 columns for comments and on the second entry you'd have 97 empty spaces. Make sense?
GET/POST
This is basically how you pass stuff from one webpage to another. When you click a submit button on a form it is likely doing one of these two actions (I actually don't think it can do anything else). They're both fairly simple: GET puts whatever you filled in the form in the URL (do a google search and take a look at the location bar) and POST passes the variables invisibly (and according to this page should be used if you're doing something like inserting the variables into a database or sending an email because GET is easy to mess with).
Moving Stuff to and From Databases
To do pretty much everything I've needed to do thus far I've only needed a handful of database commands. SELECT grabs stuff from your database. INSERT puts stuff in your database. DELETE (which I've used far less frequently), delete's from the database (surprising huh?). Within those commands you just use WHERE to define the parameters for what row or rows you want to grab (for instance, grab the first name and email for the user with the last name "Brier").
APIs
This is one of those things lots of people talk about, but few actually understand how they actually work (and I can't claim to be an expert by any means). Most APIs work by passing them a URL with the data you want in the syntax they've defined. They then give you back whatever data you requested (most of the time in XML which you then need to parse). Using Google Maps as an example, they make it super simple to get the latitude and longitude for an address (and you can actually try this without knowing any code at all by signing up for a Google Maps API key for free.
So essentially you need to construct a URL with the address and your API key. It works something like this: http://maps.google.com/maps/geo?q=INSERT ADDRESS HERE WITH +'s INSTEAD OF SPACES&output=DEFINE OUTPUT, IN MY CASE I'M USING CSV (COMMA SEPERATED VALUES)&key=YOUR UNIQUE API KEY. They then return a CSV file with 4 values, the latitude, longitude and two other things I can't remember (I think zip is one of them). With varying degrees of complexity that's basically how all the APIs I've experiences work.
So, I hope this is somewhat useful/interesting. Part of what inspired me to write this was a quote I read last night in a little book from Electric Artists (who celebrated their 10th anniversary last night): "If you can't explain it simply, you don't understand it well enough." That nugget comes from Albert Einstein and I couldn't agree more. Obviously there's lots more to it (I haven't really even touched on PHP), but these are a few mental hurdles I had before I got started. Hopefully it inspires a few people to give PHP (or some other web language) a shot. It's really good fun.
PREVIOUS ENTRIES
Me on Identity
Reprinting an interview I recently did on the role of identity in the internet age.
April 14, 2008 | EMAIL | PRINT | 5 COMMENTS
Brain Candy
A couple different things that have been floating around in my brain.
March 28, 2008 | EMAIL | PRINT | 4 COMMENTS
Pre-PSFK Drinks
An invitation to get some drinks next Wednesday, March 26.
March 20, 2008 | EMAIL | PRINT | 3 COMMENTS
Scalable Brands
How brands tap into exponential growth.
March 18, 2008 | EMAIL | PRINT | 5 COMMENTS
Brand vs. Utility
A presentation on brand versus utility that I gave a few weeks ago.
March 12, 2008 | EMAIL | PRINT | 8 COMMENTS
Quotable
A bunch of quotes roughly about non-linearity presented linearly.
March 4, 2008 | EMAIL | PRINT | 9 COMMENTS
Brands in a World of Costless Interaction
Trying something new online is never more than a click away. How does this change the role of brand?
February 25, 2008 | EMAIL | PRINT | 7 COMMENTS
Playing Catch Up
Just some random thoughts and excuses for why I haven't posted in a while.
February 14, 2008 | EMAIL | PRINT | 3 COMMENTS
