DaniWeb Forum Index > Web Development > PHP

Button php export table data

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Nov 2009

Posts: 8

Reputation: jppr03 is an unknown quantity at this point

Solved Threads: 0

jppr03

Offline

Newbie Poster

Button php export table data

Nov 6th, 2009

Hi! I need a button in php code, that when i click on that button it export's my SELECT to a text file or excell file..

i searched.. there's a lot of program's that make that.. but i don't want that.. i want to make on my webpage a simple code button that when someone click there it save's the content of a table..

thanks a lot

•

Join Date: Nov 2009

Posts: 8

Reputation: jppr03 is an unknown quantity at this point

Solved Threads: 0

jppr03

Offline

Newbie Poster

Nov 7th, 2009

please.. anyone know? :s

•

Join Date: May 2007

Posts: 454

Reputation: Atli is on a distinguished road

Solved Threads: 56

Atli

Offline

Posting Pro in Training

Nov 7th, 2009

Hey.

What data are you looking to export?
Fetching data from a form and writing it to a file is fairly simple. We just have no idea what sort of data you are using, and without knowing that we can't really say anything for certain.

We need to see your code. The form that contains your data.

Please do not ask for help in a PM. Use the forums.
And use [code] tags!

•

Join Date: Nov 2009

Posts: 8

Reputation: jppr03 is an unknown quantity at this point

Solved Threads: 0

jppr03

Offline

Newbie Poster

Nov 7th, 2009

