editing values stored in each subarray of an array

Question

I am using the following code which lets me navigate to a particular array line, and subarray line and change its value.

What i need to do however, is change the first column of all rows to BLANK or NULL, or clear them out.

How can i change the code below to accomplish this?

<?php
$row = $_GET['row'];
$nfv = $_GET['value'];
$col = $_GET['col'];

$data = file_get_contents("temp.php");
$csvpre = explode("###", $data);
$i = 0;
$j = 0;

if (isset($csvpre[$row]))
{
  $target_row = $csvpre[$row];
  $info = explode("%%", $target_row);
  if (isset($info[$col]))
  {
     $info[$col] = $nfv;
  }
  $csvpre[$row] = implode("%%", $info);
}


$save = implode("###", $csvpre);
$fh = fopen("temp.php", 'w') or die("can't open file");
fwrite($fh, $save);
fclose($fh);
?>

Artelius · Accepted Answer · 2009-11-02 23:58:33Z

4

Use foreach or array_map to perform the same action on all elements of an array.

In this case, something roughly along these lines?

foreach($rows as &$row) {
    $row[0] = NULL;
}

answered Nov 2, 2009 at 23:58

Artelius

49.3k13 gold badges94 silver badges106 bronze badges

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

2 Comments

Artelius Over a year ago

Sorry, forgot the & before $row. Fixed now.

Artelius Over a year ago

Also, if you don't mind chopping off the first array element altogether, so that $row[0] refers to what was originally $row[1], then just do array_shift($row).

pr1001 · Accepted Answer · 2009-11-02 23:56:51Z

0

I don't have a ready answer for you but I would recommend checking out CakePHP's Set class. It does things like this very well and (in some methods) supports XPath. Hopefully you can find the code you need there.

answered Nov 2, 2009 at 23:56

pr1001

22k18 gold badges84 silver badges127 bronze badges

Comments

Kevin Peno · Accepted Answer · 2009-11-03 07:43:13Z

Depending on the size of that file, this could be much more efficient than looping through:

$data = file_get_contents("temp.php"); //data = blah%%blah%%blah%%blah%%###blah%%blah%%blah
$data = preg_replace( "/^(.+?)(?=%%)/", "\\1", $data ); //Replace first column to blank
$data = preg_replace( "/(###)(.+?)(?=%%))/", "\\1", $data ); //Replace all other columns to blank

After that, write it back to the file as you did above.

This would need to be adjusted to allow for escape characters if your columns allow %% to appear consecutively within them, but other than that, this should work.

If you expect this csv file to get REALLY large, you should start thinking of looping through the file line by line rather than reading it completely into memory using file_get_contents. I would point you to fgets_csv, but I don't believe it is possible to get each csv line by any delimiter other than newline (unless you are willing to replace your ### separator with \r\n). If you end up going this way, the answer totally changes :P

For more information on Regex (specifically positive lookaheads) see Regex Tutorial - Lookahead and Lookbehind Zero-Width Assertions (also a great site for regex in general)

Collectives™ on Stack Overflow

editing values stored in each subarray of an array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related