upgrade_phpmyadmin.sh

# Copyright (C) 2013 - 2025 Teddysun <i@teddysun.com>
#
# This file is part of the LAMP script.
#
# LAMP is a powerful bash script for the installation of
# Apache + PHP + MySQL/MariaDB and so on.
# You can install Apache + PHP + MySQL/MariaDB in an very easy way.
# Just need to input numbers to choose what you want to install before installation.
# And all things will be done in a few minutes.
#
# Website:  https://lamp.sh
# Github:   https://github.com/teddysun/lamp

#upgrade phpmyadmin
upgrade_phpmyadmin() {

    if [ -d "${web_root_dir}/phpmyadmin" ]; then
        installed_pma="$(awk '/Version/{print $2}' ${web_root_dir}/phpmyadmin/README)"
    else
        if [ -s "$cur_dir/pmaversion.txt" ]; then
            installed_pma="$(awk '/phpmyadmin/{print $2}' ${cur_dir}/pmaversion.txt)"
        else
            echo -e "phpmyadmin\t0" >${cur_dir}/pmaversion.txt
            installed_pma="$(awk '/phpmyadmin/{print $2}' ${cur_dir}/pmaversion.txt)"
        fi
    fi

    if [ "${installed_pma}" != "0" ]; then
        major_ver="$(echo ${installed_pma} | cut -d. -f1-2)"
    else
        _error "phpMyAdmin installation directory not found, please check it and retry"
    fi
    latest_pma="$(curl -s https://www.phpmyadmin.net/files/ | awk -F\> '/\/files\//{print $3}' | grep "${major_ver}" | cut -d'<' -f1 | sort -V | tail -1)"
    [ -z "${latest_pma}" ] && latest_pma="$(curl -s ${download_root_url}/pmalist.txt | grep "${major_ver}" | tail -1 | awk -F- '{print $2}')"
    _info "Latest version of phpmyadmin   : $(_red ${latest_pma})"
    _info "Installed version of phpmyadmin: $(_red ${installed_pma})"
    read -p "Do you want to upgrade phpMyAdmin? (y/n) (Default: n):" upgrade_pma
    [ -z "${upgrade_pma}" ] && upgrade_pma="n"
    if [[ "${upgrade_pma}" = "y" || "${upgrade_pma}" = "Y" ]]; then
        _info "phpMyAdmin upgrade start..."
        if [ -d "${web_root_dir}/phpmyadmin" ]; then
            mv ${web_root_dir}/phpmyadmin/config.inc.php ${cur_dir}/config.inc.php
            rm -rf ${web_root_dir}/phpmyadmin
        else
            _error "phpMyAdmin installation directory not found..."
        fi
        [ ! -d "${cur_dir}/software" ] && mkdir -p ${cur_dir}/software
        cd ${cur_dir}/software
        if [ ! -s phpMyAdmin-${latest_pma}-all-languages.tar.gz ]; then
            latest_pma_link="https://files.phpmyadmin.net/phpMyAdmin/${latest_pma}/phpMyAdmin-${latest_pma}-all-languages.tar.gz"
            backup_pma_link="${download_root_url}/phpMyAdmin-${latest_pma}-all-languages.tar.gz"
            untar ${latest_pma_link} ${backup_pma_link}
            mkdir -p ${web_root_dir}/phpmyadmin
            mv * ${web_root_dir}/phpmyadmin
        else
            tar zxf phpMyAdmin-${latest_pma}-all-languages.tar.gz
            mv phpMyAdmin-${latest_pma}-all-languages ${web_root_dir}/phpmyadmin
        fi
        if [ -s ${cur_dir}/config.inc.php ]; then
            mv ${cur_dir}/config.inc.php ${web_root_dir}/phpmyadmin/config.inc.php
        else
            mv ${web_root_dir}/phpmyadmin/config.sample.inc.php ${web_root_dir}/phpmyadmin/config.inc.php
        fi
        mkdir -p ${web_root_dir}/phpmyadmin/{upload,save}
        if [ -s ${web_root_dir}/phpmyadmin/examples/create_tables.sql ]; then
            cp -f ${web_root_dir}/phpmyadmin/examples/create_tables.sql ${web_root_dir}/phpmyadmin/upload/
        elif [ -s ${web_root_dir}/phpmyadmin/sql/create_tables.sql ]; then
            cp -f ${web_root_dir}/phpmyadmin/sql/create_tables.sql ${web_root_dir}/phpmyadmin/upload/
        fi
        chown -R apache:apache ${web_root_dir}/phpmyadmin
        echo -e "phpmyadmin\t${latest_pma}" >${cur_dir}/pmaversion.txt
        _info "Clear up start..."
        cd ${cur_dir}/software
        rm -rf phpMyAdmin-${latest_pma}-all-languages/
        rm -f phpMyAdmin-${latest_pma}-all-languages.tar.gz
        _info "Clear up completed..."
        _info "phpMyAdmin upgrade completed..."
    else
        _info "phpMyAdmin upgrade cancelled, nothing to do..."
    fi

}