If database field is empty, how to show on form "empty"

Discussion in 'PHP' started by Matt Ridge, Nov 21, 2011.

  1. #1
    What I am looking for is that if any field in a database is empty, the form comes back and puts in the word "empty" into the web page, but not the database.

    Would it look something like this?

    
    <?php
          if (!empty($row['Added_By'])) {
    		echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span>' . $row['Added_By'] . '</div>';
    
          else
            if (empty($row['Added_By'])) {
                   echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span><p>empty</p></div>';
    ?>
    
    Code (markup):
     
    Matt Ridge, Nov 21, 2011 IP
  2. kentIT

    kentIT Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    plz try code bellow
    
    <?php
          $added_by = $row['Added_By'];
          if (isset($added_by))
          {
              echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span>' . $added_by. '</div>';
         }else{
                   echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span><p>empty</p></div>';
        }
    ?>
    
    Code (markup):
     
    kentIT, Nov 21, 2011 IP
  3. Matt Ridge

    Matt Ridge Peon

    Messages:
    166
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Ok, I got this, it shows the first part fine, but the second part it doesn't show the "Empty" comment... I don't understand why... as far as I can tell the code is fine...

    <?php
    			//Nonconformity, Disposition, Comments and Comments & Additional Details
    			echo '<div id="box3">';
    				if (!empty($row['Nonconformity']) || !empty($row['Disposition']) || !empty($row['Comments']) || !empty($row['CommentsAdditional_Details'])) {
    					echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />' . $row['Nonconformity'] . '</div>';
    					echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br />' . $row['Disposition'] . '</div>';
    					echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br />' . $row['Comments'] . '</div>';
    					echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />' . $row['CommentsAdditional_Details'] . '</div>';}
    						else
    							if (empty($row['Nonconformity']) || empty($row['Disposition']) || empty($row['Comments']) || empty($row['CommentsAdditional_Details'])) {
    								echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />Empty</div>';
    								echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;<br /></span>Empty</div>';
    								echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;<br /></span>Empty</div>';
    								echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />Empty</div>';}
    			echo '</div>';
    ?>
    Code (markup):
     
    Matt Ridge, Nov 21, 2011 IP
  4. kentIT

    kentIT Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    you need check condition in code...
    set variable for array each $row and default value is Empty for all, example
    
    $Nonconformity = "Empty";
    if(isset($row['Nonconformity']))$Nonconformity = $row['Nonconformity'];
    
    PHP:

    And each array like
    So you just need echo
    
    echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />' .$Nonconformity. '</div>';
    
    PHP:
     
    kentIT, Nov 21, 2011 IP
  5. Matt Ridge

    Matt Ridge Peon

    Messages:
    166
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #5
    But what if one isn't empty? Because Nonconformity is not empty... I want it to show full fields, and put empty where they are.
     
    Matt Ridge, Nov 21, 2011 IP
  6. kentIT

    kentIT Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    plz check code bellow
    
    <?php
    //Nonconformity, Disposition, Comments and Comments & Additional Details
    //Assign default Nonconformity, Disposition, Comments, Additional Details
    $Nonconformity = "Empty";
    $Disposition = "Empty";
    $Comments = "Empty";
    $CommentsAdditional_Details = "Empty";
    // Check Array of valiable $row['Nonconformity'] if not empty assigned value to $Nonconformity
    if(isset($row['Nonconformity'])) $Nonconformity = $row['Nonconformity']; // Valiable $Nonconformity have value of array $row['Nonconformity']
    // Check Array of valiable $row['Disposition'] if not empty assigned value to $Disposition
    if(isset($row['Disposition'])) $Disposition = $row['Disposition']; // Valiable $Disposition have value of array $row['Disposition']
    // Check Array of valiable $row['Comments'] if not empty assigned value to $Comments
    if(isset($row['Comments'])) $Comments = $row['Comments'];// Valiable $Comments have value of array $row['Comments']
    // Check Array of valiable $row['CommentsAdditional_Details'] if not empty assigned value to $CommentsAdditional_Details
    if(isset($row['CommentsAdditional_Details'])) $CommentsAdditional_Details = $row['CommentsAdditional_Details']; // Valiable $CommentsAdditional_Details have value of array $row['CommentsAdditional_Details']
    echo '<div id="box3">';    echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />' . $Nonconformity . '</div>';
        echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br />' . $Disposition . '</div>';
        echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br />' . $Comments . '</div>';
        echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />' . $CommentsAdditional_Details . '</div>';
    echo '</div>';?>
    PHP:
    You should read the notes clearly
     
    kentIT, Nov 22, 2011 IP
  7. Matt Ridge

    Matt Ridge Peon

    Messages:
    166
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #7
    Thanks, but you really didn't answer my question. I did find it elsewhere though.
     
    Matt Ridge, Nov 22, 2011 IP