Mysql - Several files in one field.

free web hosting
Open Discussion > CONTRIBUTE > The Internet > Web Design

Mysql - Several files in one field.

bluechip
Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL. I know my question may not be clear because I lack in terminology but pliz try and help. What I want to do is for axample have a database of my clients with the following fields for every client:
fname, lname, more than one photos, contrubutions(comments, jokes, testimonials posted) etc. I want to have the things like the photos in the same field but they have to be unique so that my php code can deal with them individually llike they are coming from different fields.

Reply

gogoily
I suggest you not store images into mysql database. Instead, just store the images' path into mysql. Then you can verify the images by their path.

Reply

hitmanblood
Yes gogoily is right the easiest way to store it would be in fact to store path. Another way would be to store binary data of the picture but this is harder way and probably if beginner you will fail.

The other thing is that there is already discussion about this topic on the forum however I am not able to find it now. But if you need this very much then search forums more thoughtfully and you will be able to find it. I remember that there were many more posts on this topic there.

good luck with this.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Recent Queries:-
  1. saving several text field in one mysql field - 50.33 hr back. (1)
  2. storing urls of files saved somewhere in mysql database - 151.11 hr back. (1)
  3. count * fields mysql - 397.78 hr back. (1)
  4. how to store multiple paths in mysql field - 434.55 hr back. (1)
  5. making a mysql hosted files files - 491.12 hr back. (1)
  6. remove uploaded file from mysql databse using php - 590.87 hr back. (1)
  7. count of fields mysql more than 1 field - 639.19 hr back. (1)
  8. mysql two fields in one - 703.93 hr back. (1)
  9. downloading files from mysql database using php - 764.20 hr back. (1)
  10. mysql make a field a link to another field - 800.66 hr back. (1)
  11. make one field in mysql a href - 881.16 hr back. (1)
  12. how to store 2 images in one filed mysql - 959.07 hr back. (1)
  13. how to store path in mysql - 1052.28 hr back. (1)
  14. mysql lots of fields in table - 1140.14 hr back. (1)
Similar Topics

