[SOLVED] Build query with "values" part

Build query with "values" part

I have a long insert query which contains 10+ columns. I am looking for a compact way to build this query like:

$mysqli = new MySQLi(...);
$mysqli->query("insert into table");
$mysqli->addKeyValue("columnName1", "value1");
$mysqli->addKeyValue("columnName2", "value2");
$mysqli->addKeyValue("columnName"3, "value3");
$mysqli->execute();

As far as I know there is no way to do this with default MySQLi. Is there a library that provides similar functionality?

The reason I insist on trying to do something like this is I am trying to write code that doesn't exceeds 80-100 character limit per line to make my code more readable.

I know prepared statements and bind param.

Solution

I can offer you a library called SafeMysql which I wrote to make mysqli usable. With it the approach will be different:

include_once 'safemysql.class.php';
$db = new safeMysql();
$data = [
    "columnName1" => "value1",
    "columnName2" => "value2",
    "columnName3" => "value3",
];
$db->query("insert into table SET ?u", $data);

as you can see, in both cases the line size doesn't exceed even 40 characters.