calling php in form page...

eightonesix

I thought I had this coded correctly, but I can't seem to get the script to call back to the script correctly. Any ideas?

<body bgcolor="black" text="white" link="yellow" alink="yellow" vlink="yellow">
<?
// set a variable with the database name
$database_name = "miamivalleyfools_com";

// attempt to connect to database and store result
$dbh = mysql_connect("localhost","miamivalleyfools","REMOVED");

// check the result of the connection attempt
if (!mysql_select_db($database_name)) {
  echo "Can't Select $database_name";
}

// Conditional test to see if submit button was pressed
if ($enter_data) {

  // build our query string
  $sql = "insert into 2004registration (first_name, last_name, title, dept, address1, address2, city, state, zip, night_phone_a, night_phone_b, night_phone_c, day_phone_a, day_phone_b, day_phone_c, email, comm2, LiveReg, Paid) values ('$FNAME', '$LNAME', '$TITLE', '$DEPT', '$ADD1', '$ADD2', '$CITY', '$STATE', '$ZIP', '$NITPXA', '$NITPXB', '$NITPXC', '$DAYPXA', '$DAYPXB', '$DAYPXC', '$EMAIL', '$COMM2', '$LIVEREG', '$PAID')";

  // execute a query and store the result
  $res = mysql_query($sql,$dbh);

  // check to make sure the query actually ran
  if (!$res) {
    echo mysql_errno().": ".mysql_error ()."";
    return 0;
  }

  printf("IT WORKED");
}
?>
<table width="100%" height="100%" border=0>
<tr><td valign="center" align="center">

<form action="<? $_SERVER['PHP_SELF']?>" method="post">
<input type="hidden" name="LiveReg" value="Yes">  

<input type="hidden" name="Paid" value="No">  

<table>

<tr><td><font face="verdana" size=2>First name</td><td><input type="text" name="first_name" value="" size="25" tabindex="1">
<tr><td><font face="verdana" size=2>Last name</td><td><input type="text" name="last_name" value="" size="25" tabindex="1">
<tr><td><font face="verdana" size=2>Title</td><td><input type="text" name="title" value="" size="25" tabindex="1">
<tr><td><font face="verdana" size=2>Department</td><td><input type="text" name="dept" value="" size="25" tabindex="1">
<tr><td><font face="verdana" size=2>Address</td><td><input type="text" name="address1" value="" size="25" tabindex="1">
<tr><td><font face="verdana" size=2>Address (opt.)</td><td><input type="text" name="address2" value="" size="25" tabindex="1">
<tr><td><font face="verdana" size=2>City</td><td><input type="text" name="city" value="" size="" tabindex="1">
<tr><td><font face="verdana" size=2>State</td><td><input type="text" name="state" value="" size="2" tabindex="1">
<tr><td><font face="verdana" size=2>Zip code</td><td><input type="text" name="zip" value="" size="5" tabindex="1">
<tr><td><font face="verdana" size=2>Evening phone</td><td>(<input type="text" name="night_phone_a" value="" size="3" tabindex="1">) <input type="text" name="night_phone_b" value="" size="3" tabindex="1"> - <input type="text" name="night_phone_c" value="" size="4" tabindex="1">
<tr><td><font face="verdana" size=2>Alternate phone</td><td>(<input type="text" name="day_phone_a" value="" size="3" tabindex="1">) <input type="text" name="day_phone_b" value="" size="3" tabindex="1"> - <input type="text" name="day_phone_c" value="" size="4" tabindex="1">
<tr><td><font face="verdana" size=2>E-mail</td><td><input type="text" name="email" value="" size="25" tabindex="1"></td></tr>
<tr><td><font face="verdana" size=2>T-shirt size</td><td>
<select name="comm2" size="1">
<option label="Medium" value="M, "></option>
<option label="Large" value="L, "></option>
<option label="X-Large" value="XL, "></option>
<option label="2X-Large" value="2X, "></option>
</select>

</td></tr>


</table>
<p>
<input type="submit" name="enter_info" value="Submit Information">
</form></form>

nunomira

hi,

the submit button:

<input type="submit" name="enter_info" value="Submit Information">

and this conditional:

// Conditional test to see if submit button was pressed 
if ($enter_data) {

shouldn't be?

// Conditional test to see if submit button was pressed 
if (isset ($enter_info) && enter_info == "submit") {

cafrow

I have explained how to handle form variable 2 times today, so now I am going to start linking.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10270887

it would help for you to tell us your error, but I did see somethign that did not look correctly, check out this line.

// attempt to connect to database and store result 
$dbh = mysql_connect("localhost","miamivalleyfools","REMOVED"); 

// check the result of the connection attempt 
if (!mysql_select_db($database_name)) { 
  echo "Can't Select $database_name"; 
}

You do not actually connect, you just set $dbh equal to the connection string, but do not execute it. do something like

if (!$dbh){
 echo "could not connect";
}

Put that between the $dbh and the check the Result section.

please give us more info as to what is wrong.

Thanks

eightonesix

it redirects to:

http://miamivalleyfools.com/fiesta/<?%20$_SERVER['PHP_SELF']?>

with a 404 error that reads:

The requested URL /fiesta/< was not found on this server.

ucbones

instead of:
<form action="<? $_SERVER['PHP_SELF']?>" method="post">

try:
<form action="<?=$_SERVER['PHP_SELF']?>" method="post">

HTH

ucbones

eightonesix

same errors... 404 and page not found.

it seems as if the page is trying to send the results to a script outside of the page, instead of going abvove to the embedded php?

ucbones

very strange... try changing the action of the form to "scriptname.php", where scriptname is (patronisingly enough :rolleyes🙂 the filename of the script... If that doesn't work post the address of the script and I'll take a look!

HTH,

ucbones

eightonesix

the page is at:

http://miamivalleyfools.com/fiesta/newpaypal.php

it enters info into our db, then sends them to a link to paypal for payment of their conference fees.

hope this helps.

ucbones

the script appears to be posting to itself now, but the information isn't processed...

ucbones