Learn VBA & Macros in 1 Week!

PHP - Form _post Help

Full Excel VBA Course - Beginner to Expert

Form _post Help	View Content

Hi All,

I am having a bit of difficulty with a form I've built that has some PHP elements in it. The issue is it is just not sending the values (which are in hidden fields).

Code is:

Code: [Select]
while($row = mysql_fetch_array($result)){

echo '<tr style="padding: 15px;">';
echo '<td>' . $row['product_id'] . '</td>';
echo '<td>' . $row['name'] . '</td>';
echo '<td>' . $row['catalogue_id'] . '</td>';
?>
<td>
<form method="post" enctype="multipart/form-data" action="<?php echo str_replace( '%7E', '~', $_SERVER['REQUEST_URI']); ?>">

<input type="hidden" name="editform" value="Y">

<input type="hidden" name="prodid" value="<?php echo $row['product_id'] ?>">
<input type="hidden" name="prodname" value="<?php echo $row['name'] ?>">
<input type="hidden" name="catalogue_id" value="<?php echo $row['catalogue_id'] ?>">
<input type="hidden" name="full_description" value="<?php echo $row['full_description'] ?>">
<input type="submit" name="Edit" value="<?php _e('Edit', 'pmimp_trdom' ) ?>" />
</form>
</td>

Would it have something to do with splitting up the php tags?
Any help would be apprecited!

Thanks!

Full Excel VBA Course - Beginner to Expert

Php Form, $_get, & $_post

Similar Tutorials

View Content

My form values are not posting on my thankyou.php page. I'm sure it's a simple fix.

Here's some code from reservation.php .
form action="CGI/gdform.php" method="post" enctype="application/x-www-form-urlencoded" name="formres" id="formres">
    <input type="hidden" name=" redirect" value="ThankYou.php">
   <label><span class="style12">Your Name:
   <input type="text" name="txtName" id="Name" />
   </span></label>
  ...
<p class="style12"><span id="sprytextfield10">
   <label>Date of Special Event:
   <input type="text" name="DateReq" id="DateReq" />
   </label>
<?php
$txtName = $_GET[txtName];
...
$DateReq = $_GET[DateReq];
?>
</form>

On my thankyou.php:
<body>

<?php
$txtName = $_POST[txtName];
...
$DateReq = $_POST[DateReq];

?>

and a little lower down...
<?php echo $txtName ?>
...
<?php echo $DateReq ?>

Any reason why the thank you page isn't calling the values? I exhaustively checked it against a working form I have on another site, and the code seems to be, well, identical.

Not getting an error, just get empty space where the values should be.

Form Submission $_post

Similar Tutorials

View Content

can someone visually just read through my code and let me know if this looks like it'll work? I'm not getting any errors in my IDE so now I want to double check the structure

<?php
require_once '/usr/local/cpanel/3rdparty/lib/php/Mail.php';

$db_server = 'localhost';
$db_user = '-----';
$db_pass = '-----';

$dbc = mysql_connect ($db_server, $db_user, $db_pass);
if (!$dbc) {
    die(mysql_error());
    header ('Location: /contact');
    exit;
}

if ($_POST['contactsent'] != 'yes') {
    header ('Location: /contact');
    exit;

} else {

if (is_array($_POST)) {
        foreach ($_POST as $key => $value) {
            $_POST[$key] = mysql_real_escape_string(stripslashes($value));
        }
    }

    $RequestType      = $_POST["RequestType"];
    $ConsumerBusiness = $_POST["ConsumerBusiness"];
    $GlobalLocation   = $_POST["GlobalLocation"];
    $FirstName        = strtolower(str_replace("'","''",$_POST["FirstName"]));
    $FirstName        = strtoupper(substr($FirstName,0,1)).substr($FirstName,1);
    $LastName         = strtolower(str_replace("'","''",$_POST["LastName"]));
    $LastName         = strtoupper(substr($LastName,0,1)).substr($LastName,1);
    $Email            = strtolower(str_replace("'","''",$_POST["Email"]));
    $Title            = strtolower(str_replace("'","''",$_POST["Title"]));
    $Title            = strtoupper(substr($Title,0,1)).substr($Title,1);
    $Company          = strtolower(str_replace("'","''",$_POST["Company"]));
    $Company          = strtoupper(substr($Company,0,1)).substr($Company,1);
    $Address          = strtolower(str_replace("'","''",$_POST["Address"]));
    $Address          = strtoupper(substr($Address,0,1)).substr($Address,1);
    $City             = strtolower(str_replace("'","''",$_POST["City"]));
    $City             = strtoupper(substr($City,0,1)).substr($City,1);
    $State            = $_POST["State"];
    $Zip              = $_POST["Zip"];
    $Phone            = $_POST["Phone"];
    $F              = $_POST["F"];
    $ProductDesc      = $_POST["ProductDesc"];
    $Comment          = $_POST["Comment"];

    if ($GlobalLocation == "Canada"):
        $SendTo="canadainfo@------.com";
    elseif ($GlobalLocation == "Central America"):
        $SendTo="customer.service@------.com.pa";
    elseif ($GlobalLocation == "Europe"):
        $SendTo="marketing@-----.uk";
    elseif ($GlobalLocation == "Mexico"):
        $SendTo="ventas@------.com.mx";
    else:
        $SendTo="info@------.com";
    endif;

function dbSet($fields, $source = array()) {
    $set='';
    if (!source) $source = &$_POST;
    foreach ($fields as $field) {
        if (isset($source[$field])) {
            $set.="`$field`='".mysql_real_escape_string($source[$field])."', ";
        }
    }
    return substr($set, 0, -2);
}

// INSERT INTO DATABASE
            mysql_select_db("new_contact",$dbc) or die("Could not select new_contact");

$fields =   explode(" ", "RequestType ConsumerBusiness GlobalLocation FirstName LastName Email Title Company Address City State Zip Phone F ProductDesc Comment");
            $query = "INSERT INTO new_contact SET ".dbSet($fields, $_POST);
            mysql_query($query);

// SETUP EMAIL
$Bodycopy = "This information was submitted via the ------.com website and sent to you because of the location
        identified by the user. <br>If this has reached you in error, please forward this email to info@------.com";
$Bodycopy. "<br>----------------------------------------------------------------------------------------------<br><br>";

        if ($RequestType != "")      $Bodycopy. "What kind of information do you need? : " .$RequestType. "<br>";
if ($ConsumerBusiness != "") $Bodycopy. "What type of customer or vendor are you? : " .$ConsumerBusiness. "<br>";
if ($GlobalLocation != "")   $Bodycopy. "Global Location : " .$GlobalLocation. "<br>";
if ($Company != "")          $Bodycopy. "Company : " .$Company. "<br>";
if ($FirstName != "")        $Bodycopy. "First Name : " .$FirstName. "<br>";
if ($LastName != "")         $Bodycopy. "Last Name : " .$LastName. "<br>";
if ($Title != "")            $Bodycopy. "Title : " .$Title. "<br>";
if ($Email != "")            $Bodycopy. "Email : " .$Email. "<br>";
if ($Address != "")          $Bodycopy. "Address : " .$Address. "<br>";
if ($City != "")             $Bodycopy. "City : " .$City. "<br>";
if ($State != "")            $Bodycopy. "State : " .$State. "<br>";
if ($Zip != "")              $Bodycopy. "Zip/Postal Code : " .$Zip. "<br>";
if ($Phone != "")            $Bodycopy. "Phone : " .$Phone. "<br>";
if ($F != "")              $Bodycopy. "F : " .$F. "<br>";
if ($ProductDesc != "")      $Bodycopy. "UPC or product description : " .$ProductDesc. "<br>";

$Bodycopy. "<br>----------------------------------------------------------------------------------------------<br><br>";

if ($Comment != "")          $Bodycopy. "Comments : <br>" .$Comment. "<br>";

        $Bodycopy. "<br><br>";
        $Bodycopy. $IP = $_SERVER["remote_addr"];

// PROCESS EMAIL

// mail server info...

        $from = $SendTo;
        $to = "Do Not Reply <donotreply@------>";
        $subject = "Website Contact : " . $GlobalLocation;
        $body = $Bodycopy;
        $host = "mail.------";
        $port = "25";
        $username = "donotreply@-------";
        $password = "-------";

        $headers = array ('From' => $from,
        'To' => $to,
        'Subject' => $subject);
        $smtp = Mail::factory('smtp',
        array ('host' => $host,
         'auth' => true,
         'port' => $port,
         'username' => $username,
         'password' => $password));

        $mail = $smtp->send($to, $headers, $body);

        if (PEAR::isError($mail)) {
        echo("<p>" . $mail->getMessage() . "</p>");
        } else {
        echo("<p>Message successfully sent!</p>");
        }

// MAKE SURE DB CONN IS CLOSED
        mysql_close($dbc);

// REDIRECT TO THANK YOU PAGE
        header ('Location: /index.php?option');
        exit();

}

?>

Form $_post Problem!

Similar Tutorials

View Content

Hi there I'm trying to make this form submit...but alas, is to no avail .... i have two forms on top of each other one of them is:

Code: [Select]
<form name="entries_form" method="post" action="index.php">
<table>
<tr>
<th><label>Date</label></th>
<th><label>From</label></th>
<th><label>To</label></th>
<th><label>Break</label></th>
<th><label>Hours</label></th>
<th><label>Required Hours</label></th>
<th><label>Notes</label></th>
</tr>
<tr>
<td>

<input name="Date" type="text" id="Date" />
</td>
<td>

<input name="From" type="text" id="From" />
</td>
<td>
<input name="To" type="text" id="To" />
</td>
<td>

<input name="Break" type="text" id="Break" />
</td>
<td>

<input name="Hours" type="text" id="Hours" />
</td>
<td>

<input name="Rqrd_hrs" type="text" id="Rqrd_hrs" />
</td>
<td>

<input name="Notes" type="text" id="Notes" />
</td>
<td>
<input type="submit" name="Save" value="Save" id="Save" style="background-color:#7A70A4;" />
</td>
</tr>
</table>
</form>
to post i'm using this code (to much over the top maybe):
Code: [Select]
<?php

$session = new Session();
$u_id = $session->get('id'); //to get the user id from session

if(isset($_POST['submit']) == 'Save'){//form's button  name is Save
$entry->user_id = $user_id = $u_id;
        $entry->date = $date = trim(strtolower($_POST['Date']));
        $entry->start_time = $start_time = trim(strtolower($_POST['From']));
        $entry->end_time   = $end_time   = trim(strtolower($_POST['To']));
$entry->breaks      = $break   = trim(strtolower($_POST['Break']));
$entry->total_hours   = $total_hours   = trim(strtolower($_POST['Hours']));
$entry->reqd_hours   = $required_hours   = trim(strtolower($_POST['Rqrd_hrs']));
$entry->notes   = $notes   = trim(strtolower($_POST['Notes']));

        $entry->add_entry();
    }else die("Not Posted");
    ?>
the add entry() function does the following:
Code: [Select]
public function add_entry(){
global $database;
$sql = "INSERT INTO sheetentries (";
$sql .= "user_id, date, start_time, end_time, break, required_hours, total_hours, notes";
$sql .= ") VALUES ('";
$sql .= $this->user_id ."', '";
$sql .= $this->date ."', '";
$sql .= $this->start_time ."', '";
$sql .= $this->end_time ."', '";
$sql .= $this->breaks ."', '";
$sql .= $this->reqd_hours ."', '";
$sql .= $this->total_hours ."', '";
$sql .= $this->notes ."')";
$database->query($sql);
}
the user_id or $u_id brought from the session when the user loggs in:
Code: [Select]
$u_id = $session->get('id');
anyway, whenever i try submitting the form nothing happens, what am i missing,,, thanks in advance

Hidden Form & _post

Similar Tutorials

View Content

This is just a snippet of my code. The php script itself is called test.php and so it calls itself once the form is submitted. I keep having problems retrieving the data back correctly; I am testing in retrieving the data on the same script from the same page before retrieving the POST data from another webpage.

If $decimalSum is a variable that assigns a value that is hard-coded then I would be able to retrieve the same value. However, if the value is computed I can not retrieve it unless I click on the "Find" button twice. This is such a strange behavior and I don't know why.

Does anyone have any suggested solutions to this?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title></title>
</head>
<body>

<?php
echo '<form enctype="multipart/form-data" method="post" action="test.php">';

echo '   <label for="_firstName">First name :     </label>';
echo '   <input type="text" id="_firstName" name ="_firstName">';
echo '   <input type="checkbox" value="1" name="_firstNameChecked"/>';

echo '   <label for="_middleName">Middle name :     </label>';
echo '   <input type="text" id="_middleName" name ="_middleName">';
echo '   <input type="checkbox" value="1" name="_middleNameChecked" />';

echo '   <label for="_lastName">Last name :     </label>';
echo '   <input type="text" id="_lastName" name ="_lastName">';
echo '   <input type="checkbox" value="1" name="_lastNameChecked" />';

echo '<br />';

echo '<input type="submit" name="Find" value="Find" />';

$firstNameChecked        = intval(($_POST['_firstNameChecked']));
$middleNameChecked    = intval(($_POST['_middleNameChecked']));
$lastNameChecked         = intval(($_POST['_lastNameChecked']));

$decimalSum = (int)((2*2*2)*$firstNameChecked + (2*2)*$middleNameChecked + (2*1)*$lastNameChecked);

//$decimalSum = 28;

echo '<br />';
echo '$decimalSum = ' . $decimalSum . '<br />';

echo '<input type="hidden" name="_decimalSum" value = "' . $decimalSum . '" />';

$decimalSum2      =     ($_POST['_decimalSum']);

echo '$decimalSum2  = ' . $decimalSum2 . '<br />';

echo '</form>';
echo '</body>';
echo '</html>';
?>

How Can I Test The $_post Array To See If It Is Set By The Form

Similar Tutorials

View Content

I have a form that is populating fields based on a database query. I am then trying to update the database based on any changes made in the form and passed through a POST action.

The problem I am having is with the block where I declare short variable names for the $_POST variables that will be passed when the user hits the submit button. For each variable declaration I get an error message like this:
Quote

Encountered error: 8 in mbr_profile_updt_form.php, line 130: Undefined index: email

I have tried testing the $_POST variable using the isset function but it apparently is set but empty.

What would be a good way to test to see if the user has pressed the submit button before I go into the processing block that is intended to handle those values from the form?

Here is where my code is at right now:
Code: [Select]
if (!isset($_POST))
{
throw new Exception('You have not filled the form out completely - please go back'
.' and try again.');
}
else
{
//filled in so create short variable names
$email=$_POST['email'];
$first_name=$_POST['first_name'];
$last_name=$_POST['last_name'];

Form: $_post 2 Values From Each Checkbox And Button

Similar Tutorials

View Content

So, i need this.

$_post Won't Work!! Form Validation Php/html

Similar Tutorials

View Content

Hi there. My problem is quite simple, but carries lots of questions of why the hell is this happening.

I'm new at PHP but I'm familiar with the syntax, since It's been 3 years since I code in C, 1 in Java and half year in JS (with HTML and CSS of course).

I was creating a page where I could validate a HTML form using PHP script, it was going everything allright, until I couldn't use the data that was going to the $_POST array. I tested it on some other file and It was like the server just didn't allowed me to do it so. I searched around on internet and I found the print_r() function, which shows the data as an associative array in $_POST, like this: array(KeyName => ValueName).

Check the code and please, help me find why is this happening. I'm brazillian and all I know about english came from netflix, so i'm sorry if I wrote anything wrong. Thanks S&Z

<!DOCTYPE html>
<html lang = "pt-br" >
   <head>
       <title>
           Formulário
       </title>
       <meta charset="utf-8">
   </head>
   <body>
       <form method = "POST" action = "<?php htmlspecialchars($_SERVER["PHP_SELF"]);?>" autocomplete = "off">
           Nome: <br>
           <input type = "text" name = "Name" placeholder = "Ex: Guilherme" required autofocus>
           <?php
               if($_SERVER["REQUEST_METHOD"] == $_POST){
                   echo $_POST["Name"];
               }
           ?>
           <br><br>
           <input type = "submit" value = "Enviar">
       </form>
       <?php
           print_r($_POST);
       ?>
   </body>
</html>

Issue With Form Sending Proper $_post Data

Similar Tutorials

View Content

I usually hate to post something like this as a first post...I'd like to at least do an into but I"m stumped and I think it's a totally stupid thing I"m not noticing. Anyway, this is the final step in a three step user verification; this is for a staff user to be verified. Anyway, by now they have already verified their email and entered a random code so I"m only worried about actually setting them to verified status in my database so they can start working on blogs etc.

Anyway, this form is supposed to find all unverified staff members, and allow an admin to easily just click down the list (one at a time currently) and verify the user (ie. setting their database status to verified_staffUser). The username that is supposed to be verified (or declined and therefore their entry deleted) is supposed to be passed through as $_POST[vnsupUsername]. This is set each time it loops through and prints a new user.

The problem is that it's only sending the final username when I click verify/decline on any user :\. I"m not sure why it's doing this. In firebug on firefox it's showing that the user name is set for each one to be properly in the form...but when I click on it (I am having on my machine) the username being worked with echoed..and it's always the last one that was entered into the database. I have no idea why this is happening ..any thoughts?

Code: [Select]
<?php
if(isset($_GET[vnsufac]) || isset($_POST[svnsu]) || isset($_POST[dvnsu])){
// simply prints the back home button
echo "<form action=\"http://localhost/~atharp1122/OGirly_Site/ogirly_staff_homepage.php\" method=\"post\">"
        ."<input type=\"submit\" value=\"Back to Staff Homepage\" style=\"margin-top:10px;\">";

// this will print out the form to verify/deny all new staff user requests that have been email verified
$programCheckUVStaff = mysql_query("SELECT username, email, firstname, lastname FROM staffUNAP where verified_staff = '0'");
while($UVStaff = mysql_fetch_assoc($programCheckUVStaff)){
      print "<div class=\"newVerifyUserContain\" >";
    print "<div class=\"newVerifyUser\" >";
  echo "<h3 style=\"text-align: center;\">Would you like to verify this Staff request?</h3>";
    echo "<table><tr><td>"
      ."<img src=\"images/default_icons/di_bunny_rabbit.png\" width=\"56\" height=\"59\" />"
  ."<ul style=\"padding-left: 100px; padding-bottom: 20px; margin-top: -42px; list-style-type: none;\"><li>"
  ."{$UVStaff[username]} aka {$UVStaff[firstname]} {$UVStaff[lastname]}</li><li>"
  ."{$UVStaff[email]}</li></ul></td></tr><tr><td>"
    ."<form action=\"{$_SERVER[PHP_SELF]}\" method=\"post\">"
      ."<input type=\"checkbox\" name=\"isadmin\" value=\"1\" style=\"margin-left: 10px;\">Is Admin?"
."<input type=\"hidden\" name=\"vnsupUsername\" value=\"{$UVStaff['username']}\">"
  ."<input type=\"submit\" name=\"svnsu\" value=\"Verify Staff\" style=\"margin-left: 200px;\">"
  ."<input type=\"submit\" name=\"dvnsu\" value=\"Decline Request\">";
    print "</table>";
  print "</div></div>";
}
}
// verify a staff member
if(isset($_POST[svnsu])){
echo "verifying a new user";
echo $_POST[vnsupUsername];
}
?>

Can I Use A Value="" In A Form Tag To Select A Db Table From $_post?

Similar Tutorials

View Content

I want to post some form identifyer when I hit submit, so that I can use this in an SQL query.

Previously I used the below code and would retrieve either page1.php or page2.php etc from $_POST['subject']);

Code: [Select]
<td>
<select name="subject" id="subject" onchange="gotourl(this.value)">
<option value="" >Please Select</option>
<option value="page1.php" >page1</option>
<option value="page2.php">page2</option>
<option value="page3.php">page3</option>
</select>
</td>

will this work?

Code: [Select]
<form id="form1" name="form1" value="tableName" method="post" action="">

$_POST['form1']) returns tableName......

