andela-joyebanji / PotatoORM

    {

        $bindNameParameters = [];

        $sqlUpdate = 'UPDATE '.$this->getTableName().' SET ';

        foreach ($this->properties as $columnName => $columnValue) {

            if ($columnName == 'id') {

                continue;

            }

            $bindColumnName = ':'.$columnName;

            $sqlUpdate .= "$columnName = $bindColumnName,";

            $bindNameParameters[$bindColumnName] = $columnValue;

        }

        //Remove the last comma in sql command then join it to the other query part.

        $columnValues = '';

        $bindNameParameters = [];

        $sqlCreate = 'INSERT'.' INTO '.$this->getTableName().' (';

        foreach ($this->properties as $columnName => $columnValue) {

            $bindColumnName = ':'.$columnName;

            $columnNames .= $columnName.',';

            $columnValues .= $bindColumnName.',';

            $bindNameParameters[$bindColumnName] = $columnValue;

        }

        // Remove ending comma and whitespace.

        $columnNames = substr($columnNames, 0, -1);

        $columnValues = substr($columnValues, 0, -1);