<?php
error_reporting(E_ALL); ini_set('display_errors',1);

$dsn = 'mysql:host=popportal.swimshow.com;dbname=popporta_popadmin';
$username = 'popporta_popadmi';
$password = 'Funkd8479#';

try {
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


	$sql = "INSERT INTO users(name,email,is_active, password )
				VALUES(:name, :email, :is_active, :password)";

	$stmt = $pdo->prepare($sql);

	$stmt->bindValue(':name', "toto");
	$stmt->bindValue(':email', "toto@gmail.com");
	$stmt->bindValue(':is_active', "1");
	$stmt->bindValue(':password', "adc0c6d199364147f3d34810ebd65428");

	$stmt->execute();

	$stmt->closeCursor();


    echo 'INSERTED to Database<br>' ;
    echo 'SERVER SOFTWARE: ' .  $_SERVER['SERVER_SOFTWARE'] ;

} catch (PDOException $e) {
    echo 'ERROR connecting, check your DB credentials<br>';
    $error_message = $e->getMessage();
    echo '<br>';
	echo $error_message ;
    exit();
}