Array to String PHP

Question

What is the best method for converting a PHP array into a string  I have the variable  type which is an array of types     type     POST type     I want to store it as a single string in my database with each entry separated by         Sports Festivals Other

User · Answer

You can use the PHP string function implode    Like    lt  php    sports   POST  sports        festival   POST  festival       food   POST  food       array   sports  festival  food      string implode      array     echo  string    gt    If  for example   sports  football    festival  janmastami    food  biriyani    Then output would be   football janmastami biriyani  For more details on PHP implode   function refer to w3schools

User · Answer

No  you don t want to store it as a single string in your database like that   You could use serialize   but this will make your data harder to search  harder to work with  and wastes space   You could do some other encoding as well  but it s generally prone to the same problem   The whole reason you have a DB is so you can accomplish work like this trivially  You don t need a table to store arrays  you need a table that you can represent as an array   Example   id   word 1    Sports 2    Festivals 3    Classes 4    Other   You would simply select the data from the table with SQL  rather than have a table that looks like   id   word 1    Sports Festivals Classes Other   That s not how anybody designs a schema in a relational database  it totally defeats the purpose of it

User · Answer

You can use json encode     lt  php  arr   array  a    gt  1   b    gt  2   c    gt  3   d    gt  4   e    gt  5    echo json encode  arr     gt    Later just use json decode   to decode the string from your DB  Anything else is useless  JSON keeps the array relationship intact for later usage

User · Answer

The implode   function returns a string from the elements of an array   lt  php      arr   array  Hello   World    Beautiful   Day         echo implode  quot   quot   arr     gt   Output  Hello World  Beautiful Day   lt  php      arr   array  Hello   World    Beautiful   Day         echo implode  quot   quot   arr     gt   Output  Hello World  Beautiful Day

User · Answer

data   array  asdcasdc   35353   asdca353sdc   sadcasdc   sadcasdc   asdcsdcsad      string array   json encode  data     now you can insert this  string array value into Database

User · Answer

For store associative arrays you can use serialize    arr   array       a    gt  1       b    gt  2       c    gt  3     file put contents  stored-array txt   serialize  arr      And load using unserialize    arr   unserialize file get contents  stored-array txt      print r  arr     But if need creat dinamic  php files with array  for example config files   you can use var export      true    like this   Save in file    arr   array       a    gt  1       b    gt  2       c    gt  3      str   preg replace      s           1    var export  arr  true     str     lt  php    PHP EOL    return      str         file put contents  config php    str     Get array values    arr   include  config php    print r  arr

User · Answer

there are many ways    two best ways for this are   arr   array  a    gt  1   b    gt  2   c    gt  3   d    gt  4   e    gt  5   echo json encode  arr     ouputs as   a  1  b  2  c  3  d  4  e  5     b   array   m    gt   monkey    foo    gt   bar    x    gt  array   x    y    z      results   print r  b  true       results now contains output from print r

User · Answer

Use implode implode  quot   quot   type

User · Answer

One of the Best way   echo print r  array  true

User · Answer

implode      lt  php  string   implode      types     However  Incognito is right  you probably don t want to store it that way -- it s a total waste of the relational power of your database   If you re dead-set on serializing  you might also consider using json encode

User · Answer

Yet another way  PHP var export   with short array syntax  square brackets  indented 4 spaces  function varExport  expression   return   true         export   var export  expression  true        export   preg replace  quot              m quot     1 1 2    export        array   preg split  quot   r n  n  r  quot    export        array   preg replace   quot   s array s     quot    quot           quot    quot   s  gt  s   quot     null     1       gt        array        export   join PHP EOL  array filter   quot   quot      array             if   bool   return  return  export  else echo  export     Taken here

User · Answer

json encode  data    converts an array to JSON string json decode  jsonString    converts json string to php array   WHY JSON   You can use it with most of the programming languages  string created by serialize   function of php is readable in PHP only  and you will not like to store such things in your databases specially if database is shared among applications written in different programming languages

User · Answer

This one saves KEYS  amp  VALUES  function array2string  data        log a           foreach   data as  key   gt   value            if is array  value       log a         key      gt      array2string  value       n           else                     log a         key      gt     value   n             return  log a      Hope it helps someone

[php] Array to String PHP?

Examples related to php

Examples related to arrays

Examples related to string