Skip to content

Instantly share code, notes, and snippets.

View gjerokrsteski's full-sized avatar
🎯
Focusing

Gjero Krsteski gjerokrsteski

🎯
Focusing
View GitHub Profile
@gjerokrsteski
gjerokrsteski / pdo-sql.log
Created September 9, 2011 08:31
SQL-Statements erstellt von PDO während des Benchmarks
110824 10:14:42 14425 Connect xxxxx@localhost on krsteski_doctrine2_test
14425 Query SET NAMES utf8
14425 Query DROP TABLE IF EXISTS bookPDO
14425 Query DROP TABLE IF EXISTS authorPDO
14425 Query CREATE TABLE bookPDO (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(255) NOT NULL,
isbn varchar(24) NOT NULL,
price decimal(10,0) NOT NULL,
authorPDO_id int(11) DEFAULT NULL,
@gjerokrsteski
gjerokrsteski / doctrine-sql.log
Created September 9, 2011 08:26
SQL-Statements erstellt von Doctrine2 während des Benchmarks
110824 10:24:59 14537 Connect xxxx@xxxxx on krsteski_doctrine2_test
14537 Query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
14537 Query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS CollactionName FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'krsteski_doctrine2_test' AND TABLE_NAME = 'Author'
14537 Query SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'Author' */ WHERE k.table_name = 'Author' AND k.table_schema = 'krsteski_doctrine2_test' /*!50116 AND c.constraint_schema = 'krsteski_doctrine2_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
1453
@gjerokrsteski
gjerokrsteski / php-send-pdf-file-as-header
Created December 8, 2010 16:18
sends pdf-file as header through any firewall and browser
/**
* Prints out the new generated pdf-file as an raw HTTP-header.
* @link http://reeg.junetz.de/DSP/node16.html
* @link http://www.php.net/manual/de/function.header.php#88038
* @return void
*/
function sendPdfFileAsHeader($pdfFile, $fileName)
{
$disposition = (false !== strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE 5.5'))
? ''