Skip to content

Instantly share code, notes, and snippets.

View sv3tli0's full-sized avatar
🏠
Working from home

Svetoslav Mutev sv3tli0

🏠
Working from home
  • Plovdiv
  • 07:13 (UTC +03:00)
View GitHub Profile
@sv3tli0
sv3tli0 / gist:130876213b139ca33508
Created February 23, 2015 21:32
PHP subscribe - simple subscribe functionality responding in json format
<?php
$email = (string) filter_input( INPUT_GET, 'email', FILTER_SANITIZE_EMAIL);
$email = filter_var( $email, FILTER_VALIDATE_EMAIL);
$name = (string) filter_input( INPUT_GET, 'name', FILTER_SANITIZE_SPECIAL_CHARS);
if( $email) {
$pdo = new PDO('mysql:host=127.0.0.1;dbname=database', 'username', 'password');
$stm = $pdo->prepare("SELECT COUNT(*) FROM `subscribes` WHERE `email` = ? ;");
$stm->execute([$email]);