Values from JSON encode array are not passing to the variables

Question

I have issue that i am not able to retrieve values from the json array. Below is the code which i have written.

$receiver_data=$_POST['array'];

$new_array=json_decode($receiver_data,true);

foreach($new_array as $row)
{
    $m_id='".$row["m_id"]."'; 
    $u_id='".$row["u_id"]."';
    break;
}

$query = "DELETE FROM `squads` WHERE m_id=? AND u_id=? ";
$stmt = $con->prepare($query);
$stmt->bind_param("ss", $m_id,$u_id);
$stmt->execute();

$stmt->close();

In your loop `'".$row["m_id"]."'` with single quotes is a literal value (including the variable names,quotes etc.). Juts use `$row["m_id"]` — Nigel Ren, Feb 05 '19 at 08:09

ScaisEdge · Accepted Answer · 2019-02-05T08:29:36.147

4

You don't need quote for assignments
the data binging convert properly the type (ss)

$receiver_data=$_POST['array'];

$new_array=json_decode($receiver_data,true);

foreach($new_array as $row)
{
    $m_id= $row["m_id"] ; 
    $u_id=$row["u_id"];
    break;
}

$query = "DELETE FROM `squads` WHERE m_id=? AND u_id=? ";
$stmt = $con->prepare($query);
$stmt->bind_param("ss", $m_id,$u_id);
$stmt->execute();

$stmt->close();

and if you want delete all the rows remove break and add delete code in loop

$receiver_data=$_POST['array'];

$new_array=json_decode($receiver_data,true);

$query = "DELETE FROM `squads` WHERE m_id=? AND u_id=? ";
$stmt = $con->prepare($query);

foreach($new_array as $row)
{
    $m_id= $row["m_id"] ; 
    $u_id=$row["u_id"];
    $stmt->bind_param("ss", $m_id,$u_id);
    $stmt->execute();

}

$stmt->close();

or for avoid the loop and delete just the first

$receiver_data=$_POST['array'];

$new_array=json_decode($receiver_data,true);
$m_id= new_array[0]["m_id"] ; 
$u_id=new_array[0]["u_id"];

$query = "DELETE FROM `squads` WHERE m_id=? AND u_id=? ";
$stmt = $con->prepare($query);
$stmt->bind_param("ss", $m_id,$u_id);
$stmt->execute();

$stmt->close();

edited Feb 05 '19 at 08:29

answered Feb 05 '19 at 08:05

ScaisEdge

131,976
10
91
107

Why would you put the `prepare()` etc. in the loop? – Nigel Ren Feb 05 '19 at 08:10
@NigelRen answer updated (. i was editing .. the code .. ..doing others too) – ScaisEdge Feb 05 '19 at 08:13
What if we only want to delete only very first row in JSON array? @scaisEdge – Jahanzaib Niazi Feb 05 '19 at 08:24
then just assign the value of the first rows (you could avoid the loop and break) – ScaisEdge Feb 05 '19 at 08:26
answer updated without loop – ScaisEdge Feb 05 '19 at 08:29
@scaisEdge thanks a lot for helping. – Jahanzaib Niazi Feb 05 '19 at 09:25
@JahanzaibNiazi .. you are welcome ... i hope is all clear now – ScaisEdge Feb 05 '19 at 09:26

Values from JSON encode array are not passing to the variables

1 Answers1