data extraction from databse issue

Discussion in 'PHP' started by aleale, Dec 16, 2011.

  1. #1
    My db table has columns "id" (int-11), "date(varchar-50)", "author name(varchar-100)", "text (varchar-100000)"...
    I am storing images + text in text field of database. Everything is going fine while i am using ckeditor to insert data into the database for that particular text field.
    Now when i am retrieving data from database... i am able to extract id, date, autorname successfully (i have check it while the issue came)..but when i am trying to retrieve text field which have image, that jumps to page not found error...

    what could be the issue... am i having problem with database or editor that i am using????
     
    aleale, Dec 16, 2011 IP
  2. dujmovicv

    dujmovicv Member

    Messages:
    62
    Likes Received:
    2
    Best Answers:
    4
    Trophy Points:
    48
    #2
    Can you post the PHP code which is used to retrieve/display the result?
    Are you storing the path to the image on the disk in the text field or what?
     
    dujmovicv, Dec 16, 2011 IP
  3. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #3
    You're storing an image in a text field? That could cause a problem. What kind of database is this?
     
    Rukbat, Dec 16, 2011 IP
  4. aleale

    aleale Well-Known Member

    Messages:
    1,453
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    130
    #4
    i am not storing image on that field.. the scr attribute (url) is storing on that field...... When i am inserting only text on that field it is easily stored and page is easily shown but when i am storing image which is store as URL of that data causing issue....
     
    aleale, Dec 16, 2011 IP
  5. dujmovicv

    dujmovicv Member

    Messages:
    62
    Likes Received:
    2
    Best Answers:
    4
    Trophy Points:
    48
    #5
    What type of issue? Can you please post the part of the code which suppose to show those database entries? Try to be more specific when asking for help in PHP...
     
    dujmovicv, Dec 18, 2011 IP