$query_col .= " `" . $key . "` ,";
$query_val .= " '\".\$_POST[\"" . $value . "\"].\"' ,";
}
$query_col = rtrim($query_col, ",");
$query_val = rtrim($query_val, ",");
return $query . "( " . $query_col . " ) values (" . $query_val . ");\"";
}
public function gen_insert_code($query)
{
$code = "<?php\n";
$code .= "\t\$query\t=\t{$query};\n";
$code .= "\t\$result\t=\t\$conn->query(\$query);\n";
$code .= "\tif(\$result === true)\n";
$code .= "\t{\n";
$code .= "\t\techo 'Record saved';\n";
$code .= "\t}\n";
$code .= "\telse\n";
$code .= "\t{\n";
$code .= "\t\techo 'Record Not saved';\n";
$code .= "\t}\n";
return $code . "?>";
}
}
$Insert = new Insert();
$table_name = 'users';
$col_val_arr = array("name" => "name", "age" => "age", "test" => "test");
$query = $Insert->gen_insert_query($table_name, $col_val_arr);
file_put_contents("test.php", $Insert->gen_insert_code($query));
?>
