http://blog.coding.ro Coding Through Life Mon, 21 Sep 2009 20:54:22 +0000 http://backend.userland.com/rss092 en After a long weekend of trials and errors I've finally managed to properly install Leopard 10.5.6 on my laptop. I have Leopard on my desktop along side windows 7 and is running fast, really fast. Although I knew  from the start that installing on my Presarion A944 it will not be ... http://blog.coding.ro/2009/09/osx-leopard-on-compaq-presario-a900/ One of the major fights I had while making a jump from Delphi programming to C# and .NET was the one related to embedded databases. In Delphi there are many options and I've used most of them in my programming endeavors. On the other side, .NET  seems poor by comparison. ... http://blog.coding.ro/2009/09/embedded-database-for-net/ Just the other day I was building a small in-place application/page and I needed to load some XML data using AJAX. I'll just post here the code as I believe a good example is better than a week of training. //---- this function is a wrapper for XMLHttpRequest and is not mine ... http://blog.coding.ro/2009/09/loading-and-parsing-xml-from-javascript-using-ajax-calls/ Building a house :)  : [flashvideo file=http://coding.ro/media/casa_3.m4v /] [flashvideo file=http://coding.ro/media/casa_4a.m4v /] [flashvideo file=http://coding.ro/media/casa_5.m4v /] Structure is ready... http://blog.coding.ro/2009/08/buildingahouse/ A small search on Google showed me that most of the existent Lotto Number Generators are shareware, so I decided to write a tiny PHP script that does the basic job: http://blog.coding.ro/2008/08/lotto-numbers-php-generator/ While trying to set up a meteor server I stumble upon a small issue. I need it to access the same network card using 2 different IP addresses. My favorite linux distribution for server is Ubuntu Server, but as far as I know this should apply to all Linux distros. 1. ... http://blog.coding.ro/2008/05/ubuntu-2-ip-using-one-nic/ JavaScript can display a nice confirmation box that will allow your script to test user's choice when necessary. The JavaScript "confirm" result is of type boolean. The following example should clear things for you: var yesorno = confirm("Do you like PHP?"); if( yesorno ) { alert("You like PHP, great..."); } else { ... http://blog.coding.ro/2008/05/javascript-confirmation-box/ Since the appearance of the Leopard version of the OSX operating system, I've been dying to install it on my PC. At the time I had an old Athlon CPU and I decided to get a cool new processor that would support the new OSX. In about a week I put together ... http://blog.coding.ro/2008/04/osx-leopard-leo4all-on-my-pc/ Run this SQL script either from a mysql console or from your favorite scripting language (PHP, PERL...) LOAD DATA LOCAL INFILE '/path-to-file/dump_file.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (Field_1, Filed_2, Field_3); I believe the syntax is more than clear so I won't bother explaining too much. http://blog.coding.ro/2008/04/how-can-we-import-data-in-mysql-from-csv-file/ IN PHP: $table2dump = 'table_name'; $file_content = ''; $sql = "SHOW COLUMNS FROM " . $table2dump ; $res = mysql_query($sql); while ($row = mysql_fetch_assoc($res)) { $file_content .= $row['Field'].','; } $file_content = substr($file_content, 0, -1)."\n"; $sql = "SELECT * FROM " . $table2dump ; $res = mysql_query($sql); while ($row = mysql_fetch_assoc($res)) { $file_content .= implode(',', $row)."\n"; } header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv; filename=" . date("Y-m-d") . ... http://blog.coding.ro/2008/04/how-can-we-export-mysql-data-as-csv/