I am trying to insert a user and his password into my Oracle database. When I insert a basic name and password, all right. But when I try to insert a user, with a password hasheada, I do not get an error, but it does not do anything to me either.
I attach the code:
<?php
require_once "../INCLUDES/conn.php";
$con = connection();
$user = 'usuario';
$pass = password_hash('K899XMu8ee4I', PASSWORD_DEFAULT);
$statement = $con->prepare("INSERT INTO usuarios (name, pass) VALUES (:user,
:pass)");
$statement->bindParam(':user', $user);
$statement->bindParam(':pass', $pass);
$statement->execute();
$con = null;
?>
I get the following error:
Array ( [0] => HY000 [1] => 1745 [2] => OCIStmtExecute: ORA-01745: invalid host/bind variable name (ext\pdo_oci\oci_statement.c:159) )