PHP - How To Get A Checkbox To Update A Database Onclick Without A Submit Button?

I need to create several buttons that when clicked it updates a field in a table and then passes params to another page (action). I cant seem to figure a logical way of doing this without making things messy, any one have any ideas

When I display the data in my database I have included a radio button in each row. When the button is clicked, the intention is to delete all the information in that row. But it won't delete anything...

Here's the form:
Code: [Select]
<FORM Method = "POST" action ="update_tee_times.php">
 
<?php

include("opendatabase.php"); 

$dateID = $_POST[teetimedate];

$result = mysql_query("
SELECT Date, Player1,Player2,Player3,Player4,Player5,Time, IF( TIME(Time) BETWEEN '17:30:00' AND '19:30:00','FFFF66','FFFFFF') AS color
FROM Daysheets
WHERE Date ='$dateID'"); 

echo "<h1>";
echo date("l, F d, Y", strtotime($dateID));
echo "</h1>";

echo "<table align=center width=700 border=1>\n";
echo "<th>Clear</th><th>Time</th><th>Player 1</th><th>Player 2</th><th>Player 3</th><th>Player 4</th><th>Player 5</th>
<th>M</th><th>W</th><th>G</th>";

$i=0;

while($row = mysql_fetch_array( $result )) 
{
$dateID = $row['Date'];
$timeID = $row['Time'];

echo "<tr>";
echo "<td>";
echo "<input type='radio' name='time1[$i]' value='$timeID'>"; //HERE'S THE RADIO BUTTON
echo "</td><td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player1]' name='player1[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player2]' name='player2[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player3]' name='player3[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player4]' name='player4[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='17' value= '$row[Player5]' name='player5[$i]'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Men]' name='women'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Women]' name='women'
style ='background-color:#{$row['color']};'>";
echo "</td><td>";
echo "<input type='text' size='2' value= '$row[Guest]' name='guests'
style ='background-color:#{$row['color']};'>";

echo "<input type='hidden' name='date[$i]' value='$dateID'>";
echo "<input type='hidden' name='time2[$i]' value='$timeID'>";
echo "</td></tr>";
$i++;
}
echo "</table>";

mysql_close($con);

?>
<br /><br />

<input type="Submit" name="Submit" value="Update Tee Times">
</FORM> And here's the form action:
Code: [Select]
<?php

header("Location: /teetimes/preteetimesadmin.php");

include("opendatabase.php");

$size = count($_POST['player1']);
$timeID1 = $_POST['time1'][$i];

//HERE'S WHERE I'M TRYING TO DELETE THE DATA.
mysql_query("
UPDATE Daysheets
SET 
        Player1='',
        Player2='',
        Player3='',
        Player4='',
        Player5=''
WHERE Time ='$timeID1' ");

//HERE'S THE UPDATE, WHICH WORKS FINE.
$i=0;

while ($i < $size)
     {
     $dateID = $_POST['date'][$i];
     $timeID2 = $_POST['time2'][$i];  
     $player1 = ($_POST['player1'][$i]);
     $player2 = ($_POST['player2'][$i]);
     $player3 = ($_POST['player3'][$i]);
     $player4 = ($_POST['player4'][$i]);
     $player5 = ($_POST['player5'][$i]);

mysql_query("
UPDATE Daysheets
SET 
        Player1='$player1',
        Player2='$player2',
        Player3='$player3',
        Player4='$player4',
        Player5='$player5'

WHERE Date ='$dateID' 
AND Time ='$timeID2' ");
     $i++;
}

mysql_close($con)

?>When I add or update any information it works fine. It just won't delete anything where the radio button is clicked.
Any help appreciated! Thanks.

Hi there.
I have this course registering website whereby i will need to :
1. pull out all course info and display (done that)
2. when user choose the course they are interested in using radio button and click submit , it will display you're registered and update the database to decrease the head count by 1.

i m stuck on the radio button part... after i click submit nothing happens...

Please advice... thanks a lot


Code: [Select]
<html>
<head>
  <title>TimeTable</title>

</head>

<body>
 <h1> Here is the timetable</h1>

<?php


     
  @ $db = new mysqli('localhost', 'root', '', 'mylifestyle');

  if (mysqli_connect_errno()) {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
  
  $query = "SELECT course.CourseName , course.Instructor , course.ClassSize , courseschedule.Date ,courseschedule.Time , courseschedule.Location FROM course INNER JOIN courseschedule ON course.CourseID = courseschedule.CourseID";
  $result = $db->query($query);
  $num_results = $result->num_rows;
  
  
  echo "<table border='1'>
  <tr>
  <th>Course Name</th>
  <th>Instructor</th>
  <th>Class size</th>
  <th>Date</th>
  <th>Time</th>
  <th>Location</th>
  <th>Register</th>
  </tr>"; ?>
 
<?php 

  for ($i=0; $i <$num_results; $i++) {
     $row = $result->fetch_assoc();?>
  <tr>
      <form action = ""
          method = "post">
<td><? echo $row['CourseName']; ?></td>
<td><? echo $row['Instructor']; ?></td>
<td><? echo $row['ClassSize']; ?></td>
<td><? echo $row['Date']; ?></td>
<td><? echo $row['Time']; ?></td>
<td><? echo $row['Location']; ?></td>


<td align="center"><input name="radio" type="radio" id="radio[]" value="<? echo $row['ClassSize']; ?>"></td>
</tr>
<?php
}
?>

<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="submit" type="submit" id="submit" value="submit"></td>

 
 <?php




if($submit){
for($i=0;$i<$num_results;$i++){
$del_id = $radio[$i];
$query = "UPDATE course SET ClassSize = ClassSize -1 Where id='$del_id'";
$result = mysql_query($query);
}

// if successful redirect to delete_multiple.php
if($result){

echo  "$CourseName was deleted from database - myliftstyle!!<br />";

// Compute the item costs and total cost
 

  }
  }



    ?>

   </div>
</body>
</html>
[attachment deleted by admin]

the info posts beautifully i just canst seem to get the button to auto click or submit, tried numerous ways!  help

Code: [Select]
<?php  

require_once "../store/paypal/utility.php";
require_once "../store/paypal/constants.php";

$url = "https://www.".DEFAULT_ENV.".paypal.com/cgi-bin/webscr";
$postFields =   "cmd=".urlencode("_notify-synch").
            "&tx=".urlencode(htmlspecialchars($_GET["tx"])).
            "&at=".urlencode(DEFAULT_IDENTITY_TOKEN);
$ppResponseAr = Utils::PPHttpPost($url, $postFields, true);

if(!$ppResponseAr["status"]) {
   Utils::PPError($ppResponseAr["error_msg"], $ppResponseAr["error_no"]);
   exit;
}

$httpParsedResponseAr = $ppResponseAr["httpParsedResponseAr"];

// assign posted variables to local variables
   $item_name = $httpParsedResponseAr['item_name'];
   $item_number = $httpParsedResponseAr['item_number'];
   $receiver_email = $httpParsedResponseAr['receiver_email'];
   $receiver_id = $httpParsedResponseAr['receiver_id'];
   $quantity = $httpParsedResponseAr['quantity'];
   $first_name = $httpParsedResponseAr['first_name'];
   $last_name = $httpParsedResponseAr['last_name'];
   $payer_email = $httpParsedResponseAr['payer_email'];
   $txn_type = $httpParsedResponseAr['txn_type'];
   $address_street = $httpParsedResponseAr['address_street'];
   $address_city = $httpParsedResponseAr['address_city'];
   $address_state = $httpParsedResponseAr['address_state'];
   $address_zip = $httpParsedResponseAr['address_zip'];
   $item_number = $httpParsedResponseAr['item_number'];
   $option_name1 = $httpParsedResponseAr['option_name1'];
   $option_selection1 = $httpParsedResponseAr['option_selection1'];
   $option_name2 = $httpParsedResponseAr['option_name2'];
   $option_selection2 = $httpParsedResponseAr['option_selection2'];
   $invoice = $httpParsedResponseAr['invoice'];
   $custom = $httpParsedResponseAr['custom'];
   $payer_id =$httpParsedResponseAr['payer_id'];

?>
<html lang="en">
<head>
<title>Rec</title>
<link REL="stylesheet" href="include/style.css" type="text/css">
<!--[if IE]>
<link REL="stylesheet" href="include/styleIE.css" type="text/css">
<![endif]-->
<style>
#center_block {width:50%;margin:0 auto;min-width:500px;}
#contents_block {text-align:center;}
#header_block {white-space:nowrap;height:25px;padding:0 10px 5px;text-align:center;}
#fields_block {width:100%;margin:0;padding:10px}
#header_block  span {margin:0 5px}
#buttons_block {padding:10px 10px 5px}
#buttons_block div {padding:3px}
#delimiter {margin:2px}
#fields_block td {padding:3px 14px}
#username_block td {padding-top:13px;white-space:nowrap;}
#remember_block td {padding-bottom:13px;white-space:nowrap;}
#required_block {text-align:left;padding:5px}
</style>
<!--[if IE]>
<style>
#main_block {width:100%}
</style>
<![endif]-->
</head>
<body>
<script language="JavaScript" src="include/jquery.js"></script>

<script language="JavaScript" src="include/jsfunctions.js"></script>

<script language="JavaScript" src="include/runnerJS/RunnerBase.js"></script>





 
 
<form action="rec.php" method="post" id="rec" name="rec.php">

<table id="center_block" align="center">
   <tr><td id="contents_block">
 
 
<div class="main_table_border2 loginshade" id="main_block">
 
<table cellpadding=0 cellspacing=0 border=0 id="fields_block" class="loginshade">
 
<tr id="email_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_email_1">Email:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_email_0" style="white-space: nowrap;"><input id="value_email_1" style="" type="text" name="value_email_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["payer_email"]) ?>">&nbsp;<font color="red">*</font></span>
             <div class="error"></div>
   </td>
</tr>
 
 
<tr id="pass_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_pass_1">Pass:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_pass_0" style=""><input style="" id="value_pass_1" type="Password" name="value_pass_1"  maxlength=50 value="1234">&nbsp;<font color="red">*</font></span>
             <div class="error"></div>
   </td>
</tr>
 
 
<tr id="confirm_block">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_confirm_1">Re-enter password:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_confirm_0" style=""><input style="" id="value_confirm_1" type="Password" name="value_confirm_1"  value="1234">&nbsp;<font color="red">*</font></span>
      <div class="error"></div>
   </td>
</tr>
 
 
<tr id="fname_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_fname_1">First Name:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_fname_0" style="white-space: nowrap;"><input id="value_fname_1" style="" type="text" name="value_fname_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["first_name"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="lname_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_lname_1">Last Name:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_lname_0" style="white-space: nowrap;"><input id="value_lname_1" style="" type="text" name="value_lname_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["last_name"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="address_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_address_1">Address:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_address_0" style="white-space: nowrap;"><input id="value_address_1" style="" type="text" name="value_address_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_street"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="city_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_city_1">City:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_city_0" style="white-space: nowrap;"><input id="value_city_1" style="" type="text" name="value_city_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_city"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="state_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_state_1">State:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_state_0" style="white-space: nowrap;"><input id="value_state_1" style="" type="text" name="value_state_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_state"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="zip_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_zip_1">Zip:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_zip_0" style="white-space: nowrap;"><input id="value_zip_1" style="" type="text" name="value_zip_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_zip"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="cosponsor_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_cosponsor_1">Cosponsor:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_cosponsor_0" style=""><input id="type_cosponsor_1" type="hidden" name="type_cosponsor_1" value="checkbox"><input id="value_cosponsor_1" type="Checkbox" name="value_cosponsor_1" ></span>
          </td>
</tr>
 
 
<tr id="recipients_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_recipients_1">Recipients:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_recipients_0" style="white-space: nowrap;"><input id="value_recipients_1" style="" type="text" name="value_recipients_1"  maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["quantity"]) ?>">&nbsp;<font color="red">*</font></span>
          </td>
</tr>
 
 
<tr id="clients_fieldblock">
   <td align=left width=50% class=loginshade>
      <div align="left"><label for="value_clients_1">Clients:</label></div>
   </td>
   <td width=50% class=loginshade>
      <span id="edit1_clients_0" style=""><input id="type_clients_1" type="hidden" name="type_clients_1" value="checkbox"><input id="value_clients_1" type="Checkbox" name="value_clients_1" ></span>
          </td>
</tr>
 
 
<tr id="space_block"></tr>
 
</table>
 
 
</div>
</td></tr>
</table>
    <input type=submit value="Submit" class=button id="saveButton1" onload="Submit"></form>

</body>
</html>

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

Hi i have this simple update form and scrip but somehow it doesnt seem to be update the field on the database can someone help out please.
The html form is the second form bellow where the action send to status_update.php
HTML FORM
Code: [Select]
<?php                include("../header.html");            ?>
<?php                include("header_news.html");            
extract($_REQUEST,EXTR_SKIP);
?><?php            
/*                print("sfilm_refnum = $sfilm_refnum<BR>");                
print("sfilm_addr01 = $sfilm_addr01<BR>");                
print("sfilm_postcode = $sfilm_postcode<BR>");                
print("Film Client = $fclient<BR>");            */             
?>           
<form id="search" action="list.php" method="post" name="search">               
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">                   
<tr>                       
<td align="right" width="140"></td>                       
<td width="320"><span class="hofblack10">                           
</span>                           
</td>                       
<td align="center" width="100"><input type="hidden" name="lstart" value="<?php print("$lstart"); ?>" /><input type="hidden" name="lend" value="<?php print("$lend"); ?>" /><input type="hidden" name="lamount" value="<?php print("$lamount"); ?>" /></td>                        <td align="center" width="100"></td>                       
<td align="right"></td>                   
</tr>               
</table>           
</form>           
<table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#4050c4">               
<tr>                 
<td width="60" class="hofwhite10">action</td>                   
<td width="140"><span class="hofwhite14">DATE</span></td>                   
<td width="80"><span class="hofwhite14">ID</span></td>                   
<td><span class="hofwhite14">News Titile</span></td>                   
<td width="100"><span class="hofwhite14">Status</span></td>               
</tr>               
<tr height="0">                 
<td bgcolor="white" width="60"></td>                   
<td bgcolor="white" width="140" height="0"></td>                   
<td bgcolor="white" width="80" height="0"></td>                   
<td bgcolor="white" height="0"></td>                   
<td bgcolor="white" width="100" height="0"></td>               
</tr>           
</table><table width="780" border="0" cellspacing="0" cellpadding="4"><tr>                   
<td width="60"></td>                 
<td width="80"></td>                   
<td><a class="blueullrg" href="add.php">Add News</a></td>                   
<td align="right" width="120"></td>               
</tr>               
<tr height="0">                   
<td width="60" height="0"></td>                 
<td width="80" height="0"></td>                   
<td height="0"></td>                   
<td align="right" width="120" height="0"></td>               
</tr>           
</table>  <?php          
//get the DB connection variables    
include("../../../includes/config.php");        
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select DATABASE.");                
$query2="SELECT * FROM news WHERE !(news_status='deleted')";        
$result2 = mysql_query($query2) or die("Couldn't execute QUERY - Select NEWS Qty");        
$fqty = mysql_num_rows($result2);            
//SELECT or FIND the same USERNAME        
$query3="SELECT * FROM news WHERE !(news_status='deleted') ORDER BY news_id DESC";        
$result3 = mysql_query($query3) or die("Couldn't execute QUERY - Select NEWS");        
while ($row = mysql_fetch_array($result3))            
{                
$news_id                 = $row['news_id'];                
$news_title                = $row['news_title'];                
$news_story                = $row['news_story'];                
$news_image                = $row['news_image'];                
$news_image_caption        = $row['news_image_caption'];                
$news_image_link        = $row['news_image_link'];                
$news_date_day            = $row['news_date_day'];                
$news_date_month        = $row['news_date_month'];                
$news_date_year            = $row['news_date_year'];                
$news_status            = $row['news_status'];                
$news_website            = $row['news_website'];                
$news_date_created        = $row['news_date_created'];        
        $news_date_modified        = $row['news_date_modified'];    ?>           
        <table width="780" border="0" cellspacing="0" cellpadding="4" bgcolor="#eeeeee">               
        <tr>                 
        <td width="60"><span class="hofblack10">                   
         <?php                    
         if($news_status=="deleted"){                        
         print("<a class='hifblack10'>deleted</span>");                    
         }ELSE{                        
         print("<a class='blueul' href='edit.php?id=$news_id'>edit</a>");                    
         }                    
         ?>                 
          </span></td>                   
          <td width="140"><span class="titlegrey12">                     
          <?php                      
          if(!$news_date_day) 
          { echo "00"; }
          else{ echo $news_date_day; }                      
          echo "/";                     
           if(!$news_date_month) { echo "00"; }else{ echo $news_date_month; }                      
           echo "/";                      
           if(!$news_date_year) { echo "0000"; }else{ echo $news_date_year; }                    
           ?>                   
           </span></td>                   
           <td width="80"><span class="titlegrey12"><?php                    print("$news_id");                    ?></span>
           </td>                   
           <td><?php                    
           if($news_status=="deleted")
           {                        
           print("<class='hofblack10'>$news_title</span>");                    
           }ELSE{                        
           print("<a class='blueul' href='edit.php?id=$news_id'>$news_title</a>");                    
           }                    
           ?></td>                   
           <td width="100">                       
           <form id="list_update" action="status_update.php" method="post" name="list_update">                           
        <select name="newnstatus" size="1">                               
           <option  <?php if($row['news_status'] == "") 
           {
            print("selected");
           } ?>
           selected="selected" value="">Status...</option>                               
           <option  <?php if($row['news_status'] == "on")
           {
            print("selected");
           } ?> value="on">On</option>
               <option  <?php if($row['news_status'] == "off")
           {
            print("selected");
           } ?> value="off">Off</option>
            <option  <?php if($row['news_status'] == "deleted")
           {
            print("selected");
           } ?> value="deleted">Delete</option>
        </select>
         <input type="hidden" name="nstatus" value="<?php echo $row[news_status]; ?>" />                           
           <input type="hidden" name="id" value="<?php echo $row[news_id]; ?>" />                       
           <input type="submit" name="update" value="update" />                       
           </form>                     
            </td>               
            </tr>               
            <tr height="0">                 
            <td bgcolor="white" width="60"></td>                   
            <td bgcolor="white" width="140" height="0"></td>                   
            <td bgcolor="white" width="80" height="0"></td>                   
            <td bgcolor="white" height="0"></td>                   
            <td bgcolor="white" width="100" height="0"></td>               
            </tr>           
            </table>
            <?php            }        mysql_close($connection);//}?>           
            <table width="780" border="0" cellspacing="0" cellpadding="4">         
            <tr>                   
            <td width="60"></td>                 
            <td width="80"></td>                   
            <td><a class="blueullrg" href="add.php">Add News</a></td>                   
            <td align="right" width="120"></td>               
            </tr>           
            </table><?php                // include("list_navigation.html");            ?>
            <?php                include("../footer.html");            ?>
            </div></body></html>
The action script php
Code: [Select]
<?php
/*    echo "fstatus: ".$fstatus."<BR>";    
echo "id: ".$id."<BR>";    
echo "fclient: ".$fclient."<BR>";    
echo "newfstatus: ".$newfstatus."<BR>";*/    
//set the date of agreement        
$timestamp = date('l jS \of F Y h:i:s A');    
//get the DB connection variables        
include("../../../includes/config.php");
//connect to DB        
$connection = @mysql_connect($db_address,$db_username,$db_password) or die("Couldn't CONNECT.");        
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select FILMS DATABASE.");    
// All appears well, so enter into database                
$query= "UPDATE news SET news_status = '$newnstatus' WHERE news_id='$id'";

$result = mysql_query($query) or die("could not execute query - Update FILMS Record to DB");    
//setup an email to the Admin @ hof, w/o attachment            
$emailto="xx@xxx.co.uk";        
$emailfrom="no-reply@xxxx.co.uk";        
$emailsubject="xx Record Updated";        
$emailmessage="Hello Registrar\n\n";        
$emailmessage.="News ID: ".$id."\n";        
$emailmessage.="Updated on: ".$timestamp."\n\n";        
$emailmessage.="Status was: ".$nstatus."\n";        
$emailmessage.="Status now: ".$newfnstatus."\n";        
$emailmessage.="Thank you,\n\n";        
$emailmessage.="Web Site ROBOT\n";        
$emailmessage.="(Administrator)\n";        
$emailmessage.="xxx.co.uk | xxx.biz\n";        
$emailmessage.="----------------------------------------------\n";        
$emailmessage.="e. http://www.xxx.co.uk/contact.php\n";        
$emailmessage.="w. http://www.xxx.co.uk\n";        
$emailheader="From: xxx.co.uk<$emailfrom>";
$emailheader  .= 'Cc: xxx@xxx.co.uk'."\r\n";
$emailheader  .= 'Bcc: xxx@xxxxx.co.uk'."\r\n";        
$ok=mail($emailto,$emailsubject,$emailmessage,$emailheader);        
mysql_close($connection);            
if ($ok)
 {        
 header("Location: list.php"); 
 /* Redirect browser */        
 exit;    
 } else {        
 $errmsg="There was a problem, please try later or telephone us direct.";        
 $errsta="1";        
 include("edit_error.html");        
 //echo "<p>Mail could not be sent. Sorry!</p>";        
 exit;    
 }        
 ?> Thanks in advance

I have the following code to generate a table of results from a MySQL query. As you can see, some of the rows contain onclick, onmouseover & onmouseout events.


$table = "<table border='0' cellpadding='5' cellspacing='0' width='460px'>
$i=1;
        while($arr = mysql_fetch_array($result, MYSQL_NUM))
        {
            $table .= "<tr onclick=\"expandcollapse('subb".$i."a', 'subb".$i."b', 'subb".$i."c')\" onMouseOver=\"this.bgColor='gold'; this.style.cursor='pointer';\" onMouseOut=\"this.bgColor='#FFFFFF';\"> <td style='border-left: 1px solid #808080; border-bottom: 1px solid #808080;'> &plusmn;&nbsp;&nbsp;".$arr[0]."&nbsp;".$arr[1]."</td>"
                          ."<td style='border-bottom: 1px solid #808080;'>".$arr[2]."</td>"
                          ."<td style='border-bottom: 1px solid #808080;'>".$arr[3]."</td>"
                          ."<td style='border-bottom: 1px solid #808080;'>".$arr[4]."</td>"
                          ."<td style='border-bottom: 1px solid #808080; border-right: 1px solid #808080;'>".$arr[5]."</td></tr>"
                     ."<tr id='subb".$i."a'; style='display:none';><td colspan='5' style='border-bottom: 1px solid #808080; border-right: 1px solid #808080; border-left: 1px solid #808080;';> ".wordwrap ($arr[6], 53, '<br />',$cut = true)."</td></tr>"
                     ."<tr id='subb".$i."b'; style='display:none';><td colspan='5' style='border-bottom: 1px solid #808080; border-right: 1px solid #808080; border-left: 1px solid #808080;'> ".wordwrap ($arr[7], 53, '<br />',$cut = true)."</td></tr>"
                     ."<tr id='subb".$i."c'; style='display:none';><td colspan='5' style='border-bottom: 1px solid #808080; border-right: 1px solid #808080; border-left: 1px solid #808080;'> ".wordwrap ($arr[8], 53, '<br />',$cut = true)."</td></tr>";
        //echo $i;
        $i++;
        }
        $table .= "</table>";
        echo $table;


I now want to add a checkbox to these rows, but I don't want the row onclick event to happen when the checkbox is clicked. How do I do this?

Is there a way to run somefunction(thisrow) instead of somefunction(this)? Because that way I could specify an onclick event for each individual cell that affects the whole row and just add an extra column with checkboxes that doesn't have this onclick event.

Thanks!

Friends
  I am new to php and i have to submit my coursework in php by 3rd dec, I stuck at one place where i have to upload multiple photo and one can see all the photo he has uploaded and can edit or delete that photo so i have done uploading now i am showing those pics in table by running loop and generating tr and td but now i have two buttons with each row edit and delete now when i clicked on one delete or edit that pic should be delete or give text box to edit description of pic, Please help me how to do that.......

Hi there. I have a page that lists the records of a table. On this page I want to be able to edit/update two attributes of these records by a checkbox - e.g., being able to update multiple records at once. I thought the smartest way to achieve this would be by using arrays. I've implemented one checkbox array and have two fields. Currently when I change both fields and hit submit, the height value changes and the name value is changed to the last record displayed in the table.

E.g.

Height - 170 -> 160 -> UPDATED TO 160
Name - Test1 -> Test2 -> UPDATED TO VICTORY (last record listed in table; displayed alphabetically)

My code is as follows:

<?php
include("connection.php");
$conn = oci_connect($UName,$PWord,$DB) or die("Database Error - Contact Admin - sjrei5@student.monash.edu");
if (empty($_POST["check"]))
{
    $query = "SELECT * FROM HORSE ORDER BY HORSE_NAME";
    $stmt = oci_parse($conn,$query);
    oci_execute($stmt);
$Horses = oci_fetch_array ($stmt);
?>
    <form method="post" action="horse_multi.php">
      <table border="1" id="customers">
      <tr>
        <th>ID</th>
        <th>EDIT</th>
        <th>NAME</th>
        <th>HEIGHT</th>
      </tr>
<?php
while ($Horses = oci_fetch_array ($stmt))
{
?>
        <tr>
          <td><?php echo $Horses["HORSE_ID"]; ?></td>
          <td align="center"><input type="checkbox" name="check[]" value="<?php echo $Horses["HORSE_ID"]; ?>"></td>
          <td align="center"><input type="text" size="5" name="<?php echo $Horses["HORSE_ID"]; ?>" value="<?php echo $Horses["HORSE_HEIGHT"]; ?>"></td>
          <td align="center"><input type="text" size="20" name="HORSE_NAME" value="<?php echo $Horses['HORSE_NAME']; ?>"></td>
        </tr>
<?php
}
?>
      </table><p />
        <h4><input type="submit" value="Update Selected Horses"></h4>
    </form>
<?php
oci_free_statement($stmt);
}
else
{

foreach($_POST["check"] as $horse_id)
{
$query = "UPDATE HORSE SET HORSE_NAME= '$_POST[HORSE_NAME]', HORSE_HEIGHT = ".$_POST[$horse_id]." WHERE HORSE_ID ='".$horse_id."'";
$stmt = oci_parse($conn,$query);
oci_execute($stmt);
}
}
?>
</body>
</html>


Any ideas? 

hello i had a look here its prety simple example http://www.formget.com/php-checkbox/     i wish something like this but with many more check boxes about 100,   the senario ls like this   there will be many users in a system,   each user profile will have these kind of questions   for example   Hobby : tenis [] badminton[] footbal[] carrom[]   programming language : perl[] python[] cobol[] as3[]   favorit biscuit : bakers[] subana[] ect[]     ect ect   these checkbox need to reflect for diferent users. administrator can add new category [ ie hobby , programming language] under each category he can add more options such as football, tenis ect   he should be able to have an interface to modify the options entered by user when a user request a change     what is a good way to implement this in php mysql      

Hey phpFreaks, im having some troubles getting my script to work correctly and im also not sure if this issue is in the right section of the forum. but heres what i have going on.
I have a query result that displays a list of images with a checkbox and a couple buttons for edit and delete. everything works fine other than the checkbox stuff. I had it working when i was using a submit button, but i wanted to get rid of that button cuz it was only dealing with the checkboxes. so whats going on when using the checkboxes is that when checked or uncheck it would submit the form. It works to submit but its not submitting any data to the database.

heres what i got for code for this section of checkbox.
Code: [Select]
<?php
echo '<form method="post">';
if(isset($_POST['submit'])){
foreach($_POST['id'] as $id){
$value = (isset($_POST['location'][$id]) && $_POST['location'][$id]=="0" ? '0' : '1');
$insert = mysql_query("UPDATE items SET location='$value' WHERE id='$id'") or die('Insert Error: '.mysql_error());
}
}
     $result = mysql_query("SELECT * FROM items")
or die("Query Failed: ".mysql_error());
$counter = 0;
echo '<div class="specialcontainer">';
 while($row = mysql_fetch_array($result)){
list($id, $item_info, $item_img, $price, $sale, $location) = $row;
if($location == '0'){
$set_checked = 'checked="checked"';
}else{
$set_checked = '';
}
if($counter % 5==0) {
echo '</div>';
echo '<div class="specialcontainer">';
}
echo '<div class="special"><img src="../images/items/'.$item_img.'" width="130" /><br />'.$item_info.'<br />$'.$price.'<br />$'.$sale.'<br />Slide Show: <input type="checkbox" id='.$id.' value="0" name="location['.$id.']" '.$set_checked.'  onchange="this.form.submit()"/><br /><input type="button" value="Edit" name="edit" id="'.$id.'" onclick="window.location.href=\'specials.php?action=edit&id='.$id.'\'"><input type="button" value="Delete" name="Delete" id="'.$id.'" onclick="window.location.href=\'specials.php?action=delete&id='.$id.'\'"><input type="hidden" name="id[]" value='.$id.' /></div>';
$counter++;
 }
 echo '</div>';
 echo '</form>';
?>

I am using a WordPress theme that uses some of its own functions besides WP functions.

Let me make clear from the start that when I say "Multiple Checkboxes" in the paragraphs below I am NOT talking about checkboxes that each hold a single value.  I am talking about one Checkbox field that allows multiple values to be selected and puts those values into an array with one Name value and stores the output in a string in a single mysql table field.

Right up front, what I need during the Edit Ad functions is the inbuilt function that will Delete the previous Array of values in any multiple checkbox when the ad is updated. Right now updating the ad works for every situation except NO values selected or for Unchecking all previously selected values in a Multiple Checkbox.  If I have, for example, 4 checkboxes selected and unselect all of them before submitting the edited ad it will return the last saved array of values but not an Empty array with no checkboxes selected.

This theme has a Form Builder with a Custom fields builder used by the admin to create forms for a classified ads website. According to which category of ad the Ad creation procedure will show different forms, with different fields.

I had to manually create the capability to generate multiple checkboxes...so that the different multiple checkboxes when selected and updated to the mysql table might hold a variety of values in a comma-delimited array. That works fine.

When the Ad is edited on its own page, (outside of the Wordpress admin dashboard) the problem is that if a user would uncheck all checkboxes in a particular multiple checkbox then the unselected state does not overwrite the previous array of values. What returns after editing is the previous selected values.

I have tried jquery functions but none of them are working the way I had hoped.

so one type of checkbox might have a hypothetical value like this  "name="cp_checkbox_help[]" and if three options are selected then on submit the value could be--- name="cp_checkbox_help[Sunday,Monday,Tuesday]"

I use implode and explode to store the array as comma separated and retrieve the array for editing or display.

I guess I need to create a Null or empty value as a default that only changes when selections are made.

But, since I use implode and explode to make the array "pretty" I don't know if simply specifying nothing will erase a whole array on update.

Here is some of the code used to see how I get what I get--

This displays the checkboxes that I create and name and fill with different values--


case 'checkbox':
 ?>
<?php 
$options = explode(',', $result->field_values);
 echo '<div id="checkboxes"><table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <th colspan="2" scope="col">' . $result->field_label. '</th>
  </tr>';
$myvals= explode(',', $post_meta_val);
foreach ($options as $option) {
 {
 ?> 
              
              <tr>
    <td width="4%"><input style="display:inline-block; float:left;" type="<?php echo $result->field_type; ?>" name="<?php echo $result->field_name; ?>[]" class="checkbox<?php if($result->field_req) echo ' required'?>" id="<?php echo $field_label; ?>" value="<?php echo $option; ?>" <?php foreach ($myvals as $myval)
{ if (in_array($myval, array($option), true)) {echo 'checked="yes"';}}?>/></td>
    <td width="96%"style="vertical-align:top; text-indent: 7px; text-align: left;" ><?php echo $option . '</td>
  </tr> ' ?>   



<?php
             }     } echo '  </tr>
</table></div><div class="clr"></div>';
 break; 



Following is the main part of the code that updates the Ad form--



  // update the ad and return the ad id
    $post_id = wp_update_post($update_ad);



    if($post_id) {

        // now update all the custom fields
        foreach($_POST as $meta_key => $meta_value) {
            if (cp_str_starts_with($meta_key, 'cp_'))
if (cp_str_starts_with($meta_key, 'cp_checkbox_charley'))
$meta_value= implode(',', $_POST['cp_checkbox_charley']);
if (cp_str_starts_with($meta_key, 'cp_checkbox_help'))
$meta_value = implode(',', $_POST['cp_checkbox_help']);
if (cp_str_starts_with($meta_key, 'cp_checkbox_hello'))
$meta_value= implode(',', $_POST['cp_checkbox_hello']);
                //echo $meta_key . ' <--metakey <br/>' . $meta_value . ' <--metavalue<br/><br/>'; // for debugging
                update_post_meta($post_id, $meta_key, $meta_value);
        }

        $errmsg = '<div class="box-yellow"><b>' . __('Your ad has been successfully updated.','cp') . '</b> <a href="' . CP_DASHBOARD_URL . '">' . __('Return to my dashboard','cp') . '</a></div>';

    } else {
        // the ad wasn't updated so throw an error
        $errmsg = '<div class="box-red"><b>' . __('There was an error trying to update your ad.','cp') . '</b></div>';

    }

    return $errmsg;

}

Back on the Edit Ad page this is the Submit


                        <p class="submit center">
                            <input type="button" class="btn_orange" onclick="window.location.href='<?php echo CP_DASHBOARD_URL ?>'" value="<?php _e('Cancel', 'cp')?>" />&nbsp;&nbsp;
                            <input type="submit" class="btn_orange" value="<?php _e('Update Ad &raquo;','cp') ?>" name="submit" />

I have a feeling what I need is just a couple of lines to detect no posted values and then... but if one checkbox array has 6 values in it and another checkbox array has only 3 values, for example, do I need to count each specific checkbox for number of values and then overwrite or will one function completely delete the previous array and its commas?

I would really appreciate some expert assistance here!

Hi,

having problems getting checkboxes to display all reuslts when a user selects more than one check box say in the category section and one in the location section - see page http://www.partyco.co.uk/event-and-party-venues/ - submit to see reults page:

I managed to get it to display reults if the user only seletc either a right or left column option OR one of each - BUT not when thet select multiple categories and one location - and ideas how to do this ? putting it into an array perhaps - but how - new to some of this....

here is the code for the reults page:
Code: [Select]
<?php
$location = $_POST[location];
$category = $_POST[category];
?>

<?php

$Link = mysql_connect("xxxxxxxxx", "xxxxxxxxx", "xxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxx") or die(mysql_error());

// selects db listings when location not given
if (empty($location)) {
$query = "SELECT * FROM venues WHERE category = '$category' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when category not given
} elseif(empty($category)) {
$query = "SELECT * FROM venues WHERE location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when both given
}else {
$query = "SELECT * FROM venues WHERE category = '$category' and location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());
}

while($row = mysql_fetch_array($result)){
echo "<div class=\"resultsShort\" style=\"margin-bottom:10px;\">";
echo "<h2 id=\"resultsHeading\">";
echo $row['title'];
echo "</h2>";
echo "<p class\"resultspara\">". nl2br($row['description']). "</p>";
echo "<h4 style=\"margin:5px 0 0 0; padding:0;\">Contact details</h4>";
echo "<p class\"resultspara\">". nl2br($row['contact']). "</p>";
echo "<div style=\"float:left; width:124px; height:40px; margin:10px 15px 0 0;\">";
echo "<a href=\"/party-supplier-resources/email-supplier.php?title=". $row['title']. "&email=" . $row['email']. "&location=" . $row['location']. "&category=" . $row['category']. "\" title=\"contact this venue here\">";
echo "<img src=\"/images/email-supplier.jpg\" width=\"124\" align=\"right\" height=\"35\" alt=\"contact this supplier button\" border=\"0\" /></a>";
echo "</div>";
echo "</div>";
}


?>


<?php include("../include/shareLinks.php"); ?>


<div id="popupContact">
<a id="popupContactClose" title="close this window">close x</a>
<h1>Supplier Directory Enquiry Form</h1>
<?php include("../include/enquiryform.php"); ?>
</div>
<div id="backgroundPopup"></div>


<?php
mysql_close ($Link);
?>
Any help appreciated!

Aaron

MOD EDIT: [code] . . . [/code] BBCode tags added.

Only the last row will update when I submit.

I have this form (and one nerve left):


<form action="" method="post" >

echo"
<input style=\"text-align:center\" type=\"text\" name=\"linkorder\" value=\"".$row['order']."\" />
<input type=\"hidden\" name=\"id\" value=\"".$row['id']."\"/>
";
<input type="submit" name="updateorder" value="Save Order" />
</form>


On Submit:


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

connect();
$changeorder = mysql_unbuffered_query("update links set `order` = '".$_POST['linkorder']."' where id = '".$_POST['id']."'") or die(mysql_error());

}



I was going put my fist through the monitor but then I remembered I could get help here.

Thank you!

I have the below code:

Code: [Select]
<div>
  <table width="100%" border="0" cellspacing="0" cellpadding="4">
                            <tr>
                              <td colspan="7" valign="top">
                              <form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<?php
if (isset($submit)) {
  // UPDATE QUERY CODE WHEN SUBMIT IS ENTERED
$str = implode(';',$_POST['checks']);
$insert = "UPDATE members SET
settings='$str'
WHERE member_id='$_SESSION[SESS_MEMBER_ID]'";

if (@mysql_query($insert))
{
?>
                          <script type="text/javascript">
document.location.replace('settings-tests.php');
                          </script>
                          <?php
}
else {
echo('Error in you submission:' . mysql_error() . "<br /><br />" . $sql);
}
}
 ?>
                          <?php
  {
  
    $result=mysql_query("SELECT * FROM members WHERE member_id = '$_SESSION[SESS_MEMBER_ID]'");
    $row = mysql_fetch_array($result);
    $arr = array();
    $arr = explode(';',$row['settings']);
    $member_id = $row['member_id'];
    $firstname = $row['firstname'];
    $lastname = $row['lastname'];
    $email = $row['email'];
    $membership = $row['membership'];
    $roles = $row['roles'];
    $login = $row['login'];

    ?>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
  <tr>
    <td colspan="2"><h3>Test Results Settings</h3></td>
    <td width="25%">&nbsp;</td>
    <td width="25%"><?php
echo $_SESSION['SESS_MEMBER_ID'];
?></td>
  </tr>
  <tr>
    <td colspan="4"><em>To turn off individual results gloablly across the site please use the following sliders (all results already added will also be made invisable)<br />
      <br />
    </em></td>
    </tr>
  <tr>
    <td width="25%"><div align='right'><strong><em>Salinity:</em></strong></div></td>
    <td width="25%"><input type="checkbox" value="test1" name="checks[]2" <?php echo (in_array("test1",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Phosphate:</em></strong></div></td>
    <td><input type="checkbox" value="test9" name="checks[]10" <?php echo (in_array("test9",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>PH:</em></strong></div></td>
    <td><input type="checkbox" value="test2" name="checks[]3" <?php echo (in_array("test2",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>potassium:</em></strong></div></td>
    <td><input type="checkbox" value="test10" name="checks[]11" <?php echo (in_array("test10",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Ammonia:</em></strong></div></td>
    <td><input type="checkbox" value="test3" name="checks[]4" <?php echo (in_array("test3",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Iodine:</em></strong></div></td>
    <td><input type="checkbox" value="test11" name="checks[]12" <?php echo (in_array("test11",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Nitrite:</em></strong></div></td>
    <td><input type="checkbox" value="test4" name="checks[]5" <?php echo (in_array("test4",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Strontium:</em></strong></div></td>
    <td><input type="checkbox" value="test12" name="checks[]13" <?php echo (in_array("test12",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Nitrate:</em></strong></div></td>
    <td><input type="checkbox" value="test5" name="checks[]6" <?php echo (in_array("test5",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Silica:</em></strong></div></td>
    <td><input type="checkbox" value="test13" name="checks[]14" <?php echo (in_array("test13",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Calcium:</em></strong></div></td>
    <td><input type="checkbox" value="test6" name="checks[]7" <?php echo (in_array("test6",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Temperatu </em></strong></div></td>
    <td><input type="checkbox" value="test14" name="checks[]" <?php echo (in_array("test14",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Magnesium:</em></strong></div></td>
    <td><input type="checkbox" value="test7" name="checks[]8" <?php echo (in_array("test7",$arr) ? "checked" : ''); ?>/></td>
    <td></td>
    <td></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Alkalinity:</em></strong></div></td>
    <td><input type="checkbox" value="test8" name="checks[]9" <?php echo (in_array("test8",$arr) ? "checked" : ''); ?>/></td>
    <td colspan="2" align="right"></td>
    </tr>
  <tr>
    <td colspan="4" align="right"><table border="0" cellspacing="0" cellpadding="8">
      <tr>
        <td><input class="Button" type="submit" name="submit" value="Submit" /></td>
      <td><input class="Button-alt" type="reset" name="reset" value="Reset" /></td>
    </tr>
    </table></td>
    </tr>
</table>

                                   
<br />

  </form><?php
}
?>                              </td>
                        </tr>
                      </table>
</p>
  </div>

This pulls data in array from database for example:

test1;test9;test2;test3;test4;test5;test6;test14;test7;test8

The SELECT query works fine if i manually edit the array in the database to make the boxes checked or not.

Problem seems to be when i click submit, its not updating the DATABASE?!

i recently upgraded to PHP5 eventually and it seems it stopped working arond then.

any help please.