PHP Classes

File: importtest.php

Recommend this page to a friend!
  Classes of Harish Chauhan   MySql To Excel   ???   Download  
File: ???
Role: Example script
Content type: text/plain
Description: Example File
Class: MySql To Excel
Export data from a MySQL database to Excel files
Author: By
Last change: ImportDataFromFile is not in class. it is ImportDataFromTable so i chanfed it.
Date: 20 years ago
Size: 542 bytes
 

Contents

Class file image Download
<?php
   
    include("mysql_excel.inc.php");
   
    $import=new HarImport();
    $import->openDatabase("localhost","user","pwd","database");
   
    //To import the data from table
    $import->ImportDataFromTable("tablename");
   
    //To import the data from sql query
    /*
    $sql="select r.user_name,p.amount from recruiter r ,payment p where p.user_name=r.user_name"
    $import->ImportData($sql,"myXls.xls");*/

    //To force to download
    //$import->ImportDataFromTable("graduate","",true);
    //Or
    //$import->ImportData($sql,"myXls.xls",true);

?>