PHP - Help To Make Specific Rows In Other Color In Export To Excel

Hello,

I want to export data from php-mysql to excel in a particular cell.

1. Get the data from php-Mysql and export data to excel sheet. I already create a template excel sheet format.I want to export data from mysql to a particular cell. Sorry I can't able to attach my template excel sheet.
2. Is it possible to export image?


Thanks in advance

Hi All,

I am exporting data to excel, but run into a problem if the text contains a line break.  When it gets to the line break, it cuts off the rest of the text.

Here is my printer code:

Code: [Select]
$file = 'Notes_Export';
$csv_output = array();


$tmp = array();
$tmp[] = 'Created On';
$tmp[] = 'Created By';
$tmp[] = 'Note';

$csv_output[] = '"' . implode('","', $tmp) . '"';

$sql  = "SELECT pn.created_on, CONCAT( u.firstname,' ', u.lastname) AS created_by, pn.note FROM prop_notes pn LEFT JOIN users u ON pn.created_by = u.user_id ";
$sql .= "WHERE pn.deleted_by IS NULL AND pn.archive = '0' AND pn.property_id = '".$_GET['pid']."'";
      $result = mysqli_query($connect, $sql);

         while($rowr = mysqli_fetch_row($result))
         {
$tmp = array();
for ($j=0; $j<3; $j++) {$tmp[] = $rowr[$j];}
$csv_output[] = '"' . implode('","', $tmp) . '"';
         }


$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
// header( "Content-disposition: filename=".$filename.".csv");
header("Content-disposition: attachment; filename=".$filename.".csv");
print implode("\n",$csv_output) . "\n";
exit;

Hi All,

      As we know........to export excel sheet the database content....we query the data base and then process the result and  using Workbook  and header we export the result in excel..................

 Is there any way we can reduce the down load time  or increase the performance for same. ?

Thanks.

Hi,

i have export the search result to excel file, but arabic characters not displaying properly in excel file, eventhough i mention the header content type as utf-8

here my code...

Code: [Select]
<?php
include("global.php");
// Original PHP code by Chirp Internet: www.chirp.com.au 
// Please acknowledge use of this code by including this header. 

function cleanData(&$str) 
{
 $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); 
 if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; 
} 

$sql = $_SESSION['emp_search_sql'];
// file name for download 
$filename = "employees_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: application/vnd.ms-excel; charset=UTF-8"); 
header("Pragma: no-cache";


$flag = false;
 $result = $DB_site->query($sql) or die('Query failed!');
while(false !== ($row = mysql_fetch_assoc($result)))
{
if(!$flag) 
{
// display field/column names as first row 

echo implode("\t", array_keys($row)) . "\n"; $flag = true; 
} 
array_walk($row, 'cleanData'); 
echo implode("\t", array_values($row)) . "\n";
}

?>


Thanks,

Hi Guys....

I need to export data into excel file. So far its works on IE and Firefox. But if i using Google Chrome it download only php file. Eg(suppose file test.xls but it goes to test.php). 

Why it happen??

Hello all,

i have a table that displays data from mysql, now i want to update multiple rows from that table with checkboxes, the value will basically just switch from 'new' to 'done' so far i have this:

Code: [Select]
<tbody>
                                        <tr class="first">
        </tr>
<?php
$ticketde=0;
while ($ticketde < $numpscde) {

$f1pscde=mysql_result($ticketresultde,$ticketde,"id");
$f2pscde=mysql_result($ticketresultde,$ticketde,"ticket");
$f4pscde=mysql_result($ticketresultde,$ticketde,"date");
$f5pscde=mysql_result($ticketresultde,$ticketde,"ip");
$f6pscde=mysql_result($ticketresultde,$ticketde,"done");

$setdone = ($f6pscde["done"] == 'n') ? "<a href=\"donepsc.php?id=".$f1pscde."\"><img src=\"ico_new.gif\" alt=\"new\" /></a>" : $f6pscde["done"];

if(isset($_POST['setdone'])){$checkbox = $_POST['checkbox'];

$id = "('" . implode( "','", $checkbox ) . "');" ;
$sql = "UPDATE ticket
        SET done='done'
        WHERE id='$f1pscde'";
$result = mysql_query($sql) or die(mysql_error());
}

?>

<tr class="first">
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f1pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f2pscde; ?></font></td>

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f5pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $setdone; ?></font></td>
<td class="tc"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $f1pscde['id']; ?>"></td>


</tr>


<?php
$ticketde++;
}
?>
</tbody>
</table>
                                    <center><input type="submit" name="setdone" id="setdone" value="Set selected  to done" class="button"/>   
                                 -     <input type="submit" name="exporttxt" id="exporttxt" value="Export selected to .txt" class="button"/>
                                    </center>
                                   
</fieldset>
</form>
                           
I found that checkbox code sample on some other site and tried to implement it, i don't really know where to go from here, as it's a total mess to me now, any help would be greatly appreciated.

Hi..,
I use below method to export data to excel.

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename=abc.xls');

if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file)

