Jump to content

Export php table to excell.

moudyboy

By moudyboy
in PHP Coding Help

 Share

Recommended Posts

moudyboy Newbie

moudyboy

Posted
Posted

Hi i am new in PHP...have a project and have stuck...please please help....

 

I have a cart and i need to export the cart contents to excell...here is my code...please take a look and see if u can hepl...

 

I also need to have an export button...and wen pressed the cart will be exported to excell

 

thanks...

 

<?php
session_start();
if (!isset($_SESSION["customer"])) {
    header("location: customer_login.php"); 
    exit();
}
//error script
error_reporting(E_ALL);
ini_set('display_errors','1');
//connect to the database
include "../storescripts/connect_to_mysql.php";
?>
<?php
///////////////////////////////////////////////////////////////////////////////////
//					SECTION ONE
///////////////////////////////////////////////////////////////////////////////////
if(isset($_POST['pid'])){
$pid=$_POST['pid'];
$wasFound=false;
$i=0;

//if the cart session is set or empty
if(!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"])< 1){
//Runs if the cart is empty
$_SESSION["cart_array"]= array(0 => array("item_id"=>$pid,"quantity"=>1));	
}else{
//Runs if the cart has at least one item in it
foreach($_SESSION["cart_array"] as $each_item){
 $i++;
while(list($key,$value)= each($each_item)){
if($key == "item_id"&&$value==$pid){
//the ite is in the cart..hence we adjust the quantity
array_splice($_SESSION["cart_array"],$i-1,1,array(array("item_id"=>$pid,"quantity"=>$each_item['quantity']+1)));
$wasFound=true;
}//close if conditio
   }//close while loop
  }//close foreach loop
  if($wasFound==false){
  array_push($_SESSION["cart_array"],array("item_id"=>$pid,"quantity"=>1));
}
  }
  header("location: cart.php");
}
?>
<?php
///////////////////////////////////////////////////////////////////////////////////
//					SECTION TWO
///////////////////////////////////////////////////////////////////////////////////
//if usser chooses to empty their sopping cart
if(isset($_GET['cmd'])&& $_GET['cmd']=="emptycart"){
   unset($_SESSION["cart_array"]);
   }
?>
<?php
///////////////////////////////////////////////////////////////////////////////////
//					SECTION THREE
///////////////////////////////////////////////////////////////////////////////////
//if usser chooses to empty their sopping cart
if(isset($_POST['item_to_adjust'])&& $_POST['item_to_adjust']!=""){
	//execute some code
	$item_to_adjust=$_POST['item_to_adjust'];
	$quantity=$_POST['quantity'];
	$quantity=preg_replace('#[^0-9]#i', '',$quantity);
	if($quantity >= 1000){$quantity=999;}
	if($quantity < 1){$quantity= 1;}
	$i=0;
foreach($_SESSION["cart_array"] as $each_item){
 $i++;
while(list($key,$value)= each($each_item)){
if($key == "item_id"&&$value==$item_to_adjust){
//the ite is in the cart..hence we adjust the quantity
array_splice($_SESSION["cart_array"],$i-1,1,array(array("item_id"=>$item_to_adjust,"quantity"=>$quantity)));
}//close if conditio
   }//close while loop
  }//close foreach loop
}
?>
<?php
///////////////////////////////////////////////////////////////////////////////////
//					SECTION FOUR
///////////////////////////////////////////////////////////////////////////////////
if(isset($_POST['index_to_remove'])&&$_POST['index_to_remove']!=""){
	//access the array and run code to remove
$key_to_remove= $_POST['index_to_remove'];
if(count($_SESSION["cart_array"])<=1){
unset($_SESSION["cart_array"]);
}else{
unset($_SESSION["cart_array"]["$key_to_remove"]);
sort($_SESSION["cart_array"]);
}
}
?>
<?php
///////////////////////////////////////////////////////////////////////////////////
//					SECTION FIVE
///////////////////////////////////////////////////////////////////////////////////

