PHP foreach loop if POST value is not empty

Question

I have this PHP loop:

foreach($_POST['af_break_date'] as $id=>$value) {
    $update_break_date_query = "UPDATE studentdates SET student_break_date = '$value' WHERE student_date_id = '$id';";
    $update_break_date_sql = mysql_query($update_break_date_query) or die(mysql_error());
}

I want to run the $update_break_date_sql only if each $_POST['af_break_date'] is not null.

How can this be done?

there is no such thing as NULL value from postdata as far as I can tell - are those checkboxes you're posting? — Zathrus Writer
– Zathrus Writer, Commented Nov 30, 2012 at 12:35

MrCode · Accepted Answer · 2012-11-30 12:36:15Z

4

foreach($_POST['af_break_date'] as $id=>$value)
{
    if($value != '')
    {
        $update_break_date_query = "UPDATE studentdates SET student_break_date = '$value' WHERE student_date_id = '$id';";
        $update_break_date_sql = mysql_query($update_break_date_query) or die(mysql_error());
    }
 }

Don't forget to secure for SQL Injection because you are adding raw user input to the query. Have a look at PDO or MySQLi and parameterised queries.

answered Nov 30, 2012 at 12:36

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

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

2 Comments

David Over a year ago

Thank you! How did I not think of this... Anyway, solved my problem!

David Over a year ago

I will, but I have to wait a few minutes to do so.

arun · Accepted Answer · 2012-11-30 12:41:35Z

1

use isset

if(isset($_POST['af_break_date'] && 
strlen(implode("",$_POST['af_break_date']))>0)
{
....
...
}

edited Nov 30, 2012 at 12:41

answered Nov 30, 2012 at 12:35

arun

3,6773 gold badges32 silver badges54 bronze badges

1 Comment

David Over a year ago

Yes I tried that already, but the af_break_date will always POST and then empty data will be sent to the MySQL, I want to prevent that.

som · Accepted Answer · 2012-11-30 12:38:38Z

0

if( isset( $_POST['af_break_date'] ) && is_array(  $_POST['af_break_date'] )) {
    foreach($_POST['af_break_date'] as $id=>$value) {
        $update_break_date_query = "UPDATE studentdates SET student_break_date = '$value' WHERE student_date_id = '$id';";
        $update_break_date_sql = mysql_query($update_break_date_query) or die(mysql_error());
    }
}

answered Nov 30, 2012 at 12:38

som

4,6542 gold badges23 silver badges36 bronze badges

Comments

Nikita Melnikov · Accepted Answer · 2012-11-30 12:40:28Z

0

Use !empty();

For Example

$value = false;

isset($value); //return true
!empty($value); //return false

answered Nov 30, 2012 at 12:40

Nikita Melnikov

2091 silver badge8 bronze badges

Comments

Muthu Kumaran · Accepted Answer · 2012-11-30 12:40:40Z

0

Just add a condition to check & avoid empty values

if($_POST['af_break_date']){
    foreach($_POST['af_break_date'] as $id=>$value) {
      if(!$value) continue;
      $update_break_date_query = "UPDATE studentdates SET student_break_date = '$value' WHERE student_date_id = '$id';";
      $update_break_date_sql = mysql_query($update_break_date_query) or die(mysql_error());
    }
}

Don't use mysql_* functions, they will be deprecated soon. Instead use mysqli or PDO for connecting database. Use prepared statements to avoid SQL injections and before that do validations before updating datas to database.

answered Nov 30, 2012 at 12:40

Muthu Kumaran

18k5 gold badges50 silver badges72 bronze badges

Comments

Kodemon · Accepted Answer · 2012-11-30 12:42:19Z

0

Alternative to isset is empty which will check if the array is empty, so since its always being posted we check if its empty before running the foreach loop.

if (!empty($_POST['af_break_date']) && is_array($_POST['af_break_date'])) {
    foreach($_POST['af_break_date'] as $id=>$value) {
        $update_break_date_sql = mysql_query("UPDATE studentdates SET student_break_date = '$value' WHERE student_date_id = '$id'") or die(mysql_error());
    }
}

answered Nov 30, 2012 at 12:42

Kodemon

3702 silver badges11 bronze badges

Collectives™ on Stack Overflow

PHP foreach loop if POST value is not empty

6 Answers 6

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related