reading blob from mysql database with php

Question

I do the following in my php code :

$q="SELECT * FROM {$table} where x;
$link = mysqli_connect("localhost", "test", "test","mytable");
$res = mysqli_query($link,$q);
 if($res)
   {
       $row = mysqli_fetch_assoc($res);
       header("Content-type: text/xml");
       header("Content-Disposition: attachment; filename=$name");
       echo $row['blob'];
   }

I can see that the data(xml file) that I uploaded into mysql does not have any leading spaces but when I run the above code 3 new lines and a space appear and the file is not well formed xml any more. Any idea why the exact contents are not being read from the table?

Have you looked in the MySQL database to see if there are new line characters there, this will rule out the script as an issue. How is the XML not well formed anymore. Do you mean there are tags missing etc, or do you mean the browser no longer interprets the XML as XML. Or do you mean it isn't indented properly? — Chris
– Chris, Commented Sep 26, 2012 at 0:01
Store XML as text, blob's are for binary data. On that note, don't store XML.. — wesside
– wesside, Commented Sep 26, 2012 at 1:26
XML Parsing Error: XML or text declaration not at start of entity Line Number 3, Column 2: — icedek
– icedek, Commented Sep 26, 2012 at 1:27
which is supposed to be in the first line is on line 3 column 2 — icedek
– icedek, Commented Sep 26, 2012 at 1:41
@Chris I looked at the MySQL DB and there are no new lines there.It is funny how I get these new lines when I read them using php. — icedek
– icedek, Commented Sep 26, 2012 at 1:42

icedek · Accepted Answer · 2012-09-26 21:49:27Z

2

Figured it out.A silly mistake. My open php tag started on line 3 column 2

> <?php

and that made the 'echo' starting from the same line (line 3 column 2). Is that how echo is supposed to work?

answered Sep 26, 2012 at 21:49

icedek

5842 gold badges14 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rkstar · Accepted Answer · 2012-09-26 01:02:56Z

0

You should investigate where the extra newlines are coming from, but you could get around your problem by running:

trim($row['blob']);

answered Sep 26, 2012 at 1:02

rkstar

1,2401 gold badge15 silver badges27 bronze badges

Collectives™ on Stack Overflow

reading blob from mysql database with php

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related