232 votes

2 answers

html - How i can display blob elements is same row with php?

Get the solution ↓↓↓

I want to display images in same row,but i can display only under each other. I tried in css display: inline-block; but dont working. Any idea what i need to do? Thanks

The code for display images:

require_once 'dbConfig.php'; 

$result = $db->query("SELECT image FROM images ORDER BY uploaded DESC"); 
?>

<?php if($result->num_rows > 0){ ?> 

    <div class="row">
    <div class="col-sm-6 col-md-4 col-lg-3" >
    <a class="lightbox">

    <?php while($row = $result->fetch_assoc()){ 


    echo '<img src="data:image/jpeg;base64,'.base64_encode($row['image']).'" width="250", " height="250">';}?>



<?php }else{ ?> 
    <p class="status error">Image(s) not found...</p> 
<?php } ?>  


</a>    
</div>  
</div>
Copy code

Undefined asked

2021-12-1

Write your answer

---

65

votes

Answer

Solution:

It's because you large col is only 3. Inspect element result

if you are using these images for lightbox thumbnail I would suggest d-flex rather than column system....

Write your answer

---

840

votes

Answer

Solution:

Try this code it will work .. now it will loop your columns as well

require_once 'dbConfig.php'; 

$result = $db->query("SELECT image FROM images ORDER BY uploaded DESC"); 
?>

<?php if($result->num_rows > 0){ ?> 

    <div class="row">
    

    <?php while($row = $result->fetch_assoc()){ 

    <div class="col-sm-6 col-md-4 col-lg-3" >
    <a class="lightbox">
    echo '<img src="data:image/jpeg;base64,'.base64_encode($row['image']).'" width="250", " height="250">';}?>

</a>    
</div> 

<?php }else{ ?> 
    <p class="status error">Image(s) not found...</p> 
<?php } ?>  


 
</div>Copy code

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-1

Link To Source
Link To Answer People are also looking for solutions of the problem: call to a member function getclientoriginalname() on null

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

27 php,mysql,html - Display SQL query(conjunction) properly in HTML

294 Is this an acceptable way to autoload html pages with php?

185 php - How can I simplify this array?

473 php - Is AHAH a security risk?

24 php - Magento import - Skip row sku is not defined

639 soap - Is it possible to specify the outgoing network interface to use for a PHP SoapClient?

915 php - More efficient way to grab MySQL row populated with single value

505 php - How to read value from HTML text input?

805 installation - How to install PHP in IIS 7.5, Windows Server 2008 R2 (64bits)

465 php - File format or extension invalid PHPExcel

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

CSS

CSS (Cascading Style Sheets) is a formal language for describing the appearance of a document written using a markup language. It is mainly used as a means of describing, decorating the appearance of web pages written using HTML and XHTML markup languages, but can also be applied to any XML documents, such as SVG or XUL.
https://www.w3.org/TR/CSS/#css

HTML

HTML (English "hyper text markup language" - hypertext markup language) is a special markup language that is used to create sites on the Internet. Browsers understand html perfectly and can interpret it in an understandable way. In general, any page on the site is html-code, which the browser translates into a user-friendly form. By the way, the code of any page is available to everyone.
https://www.w3.org/html/