Query field if empty

Question

What should be the logic for the function below?

function check_empty($field){
  $this->_params();
  $db = $this->getDb();
  $milestone = $db->select()
    ->from('milestone')
    ->where("$field IN ('')")
    ->where("name = ?", $this->milestone['name']);

  $milestone_stmt = $db->query($milestone);
  echo $milestone->__toString();
  $milestone_result = $milestone_stmt->fetchAll();

  if(count($milestone_result) > 0) {
    return true;
  } else {
    return false;
  }
}

This is the function used to check if a field is empty. If the field is originally field and updated with the contents removed in a form the other function should insert a form but it is not inserting.

Nope i meant that you have asked 6 questions, but you haven't accepted any of answers. On the top-left of every answers, you have tick icon. Click there if you think that was the right answer for your question. — S L
– S L, Commented Apr 1, 2011 at 5:01

chriso · Accepted Answer · 2011-04-02 01:45:41Z

1

The query will return true if it can't match any rows, false otherwise:

function check_empty($field) {
    $this->_params();
    $db = $this->getDb();
    $milestone = $db->select()
                    ->from('milestone')
                    ->where("$field = ''")
                    ->where("name = ?", $this->milestone['name']);
    $milestone_stmt = $db->query($milestone);

    //No query results means the field is not empty.
    return $milestone_stmt === false;
}

edited Apr 2, 2011 at 1:45

answered Apr 1, 2011 at 4:26

chriso

2,5421 gold badge20 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Efox Over a year ago

Will there be a possibility that there is a result which is not null or a special character or something?

chriso Over a year ago

@efox it'll either be a statement or false. The expression milestone_stmt === false will return false if $milestone_stmt is anything other than false

Collectives™ on Stack Overflow

Query field if empty

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related