$cartOutput="";
$cartTotal="";
if(!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"])< 1){
   $cartOutput="<h2 align='center'>Your Cart Is Empty</h2>";
}else{
$i=0;
foreach($_SESSION["cart_array"] as $each_item){
$item_id=$each_item['item_id'];
$sql=mysql_query("SELECT * FROM products WHERE id='$item_id' LIMIT 1");
while($row=mysql_fetch_array($sql)){
	$product_name=$row["product_name"];
	$price=$row['price'];
	$details=$row['details'];
}
	$pricetotal= $price*$each_item['quantity'];
	$cartTotal=$pricetotal + $cartTotal;

    //setlocale(LC_MONETARY,"en_KSHs");
	//$pricetotal= money_format("%10.2n", $pricetotal);
	//dynamic table assembly

	$cartOutput .="<tr align='center'>";
	$cartOutput .='<td><a href="../home.php?id=' . $item_id . '">' .$product_name . '</a><br/><img src="../inventory_images/' . $item_id . '.jpg" alt="' . $product_name . '" width="40" height="52" border="1"/></td>';
	$cartOutput .='<td>' . $details . '</td>';
	$cartOutput .='<td><form action="cart.php" method="post">
	<input name="quantity" type="text" value="' . $each_item['quantity'] . '" size="1" maxlength="3" />
	<input name="adjustBtn' . $item_id . '" type="image" value="change" src="../images/buttons/button_save.gif"/>
	<input name="item_to_adjust" type="hidden" value="' . $item_id . '" />
	</form></td>';
	//$cartOutput .='<td>' . $each_item['quantity'] . '</td>';
	$cartOutput .='<td>' . $price . '</td>';
	$cartOutput .='<td>' . $pricetotal . '</td>';
	$cartOutput .='<td><form action="cart.php" method="post">
	<input name="deleteBtn' . $item_id . '" type="image" value="X" src="../images/buttons/button_delete.gif"/>
	<input name="index_to_remove" type="hidden" value="' . $i . '" /
	></form></td>';
	$cartOutput .='</tr>';
	$i++;
}

  $cartTotal="<div align='right'>Your Total is KSHs. ".$cartTotal."</div>";
}
?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Your Cart</title>
<link rel="stylesheet" href="../style/style.css" type="text/css" media="screen"/>
</head>
<body>
<div align="center" id="mainWrapper">
  <?php include_once("../templates/template_header3.php");?>
  <div id="pageContent">
  <div style="margin:24px;text-align:left;">
  <br/>
  <table width="100%" border="1" cellspacing="0" cellpadding="6">
    <tr bgcolor="#00FF66"  align="center">
      <td width="17%" bgcolor="#5BD7D7"><strong>Product</strong></td>
      <td width="50%" bgcolor="#5BD7D7"><strong>Product Details</strong></td>
      <td width="7%" bgcolor="#5BD7D7"><strong>Quantity</strong></td>
      <td width="9%" bgcolor="#5BD7D7"><strong>Unit Price<br/>(KHSs.)</strong></td>
      <td width="10%" bgcolor="#5BD7D7"><strong>Total<br/>(KHSs.)</strong></td>
      <td width="7%" bgcolor="#5BD7D7"><strong>Remove</strong></td>
    </tr>
    <?php echo $cartOutput; ?>
<!--     <tr>
      <td> </td>
      <td> </td>
      <td> </td>
      <td> </td>
      <td> </td>
      <td> </td>
    </tr> -->
  </table>
  <?php echo $cartTotal; ?><br/>
  <br/>
  <a href="cart.php?cmd=emptycart">Empty Your Cart</a><br/>
  <a href="cart.php?cmd=export">Export</a><br/>
</div>
<?php include_once("../templates/template_footer.php");?>
</div>
  </body>
</html>

Link to comment
Share on other sites
ChemicalBliss Newbie

ChemicalBliss

Posted
Posted

Hi, I'm honored you have chosen to email me with this request, If i were to just fill it out and send you a complete code then what is to stop you from coming back and doing it again, and again.. Also, it is much preffered if you keep any replies or requests relevant to this topic in this topic.

 

I am more than willing to help you in this matter, though, I will get you started.

 

First: Remove those unneccessary ?><?php tags, you actually have a newline between them and that will break any header commands (Output has already been sent to the http server - the new line).

 

Second: I would put everything that uses "cmd" into SECTION 2 as you have labeled. First, use an ELSEIF statement to check if the cmd is export.

If it is then you want to start making the csv like this:

  1. [*]Get the fields, these always go first in a CSV and defines the titles of each column of data. To get these you can use array_keys(), for instance, use it only on the first data set in your cart_contents session array - you can use implode() to quickly get a string from the keys array).

[*]Make the data fields line by line by using a loop. each line you need to enclose each value with double quotes, seperated by a comma, with a system-new-line at the end. (windows: "\r\n").

 

Third: Then use the correct header declerations to display the file to the browser. These headers are:

Content-type: text/csv

