How to download file using PHP

The following is the code to download file using PHP

//Author : Mayurika Bhatt
if(isset($_GET['Action']) && $_GET['Action'] =='Download')
{
 $speed = 100;
 $export_file = "upload/".$_REQUEST['file'];
 $file_extension = strtolower(substr(strrchr(basename($export_file),"."),1));
 if(file_exists($export_file) && is_file($export_file) )
 {
  switch( $file_extension ) {
  case "exe":$ctype="application/octet-stream";
   break;
  case "zip":$ctype="application/zip";
   break;
  case "mp3":$ctype="audio/mpeg";
   break;
  case "mpg":$ctype="video/mpeg";
   break;
  case "avi":$ctype="video/x-msvideo";
   break;
  // (sensitive stuff, like php files)
  case "doc":$ctype="application/msword";break;
  case "css":$ctype="text/plain";break;
  case "htm":$ctype="application/force-download";break;
  case "html":$ctype="application/force-download";break;
  case "txt":$ctype="application/force-download";break;
  default:
   $ctype="application/force-download";
  }
  $filespaces = str_replace("_", " ", $export_file);
  header("Cache-Control:");
  header("Cache-Control: public");
  header("Content-Type: $ctype");
  header("Accept-Ranges: bytes");
  $size = filesize($export_file); 
  
  header("Content-Length: ".$size);
  header('Content-Disposition: attachment; filename="'.basename($filespaces).'"');
  //open the file
  $fp = fopen($export_file,"rb");
  //seek to start of missing part 
  //start buffered download
  while(!feof($fp)) {  
  //reset time limit for big file
   set_time_limit(0);    
   print(fread($fp,1024*$speed));
   flush();
   sleep(1);
  }
  fclose($fp);
  exit;
 }
 else
 {
  die("404 File not found!");
 }
} 

Architecture of Zend Engine

Overview
Debugging can begin via your browser or directly from the IDE Client. Communication to the Debug Server is by way of your Web server and the Zend EngineTM. Thereafter, interaction between the Debug Server and the IDE Client takes place throughout the course of a Debug Session.

The IDE Client
The IDE Client is Zend's desktop application that enables you to develop your scripts and to interact with the Debug Server. It is comprised of the Zend IDE Desktop (GUI), an editor, Debug window, Filesystem browser, debug module, and a customization tool.

Debug Via Browser
A Debug Session is a structured process of debugging one or more script files. Debug sessions are not limited to independent scripts. Beginning with a root script, a Session can continue through one or more nested scripts until it is terminated.

You can start a Debug Session directly from your browser GUI, by manually defining a set of parameters to the root script's URL.

However, the Zend IDE enables you to access your browser from within the IDE Client. In doing so, the assignment of parameters and definition of a cookie will be done automatically.

Debug Server
The Debug Server is the server-side module that controls the Zend Engine's execution over the course of a Debug Session. The Debug Server oversees a Debug Session process from beginning to end,meaning that it:

• Initiates the Session at your command.
• Executes debugging methods that you choose to apply.
• Terminates the Debug Session at your command

The Zend Engine is the internal compiler and runtime engine used by
PHP4. Developed by Zeev Suraski and Andi Gutmans, the Zend Engine is an
abbreviation of their names. In the early days of PHP4, it worked as
follows:
The PHP script was loaded by the Zend Engine and compiled into Zend opcode. Opcodes, short for operation codes, are low level binary instructions. Then the opcode was executed and the HTML generated sent to the client. The opcode was flushed from memory after execution.
Today, there are a multitude of products and techniques to help you speed up this process.

Database connection Class

Its simple to integrate it.

use it in the file where you want it to be called.
like in index.php
write this code
//include dbconnection and query class
include_once('include/connection.php');
//Database connection
$dbconnect = new DbConnect(HOST,USER,PASS,DATABASE);
$dbconnect->open();

$sql = 'select * from '.TABLENAME;
//instantiate object of query class
$dbquery = new DbQuery($sql);
$result = $dbquery->query();
$fetchrow = $dbquery->fetcharray();

