note 124449 added to mysqli-stmt.send-long-data

From: Date: Thu, 28 Nov 2019 12:40:25 +0000
Subject: note 124449 added to mysqli-stmt.send-long-data
Groups: php.notes 
Request: Send a blank email to php-notes+get-213275@lists.php.net to get a copy of this message
If you are trying to write a single field which is above max_allowed_packet then this function will not help you (contrary to what the documentation example seems to show above). Parameters in MySQL are still restricted by max_allowed_packet on a per-field basis so you will get an error like: “mysqli_sql_exception: Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_long_data_size' bytes” The only real use case for this function seems to be if you are writing multiple long fields which when combined would go over max_allowed_packet. ---- Server IP: 208.43.231.9 Probable Submitter: 185.85.3.195 (proxied: 37.48.227.29) ---- Manual Page -- http://php.net/manual/en/mysqli-stmt.send-long-data.php Edit -- https://master.php.net/note/edit/124449 Del: integrated -- https://master.php.net/note/delete/124449/integrated Del: useless -- https://master.php.net/note/delete/124449/useless Del: bad code -- https://master.php.net/note/delete/124449/bad+code Del: spam -- https://master.php.net/note/delete/124449/spam Del: non-english -- https://master.php.net/note/delete/124449/non-english Del: in docs -- https://master.php.net/note/delete/124449/in+docs Del: other reasons-- https://master.php.net/note/delete/124449 Reject -- https://master.php.net/note/reject/124449 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#213275) next »