[Fwd: Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??]
Sorry, I'm back again with this same problem! Apparently the only
reason it looked like it was solved an hour ago was because the img
src=xx statement I tried reading out of the database was pointing
to an image already on the page!
When the img src=xxx statement points to an image NOT already on
the page, it doesn't work.
I thought the size of the image might be the problem, but no matter how
small I make the image, it doesn't work.
Again, any insight into what might be the problem here would be MUCH
appreciated.
Is it necessary for an img src=xxx statement to be in the code
of the script writing the page for the image to be correctly inserted
onto the page? I believe that's the question.
It looks like when the img src=xx statement is pulled from a
database and copied onto the webpage, some kind of php or HTML parser
doesn't get a chance to parse it, resolve it, and go retrieve the image
to put it on the page!!!
I hope I'm wrong about this, but at this point I don't have any other
plausible theory!!
---BeginMessage---
Yes, here's the code that is retrieving news items from the database
and printing them on the page (I do some other stuff with the text
before, and after, I print it, for example, find the sentences, so I can
print complete sentences, and not just pieces of sentences). As I say,
occasionally these news items contain some HTML, e.g., the img
src=xxx statement. All of the text is being correctly retrieved
from the database and written to the page, including the img
src=xxx statement, because I see it all in the page source of the
page in my browser. However, the img src= statement is NOT
working, that is, the image does NOT appear on the page.
$result = mysql_query(SELECT * FROM newsitem ORDER BY
newsitem_date DESC);
if (mysql_num_rows($result) 0)
{
$i = 1;
while (($row = mysql_fetch_assoc($result)) ($i 6)) { ?
div id=newsitem
p?php echo $row['newsitem_date']; ?bibr / ?php $title
= $row['title']; echo $title; echo /i/bbr by ; ? ?php echo
$row['author']; echo of em; echo $row['newsservice']; ?/embrbr /
?php $newsitem_array = explode('.', $row['newsitem_text']);
$print_newsitem = $newsitem_array[0] . .;
$length_newsitem = strlen($print_newsitem);
for ($j = 1; $length_newsitem 250; $j++) {
$print_newsitem = $print_newsitem . $newsitem_array[$j] . .;
$length_newsitem = strlen($print_newsitem);
}
echo $print_newsitem;
echo br; $url_string = a href=\ . $row['url'] . \ (read
more of this article)/a; echo $url_string;
$blog_result = mysql_query(SELECT * FROM blog where discussion
= \$title\);
if (mysql_num_rows($blog_result) 0)
$not = ;
else
$not = not;
echo br; echo This news item does$not have a blog discussion
; echo nbsp;nbsp;;
if (mysql_num_rows($blog_result) 0)
echo a href=\bloglist.php?discussion=$title\Read this
item's blog/a ;
else
echo a href=\blog.php?discussion=$title\Start a discussion
on this item/a ;
$i++;
?
/pbr /
/div
?php
}
}
?
Stut wrote:
On 15 Jul 2008, at 22:36, Rod Clay wrote:
Hello. Again, I'm fairly new to php so please forgive me if my
question is a very simple or obvious one.
I've just tried testing for the first time some php code that is
pulling text out of a database to print it on the webpage. Some of
this text includes HTML, specifically in this case an img
src=x statement. Much to my surprise, this is not
working. Is there a problem with pulling HTML out of a database like
this as the page is being written?
There's no problem of course if my php code is writing the HTML to
the page - in this case, the img src=xx statement works fine
and the image is displayed. Why is it a problem when my php script
pulls the HTML code out of a database and writes it to the page from
there??
It would appear that when my php script writes HTML to the page a
process of some kind is executed to, in this case, get the image and
put it on the page. Apparently this same process is NOT executed if
the HTML is retrieved from a database and simply written to the page
from there. Is this correct? And, if it is, can anyone suggest a
workaround, another way to get done what I'm trying to do here?
Code please, we're not mind readers!
-Stut
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---End Message---
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[Fwd: [Fwd: Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??]]
OK. Once again, a problem I thought was abstruse and formidable turns
out to be ridiculously simple and embarrassingly obvious (once you
realize what it is - image not in web server directory!!!) But I
didn't know until this happened that the browser sends a follow-up
request to the web server for the images it finds specified on the
page. This is a very useful piece of knowledge!! It made it obvious
that I was looking for the problem in all the wrong places! Sorry for
the false alarm. Next time I'll try to have a real problem everyone can
sink their teeth into!!
---BeginMessage---
Sorry, I'm back again with this same problem! Apparently the only
reason it looked like it was solved an hour ago was because the img
src=xx statement I tried reading out of the database was pointing
to an image already on the page!
When the img src=xxx statement points to an image NOT already on
the page, it doesn't work.
I thought the size of the image might be the problem, but no matter how
small I make the image, it doesn't work.
Again, any insight into what might be the problem here would be MUCH
appreciated.
Is it necessary for an img src=xxx statement to be in the code
of the script writing the page for the image to be correctly inserted
onto the page? I believe that's the question.
It looks like when the img src=xx statement is pulled from a
database and copied onto the webpage, some kind of php or HTML parser
doesn't get a chance to parse it, resolve it, and go retrieve the image
to put it on the page!!!
I hope I'm wrong about this, but at this point I don't have any other
plausible theory!!
---BeginMessage---
Yes, here's the code that is retrieving news items from the database
and printing them on the page (I do some other stuff with the text
before, and after, I print it, for example, find the sentences, so I can
print complete sentences, and not just pieces of sentences). As I say,
occasionally these news items contain some HTML, e.g., the img
src=xxx statement. All of the text is being correctly retrieved
from the database and written to the page, including the img
src=xxx statement, because I see it all in the page source of the
page in my browser. However, the img src= statement is NOT
working, that is, the image does NOT appear on the page.
$result = mysql_query(SELECT * FROM newsitem ORDER BY
newsitem_date DESC);
if (mysql_num_rows($result) 0)
{
$i = 1;
while (($row = mysql_fetch_assoc($result)) ($i 6)) { ?
div id=newsitem
p?php echo $row['newsitem_date']; ?bibr / ?php $title
= $row['title']; echo $title; echo /i/bbr by ; ? ?php echo
$row['author']; echo of em; echo $row['newsservice']; ?/embrbr /
?php $newsitem_array = explode('.', $row['newsitem_text']);
$print_newsitem = $newsitem_array[0] . .;
$length_newsitem = strlen($print_newsitem);
for ($j = 1; $length_newsitem 250; $j++) {
$print_newsitem = $print_newsitem . $newsitem_array[$j] . .;
$length_newsitem = strlen($print_newsitem);
}
echo $print_newsitem;
echo br; $url_string = a href=\ . $row['url'] . \ (read
more of this article)/a; echo $url_string;
$blog_result = mysql_query(SELECT * FROM blog where discussion
= \$title\);
if (mysql_num_rows($blog_result) 0)
$not = ;
else
$not = not;
echo br; echo This news item does$not have a blog discussion
; echo nbsp;nbsp;;
if (mysql_num_rows($blog_result) 0)
echo a href=\bloglist.php?discussion=$title\Read this
item's blog/a ;
else
echo a href=\blog.php?discussion=$title\Start a discussion
on this item/a ;
$i++;
?
/pbr /
/div
?php
}
}
?
Stut wrote:
On 15 Jul 2008, at 22:36, Rod Clay wrote:
Hello. Again, I'm fairly new to php so please forgive me if my
question is a very simple or obvious one.
I've just tried testing for the first time some php code that is
pulling text out of a database to print it on the webpage. Some of
this text includes HTML, specifically in this case an img
src=x statement. Much to my surprise, this is not
working. Is there a problem with pulling HTML out of a database like
this as the page is being written?
There's no problem of course if my php code is writing the HTML to
the page - in this case, the img src=xx statement works fine
and the image is displayed. Why is it a problem when my php script
pulls the HTML code out of a database and writes it to the page from
there??
It would appear that when my php script writes HTML to the page a
process of some kind is executed to, in this case, get the image and
put it on the page. Apparently this same process is NOT executed if
the HTML is retrieved from a database and simply written to the page
from there. Is this correct? And, if it is, can anyone suggest a
workaround, another way to get done what I'm
