How to store LONGTEXT to MySql database

Question

I have a very large matrix 1328x1328 and I'm trying to store the upper triangle (it is symmetrical) of it to the database as LONGTEXT. In JavaScript I serialize it: JSON.stringify(matrix) (serialized string length 16744056 characters) and send it to the server using ajax:

$.ajax({
      type: "PUT",
      url: 'post-user-matrix.php',
      data: JSON.stringify(matrix),
      contentType: "application/json"
    });

It arrives to PHP with no problems, but from there I want to save it to the database table

u_id(INT) | matrix_json (LONGTEXT)

The PHP script that should send the data to the database look like this:

$user_id = getUserID();
$matrix = file_get_contents("php://input");

if ($insert_stmt = $mysqli->prepare("INSERT INTO users_matrix (u_id, matrix_json) VALUES (?,?)")) {
    $null = NULL;
    $insert_stmt->bind_param('is',$user_id, $null);

    $matrixchunks = str_split($matrix, 8192);

    for ($i=0 ; $i < count($matrixchunks) ; $i++) {
        $insert_stmt->send_long_data(1, $matrixchunks[$i] );
    }

    $insert_stmt->execute(); 

}

I tried to use send_long_data relying on PHP documentation, but the script gives no errors and doesn't send anything to the database.

This is almost certainly a `max_post_size` issue http://stackoverflow.com/questions/6135427/increasing-the-maximum-post-size — Danny Kopping, May 02 '15 at 10:54
Here - $insert_stmt->bind_param('is',$user_id, $null); replace is by ib, because it is blob data, not string - flag is b not s — Kancho Iliev, May 02 '15 at 10:55
`error_reporting(E_ALL); ini_set('display_errors', 1);` It should show errors. Also tried it with ib, still nothing. Could be `max_post_size`, but shouldn't sending smaller chunks resolve that? — Jackstick, May 02 '15 at 11:09

score 0 · Answer 1 · answered May 02 '15 at 10:58

0

I think the problem is in flags - has to be ib, not is

 $insert_stmt->bind_param('ib',$user_id, $null);

It can be seen on php documentation sample here: http://php.net/manual/en/mysqli-stmt.send-long-data.php

answered May 02 '15 at 10:58

Kancho Iliev

701
5
13

Gives no different result unfortunately. – Jackstick May 02 '15 at 11:11
OK, but what is the type of the column matrix_json? – Kancho Iliev May 02 '15 at 11:16
It's LONGTEXT, should it be BLOB? I used longtext because I'm saving a string. – Jackstick May 02 '15 at 11:22
In php documentation is written - TEXT or BLOB – Kancho Iliev May 02 '15 at 11:25
Apparently it was reached the `maximum execution time` which at first didn't show up in the errors. – Jackstick May 02 '15 at 14:31

How to store LONGTEXT to MySql database

1 Answers1