Ad:

PHP Discussion Thread
Marked Solved
Views: 2713

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Nov 6th, 2009

Button php export table data

Expand Post »

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

Similar Threads

jppr03

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Nov 2009

Permalink

Nov 7th, 2009

Re: Button php export table data

please.. anyone know? :s

jppr03

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Nov 2009

Permalink

Nov 7th, 2009

Re: Button php export table data

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.

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Nov 7th, 2009

Re: Button php export table data

thanks a lot for reply

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.

jppr03

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Nov 2009

Permalink

Nov 7th, 2009

Re: Button php export table data

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:

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.

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Nov 7th, 2009

Re: Button php export table data

Click to Expand / Collapse Quote 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:
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

K0ns3rv

Reputation Points: 11

Solved Threads: 8

Junior Poster in Training

Offline

86 posts
since Oct 2009

Permalink

Nov 7th, 2009

Re: Button php export table data

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?

jppr03

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Nov 2009

Permalink

Nov 7th, 2009

Re: Button php export table data

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 .

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.

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Nov 7th, 2009

Re: Button php export table data

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

K0ns3rv

Reputation Points: 11

Solved Threads: 8

Junior Poster in Training

Offline

86 posts
since Oct 2009

Permalink

Nov 7th, 2009

Re: Button php export table data

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.

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?

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Dynamic Array?

Next Thread in PHP Forum Timeline: Dynamic title errors

DaniWeb Message

Cancel Changes

User Name
Password