Hello all,
I Just re-joined this forum after time travel without my lap Big mistake!...
Now I'm back to working on my skills in writting code and I have a problem with some Prepared statements i'm trying to use..
[syntax=php]
function AddUser($user, $pass){
//$user = mysql_real_escape_string(htmlentities($user));
//$pass = sha1($pass);
$mysql = new mysqli('localhost', 'user', 'pass', 'dbname') or die('Could not Connect to Databse');
$stmt = $mysql->prepare("INSERT INTO `users` (`user_username`, `user_password`) VALUES (:username, :password)") or die('There is a problem with the query.');
$stmt->bindparam(':username', $user);
$stmt->bindparam(':password', $pass);
$stmt->execute();
}
[/syntax]
I can't get this query to work, and to me it looks just like the one on http://php.net/manual/en/pdo.prepared-statements.php
If you know something about prepared startements please show me the way
Best regards
Wizz
Prepared statements
Re: Prepared statements
Welcome back
Your mixing PDO and mysqli, try this example http://uk.php.net/manual/en/mysqli-stmt.bind-param.php
Your mixing PDO and mysqli, try this example http://uk.php.net/manual/en/mysqli-stmt.bind-param.php