Adding PHP to background-image url

Question

This is what I have so far but it's not working. This is my css:

background-image: url("upload/blog/'.$row["urlImg"].'");

Here is the full code:

<?php 
  $stmt = $db->query
  ( 'SELECT blog.postID, blog.postTitle, blog.postSlug, blog.postDesc, blog.urlImg, blog.postTags, blog.postDate
     FROM blog, blog_post_cats
     WHERE blog.postID = blog_post_cats.postID AND blog_post_cats.catID = 4 ORDER BY postID DESC LIMIT 1'
  ); 
  while($row = $stmt->fetch())
  {
    echo '<article style="background-image: url(upload/blog/'.$row['urlImg'].'" );"> '; 
  }
?>

This PHP echo does not work.

clicke to view output screenshot ,the blank space is the error ,others are url images

Did you forget to add your code? 😅 Please edit your question. — grooveplex
– grooveplex, Commented Feb 1, 2019 at 23:58
You need to edit your question to also show how you get $row["urlImg"] If its returning blank then the query (assuming since you are using $row) maybe be returning blank or you might be fetching it wrong — Second2None
– Second2None, Commented Feb 2, 2019 at 0:03
The first code snippet and the "full" code differ from each other. Unclear what is what. — Pinke Helga
– Pinke Helga, Commented Feb 2, 2019 at 0:12
Can you show us the html displayed on output when it "doesn't work" — Ice76
– Ice76, Commented Feb 2, 2019 at 0:45

Pinke Helga · Accepted Answer · 2019-02-02 01:27:43Z

3

Since you try to use double quotes in inline CSS, you actually are closing the HTML attribute style="background-image: url(". Use single quotes in this case of nested quotes. Rather than escaping single quotes in single-qouted echo strings, just close <?php ?> tags and write plain HTML.

<?php
  while($row = $stmt->fetch())
  {
?>
    <article class="latestPost excerpt big-1" style="background-image: url('upload/blog/<?php echo $row["urlImg"];?>');">

    </article>
<?php
  }

edited Feb 2, 2019 at 1:27

answered Feb 2, 2019 at 0:46

Pinke Helga

6,7622 gold badges25 silver badges46 bronze badges

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

2 Comments

zhak Over a year ago

i cannot us that simply because the code is run inside a query

<?php $stmt = $db->query('     SELECT          blog.postID, blog.postTitle, blog.postSlug, blog.postDesc, blog.urlImg, blog.postTags, blog.postDate      FROM          blog,         blog_post_cats     WHERE          blog.postID = blog_post_cats.postID          AND blog_post_cats.catID = 4     ORDER BY          postID DESC LIMIT 1     '); 				while($row = $stmt->fetch()){ echo '<article style="background-image: url(upload/blog/'.$row['urlImg'].'");">                 '; ?>

Pinke Helga Over a year ago

What is the problem? You can close and reopen PHP tags almost everywhere.

Johannes · Accepted Answer · 2019-02-02 01:00:03Z

1

The problem are the double-quotes around the URL of the background image. The double quote after url( closes the style atrribute it's part of. So you should use escaped quotes inside the url(...) parenthesis:

echo '<article class="latestPost excerpt big-1" style="background-image: url(\"upload/blog/'.$row["urlImg"].'\");"> ';

answered Feb 2, 2019 at 1:00

Johannes

67.9k22 gold badges84 silver badges139 bronze badges

Comments

Abdul Hannan · Accepted Answer · 2019-02-02 01:46:04Z

0

Use double quote here...

     echo '<article style="background-image: url(upload/blog/'.$row["urlImg"].'");"> ';

enter image description here

answered Feb 2, 2019 at 1:46

Abdul Hannan

1

Comments

zhak · Accepted Answer · 2019-02-10 23:56:16Z

0

thank y'all for your contributions

i got this myself

i just added my website address to it @https://mywebsite.com/upload/blog/...

 echo '<article style="background-image: url(https://mywebsite.com/upload/blog/'.$row["urlImg"].'");"> ';

answered Feb 10, 2019 at 23:56

zhak

211 silver badge6 bronze badges

Collectives™ on Stack Overflow

Adding PHP to background-image url

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related