"; }
$varArea = $_POST['area']; //collect content in text field, put into variable
$varType = $_POST['type'];
$varPrice = $_POST['price'];
$varVisit = $_POST['visit'];
$query = "INSERT INTO PROPERTY VALUES('$varArea', '$varType', '$varPrice', '$varVisit')";//insert the collected variables to the table property, put into variable $query
if(!sqlite_query($dbhandle, $query)) { echo "Could not insert table row"; } //pass the variable $query relating to this database (dbhandle) to !sqlite_query for processing
print "
Add another property?";
?>
";
// print_r( $result);
//print_r($result2);
//print "";
print "";
print "";
print "| Area | Type | Price | Visits |
";
foreach ($result as $arow) { //splits the result of select all from table into rows
echo '| ' . $arow['area'] . ' | ' . $arow['type'] . ' | ' . $arow['price'] . ' | ' . $arow['visit'] . ' |
';
} //refer to field name as SQLITE_ASSOC was used in the query handling
print "
";
?>