Thanks

Using _post

Similar Tutorials

View Content

hey guys
I know this is html but I'm using the php $_POST to grab the information the user chooses, i can't figure out though how to grab the info i'm looking for in this select option form
if they choose PasswordCracker v3.0 what is it i'm looking to set my $_post['']; to?

<FORM action="buy.php" method="POST">
    <select name="passwordcrakers">
      <option value="v2.0">PasswordCracker V2.0</option>
      <option value="v3.0">PasswordCracker V3.0</option>
      <option value="v4.0">PasswordCracker V4.0</option>
      <option value="v5.0">PasswordCracker V5.0</option>
      <option value="v6.0">PasswordCracker V6.0</option>
      <option value="v7.0">PasswordCracker V7.0</option>
      <option value="v8.0">PasswordCracker V8.0</option>
      <option value="v9.0">PasswordCracker V9.0</option>
      <option value="v10">PasswordCracker V10</option>
        </select><br />
<input type="submit" value="Buy" name="submit" />
</FORM>

How To Keep $_post Value

Similar Tutorials

View Content

I use a form to sent date and use php to display it . However , the code only can working on one page. I can not turn the page. I do not why . Please tell me reason . Thank you very much.

<select name="kind">
<option >kind</option>
<option value="Copier Toner">Copier Toner</option>
<option value="Laser Toner">Laser Toner</option>
<option value="MICR Toner">MICR Toner</option>
<option value="Inkjet">Inkjet</option>

