Submit Alot Of Contents To Database

Discussion in 'PHP' started by poblo10, Oct 11, 2010.

  1. #1
    So I know how to insert data via php&mysql, but only in singular.

    I want to submit something like 1million different words to a database.(lol dont ask)

    Another thing I want to do is set a variable for each word.

    So if you can help me out that would be great.
     
    poblo10, Oct 11, 2010 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Inserting 1 million words in database is not a problem. But set variable for each word is not clear.
    variable of php you want to set to something? to what value?

    share more details with an example to give us better idea of what you want.
     
    mastermunj, Oct 11, 2010 IP
  3. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #3
    i second mastermunj
     
    bartolay13, Oct 12, 2010 IP
  4. Thorlax402

    Thorlax402 Member

    Messages:
    194
    Likes Received:
    2
    Best Answers:
    5
    Trophy Points:
    40
    #4
    It sounds like what you need to do is figure out how you want your mysql table to be structured. An example of a simple solution (that may or may not be what you need exactly), is to add it all to one table with 3 columns (id, name of variable, value of text). Of course since you are the only one that knows what you will be using these for, you are the only one who can really determine what the best format is. Once decided, it sounds like you know how to populate it accordingly.
     
    Thorlax402, Oct 12, 2010 IP
  5. poblo10

    poblo10 Peon

    Messages:
    135
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Aight I'll deal with that variable stuff later, could you give me an example or link me somewhere that could help me figure out how to submit the 1mill+ contents i need
     
    poblo10, Oct 12, 2010 IP
  6. MyVodaFone

    MyVodaFone Well-Known Member

    Messages:
    1,048
    Likes Received:
    42
    Best Answers:
    10
    Trophy Points:
    195
    #6
    Use http://www.ozerov.de/bigdump.php maybe... but as above you need to structure your database first.

    Is it just a list of words or... ?

    If you showed us an example of what the list looks like ( 10 words etc ) and then show us how you want to control the words someone could give you a better idea.
     
    MyVodaFone, Oct 12, 2010 IP