PHP-Script

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);

ListBox in PHP&Mysql

<body>

<form action="listbox2.php" method="post">

   <select name="cars">
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="fiat">Fiat</option>
<option value="audi">Audi</option>
</select>

<input type="submit" value="Submit Pick" />

</form>

</body>

PHP___________

<?php
  $con = mysql_connect("localhost","root","Spider1");
  if(!$con)
  {
   die('Could not connect' . mysql_error());
  } mysql_select_db('cric',$con);
   //$_POST['formDoor'] = "HELLO";
   // $aDoor = $_POST['formDoor'];

   $internet = "internet";
   $google = "google";
   $paper = "paper";
   $friends = "friends";

   $Car = $_POST['cars'];

$query="INSERT INTO spidy (FirstName)VALUE ('".$Car."')";
mysql_query($query) or die ('Error submitting');

echo "You Chose: " .$Car ;




?>

MySQL Same DB of Checkbox

Multiple-Checkbox

<
HTML________FORM

<body>

<form action="chk.php" method="post">

Which buildings do you want access to?<br />
<input type="text" name="id">
<input type="checkbox" name="media[]" value="internet"/>Internet<br />
<input type="checkbox" name="media[]" value="friends" />Friends<br />
<input type="checkbox" name="media[]" value="paper" />News paper<br />
<input type="checkbox" name="media[]" value="google" />Google<br />

<input type="submit" name="formSubmit" value="Submit" />

</form>

</body>
</html>

PHP__

<?php
  $con = mysql_connect("localhost","root","Spider1");
  if(!$con)
  {
   die('Could not connect' . mysql_error());
  } mysql_select_db('cric',$con);
   //$_POST['formDoor'] = "HELLO";
   // $aDoor = $_POST['formDoor'];

   $internet = "internet";
   $google = "google";
   $paper = "paper";
   $friends = "friends";


$media_array = $_POST['media'];
foreach ($media_array as $one_media) {
$source .= $one_media.", ";
}
$media = substr($source, 0, -2);

$query = "INSERT INTO spidy (Firstname)
VALUES( '$media')";
$result = mysql_query($query);


MySQL
Date: 2011-07-31 07:25:45
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `spidy`
-- ----------------------------
DROP TABLE IF EXISTS `spidy`;
CREATE TABLE `spidy` (
  `PersonID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `FirstName` text,
  PRIMARY KEY (`PersonID`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of spidy
-- ----------------------------
INSERT INTO `spidy` VALUES ('00000000031', 'saab');
INSERT INTO `spidy` VALUES ('00000000032', 'audi');
INSERT INTO `spidy` VALUES ('00000000033', 'fiat');
INSERT INTO `spidy` VALUES ('00000000034', 'volvo');
INSERT INTO `spidy` VALUES ('00000000035', 'internet');
INSERT INTO `spidy` VALUES ('00000000036', 'internet, friends');
INSERT INTO `spidy` VALUES ('00000000037', 'saab');
INSERT INTO `spidy` VALUES ('00000000038', 'saab');
INSERT INTO `spidy` VALUES ('00000000039', 'friends, paper');
INSERT INTO `spidy` VALUES ('00000000040', 'internet, friends, paper, google');




?>
>

PHP-Script

Pages

HTML

Friday, July 29, 2011

Inquiry Detail

ListBox in PHP&Mysql

Multiple-Checkbox