PHP - Problem Processing Edit On The Same Page

I have 2 scripts that take a while to process... The first takes a few minutes, the second takes over an hour... The first script completed successfully, but the second script seems like it just stops most of the way through the script...

I have this set on both files:
set_time_limit(0);
ini_set('memory_limit', -1);

I NEED to disable ALL time limits and all of that, does ANYONE have any clue as to why my second script is failing? It is NOT the programming, I know that for sure... But the script just stops executing, and I think it is because it times out... But after setting those 2 options, I don't see why it times out..

Also for reference, I am NOT using any database... I am simply downloading files from an FTP server to my server...

Any help would be appreciated, I have been searching for the last few days on an answer.

Rob

Hi,
I'm new to php and just trying to make sense of things by trying stuff. I'm trying to make a very rudimentary CMS where form values are added to a mysql database. One of the inputs in the form ($body) is a textarea. I've messed around with this but there's a glitch somewhere-when I press the submit button I just get a blank page (the page for the form processing script). My guess is there's something not right with the "safety measures" I'm taking: trim,stripslashes,etc. Any help would be appreciated

Code: [Select]
<?php
session_start();
if(!isset($_POST['Submit'])){
header("Location: home_manage.php");
exit();
}
else{

$headline=$_POST['headline'];
$author=$_POST['author'];
$body=$_POST['body'];
$headline=trim($headline);
$author=trim($author);
$body=trim($body);
$message=array(); 
if((strlen($headline)!=0)&&(strlen($author)!=0)&&(strlen($body)!=0)){
$time=time();
$date=date('Y-m-d H:i:s',$time);
$headline=strip_tags($headline);
$author=strip_tags($author);
$body="<p>".$body."</p>";
$order=array("\r\n", "\n", "\r");
$replace='</p><p>';
$body=str_ireplace($order,$replace,$body);
$body=strip_tags($body,'<p><br />');
   if(get_magic_quotes_gpc())
    {
$headline=stripslashes($headline);
$author=stripslashes($author);
$body=stripslashes($body);
}
$headline=htmlentities(mysql_real_escape_string($headline));
$author=htmlentities(mysql_real_escape_string($author));
$body=htmlentities(mysql_real_escape_string($body));
require('storage.inc');
$link = mysql_connect($host,$user,$db_password);
$db = mysql_select_db($post_database,$link);
$query= "INSERT INTO entry (entry_date,entry_head,entry_author,entry_text) VALUES ('$date','$headline','$author','$body')";
mysql_query($query);
$message[]="<p class='announce'><b>Post titled ".$headline." has been added to the database.</b></p>";
}
else{
if(strlen($headline)<1){$message[]="<p class='announce'><b>You must include a headline for this post.</b></p>";}
if(strlen($author)<1){$message[]="<p class='announce'><b>You must include an author name for this post.</b></p>";}
if(strlen($body)<1){$message[]="<p class='announce'><b>You must include some body text for this post.</b></p>";}
}
$_SESSION['msg']['up_err']=implode($message);
header("Location: home_manage.php");
exit();
}

?>

I'm trying to process inbound webhoks from a subscription provider. The problem I'm having is that they come in very fast. So for instance I'm unable to enable a new account because the account is not even created by the time the subscription hook comes in. I tried sleep(); before processing the subscription notification but that doesn't seem to work. I would appreciate some direction on how to handle this including the creation of a webhook queue if that's the best solution. Thanks!
// If new account, enter information into database 
if ($notification_type == "new_account_notification") {
$insert = "INSERT INTO users (accountcode,firstname, lastname, email, username, password, companyname, approved)
  VALUES ('".$account_code."','".$first_name."','".$last_name."','".$email."','".$email."', '".$user_password_plain."','".$company_name."','0')";
 $add_member = mysql_query($insert);  
 }

