i want insert data mysql table through user defined variables. here doing. gives no error don't upload data table.
$sql="insert table(".$columns_name.") values(".$val.")";
here how the values of variables are:
$columns_name= col1, col2, col3, col4
$val= aa, 11, 22, bb
possible issues:
1- table reserved word. table name can't 'table'. (i assume wrote mock name).
2- format of column names , values in insert query wrong.
try before query:
$columns_name = "`$columns_name`"; $columns_name = str_replace(', ', '`, `',$columns_name); $val = "'$val'"; $val = str_replace(', ', "', '",$val);
Comments
Post a Comment