All Questions
16
questions
0
votes
0answers
239 views
PHP increase max execution time for loop
I have a php script this script contain a for loop inside this loop i have a mysql query to insert data into database.
When i test this script on my localhost this script work fine.
But when i try ...
0
votes
2answers
507 views
How to faster Mysql Insert with nullif?
i am loading a CSV file through PHP and inserting into a temporary table, this is what my loading PHP script and MySQL query.
$i=0;
while (($data = fgetcsv($source, 1000, ",")) !== FALSE)
...
0
votes
0answers
56 views
double opt-in subscribe form using php and mySql [duplicate]
I am trying to send email from localhost, using xampp. With this script belowe I am getting this error: Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "...
9
votes
1answer
13k views
Where are php's extensions .so files located?
I opened some some ini files like mysqli.ini , mysql.ini , pdo_mysql.ini. Inside those files there is an .so extension added for those files. I want to know where these .so files are stored.
Inside ...
0
votes
0answers
2k views
504 Gateway Timeout after 120 seconds
My script sometimes takes more than 2 minutes and I am getting "504 Gateway Timeout Error" sometimes.
Following are the php server settings
max_execution_time 6000 (Local), 120 (Master)
...
1
vote
2answers
296 views
Fatal error Out of memory fetching data from mysql database
Hello I am facing problem with memory limit.
Please find the code below and let me guide if any thing mistake in my code.
function getRecords($table, $limit = '') {
global $db;
if (...
1
vote
0answers
45 views
Cannot login to phpmyadmin mysql when base64_decode disabled in disabled_functions
I Cannot login to phpmyadmin mysql when I add base64_decode in disabled_functions in php.ini on Ubuntu 15.04
What could be the reason? Is it normal behavior or I had some malicious code trying to ...
2
votes
2answers
6k views
utf8 in database - set default_charset in php.ini
I have set utf8 in mysql database
now it shows
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+--------...
3
votes
1answer
535 views
PDO shown as “Not Installed” in Froxlor
I am trying to install froxlor on Ubuntu 14.04 and have already installed the PHP5 MYSQL PDO Extension.
When running code:
php -i|grep PDO
It results in
PDO
PDO support => enabled
PDO drivers =...
-1
votes
2answers
326 views
Unknown PHP PDO Error When Adding FROM_UNIXTIME to WHERE clause
I have this code and I'm not sure why it isn't working. Apparently it is not catching any exceptions, I tried to debug and found out that it is breaking at the point where i add:
WHERE MONTH(...
0
votes
2answers
113 views
Uploading Big MySql Files in Phpmyadmin
Im trying to upload a 3.8gb sql dump into phpmyadmin, in wamp. I set the max_file sizes among other things to 5gb and even restarted the server multiple times. The php_info(); also gives me 5gb as the ...
-1
votes
1answer
167 views
How To Correctly Send E-Mail From Localhost [closed]
I'm trying to test out some email scripts form my localhost but it doesn't seem to be working for any of the smtp settings that I'm using. I was able to activate it using the settings that I have ...
0
votes
2answers
841 views
How do i check mysql database extension enable/disable on server in php?
I am working on a PHP install script, and I need to check many server settings before installing applications there.
So, how do I check the mysql database extension if it is enabled/disabled on ...
0
votes
1answer
7k views
phpMyAdmin isn't working
When I run phpmyadmin it shows me this message:
phpMyAdmin - Error
The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"...
2
votes
2answers
2k views
How to set PDO default host?
I'm trying to convert some PHP code from Mysqli to PDO, and I need to be able to set a default host for PDO MySQL connections (outside of my application code).
With Mysqli, I could do this with the ...
27
votes
2answers
27k views
Set PDO to throw exceptions by default [duplicate]
I always want PDO to throw exceptions if an error occurs, as I always use PDO like so:
try {
$dbh = new PDO("mysql:host=$kdbhost;dbname=$kdbname",$kdbuser,$kdbpw);
$dbh->setAttribute(PDO::...