// If subscription, sleep for X seconds to wait for account creation then approve account 
if ($notification_type == "new_subscription_notification" || $notification_type == "reactivated_account_notification") {
//sleep(15);
$check = mysql_query("SELECT accountcode FROM users WHERE accountcode = '$account_code'") 
 or die(mysql_error());
 $check2 = mysql_num_rows($check);
 
 // If the user exists, set approved=1
 if ($check2 != 0) {
  $update_approved = mysql_query("UPDATE users SET approved=1 WHERE accountcode = '$account_code'")
  or die(mysql_error());
}

Hi can anyone please help me, I have to create a edit page that retrieves information from a list so that a user can change the text. The page looks fine but when I enter data in the fields and update it leaves the page as it was retrieved.
I am a beginner! My code looks like this:

Code: [Select]
<form method = "get" action = "edit.php">
<?php

  //check to see if user is logged on
  session_start();
  if (!(isset($_SESSION['login']) && $_SESSION['login'] != "")) {
   header ("Location:login.php");
  }

  include('connect.php');  //connection details to database in a connect.php page
  
  $product_id = $_GET['product_id'];
  
  $query = "SELECT * FROM products WHERE product_id = '$product_id'";
  $result = mysql_query($query);
  
  while($row = mysql_fetch_array($result)){
  $product_id = $row['product_id'];
  echo "<table>";
  echo "<tr>";
  echo "<td><input name = 'product_id' type = 'hidden' value ='$row[product_id]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Product Name:</td><td><input name = 'pname' type = 'text' value ='$row[product_name]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Product Range:</td><td><input name = 'prange' type = 'text' value ='$row[product_range]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Product Price:</td><td><input name = 'pprice' type = 'text' value ='$row[product_price]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td><input type = 'submit' name = 'Submit' value = 'Update'></td>";
  echo "</tr>";
  echo "</table>";
  }
  
   //if form was submitted
    if ($_SERVER['REQUEST_METHOD'] == 'POST'){
  
    //get values from fields
    $productname = $_POST['pname'];
    $range = $_POST['prange'];
    $price1 = $_POST['pprice'];
    $price = (int)$price1;
    
    if ($productname == "" || $range == "" || $price == "" ) {
        $errorMessage .= "Please fill in all text boxes";
        }
        else {
        $errorMessage = "";
        }
    
  
    
    $query = "UPDATE products SET product_name = '$productname', product_range = '$range', product_price = '$price' WHERE product_id = '$product_id'";
    $result = mysql_query($query);
    print "<br> $productname from range $range with a price of $price has been updated!";
    } 
      
?>

 
Thank you in advance!

I was looking at various tutorials on the net to help me create an edit profile page for my site but the ones I tried wouldn't work...

What changes would I have to make to this: (register.php)

<?php 
include ('header.php');
?></center>
<div class=content>
<?php  
if(!empty($_POST['username']) && !empty($_POST['password']))  
{  
    $username = mysql_real_escape_string($_POST['username']);  
    $password = md5(mysql_real_escape_string($_POST['password']));  
    $email = mysql_real_escape_string($_POST['email']);
    $location = mysql_real_escape_string($_POST['location']);
    $website = mysql_real_escape_string($_POST['website']);
    $about = mysql_real_escape_string($_POST['about']);
  
     $checkusername = mysql_query("SELECT * FROM users WHERE Username = '".$username."'");  
  
     if(mysql_num_rows($checkusername) == 1)  
     {  
        echo "<b>Error</b>";  
        echo "Sorry, that username is taken. Please go back and try again.</p>";  
     }  
     else  
     {  
        $registerquery = mysql_query("INSERT INTO users (Username, Password, EmailAddress, Location, Website, About) VALUES('".$username."', '".$password."', '".$email."', '".$location."', '".$website."', '".$about."')");  
        if($registerquery)  
        {  
            echo "<b>Success!</b>";  
            echo "Your account was successfully created. Please click<a href=\"index.php\"> here </a>to login.";  
        }  
        else  
        {  
            echo "<b>Error</b>";  
            echo "<p>Sorry, your registration failed. Please go back and try again.</p>";  
        }  
     }  
}  
else  
{  
    ?>  
   <b>Register</b>  
  <br><br>
   Please enter your details below to register.  
  <br><br>
    <form method="post" action="register.php" name="registerform" id="registerform"> 
    <table width=700px border=0 cellspacing=10><tr><td valign=top><table border=0>
<b>Required Information:</b><br><br>
<tr><td>  
        <b>Username:</b>
</td><td>
        <input type="text" name="username" id="username" />
</td></tr><tr><td>
        <b>Password:</b>
</td><td>
        <input type="password" name="password" id="password" />
</td></tr><tr><td>  
        <b>Email Address:</b>
</td><td>
        <input type="text" name="email" id="email" />
</td></tr></table></td><td valign=top>
<table border=0>
<b>Optional Information:</b><br><br>
<tr><td>
     <b>Location:</b>
</td><td>
     <input type="text" name="location" id="location">
</td></tr><tr><td>
     <b>Your Website:</b>
</td><td>
     <input type="text" name="website" id="website">
</tr></td><tr><td valign=top>
     <b>Short About:</b>
</td><td>
     <textarea name="about" id="about" rows="10" cols="20"></textarea>
</td></tr></td>
</table> </td></tr> </table>
        <input type="submit" name="register" id="register" value="Register" class=btn />  
    </form>  
  
    <?php  
}  
?>  </div>
<?php
include ('footer.php'); 
?>

an edit profile page?

I use this as the template because its damn near the same script, just with a few alterations...

I know the obvious things the bit I struggle with is selecting the database then inserting new information?...I keep getting my variables/queries messed up when I rewrite it to create a edit profile page.

Cheers,

So I'm working on a php page that can edit a .txt-file.
This is what I'v got so far:
Code: [Select]
<?php 
if (isset($_POST['submit'])) {  

$stringData = stripslashes($_POST['sf']);  
file_put_contents("huisrekening.txt", $stringData); 

header('Location: quaestor.php?a=update');  

}  
?>

Huisrekening:
<form action="" method="post">
<textarea name="sf" cols="100" rows="20">
<?php 
$theData = file_get_contents("huisrekening.txt"); 
echo $theData;  
?></textarea>
<br />
<input type="submit" name="submit" value="Update" />
</form>

<?php 
if ($_GET['a'] == 'update') { 
echo ''; 

$myFile = "huisrekening.txt"; 
$fh = fopen($myFile, 'r'); 
$theData = fgets($fh); 
fclose($fh); 
echo $theData; 

} 
?>
Problem: each time I hit the Update button an extra line appears in the .txt-file. :-(
Does anybody know what I did wrong?

hi i was wondering how i would make a website that allowed a user to login and edit there website ... like im a hoster and they can have a webpage on my server... how would i do  this? allow them to create a database , and use all types of code? please help me this is important , if i didnt explain good enough please tell me

hello all, i am trying to edit a mysql table from the browser using these codes:

edit.php:

      include"db.inc.php";//database connection

      $order = "SELECT * FROM prices";

      $result = mysql_query($order);

      while ($row=mysql_fetch_array($result)){

        echo ("<tr><td>$row[id_number]</td>");

        echo ("<td>$row[product]</td>");

        echo ("<td>$row[price]</td>");

        echo ("<td><a href=\"edit_form.php?id=$row[id_number]\">Edit</a></td></tr>");

      }

edit_form.php

      <table>

      <?

      include "db.inc.php";//database connection

      $order = "SELECT * FROM prices where id_number='$id'";

      $result = mysql_query($order);

      $row = mysql_fetch_array($result);

      ?>

      <form method="post" action="edit_data.php">

      <input type="hidden" name="id" value="<? echo "$row[id_number]"?>">

        <tr>       

          <td>Product</td>

          <td>

            <input type="text" name="product"

        size="20" value="<? echo "$row[product]"?>">

          </td>

        </tr>

        <tr>

          <td>Price</td>

          <td>

            <input type="text" name="price" size="40"

          value="<? echo "$row[price]"?>">

          </td>

        </tr>

        <tr>

          <td align="right">

            <input type="submit"

          name="submit value" value="Edit">

          </td>

        </tr>

      </form>

      </table>

edit_data.php

include "db.inc.php";

$order = "UPDATE prices SET product='$_POST[product]', price='$_POST[price]' WHERE id_number='$id'";

mysql_query($order);

header("location:edit.php");

the table:
CREATE TABLE IF NOT EXISTS `prices` (
  `id_number` int(3) NOT NULL,
  `product` varchar(30) DEFAULT NULL,
  `price` int(6) DEFAULT NULL,
  PRIMARY KEY (`id_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

the data is displayed correctly but i can't change the data...

Hello, I will try to explain this in as much detail as I can. I am probably making a simple mistake but I have gone through the code multiple times and can't figure it out.

I have 3 HTML Site tables, pending, accepted and denied applications. I have accept, deny, and delete buttons on all the tables for each row. I could probably do with out the accept and deny buttons on the last two HTML Site tables, but in the case an admin making a mistake and clicking the wrong button. I don't want the admin to have to delete the app and have the user fill out a new one. User experience and all that.

My problem: The last two HTML Site tables, Accept and Denied, the three buttons do not function but in Pending they do. I don't remember assigning those functions to one table and looked thought the code and didn't see any place I did it is only looking for id at the displayed row. Enough of my jabbering. Here is what I am working with.

 

    

Here is the code, I have done for the deletes and edits to the application status.

//DELETE APPLICATION

if(isset($_POST['delete'])) {

    $to_change = mysqli_real_escape_string($conn, $_POST['to_change']);



    $sql = "DELETE FROM apps WHERE id = $to_change";



    if(mysqli_query($conn, $sql)) {

        $feedback['delete'] = '<div class="green white-text alert-box">Success the user deleted from list.</div>';

        header('Location: admin.php');

    } else {

        $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

    }

} else {

    $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

}



//UPDATE APPLICATION STATUS TO ACCEPT

if(isset($_POST['accept'])) {

    $to_change = mysqli_real_escape_string($conn, $_POST['to_change']);

    //QUERY DB

    mysqli_query($conn, "UPDATE apps SET app_status='Accepted' WHERE id = $to_change");

    $feedback['accept'] = '<div class="green white-text alert-box">Success, the user was accepted.</div>';

    header('Location: admin.php');

} else {

    $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

}



//UPDATE APPLICATION STATUS TO DENIED

if(isset($_POST['denied'])) {

    $to_change = mysqli_real_escape_string($conn, $_POST['to_change']);

    //QUERY DB

    mysqli_query($conn, "UPDATE apps SET app_status='Denied' WHERE id = $to_change");

    $feedback['denied'] = '<div class="green white-text alert-box">Success, the user was denied.</div>';

    header('Location: admin.php');

} else {

    $feedback['ui_feedback'] = '<div class="red white-text alert-box">Connection Error</div>';

}

I know the $feedback doesn't work I wanted to see it worked and it didn't I will research that later.

<!-- NEW APPLICATIONS -->
            <div id="new_apps" class="container white container-style">
                <h4 class="blue-text text-darken-3">New Applications</h4>
                <div class="table-responsive">
                <table class="highlight centered row">
                    <thead>
                        <tr class="">
                            <th class="blue-text text-darken-3">ID</th>
                            <th class="blue-text text-darken-3">Name</th>
                            <th class="blue-text text-darken-3">Email</th>
                            <th class="blue-text text-darken-3">Discord</th>
                            <th class="blue-text text-darken-3">Steam Hex ID</th>
                            <th class="blue-text text-darken-3">DOB</th>
                            <th class="blue-text text-darken-3">Department</th>
                            <th class="blue-text text-darken-3">Date Applied</th>
                            <th class="blue-text text-darken-3">Status</th>
                            <th class="blue-text text-darken-3">Actions</th>
                        </tr>
                        <tbody class="">
<?php if($pending): ?>
<?php foreach($pending as $pend): ?>
                                    <tr>
                                        <td><?php echo $pend['id']; ?></td>
                                        <td><?php echo $pend['first_name'] . " " . $pend['last_name']; ?></td>
                                        <td><?php echo $pend['email']; ?></td>
                                        <td><?php echo $pend['discord_name']; ?></td>
                                        <td><?php echo $pend['steam_hex']; ?></td>
                                        <td><?php echo $pend['dob']; ?></td>
                                        <td><?php echo $pend['dept_select']; ?></td>
                                        <td><?php echo $pend['created_at']; ?></td>
                                        <td><?php echo $pend['app_status']; ?></td>
                                        <td>
                                            <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
                                                <input type="hidden" name="to_change"  value="<?php echo $pend['id']; ?>">
                                                <button type="submit" name="accept" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Accept"><i class="material-icons green-text text-darken-3">check_circle</i></button>
                                                <button type="submit" name="denied" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Deny"><i class="material-icons yellow-text text-darken-3">not_interested</i></button>
                                                <button type="submit" name="delete" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Delete"><i class="material-icons red-text text-darken-3">delete</i></button>
                                            </form>
                                        </td>
                                    </tr>
                            </tbody>
<?php endforeach; ?>
<?php else: ?>
                <div class="blue darken-3 white-text table-empty-box">There are no applications</div>
<?php endif; ?>
                        </thead>
                    </table>
            </div>
        </div>
<!-- ACCEPTED APPLICATIONS-->
                <div id="accepted_apps" class="container white container-style">
                    <h4 class="blue-text text-darken-3">Accepted Applications</h4>
                    <div class="table-responsive">
                    <table class="highlight centered row">
                        <thead>
                        <tr class="">
                            <th class="blue-text text-darken-3">ID</th>
                            <th class="blue-text text-darken-3">Name</th>
                            <th class="blue-text text-darken-3">Email</th>
                            <th class="blue-text text-darken-3">Discord</th>
                            <th class="blue-text text-darken-3">Steam Hex ID</th>
                            <th class="blue-text text-darken-3">DOB</th>
                            <th class="blue-text text-darken-3">Department</th>
                            <th class="blue-text text-darken-3">Date Applied</th>
                            <th class="blue-text text-darken-3">Status</th>
                            <th class="blue-text text-darken-3">Actions</th>
                        </tr>
                            <tbody class="">
<?php if($accepted): ?>
<?php foreach($accepted as $accept): ?>
                                    <tr>
                                        <td><?php echo $accept['id']; ?></td>
                                        <td><?php echo $accept['first_name'] ." " . $accept['last_name']; ?></td>
                                        <td><?php echo $accept['email']; ?></td>
                                        <td><?php echo $accept['discord_name']; ?></td>
                                        <td><?php echo $accept['steam_hex']; ?></td>
                                        <td><?php echo $accept['dob']; ?></td>
                                        <td><?php echo $accept['dept_select']; ?></td>
                                        <td><?php echo $accept['created_at']; ?></td>
                                        <td><?php echo $accept['app_status']; ?></td>
                                        <td>
                                            <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
                                                <input type="hidden" name="to_change"  value="<?php echo $accept['id']; ?>">
                                                <a type="submit" name="accept" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Accept"><i class="material-icons green-text text-darken-3">check_circle</i></a>
                                                <a type="submit" name="denied" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Deny"><i class="material-icons yellow-text text-darken-3">not_interested</i></a>
                                                <a type="submit" name="delete" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Delete"><i class="material-icons red-text text-darken-3">delete</i></a>
                                            </form>
                                        </td>
                                    </tr>
<?php endforeach; ?>
<?php else: ?>
                                <div class="blue darken-3 white-text table-empty-box">There are no applications</div>
<?php endif; ?>
                            </tbody>
                        </thead>
                    </table>
                    </div>
                </div>
<!-- deniedED APPLICATIONS -->
            <div id="denieded_apps" class="container white container-style">
                <h4 class="blue-text text-darken-3">Denied Applications</h4>
                <div class="table-responsive">
                <table class="highlight centered row">
                    <thead>
                    <tr class="">
                            <th class="blue-text text-darken-3">ID</th>
                            <th class="blue-text text-darken-3">Name</th>
                            <th class="blue-text text-darken-3">Email</th>
                            <th class="blue-text text-darken-3">Discord</th>
                            <th class="blue-text text-darken-3">Steam Hex ID</th>
                            <th class="blue-text text-darken-3">DOB</th>
                            <th class="blue-text text-darken-3">Department</th>
                            <th class="blue-text text-darken-3">Date Applied</th>
                            <th class="blue-text text-darken-3">Status</th>
                            <th class="blue-text text-darken-3">Actions</th>
                        </tr>
                        <tbody class="">
<?php if($denied): ?>
<?php foreach($denied as $deny): ?>
                                <tr>
                                    <td><?php echo $deny['id']; ?></td>
                                    <td><?php echo $deny['first_name'] ." " . $deny['last_name']; ?></td>
                                    <td><?php echo $deny['email']; ?></td>
                                    <td><?php echo $deny['discord_name']; ?></td>
                                    <td><?php echo $deny['steam_hex']; ?></td>
                                    <td><?php echo $deny['dob']; ?></td>
                                    <td><?php echo $deny['dept_select']; ?></td>
                                    <td><?php echo $deny['created_at']; ?></td>
                                    <td><?php echo $deny['app_status']; ?></td>
                                    <td>
                                        <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
                                            <input type="hidden" name="to_change"  value="<?php echo $deny['id']; ?>">
                                            <a type="submit" name="accept" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Accept"><i class="material-icons green-text text-darken-3">check_circle</i></a>
                                            <a type="submit" name="denied" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Deny"><i class="material-icons yellow-text text-darken-3">not_interested</i></a>
                                            <a type="submit" name="delete" class="tooltipped btn-floating btn-flat btn-small transparent" data-postion="bottom" data-tooltip="Delete"><i class="material-icons red-text text-darken-3">delete</i></a>
                                        </form>
                                    </td>
                                </tr>
<?php endforeach; ?>
<?php else: ?>
                                <div class="blue darken-3 white-text table-empty-box">There are no applications</div>
<?php endif; ?>
                        </tbody>
                    </thead>
                </table>
                </div>
            </div>

 

Any help would be amazing even if you tell me to look at a line lol

I am getting back into php after only doing it for a few weeks after switching to firebase,  just coming back to what works and not having limits. 

Thank you for taking the time to read this!

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=322008.0

My local IT department is migrating to a "hardened" LAMP/PHP environment. The PHP application at http://library.uww.edu/php/showrp.php is being moved to this new "hardened" environment and the "Title/Subject/Issue:" search option does not work in this environment.

The "Title/Subject/Issue:" search option does however work within the "non-hardened" environment at http://library.uww.edu/php/showrp.php.

Attached is the source code for the showrp.php.

What is likely causing the failure of the "Title/Subject/Issue:" search option.   

I have an SQL table such as this:
Pairing1 Pairing2 Week 6 1 1 5 2 1 4 3 1 1 3 2 5 4 2 3 6 2 and another with teams such as:
teamid teamname 1 Teamname 1 2 Teamname 2 3 Teamname 3 The numbers in the pairing are numbers of teams, which is in another SQL table. What would be the most efficient way... of displaying the information in the form of pairngs such as
Week 1:
Team 6 vs Team 1
Team 5 vs Team 2
etc ....
What is the best way for me to sort my results?

Hello everyone, I have a datatbase containing fields id, question, answer, and type. The questions are in true/false format, multiple choice and fill in the blank(text). At the moment, I am only trying to get the true and false questions to work. My code is as follows

Code: [Select]

<?php

$connection = mysql_connect("localhost","root","root") or die("couldn't connect");
$select = mysql_select_db("login") or die ("cannot select database!");

$query = mysql_query("SELECT * FROM questions");

$numrows = mysql_num_rows($query);

if ($numrows!=0)
{
//code to login
while($row = mysql_fetch_assoc($query))
{
$dbquestion = $row['question'];
$dbanswer = $row['answer'];
$dbtype = $row['type'];
$dbid = $row['id'];
$correctanswer =  explode('|',"$dbanswer");



switch($dbtype){
case "mchoice":
echo"<br/>"; echo $dbquestion; echo"<br/>";
break;

case "boolean":
echo"<br/>"; echo $dbquestion; echo"<br/>";
echo $correctanswer[0];

//display radio buttons

?>
<form name="boolean" method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>">
True
<input name="question" type="radio" value= "True" />
False
<input name="question" type="radio" value= "False" />
<input name="id" input type="hidden" value="<?php $dbid ?>" />
<input type="submit" name="submit" id="submit" value="Submit" />

<?php
echo "The answer submitted was ";
echo  $_POST['question'];
?>

<?php
break;

case "text":
echo"<br/>"; echo $dbquestion; echo"<br/>";
//display text box
break;
}
}
}
?>

The problem I'm having is that this creates a submit button for each question. When choosing true or false for the answer and pressing submit, the answer is selected for every question. I need the code  to look at what the user has entered, check the answer against correctanswer[0].

I'm really in a bit of a hole here and if anyone can help me it would be greatly appreciated.

Many thanks in advance
James

Can you take a look at this page?  It uses php code that I have been creating.  I need it to accept the form even if checkboxes are left empty.  Currently it comes up with an error.

http://www.pilotrock.com/color_contact/

Here is the PHP code:

<?php

if(isset($_POST['Email_Address'])) {
   
   include 'lite_settings.php';
   
   function died($error) {
      echo "Sorry, but there were error(s) found with the form you submitted. ";
      echo "These errors appear below.<br /><br />";
      echo $error."<br /><br />";
      echo "Please go back and fix these errors.<br /><br />";
      die();
   }
   
   if(!isset($_POST['organization']) ||
       !isset($_POST['Full_Name']) ||
      !isset($_POST['title']) ||
      !isset($_POST['company']) ||
      !isset($_POST['address']) ||
      !isset($_POST['city_state']) ||
      !isset($_POST['zip']) ||
      !isset($_POST['Telephone_Number']) ||
      !isset($_POST['cell_phone']) ||
      !isset($_POST['fax']) ||
      !isset($_POST['Email_Address']) ||
      !isset($_POST['confirm_email']) ||
      !isset($_POST['powder_coated_steel_blue']) ||
      !isset($_POST['powder_coated_steel_black']) ||
      !isset($_POST['powder_coated_steel_green']) ||
      !isset($_POST['powder_coated_steel_brown']) ||
      !isset($_POST['powder_coated_steel_yellow']) ||
      !isset($_POST['powder_coated_steel_red']) ||
      !isset($_POST['powder_coated_steel_gray']) ||
      !isset($_POST['powder_coated_steel_burgendy']) ||
      !isset($_POST['thermo_plastic_coated_type_expanded']) ||
      !isset($_POST['thermo_plastic_coated_type_perforated']) ||
      !isset($_POST['thermo_plastic_coated_black']) ||
      !isset($_POST['thermo_plastic_coated_blue']) ||
      !isset($_POST['thermo_plastic_coated_brown']) ||
      !isset($_POST['thermo_plastic_coated_gray']) ||
      !isset($_POST['thermo_plastic_coated_red']) ||
      !isset($_POST['thermo_plastic_coated_green']) ||
      !isset($_POST['recycle_plastic_red']) ||
      !isset($_POST['recycle_plastic_yellow']) ||
      !isset($_POST['recycle_plastic_black']) ||
      !isset($_POST['recycle_plastic_blue']) ||
      !isset($_POST['recycle_plastic_gold']) ||
      !isset($_POST['recycle_plastic_redwood']) ||
      !isset($_POST['recycle_plastic_cedar']) ||
      !isset($_POST['recycle_plastic_green']) ||
      !isset($_POST['recycle_plastic_gray']) ||
      !isset($_POST['recycle_plastic_brown'])) {
      died('We are sorry, but there appears to be a problem with the form you submitted.');     
   }
   
   $organization = $_POST['organization']; // required
   $full_name = $_POST['Full_Name']; // required
   $title = $_POST['title']; // not required
   $company = $_POST['company']; // not required
   $address = $_POST['address']; // required
   $city_state = $_POST['city_state']; // required
   $zip = $_POST['zip']; // required
   $telephone = $_POST['Telephone_Number']; // required
   $cell_phone = $_POST['cell_phone']; // not required
   $fax = $_POST['fax']; // not required
   $email_from = $_POST['Email_Address']; // required
   $confirm_email = $_POST['confirm_email']; // required
   $powder_coated_steel_blue = $_POST['powder_coated_steel_blue']; // required
   $powder_coated_steel_black = $_POST['powder_coated_steel_black']; // required
   $powder_coated_steel_green = $_POST['powder_coated_steel_green']; // required
   $powder_coated_steel_brown = $_POST['powder_coated_steel_brown']; // required
   $powder_coated_steel_yellow = $_POST['powder_coated_steel_yellow']; // required
   $powder_coated_steel_red = $_POST['powder_coated_steel_red']; // required
   $powder_coated_steel_gray = $_POST['powder_coated_steel_gray']; // required
   $powder_coated_steel_burgendy = $_POST['powder_coated_steel_burgendy']; // required
   $thermo_plastic_coated_type_expanded = $_POST['thermo_plastic_coated_type_expanded']; // required
   $thermo_plastic_coated_type_perforated = $_POST['thermo_plastic_coated_type_perforated']; // required
   $thermo_plastic_coated_black = $_POST['thermo_plastic_coated_black']; // required
   $thermo_plastic_coated_blue = $_POST['thermo_plastic_coated_blue']; // required
   $thermo_plastic_coated_brown = $_POST['thermo_plastic_coated_brown']; // required
   $thermo_plastic_coated_gray = $_POST['thermo_plastic_coated_gray']; // required
   $thermo_plastic_coated_red = $_POST['thermo_plastic_coated_red']; // required
   $thermo_plastic_coated_green = $_POST['thermo_plastic_coated_green']; // required
   $recycle_plastic_red = $_POST['recycle_plastic_red']; // required
   $recycle_plastic_yellow = $_POST['recycle_plastic_yellow']; // required
   $recycle_plastic_black = $_POST['recycle_plastic_black']; // required
   $recycle_plastic_blue = $_POST['recycle_plastic_blue']; // required
   $recycle_plastic_gold = $_POST['recycle_plastic_gold']; // required
   $recycle_plastic_redwood = $_POST['recycle_plastic_redwood']; // required
   $recycle_plastic_cedar = $_POST['recycle_plastic_cedar']; // required
   $recycle_plastic_green = $_POST['recycle_plastic_green']; // required
   $recycle_plastic_gray = $_POST['recycle_plastic_gray']; // required
   $recycle_plastic_brown = $_POST['recycle_plastic_brown']; // required
   
   $error_message = "";
   $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";
  if(!eregi($email_exp,$email_from)) {
     $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
  if(strlen($full_name) < 2) {
     $error_message .= 'Your Name does not appear to be valid.<br />';
  }
  if(strlen($address) < 2) {
     $error_message .= 'Your Address does not appear to be valid.<br />';
  }
   if(strlen($city_state) < 2) {
     $error_message .= 'Your City/State does not appear to be valid.<br />';
  }
  if(strlen($zip) < 2) {
     $error_message .= 'Your Zip/Postal Code does not appear to be valid.<br />';
  }
  if(strlen($telephone) < 2) {
     $error_message .= 'Your Telephone Number does not appear to be valid.<br />';
  }
 
  if(strlen($error_message) > 0) {
     died($error_message);
  }
   $email_message = "Form details below.\r\n";
   
   function clean_string($string) {
     $bad = array("content-type","bcc:","to:","cc:","href");
     return str_replace($bad,"",$string);
   }
   
    $email_message .= "Organization: ".clean_string($organization)."\r\n";
   $email_message .= "Full Name: ".clean_string($full_name)."\r\n";
   $email_message .= "Title: ".clean_string($title)."\r\n";
   $email_message .= "Company Name: ".clean_string($company)."\r\n";
   $email_message .= "Street Address: ".clean_string($address)."\r\n";
   $email_message .= "City/State: ".clean_string($city_state)."\r\n";
   $email_message .= "ZIP/Postal Code: ".clean_string($zip)."\r\n";
   $email_message .= "Telephone: ".clean_string($telephone)."\r\n";
   $email_message .= "Cell Phone: ".clean_string($cell_phone)."\r\n";
   $email_message .= "Fax: ".clean_string($fax)."\r\n";
   $email_message .= "Email: ".clean_string($email_from)."\r\n";
   $email_message .= "Confirm Email: ".clean_string($confirm_email)."\r\n";
   $email_message .= "Powder Coated Steel Blue: ".clean_string($powder_coated_steel_blue)."\r\n";
   $email_message .= "Powder Coated Steel Black: ".clean_string($powder_coated_steel_black)."\r\n";
   $email_message .= "Powder Coated Steel Green: ".clean_string($powder_coated_steel_green)."\r\n";
   $email_message .= "Powder Coated Steel Brown: ".clean_string($powder_coated_steel_brown)."\r\n";
   $email_message .= "Powder Coated Steel Yellow: ".clean_string($powder_coated_steel_yellow)."\r\n";
   $email_message .= "Powder Coated Steel Red: ".clean_string($powder_coated_steel_red)."\r\n";
   $email_message .= "Powder Coated Steel Gray: ".clean_string($powder_coated_steel_gray)."\r\n";
   $email_message .= "Powder Coated Steel Burgendy: ".clean_string($powder_coated_steel_burgendy)."\r\n";
   $email_message .= "Thermo Plastic Coated Type Expanded: ".clean_string($thermo_plastic_coated_type_expanded)."\r\n";
   $email_message .= "Thermo Plastic Coated Type Perforated: ".clean_string($thermo_plastic_coated_type_perforated)."\r\n";
   $email_message .= "Thermo Plastic Coated Black: ".clean_string($thermo_plastic_coated_black)."\r\n";
   $email_message .= "Thermo Plastic Coated Blue: ".clean_string($thermo_plastic_coated_blue)."\r\n";
   $email_message .= "Thermo Plastic Coated Brown: ".clean_string($thermo_plastic_coated_brown)."\r\n";
   $email_message .= "Thermo Plastic Coated Gray: ".clean_string($thermo_plastic_coated_gray)."\r\n";
   $email_message .= "Thermo Plastic Coated Red: ".clean_string($thermo_plastic_coated_red)."\r\n";
   $email_message .= "Thermo Plastic Coated Green: ".clean_string($thermo_plastic_coated_green)."\r\n";
   $email_message .= "Recycle Plastic Red: ".clean_string($recycle_plastic_red)."\r\n";
   $email_message .= "Recycle Plastic Yellow: ".clean_string($recycle_plastic_yellow)."\r\n";
   $email_message .= "Recycle Plastic Black: ".clean_string($recycle_plastic_black)."\r\n";
   $email_message .= "Recycle Plastic Blue: ".clean_string($recycle_plastic_blue)."\r\n";
   $email_message .= "Recycle Plastic Gold: ".clean_string($recycle_plastic_gold)."\r\n";
   $email_message .= "Recycle Plastic Redwood: ".clean_string($recycle_plastic_redwood)."\r\n";
   $email_message .= "Recycle Plastic Cedar: ".clean_string($recycle_plastic_cedar)."\r\n";
   $email_message .= "Recycle Plastic Green: ".clean_string($recycle_plastic_green)."\r\n";
   $email_message .= "Recycle Plastic Gray: ".clean_string($recycle_plastic_gray)."\r\n";
   $email_message .= "Recycle Plastic Brown: ".clean_string($recycle_plastic_brown)."\r\n";
   
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers);
header("Location: $thankyou");
?>
<script>location.replace('<?php echo $thankyou;?>')</script>
<?
}
?>