Create CSV File Using PHP MySqli

Create comma seprated file using fwrite php function using with mysql query. It is very easy way to create csv file.

<?php
$con =  new mysqli("127.0.0.1","root","cx(ymc@!","demodb");
if ($con->connect_error) {
    die("Connection failed: " . $con->connect_error);
}
$sql = "SELECT phoneNo_int,fName_vch,lName_vch FROM users";
$result = $con->query($sql);
$bufferDATA = "";
$exportPath = $_SERVER["DOCUMENT_ROOT"]."/demo/uploads";
$inpFileName = "users.csv";
$bufferDATA = "Contact No,First Name,Last Name".CHR(13);
/*If file already found delete it from directory*/
try {
    if(file_exists($exportPath."/".$inpFileName)) {
        unlink($exportPath."/".$inpFileName);
    }
}catch(Exception $e){
    echo $e->getMessage();
} 
............
............
............
 
More details visit :
https://www.elearn99.com/programming/create-comma-seprated-file-php/258/ 
 

Comments

Post a Comment

Popular posts from this blog

Login with facebook using coldfusion

Image
Here is a example. How to make facebooklogin for a website using coldfusion?. Before start you make a account with facebook. Step 1 :  Create a app for your website using facebooklogin.here you can get app_key and secret_key. Step 2: Step 4:  You can see this screen :   Step 5:   After filling UserName and Password a screen show like this...    After click ok the redirect to logininformation:- Output in logininformation.cfm  I hope this is useful for you. if you are facing any problem write us in comment. we are happy to solve that problem.   For more details visit these links : -   http://developers.facebook.com/docs/facebook-login/   //Permissions   http://developers.facebook.com/docs/reference/login/   https://developers.facebook.com/docs/reference/api/user/
Read more

Create CSV file in Coldfusion Using CFFile

Create CSV file in Coldfusion Using CFFile <cfquery name="GetUsers" datasource="TestDB">     SELECT UserID, UserName, Password,Active,     CASE Active         WHEN 1 THEN 'Active'         WHEN 0 THEN 'InActive'         END AS Status     FROM shema_users        </cfquery> <cfset HeaderColumn = "UserID,UserName,Password,Status"> <CFSET FileOutputPath = "C:\ColdFusion10\cfusion\wwwroot\Test\uploads">                            <CFFILE ACTION="Write" FILE="#FileOutputPath#\Users.csv" OUTPUT="#HeaderColumn#" nameconflict="overwrite" addnewline="yes">                     <cfloop query=...
Read more

Get Previous One Day Data in Sql Server

Get Previous One Day Data in Sql Server using convert(), dateadd(), datediff() and getdate() sql functions and between operator. SELECT OrderID , CustomerID , OrderDateTime FROM [ DEMODB ] . [ dbo ] . [ Orders ] WHERE OrderDateTime   BETWEEN CONVERT ( VARCHAR ( 10 ) ,   DATEADD ( DAY , DATEDIFF ( DAY , 0 , GETDATE ( ) ) , - 1 ) , 101 ) + ' ' + '00:00:00' AND CONVERT ( VARCHAR ( 10 ) ,   DATEADD ( DAY , DATEDIFF ( DAY , 0 , GETDATE ( ) ) , - 1 ) , 101 ) + ' ' + '23:59:59'
Read more