$q = mysql_query("select * from mytable");

while($mrow = mysql_fetch_assoc($q)) {
    $col = 0;
    foreach($mrow as $key=>$value) {
        $objPHPExcel->setActiveSheetIndex(0)->setCellValueByColumnAndRow($col, 0, $key);
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row + 1, $value);
        $col++;
    }
    $row++;
 }

try phpExcel

https://phpexcel.codeplex.com/wikipage?title=Examples&referringTitle=Home

I can help if you want to do phpExcel.

Ejaz

stworthy!

please help

<input class="easyui-filebox" name="file" style="width:200px;" />

show fakepath in the screen not given real path of the file.
how to solve this ?

Ejaz

use this

$.extend($.fn.dialog.methods, {
    mymove: function(jq, newposition){
        return jq.each(function(){
            $(this).dialog('move', newposition);
        });
    }
});


$(dialogName).dialog('move', {
   left: 10,
   top: 200
});
         
$(dialogName).dialog('open').dialog('setTitle','abcd Details');

$sql = "update products set productName='$productName'  where ProductBrand = '$ProductBrand' and productCode = '$productCode' and ProductSerial = '$ProductSerial' ";

$result = @mysql_query($sql);

hi

if your date field data type is date/time then use this
$tdate = date('Y-m-d H:i:s',strtotime($tdate));

if data type is just date then use this
$tdate = date('Y-m-d',strtotime($tdate));

Can we show [ sound.wav ] file in DataGrid and play?

 <div id="mytab" class="easyui-tabs" data-options="tools:'#tab-tools'" style="width:1350px;height:780px; font-family:Eras Demi ITC;">
      
            <div title="Advertise" data-options="href:'page1.php',closable:false"></div>
                <div title="Advertise via SMS" data-options="href:'page2.php',closable:false"></div>
                <div title="Campaign Response" data-options="href:'page3.php',closable:false"></div>
</div>

How to refresh or reload inner page click on any tab?

Ejaz

How to make EasyUI datagrid responsive so that it is resized when the browser window's size changes?

One more thing..
how to set data type any integer value column in Grid?

thanks

Is it possible to hide show columns programmatically?

ehussain.

stworthy!

sir i'm waiting for your reply.

thanks

hi,
I want to use footer column in datagrid php, here is my code to get data from db...

        $page = isset($_POST['page']) ? intval($_POST['page']) : 1;
   $rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
   $offset = ($page-1)*$rows;
   $result = array();

   //include 'conn.php';
   include 'include/db.php';
   
   $rs = mysql_query("select count(*) from table");
   $row = mysql_fetch_row($rs);
   $result["total"] = $row[0];
   $rs = mysql_query("SELECT .. limit $offset,$rows");
   
   $items = array();
   while($row = mysql_fetch_object($rs)){
      array_push($items, $row);
   }
   $result["rows"] = $items;

   echo json_encode($result);


can anyone help that how I add the footer value in my code?

Thanks

How to refresh grid in dialog box?