Component

Module

Button & Link Type

Customize button text and type. Make sure you have added 'Option' module, cause included data from 'Option' module.

Directory

File Folder Link
form.php \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\app\views\price_package
style.css \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\admin\themes\black_and_white
backend.js \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\admin\javascript
PricePackageController.php \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\app\controllers

 

Step 1

Update: form.php (or your create.php and view.php)
Insert this inside your <form>

<?php $btn_show = (!empty($postdata['btn_status']) ? $postdata['btn_status'] : (!empty($price_package->btn_status) ? $price_package->btn_status : '0')); $redirect_show = (!empty($postdata['redirect_status']) ? $postdata['redirect_status'] : (!empty($portfolio->redirect_status) ? $portfolio->redirect_status : '0')); ?> <h3><?php echo __('Button'); ?></h3> <div id="meta-pages" class="switch_container"> <label class="switch"> <input type="checkbox" class="status_switch toggle_btn_section" name="price_package[btn_status]" <?php echo $btn_show == 1 ? 'checked' : ''; ?> value="1"> <span class="switch_slider round"></span> </label> <label class="switch_label"><?php echo $btn_show == 1 ? 'Show' : 'Hidden'; ?><label> </div> <div id="btn_section"> <div> <label>Button Caption:</label><br> <input class="textbox" name="price_package[btn_caption]" size="40" type="text" placeholder="Example: Learn More, Contact Us..." value="<?php echo(!empty($postdata['btn_caption']) ? $postdata['btn_caption'] : (!empty($price_package->btn_caption) ? $price_package->btn_caption : '')) ?>" /> </div> <div> <label>Button Type:</label><br> <select id="btn_type" class="textbox" name="price_package[btn_type]"> <?php $link_types = Option::findByCategory('link_type'); ?> <option></option> <?php foreach($link_types as $link_type): ?> <option value="<?php echo $link_type->code; ?>" <?php echo ($postdata['btn_type'] == $link_type->code ? 'selected' : (!empty($price_package) && $price_package->btn_type == $link_type->code ? 'selected' : '')) ;?>><?php echo $link_type->name; ?></option> <?php endforeach; ?> </select> </div> <div id="external_link"> <label>Link To:</label><br> <input class="textbox" name="price_package[btn_external_link]" size="40" type="text" placeholder="External Webiste" value="<?php echo(!empty($postdata['btn_external_link']) ? $postdata['btn_external_link'] : (!empty($price_package->btn_external_link) ? $price_package->btn_external_link : '')) ?>" /> </div> <?php $btn_page_id = (!empty($postdata) && !empty($postdata['btn_page_id']) ? $postdata['btn_page_id'] : (!empty($price_package) && !empty($price_package->btn_page_id) ? $price_package->btn_page_id : '')); ?> <div id="assign_to_page"> <label>Assign To Page :</label><br> <select id="page_id" name="price_package[btn_page_id]"> <option value=""></option> <?php foreach($pages as $page){ $page_selected = ($page->id==$btn_page_id?"selected":""); if($page->id!=1){ if($page->hasChildren($page->id)){ echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>"; $subpages = $page->childrenOf($page->id); foreach($subpages as $subpage){ $subpage_selected = ($subpage->id==$btn_page_id?"selected":""); echo "<option value='".$subpage->id."' ".$subpage_selected."> - - ".$subpage->title."</option>"; $subpages2 = $subpage->childrenOf($subpage->id); foreach($subpages2 as $subpage2){ $subpage2_selected = ($subpage2->id==$btn_page_id?"selected":""); echo "<option value='".$subpage2->id."' ".$subpage2_selected."> - - - - ".$subpage2->title."</option>"; $subpages3 = $subpage2->childrenOf($subpage2->id); foreach($subpages3 as $subpage3){ $subpage3_selected = ($subpage3->id==$btn_page_id?"selected":""); echo "<option value='".$subpage3->id."' ".$subpage3_selected."> - - - - - - ".$subpage3->title."</option>"; } } } }else{ echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>"; } }else{ echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>"; } } ?> </select> </div> <div id="redirect_status"> <div id="meta-pages" class="switch_container"> <label class="switch"> <input type="checkbox" name="portfolio[redirect_status]" <?php echo $redirect_show == 1 ? 'checked' : ''; ?> value="1"> <span class="switch_slider round"></span> </label> <label class="switch_label">Open New Tab<label> </div> </div> </div> <br>
    <?php
    $btn_show = (!empty($postdata['btn_status']) ? $postdata['btn_status'] : (!empty($price_package->btn_status) ? $price_package->btn_status : '0'));
    $redirect_show = (!empty($postdata['redirect_status']) ? $postdata['redirect_status'] : (!empty($portfolio->redirect_status) ? $portfolio->redirect_status : '0'));
	?>
    <h3><?php echo __('Button'); ?></h3>
	<div id="meta-pages" class="switch_container">
		<label class="switch">
			<input type="checkbox" class="status_switch toggle_btn_section" name="price_package[btn_status]" <?php echo $btn_show == 1 ? 'checked' : ''; ?> value="1">
			<span class="switch_slider round"></span>
		</label>
		<label class="switch_label"><?php echo $btn_show == 1 ? 'Show' : 'Hidden'; ?><label>
	</div>

    <div id="btn_section">
        <div>
            <label>Button Caption:</label><br>
            <input class="textbox" name="price_package[btn_caption]" size="40" type="text" placeholder="Example: Learn More, Contact Us..." value="<?php echo(!empty($postdata['btn_caption']) ? $postdata['btn_caption'] : (!empty($price_package->btn_caption) ? $price_package->btn_caption : '')) ?>" />
        </div>
        <div>
            <label>Button Type:</label><br>
            <select id="btn_type" class="textbox" name="price_package[btn_type]">
                <?php $link_types = Option::findByCategory('link_type'); ?>
                <option></option>
                <?php foreach($link_types as $link_type): ?>
                <option value="<?php echo $link_type->code; ?>" <?php echo ($postdata['btn_type'] == $link_type->code ? 'selected' : (!empty($price_package) && $price_package->btn_type == $link_type->code ? 'selected' : '')) ;?>><?php echo $link_type->name; ?></option>
                <?php endforeach; ?>
            </select>
        </div>
        <div id="external_link">
            <label>Link To:</label><br>
            <input class="textbox" name="price_package[btn_external_link]" size="40" type="text" placeholder="External Webiste" value="<?php echo(!empty($postdata['btn_external_link']) ? $postdata['btn_external_link'] : (!empty($price_package->btn_external_link) ? $price_package->btn_external_link : '')) ?>" />
        </div>
        <?php
            $btn_page_id = (!empty($postdata) && !empty($postdata['btn_page_id']) ? $postdata['btn_page_id'] : (!empty($price_package) && !empty($price_package->btn_page_id) ? $price_package->btn_page_id : ''));
        ?>
        <div id="assign_to_page">
            <label>Assign To Page :</label><br>
            <select id="page_id"  name="price_package[btn_page_id]">
            <option value=""></option>
            <?php
            foreach($pages as $page){
                $page_selected = ($page->id==$btn_page_id?"selected":"");

                if($page->id!=1){
                    if($page->hasChildren($page->id)){
                        echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
                        $subpages = $page->childrenOf($page->id);
                        foreach($subpages as $subpage){
                            $subpage_selected = ($subpage->id==$btn_page_id?"selected":"");
                            echo "<option value='".$subpage->id."' ".$subpage_selected."> - - ".$subpage->title."</option>";
                            
                            $subpages2 = $subpage->childrenOf($subpage->id);
                            foreach($subpages2 as $subpage2){
                                $subpage2_selected = ($subpage2->id==$btn_page_id?"selected":"");
                                echo "<option value='".$subpage2->id."' ".$subpage2_selected."> - - - - ".$subpage2->title."</option>";

                                $subpages3 = $subpage2->childrenOf($subpage2->id);
                                foreach($subpages3 as $subpage3){
                                    $subpage3_selected = ($subpage3->id==$btn_page_id?"selected":"");
                                    echo "<option value='".$subpage3->id."' ".$subpage3_selected."> - - - - - - ".$subpage3->title."</option>";
                                }
                            }
                        }
                    }else{
                        echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
                    }
                }else{
                    echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
                }
            }
            ?>
            </select>
        </div>
        <div id="redirect_status">
            <div id="meta-pages" class="switch_container">
                <label class="switch">
                    <input type="checkbox" name="portfolio[redirect_status]" <?php echo $redirect_show == 1 ? 'checked' : ''; ?> value="1">
                    <span class="switch_slider round"></span>
                </label>
                <label class="switch_label">Open New Tab<label>
            </div>
        </div>
    </div>
    <br>

Step 2

Update: style.css

.display_flex { display: flex; align-items: center; margin: 0.5rem 0; } /* Button & Link Type */ #btn_section > div { margin: 0.5rem 0; }
.display_flex {
  display: flex;
  align-items: center;
  margin: 0.5rem 0;
}

/* Button & Link Type */
#btn_section > div {
  margin: 0.5rem 0;
}

Step 3

Update: backend.js

// For Button Link $(document).ready(function() { function toggle_btn_section() { if($("input.toggle_btn_section").is(":checked")) { $("#btn_section").slideDown(); } else { $("#btn_section").slideUp(); } } $("input.toggle_btn_section").click(function () { toggle_btn_section(); }) toggle_btn_section(); function toggleButtonType() { if ($("#btn_type").val() == "external_link") { $("#external_link").slideDown(); $("#assign_to_page").slideUp(); if ($("#external_link input").val() !== "") { $("#redirect_status").slideDown(); } else { $("#redirect_status").slideUp(); } } else if ($("#btn_type").val() == "assign_to_page") { $("#assign_to_page").slideDown(); $("#external_link").slideUp(); if ($("#assign_to_page select").val() !== "") { $("#redirect_status").slideDown(); } else { $("#redirect_status").slideUp(); } } else { $("#external_link, #assign_to_page, #redirect_status").slideUp(); } } toggleButtonType(); $(document).on("change", "#btn_type", function() { toggleButtonType(); }) $(document).on("keyup", "#external_link input", function() { toggleButtonType(); }) $(document).on("change", "#assign_to_page select", function() { toggleButtonType(); }) })
// For Button Link
$(document).ready(function() {
    function toggle_btn_section() {
        if($("input.toggle_btn_section").is(":checked")) {
            $("#btn_section").slideDown();
        } else {
            $("#btn_section").slideUp();
        }
    }

    $("input.toggle_btn_section").click(function () {
        toggle_btn_section();
    })
        
    toggle_btn_section();

    function toggleButtonType() {
        if ($("#btn_type").val() == "external_link") {
            $("#external_link").slideDown();
            $("#assign_to_page").slideUp();
            if ($("#external_link input").val() !== "") {
                $("#redirect_status").slideDown();
            } else {
                $("#redirect_status").slideUp();
            }
        } else if ($("#btn_type").val() == "assign_to_page") {
            $("#assign_to_page").slideDown();
            $("#external_link").slideUp();
            if ($("#assign_to_page select").val() !== "") {
                $("#redirect_status").slideDown();
            } else {
                $("#redirect_status").slideUp();
            }
        } else {
            $("#external_link, #assign_to_page, #redirect_status").slideUp();
        }
    }

    toggleButtonType();

    $(document).on("change", "#btn_type", function() {
        toggleButtonType();
    })

    $(document).on("keyup", "#external_link input", function() {
        toggleButtonType();
    })

    $(document).on("change", "#assign_to_page select", function() {
        toggleButtonType();
    })
})

Step 4

Update: PricepackageController.php
Add verification in _add() & _edit() function

<?php class PricePackageController extends Controller { private function _addpricepackage(){ if($_POST["action"]=="add"){ $data = $_POST['price_package']; Flash::set('postdata', $data); // verification if (empty($data['name'])){ Flash::set('error', __('You have to specify Package Name.')); redirect(get_url('price_package/addpricepackage')); } // if (empty($data['description'])){ // Flash::set('error', __('You have to specify Description.')); // redirect(get_url('price_package/addpricepackage')); // } if (empty($data['free_trial_status'])){ $data['free_trial_status'] = 0; } if (empty($data['contract_status'])){ $data['contract_status'] = 0; } if (empty($data['btn_status'])){ $data['btn_status'] = 0; } else { if (empty($data['btn_caption'])){ Flash::set('error', __('You have to specify Button Caption.')); redirect(get_url('price_package/addpricepackage')); } if (empty($data['btn_type'])){ Flash::set('error', __('You have to specify Button Type.')); redirect(get_url('price_package/addpricepackage')); } else { if ($data['btn_type'] == 'external_link') { if (empty($data['btn_external_link'])){ Flash::set('error', __('You have to specify External Link.')); redirect(get_url('price_package/addpricepackage')); } else { if (empty($data['redirect_status'])) { $data['redirect_status'] = 0; } } } if ($data['btn_type'] == 'assign_to_page') { if (empty($data['btn_page_id'])){ Flash::set('error', __('You have to Assign a page for Button.')); redirect(get_url('price_package/addpricepackage')); } else { if (empty($data['redirect_status'])) { $data['redirect_status'] = 0; } } } } } if (empty($data['status'])){ $data['status'] = 0; } // if (empty($data['plan_policies'])){ // Flash::set('error', __('You have to specify Plan Policies.')); // redirect(get_url('price_package/addpricepackage')); // } $price_package = new PricePackage($data); $price_package->created_by_id = AuthUser::getId(); $price_package->created_on = date('Y-m-d H:i:s'); if (!$price_package->save()) { Flash::set('error', __('Price Package could not be added!')); redirect(get_url('price_package/')); } else { $price_package_id = $price_package->lastInsertId(); $overwrite = true; $failed = []; // Upload 1 type image (Add more field inside $fields if you have another image) // Make sure fields name match database name $fields = ['package_icon']; foreach ($fields as $field) { $failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package_id, $price_package->$field); } // Create A New Record In 'package_payment' $payment_data = []; $package_payment = new PackagePayment($payment_data); $package_payment->package_id = $price_package_id; if (!$package_payment->save()) { Flash::set('error', __('Package Payment could not be added!')); }else if (!empty(array_filter($failed))) { Flash::set('error', __('Failed to upload: ' . implode(', ', $failed))); } else { Flash::set('success', __('Price Package has been added.')); } if (isset($_POST['commit'])) { Flash::set('postdata', null); redirect(get_url('price_package')); } else { Flash::set('postdata', null); redirect(get_url('price_package/editpricepackage/'.$price_package_id)); }; } redirect(get_url('price_package')); } } private function _editpricepackage($id){ use_helper('Validate'); $data = $_POST['price_package']; Flash::set('postdata', $data); $price_package = PricePackage::findById($id); if (!$price_package) { Flash::set('error', __('Price Package could not be found!')); redirect(get_url('price_package')); } // verification if (empty($data['name'])){ Flash::set('error', __('You have to specify Package Name.')); redirect(get_url('price_package/editpricepackage/'.$id)); } // if (empty($data['description'])){ // Flash::set('error', __('You have to specify Description.')); // redirect(get_url('price_package/editpricepackage/'.$id)); // } if (empty($data['free_trial_status'])){ $data['free_trial_status'] = 0; } if (empty($data['contract_status'])){ $data['contract_status'] = 0; } if (empty($data['btn_status'])){ $data['btn_status'] = 0; } else { if (empty($data['btn_caption'])){ Flash::set('error', __('You have to specify Button Caption.')); redirect(get_url('price_package/editpricepackage/'.$id)); } if (empty($data['btn_type'])){ Flash::set('error', __('You have to specify Button Type.')); redirect(get_url('price_package/editpricepackage/'.$id)); } else { if ($data['btn_type'] == 'external_link') { if (empty($data['btn_external_link'])){ Flash::set('error', __('You have to specify External Link.')); redirect(get_url('price_package/editpricepackage/'.$id)); } else { if (empty($data['redirect_status'])) { $data['redirect_status'] = 0; } } } if ($data['btn_type'] == 'assign_to_page') { if (empty($data['btn_page_id'])){ Flash::set('error', __('You have to Assign a page for Button.')); redirect(get_url('price_package/editpricepackage/'.$id)); } else { if (empty($data['redirect_status'])) { $data['redirect_status'] = 0; } } } } } if (empty($data['status'])){ $data['status'] = 0; } // if (empty($data['plan_policies'])){ // Flash::set('error', __('You have to specify Plan Policies.')); // redirect(get_url('price_package/editpricepackage/'.$id)); // } $price_package->setFromData($data); $price_package->updated_by_id = AuthUser::getId(); $price_package->updated_on = date('Y-m-d H:i:s'); if ($price_package->save()) { $overwrite = true; $failed = []; // Upload 1 type image (Add more field inside $fields if you have another image) // Make sure fields name match database name $fields = ['package_icon']; foreach ($fields as $field) { $failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package->id, $price_package->$field); } if (!empty(array_filter($failed))) { Flash::set('error', __('Failed to update: ' . implode(', ', $failed))); } else { Flash::set('success', __('Price Package has been updated.')); } } else { Flash::set('error', __('Price Package could not be saved.')); } if (isset($_POST['commit'])) redirect(get_url('price_package')); else { Flash::set('postdata', null); redirect(get_url('price_package/editpricepackage/'.$id)); } } } ?>
<?php

class PricePackageController extends Controller {
	private function _addpricepackage(){
		if($_POST["action"]=="add"){
			$data = $_POST['price_package'];
			Flash::set('postdata', $data);

			// verification
			if (empty($data['name'])){
				Flash::set('error', __('You have to specify Package Name.'));
				redirect(get_url('price_package/addpricepackage'));
			}

			// if (empty($data['description'])){
			// 	Flash::set('error', __('You have to specify Description.'));
			// 	redirect(get_url('price_package/addpricepackage'));
			// }

            if (empty($data['free_trial_status'])){
                $data['free_trial_status'] = 0;
            }
            
            if (empty($data['contract_status'])){
                $data['contract_status'] = 0;
            }

            if (empty($data['btn_status'])){
                $data['btn_status'] = 0;
            } else {
                if (empty($data['btn_caption'])){
                    Flash::set('error', __('You have to specify Button Caption.'));
                    redirect(get_url('price_package/addpricepackage'));
                }

                if (empty($data['btn_type'])){
                    Flash::set('error', __('You have to specify Button Type.'));
                    redirect(get_url('price_package/addpricepackage'));
                } else {
                    if ($data['btn_type'] == 'external_link') {
                        if (empty($data['btn_external_link'])){
                            Flash::set('error', __('You have to specify External Link.'));
                            redirect(get_url('price_package/addpricepackage'));
                        } else {
                            if (empty($data['redirect_status'])) {
                                $data['redirect_status'] = 0;
                            }
                        }
                    }

                    if ($data['btn_type'] == 'assign_to_page') {
                        if (empty($data['btn_page_id'])){
                            Flash::set('error', __('You have to Assign a page for Button.'));
                            redirect(get_url('price_package/addpricepackage'));
                        } else {
                            if (empty($data['redirect_status'])) {
                                $data['redirect_status'] = 0;
                            }
                        }
                    }
                }
            }

			if (empty($data['status'])){
                $data['status'] = 0;
			}
            
            // if (empty($data['plan_policies'])){
            //     Flash::set('error', __('You have to specify Plan Policies.'));
			// 	redirect(get_url('price_package/addpricepackage'));
			// }
			
			$price_package = new PricePackage($data);	

			$price_package->created_by_id = AuthUser::getId();
			$price_package->created_on = date('Y-m-d H:i:s');
			if (!$price_package->save()) {
				Flash::set('error', __('Price Package could not be added!'));
				redirect(get_url('price_package/'));
			} else {
                $price_package_id = $price_package->lastInsertId();
                $overwrite = true;
                $failed = [];

                // Upload 1 type image (Add more field inside $fields if you have another image)
                // Make sure fields name match database name 
                $fields = ['package_icon'];

                foreach ($fields as $field) {
                    $failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package_id, $price_package->$field);
                }
                
                // Create A New Record In 'package_payment'
                $payment_data = [];
                $package_payment = new PackagePayment($payment_data);
                $package_payment->package_id = $price_package_id;
                if (!$package_payment->save()) {
                    Flash::set('error', __('Package Payment could not be added!'));
                }else if (!empty(array_filter($failed))) {
                    Flash::set('error', __('Failed to upload: ' . implode(', ', $failed)));
                } else {
                    Flash::set('success', __('Price Package has been added.'));
                }

				if (isset($_POST['commit'])) {
					Flash::set('postdata', null);
					redirect(get_url('price_package'));
				} else {
					Flash::set('postdata', null);
					redirect(get_url('price_package/editpricepackage/'.$price_package_id));
				};
			}
		redirect(get_url('price_package'));
		}
	}

    private function _editpricepackage($id){
        use_helper('Validate');
        $data = $_POST['price_package'];
        Flash::set('postdata', $data);
        $price_package = PricePackage::findById($id);
        
        if (!$price_package) {
            Flash::set('error', __('Price Package could not be found!'));
            redirect(get_url('price_package'));
        }

        // verification
        if (empty($data['name'])){
            Flash::set('error', __('You have to specify Package Name.'));
            redirect(get_url('price_package/editpricepackage/'.$id));
        }

        // if (empty($data['description'])){
        //     Flash::set('error', __('You have to specify Description.'));
        //     redirect(get_url('price_package/editpricepackage/'.$id));
        // }

        if (empty($data['free_trial_status'])){
            $data['free_trial_status'] = 0;
        }
        
        if (empty($data['contract_status'])){
            $data['contract_status'] = 0;
        }

        if (empty($data['btn_status'])){
            $data['btn_status'] = 0;
        } else {
            if (empty($data['btn_caption'])){
                Flash::set('error', __('You have to specify Button Caption.'));
                redirect(get_url('price_package/editpricepackage/'.$id));
            }

            if (empty($data['btn_type'])){
                Flash::set('error', __('You have to specify Button Type.'));
                redirect(get_url('price_package/editpricepackage/'.$id));
            } else {
                if ($data['btn_type'] == 'external_link') {
                    if (empty($data['btn_external_link'])){
                        Flash::set('error', __('You have to specify External Link.'));
                        redirect(get_url('price_package/editpricepackage/'.$id));
                    } else {
                        if (empty($data['redirect_status'])) {
                            $data['redirect_status'] = 0;
                        }
                    }
                }

                if ($data['btn_type'] == 'assign_to_page') {
                    if (empty($data['btn_page_id'])){
                        Flash::set('error', __('You have to Assign a page for Button.'));
                        redirect(get_url('price_package/editpricepackage/'.$id));
                    } else {
                        if (empty($data['redirect_status'])) {
                            $data['redirect_status'] = 0;
                        }
                    }
                }
            }
        }
        
        if (empty($data['status'])){
            $data['status'] = 0;
        }
        
        // if (empty($data['plan_policies'])){
        //     Flash::set('error', __('You have to specify Plan Policies.'));
        //     redirect(get_url('price_package/editpricepackage/'.$id));
        // }
        
        $price_package->setFromData($data);

        $price_package->updated_by_id = AuthUser::getId();
        $price_package->updated_on = date('Y-m-d H:i:s');
        if ($price_package->save()) {
            $overwrite = true;
			$failed = [];

			// Upload 1 type image (Add more field inside $fields if you have another image)
            // Make sure fields name match database name 
            $fields = ['package_icon'];

			foreach ($fields as $field) {
				$failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package->id, $price_package->$field);
			}

            if (!empty(array_filter($failed))) {
                Flash::set('error', __('Failed to update: ' . implode(', ', $failed)));
            } else {
                Flash::set('success', __('Price Package has been updated.'));
            }
        }
        else {
            Flash::set('error', __('Price Package could not be saved.'));
        }

        if (isset($_POST['commit']))
            redirect(get_url('price_package'));
        else {
            Flash::set('postdata', null);
            redirect(get_url('price_package/editpricepackage/'.$id));
        }
    }
}
?>

Step 5

Add these 6 columns in myPhpAdmin:

ALTER TABLE `your_table_name` ADD COLUMN `btn_status` INT(1) NULL DEFAULT '0', ADD COLUMN `btn_caption` VARCHAR(100) DEFAULT NULL, ADD COLUMN `btn_type` VARCHAR(100) DEFAULT NULL, ADD COLUMN `btn_external_link` VARCHAR(100) DEFAULT NULL, ADD COLUMN `btn_page_id` INT(11) DEFAULT NULL, ADD COLUMN `redirect_status` INT(1) NULL DEFAULT '0';
ALTER TABLE `your_table_name`
  ADD COLUMN `btn_status` INT(1) NULL DEFAULT '0',
  ADD COLUMN `btn_caption` VARCHAR(100) DEFAULT NULL,
  ADD COLUMN `btn_type` VARCHAR(100) DEFAULT NULL,
  ADD COLUMN `btn_external_link` VARCHAR(100) DEFAULT NULL,
  ADD COLUMN `btn_page_id` INT(11) DEFAULT NULL,
  ADD COLUMN `redirect_status` INT(1) NULL DEFAULT '0';
Code Copied To Clipboard!