Thursday, 24 April 2014

Add large size database in phpmyadmin ....

step 1

Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here: 

C:\wamp\apps\phpmyadmin3.4.5\config.inc.php 

Note:  phymyadmin3.4.5 folder name is different in different version of wamp

step 2:

Find the line with $cfg['UploadDir'] on it and update it to:

$cfg['UploadDir'] = 'upload';


step 3:
Create a directory called ‘upload’ within the phpmyadmin directory.
    
C:\wamp\apps\phpmyadmin3.2.0.1\upload\


step 4:

copy and paste the  large sql file into upload directory which you want importing to phymyadmin

step 5: 

select sql file from drop down list from phymyadmin to import



Tuesday, 8 April 2014

Thursday, 13 March 2014

first application on phonegap android .......

http://cleancodedevelopment-qualityseal.blogspot.in/2012/12/first-phonegap-app-with-android-using.html

Friday, 14 February 2014

how to get current data and time in indian timezone in php

 $date = date_default_timezone_set('Asia/Kolkata');
    $dttime = date("d/m/Y, g:i a");

Monday, 28 October 2013

how to split month , year , day from date in php

date('m',strtotime('22-5-2013'))

if u have date data-type then it also possible on this way ..............

date('m',strtotime($arr[1]))

in which $arr[1] is date like 22-10-2013 store in database using date data-type

2nd way ,,,,

SELECT * FROM sochvote WHERE facid=$faculty_name and YEAR( STR_TO_DATE( voteDate,  '%d/%m/%Y' ) ) =$year_name ")