but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen)

any idea how to solve this?

Does anyone know how to make an excel solver function in php?  How can you say... maximize this variable by adjusting these other variables?

I have a simple database set up for story awards given out by different groups.  Here are some of the fields I'm using:

Author
Title
Year
Summary

Some of the rows are nearly identical with the same Author and Title, but sometimes a different year or or others have a Summary for the story where otherwise it would be empty for a different row.  The problem I'm having is I want to fetch the summary of the story from all rows where the Author and Title are identical.  Currently the code is fetching a random row with the same Author and Title, but won't show the Summary if that specific row doesn't have the summary filled in (and where other rows of nearly identical information would have the summary).

Here's an example of nearly identical rows:

'Boring Title', 'Boring Author', '', '2012'
'Boring Title', 'Boring Author', 'Boring Summary', '2012'

How would I go about fetching all rows with the identical Author and Title and then showing the Summary even if only one of those rows has information in the Summary field?  Much obliged for any help.

Here's the code I'm working with:

Code: [Select]
<?php
mysql_connect(localhost,db_user,pw);
@mysql_select_db(db_database) or die( "Unable to select database");

$quer="SELECT * FROM archives ORDER BY RAND() DESC LIMIT 1";
$re = mysql_query($quer);

while ($ro = mysql_fetch_array($re))
{
extract($ro);

$please = '';
if (strlen($ro[summary]) == 0) {
$please = "The summary is empty.  Please help the Archives by <a href=\"edit.php?cmd=edit&author=$author&title=$title\">filling out the summary</a>."; 
}

$select_author = mysql_query("SELECT DISTINCT author FROM archives WHERE `title` = '" . mysql_real_escape_string($title) . "' ") or die (mysql_error());

$aut = "";
while ($row2 = mysql_fetch_array($select_author)) {
   $aut .= "<a href=\"author.php?author={$row2[author]}\">$row2[author]</a> & ";
}

$aut = substr($aut,0,-3);

echo '<div style="margin: 5px;">
'.$summary.''.$please.'

<p style="float: right; width: 100%; margin-top: 10px; text-align: right;"><i> ~ <a href="info.php?author='.$author.'&title='.$title.'">'.$title.'</a> by <a href="author.php?author='.$author.'">'.$aut.'</a></i>
</div>';

}
?>

So I have an array of IDs that I would only like to select from a database table instead of everything in the table.

How might I go about doing that?

Assuming I have a result object:

$result = mysqli_query($sql_string);

How can I get specific rows, i.e. multiple rows are returned 8 total, but I was rows 2-6. Thanks.

