Friday, 17 October 2014

Saturday, 4 October 2014

i can't use my gmail account for sending mail in wamp php but my friend accout is work. fix bug

follow this link :

http://support.mailpoet.com/knowledgebase/sending-with-gmail-doesnt-work/


if above link is not work then go on this link after login in your gmail account :
https://security.google.com/settings/security/activity


Friday, 12 September 2014

selecting-multiple-columns-fields-in-mysql-subquery and used in outer

FROM (SELECT col as name1, col2 as name 2 FROM ...) B
delete from exm_examresultdetail where ExamResultId not in (select bb.ee from (SELECT MAX(TotalObtainMarks) as aa,ExamResultId as ee FROM `exm_examresult` group by UserId,ExamId) bb)
http://stackoverflow.com/questions/5686271/selecting-multiple-columns-fields-in-mysql-subquery

Tuesday, 19 August 2014

The Specified Module could not be found. (Exception from HRESULT: 0x8007007E)

replace this file C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\dsref80.dll

https://onedrive.live.com/?cid=781318cea9a1daf6&id=781318CEA9A1DAF6%21107 dowmload from this

Tuesday, 6 May 2014

how to start xampp server in redhat server

setenforce 0

service vsftpd restart
service httpd restart
service mysqld restart


how to increase upload file size limit in linux in xampp

u need to just put in httpd.conf in etc/httpd/conf/httpd.conf

<IfModule mod_php5.c> php_value upload_max_filesize 10M php_value post_max_size 20M </IfModule>


Thursday, 24 April 2014

how to host your php site in local server in xampp

first install my public wifi then one ip automatic generate in IPV4 when right click on wifi

C:\xampp\apache\conf\extra\httpd-vhosts.conf

<VirtualHost 192.168.1.102:80>
    ServerAdmin root@192.168.1.102
    DocumentRoot "C:/xampp/htdocs/SOCH/"
    ServerName 192.168.1.102
    ErrorLog "logs/dummy-host2.example.com-error.log"
    CustomLog "logs/dummy-host2.example.com-access.log" common
</VirtualHost>

create a vpn CONNECTION


http://www.bestukvpn.com/

Control Panel\All Control Panel Items\Network and Sharing Center

then set up a new connection or network

then connect to a workplace

no create a new connection

use my internet connection

internet address : bestukvpn.com
Destination name : Any name

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");