PHP - Checking Variable For Null

Can someone help me to get this code working...

Code: [Select]
public function getBowlContents(){
if is_null($this->contents) {
return "The bowl is empty!";
} else {
return "The bowl contains " . $this->contents . " soup!";
}


TomTees

if ($rowcats->followersrange == "2000-5000")
    {
    $lowrange2000 = "2000";
    $lowestrange = $lowrange2000;
    $numberpeople = $rowcats->numberpeople;
    }
    if ($rowcats->followersrange == "5000-10000")
    {
    $lowrange5000 = "5000";
    if ($lowrange5000 < $lowestrange) { 
    $lowestrange = $lowrange5000; 
    $numberpeople = $rowcats->numberpeople;}
    }

    if ($rowcats->followersrange == "10000-15000")
    {
    $lowrange10000 = "10000";
    if ($lowrange10000 < $lowestrange) { 
    $lowestrange = "$lowrange10000"; 
    $numberpeople = $rowcats->numberpeople;}
    if ($lowestrange == NULL) { echo "yes";}
    echo "$lowestrange";
    }
    if ($rowcats->followersrange == "15000-20000")
    {
    $lowrange15000 = "15000";
    if ($lowrange15000 < $lowestrange) { $lowestrange = $lowrange15000;$numberpeople = $rowcats->numberpeople;}
    }

We are trying to find the lowest range from the entries added to a database, so at the end, we can say the range is FROM... TO...

They might opt for 2-5k, or 5-10k etc.

If they opt for 10-15k, then the lowest range is 10,000.

We have a result of 10000 - 15000.  So the $lowrange10000 = "10000".

Therefore, this should be echoing the $lowestrange from 7th line up in this code, but it remains at NULL, based on:

$lowestrange = NULL;, set at the top of the code.

Why is that?

Okay, so, I have a script that allows a forum inside of a room in a game.

If you want a forum, you mark Yes from a dropdown menu inside the editing portion of the room. It will then save that room's title into a field called `board` in the database.

However, when you mark No from the dropdown, it still leaves it in there. I don't want this. I want it to change to NULL.

How do I go about doing this?

Here's my current coding:


if (!islevel($p,$co)) newlevel($p,$co);
setlevel($p,$co,"title",filter(stripslashes($title)));
setlevel($p,$co,"board",filter(stripslashes($title)));
}


Explanations:
setlevel just connects to the database and inserts these values.
$title is obviously the title of the room
$co = coordinates for the room

Here is the editing page, where the dropdown menu is:


<table width=100% style=text-align:center><tr>
<td>BOARD:<br />
<select name=b>
  <option value=0>No</option>
  <option value=1 <? if ($b == 1) echo "selected"
  ?>>Yes</option></select><br />Was <?=$b?>
</tr></table>

If I do a mysql query from a database on a field that either has a number or is blank, how can I write php to check that. 

In other words, I am getting that value back into a variable called $isaresult and doing...
Code: [Select]
if ($isaresult !== '') {
//value exists
} else {
//no value yet
}
It's that first line of code that doesn't seem to be working. Should I be using "null" or something instead? 

I'm not real experienced with checking if a value exists, so let me know the proper way to do it (since I assume there are multiple ways).

Thanks!

Hi Guyz,

I need to check the variable $itemDescription to see if the client has entered a '1' before the item description(example: 1 table)

Reason, is the client would like to add sales tax to all NOn-Food related items of 6.25%

This is for a local auction house. It needs to be simple. i,e. Don't wanna add any more form fields. Just let the user type the number 1 before all items that need to be taxed.

Here's my code:
Code: [Select]
<?php
ob_start();
?>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">

</style>
</head>

<?PHP session_start();
ob_start();
# Config settings below
# Change these to whatever you want :)
#############################

$cellsPerRow = '6';

#############################
include('connect.php');

// These queries get the amount of bidders that are in the database
$getAllBidders = mysql_query("SELECT `id` FROM bidders");
$totalBidders  = mysql_num_rows($getAllBidders);


// This section is to check if the Add New Item form has been submitted
  if($_POST['addNewItem']) {
    // Retrieve Query Strings from URL
    $itemDescription = $_POST['itemDescription'];
    $itemPrice       = $_POST['itemPrice'];
    $winningBidder   = $_POST['winningBidder'];
    $totalDeals      = $_POST['totalDeals'];
    $totalPrice      = ($totalDeals*$itemPrice);

    // Check the submitted data and make sure all is correct
    if(!$itemDescription) {
      $message = 'You must enter an Item Description.';
    } else if(!$itemPrice) {
      $message = 'You must enter an Item Price.';
    } else if(!$winningBidder) {
      $message = 'You must enter a Winning Bidder ID.';
    } else if(!$totalDeals) {
      $message = 'You must enter the amount of Deals.';
    } else if(!is_numeric($winningBidder)) {
      $message = 'The Winning Bidder ID can only be numbers.';
    } else {

      // Check to see if the bidder ID already exists
      $checkBidder = mysql_query("SELECT * FROM bidders WHERE biddersId='$winningBidder' LIMIT 1");
      $checkBidder = mysql_fetch_assoc($checkBidder);

      // If the Bidder ID does not exist, we re-direct to allow us to save the Bidder ID
      if(!$checkBidder) {

        header("Location: ?action=confirmListing&iDesc=".$itemDescription."&iPrice=".$itemPrice."&wBidder=".$winningBidder."&tDeals=".$totalDeals."");

      } else {

        // If Bidder ID exists we just insert the transaction accordingly
        mysql_query("INSERT INTO transactions (`itemDescription`, `itemPrice`, `bidderId`, `itemQty`, `totalPrice`) VALUES ('$itemDescription', '$itemPrice', '$winningBidder', '$totalDeals', '$totalPrice');");
        $message1 = 'The transaction has been successfully added.';

mysql_query("SELECT owed From bidders WHERE biddersId='$winningBidder'") or die(mysql_error());
if ($row['owed']==0) {
mysql_query("UPDATE bidders SET owed='1' WHERE biddersId='$winningBidder'") or die(mysql_error()); 
}
      }

    }

  }

