Untitled

[insert_php]

if(isset($_POST['submit']))
	{
$servername="localhost";
$username="root";
$password="";
$db="pharmacy_batch_2017";
$conn=mysqli_connect($servername, $username, $password, $db);
if(!$conn)
{
	//die("Connection failed: " . mysqli_connect_error());

}
echo '10';
/*

		for($j=1;$j<=10;$j++)
		{
			if($_POST['rollno'][$j]=="")
			{

			}
			else
			{
				$detail="insert into student_entry(rollno,name,sem,regdno,sgroup,fathername,mobileno,email)values('".$_POST['rollno'][$j]."','".$_POST['name'][$j]."','".$_POST['semester']."','".$_POST['regdno'][$j]."','".$_POST['group'][$j]."','".$_POST['fathername'][$j]."','".$_POST['mobileno'][$j]."','".$_POST['email'][$j]."')";
			if(!mysqli_query($conn,$detail))
				{
				//echo"data not saved/updated successfully";
				}
				else
				{
				//echo"data saved/updated successfully";
				}
			}


			}*/
}
[/insert_php]
<!DOCTYPE html>
<html>
<body>
<style>
    .avatar {
    cursor: pointer;
    background-color: #000000;
border: 5px solid red;
    text-decoration:none;
    color:#FFFFFF;
    font-weight:bold;
border-radius: 12px;


width: 140px;
  height: 45px;
  font-family: 'Roboto', sans-serif;
  font-size: 11px;
  text-transform: uppercase;
  letter-spacing: 2.5px;
  font-weight: 500;
  color: #000;
  background-color: #fff;
  border: none;
  border-radius: 45px;
  box-shadow: 0px 8px 15px rgba(0, 0, 0, 0.1);
  transition: all 0.3s ease 0s;
  cursor: pointer;
  outline: none;
           }
input[type="submit"]:hover {
  background-color:#00000;
  background-color: #2EE59D;
  box-shadow: 0px 15px 20px rgba(46, 229, 157, 0.4);
  color: #fff;
  transform: translateY(-15px);
}
 /* background-color:#00000;
  background-color: #2EE59D;
  color: #fff;
  box-shadow:5px 10px 8px #888888;
box-shadow: 0 0 0 10px hsl(0, 0%, 80%), 0 0 0 15px hsl(0, 0%, 90%); */
.gg
{
background-color:#00000;
  background-color: #2EE59D;
  color: #fff;
  -webkit-box-shadow: 0px 0px 20px 16px #BCBBBD;  /* Safari 3-4, iOS 4.0.2 - 4.2, Android 2.3+ */
  -moz-box-shadow:    0px 0px 20px 16px #BCBBBD;  /* Firefox 3.5 - 3.6 */
  box-shadow:         0px 0px 20px 16px #BCBBBD;  /* Opera 10.5, IE 9, Firefox 4+, Chrome 6+, iOS 5 */
}


 </style>
<form method="post" action="">


[insert_php]


echo'
<div style="background-color:lightblue;color:black;border-color:black;" class="gg">';

echo'<span class="login100-form-title p-b-35" style="background-color:lightblue;color:black;border-color:black;">
<select class="sem"  name="semester" required="required" style="background-color:lightblue;color:black;border-color:black;">
                   <center>
                    <option value="">Select Sem.</option>

                       <option value="sem1">1st Sem</option>
                          <option value="sem3">3nd Sem</option>


                            </center>
                            </select>
 ';
echo'<table >';


echo"<tr>";
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Sr.no. </th>';
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Roll No. </th>';
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Name </th>';
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Regd No. </th>';
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Group </th>';
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Father Name </th>';
echo'<th  style="text-align:center;background-color:lightblue;color:black;border-color:black;"> Mobile No. </th>';


 echo"</tr>";

	for($i=1;$i<=10;$i++)
	{
    echo'<input type="hidden" name="gg" value="'.$i.'"  width="1">';echo'<input type="hidden" name="gg1[]" value="'.$i.'"  >';


	 echo '<tr>';

	 echo'<td  style="text-align:center;width:170px;height:30px;background-color:lightblue;color:black;border-color:black;"  >'.$i.'</td>';

	 echo'<td style="background-color:lightblue;color:black;border-color:black;" ><input type="text" name="rollno['.$i.']" value="" style="text-align:center;width:170px;height:30px;background-color:lightblue;color:black;border-color:black;"></td>';

	echo'<td style="background-color:lightblue;color:black;border-color:black;"><input type="text" class="" name="name['.$i.']" value="" style="text-align:center;width:170px;height:30px;background-color:lightblue;color:black;border-color:black;" ></td>';


	echo'<td style="background-color:lightblue;color:black;border-color:black;"><input type="text" class="" name="regdno['.$i.']" style="width:170px;height:30px;text-align:center;background-color:lightblue;color:black;border-color:black;"></td>';

	echo'<td style="background-color:lightblue;color:black;border-color:black;"><select name="group['.$i.']" value="" class="" style="text-align:center;width:170px;height:30px;background-color:lightblue;color:black;border-color:black;">
	        <option value="">Select Group</option>
			<option value="A">A</option>
            <option value="B">B</option> </select></td>';

	echo'<td style="background-color:lightblue;color:black;border-color:black;"><input type="text" class="" name="fathername['.$i.']" value=""style="text-align:center;width:170px;height:30px;background-color:lightblue;color:black;border-color:black;" ></td>';

	echo'<td style="background-color:lightblue;color:black;border-color:black;"><input type="text" class="" name="mobileno['.$i.']"  value=""style="text-align:center;width:170px;height:30px;background-color:lightblue;color:black;border-color:black;" ></td>';

	echo '</tr>';


    }
echo "</table></span>";
[/insert_php]
</div>
&nbsp;
&nbsp;
<center>
<input type="submit" name="submit" value="Save Data" class="avatar"/>

</center>


</form>
</body>
</html>