hey guys! i'm back again with another question   I've been messing with the piece of code for a few days now and can't get it to function properly. i'm trying to make each row a different color which works... BUT it leaves out some data and prints it double... This is the piece of code that will help you find what i've been doing wrong...

    $color="1";
    while($row = mysqli_fetch_array($retval,  MYSQLI_ASSOC)) { 
        if($color==1){
    $cardname = $row['Name']; 
    $encodedcardname = str_replace(" ","%20",trim($cardname)); 
    $url = "http://mtgimage.com/card/$encodedcardname.jpg";
     
            echo "<tr bgcolor=''><td>"; 
            echo "<a href=$url>$cardname</a>"; 
            echo "</td><td>"; 
            echo $row['Color']; 
            echo "</td><td>"; 
            echo $row['Type']; 
            echo "</td><td>"; 
            echo $row['Subtype']; 
            echo "</td><td>"; 
            echo $row['Power']; 
            echo "</td><td>"; 
            echo $row['Toughness']; 
            echo "</td><td>"; 
            echo $row['Manacost']; 
            echo "</td><td>"; 
            echo $row['Rarity']; 
            echo "</td><td>"; 
            echo $row['Expansion']; 
            echo "</td><td>"; 
            echo $row['Foil']; 
            echo "</td><td>"; 
            echo $row['Stock']; 
            echo "</td></tr>";

            $color="2";
            }
            else {
                echo "<tr bgcolor='#F8F8F8'><td>"; 
                echo "<a href=$url>$cardname</a>"; 
                echo "</td><td>"; 
                echo $row['Color']; 
                echo "</td><td>"; 
                echo $row['Type']; 
                echo "</td><td>"; 
                echo $row['Subtype']; 
                echo "</td><td>"; 
                echo $row['Power']; 
                echo "</td><td>"; 
                echo $row['Toughness']; 
                echo "</td><td>"; 
                echo $row['Manacost']; 
                echo "</td><td>"; 
                echo $row['Rarity']; 
                echo "</td><td>"; 
                echo $row['Expansion']; 
                echo "</td><td>"; 
                echo $row['Foil']; 
                echo "</td><td>"; 
                echo $row['Stock']; 
                echo "</td></tr>";

            $color="1";
            }

        } 
        echo "</table>"; 

A picture of the result of whats it outputting right now is attached to this thread. Thanks in advance! Attached Files  Naamloos.png   322.6KB   0 downloads

Hey guys I have a few pages where im echoing in one row at a time. Like for a email system. I want to color in every other row with CSS.
since im echoing in one row at a time i cant place a class on every other row saying which one is even or odd. wondering what are some ideas on how to do this.

One idea i had was maybe assign a number to each row then maybe a php math function to find if a number is odd or even? like to know if there is a correct or standard way to do this.
typed a small little example below

           $list3 = "SELECT message FROM pm WHERE id = '".($_SESSION['user_id'])."'";
           $list2 = mysql_query($list3) or trigger_error("SQL", E_USER_ERROR);
while ($list = mysql_fetch_assoc($list2)) { 
?>

<td class="odd"><?php echo $list['message']; ?></td> 

<?php } ?>

A picture to show what I mean by coloring every other row

Hi all,

Is there a way to get jquery ajax to run a specific PHP function.

At the moment Im sending extra paramaters like check=1:

Code: [Select]

    ajaxCall: function(process, obj, type){     
        $.post("registration-post.php", type + "=" + process + "&check=1",
            function(data){
                alert(data);
                if(data==""){
                    $(obj).css(registration.errorNotificationType, registration.validatedColour);
                }else{
                    //registration.validationCollection.push($.trim(data));
                    $('.error').append($.trim(data) + "<br />");
                    $(obj).css(registration.errorNotificationType, registration.errorColour);
                    registration.progress = false;     
                }
            }
        );
    }


then doing an if statement,



        if($_POST["check"]==1){
            $registration->checkDuplication();
        }                
        if($registration->validationBool){
            $registration->validateFields();
        }



but its not really doing the job i need it to do. I'm a little stuck in my own battle to make cleaner coding