php code

if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 18;

$select="select * from $chun where brand = '$_POST[brand]' or sort ='$_POST[kind]' or type='$_POST[type]' LIMIT $start_from, 18";

$result2=mysql_query($select, $connection) or die (mysql_error());

<?php
   $sql = "select count(*) from $chun where brand = '$_POST[brand]' or sort='$_POST[kind]' or type='$_POST[type]' ";


$rs_result = mysql_query($sql,$connection);
$row = mysql_fetch_row($rs_result);
$total_records = $row[0];
$total_pages = ceil($total_records / 18);

for ($i=1; $i<=$total_pages; $i++) {

?>

<div class="trunpage"><a href='table2.php?page=<?php echo "$i" ; ?>&id=<?php echo "$_POST[brand]";?>&cd=<?php echo "$_POST[kind]";?>&td=<?php echo "$_POST[type]";?>' ><?php echo "$i" ; ?></a>

     </div>

The first page is working fine. The second page I get error message.

Undefined index: brand in C:\wamp\www\php1000\table2.php on line 234

$_post

Similar Tutorials

View Content

ok am workin on this script its a points market for a text based game but my money is not taking the amount of the players i points on the market ... just say i post 10 points for $29.000.000 ... and when the player buys the points it takes the money from that user and give the user points but .... when the user buy the points it dont give the user the money it give $290 ?? not sure is its my SQL av post that to

Code: [Select]
<?php
include 'header.php';

$_POST['buypoints'] =  abs(intval($_POST['buypoints']));{

$result = mysql_query("SELECT * FROM `pointsmarket` WHERE `id`='".$_POST['points_id']."'");
    $worked = mysql_fetch_array($result);
    $price = $worked['price'];
    $amount = $worked['amount'];
$totalcost = $price * prettynum($_POST['amount']);
$newpointsinmarket = $amount - prettynum($_POST['amount']);
$user_points = new User($worked['owner']);

if ($worked['owner'] == $user_class->id) {
echo Message("You have taken ".$_POST['amount']." points off the market.");
$newpoints = $user_class->points + $_POST['amount'];;
$result = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$user_class = new User($_SESSION['id']);
if ($newpointsinmarket == 0){
$result = mysql_query("DELETE FROM `pointsmarket` WHERE `id`='".$worked['id']."'");
} else {
$result = mysql_query("UPDATE `pointsmarket` SET `amount` = '".$newpointsinmarket."' WHERE `id`='".$worked['id']."'");
}
include 'footer.php';
die();
}
$_POST['amount'] =  abs(intval($_POST['amount']));
$_POST['points_id'] = abs(intval($_POST['points_id']));{

}
$_POST['amount'] =  abs(intval($_POST['amount']));
$_POST['points_id'] = abs(intval($_POST['points_id']));{

}
if ($totalcost > prettynum($user_class->money)){
echo Message("You don't have enough money.");
}
if($_POST['amount'] >= 1 && $_POST['amount'] <= $amount && $totalcost <= $user_class->money){
echo Message("You have bought ".$_POST['amount']." points for $".$totalcost);
$newpoints = $user_class->points + $_POST['amount'];
$newmoney = $user_class->money - $totalcost;
$result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."', `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$newmoney = $user_points->money + $totalcost;
$result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."' WHERE `id`='".$user_points->id."'");
$user_class = new User($_SESSION['id']);
if ($newpointsinmarket == 0){
$result = mysql_query("DELETE FROM `pointsmarket` WHERE `id`='".$worked['id']."'");
} else {
$result = mysql_query("UPDATE `pointsmarket` SET `amount` = '".$newpointsinmarket."' WHERE `id`='".$worked['id']."'");
}
}
}

