php - SQL Export - Wordpress plugin DEV -

-

hi have following code..

function export_file() {       $tmpname = '/tmp/' . sha1( uniqid() ) . $ext;     $filename = 'export.sql';     $cmd = sprintf( "/applications/xampp/xamppfiles/bin/mysqldump -h'%s' -u'%s' -p'%s' %s --single-transaction %s > %s",         db_host, db_user, db_password, db_name, $compression_pipe, $tmpname );      exec( $cmd );     header( 'content-type: application/bzip' );     header( 'content-length: ' . filesize( $tmpname ) );     header( 'content-disposition: attachment; filename="' . $filename . '"' );     readfile( $tmpname );     unlink( $tmpname );      exit(); }

now, works doesnt download file. saying headers sent.

headers sent (output started @ /applications/xampp/xamppfiles/htdocs/~/wp-admin/includes/template.php:1642)

now understand headers have been sent main plugin file include javascript , css files needed plugin creating.

 function admin_register_head() { $siteurl = get_option('siteurl'); $css = $siteurl . '/wp-content/plugins/' . basename(dirname(__file__)) . '/style.css'; $script = $siteurl . '/wp-content/plugins/' . basename(dirname(__file__)) . '/script.js'; echo "<link rel='stylesheet' type='text/css' href='$css' />";  echo "<script src='$script' type='application/javascript'>"; }

how go telling load page again these headers sql dump downloads file , not displayed / file created on server. eg. press link or button , call function , have headers added downloads sql dump file? please correct me if im totally off track here. open suggestions on how this.

i noob , have learnt hell of lot far php, mysql , wordpress creating different elements plugin. appreciated. have searched searched, read tutorials can't seem work. in advanced!

i did figure out now. 

if ( isset( $_get['sql_export_export'] ) ) {             export_file(); }  function export_file() {           $tmpname = '/tmp/' . sha1( uniqid() ) . $ext;         $filename = 'export.sql';         $cmd = sprintf( "/applications/xampp/xamppfiles/bin/mysqldump -h'%s' -u'%s' -p'%s' %s --single-transaction %s > %s",             db_host, db_user, db_password, db_name, $compression_pipe, $tmpname );          exec( $cmd );         header( 'content-type: application/bzip' );         header( 'content-length: ' . filesize( $tmpname ) );         header( 'content-disposition: attachment; filename="' . $filename . '"' );         readfile( $tmpname );         unlink( $tmpname );          exit();     }       function database_backup() {       ?><a class="button" href="?sql_export_export">export sql</a><?php      }

i using xampp on local build plugin wp, replace mysqldump path suit server.


Comments

Post a Comment

Popular posts from this blog

java - JavaFX 2 slider labelFormatter not being used -

-
i have following code not label slider "foo50", etc... 1 expect setlabelformatter call, instead seems have no effect (the slider labelled 50, 100, etc , println's dont run). there missing? not implemented in default 2.2 skin? using oracle java 7 package javafxbugtest; import javafx.application.application; import javafx.scene.*; import javafx.scene.control.*; import javafx.stage.*; import javafx.util.stringconverter; public class javafxbugtest extends application { @override public void start(final stage primarystage) { slider cp = new slider(); cp.setlabelformatter(new stringconverter<double>() { @override public string tostring(double t) { system.out.println("nope?"); return "foo" + t.tostring(); } @override public double fromstring(string string) { system.out.println("he
Read more

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

-
the current version of mozilla firefox 23.0.1, version not support play mp3 shoutcast streams tcp port different 80 (most common 8000 shoutcast 1.9.8). i use flash when mp3 support not available in html5 audio, way detect is: try{ var = document.createelement('audio'); r = !!(a.canplaytype && !!a.canplaytype("audio/mpeg; codecs=mp3").replace(/^no$/,'')) }catch(e){ r = false; } the support mp3 shoutcast streams in firefox added in version 24 . a.canplaytype("audio/mpeg; codecs=mp3") = in chrome , firefox, chrome support, firefox not support, due current code detect not work firefox. the current version of jquery support ie 6 1.10.2, version not has .browser i think "stylized" way testing features , not querying browsers / versions, notwithstanding here see hard not violate "principle". what "stylized" way of detect mp3 icy support without navigator.useragent in firefox? ther
Read more

web - SVG not rendering properly in Firefox -

-
i have problem svg renderring in firefox. whilst works in safari, chrome or in ie, doesn't work in firefox. inspecting element seems layers there, background visible if it's z-index higher z-index of others. rendered in firefox: svg logo in firefox link original source file: svg file thanks help. ps: used sketch 3 export svg. if helps somehow. you're experiencing bug 995813 . i fixed bug time ago change still making way through release process example display correctly firefox 31 onwards released on 22 july 2014. in meantime if move fill="white" <mask> element child <use> element work around firefox bug.
Read more