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.

        $sqlUpdate = substr($sqlUpdate, 0, -1)." WHERE id = :id";

        $sqlStatement = $this->databaseConnection->prepare($sqlUpdate);

        $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);