dynamic table with forms
Posted on
16th Feb 2014 07:03 pm by
admin
I have a table that is populated with mysql data and in teh first column there is a raido button that i would like to have it when selected and i hit either edit or delete the ID is passed to another page for the stated task. i am using raidos to prevent multiple selections. but at this time when switching selections all previous ones stay until a refresh. how can i fix this ?
Please help i am at a complete loss.....
Here is the code::
Code: (php) <?php require_once('../Connections/BIO_Clan.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_BIO_Clan, $BIO_Clan);
$query_Leaders = "SELECT clan_members.authid, clan_members.rank, clan_members.name, admins.access FROM imagest5_bioclan.clan_members LEFT OUTER JOIN imagest5_bioclan.admins ON clan_members.name = admins.name WHERE clan_members.rank = 6 ORDER BY clan_members.rank DESC, clan_members.name";
$Leaders = mysql_query($query_Leaders, $BIO_Clan) or die(mysql_error());
$row_Leaders = mysql_fetch_assoc($Leaders);
$totalRows_Leaders = mysql_num_rows($Leaders);
?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="100%" border="1" cellpadding="2" cellspacing="2">
<tr>
<td> </td>
<td>SteamID</td>
<td>Name</td>
<td>Flags</td>
</tr>
<?php do { ?>
<tr>
<td><form id="form4" name="form4" method="post" action="">
<input type="radio" name="select" id="radio" value="<?php echo $row_Leaders['authid']; ?>" />
</form></td>
<td><?php echo $row_Leaders['authid']; ?></td>
<td><?php echo $row_Leaders['name']; ?></td>
<td><?php echo $row_Leaders['access']; ?></td>
</tr>
<?php } while ($row_Leaders = mysql_fetch_assoc($Leaders)); ?>
</table>
<div align="center"><br />
<table width="62%">
<tr>
<td width="11%"><form id="form1" name="form1" method="post" action="edit.php">
<div align="center">
<input type="submit" name="edit" id="edit" value="Edit" />
</div>
</form></td>
<td width="20%"><form id="form2" name="form2" method="post" action="delete.php">
<div align="center">
<input type="submit" name="delete" id="delete" value="Delete" />
</div>
</form></td>
<td width="69%"><form id="form3" name="form3" method="post" action="">
<div align="center">
<select name="admin" id="select">
<option selected="selected">Quick Admin----</option>
<option>Ldr/CoLdr</option>
<option>Tech</option>
<option>Upper Admin</option>
<option>Mid Admin</option>
<option>Recruit Admin</option>
<option value="u">Member</option>
</select>
<input type="submit" name="admin" id="admin" value="Set" />
</div>
</form></td>
</tr>
</table>
</div>
</body>
</html>
<?php
mysql_free_result($Leaders);
?>
No comments posted yet
Your Answer:
Login to answer
324 
25 
Other forums
Schedule editor
Hi,
I have a question related to Schedule editor.
If we schedule a BLS for every 30
How to login with SAPCPIC userid
I have changed the Password for SAPCPIC in Development Server for 000,001 and 100 client.
But w
Undefined variable: adHTML
Hello:
While checking my site error logs, I've noticed one repetitive error that fills the lo
SOAP Issue
Hi,
I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.
LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a
how to get sn motherboard
Hello.
I want to get serial number motherboard, cpu and else hardware.
Can You show me sam
Stuck with preg_replace
Hi,
I'm trying to use preg_replace to remove part of the IP address submitted using a form on
help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu
image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai
ALV List Display to point to another report on Double Click
Hi,
I want my ALV List Display to point to another report on Double Click on its line ite
