Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Bilal Ahmad
Hi i wanna ask a question. I am trying to create an image on fly, please do help me , following is the code. *File Name : Font.php Code: * Image Creation var xmlhttp; function showPic() { xmlhttp=GetXmlHttpObject(); if (xmlhttp==null) { alert ("Browser does not support HTTP Request");

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Done. Thanks for letting me know about that. > kesavan trichy rengarajan wrote: > > > could be rewritten as: > > mysqli_stmt_bind_param($submitadmin, "isss", $numrows, $admin, > > sha1($password), $email); > > Turning on E_STRICT in PHP 5.3 will show > >PHP Strict Standards: Only variable

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Christopher Jones
kesavan trichy rengarajan wrote: > could be rewritten as: > mysqli_stmt_bind_param($submitadmin, "isss", $numrows, $admin, > sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be passed by reference This is also true in earlier v

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
That worked, thanks! > Remove the quotes around the variables in all your statements. > For example, this statement: > mysqli_stmt_bind_param($submitadmin, "isss", '$numrows', '$admin', > sha1('$password'), '$email'); > > could be rewritten as: > mysqli_stmt_bind_param($submitadmin, "isss", $numro

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread kesavan trichy rengarajan
Remove the quotes around the variables in all your statements. For example, this statement: mysqli_stmt_bind_param($submitadmin, "isss", '$numrows', '$admin', sha1('$password'), '$email'); could be rewritten as: mysqli_stmt_bind_param($submitadmin, "isss", $numrows, $admin, sha1($password), $email

[PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Hello everyone, I have a problem. I use the following to *try* and insert data into my MySQL database... //Variables come from a form $username= $_POST['username']; $password = $_POST['password']; $email = $_POST['email']; //Connect to the database $connect = mysqli_connect("$hostname", "$dbuse