Is there a lower limit and upper limit check function in PHP or MySQL?

Question

Is there such a function in PHP or MySQL?

function check($lower,$val, $upper)
{
if ($val>$lower && $val<$upper)
{
return $val;
}
if ($val<=$lower)
{
return $lower;
}

if ($val>=$upper)
{
return $upper;
}
}

Answer 1

I don't believe so, but there is min() and max():

function check($lower, $val, $upper) {
    return min(max($lower, $val), $upper);
}

Cheers, Tom

Answer 2

I don't know of one but you could use min() and max(). By the way - it looks like what you're really asking for is the midpoint of three integers. Either way, the code would look like:

function midValue($lowerBound, $upperBound, $value) {
   return (min($upperBound, max($lowerBound, $myValue)));
}

Answer 3

<?php

echo(check(20, 40, 50));

function check($lower,$val, $upper){
if ($val>$lower && $val<$upper){
return $val; }
else if ($val<=$lower){
return $lower;}
else if ($val>=$upper){
return $upper;}
}

Is valid php that works. I don't see much of a problem...

Answer 4

Can't think of a single function for this in MySQL, but this idiom would do the same:

GREATEST( @lower, LEAST( @val, @upper ) )

Answer 5

It may work as you intended, adding a touch of documentation, preferebly in Docbloc type format is nice to clue people in quiclkly on what you are doing. It adds a professional touch.

I guess Tom factorised your code for you.

A thumb-up for the MYSQL answer, nice! :)