Rahima Farzana.S

<?php
####################################################################
# COPYRIGHT NOTICE:
# THIS SCRIPT CREATED BY WWW.WEBUNE.COM
# PLEASE DONT ERASE THIS
# Copyrights Webune.com
###################################################################
####################################################################
################ DATABASE CONFIGURE ##############################
####################################################################
$hostname = "localhost:3306"; // usually IS localhost, but IF NOT sure, CHECK WITH your

hosting company, IF you are WITH webune leave AS localhost
$db_user = "root"; // CHANGE TO your DATABASE password
$db_password = "mysql"; // CHANGE TO your DATABASE password
$database = "probe_config"; // provide your DATABASE name
$db_table = "mapping"; // leave this AS IS


# STOP HERE
####################################################################
# THIS CODE IS USED TO CONNECT TO THE MYSQL DATABASE
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);
?>
<html>
<head>
<title>How TO INSERT DATA INTO MySQL db USING form IN php</title>
</head>
<body>

<?php
IF (isset($_REQUEST['Submit'])) {
# THIS CODE TELL MYSQL TO INSERT THE DATA FROM THE FORM INTO YOUR MYSQL TABLE
$sql = "INSERT INTO $db_table(webmeasurementsuiteId,webmeasurementsId) values

('".mysql_real_escape_numeric(stripslashes($_REQUEST['webmeasurementsuiteId']))."','".mysq

l_real_escape_numeric(stripslashes($_REQUEST['webmeasurementsId']))."')";
echo$sql;
IF($result = mysql_query($sql ,$db)) {
echo '<h1>Thank you</h1>Your information has been entered into our database<br><br><img

src="http://www.webune.com/images/headers/default_logo.jpg"';
} ELSE {
echo "ERROR: ".mysql_error();
}
} ELSE {
?>

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


webmeasurementsuiteId:<br>
<br><?php
$query  = "SELECT id FROM webmeasurementsuite";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
 $id  = $row[0];


echo "<input type=\"text\" name=\"id\" value=\"$row[0]\"/><br/>";


}


?><br>


webmeasurementsId:<br>
<br><?php
$query  = "SELECT  id FROM webmeasurements";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
  $id  = $row[0];


echo "<input type=\"text\" name=\"id\" value=\"$row[0]\"/><br />";


}


?>

<br><INPUT TYPE="submit" name="Submit" VALUE="Submit">
</form>
<?php
}
?>
</body>
</html>