HTML

HTML

Friday, July 29, 2011

Inquiry Detail

Database:_____________________

<?php
 
  $host= "localhost";
  $uname="root";
  $pass="Spider1";
 
  $con= mysql_connect("$host","$uname","$pass");
  if(!$con)
 
  {
      die ('Could Not Connect:' . mysql_error());
     
     
  }
/*
if(mysql_query("CREATE DATABASE john",$con))

  {
      echo "connected with MYSQL";
      echo "Database is Created Successfully";
     
  }
 
  else
  {
      echo "Error Creating database: " .mysql_error();
  }
  */

 mysql_select_db("john",$con);
  $sql ="CREATE TABLE education_detail
 (
 uni varchar(30),
 it_kno varchar(30),
 col_sch_name varchar(30),
 tele int,
 mob int,
 al_mob int,
 zip int,
 e_mail varchar(30),
 ork_fb varchar(30),
 fthr_mob int
  )";

 $result=mysql_query($sql,$con);
  if($result)
  {
      echo "Table Created Successfully";
     
  }
 
  else
 
        echo "Script Check karo!!!";
 
  mysql_close($con);                          
?>


________________________HTML_________________________

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>INQUIRY DETAIL</title>
</head>

<body>
<form action="inquiry_php.php" method="post">

<fieldset style="width:600px" align="center">

<legend align="left">Inquiry Detail:</legend>

<table width="632" height="446" border="0">
  <tr>
    <td height="29"><div align="left">InquiryNo </div></td>
    <td><div align="left">
        <input type="text" name="inqno" />
    </div></td>
  </tr>
  <caption>
  INQUIRY DETAIL<br />
  </caption>
 
  <tr>
    <td height="29"><div align="left">InquiryID </div></td>
    <td><div align="left">
     
        <label></label>
        <input type="text" name="inqid" />
     
    </div></td>
  </tr>
  <tr>
    <td width="125" height="29"><div align="left">InquiryDate </div></td>
    <td width="508"><div align="left">
      <input type="text" name="inqdate" />
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left"> InquiryCourse </div></td>
    <td><div align="left">
      <input type="text" name="inqcourse" />
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left">TotalFees </div></td>
    <td><div align="left">
      <input type="text" name="totalfees" />
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left">BatchTime </div></td>
    <td><div align="left">
      <input type="text" name="batchtime" />
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left">TakenBy </div></td>
    <td><div align="left">
     
        <label>
        <input type="text" name="taken" />
        </label>
     
    </div></td>
  </tr>
  <tr>
    <td height="39"><div align="left">FeesDiscount </div></td>
    <td><div align="left">
     
        <label>
        <input type="text" name="feesdisc" />
        </label>
     
    </div></td>
  </tr>
    <tr>
    <td height="29"><div align="left">ExpectedJoinDate </div></td>
    <td><div align="left">
        <input type="text" name="expectedjoin" />
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left">Schem </div></td>
    <td><div align="left">
       
          <label></label>
          <label></label>
          <label>
          <input type="text" name="schem" />
          </label>
     
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left">NextFollowup </div></td>
    <td><div align="left">
       
          <label></label>
          <label></label>
          <label>
          <input type="text" name="followup" />
          </label>
       
    </div></td>
  </tr>
  <tr>
    <td height="29"><div align="left">Remarks</div></td>
    <td><div align="left">
        <input type="text" name="remarks" size="65"/>
    </div></td>
  </tr>
  </table>
</fieldset>
<input type="submit" value="submit"  />
</form>
</body>
</html>
____________________________PHPSCRITP_________________________________

<?php
 
 $con = mysql_connect("localhost","root","Spider1");
  if(!$con)
  {
      die('Could not connect' . mysql_error());
  }
  
    
  mysql_select_db("john",$con);
 $sql = "INSERT INTO inquiry_detail (inqno, inqid, inqdate, inqcourse, totalfees, batchtime, taken, freedisc, expectedjoin, schem, followup, remarks) VALUES ('$_POST[inqno]','$_POST[inqid]','$_POST[inqdate]','$_POST[inqcourse]','$_POST[totalfees]','$_POST[batchtime]','$_POST[taken]','$_POST[feesdisc]','$_POST[expectedjoin]','$_POST[schem]','$_POST[followup]','$_POST[remarks]')";
  
  if (!mysql_query($sql,$con))
  {
 die('Error:' . mysql_error());
  }
 
echo "1 Record added";  
  mysql_close($con);

?>


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)