and so on.
If any bugs please contact me.....
/*
Created By : Mayurika bhatt
Created On : 17th Oct,2007
Name : connection.php
Functionality : Connection and query class.
*/

Class DbConnect
{
var $host = '' ;
var $user = '';
var $password = '';
var $database = '';
var $persistent = false;
var $conn;

var $error_reporting = false;

/*constructor function this will run when we call the class */

function DbConnect ($host1, $user1, $password1,$database1, $error_reporting=true, $persistent=false) {


//pass the hostname, user, password, database names here if static
$this->host = $host1;
$this->user = $user1;
$this->password = $password1;
$this->database = $database1;
$this->persistent = $persistent;
$this->error_reporting = $error_reporting;
}

function open(){
if ($this->persistent) {
$func = 'mysql_pconnect';
} else {
$func = 'mysql_connect';
}

/* Connect to the MySQl Server */

$this->conn = $func($this->host, $this->user, $this->password);
if (!$this->conn) {
return false;
}
/* Select the requested DB */

if (@!mysql_select_db($this->database, $this->conn)) {
return false;
}
return true;
}

/*close the connection */

function close() {
return (@mysql_close($this->conn));
}

/* report error if error_reporting set to true */

function error() {
if ($this->error_reporting) {
return (mysql_error()) ;
}

}
}
/* Class to perform query*/
class DbQuery extends DbConnect
{
var $result = '';
var $sql;
function DbQuery($sql1)
{
$this->sql = $sql1;
}

function query() {

return $this->result = mysql_query($this->sql);
//return($this->result != false);
}

function affectedrows() {
return(@mysql_affected_rows($this->conn));
}

function numrows() {
return(@mysql_num_rows($this->result));
}
function fetchobject() {
return(@mysql_fetch_object($this->result, MYSQL_ASSOC));
}
function fetcharray() {
return(@mysql_fetch_array($this->result));
}

function fetchassoc() {
return(@mysql_fetch_assoc($this->result));
}

function freeresult() {
return(@mysql_free_result($this->result));
}

}

Import CSV File using PHP

Below is the code to import csv file to MySQL .

It allows you to specify the delimiter in this csv file, whether it is a comma, a tab etc. It also allows you to chose the line separator.

It also permits you to include an empty field at the beginning of each row, which is usually an auto increment integer primary key.

This script is useful mainly if you don't have or you are a command prompt guy.
Just make sure the table is already created before trying to dump the data.
Kindly post your comments if you got any bug report.

/* Created By : Mayurika Bhatt
Created On : 25th Oct, 2007
Functionality : Add News User.
*/
@ob_start();
@session_start();
//include dbconnection and query class
include_once('include/userfunction.php');
include('include/dbconfig.php');

//Database connection
$dbconnect = new DbConnect(HOST,USER,PASS,DATABASE);
$dbconnect->open();

$databasetable = NEWSUSER;
$fieldseparator = ",";
$lineseparator = "\n";
//change the name of the file you want

$csvfile = 'filename';

/********************************************************************************************/
/* Would you like to add an empty field at the beginning of these records?
/* This is useful if you have a table with the first field being an auto_increment integer
/* and the csv file does not have such as empty field before the records.
/* Set 1 for yes and 0 for no. ATTENTION: don't set to 1 if you are not sure.
/* This can dump data in the wrong fields if this extra field does not exist in the table
/********************************************************************************************/
$addauto = 0;
/********************************************************************************************/
if(!file_exists($csvfile)) {
$msg = "File not found. Make sure you specified the correct path.
";
}
$file = fopen($csvfile,"r");

if(!$file) {
$msg = "Error opening data file.
";
}

$size = filesize($csvfile);

if(!$size) {
$msg = "File is empty.
";
}
$csvcontent = fread($file,$size);

fclose($file);
$lines = 0;
$queries = "";
$inserted = 0;
$linearray = array();

