src/FelixOnline/Base/BaseDB.php
public function constructInsertSQL($fields)
    {
        $sql = array();

        $sql[] = "INSERT INTO";
        $sql[] = "`" . $this->dbtable . "`";
        $sql[] = "(";

        $columns = array();
        foreach ($fields as $key => $value) {
            $columns[] = "`" . $key . "`";
        }

        $sql[] = implode(", ", $columns);

        $sql[] = ") VALUES (";

        $values = [];
        foreach ($fields as $key => $value) {
            $values[] = $value->getSQL();
        }

        $sql[] = implode(", ", $values);
        $sql[] = ")";

        return implode(" ", $sql);
    }
public function constructInsertSQL($fields)
    {
        $sql = array();

        $sql[] = "INSERT INTO";
        $sql[] = "`" . $this->dbtable . "`";
        $sql[] = "(";

        $columns = array();
        foreach ($fields as $key => $value) {
            $columns[] = "`" . $key . "`";
        }

        $sql[] = implode(", ", $columns);

        $sql[] = ") VALUES (";

        $values = [];
        foreach ($fields as $key => $value) {
            $values[] = $value->getSQL();
        }

        $sql[] = implode(", ", $values);
        $sql[] = ")";

        return implode(" ", $sql);
    }
public function constructInsertSQL ( $ fields ) { $ sql = array ( ) ; $ sql [ ] = "INSERT INTO" ; $ sql [ ] = "`" . $ this -> dbtable . "`" ; $ sql [ ] = "(" ; $ columns = array ( ) ; foreach ( $ fields as $ key => $ value ) { $ columns [ ] = "`" . $ key . "`" ; } $ sql [ ] = implode ( ", " , $ columns ) ; $ sql [ ] = ") VALUES (" ; $ values = [ ] ; foreach ( $ fields as $ key => $ value ) { $ values [ ] = $ value -> getSQL ( ) ; } $ sql [ ] = implode ( ", " , $ values ) ; $ sql [ ] = ")" ; return implode ( " " , $ sql ) ; }
Public: Construct SQL
Public : Construct SQL