Content-disposition: attachment; filename=$filename.csv

 

You may also want to use this header to prevent page caching:

Cache-Control: no-store, no-cache

 

<?php
session_start();
if (!isset($_SESSION["customer"])) {
    header("location: customer_login.php"); 
    exit();
}
//error script
error_reporting(E_ALL);
ini_set('display_errors','1');
//connect to the database
include "../storescripts/connect_to_mysql.php";

///////////////////////////////////////////////////////////////////////////////////
//					SECTION ONE
///////////////////////////////////////////////////////////////////////////////////
if(isset($_POST['pid'])){
$pid=$_POST['pid'];
$wasFound=false;
$i=0;

//if the cart session is set or empty
if(!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"])< 1){
//Runs if the cart is empty
$_SESSION["cart_array"]= array(0 => array("item_id"=>$pid,"quantity"=>1));	
}else{
//Runs if the cart has at least one item in it
foreach($_SESSION["cart_array"] as $each_item){
 $i++;
while(list($key,$value)= each($each_item)){
if($key == "item_id"&&$value==$pid){
//the ite is in the cart..hence we adjust the quantity
array_splice($_SESSION["cart_array"],$i-1,1,array(array("item_id"=>$pid,"quantity"=>$each_item['quantity']+1)));
$wasFound=true;
}//close if conditio
   }//close while loop
  }//close foreach loop
  if($wasFound==false){
  array_push($_SESSION["cart_array"],array("item_id"=>$pid,"quantity"=>1));
}
  }
  header("location: cart.php");
}

///////////////////////////////////////////////////////////////////////////////////
//					SECTION TWO
///////////////////////////////////////////////////////////////////////////////////
//if usser chooses to empty their sopping cart
if(isset($_GET['cmd'])&& $_GET['cmd']=="emptycart"){
   unset($_SESSION["cart_array"]);
}elseif(isset($_GET['cmd'])&& $_GET['cmd']=="export"){

	// This is how you get the fields as an array from your session variable
	$cart_contents = $_SESSION["cart_array"];
	$fields = array_keys($cart_contents[0]);

	// Make the CSV contents here and save to the variable $csv_output
	// This is what you need to do.

	print $csv_output;
	exit;
}

///////////////////////////////////////////////////////////////////////////////////
//					SECTION THREE
///////////////////////////////////////////////////////////////////////////////////
//if usser chooses to empty their sopping cart
if(isset($_POST['item_to_adjust'])&& $_POST['item_to_adjust']!=""){
	//execute some code
	$item_to_adjust=$_POST['item_to_adjust'];
	$quantity=$_POST['quantity'];
	$quantity=preg_replace('#[^0-9]#i', '',$quantity);
	if($quantity >= 1000){$quantity=999;}
	if($quantity < 1){$quantity= 1;}
	$i=0;
foreach($_SESSION["cart_array"] as $each_item){
 $i++;
while(list($key,$value)= each($each_item)){
if($key == "item_id"&&$value==$item_to_adjust){
//the ite is in the cart..hence we adjust the quantity
array_splice($_SESSION["cart_array"],$i-1,1,array(array("item_id"=>$item_to_adjust,"quantity"=>$quantity)));
}//close if conditio
   }//close while loop
  }//close foreach loop
}

///////////////////////////////////////////////////////////////////////////////////
//					SECTION FOUR
///////////////////////////////////////////////////////////////////////////////////
if(isset($_POST['index_to_remove'])&&$_POST['index_to_remove']!=""){
	//access the array and run code to remove
$key_to_remove= $_POST['index_to_remove'];
if(count($_SESSION["cart_array"])<=1){
unset($_SESSION["cart_array"]);
}else{
unset($_SESSION["cart_array"]["$key_to_remove"]);
sort($_SESSION["cart_array"]);
}
}

///////////////////////////////////////////////////////////////////////////////////
//					SECTION FIVE
///////////////////////////////////////////////////////////////////////////////////

