Writing an php associative array to a text file

Question

i want write an mysql_fetch_assoc(which returns an associative array) values to a text file, though i want to get the output in a manner like below

ID => 17
CODE => 4
Value => 59559

it just gets printed like follows

so this is the code that im currently using to get the result, can anybody help me on this

$query = "CALL pro_details($ID, '$start', '$end', $limit, $pos);";
        $result = mysql_query($query, $con);
        $myFile = "debug.txt";
        $fh = fopen($myFile, 'w') or die("can't open file");
        while($stringData_2 = mysql_fetch_assoc($result)){
                foreach ($stringData_2 as $string) {
                    fwrite($fh, $string);
                    $stringbreak = "\n";
                    fwrite($fh, $stringbreak);
                }
                $stringbreak = "----------------\n";
                fwrite($fh, $stringbreak);
        }
        fclose($fh);

Darren · Accepted Answer · 2014-12-04 05:09:52Z

4

Change your fwrite() call to this:

foreach ($stringData_2 as $key=>$string) {
    fwrite($fh, $key ." => ".$string);
    $stringbreak = "\n";
    fwrite($fh, $stringbreak);
}

answered Dec 4, 2014 at 5:09

Darren

13.1k4 gold badges44 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prog_Rookie Over a year ago

Darren and roulie you guys replied first and both answers works... i dont know which answer to accept :P.. u have posted aanswers on exact time

Darren Over a year ago

@user3584871 go with roullie, he posted before mine.

roullie · Accepted Answer · 2014-12-04 05:09:39Z

3

how about trying

foreach ($stringData_2 as $index => $string) {
    fwrite($fh, $index.'=>'.$string);
    $stringbreak = "\n";
    fwrite($fh, $stringbreak);
}

answered Dec 4, 2014 at 5:09

roullie

2,82019 silver badges26 bronze badges

1 Comment

Prog_Rookie Over a year ago

Darren and roulie you guys replied first and both answers works... i dont know which answer to accept :P.. u have posted aanswers on exact time

Orchid · Accepted Answer · 2014-12-04 05:22:32Z

1

In foreach loop you can get both the key and values of an array

foreach($variable as $key => $value) {
    // so that u can print both the keys and values
    $key ---> ID,code,Value
    $value ---> 12,4,59559
}

http://php.net/manual/en/control-structures.foreach.php

answered Dec 4, 2014 at 5:22

Orchid

5724 silver badges17 bronze badges

Comments

mike510a · Accepted Answer · 2014-12-04 05:31:29Z

1

    while($stringData_2 = mysql_fetch_assoc($result)){
               array_walk( $stringData_2 'displayData');


        }

...

function displayData($item, $key)
{
     fwrite($fh, "$key." => " . $item . "\n");
}

edited Dec 4, 2014 at 5:31

answered Dec 4, 2014 at 5:17

mike510a

2,1881 gold badge15 silver badges29 bronze badges

Comments

manuyd · Accepted Answer · 2014-12-04 05:37:01Z

1

You can solve like this

while($stringData_2 = mysqli_fetch_assoc($result)){
    foreach ($stringData_2 as $key=>$string) {
         fwrite($fh, $key.'=>'.$string);
         $stringbreak = "\n";fwrite($fh, $stringbreak);
    }
   $stringbreak = "----------------\n";
   fwrite($fh, $stringbreak);
}

answered Dec 4, 2014 at 5:37

manuyd

2011 silver badge8 bronze badges

Comments

abe1432181 · Accepted Answer · 2023-02-13 16:18:28Z

0

How about using serialize and unserialize?

 $array["key1"]="value1";
 $array["key2"]="value \"with\" quotes";
 $array["key3"]="value3";

 $tx=serialize($array);
 echo "<LI>serialized:".$tx;

 $test=unserialize($tx);
 foreach($test as $k=>$v) echo "<LI>rebuilt array:[$k] = [$v]";

returns

serialized:a:3:{s:4:"key1";s:6:"value1";s:4:"key2";s:19:"value "with" quotes";s:4:"key3";s:6:"value3";}
rebuilt array:[key1] = [value1]
rebuilt array:[key2] = [value "with" quotes]
rebuilt array:[key3] = [value3]

so therefore you can do the following:

file_put_contents($fn, serialize($array1));
.
.
.
$array2=unserialize(file_get_contents($fn));

answered Feb 13, 2023 at 16:18

abe1432181

1,4342 gold badges15 silver badges36 bronze badges

Collectives™ on Stack Overflow

Writing an php associative array to a text file

6 Answers 6

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related