How to get the delimiter count in a For Loop in PHP

[stephenrodrics]

Hi,

I have a string in PHP I want to know the count of delimiter used in the string, is there any function in PHP to get this count in a For loop

2,7,10

I want to know the count of , used in the above string

[pbs]

try this

Code: Select all

$str = "2,7,10";
$delimiter = ",";
$str_arr = explode($delimiter, $str);
$cnt = count($str_arr) - 1;


may this work for you

[johnj]

there is a builtin function called substr_count(), take a look at that

[stephenrodrics]

try this

Code: Select all

$str = "2,7,10";
$delimiter = ",";
$str_arr = explode($delimiter, $str);
$cnt = count($str_arr) - 1;


may this work for you

thanks for the explanation it really works, now my 2nd step is to pass this no in empid field

I am using a foreach loop to update database with query



here is the code

Code: Select all

$i =1;
for each($str_arr as $element)
{
   $sql="Update testtable set empname =$dummy where empid = $str_arr[$i]";
   $i++;
   echo $i;
   echo    $sql;
}


what I have noticed is query is getting fired 4 times

Code: Select all

Update testtable set empname ='sam' where empid = 2";
Update testtable set empname ='sam' where empid = 7";
Update testtable set empname ='sam' where empid = 10";

last one is also fired where there is no value

Update testtable set empname ='sam' where empid = ";  ERROR


when I try to do this I get a error

for each($str_arr-1 as $element)

any clue on this issue, why extra query is getting fired

[johnj]

$str_arr is an array. What does $str_arr - 1 mean?

[stephenrodrics]

it reduces the array index by 1