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
Post a Comment