php - Instead of saving CSV file how to Download the file -


i exporting data database using csv extension , want download results csv file. how can that?

this code:

public function actionexportexcel() {      $con = mysql_connect("localhost", "root", "") or die();     mysql_select_db("fiducial", $con);     $filename = 'uploads/'.strtotime("now").".csv";     $query = mysql_query("select *                         (                             select employeecode,name,dob,age,sex,employee_relation,company_id                             employeedetails                             union                             select employeecode,father_name,father_dob,father_age,father_gender,father_relation,company_id                             employeedetails                             father_name not null , company_id not null                             union                             select employeecode,mother_name,mother_dob,mother_age,mother_gender,mother_relation,company_id                             employeedetails                             mother_name not null , mother_dob not null                         )t t.company_id = '56' order t.employeecode ") or die(mysql_error());      $num_rows = mysql_num_rows($query);     if($num_rows >= 1)     {         $rows = mysql_fetch_assoc($query);         $seperator = "";         $comma = "";         foreach ($rows $name => $value)          {             $seperator .= $comma . '' .str_replace('', '""', $name);             $comma = ",";         }         $seperator .= "\n";         $fp = fopen($filename, "w");         fputs($fp, $seperator);         mysql_data_seek($query, 0);         while($rows = mysql_fetch_assoc($query))         {             $seperator = "";             $comma = "";             foreach ($rows $name => $value)              {                 $seperator .= $comma . '' .str_replace('', '""', $value);                 $comma = ",";             }             $seperator .= "\n";             fputs($fp, $seperator);         }         echo "data exported";         fclose($fp);     } else {         echo "no data available";     }  }

how can download csv file?

you need set http headers correctly csv file download , instead of writing query results csv file on local server, need write php output buffer (php://output):

full working example:

public function actionexportexcel() {       $con = mysql_connect("localhost", "root", "") or die();     mysql_select_db("fiducial", $con);     $filename = 'uploads/'.strtotime("now").".csv";     $query = mysql_query("select *                         (                             select employeecode,name,dob,age,sex,employee_relation,company_id                             employeedetails                             union                             select employeecode,father_name,father_dob,father_age,father_gender,father_relation,company_id                             employeedetails                             father_name not null , company_id not null                             union                             select employeecode,mother_name,mother_dob,mother_age,mother_gender,mother_relation,company_id                             employeedetails                             mother_name not null , mother_dob not null                         )t t.company_id = '56' order t.employeecode ") or die(mysql_error());        $num_rows = mysql_num_rows($query);     if($num_rows >= 1) {         header('content-description: download name ');         header('content-type: application/csv');         header('content-disposition: attachment; filename=yourfilename.csv');          $rows = mysql_fetch_assoc($query);         $seperator = "";         $comma = "";         foreach ($rows $name => $value)          {             $seperator .= $comma . '' .str_replace('', '""', $name);             $comma = ",";         }         $seperator .= "\n";         $fp = fopen('php://output', 'w');         fputs($fp, $seperator);         mysql_data_seek($query, 0);         while($rows = mysql_fetch_assoc($query))         {             $seperator = "";             $comma = "";             foreach ($rows $name => $value)              {                 $seperator .= $comma . '' .str_replace('', '""', $value);                 $comma = ",";             }             $seperator .= "\n";             fputs($fp, $seperator);         }          fclose($fp);     } else {         echo "no data available";     }  }

Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more