Anyone know how to store image in mysql and display back using angular and php?

Question

I have created a web page to display image, topic and details. Just now i have a static html page this is just a page i have nothing implemented any thing.

<section class="section-02">
        <div class="container">
    <h3>
            <div class="heading-large">Current Best</div>
          </h3>
    <div class="row">
            <div class="col-md-4">
        <div class="card"> <img class="img-fluid" src="img/media-1.jpg" alt="">
                <div class="card-block">
            <div class="news-title"><a href="#">
              <h2 class=" title-small">An Alternative Form of Mental Health Care Gains a Foothold</h2>
              </a></div>
            <p class="card-text"><small class="text-time"><em>3 mins ago</em></small></p>
          </div>
              </div>
        <ul class="news-listing">
                <li><a href="#">Key Republicans sign letter warning against candidate</a></li>
                <li><a href="#">Obamacare Appears to Be Making People Healthier</a></li>
                <li><a href="#">Syria war: Why the battle for Aleppo matters</a></li>
                <li><a href="#">‘S.N.L.’ to Lose Two Longtime Cast Members</a></li>
              </ul>
      </div>
            <div class="col-md-4">
        <div class="card"> <img class="img-fluid" src="img/media-2.jpg" alt="">
                <div class="card-block">
            <div class="news-title"><a href="#">
              <h2 class=" title-small">Delta passengers got pizza delivered to the plane</h2>
              </a></div>
            <p class="card-text"><small class="text-time"><em>3 mins ago</em></small></p>
          </div>
              </div>
        <ul class="news-listing">
                <li><a href="#">Syria war: Why the battle for Aleppo matters</a></li>
                <li><a href="#">Key Republicans sign letter warning against candidate</a></li>
                <li><a href="#">Obamacare Appears to Be Making People Healthier</a></li>
                <li><a href="#">‘S.N.L.’ to Lose Two Longtime Cast Members</a></li>
              </ul>
      </div>
            <div class="col-md-4">
        <div class="card"> <img class="img-fluid" src="img/media-3.jpg" alt="">
                <div class="card-block">
            <div class="news-title"><a href="#">
              <h2 class=" title-small">Minorities Suffer From Unequal Pain Treatment</h2>
              </a></div>
            <p class="card-text"><small class="text-time"><em>3 mins ago</em></small></p>
          </div>
              </div>
        <ul class="news-listing">
                <li><a href="#">‘S.N.L.’ to Lose Two Longtime Cast Members</a></li>
                <li><a href="#">Key Republicans sign letter warning against candidate</a></li>
                <li><a href="#">Obamacare Appears to Be Making People Healthier</a></li>
                <li><a href="#">Syria war: Why the battle for Aleppo matters</a></li>
              </ul>
      </div>
          </div>
  </div>
      </section>

now i want to store this in mysql database using angular and php

Create a PHP script where you INSERT your data into your database with MySQL. And make a post call from angular to your PHP script sending the object. Try this out, then come and post what you did so far and where you are getting errors, and we can give you a hand. But we can't code for you. Cheers! ;) — SrAxi
– SrAxi, Commented May 2, 2017 at 11:17

Alex Roig · Accepted Answer · 2017-05-02 11:17:02Z

1

Although it's technically possible to store an image in a BLOB type, I totally discourage you to do it and rather use a could-based filesystem such as S3 or the local filesystem of the server. Just store on the DB the URI of the image.

Storing BLOBS in the DB will make it slower, the backups will take much longer and the queries must be optimized to avoid retrieving the BLOB. A simple SELECT * FROM users; can kill your DB if you have thousands of users.

answered May 2, 2017 at 11:17

Alex Roig

1,58412 silver badges20 bronze badges

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

6 Comments

Nasiruddin Saiyed Over a year ago

will it work with angular php mysql? if yes then how?

Alex Roig Over a year ago

Sure. To upload the photo, just POST it. Put it into a form and post the file to the backend.

Alex Roig Over a year ago

Once in PHP, then you'll need to decide where you want to store the image. Try to rename it to something random and put it to the folder where you serve the static content. Then, store on DB the random name that you generated.

Alex Roig Over a year ago

To display it back, regenerate the url to access the file, ex http://127.0.0.1/static/img/myrandomname.png

Nasiruddin Saiyed Over a year ago

thanks your idea worked. i have store image path as text in database and then retrieved in ng-repeat as ng-src="{{homes.img}}"

|

Collectives™ on Stack Overflow

Anyone know how to store image in mysql and display back using angular and php?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related