mashempires.com

mashempires.com http://mashempires.com Blog about Web-Programming and more Wed, 09 Dec 2009 12:42:22 +0000 http://backend.userland.com/rss092 en BookStats.com released We released the BookStats.com page few days ago - a page where you can track book sales and new reviews on Amazon! http://mashempires.com/2009/12/bookstatscom-released/ PHP: file_get_contents(), localhost and Windows Vista Just try this code with PHP: echo file_get_contents("http://localhost/some/path/xyz.php"); If you work on a Linux-system or a Windows-system other than Windows Vista this will work fine, but on vista, the call will hang - after some time you will get just a message "Host refused the connection"; calling the url in a browser ... http://mashempires.com/2009/09/php-file_get_contents-localhost-and-windows-vista/ Filezilla-Server and FTP/SSL Found an interesting tutoriol for setting up SSL with the Filezilla FTP-Server: Tutorial http://mashempires.com/2009/08/filezilla-server-and-ftpssl/ MindMeister.com premium licenses Gotten 5 x 2 Premium months for free, feel free to use them (if you used one, post a comment for others). 23722317grjrf9227a 278784c8grjsc1e875 2825666lgrjt1a2a9d 297847dzgrju08faa4 301449kpgrjvaec4df http://mashempires.com/2009/05/mindmeistercom-premium-licenses/ Analytics: Amazon sales rank - when was something “sold”? At elchie.eu (in few weeks a relaunch with more functionality will be move over to bookstats.com) I track the sales ranks of my own books with sales ranks I get from Amazon. Every hour I check the current data and store it within a database to get historical values. There are ... http://mashempires.com/2009/03/analytics-amazon-sales-rank-when-was-something-sold/ CSS naked day On April, 9th the CSS naked day will held once again. Whats the "CSS naked day"? On this day, remove all CSS-styles from your webpage, so the pure HTML content will be shown. This will promote web standards, just keep it plain and simple. It's time to show off your body See also ... http://mashempires.com/2009/03/css-naked-day/ T-SQL/MySQL: Update only one record If you want to update just the first record and it's not possible to work with specialized conditions within the where clause in MySQL you can do this: update table set field=1 limit 0,1 But limit won't work with T-SQL - what to do? Idea: Use top. Normally top used within select-statements: select ... http://mashempires.com/2009/03/t-sqlmysql-update-only-one-record/ Google: Search Images by color [Found on lifehacker.com] Nice feature with just an URL-hack: Search images by color on Googles image-search. When searching for a image, extend the url with &imgcolor=<color> For example: http://images.google.com/images?q=cat&hl=en&imgcolor=green http://mashempires.com/2009/03/google-search-images-by-color/ United domains gives TLD-World-Map away The German United Domains Company gives a free TLD-World-Map (value: 29 Euro) away to any blogger blogging about this campaign. In the first part you will get the free world map. If you take a photo with this map in background and send it to aktion@united-domains.de your blog will be listed ... http://mashempires.com/2009/03/united-domains-gives-tld-world-map-away/ LIMIT in T-SQL The limit-keyword within select-statements is in T-SQL/MS-SQL not available. In MySQL you can retrieve records 5 to 10 with this statement: select * from tbl limit 5,5 In T-SQL you have to use a temporary table: with temp as (select *,ROW_NUMBER() OVER (ORDER BY id) as rownum from tbl) select * from temp where ... http://mashempires.com/2009/03/limit-in-t-sql/