<p><pre><code> Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 in /home/zane/public_html/airgif/api/engine/mysql.php on line 12
{"error":"Failed to connect to the database: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95"}
</code></pre>
For those of you starting new PHP projects, and for the sake of this one: the mysql_* set of functions in PHP have been discouraged for many years and are deprecated[1] as of PHP 5.5.<p>Hopefully it isn't too late to migrate to mysqli_*[2] functions or, what many developers prefer, PDO[3]. Should you choose to go the PDO route, there are some good resources out there[4] to get started.<p>[1] - <a href="https://php.net/manual/en/migration55.deprecated.php" rel="nofollow">https://php.net/manual/en/migration55.deprecated.php</a><p>[2] - <a href="https://php.net/manual/en/book.mysqli.php" rel="nofollow">https://php.net/manual/en/book.mysqli.php</a><p>[3] - <a href="https://php.net/manual/en/book.pdo.php" rel="nofollow">https://php.net/manual/en/book.pdo.php</a><p>[4] - <a href="http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers" rel="nofollow">http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers</a>
Neat project! Some feedback after trying it:<p>- I don't have a GIF folder, so it would be nice if there was a "create" folder button, or if you just created me one<p>- Can you offer a standalone build outside of the mac app store?<p>The gamification that you've included is kind of neat as well.
Setting a width and height on your thumbnails will cause your search results to look better when the site is slow (or on a slow connection):<p><a href="http://i.imgur.com/GXItOaL.jpg" rel="nofollow">http://i.imgur.com/GXItOaL.jpg</a>
Great idea, pretty poor execution. Gifs are bouncing/animating around all over the place for no apparent reason. Clicking on a gif to view just keeps loading indefinitely. Then I have to earn points to get a gif so I click to tag, but that doesn't seem to work either. I genuinely saw value in this idea. I was hoping for an app that aggregates the searching of gifs across all the popular meme/gif sites and let's me manage and tag them so I can quickly grab them when I need them. Instead, this app opts for a more complicated, less valuable, and unstable service. I hate to be so harsh, but thems my thoughts.
The tagging aspect of the project is interesting. Being able to find something specific easily on the web can be at times difficult due to a general lack of descriptions for images.<p>I have a habit of describing by filename every single image/gif/video I download which helps beyond measure when performing a search, and have over 8,000 files named in this way. I can find what I'm looking for in a few seconds. The benefit is it only takes a few moments to name initially but saves an enormous amount of time in the long run. Rewarding users to tag descriptively is a nice idea.
I've been very, very slowly building something similar to this for a long, long time and this is looks like it's 3x as awesome as the goal I had set for myself in my head.
How do you feel about "HTML5 GIFs"? I'm sure people would appreciate an automated conversion to webm. See the MediaCrush source for help: <a href="https://github.com/MediaCrush/MediaCrush" rel="nofollow">https://github.com/MediaCrush/MediaCrush</a>
Site went down it seems. Link to app store <a href="https://itunes.apple.com/us/app/airgif/id879836961?ls=1&mt=12" rel="nofollow">https://itunes.apple.com/us/app/airgif/id879836961?ls=1&mt=1...</a>
Giftoppr helps you sync your favorite GIFs with Dropbox. The UI is so much better.<p>And FOSS.<p><a href="https://github.com/desktoppr/giftoppr" rel="nofollow">https://github.com/desktoppr/giftoppr</a>
Nice concept. I like the points idea to incite tagging.<p>The homepage does a poor job of convincing me to install the application : an image (carousels don't count) and two lines of text for a visual application.