Insert data array within array in database in php

Question

I have an array followers_array and inside that I have array followers. Now I want to insert all the data in database. I have tried this but this insert only three data and not all I want to insert data of an array which contain another array.

now my table in database contain three fields id username and profile_pic_url I want to insert these data in database.I tried but it saves only three data where as I have 25 data in array.

whole code Here is my full code. please tell me where am I going wrong.

  <?php
  error_reporting(0);
  require('./vendor/autoload.php');
   $con = mysql_connect('localhost','root','') or die('Cannot connect to  the DB');
     mysql_select_db('insta',$con);
  $username = $_GET['user'];
  $pass = $_GET['pass'];

  if(!empty($pass) && !empty($username))
   {
   $i = new \InstagramAPI\Instagram(false);

  $i->setUser($username, $pass);

   if($i->settings->islogged() == false)
  {

    echo "You are not logged in.";
   }
  else
   {

    $a = $i->getUsernameId($username);

    $helper = null;
    $followers = [];

    $followers_array = array();

    do {
        if (is_null($helper)) {
            $helper = $i->getSelfUserFollowers();
        } else {
            $helper = $i->getSelfUserFollowers($helper->getNextMaxId());
        }

        $followers = array_merge($followers, $helper->getUsers());
    } while (!is_null($helper->getNextMaxId()));

    foreach ($followers as $follower) {
        $username = $follower->getUsername();
        $profie_pic_url = $follower->getProfilePicUrl();
        $id = $follower->getPk();
        $status = $i->userFriendship($id);

         $query = mysql_query("INSERT INTO `followers`  (username,profile_pic_url,follower_id)
          VALUES ('".$username."','".$profie_pic_url."','".$id."')");


       // if ($status->getFollowing() == false)
      //  {
         array_push($followers_array,array('id' => $id,'username' =>  $username,'profie_pic_url' => $profie_pic_url));
      //  }
    }
       if($query){
      echo "Data inserted </br>";
      }




   echo "<pre>";
   print_r($followers_array);



  }
 }
else
 {
     echo"username is required";
  }

 ?>

here is my table with three data.

Every time you use [the `mysql_`](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) database extension in new code **[a Kitten is strangled somewhere in the world](http://2.bp.blogspot.com/-zCT6jizimfI/UjJ5UTb_BeI/AAAAAAAACgg/AS6XCd6aNdg/s1600/luna_getting_strangled.jpg)** it is deprecated and has been for years and is gone for ever in PHP7. If you are just learning PHP, spend your energies learning the `PDO` or `mysqli` database extensions. [Start here](http://php.net/manual/en/book.pdo.php) — RiggsFolly, Jan 11 '17 at 09:12
thank you Riggs for your valuable sugesstion. I will keep in mind — Mudassar Saiyed, Jan 11 '17 at 09:13
And once you've learnt those libraries, read about [prepared statements](https://en.wikipedia.org/wiki/Prepared_statement) so that you aren't vulnerable to [SQL injection](https://en.wikipedia.org/wiki/SQL_injection). — Phylogenesis, Jan 11 '17 at 09:13
There are too many method calls to classes you must have written. There is no way we can tell from this amount of information what may have gone wrong with your data, since there cannot be any obvious syntax errors. You need to track the state of your arrays through the entire code, printing their contents out at each iteration and compare them to the expected data. — Shadow, Jan 11 '17 at 09:19
so shall i post my whole code here?? if you want I can post it here. — Mudassar Saiyed, Jan 11 '17 at 09:20
It's possible that some character in the data you're trying to insert causes the problem. Try to escape al especial characters with something like: mysqli_real_escape_string or mysql_real_escape_string (deprecated) — MarioZ, Jan 11 '17 at 10:50
still getting three values. where as i am getting all 25 value when I use print_r — Mudassar Saiyed, Jan 11 '17 at 10:54
Only 3 inserts in the database and all 25 in `$followers_array`? I would try to insert the 4th manually with Phpmyadmin to see if the sql works (if you didn't do ti yet) It's what I do to check whenever I have problems with queries. — MarioZ, Jan 11 '17 at 11:04
ok i will try your trick yes.. when I use print_r($followers_array) i get 25 data and when I insert using above script I get on three data. — Mudassar Saiyed, Jan 11 '17 at 11:11

Insert data array within array in database in php

0 Answers0