Profile

Cover photo
Jonathan Kelly
Works at Freelance
Attended New York University
Lived in Newark, NJ
207 followers|98,658 views
AboutPostsYouTube+1's

Stream

 
Awesome #socialnetworking  rendition of the #gameofthrones  intro.
1
Add a comment...

Jonathan Kelly

Shared publicly  - 
 
 
Intro to Design/Dev for +Google Glass is up  - props to +Katy Kasmai +Serko Artinian +Soji Ojugbele for putting it together.  Recap video linked.  Pardon the intro I couldn't resist LOL.
1
Add a comment...

Jonathan Kelly

Shared publicly  - 
 
Well that was quick! Gained access into the #androidwear developer beta!
1
Add a comment...
 
Went to the #dartflightschool and earned my wings. No red bull required! #gdgny
2
Add a comment...
Have them in circles
207 people
Elvis Au's profile photo
Greg Smith's profile photo
Kwame Williams's profile photo
Linda Michalik's profile photo
Tyler Armstrong's profile photo
Andrew Li's profile photo
Michelle Williams's profile photo
michael mabini's profile photo
 
Digging through a #Magento  site layout to update the navigation is a pain when the previous developer did a heck of a job nesting files. Thanks, #jerk ! #webdesign   #webdevelopment    
1
Add a comment...

Jonathan Kelly

Shared publicly  - 
 
7 hours of talks on advanced web technologies. Get your popcorn!
1
Add a comment...
 
I'm trying to implement Google's Google Map store locator tutorial using PDO statements but when trying to execute this query I'm getting the following error:

 "Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''25'' at line 8".

Line 8 is a blank line. This is the format of my pdo query (in php):

try {
$query = $connection->prepare('SELECT address,
      name,
      lat,
      lng,
      (3959 * ACOS(COS(RADIANS(:latitude1)) * COS(RADIANS(lat)) * COS(RADIANS(lng)-RADIANS(:longitude)) + SIN(RADIANS(:latitude2)) * SIN(RADIANS(lat)))) AS distance
FROM markers HAVING distance < :radius
ORDER BY distance LIMIT 0,
                       :maxStores');
$query->execute(array('latitude1' => $center_lat, 'longitude' => $center_lng, 'latitude2' => $center_lat, 'radius' => $radius, 'maxStores' => $maxStores));
} catch(PDOEXception $e) {
echo 'Error: ' . $e->getMessage();
}

I can't tell where the error is within the prepare statement. Does anyone have any guidance? Thank you!
1
Jonathan Kelly's profile photoDaniel M's profile photo
2 comments
 
It actually was the maxStores at the end of the query. Not sure why you can't use named parameters at the end of a query but for now I have it hard coded to a set value.
Add a comment...

Jonathan Kelly

Shared publicly  - 
1
Add a comment...
People
Have them in circles
207 people
Elvis Au's profile photo
Greg Smith's profile photo
Kwame Williams's profile photo
Linda Michalik's profile photo
Tyler Armstrong's profile photo
Andrew Li's profile photo
Michelle Williams's profile photo
michael mabini's profile photo
Work
Occupation
CG Artist, Programmer, Website Designer/Web Developer
Skills
Front end development, CG lighting and rendering, PHP scripting, graphics programming enthusiast
Employment
  • Freelance
    Web Developer/Designer, 2007 - present
  • The Richline Group
    Web Developer, 2012 - present
  • BREED
    CG Artist / Web designer, 2012 - 2012
  • VR Sim
    Programmer, 2004 - 2005
  • Commercial Legal Software
    Programmer, 2005 - 2006
  • Passion Pictures
    CG Artist, 2011 - 2012
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
Newark, NJ - New York, NY - New Britain, Connecticut
Story
Tagline
I lover of art and science and finding ways of combining them to make cool things. I also consider myself a foodie.
Introduction
A programmer at heart currently working as a front end web developer in New York City. In the past I've also done some commercial 3D art but I'm always on the quest to marry art and science.
Bragging rights
Competed in Cut & Paste NY 2011
Education
  • New York University
    Master of Science, Digital Imaging and Design, 2007 - 2009
  • University of Hartford
    Bachelor of Science, Computer Science, 2000 - 2004
Basic Information
Looking for
Friends, Networking
Apps with Google+ Sign-in
Jonathan Kelly's +1's are the things they like, agree with, or want to recommend.
Suicide Burger - Burger King Secret Menu | #HackTheMenu
hackthemenu.com

Try the Burger King Suicide Burger if you enjoy tempting fate. 8 patties fill this monster burger - find out more as we expose the Burger Ki

Chromecast is now open to developers
chrome.blogspot.com

Chromecast makes it easy to enjoy all of your favorite online content on a TV screen with the simple press of a button on your phone, tablet

Codrops
plus.google.com

Useful resources &amp; inspiration for creative minds

Android 5.0 UI Design Concept
www.makeuseof.com

It might be a while before we get to see Android 5.0, but what would you expect from the future Android OS? A cleaner lock-screen, perhaps?

Basil Thai Restaurant
plus.google.com

Basil Thai Restaurant hasn't shared anything on this page with you.

Pick Up
market.android.com

Shop Google Play on the web. Purchase and enjoy instantly on your Android phone or tablet without the hassle of syncing.

Freebase
plus.google.com

News and tips on using Freebase.

Dart
plus.google.com

Structured Apps for the Modern Web

The Truth About Multiple H1 Tags in the HTML5 Era – Tuts+
dev.tutsplus.com

Whether you're a webmaster or a web designer, there's a question you've most likely either asked or answered many times over the years. That

NewCircle Training
plus.google.com

Educating the world in open source development.

GDG New York
plus.google.com

The place in New York City where engineers, programmers, and geeks go to share and learn about Google technologies.

Webdesigntuts+
plus.google.com

In-Depth Tutorials and Articles on Web Design

Wptuts+
plus.google.com

WordPress Training, Tutorials, Articles and Freebies

Turn your beer bottles into glass cups! (5 easy steps)
seriouslyforreal.com

Glassware can get pretty expensive especially if your in college and always getting sh*t faced and breaking your glasses. Start just using y

rar.js
github.com

rar.js - Pure-JavaScript RAR reader using AJAX, File API &amp; local access

Summon Steve
summonsteve.com

Uncertain about 2012? Need to make some hard decisions? Let the man who changed the face of technology answer all your questions

Compress JPEG Images Online
compressjpg.com

Compress JPEG images for displaying on your web pages, in forums, blogs, social networks or sending by email.

Charles Tyrwhitt
plus.google.com

Quality Men&#39;s Shirts, Suits, Ties &amp; Accessories