Hi. I need help please. I have the following code and I need the field "fee to also submit to the MySQL database, but it is not. It is something that I added and was not originally part of the code. I created a MySQL table:
CREATE TABLE courses (
id int4 DEFAULT '0' NOT NULL auto_increment,
name varchar(128) DEFAULT '' NOT NULL,
fee decimal(10,2),
active smallint(6) DEFAULT '1' NOT NULL,
applyopen smallint(6) DEFAULT '0' NOT NULL,
info text,
users int4 DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY name (name),
KEY active (active)
And then here is my code. Everything but the fee is submitted. (This is long.)
<?require("../include/global_login.php");
require("../include/colors.php");?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Courses</title>
<script language="javascript">
function startup(){
document.course.elements["courseadmins[]"].options[0]=null;
document.course.elements["users[]"].options[0]=null;
}
function addadmin(){
for(a=document.course.elements["users[]"].options.length-1;a>-1;a--){
if(document.course.elements["users[]"].options[a].selected){
document.course.elements["courseadmins[]"].options[document.course.elements["courseadmins[]"].options.length]=new Option(document.course.elements["users[]"].options[a].text,document.course.elements["users[]"].options[a].value);
document.course.elements["users[]"].options[a]=null;
}
}
}
function removeadmin(){
for(a=document.course.elements["courseadmins[]"].options.length-1;a>-1;a--){
if(document.course.elements["courseadmins[]"].options[a].selected){
document.course.elements["users[]"].options[document.course.elements["users[]"].options.length]=new Option(document.course.elements["courseadmins[]"].options[a].text,document.course.elements["courseadmins[]"].options[a].value);
document.course.elements["courseadmins[]"].options[a]=null;
}
}
}
function mark_all(){
for(a=document.course.elements["courseadmins[]"].options.length-1;a>-1;a--){
document.course.elements["courseadmins[]"].options[a].selected=true;
}
}
function sendform(){
mark_all();
document.forms["course"].submit();
}
</script>
<link rel="STYLESHEET" type="text/css" href="../css.php">
</head>
<body bgcolor="<?echo $cBGcolor?>" topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" onLoad="startup()">
<? $width = strstr($HTTP_USER_AGENT,"MSIE") ? "77" : "45";
$check=mysql_query("SELECT FROM wp WHERE users=".$person["id"]." AND courses=$courses AND admin=1;");
if($person["admin"]==1 || (mysql_num_rows($check)!=0 && $courses!=0)){
if($courses==0){
$course["id"]=0;
$course["name"]="";
$course["fee"]="";
$course["active"]=1;
$course["applyopen"]=1;
$course["info"]="";
$course["users"]=$person["id"];
}else{
$check=mysql_query("SELECT from courses where id=$courses;");
$course=mysql_fetch_array($check);
}?>
<h1 class="h1">
<img src="../images/courses.gif" border="0">
Create/Edit course
<hr noshade size="1" width="100%" color="<?echo $cBorder?>">
</h1>
<table border=0 cellpadding=0 cellspacing=0 align="center">
<tr>
<td class="main" bgcolor="<?echo $cBorder?>">
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<form action="createcourse.php" method="post" name="course" onSubmit="mark_all()">
<input type="hidden" name="courses" value="<?echo $courses?>">
<tr>
<td colspan="1" class="main" align="right" bgcolor="<?echo $cBGMainInfo[0]?>">
<? $check=mysql_query("SELECT from users WHERE id=".$course["users"].";");?>
<b>Course created by:</b>
</td>
<td colspan="2" class="main" align="left" bgcolor="<?echo $cBGMainInfo[0]?>">
<?echo mysql_result($check,0,"firstname")." ".mysql_result($check,0,"surname")?>
</td>
</tr>
<tr>
<td class="main" align="right" valign="top" bgcolor="<?echo $cBGMainInfo[1]?>">
<b>Course name:</b>
</td>
<td class="main" bgcolor="<?echo $cBGMainInfo[1]?>" colspan="2">
<input type="text" name="name" size="15" maxlength="12" class="main" value="<?echo $course["name"]?>">
</td>
</tr>
<tr>
<td class="main" align="right" valign="top" bgcolor="<?echo $cBGMainInfo[1]?>">
<b>Course fee:</b>
</td>
<td class="main" bgcolor="<?echo $cBGMainInfo[1]?>" colspan="2">
<input type="text" name="fee" size="15" maxlength="12" class="main" value="<?echo $course["fee"]?>">
</td>
</tr>
<tr>
<td class="main" align="right" valign="top" bgcolor="<?echo $cBGMainInfo[0]?>">
<b>Active:</b>
</td>
<td class="main" bgcolor="<?echo $cBGMainInfo[0]?>" colspan="2">
<input type="checkbox" name="active" class="small" value="true" <?if($course["active"]==1){echo "checked";}?>>
</td>
</tr>
<tr>
<td class="main" align="right" valign="top" bgcolor="<?echo $cBGMainInfo[1]?>">
<b>Info:</b>
</td>
<td colspan="2" class="small" bgcolor="<?echo $cBGMainInfo[1]?>">
<textarea name="info" class="main" cols="<?echo $width?>" rows="10" wrap="physical"><?echo $course["info"]?></textarea>
</td>
</tr>
<tr>
<td class="main" rowspan="3" align="right" valign="top" bgcolor="<?echo $cBGMainInfo[0]?>">
<b>Applications:</b>
</td>
<td class="main" bgcolor="<?echo $cBGMainInfo[0]?>">
The course is closed except for those that are already members.
</td>
<td valign="top" bgcolor="<?echo $cBGMainInfo[0]?>">
<input type="Radio" name="applyopen" value="-1" <?if($course["applyopen"]==-1){echo "checked";}?>>
</td>
</tr>
<tr>
<td class="main" bgcolor="<?echo $cBGMainInfo[0]?>">
<b>I</b> want to accept every user and I will receive a mail for <br>every application in which I can respond instantantaniously.
</td>
<td valign="top" bgcolor="<?echo $cBGMainInfo[0]?>">
<input type="Radio" name="applyopen" value="0" <?if($course["applyopen"]==0){echo "checked";}?>>
</td>
</tr>
<tr>
<td class="main" bgcolor="<?echo $cBGMainInfo[0]?>">
Everyone is accepted automatically
</td>
<td valign="top" bgcolor="<?echo $cBGMainInfo[0]?>">
<input type="Radio" name="applyopen" value="1" <?if($course["applyopen"]==1){echo "checked";}?>>
</td>
</tr>
<? $mt=mysql_query("SELECT DISTINCT name,id,picture,info FROM modules_type;");?>
<tr>
<td class="main" rowspan="<?echo (mysql_num_rows($mt)+3)?>" align="right" valign="top" bgcolor="<?echo $cBGMainInfo[1]?>">
<b>User rights🙁Everyone)</b>
</td>
<td class="main" colspan="2" bgcolor="<?echo $cBGMainInfo[1]?>">
<input type="checkbox" name="modules_type[]" value="-1" <?
$check=mysql_query("SELECT from wp_access WHERE courses=".$course["id"]." AND modules_type=-1 AND users=0;");
if(mysql_num_rows($check)!=0){
echo "checked";
}?>>
<img src="../images/folder.gif" alt="" align="top" width=18 height=16>
<b>Folder</b>
</td>
</tr>
<tr>
<td class="main" colspan="2" bgcolor="<?echo $cBGMainInfo[1]?>">
<input type="checkbox" name="modules_type[]" value="-2" <?
$check=mysql_query("SELECT from wp_access WHERE courses=".$course["id"]." AND modules_type=-2 AND users=0;");
if(mysql_num_rows($check)!=0){
echo "checked";
}?>>
<img src="../images/cases.gif" alt="" align="top" width=20 height=16>
<b>Cases</b>
</td>
</tr>
<tr>
<td class="main" colspan="2" bgcolor="<?echo $cBGMainInfo[1]?>">
<input type="checkbox" name="modules_type[]" value="-3" <?
$check=mysql_query("SELECT from wp_access WHERE courses=".$course["id"]." AND modules_type=-3 AND users=0;");
if(mysql_num_rows($check)!=0){
echo "checked";
}?>>
<img src="../images/groups.gif" alt="" align="top" width=20 height=16>
<b>Groups</b>
</td>
</tr>
<? while($row=mysql_fetch_array($mt)){?>
<tr>
<td colspan="2" class="main" bgcolor="<?echo $cBGMainInfo[1]?>">
<input type="checkbox" name="modules_type[]" value="<?echo $row["id"]?>" <?
$check=mysql_query("SELECT from wp_access WHERE courses=".$course["id"]." AND modules_type=".$row["id"]." AND users=0;");
if(mysql_num_rows($check)!=0){
echo "checked";
}?>>
<img src="../<?echo $row["picture"]?>" align="top" width=20 height=16>
<b><?echo $row["name"]?></b>
<span class="small"><?echo $row["info"]?></span>
</td>
</tr>
<? }
$users=mysql_query("SELECT FROM users WHERE active=1 ORDER BY surname ASC,firstname ASC;");
$admins=mysql_query("SELECT u.id,u.surname,u.firstname FROM users u,wp,courses c WHERE c.id=".$course["id"]." AND c.id=wp.courses AND wp.users=u.id AND wp.admin=1 AND u.active=1 ORDER BY u.surname ASC, u.firstname ASC;");?>
<tr>
<td colspan="3" class="main" align="center" bgcolor="<?echo $cBGMainInfo[0]?>">
<div align="center"><b>Courseadministrators</b></div><br>
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<td align="center" class="small" valign="top">
<b>Administrators</b><br>
<select multiple name="courseadmins[]" size="7" style="width:200;">
<option value="0">----------------------------
<? while($row=mysql_fetch_array($admins)){
?><option value="<?echo $row["id"]?>"><?echo $row["surname"]."".$row["firstname"]?><?
}?>
</select>
</td>
<td align="center" class="small" valign="top">
<br><br>
<input type="button" value=" << " onClick="addadmin()">
<br><br>
<input type="button" value=" >> " onClick="removeadmin()">
</td>
<td align="center" class="small" valign="top">
<b>Other users</b><br>
<select multiple name="users[]" size="15" style="width:200;">
<option value="0">----------------------------
<? if(mysql_num_rows($admins)!=0){
mysql_data_seek($admins,0);
}
$mypos=0;
while($row=mysql_fetch_array($users)){
$show=1;
if($mypos<mysql_num_rows($admins)){
if(mysql_result($admins,$mypos,"id")==$row["id"]){
$show=0;
$mypos++;
}
}
if($show==1){
?><option value="<?echo $row["id"]?>"><?echo $row["surname"]."".$row["firstname"]?><?
}
}?>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3" align="left" class="mainwhite" valign="top" bgcolor="<?echo $cBGMainFunc?>" height="18">
<?if($courses==0){?>
<img src="../images/arrow.gif" width="7" height="7" alt="" border="0"> <a href="javascript:sendform();"><b class="mainwhite"><u>Create</u></b></a>
<?}else{?>
<img src="../images/arrow.gif" width="7" height="7" alt="" border="0"> <a href="javascript:sendform();"><b class="mainwhite"><u>Update</u></b></a>
<img src="../images/arrow.gif" width="7" height="7" alt="" border="0"> <a href="javascript:document.forms['create'].reset();"><b class="mainwhite"><u>Reset</u></b></a>
<?}?>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<?}else{
//User don't have access to this script?>
<p> </p>
<div align="center" class="h3">Sorry, you are not permitted to create or edit a course!</div>
<?}?>
<br>
<br>
<br>
</body>
);
Thanks in advance for any advice. 😉
Amanda
