Jump to content

forumnz

Members
  • Posts

    735
  • Joined

  • Last visited

Posts posted by forumnz

  1. Thanks Ken2k7

     

    I modified one of your lines to read:

    <?php
    $e = '[{"field3":66,"field4":5,"field1":"ggg","field2":"g","field5":"h","field6":"h","field7":"hh","id":"1"},{"field3":66,"field4":5,"field1":"ggg","field2":"g","field5":"h","field6":"h","field7":"hh","id":"1"}]';
    ?>

    Which is basically 2 sets of data.

     

    And the output is:

    array(2) { [0]=>  array( { ["field3"]=>  int(66) ["field4"]=>  int(5) ["field1"]=>  string(3) "ggg" ["field2"]=>  string(1) "g" ["field5"]=>  string(1) "h" ["field6"]=>  string(1) "h" ["field7"]=>  string(2) "hh" ["id"]=>  string(1) "1" } [1]=>  array( { ["field3"]=>  int(66) ["field4"]=>  int(5) ["field1"]=>  string(3) "ggg" ["field2"]=>  string(1) "g" ["field5"]=>  string(1) "h" ["field6"]=>  string(1) "h" ["field7"]=>  string(2) "hh" ["id"]=>  string(1) "1" } } 

     

    Which is fine (I believe). What would I need to do now?

     

    Much appreciated :)

  2. This is what I have for the quotes problem:

    <?php
    $str = $data;
    $str = substr($str, 1, strlen($str) - 2);
    
    $str = preg_replace("/([a-zA-Z0-9_]+?):/" , "\"$1\":", $str); // fix left side
    $str = preg_replace("/:(^false^true[a-zA-Z_]+[a-zA-Z0-9_]*)/", ":\"$1\"", $str); // fix right side 
      
      
    $data = json_decode($str, true);
    
    
    $data = print_r($data);
    ?>

     

    Still returns 1 though..?

    Why would that be?

     

    I do want to store them in a database but I need to get the data into an array for that don't I?

  3. Hey

     

    I have a JS script that POSTs this:

    [{"field3":66,"field4":5,"field1":"ggg","field2":"g","field5":"h","field6":"h","field7":"hh","id":"1"},{"field2":"cgh","field4":73377,"field3":770}]

    to a PHP file.

     

    What can I do to insert that information into a database?

    Note that the data between {} is it's own row.

     

    Basically, how can I get that into some sort of suitable array?

  4. Thanks xenophobia - it helps a lot.

     

    How can I rearrange the output to suit?

    Currently it is:

    Array ( [0] => stdClass Object ( [field1] => a [field2] => b ) [1] => stdClass Object ( [field1] => a2 [field2] => b2  ) )

     

    Thanks :)

  5. How can I separate these sets of data in this array so that they can be inserted into a database?

     

    Array ( [0] => stdClass Object ( [field1] => a [field2] => b ) [1] => stdClass Object ( [field1] => a2 [field2] => b2  ) ) 

     

    Would I use the [0] and [1]? Sorry for the question, but if someone can point me in the right direction I am more than happy to try to work it out for myself :)

     

    Thank you :)

  6. Thanks but what I meant was that the JS posts the data, and the output is as above. I think I may have to refer to the JS, but what would I need to write in the PHP form, to 'retrieve' the POSTed data and put it into a variable?

     

    :)

  7. I have a script that outputs data like this:

     

    {success: true, data: [{"id":"1","fld1":"text","fld2":"text","fld3":"text","fld4":"text","fld5":"text","fld6":"text","fld7":"text","fld8":"text"}, {"id":"2","fld1":"text","fld2":"text","fld3":"text","fld4":"text","fld5":"text","fld6":"text","fld7":"text","fld8":"text"}], 
    form: {"fld9":"text","fld10":"text","fld11":"text","fld12":"text"}}

     

    How can turn that first part of it (the lines that start with id) into an array?

     

    Thanks a lot :)

  8. I get this error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to, date, due_date, inv_number, ref, tax_incl) VALUES ('e878dca5c96oa38a815cf915' at line 1

     

    And this is the code:

    <?php
    mysql_query("INSERT INTO table (hash_key, inv_key, to, date, due_date, inv_number, ref, tax_incl) VALUES ('$hk', '$ik', '$to', '$date', '$due', '$inv_num', '$ref', '$tax')")or die(mysql_error());
    ?>

     

    What's wrong with it?

    Thanks :D

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.