Hi all. I am having some trouble implementing my add-data.php as explained in this tutorial

My situation is that I should be able to do CRUD of data but from/to multiple tables. Following the tutorial, so far I have done the display/index.php, generate.php and the form part of add-data.php. Now, I'm stuck with the add-data.php, since everytime I add, only the second table "relation" receives input, the first one "trialindex2" does not insert my input.

Here's a part of my add-data.php:

                $total = $_POST['total'];

                for($i=1; $i<=$total; $i++)
                // gets info from the add-data FORM
                $photo_link = mysqli_real_escape_string($_POST["photo_link$i"]); //mysqli_real_escape_string to prevent msyql injection
                $last_name = mysqli_real_escape_string($_POST["last_name$i"]);  //sanitize the input by using mysql_real_escape_string
                $first_name = mysqli_real_escape_string($_POST["first_name$i"]);
                $middle_name = mysqli_real_escape_string($_POST["middle_name$i"]);  
                $sex = mysqli_real_escape_string($_POST["sex$i"]);
                $vital_status = mysqli_real_escape_string($_POST["vital_status$i"]);
                $birth_date = mysqli_real_escape_string($_POST["birth_date$i"]);
                $birth_place = mysqli_real_escape_string($_POST["birth_place$i"]);
                $death_date = mysqli_real_escape_string($_POST["death_date$i"]);
                $death_place = mysqli_real_escape_string($_POST["death_place$i"]);
                $death_cause = mysqli_real_escape_string($_POST["death_cause$i"]);

                //query here   
                $query="INSERT INTO trialindex2 (photo_link, last_name, first_name, middle_name, sex, vital_status, birth_date,                          
                birth_place, death_date, death_place, death_cause)
                "; //closing for $query

                } //closing for for

                //$person_pk= mysql_insert_id($link);

                //check if query success
                if (mysqli_query($link,$query)) //$sql = $MySQLiconn->query($sql);
                        //closing for php before if(isset)...

                        <!--script to alert success/failure to insert-->
                        alert('<?php echo $total." new record(s) inserted !!!"; ?>');
                } //closing for if
                        //closing for else php
                        alert('Error while inserting. TRY AGAIN!');
                <!--end of alert script-->

                <!--NOT SURE FOR POSITION-->           
                } //closing for else

                $last_insert_person_pk = mysql_insert_id();
                //get previous insert statement's person_pk

                //STORE RESULTS
                $result = mysqli_query("SELECT * FROM trialindex2 WHERE person_pk='$last_insert_person_pk'");

        } //closing for top if   //not sure for closing