Echoing PHP from Database (Widget)

[justlukeyou]

Hi,

 

I am trying add a widget to certain blog post so that it display products. Just like an image would appear. The code works fine when I paste onto a standard page but when I try to echo it from a database it displays the second peice of PHP code as it was standard text.

 

Any suggestions please?

 

<?php echo $query_row['name']; ?>

<?php

$query = mysql_query("
    SELECT name, linkname, product_id, price, discount, image_link
        FROM productdbase p
        INNER JOIN furniture_groups f
            ON
                f.id = p.id
        WHERE
            linkname LIKE '%coffee%'
    LIMIT 15");

while ($query_row = mysql_fetch_assoc($query)) { 

?>

<div class="productrangeborder">
<div class="productsdetailsborder">
<a href="http://website.co.uk/products/product/<?php echo $query_row['product_id']; ?>" class='productlink' rel="nofollow" ><?php echo $query_row['name']; ?>
</a>
</div>

<div class="productimageborder">
<a href="http://website.co.uk/products/product/<?php echo $query_row['product_id']; ?>" rel="nofollow"><img src="<?php echo $query_row['image_link']; ?>" alt="<?php echo $query_row['name']; ?>" /></a>
</div>

<div class="priceborder">Price £<?php echo $query_row['price']; ?><br /></div><div class="discountborder">Save <?php echo $query_row['discount']; ?>%<br />
</div></div>

<?php 
 }
?>

[trq]

I am trying add a widget to certain blog post so that it display products. Just like an image would appear. The code works fine when I paste onto a standard page but when I try to echo it from a database it displays the second peice of PHP code as it was standard text.

 

No kidding. Think about what you are actually doing.

 

Code is not meant to be stored in a database. Your doing it wrong.

[justlukeyou]

No kidding. Think about what you are actually doing.

 

Code is not meant to be stored in a database. Your doing it wrong.

Thanks,

 

How can I echo a 'widget' onto a pirticular blog post?

[trq]

 

 

How can I echo a 'widget' onto a pirticular blog post?

 

Far too vague a question I'm afraid.

[justlukeyou]

I want to echo products from a database in the middle of certain blog posts.

 

So if Im writing about Mario Console games I can echo "Mario" from my database into a product outlay. It works on a standard page but I need echo it on specific blog posts which are stored in my database.

[jazzman1]

What's the extension of the file? It's php or something else?

[justlukeyou]

It is echoed onto a php file.

[trq]

I want to echo products from a database in the middle of certain blog posts.

 

So if Im writing about Mario Console games I can echo "Mario" from my database into a product outlay. It works on a standard page but I need echo it on specific blog posts which are stored in my database.

 

All sorts of way of doing that. Generally though, you are just looking to replace some content with some other content as you get it from the database.

 

The basic concept is simple:

$original = "This is some test about {{foo}}, and how good it is";
$text = preg_replace_callback(
  '/\{(.*?)\}/',
  function() {
    // some logic to return "foo" from the database }
  ,
  $original
);

echo $text;

[mac_gyver]

edit: basically says the same as trq's post above (why wasn't that there when i viewed the thread?)

 

You would use a tag in the content, like a custom bbcode tag, that when the output is processed and sent to the browser, the tag would be replaced with the actual content. only the tag would be stored in the database. the actual php code that does the work would be part of your application code.

Edited August 25, 2013 by mac_gyver

[justlukeyou]

All sorts of way of doing that. Generally though, you are just looking to replace some content with some other content as you get it from the database.

 

The basic concept is simple:

$original = "This is some test about {{foo}}, and how good it is";
$text = preg_replace_callback(
  '/\{(.*?)\}/',
  function() {
    // some logic to return "foo" from the database }
  ,
  $original
);

echo $text;

 

This echoes title of the blog post regardless of whether I include the $original variable or not.

 

Are you suggesting your code goes after my code and your code echoes the existing code I readly have?

[trq]

Your not very good at this asking for help thing are you?

 

Try posting some relvant code.

[justlukeyou]

I'm trying to echo the following code from a database. I'm not sure how I can explain it any easier.

 

<?php

$query = mysql_query("
    SELECT name, linkname, product_id, price, discount, image_link
        FROM productdbase p
        INNER JOIN furniture_groups f
            ON
                f.id = p.id
        WHERE
            linkname LIKE '%coffee%'
    LIMIT 15");

while ($query_row = mysql_fetch_assoc($query)) { 

?>

<div class="productrangeborder">
<div class="productsdetailsborder">
<a href="http://website.co.uk/products/product/<?php echo $query_row['product_id']; ?>" class='productlink' rel="nofollow" ><?php echo $query_row['name']; ?>
</a>
</div>

<div class="productimageborder">
<a href="http://website.co.uk/products/product/<?php echo $query_row['product_id']; ?>" rel="nofollow"><img src="<?php echo $query_row['image_link']; ?>" alt="<?php echo $query_row['name']; ?>" /></a>
</div>

<div class="priceborder">Price £<?php echo $query_row['price']; ?><br /></div><div class="discountborder">Save <?php echo $query_row['discount']; ?>%<br />
</div></div>

<?php 
 }
?>

I dont know what this code is supposed to do. All it does is echo the title of the blog.

 

$original = "This is some test about {{foo}}, and how good it is";
$text = preg_replace_callback(
  '/\{(.*?)\}/',
  function() {
    // some logic to return "foo" from the database }
  ,
  $original
);

echo $text;

[trq]

It is an example of the logic involved, its not meant to be working code.

 

If you want someone to write code for you hire a programmer.

[justlukeyou]

Could you explain the logic and what I am supposed to do with it.

[justlukeyou]

Hi,

 

There is something seriously wrong with echoing the code from the database. I put this simple test on my page which echoes toad.

 

$test = toad;

echo $test;

?>

But when I try it in echoing it from my database it doesn't display anything. The issue is echoing the code from the database.

 

$test = toad;

echo $test;

?>

Edited August 26, 2013 by justlukeyou

[trq]

No kidding. Think about what you are actually doing.

 

Code is not meant to be stored in a database. Your doing it wrong.

[justlukeyou]

 

No kidding. Think about what you are actually doing.

 

Code is not meant to be stored in a database. Your doing it wrong.

 

 

 

What should I be doing then.  There must be a way to do this.  Every example I have seen involves storing code in the database.

[justlukeyou]

Any suggestions please?

[trq]

 

 

Every example I have seen involves storing code in the database.

 

Where the fuck are you reading?

[KevinM1]

 

"Yo dawg, I heard you like writing PHP to access your database.  So I put PHP in your database so you can write PHP code to access your database with the code that's in your database."

[justlukeyou]

Okay thanks.

 

I think I have a solution which no one has suggested.  I shall try it and let you know.