mysql data adding problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • blossam
    New Member
    • May 2007
    • 29

    mysql data adding problem

    hello friends
    i want to add data in mysql table
    my column type is mediumtext and i want to add file of 3mb size in that column is it possible or not please help me its urgent
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    use file_get_conten ts() to read the file and then simply make INSERT statment.

    Comment

    • kovik
      Recognized Expert Top Contributor
      • Jun 2007
      • 1044

      #3
      It'd be much more efficient to upload the file to the server, and then just save the file path to the database.

      Comment

      • Moezzie
        New Member
        • Jun 2007
        • 17

        #4
        so you would recommend just having the path to the file in the database and not the hole file?

        The reason why im asking is because i have pretty much the same problem. I store my files in a longblob on a mysqldatabase but mysql tells me that the maxfilesize is 2048kb and i cant seem to find a way to make it bigger.

        Is there any way to easily change that limit or is it better to write a new phpscript to store the files somewhere else?

        Comment

        Working...