ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / letaweb / admin / classes

<?php

/**
 * Export & import sql.
 *
 * @author davidhhuan
 */
class DLDatabaseHelper
{
    /**
     * Export the sql to a file.
     *
     * @author davidhhuan
     *
     * @param bool   $withData:  Whether to export the insert-data at the same time
     * @param bool   $dropTable: Add to drop the table or not
     * @param string $saveName:  the saved file name
     * @param string $savePath
     *
     * @return mixed
     */
    public static function export($withData = true, $dropTable = false, $saveName = null, $savePath = false)
    {
        $pdo = Yii::app()->db->pdoInstance;
        $mysql = '';
        $statments = $pdo->query('show tables');
        foreach ($statments as $value) {
            $tableName = $value[0];
            if ($dropTable === true) {
                $mysql .= "DROP TABLE IF EXISTS `$tableName`;\n";
            }
            $tableQuery = $pdo->query("show create table `$tableName`");
            $createSql = $tableQuery->fetch();
            $mysql .= $createSql['Create Table'].";\r\n\r\n";
            if ($withData != 0) {
                $itemsQuery = $pdo->query("select * from `$tableName`");
                $values = '';
                $items = '';
                while ($itemQuery = $itemsQuery->fetch(PDO::FETCH_ASSOC)) {
                    $itemNames = array_keys($itemQuery);
                    $itemNames = array_map('addslashes', $itemNames);
                    $items = implode('`,`', $itemNames);
                    $itemValues = array_values($itemQuery);
                    $itemValues = array_map('addslashes', $itemValues);
                    $valueString = implode("','", $itemValues);
                    $valueString = "('".$valueString."'),";
                    $values .= "\n".$valueString;
                }
                if ($values != '') {
                    $insertSql = "INSERT INTO `$tableName` (`$items`) VALUES".rtrim($values, ',').";\n\r";
                    $mysql .= $insertSql;
                }
            }
            //$mysql.="/*-----------------------------------------------------*/\n\r"; 
        }

ob_start();
        echo $mysql;
        $content = ob_get_contents();
        ob_end_clean();
        $content = gzencode($content, 9);

if (is_null($saveName)) {
            $saveName = date('YmdHms').'.sql.gz';
        }

if ($savePath === false) {
            //header("Content-Type: application/force-download");
            //header("Content-Type: application/octet-stream");
            //header("Content-Type: application/download");
            //header("Content-Description: Download SQL Export");  
            //header('Content-Disposition: attachment; filename='.$saveName);
            //echo $content;
            //die();
            $request = Yii::app()->getRequest();
            $request->sendFile($saveName, $content);
        } else {
            $filePath = $savePath ? $savePath.'/'.$saveName : $saveName;
            file_put_contents($filePath, $content);
            echo 'Database file saved: '.$saveName;
        }
    }

/**
     * import sql from a *.sql file.
     *
     * @author davidhhuan
     *
     * @param string $file: with the path and the file name
     *
     * @return mixed
     */
    public static function import($db, $file = '')
    {
        $pdo = $db->getPdoInstance();
        try {
            if (file_exists($file)) {
                $sqlStream = file_get_contents($file);
                $sqlStream = rtrim($sqlStream);
                $newStream = preg_replace_callback("/$(.*)$/", create_function('$matches', 'return str_replace(";"," $$$ ",$matches[0]);'), $sqlStream);
                $sqlArray = explode(';', $newStream);
                foreach ($sqlArray as $value) {
                    if (!empty($value)) {
                        $sql = str_replace(' $$$ ', ';', $value).';';
                        $pdo->exec($sql);
                    }
                }
                //echo "succeed to import the sql data!";
                return true;
            } else {
                throw new Exception('file doesn\'t exists');
            }
        } catch (PDOException $e) {
            echo $e->getMessage();
            exit;
        }
    }
}

[+] ..
[+] php-jwt
[-] Blowfish.php [edit]
[+] socialEmbed
[+] mailchimp
[+] swiftMailer
[-] CMS_Rewrite.php [edit]
[+] hosting
[-] general.php [edit]
[-] ScreenShot.php [edit]
[-] UrlManager.php [edit]
[+] payments
[-] Configuration.php [edit]
[+] twig-renderer-master
[-] Functions.php [edit]
[+] twig
[+] addons
[+] hoauth
[-] package.xml [edit]
[-] PController.php [edit]
[-] ETwigViewRenderer.php [edit]
[+] htmlpurifier
[-] Randomness.php [edit]
[-] CSSParser.php [edit]
[-] Mail.php [edit]
[-] Rijndael.php [edit]
[+] components
[+] rss
[-] WebApplication.php [edit]
[-] passwordhash.php [edit]
[-] DLDatabaseHelper.php [edit]
[+] Exceptions