php - string after serialize is not inserted into the database -


i have array, convert array string using serialize function. tried insert database. not inserting database.

what tried is:

$con = mysqli_connect("localhost", "root", "", "db_sample"); $text = array("php", "java", "httml", "css"); $text = serialize($text); //echo gettype($text); //gives type string  mysqli_query($con, "insert tbl_image(title) values($text)");//not working  //mysqli_query($con, "insert tbl_image(title) values(".$text.")");//not working  //mysqli_query($con, "insert tbl_image(title) values('abc')"); //working   mysqli_close($con); 

table structure:

table name: tbl_image

id    int   autoincrement title text 

how can make working??

try add quotes sql query:

mysqli_query($con, "insert tbl_image(title) values('".mysqli_real_escape_string($con, $text)."')"); 

Comments