* You may have used mysql_connect function but it was deprecated in PHP 5.5.0 and above.
bindValue($parameter, $value, $dataType);
$parameter: You don't need to use the same name as column name, but this form should be like ':name'
$dataType: PDO::PARAM_STR is for VARCHAR, or other string data type. PDO::PARAM_INT is for INTEGER data type.