foreach(split($lineseparator,$csvcontent) as $line) {
$lines++;
$line = trim($line," \t");
$line = str_replace("\r","",$line);
/************************************************************************************************************
This line escapes the special character. remove it if entries are already escaped in the csv file
************************************************************************************************************/
$line = str_replace("'","\'",$line);
/***********************************************************************************************************/

$linearray = explode($fieldseparator,$line);

if($lines == 1)
{
//first line as the name of the fields
$first = explode($fieldseparator,$line);
}
if($lines !=1)
{
$linemysql = implode("','",$linearray);

if($addauto)
$query = "insert into $databasetable ($user) values('','$linemysql');";
else
$query = "insert into $databasetable ($user) values('$linemysql');";

$queries .= $query . "\n";

$dbquery = new DbQuery($query);
$resinsert = $dbquery->insertquery();
if($resinsert)
{
$inserted ++;
}
}
}

$rec = $lines-1;
if($inserted == $rec)
{
$msg = "Found a total of $rec records in this csv file.
Data inserted successfully";
header('location:addnewsuser.php?msg='.urlencode($msg));
exit;
}
else
{
$msg .= " Data not inserted successfully";
header('location:addnewsuser.php?msg='.urlencode($msg));
exit;
}
?>

Definitions Of PHP

The PHP Hypertext Preprocessor is a programming language that allows web developers to create dynamic content that interacts with databases.PHP is a recursive acronym for "PHP Hypertext Preprocessor". It is an open source, interpretive, HTML centric, server side scripting language. PHP is especially suited for Web development and can be embedded into HTML pages.

personal home Page, and HTML-embedded scripting language originally designed for simple home page development. PHP has evolved to become an extended scripting language capable of substituting for CGI and SSI.

(Hypertext Preprocessor) open source, server-side HTML scripting languaage used to create dynamic Web pages. PHP is embedded within tags, so the author authorr can move between HTML and PHP instead of using large amounts of code.

Acronym: Hypertext Preprocessor. PHP is a server-side scripting language for creating dynamic Web pages. You create pages with PHP and HTML. When a visitor opens the page, the server processes the PHP commands and then sends the results to the visitor's browser, just as with ASP or ColdFusion.

Abbreviation for Hypertext preprocessor

PHP, or "PHP: Hypertext Preprocessor", is a commonly-used open-source scripting language. phpBB is written in PHP and requires the PHP runtime engine to be installed and properly configured on the server phpBB is run on.

One of the most popular server-side scripting languages on the web. PHP is open-source, and noted for its efficiency and suitability for developing web applications.

PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages. PHP-enabled web pages are treated just like regular HTML pages and you can create and edit them the same way you normally create regular HTML pages.

PHP is the most popular open source programming language for building dynamic web sites which can be used to write server-side programs that access databases.

PHP Hypertext Preprocessor is a server-side embedded scripting language that allows increased delivery of dynamic content from databases. PHP can perform any task that CGI can, but increased compatability with other technologies (SMTP, POP3 etc) makes it much more powerful.

PHP (Hypertext Preprocessor) is an free open-source server-side scripting language. PHP code can be embedded in HTML. PHP files usually have extensions like .php or .php3. PHP language style is similar to C and Java.

Script language on the server (server-side). PHP is converted to (X)HTML code. PHP is widely used for processing data from forms or for communicating with a database

PHP is a scripting language used to create dynamic websites. Its advantage over JavaScript is that it runs on the web server rather than on the viewer's PC or Mac. PHP can be used for the same kind of applications as ASP and .NET but is free and open source.

A script programming language that can be embedded into HTML. In effect, it turns your HTML pages into a program that is run by the Web server before being displayed, allowing you to customize your site's Web pages on the fly.

