insert multiple table rows via a php into mysql

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • help insert multiple table rows via a php into mysql

    I am inserting multiple line values from a html table form in to sql but it's only inserting the last table form value in my database. I can't figure out where the problem is.
    Can you help me out with this?
    This is my PHP:


    $result = mysql_query("SELECT * FROM ex_marks WHERE session='$session' and cl_name='$cl_name' and cl_section='$cl_section' and subject='$subj' and exam='$exam' and date='$date' and roll_no='$rollno' and obtainmarks='$marks'");if(mysql_num_rows($result)==0){ mysql_query("INSERT INTO ex_marks(mid, session, cl_name, cl_section, name, fname, status, date, exam, roll_no, subject, obtainmarks, maxmarks, passmarks) VALUES('', '$session', '$cl_name', '$cl_section', '$name','$fname', '$attendance', '$date', '$exam', '$rollno', '$subj','$marks','$maxmarks','$passmarks')")ordie(mysql_error()); echo "<script type='text/javascript'>alert('Submitted Successfully!')</script>";}else{ echo "<script type='text/javascript'>alert('Already Exist!')</script>";} And this is the form where values are inserted:
    <divid="page-wrapper"><divclass="container-fluid"><divclass="row"><divclass="col-lg-12"><h1class="page-header">ASSIGN MARKS</h1><divclass="col-lg-6"><divclass="panel"><formmethod="post"><!--<div class="form-group"> <input type="text" size="15" name="date" id="name[]" class="tcal form-control" placeholder="EXAM DATE" required="required"/> </div>--><divclass="form-group"><inputclass="form-control"type="text"size="17"name="maxmarks"placeholder="TOTAL MARKS"required="required"/></div><divclass="form-group"><inputclass="form-control"type="text"size="17"name="passmarks"placeholder="PASS MARKS"required="required"/></div><buttonname="btn_sub"type="submit"class="btn btn-info">SUBMIT</button></div></div><!-- /.col-lg-12 --></div></div><!-- /.row --><divclass="row"><divclass="col-lg-12"><divclass="panel panel-default"><divclass="panel-heading"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Se ssion : <?php $session=$_GET['session']; echo $session;?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cl ass : <?php $cl_name=$_GET['cl_name']; echo $cl_name;?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Se ction : <?php $cl_section=$_GET['cl_section']; echo $cl_section;?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;Subject : <?php $subj = $_GET['subj']; echo $subj;?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;Exam Date : <?php $date=$_GET['date']; echo $date;?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;Exam : <?php $exam=$_GET['exam']; echo $exam;?></div><!-- /.panel-heading --><divclass="panel-body"><divclass="dataTable_wrapper"><tableclass="table table-striped table-bordered table-hover"id="dataTables-example"><thead><tr><th>NO.</th><thclass="text-center">NAME</th><thclass="text-center">ROLL NO</th><thclass="text-center">FATHER NAME</th><thclass="text-center">SCORED MARKS</th><thclass="text-center">ATTENDANCE</th></tr></thead><tbody><?php $key="";if(isset($_POST['searchtxt'])) $key=$_POST['searchtxt'];if($key !="") $sql_sel1=mysql_query("SElECT * FROM ex_attendance WHERE session like '%$key%' and cl_name like '%$key%' and cl_section like '%$key%'");else $sql_sel1=mysql_query("select * from ex_attendance where session='$session' and cl_name='$cl_name' and cl_section='$cl_section' and exam='$exam' and date='$date' and subject='$subj'"); $i=0;while($row1=mysql_fetch_array($sql_sel1)){ $i++; $color=($i%2==0)?"lightblue":"white";?><trclass="odd gradeX"><td><?php echo $i;?></td><tdalign="center"><input size="17" type="text" name="name" value="<?php echo $row1['f_name']." ".$row1['m_name']." ".$row1['l_name'];?>" readonly="readonly"/></td><tdalign="center"><input size="13" type="text" name="rollno" value="<?php echo $row1['roll_no']?>" readonly="readonly"/></td><tdalign="center"><input size="17" type="text" name="fname" value="<?php echo $row1['fname']?>" readonly="readonly"/></td><tdalign="center"><inputsize="17"type="text"name="marks"required="required"/></td><tdalign="center"><input size="17" type="text" name="attendance" id="name[]" value="<?php echo $row1['status'];?>" readonly="readonly"/></td></tr><?php }?></form></tbody></table></div></div><!-- /.table-responsive --></div><!-- /.panel-body --></div><!-- /.panel --></div><!-- /.col-lg-12 --></div></div>
Working...
X