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