Linux, Apache, MySQL, PHP

<form method="POST" action="send.php">
      <font color="green"> Full Name : </font>
      <input type="text" name="name" size="20">

      <font color="green"> Gotra(Clan) : </font>
      <input type="text" name="gotra" size="20">

      <font color="green"> Father's Name : </font>
      <input type="text" name="fname" size="20">

      <font color="green">Details of Prasad to be Offered : </font>
(eg.: name of temple, quantity of prasad, specific date & any other requirements)
      <textarea rows="5" name="prasad" cols="40" ></textarea>

      <font color="green"> Any Wish to God  : </font>
      <textarea rows="5" name="wish" cols="40" ></textarea>

      <font color="green"> Postal Address : </font>
      <textarea rows="5" name="address" cols="40" ></textarea>

      <font color="green"> Phone no.  : </font>
      <input type="text" name="phone" size="20">

      <font color="green"> Preferred Time of Contact : </font>
      <input type="text" name="time" size="20">

      <font color="green"> Email address : </font> 
      <input type="text" name="email" size="20">

	<br>      
	 <input name="Submit" type="submit" class="input" value="Send">
         <input name="Submit2" type="reset" class="input" value="Reset">
        </br>         
     </form>

<?php 
if(isset($_POST['submit'])) { 
$to = "gagan.u20@gmail.com"; 
$subject = "E-Prasad Details"; 
$name_field = $_POST['name']; 
$gotra_field=$_POST['gotra'];
$fname_field = $_POST['fname']; 
$prasad=$_POST['prasad'];
$wish=$_POST['wish'];
$address=$_POST['address'];
$phone_field=$_POST['phone'];
$time_field=$_POST['time'];
$email_field=$_POST['email'];
  
$body = "From: $name_field\n Gotra: $gotra_field\n Father's name: $fname_field\n Details of prasad to be offered : $prasad\n Any wish to God: $wish\n Postal address : $address\n Phone no. : $phone_field\n Preferred time of contact : $time_field\n E-mail address : $email_field"; 
  
echo "Data has been submitted!"; 
mail($to, $subject, $body); 
} else { 
echo "An error occurred! Please try again."; 
} 
?> 

<script language=JavaScript>
<!--
function check_length(my_form)
{
maxLen = 150; // max number of characters allowed
if (my_form.my_text.value.length >= maxLen) {
// Alert message if maximum limit is reached.
// If required Alert can be removed.
var msg = "You have reached your maximum limit of characters allowed";
alert(msg);
// Reached the Maximum length so trim the textarea
my_form.my_text.value = my_form.my_text.value.substring(0, maxLen);
}
else{ // Maximum length not reached so update the value of my_text counter
my_form.text_num.value = maxLen - my_form.my_text.value.length;}
}
//-->
</script>

<?php
mysql_connect('localhost','eskool','eskool') or die("Table not connected");
mysql_select_db('eskool') or die("Database not connected");
$num=$_POST["numrow"];
$cls=$_POST["cls"];
$sec=$_POST["sec"];
$status=$_POST["status"];
$mon=$_POST["mon"];
$feetype=$_POST["fee"];
//echo $mon;
//echo $feetype;
//echo $cls;
//echo $sec;
//echo $status;
//echo "<form method=post action=http://localhost/eskool/node/253>";
if($status=="Pending"){
$j=0;
for($i=1;$i<=$num;$i++)
{
$che=$_POST["ck$i"];
//echo $che;
if(isset($che))
{
$query=mysql_query("select * from stud_reg where regno='".$che."'") or die("Not Select");
//$query=mysql_query("select contact from stud_reg where class='".$cls."' AND section='".$sec."' AND regno='".$che."'");
$row=mysql_fetch_array($query);
$nam=$row["fstname"].$row["lname"].'.'.$row["initial"];
$cont=$row["contact"];
$query2=mysql_query("select * from `2009` where month='".$mon."' and feetype='".$feetype."' ") or die("Not selected");
$row2=mysql_fetch_array($query2);
$paydat=$row2["paydate"];
//if($i<$num){$str='$cont"\;"';$i++;}
//$str=$str.$cont;
//echo $cont;
//$semi=";";
//if($j!=0){$str=$str.$semi;}
//$j++;
//$str=$str.$cont;
//echo "Message : <input type=text name=msg size=150 value=''>";
//$sms="http://localhost/mobil=";
$sms='http://smsc11.com/corp/SendingSms.jsp?uname=aker&pass=aker&mobile=';
$sms=$sms.$cont;
$msg="&msg=Please+note+that+$feetype+for+your+child+$nam+is+due+on+the+$paydat+-+xyz+school+,+Bangalore";
$send="$sms.$msg";
echo $send;
header( "Location:$send" ) ;}