Programming/PHP

[PDO]SQLSTATE[HY000]: General error: 2014 Cannot execute queries...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.' in /home/xxxxx/www/xxxx/xxxxx.p..

2020. 2. 13. 18:51

Programming/PHP

[PDO]디비 연결

try { $pdo = new PDO("mysql:host=localhost; dbname=DBNAME; charset=utf8", "ID", "PASSWORD", [ PDO::MYSQL_ATTR_FOUND_ROWS => true, PDO::ATTR_EMULATE_PREPARES => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ]); //$pdo->exec("SET NAMES utf8"); } catch(PDOException $e) { die("Connection Failed : ".$e->getMessage()); } 자신의 호스팅에 설치된 PHP 버전이 5.3.6 ..

2020. 2. 13. 09:52

Programming/PHP

모바일로 접속했는지 체크

출처 : http://detectmobilebrowsers.com/

2020. 2. 12. 15:20

Programming/PHP

여러 개의 br을 하나로 줄이기

$str = "I love you"; echo preg_replace("/( \s*)+/", " ", $str);

2020. 2. 11. 17:11