Databases
StackOverflow2013
Postsdbo
POhow to export report in word or excel
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to export report in word or excel
    primarykey
    data
    text
    <p>i want to export this report format in word or excel please help me. with this code i am getting proper data from database now i want to export it.</p> <pre><code>&lt;form name="form1" method="post" action="daily.php"&gt; &lt;h1 style="padding-left:150px;"&gt; Daily Report &lt;/h1&gt; &lt;div class="report" style="overflow:auto;height:400px;"&gt; &lt;?php $q="select cid,gtotal from db_transaction where tdate='$dat'"; $a=mysql_query($q); echo '&lt;table border="1" class="curvedEdges"&gt;'; echo '&lt;th width="30"&gt;Sr &lt;/th&gt;&lt;th&gt; Customer Name &lt;/th&gt; &lt;th&gt;Services &lt;/th&gt; &lt;th&gt;Service By &lt;/th&gt; &lt;th&gt; Amount&lt;/th&gt;'; $i=1;$gd=0; while($row=mysql_fetch_array($a)) { $qa=mysql_query("select cname from db_customers where cid=$row[0]"); $cnm=mysql_fetch_array($qa); $sd=mysql_query("select service,price from db_sale_service where cid=$row[0]"); echo '&lt;tr&gt;&lt;td&gt;'.$i.'&lt;/td&gt;&lt;td&gt;'.strtoupper($cnm[0]).'&lt;/td&gt;&lt;td&gt;&lt;table&gt;&lt;th&gt;Name&lt;/th&gt;&lt;th&gt;Price&lt;/th&gt;'; while($snm=mysql_fetch_array($sd)) { echo '&lt;tr&gt;&lt;td&gt;'.$snm[0].'&lt;/td&gt; &lt;td&gt;'.$snm[1].'&lt;/td&gt;&lt;/tr&gt;'; } $sd=mysql_query("select serviceby from db_sale_service where cid=$row[0]"); $snm=mysql_fetch_array($sd); echo '&lt;/table&gt;&lt;/td&gt;&lt;td&gt;'.$snm[0].'&lt;/td&gt;&lt;td&gt;'.$row[1].'&lt;/td&gt;&lt;/tr&gt;'; $i++; $gd+=$row[1]; } echo '&lt;tr&gt;&lt;td colspan="3" align="center"&gt;&lt;strong&gt;Tolday\'s Total &lt;/strong&gt;&lt;/td&gt;&lt;td colspan="2" align="center"&gt;&lt;strong&gt;'.$gd.'&lt;/strong&gt;&lt;/td&gt;&lt;/tr&gt;'; echo '&lt;/table&gt;'; ?&gt; &lt;/div&gt; &lt;/form&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USKalpit
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POhow to export report in word or excel
      1. This table or related slice is empty.
      1. VTClose
    2. VO
      singulars
      1. POhow to export report in word or excel
      1. This table or related slice is empty.
      1. VTModeratorReview
    3. VO
      singulars
      1. POhow to export report in word or excel
      1. This table or related slice is empty.
      1. VTClose
    1. COpossible duplicate of [Export values to Excel file format](http://stackoverflow.com/questions/6991284/export-values-to-excel-file-format)
      singulars
      1. POhow to export report in word or excel
      1. USRikesh
    2. COIf you want to export to word you can use the PHPWord library (phpword.codeplex.com). If you want to export to Excel you have two options: using the PHPExcel library (phpexcel.codeplex.com) or simply exporting to CSV (comma-separated values). The CSV will not allow you to do any formatting, so if you need formatting the PHPExcel library is your best bet.
      singulars
      1. POhow to export report in word or excel
      1. USuser1578653
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload