How are images stored in a database
Hello everyone! So I want to save pictures (photos) in my MySQL database - how does that work? How do I have to format the "picture column" in DB so that I can save the pictures (e.g. search using a form ... save picture in DB) and then retrieve the picture (s) and display them in the browser? ? Thanks in advance!! Greetings, Yuri
Answer 1 from Nessus
there you will get a lot of problems. Better go there and just save the paths in the DB, and the images in an external directory. IMHO makes the most sense.
Answer 2 from Juri M.
... and how do I do that by saving image paths in DB?
And how do I get the pictures out of a directory?
What does IMHO mean?
Thanks in advance!!
Answer 3 from vietzer
So create a column (e.g. bilder_quelle) in which you enter the path to your pictures (e.g. http://www.deinedomain.de/bilder/bild.jpg)
You can then take your picture with
P.S. IMHO = In My Humble Opinion
Answer 4 from Juri M.
First of all, thank you for the vietzer script, which helps me!
But one more thing:
1) Save path is now possible.
Now how do I do so that the script saves the path in DB AND the picture in a picture directory at the same time?
2) Question about the following script:
$ query = mysql_fetch_array (mysql_query ("SELECT * from user WHERE first name = 'Stefan'"));
if ($ query)
How can I make that if there is no picture of Stefan (Stefan is in DB) in DB, the script tells me "No picture!" issues?
Thanks in advance!!!
I would like to ask a question to the members for free:
Search in all existing articles:
- What are your favorite personal financial books
- How can I buy Bitcoin in India
- What is the World Health Organization
- How does a program learn
- How can I apply for h1b
- How is the law of Chandigarh University
- What is electrophoresis
- What are the different positions in football
- How good is the Telegram messaging app
- What worldly things do you find beautiful
- How is AOL mail forwarded to Gmail
- How is the commission for coupon sites determined
- Where should I get pizza from?
- How did Hurricane Dorian affect you
- Have any Dr. Rajkumar remade
- Which is the most honest lie of all
- The man is a math concept
- What is I S I S.
- Why did Shukracharya hate Lord Vishnu
- What is the Roman numeral for 94?
- Is thrush a sign of cancer
- How does the Eucharist affect us?
- Why do people count everything
- What is the process of artist creation
- How does blockchain process multiple parallel transactions
- What makes depressed people narrow-minded
- How can I activate Windows 7
- What is the full form of the Internet
- Do boys always get an ear infection
- What is the Japanese term for trust?
- Why do antidepressants cause tinnitus
- Who more just Palestinians or Israelis
- Which locations will minors hire?
- What Are Some Good HBO Documentaries