counting with str_replace()

ali_p

Hello,

Heres what i am trying to do :
I have a field with characters seperated by * and i want to count every character in the field of the table. I saw that with php 5 you can do this by adding $count. Anybody know of a work aroung for php 4?

Heres some code to make things clearer


$sql = "SELECT *
		FROM jobs_new";
$result2 = mysql_query($sql, $conn)or die(mysql_error());

while ($row = mysql_fetch_array($result2)) {

$division = str_replace("*","<br>", $row['division_new']);

$display .="$division<br>";

Thanks in advance

jernhenrik

There are many ways to do this. You could use substr_count, checking the $row['division'] for occurences of * and subtract this from the strlen of the $row.

or alternatively do something like this:

<?php
$str = "t*hi*s* is* a* te*s*t*";//this is your row from mysql
$cnt = 0;
$display = '';

for ($i = 0; $i < strlen($str); $i++)
{
	if($str[$i]!="*")
	{
		$display .= $str[$i]."<br/>";
		$cnt++;
	}
}
echo $cnt.'<br/>';
echo $display;
?>

ali_p

Thank you jernhenrik,

Perfect I think this will work for me , although i'm concerned that if my field contains AL1LS, the 1L will get counted twice because there are 2 characters. Is your code counting between the or is it counting individual characters that remain?

Thanks

jernhenrik

It's counting the number of characters that are not . If you wish to count the number of elements separated by an you could do something like:

<?php
$str = "A*L*1L*S";//this is your row from mysql
$cnt = 0;
$display = '';

$arr = explode("*",$str);
foreach ($arr as $value)
{
	$display .= $value.'<br/>';
	$cnt++;
}

echo 'no of elements separated by *: '.$cnt.'<br/><br/>';
echo $display;
?>

This is just an example, you can substitute counting the number of elements in the array with count() and you can concatenate your string display with an implode().