The forums have permanently moved to forum.kirupa.com. This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.


Results 1 to 8 of 8

Thread: Parse large string from flash to MySQL with PHP

  1. #1

    Parse large string from flash to MySQL with PHP

    Hey,

    I'm trying to parse some big strings containing html code to store in MySQL.
    I can't make it work. I've tried with different data types, but I think the 'text' type is the correct one to use.. different engine types as well but it don't store the whole string, just parts of it.

    It's really bad, really need help.

  2. #2
    I can't make it work
    Ambiguous at it's best.
    Care to elaborate?
    Web Design and Web Development blog
    Designer Notice: Browser List for design compatibility

  3. #3
    heh..
    I got five textfields in flash, the user write articles and can textformat the textfields as he wish. Then i wanna pull the html code from these five textfields, store it in each column in MySQL, and load them later on.

    The articles are mediumbig, but the html code makes the strings even bigger.
    Result so far: ofcourse the whole string isn't being stored, it's like it's limited.

    I've tried different store engines. now im using the deffault one "MYISAM".

    The table looks like this:
    PHP Code:
     CREATE TABLE `resor` (
    `
    idTINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `
    resaVARCHAR250 NOT NULL ,
    `
    unoMEDIUMTEXT NOT NULL ,
    `
    dosMEDIUMTEXT NOT NULL ,
    `
    tresMEDIUMTEXT NOT NULL ,
    `
    cuatroMEDIUMTEXT NOT NULL ,
    `
    cincoMEDIUMTEXT NOT NULL ,
    `
    galleriVARCHAR250 NOT NULL ,
    `
    landVARCHAR50 NOT NULL
    ENGINE MYISAM CHARACTER SET utf8 COLLATE utf8_bin 
    Important notice:
    I'm not using a local server machine..
    And i'm making the mysql queries in flash and parse them to php..

    So basically i wanna store really large html code, why should that be a problem?

  4. #4
    So the problem is the database can't store the high amount of text?
    Why not change MEDIUMTEXT to LONGTEXT?
    Web Design and Web Development blog
    Designer Notice: Browser List for design compatibility

  5. #5
    Yes i have tried that, and then tried to store the exact same article.. but it store the exact same amount.
    Weird huh?

    And the text ain't event that long.. i mean its much, but not humongous

  6. #6
    Are you using POST or GET?
    Web Design and Web Development blog
    Designer Notice: Browser List for design compatibility

  7. #7
    hm shouldn't matter?

    Anyways thanks for your help man, but silly...

    i forgot to urlencode the text when loading it so everytime there was a "&" in the article... you know the rest.

    Shouldn't be doing this when im tired.. thats it for today, im going to bed!

  8. #8
    Ahh fair enough.
    But GET / POST does make a difference.
    GET can only contain a certain amount of characters - quite a lot but not anywhere near as many as POST.
    Web Design and Web Development blog
    Designer Notice: Browser List for design compatibility

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012