PHP(http://www.php.net/) is a server-side, interpreted programming language designed specifically for Web programming. It is closely integrated with Web server technology so does not use the CGI.

A server-side scripting language made popular by the Open Source community.

Hypertext Preprocessor : dynamic webpage creation's technology.

Very similar to shtml but utilizes PHP to do its work.

Abbreviation for Hypertext Pre-Processor, a server language used to produce dynamic content on web pages.

Stands for "Hypertext Preprocessor." A server side scripting language used normally on Unix-based systems.

Refers to "PHP: Hypertext Preprocessor" which means that PHP handles data before it becomes HTML. According to the official PHP Web site, PHP is a server-side, cross-platform, HTML embedded scripting language.

PHP is a very popular open source server-side scripting language. Like ASP and JSP, PHP code is embedded in web pages and allows the creation of dynamic pages. Most web hosting companies offer PHP.

PHP (PHP:Hypertext Preprocessor) is a reflective programming language originally designed for producing dynamic web pages. PHP is used mainly in server-side scripting, but can be used from a command line interface or in standalone graphical applications.

MySQL Optimization

How to Optimize Mysql?
Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized.The most important factor in making a system fast is its basic design.

The most common system bottlenecks are:

* Disk seeks. It takes time for the disk to find a piece of data. With modern disks, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. This time improves slowly with new disks and is very hard to optimize for a single table. The way to optimize seek time is to distribute the data onto more than one disk.

* Disk reading and writing. When the disk is at the correct position, we need to read the data. With modern disks, one disk delivers at least 10-20MB/s throughput. This is easier to optimize than seeks because you can read in parallel from multiple disks.

* CPU cycles. When we have the data in main memory (or if it was already there), we need to process it to get our result. Having small tables compared to the amount of memory is the most common limiting factor. But with small tables, speed is usually not the problem.

* Memory bandwidth. When the CPU needs more data than can fit in the CPU cache, main memory bandwidth becomes a bottleneck. This is an uncommon bottleneck for most systems, but one to be aware of.

Optimizing hardware for MySQL

* If you need big tables ( > 2G), you should consider using 64 bit hardware like Alpha, Sparc or the upcoming IA64. As MySQL uses a lot of 64 bit integers internally, 64 bit CPUs will give much better performance.

* For large databases, the optimization order is normally RAM, Fast disks, CPU power.

* More RAM can speed up key updates by keeping most of the used key pages in RAM.

* If you are not using transaction-safe tables or have big disks and want to avoid long file checks, a UPS is good idea to be able to take the system down nicely in case of a power failure.

* For systems where the database is on a dedicated server, one should look at 1G Ethernet. Latency is as important as throughput.

Optimizing the application

* One should concentrate on solving the problem.
* When writing the application one should decide what is most important:
o Speed
o Portability between OS
o Portability between SQL servers
* Use persistent connections.
* Cache things in your application to lessen the load of the SQL server.
* Don't query columns that you don't need in your application.
* Don't use SELECT * FROM table_name...
* Benchmark all parts of your application, but put the most effort into benchmarking the whole application under the worst possible 'reasonable' load. By doing this in a modular fashion you should be able to replace the found bottleneck with a fast 'dummy module', you can then easily identify the next bottleneck (and so on).
* Use LOCK TABLES if you do a lot of changes in a batch; For example group multiple UPDATESDELETES together.

Optimizing MySQL

* Choose compiler and compiler options.
* Find the best MySQL startup options for your system.
* Scan the the MySQL manual and read Paul DuBois' MySQL book.
* Use EXPLAIN SELECT, SHOW VARIABLES, SHOW STATUS and SHOW PROCESSLIST.
* Learn how the query optimizer works.
* Optimize your table formats.
* Maintain your tables (myisamchk, CHECK TABLE, OPTIMIZE TABLE).
* Use MySQL extensions to get things done faster.
* Write a MySQL UDF function if you notice that you would need some function in many places.
* Don't use GRANT on table level or column level if you don't really need it.
* Pay for MySQL support and get help to solve your problem :)

Let me Introduce myself

I am a PHP Developer. I can do fantastic coding. Now your funnybone might tickle, everyone thinks the same. I have a passion for coding. I can do almost any kind of coding. As such I have worked on some of the most popular CMS . Joomla, phpBB2, oscommerce, etc.... I am member of Drupal community also. Ajax is cup of coffee for me. It simplifies some tasks in really amazing manner. I would personally recommend to use all the flavours of PHP on-hand if you are developing in PHP . When I started it was not so easy, as to understand the concepts ,implement them , get the proper output is not everybody's work. Especially, when there is no other resource. But thanks to WWW who made my work possible. If you get to my blog and find something interesting I will be the most happiest ever.