WordPress.org

Ready to get started?Download WordPress

Forums

database in my sql. what kind of language is this?? (11 posts)

  1. freeace00
    Member
    Posted 1 year ago #

    when you put database, you can see these kind of data.
    what kinds of program language is this?

    a:2:{i:0;s:12:"checkbox1";i:1;s:15:"checkbox2";}
    a:2:{i:0;s:12:"checkbox1";i:1;s:15:"checkbox2";}

    like these... I know it's for check box. but I am not sure how it works

  2. Andrew
    Forum Moderator
    Posted 1 year ago #

    This is inside the SQL tables?

  3. mathis@Tambour
    Member
    Posted 1 year ago #

    Isn't it in a array ?
    Because i am saving my theme options in a single array and
    its looks like that :
    a:55:{s:9:"rap_width";s:4:"1200";s:12:"rap_bg_color";s:7:"#0734AF";s:10:"custom_css";s:0:"";s:12:"header_width";s:4:"1024";s:13:"header_height";s:3:"200";s:13:"title_display";s:1:"1";s:11:"title_color";s:7:"#000000";s:10:"title_size";}

  4. esmi
    Forum Moderator
    Posted 1 year ago #

    That is a serialized array.

  5. freeace00
    Member
    Posted 1 year ago #

    oh thanks guys.
    where I can study about that? I need to put my old datebase into wp tables.
    any recommendation?

  6. esmi
    Forum Moderator
    Posted 1 year ago #

    I think that would extremely difficult to accomplish manually. WordPress uses relational tables, so there may be multiple entries for a given object across two or more tables. Have you reviewed Database_Description?

  7. freeace00
    Member
    Posted 1 year ago #

    EXTREMELY???

    oh that's sad..

    I just saw it briefly. my old data base is ms-sql.

    so I decided to create tables which are same structure as wordpress(fields, columms, data types...)

    then export to CSV file and upload to my SQL tables (wp)

    the relational tables, I have seen several times and I mostly understood (but not all. so I am little worried)
    But I don't want to lose all of my contents, over 90000 data.

    the 1 of related table, has serised array data, So I am asking you guys :(
    sounds not so easy way to go :(

    what shall I do? :(

  8. esmi
    Forum Moderator
    Posted 1 year ago #

    EXTREMELY???

    Yep. Not something I'd ever want to go near with a very large bargepole. What cms were you using previously? Can it generate RSS feeds?

  9. freeace00
    Member
    Posted 1 year ago #

    I have built RSS generator but it doesn't work now.
    I am doing ASP, ms sql and my site is based on them.

    I realized my site is not good at online marketing such as SEO, RSS, SNS,, etc..

    Therefore I started studying php, my sql for WordPress which are strong at online marketing.

    I did all of them by my self for CMS. but it took really long time always. lol

    I like wordpress but my site is too big to move all of them to wordpress :(
    As you said, I will have some problems to move all of them to new site which would be wordpress.

    please advise me if you can ;) it would be a big help.

    do you want to see my site? the new one, and old one. (No pressure, if u dont need then just let it go ;)

  10. esmi
    Forum Moderator
    Posted 1 year ago #

    Have you had a look at Importing_Content?

  11. freeace00
    Member
    Posted 1 year ago #

    I have never seen most of them. but CSV looks good.
    I will read it over.

    Thanks for your help esmi :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.