Developing a Simple CMS Application using GridlessBuilder.js 

Now we can perform a checking. If user is authorized for editing, we select data from pages table. If user is a visitor, we select data from pages_published table.

if($authorized){
    $sql = 'SELECT * FROM pages where filename=:filename'; 
    $s = $pdo->prepare($sql);
    $s->bindValue(':filename', $filename);
    $s->execute();
    if($row = $s->fetch()) {
        $id = $row['id'];
        $title = $row['title'];
        $description = $row['description'];
        $content = $row['content'];
        $css = $row['css'];
        $js = $row['js'];
    }
} else {
    $sql = 'SELECT * FROM pages_published WHERE filename=:filename AND archived=false'; 
    $s = $pdo->prepare($sql);
    $s->bindValue(':filename', $filename);	
    $s->execute();
    if($row = $s->fetch()) {
	$id = $row['pageid'];
        $title = $row['title'];
        $description = $row['description'];
        $content = $row['content'];
        $css = $row['css'];
        $js = $row['js'];
    } 
}

To publish a page, we modify a bit our GridlessBuilder.js initialization.

var obj = new GridlessBuilder({
    wrapper: '.is-wrapper', 
    onSave: function() {
        savePage();
    },
    onSaveAndFinish: function() {
        savePage(true); // publish=true        
    }
});

Here we use onSaveAndFinish event to do the publishing process. In the onSaveAndFinish function, we call our savePage() method, but this time we pass a true value to the function to indicate that it is for publishing.

We modify our savePage() method as follows:

function savePage(publish) {
        
    ui.showInfo('Saving..');

    var data = {};
    data.post_id = <?php echo $id; ?>;
    data.post_content = obj.html(); 
    data.post_styles = obj.styles();
    data.post_js = obj.js();
    
    if(publish) data.post_publish = 1; // publish
    else data.post_publish = 0; // save draft

    ... 
}

The savePage method now has a publish parameter. If publish is true, data.post_publish value is set 1. This will tell our server side code to not just saving the content, but also inserting a new record into our pages_published table.

Here is our PHP code for publishing the page:

// Archive current online version
$sql = 'UPDATE pages_published SET archived=true WHERE pageid=:pageid';	
$s = $pdo->prepare($sql);
$s->bindValue(':pageid', $id);
$s->execute(); 			

// Insert new online version
$sql = 'INSERT INTO pages_published (pageid,filename,title,description,content,css,js,archived,dateupdated) 
VALUES (:pageid,:filename,:title,:description,:content,:css,:js,false,:dateupdated)';	
$s = $pdo->prepare($sql);
$s->bindValue(':pageid', $id);
$s->bindValue(':filename', $filename);
$s->bindValue(':title', $title);
$s->bindValue(':description', $description);
$s->bindValue(':content', $content);
$s->bindValue(':css', $css);
$s->bindValue(':js', $js);
$s->bindValue(':dateupdated', $dateupdated->format('Y-m-d H:i:s'));
$s->execute();