How to tell if there is a . in a number

[brown2005]

hi, i have two numbers;

$n1 = "453.23423";

$n2 = "45323423";

i want to echo

$n1 has 1 . in it
$n2 has 0 . in it

any help please...

[chronister]

[url=http://us2.php.net/manual/en/function.is-float.php]http://us2.php.net/manual/en/function.is-float.php[/url]

look at the first comment

[brown2005]

i dont think that is really what i needed, as i could have a number that has say;

435.345.34

thanks

richard

[Orio]

One of things I like about PHP (compared to C for an example), is the fact you cant treat a number both as an integer and as a string :) Use [url=http://www.php.net/strpos]strpos()[/url]

[code]<?php

if(strpos($number, ".") !== FALSE)
echo "Has a dot";
else
echo "Doesnt have";

?>[/code]

Orio.

[HuggieBear]

A regular expression and count would get you the result you're after...

[code]<?php
$string = "123.456.789";
$pattern = "/(\.)/";
if (preg_match_all($pattern, $string, $matches)){
  echo $string . " has " .count($matches[1]). " . in it";
}
else {
  echo $string . " has 0 . in it";
}
?>[/code]

Regards
Huggie

[brown2005]

Hi, yeah both of them codes are very useful, thank you very much.

What I need to do now if it is possible, is say i have a field in a table

number

i want to count the number of records in the table where a . is in it?

can this be done...?

[HuggieBear]

Do you mean in a database?

If so, then this should work...

[code]SELECT count(column_name) FROM table_name WHERE column_name LIKE '%.%';[/code]

Regards
Huggie

[chiprivers]

Back to your original question, I think a simpler way to code this would be:

[code]
<?php

$string = "123.456.789";

$str_exp = explode('.',$string);

$num = count($str_exp) - 1;

?>
[/code]

[brown2005]

Hi, Huggie, With your code, what if you want to discount duplicate entries...?

[Orio]

Just add "distinct":
[code]SELECT DISTINCT count(column_name) FROM table_name WHERE column_name LIKE '%.%'[/code]

Orio.