Titanium Appcelerator - Import project - resource already exists

If you deleted exiting project folder from "Work Space" means open Titanium Studio -->Window-->Show View--> "Project Explorer" . There you can find deleted project Resource file to delete completely. Then import new in same name again.

Import Excel or CSV to MYsql

1. Convert Excel file to CSV format.
2. Use PHPMYAdmin and then execute below SQL statement.

LOAD DATA LOCAL INFILE 'D:\\filename.csv' INTO TABLE database.tablename FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (fieldname1,fieldname2,fieldname3 )

Function split() is deprecated in PHP 5.3.0

Just replace
$win_size = split('x', $popup_win_size);
with
$win_size = explode('x', $popup_win_size);

Ereg To Preg for PHP 5.3.x from PHP 5.2.x -- deprecated error

Some other ereg_replace calls that you might find:

ereg_replace('2037' . '$', $year, date(DATE_FORMAT, mktime($hour, $minute, $second, $month, $day, 2037)))
ereg_replace('"', ' ', $pieces[$k])
ereg_replace('(' . implode('|', $from) . ')', $to, $string)
ereg_replace('[^0-9]', '', $number)
ereg_replace('-language', '-' . $languages[$j]['directory'], $cached_file)
ereg_replace('(' . implode('|', $from) . ')', $to, $string)
ereg_replace("\r","",$which_text)
ereg_replace('-language', '-' . $language, $cache_blocks[$i]['file'])
ereg_replace(",\n$", '', $schema)
ereg_replace("\n#", "\n".'\#', $row)
ereg_replace(', $', '', $schema)

would become

preg_replace('{2037\z}', $year, date(DATE_FORMAT, mktime($hour, $minute, $second, $month, $day, 2037)))
str_replace('"', ' ', $pieces[$k])
preg_replace('{(' . implode('|', $from) . ')}', $to, $string)
preg_replace('{\D}', '', $number)
str_replace('-language', '-' . $languages[$j]['directory'], $cached_file)
str_replace("\r","",$which_text)
str_replace('-language', '-' . $language, $cache_blocks[$i]['file'])
preg_replace("{,\n\z}", '', $schema)
preg_replace("{\n#}", "\n".'\#', $row)
preg_replace('{, \z}', '', $schema)

Warning: I haven't tested any of these.          

http://forums.oscommerce.com/topic/341737-function-ereg-replace-is-deprecated/

http://www.devthought.com/2009/06/09/fix-ereg-is-deprecated-errors-in-php-53/

jquery datepicker not working in ajax page --> Solved

http://stackoverflow.com/questions/8357702/jquery-datepicker-in-ajax-page

if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
     $( "#datepicker" ).datepicker();
    }
  }
xmlhttp.open("GET","development-bundle/demos/datepicker/default.html",true);
xmlhttp.send();
}

PHP Pie chart script

http://www.softwareforeducation.com/lamp/phpweb/06pie.php

Titanium Web Link --- Is there a way to publish a link in the desktop app, that opens up in the system web browser?

Mobile: Titanium.Platform.openURL

Desktop: Titanium.Desktop.openURL

onclick="javascript:Titanium.Desktop.openURL('http://www.google.com');"


http://developer.appcelerator.com/question/28751/is-there-a-way-to-publish-a-link-in-the-desktop-app-that-opens-up-in-the-system-web-browser