The problem is that when using the PHPMySQLi extension with prepared statements, I was getting an empty value in one of my bound variables after using $mysqli->execute(), $stmt->bind_param(), and $stmt->fetch(). If I executed the exact same query using $mysqli->query() and subsequently using $result->fetch_object() I would get the values I was looking for.
…In any event, we’ll be able to work with a TEXT column instead of using a LONGTEXTcolumn in this application.
Good to know I’m not alone. Switching the column to text instead of longtext may be low tech, but if it’s good enough for Joe Kovar it’s good enough for me.
Tags: $var = $child->bigtext;, bind_result longtext, how to store php longtext in variable, longtext, longtext not working in prepared statements in php, longtext php prepared statements, longtext variable php, longtext variable phpmysqli, msqli longtext empty, mysqli, mysqli @variables, mysqli and longtext, mysqli bind_result text field, mysqli long text, mysqli longtext, mysqli longtext empty, mysqli longtext php, mysqli prepare longtext, mysqli prepared statements longtext, mysqli return longtext, php, php fetch_Object empty field returned, php longtest, php longtext, php longtext null value, php longtext store_result bind_result, php mysqli bind_result empty longtext fix, php mysqli empty longtext, php mysqli longtext, php mysqli longtext empty, php mysqli longtext fetch, php mysqli longtext null, php mysqli return longtext, php passar parametros longtext, php prepared statement longtext not work, php prepared statements longtext, php+longtext+wordpress, php+variable+longtext, return longtext field php, store variable in longtext php, the columnist boxer shorts, variables+longtext+php