";
print_r($_POST);
echo "";
$ULx = $_POST['ULx'];
$ULy = $_POST['ULy'];
$width = $_POST['width'];
$height = $_POST['height'];
$filename = $_POST['filename'];
// $owidth = $_POST['owidth'];
// $oheight = $_POST['oheight'];
/* connect to database */
mysql_connect("localhost", "root", "root") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("test");
/* build and run queries */
$query = "INSERT INTO tblCroppedPhoto (CPhoto_Id, ULx, ULy, Width, Height, Filename, CropHIT_ID) VALUES ('NULL','".$ULx."','".$ULy."','".$width."','".$height."','".$filename."','234')";
echo "query: ". $query . "
";
//$query = mysql_real_escape_string($query); //this breaks the query
mysql_query($query) or die ('Error updating database: ' . mysql_error());
//DEBUG
echo "Database Updated With: " .$ULx. " " .$ULy. " " .$width. " " .$height. " " .$filename."
";
/* display database fetch */
echo '';
echo "tblCroppedPhoto content:
";
$result = mysql_query("SELECT * FROM tblCroppedPhoto") or die ('MySQL ERROR: '. mysql_error());
while ($row = mysql_fetch_array($result)) {
echo "CPhoto_Id: " . $row['CPhoto_Id'] .
"
ULx: " . $row['ULx'] . "
ULy: " . $row['ULy'] .
"
Width: " . $row['Width'] . "
Height: " . $row['Height'] .
"
Filename: " . $row['Filename'] .
"
CropHIT_Id: " . $row['CropHIT_Id'] . "
";
echo "
";
}
echo ""; //end debug div
//endDEBUG
}
?>
Step 2: Please answer the survey questions below.