Posted by Andy Hassall on 07/13/06 18:37

On 13 Jul 2006 08:38:15 -0700, toomanyjoes@gmail.com wrote:

>I have written a function that runs a prepared statement and it seems
>to run just fine but when I check to see the affected rows nothing is
>affected. Can someone take a look at my code and tell me if they notice
>anything wrong outright.
>
>[CODE BLOCK for config.php]
>function QueryDB_mysqli($query, $typeStr, $varStr){
>$db_connection = new mysqli(DB_HOST, DB_USER, DB_PASSWORD,DB_DATABASE);
>$statement = $db_connection->prepare($query);
>$statement->bind_param($typeStr, $varStr);
>$statement->execute();
>$statement->close();
>exit();
>}

Is autocommit on or off? If off, it's probably doing a rollback at end of
script.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]