[RESOLVED] Insert if not empty

lily30

Hi all,

I am working on multi-page form that inserts/update data in three tables in mysql DB. So I have a table reports, and form field newreport (textarea) that can be empty. I would like to skip inserting into the table reports if this field is empty.

Here is what i have tried so far:

The form field is this:

 
<textarea name="newreport" id="newreport" rows="10" cols="100" ></textarea

And in the action page I have:

      $newreport=$_POST['newreport'];

  if(isset($newreport)){
  $sqlInsert="INSERT INTO reports (agreement_id, report_txt) VALUES ('$id','$newreport')"; 
  $insertExec=mysql_query($sqlInsert);                                     
   }

This is not working, the record is insert even if empty.

Please advise if you have some ideas.
Lily

Derokorian

Well you are setting the variable newreport yourself and then checking if that variable is set... try using empty()

$newreport = isset($_POST['newreport']) ? $_POST['newreport'] : '';

if( !empty($newreport) ) {
      $sqlInsert="INSERT INTO reports (agreement_id, report_txt) VALUES ('$id','$newreport')"; 
      $insertExec=mysql_query($sqlInsert);  

}

lily30

@: Thank you for your reply.

I tried your suggestion, but it didn't work. 🙁

Derokorian

Can you show the result of var_dump($_POST);

lily30

OK with:

var_dump($newreport);

I get this: string(34) " "

Derokorian

Ok so its not an empty string, it contains 34 characters (apparently all white space). try using trim when setting it:

$newreport = isset($_POST['newreport']) ? trim($_POST['newreport']) : '';

lily30

It looks like the php doesn't recognize the trim fumction or something like that...

When I do:

 $newreport = isset($_POST['newreport']) ? trim($_POST['newreport']) : '';

I still get with var_dump : string(34) " "

lily30

Oups sorry.. I get the point of the function "trim"!

It's working!!! Thank you soo much you saved me 🙂