JSON LOOP through Result PHP

Question

I have a Json file 'extract.json', i get content for loop through result, but my code return only one row, My script ==>

$filename  = "extract.json";
$str = file_get_contents($filename);
if($str!=null) {
    $decoded=json_decode($str,true);
    $compteur = 0;
    $compteur =  count($decoded);
    if(is_array($decoded)) {
        foreach($decoded as $value) {
            $var1= $value["val1"];
            $var2 = $value["val2"];
            $var3 = $value["val3"];
            $var4 = $value["val4"];
            $var5 = $value["val5"];....

            $injection_final = "INSERT INTO `Table`(
                `var1`,
                `var2`,
                `var3`,
                `var4`,
                `var5`,)
                VALUES
                ($var1,$var2,$var3,$var4,$var5)";
            $inj = mysqli_query($con1,$injection_final);
        }
    }
}

MY JSON FILE ==>

[{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"}...]

Suchit kumar · Accepted Answer · 2017-02-03 09:16:34Z

1

The problem is in your sql, so it should not insert even a single row. you are using dates but haven't put them in quotes.Try like below:

 $filename  = "extract.json";
    $str = file_get_contents($filename);
    if($str!=null){
        /////.....rest of your code

                 $var1= $value["val1"];
                $var2 = $value["val2"];
                $var3 = $value["val3"];
                $var4 = $value["val4"];
                $var5 = $value["val5"];

                $injection_final = "INSERT INTO Table(var1,var2,var3,var4,var5,)
                VALUES($var1,$var2,'$var3',$var4,'$var5')";
                echo $injection_final."<br>";//use this query to insert

        ......
    }

answered Feb 3, 2017 at 9:16

Suchit kumar

11.9k3 gold badges26 silver badges46 bronze badges

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

10 Comments

Suchit kumar Over a year ago

@Belicoff are you able to see the sqls echoed.

Belicoff Over a year ago

Yes of course i say it clearly brother :) but query excute only one every time :( :(

Suchit kumar Over a year ago

@Belicoff run the echoed sql directly in your phpmyadmin and see if inserted. did you check your connection string.what are you trying to return.

Belicoff Over a year ago

OOOps, i have an address with apostophe char that block the insertion, it's the error i think

Suchit kumar Over a year ago

@Belicoff in that case use mysqli_real_escape_string if you are using mysqli.

|

M A SIDDIQUI · Accepted Answer · 2017-02-03 09:25:03Z

<?php

$json_data = '[{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"},{"val1":"1","val2":"2","val3":"0000-00-00","val4":"1","val5":"1939-05-08"}]';
//uncomment the below line to read from file
//$json_data = file_get_contents("extract.json");
$array_data = json_decode($json_data, true);

for ($i = 0; $i < count($array_data); $i++) {
    $table_column_names = "";
    $table_column_values = "";
    foreach ($array_data[$i] as $coulmn_name => $field_value) {
        $table_column_names  .= "`$coulmn_name`, ";
        $table_column_values  .= "'$field_value', ";
    }
    $table_column_names = rtrim($table_column_names, ", ");
    $table_column_values = rtrim($table_column_values, ", ");
    $sql_query = "INSERT INTO `Table` ($table_column_names) VALUES ($table_column_values)";
    //excute query here -- like if i just print the query
    echo $sql_query."\n";
}

Here is what you need .. it will execute all rows Output :

INSERT INTO `Table` (`val1`, `val2`, `val3`, `val4`, `val5`) VALUES ('1', '2', '0000-00-00', '1', '1939-05-08')
INSERT INTO `Table` (`val1`, `val2`, `val3`, `val4`, `val5`) VALUES ('1', '2', '0000-00-00', '1', '1939-05-08')
INSERT INTO `Table` (`val1`, `val2`, `val3`, `val4`, `val5`) VALUES ('1', '2', '0000-00-00', '1', '1939-05-08')
INSERT INTO `Table` (`val1`, `val2`, `val3`, `val4`, `val5`) VALUES ('1', '2', '0000-00-00', '1', '1939-05-08')
INSERT INTO `Table` (`val1`, `val2`, `val3`, `val4`, `val5`) VALUES ('1', '2', '0000-00-00', '1', '1939-05-08')

I have been tried this, but the table insertion don't have a same column of my json file I want to parse some any field :)

Mohammad Mudassir · Accepted Answer · 2017-02-03 09:43:39Z

1

Simple change in this line from $var1,$var2,$var3,$var4,$var5)"; to

('$var1', '$var2', '$var3', '$var4', '$var5')";

answered Feb 3, 2017 at 9:43

Mohammad Mudassir

1516 bronze badges

Comments

Wolfack · Accepted Answer · 2017-02-03 09:19:24Z

0

The format of your JSON array is not correct. Please refer to the following link for an example:

http://www.w3schools.com/js/js_json_arrays.asp

answered Feb 3, 2017 at 9:19

Wolfack

2,8191 gold badge31 silver badges51 bronze badges

1 Comment

Suchit kumar Over a year ago

no man his json data is correct . you can check here:json.parser.online.fr (remove dots in the last).his sql is the issue.

Collectives™ on Stack Overflow

JSON LOOP through Result PHP

4 Answers 4

10 Comments

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

10 Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related