$cartOutput="";
$cartTotal="";
if(!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"])< 1){
   $cartOutput="<h2 align='center'>Your Cart Is Empty</h2>";
}else{
$i=0;
foreach($_SESSION["cart_array"] as $each_item){
$item_id=$each_item['item_id'];
$sql=mysql_query("SELECT * FROM products WHERE id='$item_id' LIMIT 1");
while($row=mysql_fetch_array($sql)){
	$product_name=$row["product_name"];
	$price=$row['price'];
	$details=$row['details'];
}
	$pricetotal= $price*$each_item['quantity'];
	$cartTotal=$pricetotal + $cartTotal;

    //setlocale(LC_MONETARY,"en_KSHs");
	//$pricetotal= money_format("%10.2n", $pricetotal);
	//dynamic table assembly

	$cartOutput .="<tr align='center'>";
	$cartOutput .='<td><a href="../home.php?id=' . $item_id . '">' .$product_name . '</a><br/><img src="../inventory_images/' . $item_id . '.jpg" alt="' . $product_name . '" width="40" height="52" border="1"/></td>';
	$cartOutput .='<td>' . $details . '</td>';
	$cartOutput .='<td><form action="cart.php" method="post">
	<input name="quantity" type="text" value="' . $each_item['quantity'] . '" size="1" maxlength="3" />
	<input name="adjustBtn' . $item_id . '" type="image" value="change" src="../images/buttons/button_save.gif"/>
	<input name="item_to_adjust" type="hidden" value="' . $item_id . '" />
	</form></td>';
	//$cartOutput .='<td>' . $each_item['quantity'] . '</td>';
	$cartOutput .='<td>' . $price . '</td>';
	$cartOutput .='<td>' . $pricetotal . '</td>';
	$cartOutput .='<td><form action="cart.php" method="post">
	<input name="deleteBtn' . $item_id . '" type="image" value="X" src="../images/buttons/button_delete.gif"/>
	<input name="index_to_remove" type="hidden" value="' . $i . '" /
	></form></td>';
	$cartOutput .='</tr>';
	$i++;
}

  $cartTotal="<div align='right'>Your Total is KSHs. ".$cartTotal."</div>";
}
?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Your Cart</title>
<link rel="stylesheet" href="../style/style.css" type="text/css" media="screen"/>
</head>
<body>
<div align="center" id="mainWrapper">
  <?php include_once("../templates/template_header3.php");?>
  <div id="pageContent">
  <div style="margin:24px;text-align:left;">
  <br/>
  <table width="100%" border="1" cellspacing="0" cellpadding="6">
    <tr bgcolor="#00FF66"  align="center">
      <td width="17%" bgcolor="#5BD7D7"><strong>Product</strong></td>
      <td width="50%" bgcolor="#5BD7D7"><strong>Product Details</strong></td>
      <td width="7%" bgcolor="#5BD7D7"><strong>Quantity</strong></td>
      <td width="9%" bgcolor="#5BD7D7"><strong>Unit Price<br/>(KHSs.)</strong></td>
      <td width="10%" bgcolor="#5BD7D7"><strong>Total<br/>(KHSs.)</strong></td>
      <td width="7%" bgcolor="#5BD7D7"><strong>Remove</strong></td>
    </tr>
    <?php echo $cartOutput; ?>
<!--     <tr>
      <td> </td>
      <td> </td>
      <td> </td>
      <td> </td>
      <td> </td>
      <td> </td>
    </tr> -->
  </table>
  <?php echo $cartTotal; ?><br/>
  <br/>
  <a href="cart.php?cmd=emptycart">Empty Your Cart</a><br/>
  <a href="cart.php?cmd=export">Export</a><br/>
</div>
<?php include_once("../templates/template_footer.php");?>
</div>
  </body>
</html>

 

If you get stuck, provide your current work. And what is happening, and what you want to happen. Then anyone can answer if they know the problem :P.

 

Good luck and I hope this helps

Link to comment
Share on other sites
moudyboy Newbie

moudyboy

Posted
  • Author
Posted

he i took a diffrent approach and it worked thanks alot for the tips...

 

if(isset($_GET['cmd'])&& $_GET['cmd']=="emptycart"){
unset($_SESSION["cart_array"]);
}elseif(isset($_GET['cmd'])&& $_GET['cmd']=="export"){

// This is how you get the fields as an array from your session variable

$cart_contents = $_SESSION["cart_array"];
$fields = array_keys($cart_contents[0]);

// Make the CSV contents here and save to the variable $csv_output
$csv_output = $cartOutput2;


// This is what you need to do.
//print $csv_output;



$filename = $file."_".date("d-m-Y_H-i",time()).".csv";
$fp = fopen('..\\documentation_files\\customer\\'.$filename, 'w') or die("can't open file");
fwrite($fp, $csv_output);
fclose($fp);

header('Content-disposition: attachment; filename='.$filename);
header('Content-type: text/csv');
readfile('..\\documentation_files\\customer\\'.$filename);
exit;

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.