Nikita Porshnjakov N-Porsh

N-Porsh / pdo_connect.php

Last active August 29, 2015 14:24 — forked from fomigo/pdo_connect.php

	<?php

	try {
	$pdo = new PDO(
	'mysql:host=localhost;dbname=test_database',
	'username',
	'password',
	array(
	PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
	PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'

N-Porsh / gist:7247597

Last active December 27, 2015 01:49 — forked from vbaert/emailimage.php

PHP: image in email

	<?php
	if(isset($_GET['uid']) && isset($_GET['mid'])){

	$mailid = (int)$_GET['mid'];
	$userid = (int)$_GET['uid'];

	$db = new mysqli_connect('databaseserver', 'databaseuser', 'databasepassword', 'databasename');
	$db->query("INSERT INTO mailreaders (mailid, userid) VALUES ($mailid, $userid)");

	$im=imagecreatetruecolor(1,1);