<?php

$servername = "address";
$username = "user";
$password = "pass";
$dbname = "eve";

try {
    $conn = new PDO("mysql:host=".$servername.";dbname=".$dbname."", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO corp_assetlist (itemID, locationID, typeID, quantity, flag, singleton, rawQuantity)
    VALUES (':val1', ':val2', ':val3', ':val4', ':val5', ':val6', ':val7')";

    // use exec() because no results are returned
    $conn->exec($sql);

$req->execute(array(
    'val1' => 'itemID',
    'val2' => 'locationID',
    'val3' => 'typeID',
    'val4' => 'quantity',
    'val5' => 'flag',
    'val6' => 'singleton',
    'val7' => 'rawQuantity',
));

    echo "New record created successfully";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;

?>