https://www.dotpointer.ga/mysql/
https://gitlab.com/dotpointer/mysql-shim/
Category Archives: PHP
phpmyadmin – Não foram recebidos dados para importar.
Não foram recebidos dados para importar. Ou não foi submetir um nome de ficheiro, ou o tamanho do ficheiro excede o tamanho máximo permitido pela sua configuração PHP. Veja FAQ 1.16.
Temos de aumentar o limit de upload e post no php.ini
rh-php73 – enable imagick extension module
Let’s search for imagick.so
find / -name 'imagick.so'
/usr/lib64/php/modules/imagick.so
/opt/rh/rh-php73/root/usr/lib64/php/modules/imagick.so
Let’s enable imagick extension module
nano /etc/opt/rh/rh-php73/php.d/20-imagemagick.ini
; Enable imagick extension module
extension=/opt/rh/rh-php73/root/usr/lib64/php/modules/imagick.so
Restart PHP 7.3 FPM
service rh-php73-php-fpm
google captcha – no curl_exec
$response = file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=".$secret."&response=".$response);
$response = json_decode($response, true);
if($response["success"] === true){
// actions if successful
}else{
// actions if failed
}
codeigniter Message: __autoload() is deprecated, use spl_autoload_register() instead
A CI application was returning me the following error, after the PHP been updated to 7.3.
I had to change a few lines at config/config.php
function __autoload($class)
{
if(strpos($class, 'CI_') !== 0)
{
@include_once( APPPATH . 'core/'. $class . EXT );
}
}
to
spl_autoload_register(function($class) {
@include_once ( APPPATH . 'core/'. $class . EXT );
});google.com: XXX.XXX.XXX.XXX is neither permitted nor denied by best guess record for domain of [email protected]
If you are using mail() to send an email, with PHP, and you are getting the following error…
spf=neutral (google.com: 69.55.XXX.XXX is neither permitted nor denied by best guess record for domain of [email protected]) [email protected] Return-Path: <[email protected]>
You can force the ‘mailfrom’ by adding -f[email protected], after the headers.
$send = mail($to, $subject, $message, implode("\r\n", $headers), '-f'.$from);
PHP 2-chars ISO 3166-1 code to full country name
echo (Locale::getDisplayRegion(‘-PT, ‘en’))
php – short_open_tag not working?
Some tutorials tell use to set short_open_tag on /etc/php.ini, but it might now work!
This might not be the php.ini that PHP/Apache is reading.
Use phpinfo() to get the real php.ini file.
Hope it helps anyone.
PEAR – DB Error: extension not found
Yesterday I had to set up a new server for bunch of sites from 2008 using PHP Pear….
DB Error: extension not found
You might need to add the following line at the end of /etc/php.ini
extension=mysqli.so
codeigniter + php + mysql – emojis 😉
This is how…
On mysql set your table(s)’s filed(s) to utf8mb4_general_ci.
codeigniter config/database.php
$db['default']['char_set'] = 'utf8mb4';
$db['default']['dbcollat'] = 'utf8mb4_general_ci';Resources
https://stackoverflow.com/questions/16828197/displaying-utf8-character-on-codeigniter