<?php
	/* 
	* DUMP MYSQL TABLE FROM PHP 
	* credits: 
	* David Walsh - original script http://davidwalsh.name/backup-mysql-database-php
	* Emanuele "ToX" Toscano - single insert into instruction for many rows, dump & create table functions
	*/
	function dumpTable($host, $user, $pass, $db, $table) {
	    $return = null;
	    $link = mysql_connect($host, $user, $pass);
	    mysql_select_db($db, $link);
	    
	    $result     = mysql_query('SELECT * FROM ' . $table);
	    $num_fields = mysql_num_fields($result);
	    
	    /* DUMP TABLE (uncomment if you need it) *\/
	        $return.='DROP TABLE ' . $table . ';';

	    /* CREATE TABLE (uncomment if you need it) *\/
	        $row2=mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
	        $return.="\n\n" . $row2[1] . ";\n\n";
	    
	    /* INSERT INTO instructions */
	    	if ($num_fields > 0) {
	    		$return.='INSERT INTO ' . $table . ' VALUES';
		        for ($i=0; $i<$num_fields; $i++) {
		        	$x = 0;
		            while ($row=mysql_fetch_row($result)) {
		            	$x++;
		            	if ($x == 1) {
		            		$return .= "\n(";
		            	} else {
		            		$return .= "),\n(";
		            	}
		                for ($j=0; $j<$num_fields; $j++) {
		                    $row[$j]=addslashes($row[$j]);
		                    $row[$j]=str_replace("\n", "\\n", $row[$j]);
		                    if (isset($row[$j])) {
		                        $return.='"' . $row[$j] . '"';
		                    } else {
		                        $return.='""';
		                    }
		                    if ($j<($num_fields-1)) {
		                        $return.=',';
		                    }
		                }
		            }
		        }
		        $return.=");\n";
		    }
	    	    
	    return $return;
	}