PHP function fetching array value

Question

I had this data (refer 2nd image below) and php function that fetch those data's then insert into the database. Somehow the function not manage to insert $outletID, it manage to loop 3 times and data insert into it, but at column outletID it insert Array as a value. Any idea what Im doing wrong here?

function addRevenueAccounts(){
  global $Obj;  
  $recipeTypeID = (isset($_POST['recipeTypeID']) ? $_POST['recipeTypeID'] : '');
  $outletID     = (isset($_POST['outletID']) ? $_POST['outletID'] : ''); 
  $accountID    = (isset($_POST['accountID']) ? $_POST['accountID'] : '');

  $countOutletID = sizeof($outletID);
  for($x=0; $x< $countOutletID; $x++ ){

    $revenueAccountID = $Obj->GENERATE_PK("tblAccRevenueAccounts");
    $sqlAdd = "INSERT INTO tblAccRevenueAccounts
              SET revenueAccountID = '".$revenueAccountID."',
              outletID = '".$outletID[$x]."',
              accountID = '".$accountID."',
              recipeTypeID = '".$recipeTypeID."',
              dateTimeEmployee = NOW(),
              active = 'y' ";
    $Obj->ExecuteData($sqlAdd, $Obj->DEFAULT_PDO_CONNECTIONS); 
  }   
}

how is that data generated? That is a very unusual structure — Professor Abronsius, Oct 23 '19 at 07:14
You should look into using prepared statements, but you seem to be using some library for your SQL so not sure how this would be supported. — Nigel Ren, Oct 23 '19 at 07:15
@RamRaider im using Kendo Ui grid form. And one of the grid column can be select more than one value. When submit it sent those structure — dontbannedmeagain, Oct 23 '19 at 07:19
"Sometimes" looks strange. What have you tried to debug the problem? — Nico Haase, Oct 23 '19 at 07:35

score 1 · Answer 1 · answered Oct 23 '19 at 07:14

1

You need to use $outletID[$x]['OutletID'], otherways you'll get whole array (outletID, outletName, index, checked, ...)

answered Oct 23 '19 at 07:14

Pavel Třupek

898
6
19

score 1 · Answer 2 · answered Oct 23 '19 at 07:34

Your structure is a bit weird, but your naming convention is weirder. Anyway updated code below (you where inserting the whole array into the database):

$sqlAdd = "INSERT INTO tblAccRevenueAccounts
          SET revenueAccountID = '".$revenueAccountID."',
          outletID = '".$outletID[$x]['outletID']."',
          accountID = '".$accountID."',
          recipeTypeID = '".$recipeTypeID."',
          dateTimeEmployee = NOW(),
          active = 'y' ";

PS: Posted from phone, no code formatting available! ( why!? )

PHP function fetching array value

2 Answers2