Do not save empty rows

Question

I have a table that contains a list of all products and before each one there is a field "number" in which the user will put the quantity then click on save.

This code save all rows in data base using mutiple-insert but I want that if quantite is null or empty, so do not save this row , I want just save

$managerAchat = new AchatManager($db);


if(isset($_POST['ajouter']))
{

$size = count($_POST['quantite']);

$i = 0;
while ($i < $size) 
{
if(isset($_POST['quantite'][$i]))
    {

      $nomProd = $_POST['nomProd'][$i] ;
      $prixProd = $_POST['prixProd'][$i] ;
      $quantite = $_POST['quantite'][$i] ;
      $date = date('d/m/Y');

      $AchatObject = new Achat(array(
      'nomProd' => $nomProd ,
      'prixProd' => $prixProd ,
      'quantite' => $quantite ,
      'date' => $date ,
            )) ;

      $managerAchat->insert($AchatObject);

      ++$i;
    }


}       


}

jeroen · Accepted Answer · 2014-04-16T14:51:32.130

2

It seems you just need to change:

if(isset($_POST['quantite'][$i]))

to:

if(isset($_POST['quantite'][$i]) && $_POST['quantite'][$i] > 0)

You can also use for example array_filter() to loop only over the keys that have an amount set:

if(isset($_POST['ajouter']))
{
  $has_amounts = array_filter($_POST['quantite']);
  foreach (array_keys($has_amounts) as $key)
  {
    $nomProd = $_POST['nomProd'][$key];
    // etc.

edited Apr 16 '14 at 14:51

answered Apr 16 '14 at 14:42

jeroen

91,079
21
114
132

I didn't think at this point someone would ever use code like that, much less suggest it. #empty() `:D` – php_nub_qq Apr 16 '14 at 14:44
this make an empty loop :/ – hous Apr 16 '14 at 14:46
@php_nub_qq And why is that? Using `empty()` does not solve the problem if the user enters a string like `blablabla`. Casting to a numeric value does. But in case you just want to check for empty and null values, you can use the second solution as well. Personally I would always check (probably separately) for a numerical value when talking about amounts. – jeroen Apr 16 '14 at 14:56
1

@jeroen I'm sorry I probably disregarded the datatype factor because it's been a long time since I ever had to validate data by hand, having all those fancy frameworks and what not, hehe. Cheers – php_nub_qq Apr 16 '14 at 14:58

score 0 · Answer 2 · answered Apr 16 '14 at 14:42

I'm not 100% sure this is correct as your question and code are not clear. But, you can check to see if $_POST['quantite'][$i] is empty (zero and null will both be considered empty) and skip them if they are:

if(isset($_POST['quantite'][$i]) && !empty($_POST['quantite'][$i]))

Do not save empty rows

2 Answers2