KimiyukiYamauchi/insert_dish.php

## insert_dish.php
<!DOCTYPE html>
<html>
<head>
	<meta charset="UTF-8">
	<title></title>
</head>
<body>

<?php
// Load PEAR MDB2
require 'MDB2.php';
// Load the form helper functions
require 'formhelpers.php';

// Connect to the database
//$db = MDB2::connect('mysql://s11011:password@localhost/db11?charset=utf8');
$db = MDB2::connect('oci8://s11011:password@172.16.40.4:1521/?service=db11');
if (MDB2::isError($db)) { die ("Can't connect: " . $db->getMessage()); }
// Set up automatic error handling
$db->setErrorHandling(PEAR_ERROR_DIE);

// The main page logic:
// - If the form is submitted, validate and then process or redisplay
// - If it's not submitted, display
if ($_POST['_submit_check']) {
    // If validate_form() returns errors, pass them to show_form()
    if ($form_errors = validate_form()) {
        show_form($form_errors);
    } else {
        // The submitted data is valid, so process it
        process_form();
    }
} else {
    // The form wasn't submitted, so display
    show_form();
}

function show_form($errors = '') {
    // If the form is submitted, get defaults from submitted parameters
    if ($_POST['_submit_check']) {
        $defaults = $_POST;
    } else {
        // Otherwise, set our own defaults: price is $5
        $defaults = array('price' => '5.00');
    }

    // If errors were passed in, put them in $error_text (with HTML markup)
    if (is_array($errors)) {
        $error_text = '<tr><td>You need to correct the following errors:';
        $error_text .= '</td><td><ul><li>';
        $error_text .= implode('</li><li>',$errors);
        $error_text .= '</li></ul></td></tr>';
    } else {
        // No errors? Then $error_text is blank
        $error_text = '';
    }

    // Jump out of PHP mode to make displaying all the HTML tags easier
?>
<form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
<table>
<?php print $error_text ?>

<tr><td>Dish Name:</td>
<td><?php input_text('dish_name', $defaults) ?></td></tr>

<tr><td>Price:</td>
<td><?php input_text('price', $defaults) ?></td></tr>

<tr><td>Spicy:</td>
<td><?php input_radiocheck('checkbox','is_spicy', $defaults, 'yes'); ?>
 Yes</td></tr>

<tr><td colspan="2" align="center"><?php input_submit('save','Order'); ?>
</td></tr>

</table>
<input type="hidden" name="_submit_check" value="1"/>
</form>
<?php
      } // The end of show_form()

function validate_form() {
    $errors = array();

    // dish_name is required
    if (! strlen(trim($_POST['dish_name']))) {
        $errors[] = 'Please enter the name of the dish.';
    }

    // price must be a valid floating point number and
    // more than 0
    if (floatval($_POST['price'] <= 0)) {
        $errors[] = 'Please enter a valid price.';
    }

    return $errors;
}

function process_form() {
    // Access the global variable $db inside this function
    global $db;

    // Get a unique ID for this dish
    $dish_id = $db->nextID('dishes');

    // Set the value of $is_spicy based on the checkbox
    if ($_POST['is_spicy'] == 'yes') {
        $is_spicy = 1;
    } else {
        $is_spicy = 0;
    }

    // Insert the new dish into the table
    $sth = $db->prepare('INSERT INTO dishes
					(dish_id, dish_name, price, is_spicy)
          VALUES (?,?,?,?)');
    $sth->execute(array($dish_id, $_POST['dish_name'],
											$_POST['price'], $is_spicy));


    // Tell the user that we added a dish.
    print 'Added ' . htmlentities($_POST['dish_name']) .
          ' to the database.';
}

?>
</body>
</html>
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8">
	<title></title>
	</head>
	<body>

	<?php
	// Load PEAR MDB2
	require 'MDB2.php';
	// Load the form helper functions
	require 'formhelpers.php';

	// Connect to the database
	//$db = MDB2::connect('mysql://s11011:password@localhost/db11?charset=utf8');
	$db = MDB2::connect('oci8://s11011:password@172.16.40.4:1521/?service=db11');
	if (MDB2::isError($db)) { die ("Can't connect: " . $db->getMessage()); }
	// Set up automatic error handling
	$db->setErrorHandling(PEAR_ERROR_DIE);

	// The main page logic:
	// - If the form is submitted, validate and then process or redisplay
	// - If it's not submitted, display
	if ($_POST['_submit_check']) {
	// If validate_form() returns errors, pass them to show_form()
	if ($form_errors = validate_form()) {
	show_form($form_errors);
	} else {
	// The submitted data is valid, so process it
	process_form();
	}
	} else {
	// The form wasn't submitted, so display
	show_form();
	}

	function show_form($errors = '') {
	// If the form is submitted, get defaults from submitted parameters
	if ($_POST['_submit_check']) {
	$defaults = $_POST;
	} else {
	// Otherwise, set our own defaults: price is $5
	$defaults = array('price' => '5.00');
	}

	// If errors were passed in, put them in $error_text (with HTML markup)
	if (is_array($errors)) {
	$error_text = '<tr><td>You need to correct the following errors:';
	$error_text .= '</td><td><ul><li>';
	$error_text .= implode('</li><li>',$errors);
	$error_text .= '</li></ul></td></tr>';
	} else {
	// No errors? Then $error_text is blank
	$error_text = '';
	}

	// Jump out of PHP mode to make displaying all the HTML tags easier
	?>
	<form method="POST" action="<?php print $_SERVER['PHP_SELF']; ?>">
	<table>
	<?php print $error_text ?>

	<tr><td>Dish Name:</td>
	<td><?php input_text('dish_name', $defaults) ?></td></tr>

	<tr><td>Price:</td>
	<td><?php input_text('price', $defaults) ?></td></tr>

	<tr><td>Spicy:</td>
	<td><?php input_radiocheck('checkbox','is_spicy', $defaults, 'yes'); ?>
	Yes</td></tr>

	<tr><td colspan="2" align="center"><?php input_submit('save','Order'); ?>
	</td></tr>

	</table>
	<input type="hidden" name="_submit_check" value="1"/>
	</form>
	<?php
	} // The end of show_form()

	function validate_form() {
	$errors = array();

	// dish_name is required
	if (! strlen(trim($_POST['dish_name']))) {
	$errors[] = 'Please enter the name of the dish.';
	}

	// price must be a valid floating point number and
	// more than 0
	if (floatval($_POST['price'] <= 0)) {
	$errors[] = 'Please enter a valid price.';
	}

	return $errors;
	}

	function process_form() {
	// Access the global variable $db inside this function
	global $db;

	// Get a unique ID for this dish
	$dish_id = $db->nextID('dishes');

	// Set the value of $is_spicy based on the checkbox
	if ($_POST['is_spicy'] == 'yes') {
	$is_spicy = 1;
	} else {
	$is_spicy = 0;
	}

	// Insert the new dish into the table
	$sth = $db->prepare('INSERT INTO dishes
	(dish_id, dish_name, price, is_spicy)
	VALUES (?,?,?,?)');
	$sth->execute(array($dish_id, $_POST['dish_name'],
	$_POST['price'], $is_spicy));


	// Tell the user that we added a dish.
	print 'Added ' . htmlentities($_POST['dish_name']) .
	' to the database.';
	}

	?>
	</body>
	</html>