Rajan’s Date Converter

API to get TODAY’s NEPALI Date (output: वि.सं २०७४ श्रावन ८, आइतबार) http://rajanmaharjan.com/getdate/ http://rajanmaharjan.com/getdate/index.php?dateType=np API to get TODAY’s English Date (output: 23 July 2017, Sunday) http://rajanmaharjan.com/getdate/index.php?dateType=en API to get TODAY’s NEPALI day or year or month or date (To display date as per your customization) http://rajanmaharjan.com/getdate/index.php?dateType=np&dformat=day (output: आइतबार) http://rajanmaharjan.com/getdate/index.php?dateType=np&dformat=yyyy (output: […]

Import xls data to MYSQL

mysql_connect(“localhost”,”root”,””) or die(“cannot connect”); mysql_select_db(“db_name”) or die(“cannot find database”); $dataSheetFile=”sample_csv.csv”; $counter=0; if (($handle = fopen($dataSheetFile, “r”)) !== FALSE) { while (($data = fgetcsv($handle, 1000, “,”)) !== FALSE) { $university=htmlentities(trim($data[0])); $faculty=htmlentities(trim($data[1])); $research_sub_group=htmlentities(trim($data[2])); $themenband=htmlentities(trim($data[3])); $street=htmlentities(trim($data[4])); $zipcode=htmlentities(trim($data[5])); $city=htmlentities(trim($data[6])); $website=htmlentities(trim($data[7])); $counter++; mysql_query(“INSERT INTO research_sub_group set university=’$university’, faculty=’$faculty’, research_sub_group=’$research_sub_group’, themenband=’$themenband’, street=’$street’, zip=’$zipcode’,city=’$city’,website=’$website'”); } } echo […]

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top