Exporting SQL Tables with PHP

try this

$result = $db_con->query('SELECT * FROM `some_table`');
$fp = fopen('php://output', 'w');
if ($fp && $result) {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="export.csv"');
    while ($row = $result->fetch_array(MYSQLI_NUM)) {
        fputcsv($fp, array_values($row));
    }
    die;
}

Alright, so here is the result I came up with. After using the direction of help from @Pankaj Kaityar's response. I was able to do some more research find a snippet of code that let me make up a function to download a copy of my databases, or save it to the server by the press of one or the other button.

The code is simplified as much as I could, and I'm sure there are other people who could improve this. But this works for me. Anyone else feel free to use it.

//HTML Buttons
<a href="pagename?perform_new_backup=download">Perform Server Backup</a>
<a href="pagename?perform_new_backup=server">Perform Download Backup</a>

//PHP Code
$db_array = array();
$directory_ctr = 0;
$dir_name_backup_new = "site_files/backups/";
if(isset($_GET['perform_new_backup'])) {
    include('function_db_export.php');
    $site_connection = mysqli_connect("$db_host", "$db_user_dec", "$db_password_dec", "$db_name_dec") or die("Error Connecting: $DB_ERROR | " . mysqli_error($site_connection));
        echo 'Connected... ' . mysqli_get_host_info($site_connection) . "<br />";
    if(!$site_connection) {
        echo "Error 12: Unable to connect to MySQL." . PHP_EOL;
        echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
        echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    } else {
        $SHOW_TABLES=$site_connection->query("SHOW TABLES FROM $db_name_dec") or die("Error 13: " . mysqli_error($site_connection));
        $SHOW_TABLES_total = $SHOW_TABLES->num_rows;
        if($SHOW_TABLES_total != 0) {
            while($row2=mysqli_fetch_assoc($SHOW_TABLES)) {
                if(!is_dir($dir_name_backup_new)) {
                    echo "'$dir_name_backup_new' directory does not exist. <br />";
                    echo "Attempting To Create Directroy ... <br />";
                    mkdir("$dir_name_backup_new");
                    if(is_dir($dir_name_backup_new)) {
                        echo "Success Making Directory! <br />";
                    } else {
                        echo "Failed To Make Directory! <br />";
                        $directory_ctr++;
                    }
                }

                if($directory_ctr == 0) {
                    foreach($row2 as $key=>$table_name) {
                        array_push($db_array,"$table_name");
                        echo "Found '<u>$table_name</u>' Table... Attempting Backup... <br />";
                    }
                } else {
                    echo "Error: Directories Not Created. <br />";
                }
            }//END WHILE
            //echo print_r($db_array); //Testing Purposes
            $new_file_name = $db_name_dec.'-db-backup-'.$current_date_stamp.'.sql';
            if($_GET['perform_new_backup'] == "server") {
                $save_setting = $save_location=false;
            } elseif($_GET['perform_new_backup'] == "download") {
                $save_setting = $dir_name_backup_new;
            } else {
                $save_setting = $dir_name_backup_new;
            }
            $cur_page = "$select_variable?id=$website_id";
            Export_Database($db_host, $db_user_dec, $db_password_dec, $db_name_dec, $save_setting, $table_name = $db_array, $new_file_name, $cur_page);
        } //END IF
    }
}

//FUNCTION FILE (function_db_export.php)
function Export_Database($host,$user,$pass,$name,$save_location=false,  $tables=false, $backup_name=false, $current_page ) {
    global $web_output;
    $new_conn = new mysqli($host,$user,$pass,$name);
    $new_conn->select_db($name);
    $new_conn->query("SET NAMES 'utf8'");

    $queryTables = $new_conn->query('SHOW TABLES');
    while($row = $queryTables->fetch_row()) {
        $target_tables[] = $row[0];
    }

    if($tables !== false)  { $target_tables = array_intersect( $target_tables, $tables); }

    foreach($target_tables as $table) {
        $result =   $new_conn->query('SELECT * FROM '.$table);
        $fields_amount = $result->field_count;
        $rows_num=$new_conn->affected_rows;
        $res = $new_conn->query('SHOW CREATE TABLE '.$table);
        $TableMLine =   $res->fetch_row();
        $content = (!isset($content) ?  '' : $content) . "\n\n".$TableMLine[1].";\n\n";

        for ($i = 0, $st_counter = 0; $i < $fields_amount;   $i++, $st_counter=0) {
            while($row = $result->fetch_row()) { //when started (and every after 100 command cycle):
                if ($st_counter%100 == 0 || $st_counter == 0 ) {
                    $content .= "\nINSERT INTO ".$table." VALUES";
                }
                $content .= "\n(";
                for($j=0; $j<$fields_amount; $j++) {
                    $row[$j] = str_replace("\n","\\n", addslashes($row[$j]) );
                    if (isset($row[$j])) {
                        $content .= '"'.$row[$j].'"' ;
                    } else {
                        $content .= '""';
                    }
                    if ($j<($fields_amount-1)) {
                        $content.= ',';
                    }
                }
                $content .=")";
                //every after 100 command cycle [or at last line] ....p.s. but should be inserted 1 cycle earlier
                if ( (($st_counter+1)%100==0 && $st_counter!=0) || $st_counter+1==$rows_num) {
                    $content .= ";";
                } else {
                    $content .= ",";
                }
                $st_counter=$st_counter+1;
            }
        } $content .="\n\n\n";
    }

    if($save_location !== false) {
        $myfile = fopen($save_location.$backup_name, "w") or die("Unable to open file!");
        fwrite($myfile, $content);
        fclose($myfile);
        $web_output .= "... Backup Has Completed. <br />";
        $web_output .= "Page will refresh in 5 seconds.";
        header( "refresh:5;url=$current_page" );
    } else {
        header('Content-Type: application/octet-stream');
        header("Content-Transfer-Encoding: Binary");
        header("Content-disposition: attachment; filename=\"".$backup_name."\"");
        echo $content; exit();
        header( "refresh:5;url=$current_page" );
    }
}