Mysql不存储blob列数据

Question

I have strange problem that I am unable to figure out, any help would be appreciated!.

The problem is I am trying to store an object into mysql database, when I execute the insertion command I run successfully, but when I check the table, all columns have the new inserted data expect the column with Blob datatype.

here is the table

CREATE TABLE `uc_opportunities` (
 `post_id` int(11) NOT NULL AUTO_INCREMENT,
 `org_id` int(11) DEFAULT NULL,
 `dateTime` int(11) NOT NULL,
`subject` varchar(200) NOT NULL,
`text` varchar(2000) DEFAULT NULL,
`zipcode` varchar(10) NOT NULL,
`location` varchar(100) DEFAULT NULL,
`schedule` blob NOT NULL,
PRIMARY KEY (`post_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

and here is the insertion function:

public function addOpportunity($org_id)
{
    global $mysqli,$emailActivation,$websiteUrl,$db_table_prefix; // 

    echo "inside add opportunity<br>";
    var_dump($this->schedule);

    $stmt = $mysqli->prepare("INSERT INTO ".$db_table_prefix."opportunities (
        org_id,
        dateTime,
        subject,
        text,
        zipcode,
        schedule
        )
        VALUES (
        ?,
        ?,
        ?,
        ?,
        ?,
        ?
        )");

    $schedule_serialized = serialize($this->schedule);      
    $stmt->bind_param("iissib", $org_id, $this->dateTime, $this->subject,$this->postText, $this->zipcode, $schedule_serialized );
    $result = $stmt->execute();

    echo "execution result ".$result."<br>";
    $inserted_id = $mysqli->insert_id;
    $stmt->close();

    $this->post_id = $inserted_id;

    }

All columns except schedule are inserted, I check if the insertion function receive the schedule correctly using var_dump($this->schedule) and it is correct. What do you think might be the problem?

Thank you

Answer 1

Please check out the mysqli documentation in reference to saving blob data and mysql config for max_allowed_packet. It's possible this could be your issue since I don't know how big your serialized data is:

php.net mysqli