$_POST['addpoints'] =  abs(intval($_POST['addpoints']));
$_POST['id'] = abs(intval($_POST['id']));{

}
if($_POST['amount'] < 1){

}
if($_POST['price'] < 1){

}
if ($_POST['amount'] >= 1 && prettynum($_POST['amount']) <= $user_class->points && $_POST['price'] >= 1){
echo Message("You have added ".$_POST['amount']." points to the market a price of $".$_POST['price']." per point.");
$result= mysql_query("INSERT INTO `pointsmarket` (owner, amount, price)"."VALUES ('$user_class->id', '$_POST[amount]', '$_POST[price]')");
$newpoints = $user_class->points - $_POST['amount'];
$result = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$user_class = new User($_SESSION['id']);
}

?>
<link href="style.css" rel="stylesheet" type="text/css" />

<tr><td class="contenthead">Point Market</td></tr>
<tr><td align="center" class="contentcontent">
<p> </p>
<p><strong>You need to be a Respected Warrior to add points to the market</strong><br>
Use this form to add points to the points market.</p>
<p><strong>Bank Account[<? echo prettynum($user_class->bank) ?>]</strong><strong></strong><br />
<strong><a href="pointmarket.php">[Refresh</a>]</strong></p>
<form method='post'>
<table align="center">
<tr>
<td>Amount of points</td><td>  <input name='amount' type='text' class="areatest" value='0' size='10' maxlength='20'></td>
</tr>
<tr>
<td>Price per point</td><td>$<input name='price' type='text' class="areatest" value="0" size='10' maxlength='20'></td>
<tr><td align="center" colspan="2"><input name='addpoints' type='submit' class="buttong" value='Add Points'></form></td>
</tr></table>
</td></tr>
<tr><td class="contentcontent">
<?php
$result = mysql_query("SELECT * FROM `pointsmarket` ORDER BY `price` DESC");
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$user_points = new User($line['owner']);
if ($user_points->id == $user_class->id){
$submittext = "Remove";
} else {
$submittext = "Buy";
}
echo "<form method='post'>";
echo $user_points->formattedname." - ".$line['amount']." points for ".prettynum($line['price'],1)." per point <input type='text' name='amount' size='3' maxlength='20' value='".prettynum($line['amount'])."'><input type='hidden' name='points_id' value='".$line['id']."'><input type='submit' name='buypoints' value='".$submittext."'></form><br>";
}
?>
</td></tr>
<?php
include 'footer.php';
?>

