<?php

		try{
			$dbhost = "localhost";
			$dbname = "popporta_popadmin";
			$dbusername = "popporta_popadmi";
			$dbpassword = "Funkd8479#";

			$pdo = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);
			$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			echo "CONNECTED<br>";


			$data =  [
					"fname" => $fname ,
					"lname" => $lname ,
					"company_name" => $company_name ,
					"message" => $message ,
					"created_at" => date('Y-m-d H:i:s')
			] ;

			$sql = "INSERT INTO retailer_reg( fname, lname,  company_name, message, :created_at)";

			$stmt = $pdo->prepare($sql);
			//$stmt->execute( $data );

			$result = $stmt->execute( $data );

			if( $result ){
				echo "<h2 style='color:green;'>INSERTED ROW</h2>";
			} else {
				echo "<h2 style='color:red;'>FAILED TO INSERT ROW</h2>" ;
			}

			$stmt->closeCursor();

		}
		catch ( PDOException $e) {
			echo $e->getMessage();
		}