// This section is to check if the Add Bidder to database form has been submitted
  if($_POST['confirmBidder']) {
    $itemDescription = $_POST['itemDescription'];
    $itemPrice       = $_POST['itemPrice'];
    $winningBidder   = $_POST['winningBidder'];
    $totalDeals      = $_POST['totalDeals'];
    $totalPrice      = ($itemPrice*$totalDeals);
    $addBidder       = $_POST['addBidder'];
$checkInput= preg_match([1]+*);


if ($itemDescription== $checkInput)
$itemPrice= $itemPrice * 6.25%;

    mysql_query("INSERT INTO transactions (`itemDescription`, `itemPrice`, `bidderId`, `itemQty`, `totalPrice`) VALUES ('$itemDescription', '$itemPrice', '$winningBidder', '$totalDeals', '$totalPrice');");
    $message1 = 'The transaction has been successfully added.';

   
    if($addBidder == 'Yes') {
      mysql_query("INSERT INTO bidders (biddersId) VALUES ('$winningBidder');");
      $message1 .= '<br> The Bidder ID has also been added.';
mysql_query("SELECT owed From bidders WHERE biddersId='$winningBidder'") or die(mysql_error());
if ($row['owed']==0) {
mysql_query("UPDATE bidders SET owed='1' WHERE biddersId='$winningBidder'") or die(mysql_error()); 
}
    }
     
 if($addBidder == 'No') {
                 $message1 = '<br><font color= "red"> Bidder has NOT been logged.</font>';
               }

   // $itemDescription = '';
   // $itemPrice       = '';
   // $winningBidder   = '';
   //  $totalDeals      = '';
   // $totalPrice      = '';
   // $addBidder       = '';
      }

       

   

 

?>


<?PHP
  // This line of code will check the current task we are doing
  if($_GET['action'] == 'confirmListing') {
    $itemDescription = $_GET['iDesc'];
    $itemPrice       = $_GET['iPrice'];
    $winningBidder   = $_GET['wBidder'];
    $totalDeals      = $_GET['tDeals'];
?>

<form name="confirmBidder" method="POST" action="?">

<?PHP
// This is the hidden data from the previous form
// Better than using sessions and GET query
?>
<input type="hidden" name="itemDescription" id="itemDescription" value="<?PHP echo $itemDescription;?>">
<input type="hidden" name="itemPrice" id="itemPrice" value="<?PHP echo $itemPrice;?>">
<input type="hidden" name="winningBidder" id="winningBidder" value="<?PHP echo $winningBidder;?>">
<input type="hidden" name="totalDeals" id="totalDeals" value="1">

<table cellpadding="0" cellspacing="1" border="0" style="background: #ffffff; margin: auto;">
 <tr>
  <td colspan="2" class="formHeader"> Add New Auction Item </td>
 </tr>
 <tr>
  <td class="formField"> Add This Bidder? </td>
  <td class="formValue"> <select name="addBidder" id="addBidder" class="input" style="width: 195px;"> <option value="Yes">Yes</option> <option value="No">No</option></select> </td>
 </tr>
 <tr>
  <td colspan="2" class="formButton">
<input type="submit" name="confirmBidder" id="confirmBidder" value="Confirm Bidder Action?">
<input type="reset" name="reset" id="reset" value="Reset Form">
  </td>
 </tr>
</table>
</form>

<?PHP
  // If the action is not to confirm a listing then show add item section
  } else {
?>

<?PHP//----- Add New Item Section -----\\?>

<?PHP
  if($message) {
    echo '<div class="Error">',$message,'</div><div style="height: 10px;"></div>';
  } else if($message1) {
    echo '<div class="Success">',$message1,'</div><div style="height: 10px;"></div>';
  }
?>

<form name="addNewItem" method="POST" action="?">
<table cellpadding="0" cellspacing="1" border="0" style="background: #ffffff; margin: auto;">
 <tr>
  <td colspan="2" class="formHeader"> Add New Auction Item </td>
 </tr>
 <tr>
  <td class="formField"> Item Description </td>
  <td class="formValue"> <input type="text" name="itemDescription" class="formText" id="itemDescription" value="<?=$itemDescription;?>" style="width: 195px;"> </td>
 </tr>
<tr>
 <td class="formField"> Item Price </td>
  <td class="formValue"> <input type="text" name="itemPrice" class="formText" id="itemPrice" value="<?=$itemPrice;?>" style="width: 195px;"> </td>
 </tr>
 <tr>
  <td class="formField"> Winning Bidder ID </td>
  <td class="formValue"> <input type="text" name="winningBidder" class="formText" id="winningBidder" style="width: 195px;"> </td>
 </tr>
 <tr>
  <td class="formField"> How Many Deals? </td>
  <td class="formValue"> <input type="text" name="totalDeals" class="formText" id="totalDeals" value="1" style="width: 195px;"> </td>
 </tr>
 <tr>
  <td colspan="2" class="formButton">
<input type="submit" name="addNewItem" id="addNewItem" value="Add New Auction Item?">
<input type="reset" name="reset" id="reset" value="Reset Form">
  </td>
 </tr>
</table>
</form>

<?PHP//----- Add New Item Section -----\\?>

<?PHP } ?>


All help appreciated to the fullest...