SQL
Code: [Select]
CREATE TABLE IF NOT EXISTS `pointsmarket` (
`owner` int(10) NOT NULL default '0',
`amount` text NOT NULL,
`price` text NOT NULL,
`id` int(10) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=81 ;

$_post Not Getting Sent.

Similar Tutorials

View Content

Hello,

My script here is not sending POST vars from form to script. I can't figure it out.

Form:
Code: [Select]
<form action="train2.php" method="POST">
<tr>
<td colspan="4"><center><img src="pic/toppage16.gif" /></center></td>
</tr>

<TR> <TD><FONT COLOR="white">Reassign Miners</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength="8" value="0" name="miner>"</FONT></TD>

</TR>

<TR>

<TD><FONT COLOR="white">Reassign Normal Attackers</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength="8" value="0" name="atsold"></FONT></TD>

</TR>

<TR>

<TD><FONT COLOR="white">Reassign Normal Defenders</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size=6 maxlength=8 value=0 name="defsold"></FONT></TD>

</TR>

<TR>

<TD><FONT COLOR="white">Reassign Covert Agents</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size=6 maxlength=8 value=0 name="spy"></FONT></TD>

</TR>

<TR> <TD><FONT COLOR="white">Anti Covert Agents</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD><TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength=8 value=0 name="spykiller"></FONT></TD></TR>

<TR> <TD align=middle colSpan=3><FONT COLOR="white"><INPUT type="submit" value="UnTrain!" name="untrain">
</FONT>

</TD>

</form>

Code: [Select]
<?php
if(isset($_POST['untrain'])){

die($_POST['miner']);
$miners = securevar($_POST['miner']);
$nattackers = securevar($_POST['atsold']);
$ndefenders = securevar($_POST['defsold']);
$covertunits = securevar($_POST['spy']);
$anticovertunits = securevar($_POST['spykiller']);

$totalunits+=$miners;
$totalunits+=$nattackers;
$totalunits+=$ndefenders;
$totalunits+=$covertunits;
$totalunits+=$anticovertunits;

if($totalunits>=1){
$q = "UPDATE `accountinfo_db` SET `miners_1` = `miners_1`-'$miner', `attackers_1` = `attackers_1`-'$natta', `defenders_1` = `defenders_1`-'$ndefe', `covertagents` = `covertagents`-'$cover', `anticovertagents` = `anticovertagents`+'$antic', `untrainedunits` = `untrainedunits`+'$totalunits' WHERE `id` = '$id'";
$res = mysql_query($q) or die(mysql_error());

if(isset($res)){
header("Location: train.php?strmsg=".$totalunits."Troops Untrained! For 0 Naquadah.");
}

}else{
header("Location: train.php?strmsg=You must enter atleast 1 troop to be un-trained!");
}

}

?>

when I die($_GET['miner'); nothing is outputed even tho I submited the data.

Thank you,
Brian

$_post Help

Similar Tutorials

View Content

Hi guys, running through this tutorial at the moment:

http://www.tizag.com/phpT/forms.php

I seem to keep having problems with the $_POST variable. Is that obsolete syntax now?

Here's the part I get an error on:

<html>
<body>
<?php
$quantity=$_POST['quantity'];
$item=$_POST['item'];

echo "You ordered".$quantity."".$item.".<br/>.";
echo "Thank you for ordering from Boombaby art supppplies!";

?>
</body>
</html>

Here's the error:

( ! ) Notice: Undefined index: quantity in C:\wamp\www\process.php on line 4
Call Stack
#   Time   Memory   Function   Location
1   0.0009   363936   {main}( )   ..\process.php:0

( ! ) Notice: Undefined index: item in C:\wamp\www\process.php on line 5
Call Stack
#   Time   Memory   Function   Location
1   0.0009   363936   {main}( )   ..\process.php:0
You ordered.
.Thank you for ordering from Boombaby art supppplies!

Any help would be appreciated. I tried googling but everything didn't seem to answer my question or was too confusing.

Thanks.

Php $_post[' ']

Similar Tutorials

View Content

Hi guys,

I have a form using radio buttons.
For the radio button, lets just say i have the id name as 'rim' + number eg; rim0, rim1, rim2....

When i post the data to another file to execute the data collected, naturally i would use the:
Code: [Select]
$rim0=$_POST['rim0'];
$rim1=$_POST['rim1'];
....
$rim10=$_POST['rim10'];
i tried to shorten this process using this method:
Code: [Select]
//$q is part of the post variable.
for($x = 0; $x < count($q); $x++){

$rim[]=$_POST['"rim"."$x"'];
}
But i get this error
Code: [Select]
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Is there something wrong with my POST syntax?

$_get And $_post

Similar Tutorials

View Content

Well, i have got this code:

Code: [Select]
<?php
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<form action="signature.php?user=" .$user. "&img=". $img" method="post">
<input name="user" type="text" />
<select name="img">
<option value="blue">Blue</option>
<option value="red">Red</option>
<option value="purple">Purple</option>
<option value="pink">Pink</option>
</select>

<?php
$user = $_POST['user'];
$img = $_POST['img'];
?>
<input type="submit" value="Submit" />

<?php
//Skill Grabs
$order = array("Overall",
                        "Attack",
                        "Defence",
                        "Strength",
                        "Hitpoints",
                        "Ranged",
                        "Prayer",
                        "Magic",
                        "Cooking",
                        "Woodcutting",
                        "Fletching",
                        "Fishing",
                        "Firemaking",
                        "Crafting",
                        "Smithing",
                        "Mining",
                        "Herblore",
                        "Agility",
                        "Thieving",
                        "Slayer",
                        "Farming",
                        "Runecraft",
                        "Hunter",
                        "Construction",
                        "Summoning",
                        "Dungeoneering");

$user = $_GET['user']; //Change this to the variable (Or a string literal) that contains the username
$get = file_get_contents("http://hiscore.runescape.com/index_lite.ws?player=$user");
$get = explode("\n", $get);
$i = 0;

foreach ($order as $key => $value)
{
        $value = strtolower($value);
        $temp = explode(",", $get[$i]);
        $temp = array("rank" => $temp[0], "level" => $temp[1], "exp" => $temp[2]);
        $stats[$value] = $temp;
        $eval = "\$$value = array(\$temp[\"rank\"], \$temp[\"level\"], \$temp[\"exp\"]);";
        eval($eval);
        $i++;
}

//End Skill Grabs

// specify the file name - you can use a full path, or "../../" type stuff here
// if the image is not in the same directory as this code file
$image = imagecreatefrompng("http://slay2day.x10.mx/highscores/signatures/".$_GET['img'].".png");

// specify the font size

// in this case, the color is white, but you can replace the numbers with the RGB values
// of any color you want
$color = imagecolorallocate($image, 255,255,255);

// and now we do the overlay - the layers of text start top to bottom, so
// the drop shadow comes first

// $image - the base image file we specified above
// $font_size - Well duh. Its the size of the font
// 0 - the angle of the text - we don't want an angle, so we leave it at 0
// 55 - pixels to the right from the leftmost part of the image
// 35 - pixels down from the top of the image
// $black - the color we defined above
// "../fonts/ARIALBD.TTF" - the location on the server that the font can be found
// "Test Text" - the text we're overlaying - you can also use a variable here

ImageTTFText ($image, "7", 0, 280, 10, $color, "arial.ttf","Slay2day");

ImageTTFText ($image, "12", 0, 240, 55, $color, "biblio.ttf",$user);

if($overall[0]==-1){ImageTTFText($image, "11", 0, 230, 105, $color, "biblio.ttf","NOT RANKED");}else{ImageTTFText($image, "11", 0, 240, 105, $color, "biblio.ttf",$overall[0]);}

ImageTTFText ($image, "10", 0, 27, 20, $color, "arial.ttf",$attack[1]);
ImageTTFText ($image, "10", 0, 27, 42, $color, "arial.ttf",$strength[1]);
ImageTTFText ($image, "10", 0, 27, 64, $color, "arial.ttf",$defence[1]);
ImageTTFText ($image, "10", 0, 27, 88, $color, "arial.ttf",$hitpoints[1]);
ImageTTFText ($image, "10", 0, 27, 114, $color, "arial.ttf",$ranged[1]);

ImageTTFText ($image, "10", 0, 70, 20, $color, "arial.ttf",$prayer[1]);
ImageTTFText ($image, "10", 0, 70, 42, $color, "arial.ttf",$magic[1]);
ImageTTFText ($image, "10", 0, 70, 64, $color, "arial.ttf",$cooking[1]);
ImageTTFText ($image, "10", 0, 70, 88, $color, "arial.ttf",$woodcutting[1]);
ImageTTFText ($image, "10", 0, 70, 114, $color, "arial.ttf",$fletching[1]);

ImageTTFText ($image, "10", 0, 117, 20, $color, "arial.ttf",$fishing[1]);
ImageTTFText ($image, "10", 0, 117, 42, $color, "arial.ttf",$firemaking[1]);
ImageTTFText ($image, "10", 0, 117, 64, $color, "arial.ttf",$crafting[1]);
ImageTTFText ($image, "10", 0, 117, 88, $color, "arial.ttf",$smithing[1]);
ImageTTFText ($image, "10", 0, 117, 114, $color, "arial.ttf",$mining[1]);

ImageTTFText ($image, "10", 0, 162, 20, $color, "arial.ttf",$herblore[1]);
ImageTTFText ($image, "10", 0, 162, 42, $color, "arial.ttf",$agility[1]);
ImageTTFText ($image, "10", 0, 162, 64, $color, "arial.ttf",$thieving[1]);
ImageTTFText ($image, "10", 0, 162, 88, $color, "arial.ttf",$slayer[1]);
ImageTTFText ($image, "10", 0, 162, 114, $color, "arial.ttf",$farming[1]);

ImageTTFText ($image, "10", 0, 212, 20, $color, "arial.ttf",$runecraft[1]);
ImageTTFText ($image, "10", 0, 212, 42, $color, "arial.ttf",$construction[1]);
ImageTTFText ($image, "10", 0, 212, 64, $color, "arial.ttf",$hunter[1]);
ImageTTFText ($image, "10", 0, 212, 88, $color, "arial.ttf",$summoning[1]);
ImageTTFText ($image, "10", 0, 212, 114, $color, "arial.ttf",$dungeoneering[1]);

// Now add the actual white text "on top"

header("Content-type: image/png");
imagepng($image);
imagedestroy($image);
?>
It generates a image and gets data from the name thats in the url. I am wanting to make a form where they fill out their name and what color they use.

What is wrong?

Foreach $_post

Similar Tutorials

View Content

I have a form with radio buttons, depending on if a person selects yes, they will be given an answer after they hit submit.

I don't want to do a bunch if un-necessary coding, so I'm trying something else, but it's not working.

My form is this
Code: [Select]
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td align="center" valign="top">Yes</td>
<td align="center" valign="top"><input type="radio" name="phone1" id="phone1" value="1" /></td>
<td align="center" valign="top">No</td>
<td align="center" valign="top"><input type="radio" name="phone1" id="phone1" value="2" /></td>
</tr>

</table>

My code is this
Code: [Select]
<?php
  if(isset($_POST['submit'])) {

$key;
$key['phone1'] = "testing phone 1";
$key['phone2'] = "testing phone 2.";

foreach( $_POST as $key => $value) {
if($value == "1"){
echo $key."<br />";
}
}
  }
?>

Now, it does not show the wording associated with $key if the value is 1.

Can anybody help me out here? This form is going to have over 100 questions.

Thanks in advance.

Getting Wrong $_post Value

Similar Tutorials

View Content

Hi guys! I need your help..
I'm having a problem in getting the post values from my form,
I have 2 arrays and some values:
Code: [Select]
$total = 3;
$array1 = (branch1, branch2, branch3);
$array2 = (100, 200, 300);
$count = count($array1) - $total;
then i combine them
Code: [Select]
$array3 = combine_array($array1, $array2);
if $count is 0, using a foreach loop i echo each value and key
Code: [Select]
foreach($combined_array as $value => $key)
{
echo "<tr>";

echo "<td><input type='hidden' name='branch' value='{$value}'></td>";
echo "<td id='edit'>" . "<input type='submit' name='edit' value='' />" . "</td>";
echo "<td id='sep'> / </td>";
echo "<td><input type='hidden' name='id' value='{$key}'></td>";
echo "<td id='del'>" . "<input type='submit' name='delete' value='' />" . "</td>";
very simple and it works perfectly fine,
but if the variable $count is not equal to 0, i append both arrays(1 & 2) so that it will be equal to 0. (data appended is not important i just need them for the table output.)
Code: [Select]
for($i = 0; $i < $count; $i++)
{
$array1[] = "null" . $i;
$array2[] = $i;
}
// then combine
$array3 = combine_array($array1, $array2);

// echo each value and key
foreach($combined_array as $value => $key)
{
echo "<tr>";

echo "<td><input type='hidden' name='branch' value='{$value}'></td>";
echo "<td id='edit'>" . "<input type='submit' name='edit' value='' />" . "</td>";
echo "<td id='sep'> / </td>";
echo "<td><input type='hidden' name='id' value='{$key}'></td>";
echo "<td id='del'>" . "<input type='submit' name='delete' value='' />" . "</td>";
echo "</tr>";
i tried to view the code souce and both hidden fields contain correct data but if i tried to delete/edit it doesn't work.
i tried echoing/print_r the $_POST['branch'] & $_POST['id'] after i click on delete/edit and it always gives me the last $value and $key of the combined array for all the submit buttons..

Any thoughts?
As i said the appended data is not important but the problem is once i click delete the original values in array1 and 2 are not what post is giving me..therefore i cannot delete or edit them..
Sorry if my post is too long..
Thanks in advance!

Redefining $_post

Similar Tutorials

View Content

Is it possible to redefine a $_POST after PHP has received the value of it via a HTML form?
Something like this:

if ($_POST['category'] == "Belts") {
$_POST['category'] = "belts";
}

Isset($_post)

Similar Tutorials

View Content

Running into some problems with my code. I am having the user search the Database with either a UAID or the user's full name. It works fine when you input both the UAID and name; however, I want it to work if only one is give (i.e. just the name or just the UAID).

I decided to use the isset($_POST) function of php but I am not getting it to work correctly. PHP believe it is set even though it is empty.

Here is my html form.

<?php
@include 'accesscontrol.php';

echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"
      \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">"
     ."<html xmlns=\"http://www.w3.org/1999/xhtml\">"
     ."<title> Hello </title>"
     ."<meta http-equiv=\"Content-Type\"
      content=\"text/html; charset=iso-8859-1\" />"
     ."<head>"
     ."<style type=\"text/css\">"
     ."h1{"
     ."border-bottom-style: double;"
     ."border-bottom-color: black;"
     ."border-bottom-width: 5px;"
     ."}"
     ."p{"
     ."background-color:#4682B4;"
     ."}"
     ."</style>"
     ."</head>"
     ."<body style=\"background-color:#B8B8B8\">"
     ."<table align=\"center\" style=\"background-color:#B8B8B8\" WIDTH=\"100%\" HEIGHT=\"100%\">"
     ."<tr valign=\"middle\">"
     ."<td align=\"center\">"
     ."<form method=\"post\" action=\"user.php\">"
     ."<table align=\"center\" cellpadding=\"10\" style=\"background-color:#5CADFF\" width=\"500\" height=\"400\">"
     ."<tr>"
     ."<th colspan=6 align=\"center\"><h1>Welcome: ".$uid."</h1></th>"
     ."</tr>"
     ."<tr>"
     ."<td colspan=3 width=40% align=center>"
     ."UAID:<br>  <input type=\"text\" size=\"8\" name=\"UAID\" /></td>"
     ."<td colspan=3 width=60% align=center>"
     ."Name (Last, First):<br><input type=\"text\" size=\"8\" name=\"last\"/>, <input type=\"text\" size=\"8\" name=\"first\" />"
     ."</tr>"
     ."<tr>"
     ."<td colspan=6 align=\"center\"><input type=\"submit\" value=\"submit\" />"
     ."</td>"
     ."</tr>"
     ."</tr>"
     ."</table>"
     ."<tr>"
     ."</tr>"
     ."</td>"
     ."</tr>"
     ."</table>"
     ."</body>"
     ."</html>";

?>

Here is the PHP:

<?php
@include 'accesscontrol.php';
//include 'common.php';
include 'db.php';

$fname = $_POST['first'];
$lname = $_POST['last'];

$sql = "SELECT * FROM `user` WHERE UAID='$_POST[UAID]'";
$result = mysql_query($sql);
$rows = mysql_fetch_array($result);

if(isset($fname) && isset($lname))
{

echo "Post first $fname <br>"
     ."Post last $lname";
$firstname = $rows['firstname'];
$lastname = $rows['lastname'];

if($fname != $firstname OR  $lname != $lastname)
{
?>
<html>
<head>
<script language="JavaScript">
    alert(" Hello this is crap" );
    history.back();
</script>";
</head>
</html>
<?
exit;

}

else
{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"
      \"URL\">"
     ."<html xmlns=URL>"
     ."<title> Hi </title>"
     ."<meta http-equiv=\"Content-Type\"
      content=\"text/html; charset=iso-8859-1\" />"
     ."<head>"
     ."<style type=\"text/css\">"
     ."h1{"
     ."border-bottom-style: double;"
     ."border-bottom-color: black;"
     ."border-bottom-width: 5px;"
     ."}"
     ."p{"
     ."background-color:#4682B4;"
     ."}"
     ."</style>"
     ."</head>"
     ."<body style=\"background-color:#B8B8B8\">"
     ."<table align=\"center\" style=\"background-color:#B8B8B8\" WIDTH=\"100%\" HEIGHT=\"100%\">"
     ."<tr valign=\"middle\">"
     ."<td align=\"center\">"
     ."<table align=\"center\" cellpadding=\"10\" style=\"background-color:#5CADFF\" width=\"600\" height=\"400\">"
     ."<tr>"
     ."<th colspan=6 align=\"center\"><h1>Welcome: ".$uid."</h1></th>"
     ."</tr>"
     ."<tr>"
     ."<form method=\"Post\" action=\"userview.php\">"
     ."<td colspan=3 width=40%>"
     ."UAID:  <input type=\"text\" size=\"8\" name=\"UAID\" value= ".$_POST['UAID']." /></td>"
     ."<td colspan=3 width=60%>"
     ."Name (LAST, FIRST):<input type=\"text\" size=\"8\" name=\"last\"  value= ".$_POST['last']." />,
      <input type=\"text\" size=\"8\" name=\"first\" value= ".$_POST['first']." />"
     ."</td>"
     ."</tr>"
     ."<tr>"
     ."<td colspan=3 width=40%>"
     ."Department:<input type=\"text\" size=\"8\" name=\"department\" value=" .$rows['BOG'].">"
     ."</td>"
     ."<td colspan=3 width=60%>"
     ."Employee ID:<input type=\"text\" size=\"8\" name=\"empID\" value=" .$rows['employeeID'].">"
     ."</td>"
     ."</tr>"
     ."<tr>"
     ."<td colspan=3 align=\"center\"><input type=\"submit\" value=\"View\">"
     ."</form>"
     ."</td>"
     ."<form method=\"Post\" action=\"homepage.php\">"
     ."<td colspan=3 align=\"center\"><input type=\"submit\" value=\"Back\">"
     ."</td>"
     ."</tr>"
     ."</tr>"
     ."</table>"
     ."<tr></tr></td></tr></table></body></html>";

}}
mysql_free_result($result);
?>