php - export data as excel file -

-

I can easily export data by simple code, but I have a problem when I export information from J. query to code The data export.php file code is not downloaded as below 

  & lt; Php include '../../config.php'; Function CleanData (& amp; $ str) {if ($ str == 't') $ str = 'TRUE'; If ($ str == 'f') $ str = 'FALSE'; If preg_match ("/ ^ 0 /", $ str) || Preg_mach ("/ ^ \ +? \ D {8,} $ /", $ str)  "); $ out = FOPN ("Php: // output", 'w'); $ flag = wrong; $ result = mysql_query ("select from the staff") or die ('questions fail!'); While (false! == ($ line = Mysql_fetch_assoc ($ results) {if (! $ Flag) {fputcsv ($ out, array_keys ($ line), ',', '' ''); $ flag = true; {$ Row ['photo']! = '') {$ Row ['photo'] = "http: // lo "$ Line [$ line, 'clear data]' 'photo'];} fputcsv ($ out, array_values ​​($ line), ',', '' ');} Fclose ($ exits) ;;;;;);   
 What is a way to call this file by jquery?   
 
 
 No, you can not do this by javascript using jQuery or any other library, inside the browser calls AJAX JavaScript data in the engine.  
 But you can use the HTML5 download feature:  
  & lt; A href = "your_file.xls" download = "YourFile.xls" & gt; Download Excel & lt; / A & gt;   
 and provide the appropriate header in PHP:  
  header ("content-type: application / vnd.ms-excel; charset = utf-8") ; Header ("content-dispute: attachment; file name = your_file.xls"); Header ("End: 0"); Header ("Cash-Control: Required-Modified, Post Check = 0, Pre-Check = 0"); Header ("Cash-Control: Private", Incorrect); Edit:  
 Although the above will work, I withdraw my words as I got:  
  
 Created by, if you need it then ask him for help  
 Cheers!

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

java - Session timeout does't work vaadin -

-
I am developing a vaadin web application and I have added the following snippet of code in my web.xml. & lt; Session-Config & gt; & Lt; Session timeout & gt; 30 & lt; / Session timeout & gt; & Lt; / Session-config & gt; Now I have noticed after 30 minutes that my users are capable of using appllication and I do not want this. I read something about this problem on the book Wadin but I do not believe in anything. From the Wadin book: The session expires after user deactivation In the normal servlet operation, the session time defines the allowed time of inactivity After which the server should clear the session. Inactivity is measured by the last server request. Different servicelists use different default for container timeouts, such as 30 minutes for Apache Tomcat. You can set the timeout with: In a web.xml: & lt; Session-config & gt; & Lt; Session timeout & gt; 30 & lt; / Session timeout & gt; & Lt; / S...
Read more