lundi 3 juillet 2017

Laravel checkbox implementation for updating database

I've been trying to make an attendance management system in Laravel. In the attendance view,when a checkbox is checked ,the controller function is supposed to increment the appropriate database column.

I've been having some issues.Here's my code: views:

<div class="container">
<!--<div class="row">-->
    <div class="col-md-8 col-md-offset-2">
       <div class="panel panel-default">

            <div class="panel-heading">Take Attendance</div>
            <h4><center>Teacher: </center></h4>
            <div class="form-inline">

             @foreach ($second as $sec)
                            <br>
                          <div class = "form-group">

                            
                            &nbsp&nbsp&nbsp&nbsp
                            
                            </div>
                            <div class = "form-group">
                            <!---->
                            <input tabindex="1" type="checkbox" value=""  name=""  />
                            </div>
             @endforeach

             </div>
             <br>
            <form action ="report_generate&<?php echo $name ?>" method = "post" enctype = "multipart/form-data" >
            <!--<input type = "hidden" name = "_token" value = "}"/>-->
             <div class = "form-group">
             <input type="submit" value= "Submit">
            <center><a href ="/home/report&<?php echo $name ?>">Report</a></center>
             </div>
            </form>

            </div>
    </div>
</div>

@endsection

Controller(for submit button):

public function report_generate($tabu)

{

$year = DB::table('sub')->select('Year')-
>where('sub.Subject_Name','=',$tabu)->get();

$sub_id = DB::table('sub')->select('Subject_Id')-
>where('sub.Subject_Name','=',$tabu)->get();

            ob_start();
            echo $year;
            $output=ob_get_contents();
            ob_end_clean();

            if ( $output=='[{"Year":1}]')
            {

                    $req = "first";
            }
            elseif ( $output=='[{"Year":2}]')
            {

                    $req = "second";
            }
            elseif ( $output=='[{"Year":3}]')
            {

                    $req = "third";
            }
            elseif ( $output=='[{"Year":4}]')
            {

                    $req = "fourth";
            }

            $final = DB::table($req)->get();
            //dd($final);
            //$columns = Schema::getColumnListing($req);
            //dd($sub_id);
            ob_start();
            echo $sub_id;
            //dd($sub_id);
            $va=ob_get_clean();
            $va = stripslashes($va);
            $txt = rtrim($va,"}]");
            $txt = ltrim($txt,"[{Subject_Id:");
            $txt = ltrim($txt,"Subject_Id:");
            $txt = explode(":",$txt);
            $txt = str_replace('"','', $txt);
            //dd($txt[1]);

            $columns = Schema::getColumnListing($req);
            //dd($columns);
            //dd($txt);
            foreach ($columns as $col)
            {
                    //dd("Y");
                    if($col == $txt[1])
                    {
                            $got=DB::table($req)->select($col)->get();
                            //dd($got);
                            foreach($got as $g)
                                    {

                                            //want to increment that cell value

                                    }
                    }
            }
    }



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire