AppServ 2.5.10 and 2.6.0 with PHP6 New Released !!!

by appserv.net | Posted in AppServ Net

AppServ 2.5.10

  • Apache 2.2.8
  • PHP 5.2.6
  • MySQL 5.0.51b
  • phpMyAdmin-2.10.3

Download
Sourceforge.net
:
http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.10.exe?download

MD5SUM : 279c0c39866fbecb8a3904969fd5d0f4


AppServ 2.6.0

  • Apache 2.2.8
  • PHP 6.0.0-dev
  • MySQL 6.0.4-alpha
  • phpMyAdmin-2.10.3

Download
Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.6.0.exe?download

MD5SUM : e3a108c9b17f3572e53c07f52d236481

AppServ 2.5.9 & 2.4.9 with Zend Optimizer AddOns Released !

by appserv.net | Posted in AppServ Net

AppServ 2.5.9

  • Apache 2.2.4
  • PHP 5.2.3
  • MySQL 5.0.45
  • phpMyAdmin-2.10.2

Download
Sourceforge.net :
http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.9.exe?download

MD5SUM : 8b95311356c9c5f22bf9e72c68033ef7
AppServ 2.4.9

  • Apache 2.0.59
  • PHP 4.4.7
  • MySQL 5.0.45
  • phpMyAdmin-2.10.2

Download
Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.4.9.exe?download

MD5SUM : 52078d6e5d52b0b17fd929a8cc8ec74d
Zend Optimizer 3.3.0 AppServ AddOns

Download
Sourceforge.net :
http://prdownloads.sourceforge.net/appserv/appserv-addons-zendoptimizer-3.3.0.exe?download

MD5SUM : f8827fb25c1a33e61f5e7327f80ae3bb

AppServ 2.5.8 & 2.4.8 with MySQL Root Password Reset Released !

by appserv.net | Posted in AppServ Net

AppServ 2.4.8

  • MySQL Root Password Reset
  • Apache 2.0.59
  • PHP 4.4.5
  • MySQL 5.0.27
  • phpMyAdmin-2.9.2 

Download
Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.4.8.exe?download

MD5SUM : 917bffb4f5b7ca6188a4c82b067d39df

AppServ 2.5.8

  • MySQL Root Password Reset
  • Apache 2.2.4
  • PHP 5.2.1
  • MySQL 5.0.27
  • phpMyAdmin-2.9.2

Download
Sourceforge.net :
 http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.8.exe?download

MD5SUM : b5daeded874474873a03e75b36511fe7

Easy way to create XLS file from PHP

by appserv.net | Posted in AppServ Net

Everybody knows phpMyAdmin can export file to Excel format but phpMyAdmin just export .csv file,not real Excel file format. If you are interest in PHP programming and need to export to the real Excel format please check it out !

Example PHP export to XLS file format.

1. Create Function for XLS

function xlsBOF() {
echo
pack(“ssssss”, 0×809, 0×8, 0×0, 0×10, 0×0, 0×0);
return;
}

function xlsEOF() {
echo
pack(“ss”, 0x0A, 0×00);
return;
}

function xlsWriteNumber($Row, $Col, $Value) {
echo
pack(“sssss”, 0×203, 14, $Row, $Col, 0×0);
echo
pack(“d”, $Value);
return;
}

function xlsWriteLabel($Row, $Col, $Value ) {
$L = strlen($Value);
echo
pack(“ssssss”, 0×204, 8 + $L, $Row, $Col, 0×0, $L);
echo
$Value;
return;
}

2. Send Header to Browser in download format.

   // Query Database
$result=mysql_db_query($dbname,“select id,prename,name,sname,grade from appdata where course=’$courseid’ and sec=’$section’”)

// Send Header
header(“Pragma: public”);
header(“Expires: 0″);
header(“Cache-Control: must-revalidate, post-check=0, pre-check=0″);
header(“Content-Type: application/force-download”);
header(“Content-Type: application/octet-stream”);
header(“Content-Type: application/download”);;
header(“Content-Disposition: attachment;filename=$courseid-$sec.xls); // แล้วนี่ก็ชื่อไฟล์
header(“Content-Transfer-Encoding: binary “);

// XLS Data Cell

xlsBOF();
xlsWriteLabel(1,0,“Student Register $semester/$year”);
xlsWriteLabel(2,0,“COURSENO : “);
xlsWriteLabel(2,1,“$courseid”);
xlsWriteLabel(3,0,“TITLE : “);
xlsWriteLabel(3,1,“$title”);
xlsWriteLabel(4,0,“SETION : “);
xlsWriteLabel(4,1,“$sec”);
xlsWriteLabel(6,0,“NO”);
xlsWriteLabel(6,1,“ID”);
xlsWriteLabel(6,2,“Gender”);
xlsWriteLabel(6,3,“Name”);
xlsWriteLabel(6,4,“Lastname”);
$xlsRow = 7;
while(list(
$id,$prename,$name,$sname,$grade)=mysql_fetch_row($result)) {
++
$i;
xlsWriteNumber($xlsRow,0,“$i”);
xlsWriteNumber($xlsRow,1,“$id”);
xlsWriteLabel($xlsRow,2,“$prename”);
xlsWriteLabel($xlsRow,3,“$name”);
xlsWriteLabel($xlsRow,4,“$sname”);
$xlsRow++;
}
xlsEOF();
exit();

AppServ 2.4.7 and 2.5.7 Released !!

by appserv.net | Posted in AppServ Net

AppServ 2.4.7

  • Add MySQL Collation Selection.
  • Old Password for PHP MySQL Old API Function.
  • Enable InnoDB.
  • Setup detect old version and backup it before install new version.
  • Apache 2.0.59
  • PHP 4.4.4
  • MySQL 5.0.24a
  • phpMyAdmin-2.9.0.2 

Download
Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.4.7.exe?download
        Bittorrent : www.appserv.net/torrent/appserv-win32-2.4.7.exe.torrent

MD5SUM : b0e22a4a42e88ebf0a9393c0a6d2943f

AppServ 2.5.7

  • Add MySQL Collation Selection.
  • Old Password for PHP MySQL Old API Function.
  • Enable InnoDB.
  • Setup detect old version and backup it before install new version.
  • Apache 2.2.3
  • PHP 5.1.6
  • MySQL 5.0.24a
  • phpMyAdmin-2.9.0.2

Download
Sourceforge.net :
 http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.7.exe?download
        Bittorrent :
  http://www.appserv.net/torrent/appserv-win32-2.5.7.exe.torrent

MD5SUM : 0463647eec0e21f2e13075e9be3e4283