php - 序列化后的字符串未插入数据库

Question

我有一个数组，我使用serialize函数将这个数组转换成字符串。然后我尝试插入数据库。但这不是插入到数据库中。

我试过的是:

$con = mysqli_connect("localhost", "root", "", "db_sample");
$text = array("PHP", "Java", "HTTML", "CSS");
$text = serialize($text);
//echo gettype($text); //gives type as string

mysqli_query($con, "INSERT INTO tbl_image(title) VALUES($text)");//not working

//mysqli_query($con, "INSERT INTO tbl_image(title) VALUES(".$text.")");//not working

//mysqli_query($con, "INSERT INTO tbl_image(title) VALUES('abc')"); //working 

mysqli_close($con);

表结构:

表名:tbl_image

id    int   AutoIncrement
title text

我怎样才能让它工作？

Answer 1

尝试在 sql 查询中添加引号:

mysqli_query($con, "INSERT INTO tbl_image(title) VALUES('".mysqli_real_escape_string($con, $text)."')");