Keywords : mysql files

  1. Import From Excel File Into Mysql Database - (11)
    Has anyone tried using the excel import function that comes with phpmyadmin
    http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
    is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
    to import the data to , there is a link on the bottom left corner which says "insert data from a
    text file into the table" - although it says text file it still can be used to import an excel file.
    When you click on this link you will be taken to a page where you will be asked for the file name
    (the...
  2. Naming Web Page Files - Which way you like- MyPage.html or my-page.html or my_page.html (9)
    Everybody talks about meta tags, keywords, good title names and how they can increase page rankings,
    etc. But I was wondering whether the page name itself holds any value in indexing. Yes, I am
    talking about the web page file names (some-thing.html) NOT the one which you put in title tags. I
    am going to express my views and want to know what you think is correct. I have seen pages named in
    various ways like these: 1) my_web_page.html 2) DoYouLikeMyPage.html 3) hey-see-my-webpage.html (I
    think this way is more appropriate) 4) this.is.a.page.html (somewhat confusing) ...
  3. Auto-upload Files With Filezilla And Autohotkey - (0)
  4. Mysql + Php Question - (5)
    Hi, I am creating a website in php and using a mysql database to store the data. I want to store
    time data in the database. My question is what is the best datatype I should use and how do I read
    the time from the database and format(display) it using php ?...
  5. Index In A Mysql Database - Make the numbers follow (3)
    I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a
    MySQL database, the 'id' field just keeps its numbers for every record, with the backdraw
    that, whenever you remove (a) record(s) from the table, you get your list numbered as eg.
    1,5,6,7,12,25 etc. This makes it a bit difficult of keeping track of the number of records in your
    table. Is there a way of achieving (either in PHPMyAdmin or through the use of PHP) that the id
    field in your table gets sort of 'refreshed and updated' so you have a clearer view...
  6. Treating .csv Files As Database Data - Showing .CSV data on a web page (2)
    I use a nice program (which I helped to beta test) called ' Simfatic Forms ' to generate
    forms on web pages. The only problem is that it does not (yet) support MySQL databases, it saves the
    form data as a .CSV file. Now I was wondering if you can do the same with a .CSV file as you do
    with a MySQL databse, ie. displaying the data in that file on a web page which adjusts automatically
    as data are added to the file. To clarify: eg. if I make a form to sign a petition online, the data
    are saved to a .CSV file every time someone fills in the form, is it now possibl...
  7. Accessing Mysql From Javascript - Javascript to communicate with database (4)
    I found a nice program which allows you to put quizzes on your web site. You can design your own
    questions, set the layout of your page, and there is also a possibility of having the results
    emailed to you. It further offers a facility to store the results and all that, all you have to do
    is put a link in the program, telling it which page takes care of that. However, when I look at the
    HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also
    uses variable names, but as I don't know any Java, I was wondering if those variab...
  8. Which Data Type To Use In Mysql Table - Using a 5 character number (4)
    If I wanted to use an ID field which automatically increments when data are addad, but displays the
    ID as a 5 figure number, which data type would I have to use? I would want a type that assigns a
    number to a record in the format "00001", "00002", etc. However, when I use "int" as datatype, it
    only displays th field contents as "1", "2" etc. So, which data type could do the job for me? i do
    not need a decimal point or anything, just an id that displays in 5 figures, including the leading
    zeros. Thanks in advance....
  9. Another Question On Mysql Table Data Type - text field for lots of text. (1)
    In my MySQL table I would like to use one text field which can contain lots of text. What I want to
    use it for is for student records, and I want to be able to add to it without destroying what is
    already there. I want the field to contain something like: ****03/11/2007**** Chopin prelude No 9:
    small problem bars 12-15. Advice given on how to practice. ****10/11/2007**** Problem in Prelude
    overcome, piece successfully completed. New piece set: Beethoven Sonata No 1, movement 1. etc. This
    is of course just an example, but that is how I want to set up my student records...
  10. What If You Forget Mysql Root Password - (2)
    If you have set a root password, but forgot what it was, you can set a new password with the
    following procedure: 1. Take down the mysqld server by sending a kill (not kill-9) to the mysqld
    server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory:
    shell> kill `cat /mysql-data-directory/hostname.pid` You must be either the Unix root user or the
    same user mysqld runs as to do this. 2. Restart mysqld with the --skip-grant-tables option. 3. Set
    a new password with the mysqladmin password command: shell> mysqladmin -u root password &...
  11. Merging Database Php Mysql - (5)
    Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's
    Classifieds they all have user sign-up login. but they have different like i need to have 3 seperate
    account for each script is there any way like mergning one user name and password would work for 3
    section. if you don't get my question please tell me i will try to explain more in detail
    thank you for your time and help ...
  12. Host Files On Other Site - (3)
    To save the disk usages of our host, we can upload files somewhere else like fileXoom or
    filelodge and any other file hosting service... but is there any filehosting service that provides
    gigabytes of space for free? If there's any, please tell... I have a lot of files to be upload
    to the net. If anyone can help me find free file host that provides 1 or 2 gigabytes of space......
  13. How Do You Combine Multiple Mysql Databases Into One Database? - (3)
    How do you combine multiple mysql databases into one database? I was thinking thta soem servers
    restrict you to one to five mysql databases. If I have a dynamic part of a table on my site, I
    would use one database for that. For every table of dynamic information, I use one database. Can I
    streamline what I am doing and combine all of my databases into one? I could make multipple tables
    in the same database. Would that work? thanks...
  14. Phpbb And Mysql Relations? - Need forum code for my website (2)
    Hi if someone could get back to me as fast as they can that would be great! i got a couple of
    questions what do you use my sql for what does that have to do with forums? and secondally can
    someone give me the php code for the forum thanks /biggrin.gif" style="vertical-align:middle"
    emoid=":D" border="0" alt="biggrin.gif" />...
  15. Syndicate Your Content Using Php And Mysql - (0)
    I just finished reading a php book, and figured out some interesting things, and wanted to share
    them with the Trap17 community. I know lot of you make websites so this could help out. Enjoy
    QUOTE Introduction So, you've spent the best part of a year creating your PHP/MySQL driven
    web site. You've got a fair amount of decent, flexible content, and you're buddies with a
    couple of other webmasters, so they've given you a free banner ad on their site in exchange for
    one on yours. Promoting your site can be even harder than developing it. I've foun...
  16. Mysql Host Adress - how do i connect (4)
    helo! hou do you? i need somebody post the data for acces my mysql database from my client.
    thanks a lot! also i need the alter code for add a foreign key to a column on a table, thanks a
    lot /blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' /> Moved to the
    appropriate section. Don't put questions in the tutorial section please. ...
  17. Php And Mysql Problem - Need a little help (8)
    hi.. i'm new in php and mysql... here is my problem.... $sql = "SELECT COUNT(*) FROM
    messages WHERE _parent={$row }"; after sending the query above i dont know how to fetch the
    actual rows counted.. i tried using the mysql_fetch_array() and mysql_fetch_row() function but it
    didnt work... actually the only function i know that fetches results from sql queries is
    mysql_fetch_array()... so what function or code i need to have the result from the query which uses
    COUNT?...
  18. Tips On Creating Your Own Search - PHP/MySQL Integrated search on your site (1)
    I'm not a professional web developer but I've learned a lot since I used Macromedia
    Dreamweaver. The latest version 8 supports PHP 5. If you select PHP as your working language, you
    can use this software to automatically add dynamic content to your website with MySQL as a
    requisite. If you have a MySQL database containing records like a songs information database, then
    you might probably not be able to add a good search page to your website which will search records
    in the database. I faced the same problem, but now I'm able to create one sophisticated datab...
  19. Mysql And Ms Access - (1)
    Can MS Access interface with mySQL? Does anyone know how to set it up? Is it even a good idea to?...
  20. Mysql Tool - (0)
    What are the best Open Source MySql developer tools?...
  21. Mysql Infos - (2)
    hello... what are the infos for the mysql databases ? Like the host, is it localhost ? and the
    username ? And what does setting up users for the databases in cpanel does ? thanks in advance...
  22. Php Tutorial - Basics...up To Mysql/file Commands - (1)
    the best way to start php is probably not adjusting a script IMO - that misses out a stage. - the
    very first stage - here... Why use php? because it allows things to be generated very quickly -
    without lots of html pages. It enables users you choose to allow, to input their own content to the
    pages you want them to. 1) save these files as anyfilename.php - pick your names, upload them to a
    php enabled server and go to the url they are at... 2) understand , .php, //////, /* */, and ;
    Code: ?> THis tells the web browser when to expect php coding. So... wh...
  23. Website Building- E-mail Forwarding & Downloads - Response Forms & downloading zip files (9)
    Hi guys, Am new to designing. How do I : 1) include a popup form on my webpage for the visitor to
    input info & have the info forwarded to my personal e-mail account (not trap17). 2) make links to
    download files (ie. zip etc.) hosted on my website for ftp direct download to the visitors computer.
    (You know, click a link & the file automatically downloads) Any info appreciated !!!
    Tutorials ????????????????? Step by step info ???????????? Thanks in advance RGPHNX...
  24. Webpage Design- Autodownloading Hosted Files - hosted "zip" file download-How To ??? (1)
    Hi Guys, Posted this inquiry over a week ago & got no replys so I'm re-posting via new thread.
    How do I setup a automatic download to a webpage visitor to my website? If I "host" (ie. store the
    file ) on my website how do I make it so that the visitor can click on a button & get the file to
    automatically download to their computer.??? This may seem obvious to youall but I'm very new
    and have no idea. All Info appreciated!!! Any Links to "How To"s ?? Tutorials ?? Thanks
    in advance RGPHNX...
  25. Another Good Place To Host Files - But not so good like the latest post (0)
    http://yousendit.com - You can host and shre your uploaded files (Up to 1 Gb) - But the link
    to download the file will be active for 7 days or 25 downloads and you can send to an email while
    you upload it. - The speed is very fast, beleave me. Maybe already some of the members know this
    free service, but know all the members will know the power of this great free service. More links
    to come, or go to my website to view them in file storage menu....
  26. Good Places To Storage Files - to share them (2)
    http://ezshare.de ezShare is a absolutely free service for hosting files without the need to
    sign-up. The whole service is ad-financed. More infos can be found in our FAQ. FAQ: 1-Klick
    Hosting at RapidTec - Frequently Asked Questions Can I embed uploaded images directly in
    HTML-files? Like every big Service in the net, we have to assure that the traffic can be paid. If
    the images are embedded directly, we have absolutely no chance to do any advertising at all. Due to
    this, the DIRECT embedding of images is not possible. Can I delete my uploaded files? Sure...
  27. A Lot Of Photoshop Templates - Just 2 zip files (0)
    Here it is: CODE http://www.buycheapwebsites.com/download/bct-psd1.zip CODE
    http://www.buycheapwebsites.com/download/bct-psd2.zip Carpe diem....
  28. Mysql Help - Oh please help a poor little girl... (8)
    Hello....I am crap at making websites and I don't even know how to use MySql. I don't even
    know what it means.OK FIRST OF ALL DON'T GIVE ME SOME WEBSITE TO GO TO because I WONT. Anyways
    the problem is well this is a page of my banner rotation websites
    http://bexchange.bexa.trap17.com/member.php and well why does it say 0: bexa_mysql ??? WTF does it
    mean ? I aint got a clue and hopefully all you computer genius' out there can help me. If you
    can't don't worry I will just pray to god for it to hopefully change it self the next time I
    go on it. ...



Looking for mysql, files, field,

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for mysql, files, field,

*MORE FROM TRAP17.COM*
advertisement



Mysql - Several files in one field.



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE