Wednesday 17 June 2015

How to increase import size in phpmyadmin in WAMP:-


how to increase maximum execution time in php, 
How to increase maximum execution time in php, 
How to change maximum execution time in phpmyadmin, 
phpmyadmin max execution time, phpmyadmin import file size, 
phpmyadmin import file size increase, 
Increase the import file size in phpmyadmin wamp, 
Phpmyadmin increase import file size

Solution 1):-
Please follow below settings in C:\wamp\bin\apache\apache2.2.8\bin\php.ini

Find:
post_max_size = 8M
max_execution_time = 30
upload_max_filesize = 2M
memory_limit = 8M
max_input_time = 60

Change to:
post_max_size = 750M
max_execution_time = 5000
upload_max_filesize = 750M
memory_limit = 1000M
max_input_time = 5000

Then restart your wamp to take effect

Solution 2):-
Add this to an htaccess file:
<IfModule mod_php5.c>
php_value post_max_size 200M
php_value max_execution_time 259200
php_value upload_max_filesize 200M
php_value memory_limit 300M
php_value max_input_time 259200
</IfModule>

Solution 3:-
If you don't have access of your php.ini or dont use htaccess file, you can use ini_set in your php file:
For example - ini_set('max_execution_time', 5000);

You can also refer http://forum.wampserver.com/read.php?2,45000 for more informaion

Saturday 13 June 2015

Non secure to Secure AJAX call in PHP with Maintaining Session Variables

Want to Non secure to Secure AJAX call in PHP and maintain session?


What is .htaccess file?
".htaccess is a configuration file for use on web servers running the Apache Web Server software.

When a .htaccess file is placed in a directory which is in turn 'loaded via the Apache Web Server', then the .htaccess file is detected and executed by the Apache Web Server software.

These .htaccess files can be used to alter the configuration of the Apache Web Server software to enable/disable additional functionality and features that the Apache Web Server software has to offer."

------------------------------------------------

Write below code in .htaccess file.


SetEnvIf Origin "http(s)?://(www\.)?(yourdomainname.com)$" AccessControlAllowOrigin=$0
Header set Access-Control-Allow-Origin %{AccessControlAllowOrigin}e env=AccessControlAllowOrigin

Header set Access-Control-Allow-Credentials true

-------------------------------------------------------------

In your jQuery AJAX call add below code,

xhrFields : { withCredentials : true }

Example,

$.ajax({ 
 type: 'POST',
url: http://www.yourdominname.com?test.php
data:  $('#formname').serialize(),
xhrFields : { withCredentials : true },
success: function(msg) 
}
});