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