thanks a lot for reply

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
	$db = new Banco();
 
	$id =  $_REQUEST['id'];
	$datai = $_REQUEST['iData'];
	$dataf = $_REQUEST['fData'];
 
	$rs = $db->Query("SELECT *
					  FROM localizacao                          
				      WHERE (local_clien_id='$id') AND
							  ((data>=to_date('$datai', 'dd/mm/yyyy')) AND 
							   (data<=to_date('$dataf', 'dd/mm/yyyy')+1))
				      ORDER BY local_id asc");
 
		if(pg_num_rows($rs)>0)
		{		  
			while($myrow = pg_fetch_assoc($rs)) { 
				printf ("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $myrow['latitude'], $myrow['longitude'], $myrow['altitude'], $myrow['data']); 
			}
		}
	$db = new Banco();

	$id =  $_REQUEST['id'];
	$datai = $_REQUEST['iData'];
	$dataf = $_REQUEST['fData'];

	$rs = $db->Query("SELECT *
					  FROM localizacao                          
				      WHERE (local_clien_id='$id') AND
							  ((data>=to_date('$datai', 'dd/mm/yyyy')) AND 
							   (data<=to_date('$dataf', 'dd/mm/yyyy')+1))
				      ORDER BY local_id asc");
		
		if(pg_num_rows($rs)>0)
		{		  
			while($myrow = pg_fetch_assoc($rs)) { 
				printf ("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $myrow['latitude'], $myrow['longitude'], $myrow['altitude'], $myrow['data']); 
			}
		}

OUTPUT:

http://i.imagehost.org/0085/example.jpg

i wanted to save that table content that show's in the figure.. latitude, longitude and data, to a text file or excell file...

you know now what i mean?

Last edited by jppr03; Nov 7th, 2009 at 9:12 am.

•

Join Date: May 2007

Posts: 454

Reputation: Atli is on a distinguished road

Solved Threads: 56

Atli

Offline

Posting Pro in Training

Nov 7th, 2009

Ok, I see.

You can have PHP create whatever output you want out of that.

For example, to create a XML file and save it on the server, you can do:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
// <snipped the DB code>
 
$output = '<?xml version="1.0" encoding="UTF-8"?><root>';
if(pg_num_rows($rs)>0)
{		  
    while($myrow = pg_fetch_assoc($rs))
    {
        $output .= sprintf('<row><latitude>%s</latitude><longitude>%s</longitude><altitude>%s</altitude><date>%s</date></row>',
            $myrow['latitude'], $myrow['longitude'], $myrow['altitude'], $myrow['data']);
        $output .= "\n";
    }
}
$output .= '</root>';
 
file_put_contents('/path/to/my/file.xml', $output);
// <snipped the DB code>

$output = '<?xml version="1.0" encoding="UTF-8"?><root>';
if(pg_num_rows($rs)>0)
{		  
    while($myrow = pg_fetch_assoc($rs))
    {
        $output .= sprintf('<row><latitude>%s</latitude><longitude>%s</longitude><altitude>%s</altitude><date>%s</date></row>',
            $myrow['latitude'], $myrow['longitude'], $myrow['altitude'], $myrow['data']);
        $output .= "\n";
    }
}
$output .= '</root>';

file_put_contents('/path/to/my/file.xml', $output);

Creating a Excell file is a bit more complicated (Microsoft don't play well with others), but Excell should be able to read basic XML files like these.

Please do not ask for help in a PM. Use the forums.
And use [code] tags!

•

Join Date: Oct 2009

Posts: 53

Reputation: K0ns3rv is an unknown quantity at this point

Solved Threads: 6

K0ns3rv

Offline

Junior Poster in Training

Nov 7th, 2009

•

Originally Posted by Atli

Ok, I see.

You can have PHP create whatever output you want out of that.

For example, to create a XML file and save it on the server, you can do:
Help with Code Tags

php Syntax (Toggle Plain Text)
// <snipped the DB code>
 
$output = '<?xml version="1.0" encoding="UTF-8"?><root>';
if(pg_num_rows($rs)>0)
{		  
    while($myrow = pg_fetch_assoc($rs))
    {
        $output .= sprintf('<row><latitude>%s</latitude><longitude>%s</longitude><altitude>%s</altitude><date>%s</date></row>',
            $myrow['latitude'], $myrow['longitude'], $myrow['altitude'], $myrow['data']);
        $output .= "\n";
    }
}
$output .= '</root>';
 
file_put_contents('/path/to/my/file.xml', $output);
// <snipped the DB code> $output = '<?xml version="1.0" encoding="UTF-8"?><root>'; if(pg_num_rows($rs)>0) { while($myrow = pg_fetch_assoc($rs)) { $output .= sprintf('<row><latitude>%s</latitude><longitude>%s</longitude><altitude>%s</altitude><date>%s</date></row>', $myrow['latitude'], $myrow['longitude'], $myrow['altitude'], $myrow['data']); $output .= "\n"; } } $output .= '</root>'; file_put_contents('/path/to/my/file.xml', $output);
Creating a Excell file is a bit more complicated (Microsoft don't play well with others), but Excell should be able to read basic XML files like these.

Creating a simple exel file is fairly simple, you will get the idea if you save an exel sheet as html and open it.
Basicly you can create an .xls file and fill it with html.

//K0ns3rv

•

Join Date: Nov 2009

Posts: 8

Reputation: jppr03 is an unknown quantity at this point

Solved Threads: 0

jppr03

Offline

Newbie Poster

Nov 7th, 2009

thanks for helping Alti ..

how i make that, but with a button, like a button then when i click on it, it save's my content to that XML file?

•

Join Date: May 2007

Posts: 454

Reputation: Atli is on a distinguished road

Solved Threads: 56

Atli

Offline

Posting Pro in Training

Nov 7th, 2009

Also, forgot to mention.

If you would rather send the file to the user, to allow him to download it, you can do this instead of the file_put_contents .

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
header('content-type: text/xml');
header('content-disposition: attachment; filename=data_export.xml');
echo $output;
header('content-type: text/xml');
header('content-disposition: attachment; filename=data_export.xml');
echo $output;

This prompts a download box in all the major browsers.

Last edited by Atli; Nov 7th, 2009 at 11:26 am.

Please do not ask for help in a PM. Use the forums.
And use [code] tags!

•

Join Date: Oct 2009

Posts: 53

Reputation: K0ns3rv is an unknown quantity at this point

Solved Threads: 6

K0ns3rv

Offline

Junior Poster in Training

Nov 7th, 2009

I have the code for saving a file then sending it to the user, I'd be glad to help you, but i won't be back for 30 min, so stick around if you havn't gotten an answer.

//K0ns3rv

•

Join Date: May 2007

Posts: 454

Reputation: Atli is on a distinguished road

Solved Threads: 56

Atli

Offline

Posting Pro in Training

#10

Nov 7th, 2009

Consider this code.
It has a form where a user enters the start and end date, and the PHP code compiles a XML file with all the data from a table that were created in that time-frame.

I created it for a MySQL database, but you can easily re-write the database part to fit your database. I just don't have anything else to test on my end.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
if(isset($_POST['StartDate'], $_POST['EndDate']))
{
    $dbLink = new mysqli('localhost', 'usr', 'pwd', 'dbName');
 
    // Fetch the data
    $start = $dbLink->real_escape_string($_POST['StartDate']);
    $end = $dbLink->real_escape_string($_POST['EndDate']);
    $sql = "SELECT * FROM `news`
            WHERE `Created` BETWEEN '{$start}' AND '{$end}'";
    $result = $dbLink->query($sql);
 
    // Create the XML output
    $output = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<root>\n";
    if($result->num_rows > 0)
    {
        while($myrow = $result->fetch_assoc())
        {
            $output .= "\t<row>\n";
            foreach($myrow as $_name => $_value)
            {
                $output .= "\t\t<$_name>$_value</$_name>\n";
            }
            $output .= "\t</row>\n";
        }
    }
    $output .= "</root>";
 
    // Send it as a XML file for download
    header('content-type: text/xml');
    header('content-disposition: attachment; filename=data_export.xml');
    echo $output;
    exit;
}
else
{
?>
<!DOCTYPE html>
<html>
    <head>
        <title>Data Export Thingie</title>
    </head>
    <body>
        <h1>Export some dataz!</h1>
        <form action="?" method="post">
            <label for="StartDate">Start Date:</label>
            <input type="text" name="StartDate" id="StartDate" value="YYYY-MM-DD HH:MM" /><br />
            <label for="EndDate">End Date:</label>
            <input type="text" name="EndDate" id="EndDate" value="YYYY-MM-DD HH:MM" /><br />
            <input type="submit" />
        </form>
    </body>
</html>
<?php
}
?>
<?php
if(isset($_POST['StartDate'], $_POST['EndDate']))
{
    $dbLink = new mysqli('localhost', 'usr', 'pwd', 'dbName');

    // Fetch the data
    $start = $dbLink->real_escape_string($_POST['StartDate']);
    $end = $dbLink->real_escape_string($_POST['EndDate']);
    $sql = "SELECT * FROM `news`
            WHERE `Created` BETWEEN '{$start}' AND '{$end}'";
    $result = $dbLink->query($sql);

    // Create the XML output
    $output = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<root>\n";
    if($result->num_rows > 0)
    {
        while($myrow = $result->fetch_assoc())
        {
            $output .= "\t<row>\n";
            foreach($myrow as $_name => $_value)
            {
                $output .= "\t\t<$_name>$_value</$_name>\n";
            }
            $output .= "\t</row>\n";
        }
    }
    $output .= "</root>";

    // Send it as a XML file for download
    header('content-type: text/xml');
    header('content-disposition: attachment; filename=data_export.xml');
    echo $output;
    exit;
}
else
{
?>
<!DOCTYPE html>
<html>
    <head>
        <title>Data Export Thingie</title>
    </head>
    <body>
        <h1>Export some dataz!</h1>
        <form action="?" method="post">
            <label for="StartDate">Start Date:</label>
            <input type="text" name="StartDate" id="StartDate" value="YYYY-MM-DD HH:MM" /><br />
            <label for="EndDate">End Date:</label>
            <input type="text" name="EndDate" id="EndDate" value="YYYY-MM-DD HH:MM" /><br />
            <input type="submit" />
        </form>
    </body>
</html>
<?php
}
?>

Does that help at all?