getting error after filling out form

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



The php $_SERVER['PHP_SELF'] form comes up fine, I can
fill it out, but when I click 'submit' I get the
following error:

The requested URL
/php_excercises/{/php_excercises/schedule.php} was not
found on this server.

..and my database table is ignored. This was all
working just fine before and I don't remember changing
anything.

Here is my code:

<!DOCTYPE html PUBLIC
	"-//W3C//DTD XHTML 1.0 Strict//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
<html>
<head>
<title>Listing 13.1 Opening a Connection to a
Database</title>
</head>
<body>
<?php

if ( ! empty( $_REQUEST['sound'] )&&
	! empty( $_REQUEST['equip'] )&&
	! empty( $_REQUEST['food'] )&&
	! empty( $_REQUEST['drink'] )&&
	! empty( $_REQUEST['comp'] ) ){
		// check user imput here!
		$dberror = "";
		$ret = add_to_database( $_REQUEST['sound'],
                  $_REQUEST['equip'],
			      $_REQUEST['food'],
			      $_REQUEST['drink'],
			      $_REQUEST['comp'], $dberror );
		if ( ! $ret ) {
			print "Error: $dberror<br />\n";
		} else {
		  print "Thank you very much<br />\n";
		}
} else {
  write_form();
}
function add_to_database( $sound, $equip, $food,
$drink, $comp, &$dberror ) {
	$sound = mysql_real_escape_string( $sound );
    $equip = mysql_real_escape_string( $equip );
	$food = mysql_real_escape_string( $food );
	$drink = mysql_real_escape_string( $drink );
	$comp = mysql_real_escape_string( $comp );
    $link = mysql_pconnect( "localhost", "", "" );
    if ( ! $link ) {
		$dberror = mysql_error();
		return false;
	}
    if ( ! mysql_select_db( "schedule05", $link ) ) {
		$dberror = mysql_error();
	    return false;
	}
    $query = "INSERT INTO specs( sound, equip, food,
drink, comp )
		values('$sound', '$equip', '$food', '$drink',
'$comp' )";
    if ( ! mysql_query( $query, $link ) ) {
		$dberror = mysql_error();
		return false;
  }
  return true;
}

function write_form() {
	print '
		<form method="post" action="{' .
$_SERVER['PHP_SELF'] . '}">
        
		<p><input type="text" name="sound" />
		Does venue have mixer?</p>

		<p><input type="text" name="equip" />
		Does venue have its own equipment?</p>

		<p><input type="text" name="food" />
		What kind of food deal?</p>
		
		<p><input type="text" name="drink" />
		What kind of drink deal?</p>
		
		<p><input type="text" name="comp" />
		What is our compensation?</p>
		
		<p><input type="submit" value="submit!" /></p>
		</form>
		
	</FORM> ';
	
}
?>
</form>
</BODY>
</HTML>

=====
Patrick Roane
Web design and development
www.franklin-band.com
Fox River Grove, Il.

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux