Jump to content

help in editing a row


tabatsoy

Recommended Posts

please help me with my code in editing, when i press on the edit, it will echo the row i clicked on the edit form.

 

Here is my code:

       

<?
session_start();
?>
<!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=iso-8859-1" />
<title>English Questions</title>

<link href="Layout.css" rel="stylesheet" type="text/css" />
<script type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>

<body>
<p align="center"><img src="images/logo.jpg" width="800" height="200" /><a name="top" id="top"></a></p>
<div align="center">
<?
$db = mysql_connect("localhost");
mysql_select_db("examination",$db);

$edit_questionNumber = $_POST["edit_questionNumber"];
$edit_question = $_POST["edit_question"];
$edit_choiceA = $_POST["edit_choiceA"];
$edit_choiceB = $_POST["edit_choiceB"];
$edit_choiceC = $_POST["edit_choiceC"];
$edit_choiceD = $_POST["edit_choiceD"];
$edit_answer = $_POST["edit_answer"];

$len_edit_qn = strlen($edit_questionNumber);
$len_q = strlen($edit_question);
$len_a = strlen($edit_choiceA);
$len_b = strlen($edit_choiceB);
$len_c = strlen($edit_choiceC);
$len_d = strlen($edit_choiceD);
$len_ans = strlen($edit_answer);
	if($len_edit_qn && $len_q && $len_a && $len_b && $len_c && $len_d && $len_ans){
		if(($edit_answer == $edit_choiceA) || ($edit_answer == $edit_choiceB) || ($edit_answer == $edit_choiceC) || ($edit_answer == 			$edit_choiceD)){
			$result = mysql_query("UPDATE englishQuestions
									SET question = '$edit_question', choiceA = '$edit_choiceA', choiceB = '$edit_choiceB',
										choiceC = '$edit_choiceC', choiceD = '$edit_choiceD', answer = '$edit_answer'
									WHERE englishQuestionID = '$edit_questionNumber'");
		}else{
			echo '<font class = "style2">d magkaparehas</font>';
		}
	}else if($len_edit_qn || $len_q || $len_a || $len_b || $len_c || $len_d && $len_ans){
		echo '<font class = "style2">fill in all the edit fields</font>';
	}

$add_question = $_POST["add_question"];
$choiceA = $_POST["add_choiceA"];
$choiceB = $_POST["add_choiceB"];
$choiceC = $_POST["add_choiceC"];
$choiceD = $_POST["add_choiceD"];
$answer = $_POST["add_answer"];

  	$len_question = strlen($add_question);
	$len_choiceA = strlen($choiceA);
	$len_choiceB = strlen($choiceB);
	$len_choiceC = strlen($choiceC);
	$len_choiceD = strlen($choiceD);
	$len_answer = strlen($answer);
	if($len_question && $len_choiceA && $len_choiceB && $len_choiceC && $len_choiceD && $len_answer){
		if(($answer == $choiceA) || ($answer == $choiceB) || ($answer == $choiceC) ||($answer == $choiceD)){
					$result = mysql_query("INSERT INTO englishQuestions
										(englishQuestionID, question, choiceA, choiceB, choiceC, choiceD, answer)
										VALUES(NULL, '$add_question', '$choiceA', '$choiceB', '$choiceC', '$choiceD', '$answer')");
		}else{
			echo '<font class = "style2">di magkaparehas</font>';
		}
	}else if($len_question || $len_choiceA || $len_choiceB || $len_choiceC || $len_choiceD || $len_answer){
		echo '<font class = "style2">fill in all the add fields</font>';
	}

?>
</div>
<table width="400" border="0" align="center" class="session">
  <tr>
    <td colspan="2" class="session" span>
<?
	if(!$_SESSION['loggedin']){
		echo '<br><font size = "3" color = "#000000"><strong>this page is for administrators only</font></strong><br><br>';
		echo '<font size = "1"><a href = "login.php">click here to log in </a></font><br><br>';
		exit;
	}
	echo 'English Questions -- Good day '.$_SESSION['loggedin'].'.<br><br>';
?>    </td>
  </tr>
  <tr>
    <td width="375"><font size="1"><a href="LogicQuestions.php">Logic Questions</a></font></td>
 <td width="415"><font size="1"><a href="ResultsPage.php">Results Page </a></font></td>
  </tr>
   <tr>
    <td width="375"><font size="1"><a href="MathQuestions.php">Math Questions</a></font></td>
 <td width="415"><font size="1"><a href="logout.php">Log out </a></font></td>
  </tr>
</table>
<p align="center">

<table width="850" border="0"  align="center" class="tableresults">
  <tr>
    <td align="center" width = "50" valign="center"><strong>question #</strong></td>
<td width="250" align="center" valign="center"><strong>question</strong></td>
<td width="100" align="center" valign="center"><strong>choice A</strong></td>
<td width="100" align="center" valign="center"><strong>choice B</strong></td>
<td width="100" align="center" valign="center"><strong>choice C</strong></td>
<td width="100" align="center" valign="center"><strong>choice D</strong></td>
<td width="100" align="center" valign="center"><strong>answer</strong></td>
<td width="50" align="center" valign="center"></td>
  </tr>
</table>

<table width="850" border="0"  align="center" class="underresult">
<?
	$query = "SELECT *
			FROM englishQuestions";
	$result = mysql_query($query);
	for($i = 0; $i < mysql_num_rows($result); $i++){
		$question_number = mysql_result($result, $i, "englishQuestionID");
		$question = mysql_result($result, $i, "question");
		$choiceA = mysql_result($result, $i, "choiceA");
		$choiceB = mysql_result($result, $i, "choiceB");
		$choiceC = mysql_result($result, $i, "choiceC");
		$choiceD = mysql_result($result, $i, "choiceD");
		$answer = mysql_result($result, $i, "answer");

		if($i % 2){
			$bg = "#BED9EF";
		}
		else{
			$bg = "#FFFFFF";
		}

		echo '<tr bgcolor = "'.$bg.'">
				<td width = "50" align = "center" valign = "center" >'.$question_number.'<td>';
				echo '<td width = "250" align = "center" valign = "center">'.$question.'</td>';
				echo '<td width = "100" align = "center" valign = "center">'.$choiceA.'</td>';
				echo '<td width = "100" align = "center" valign = "center">'.$choiceB.'</td>';
				echo '<td width = "100"align = "center" valign = "center">'.$choiceC.'</td>';
				echo '<td width = "100" align = "center" valign = "center">'.$choiceD.'</td>';
				echo '<td width = "100" align = "center" valign = "center">'.$answer.'</td>';
				echo '<td width = "50" align = "center" valign = "center"><a href = "#edit">edit</a>';
	  		'</tr>';
	}
?>
</table>
<br /><br />
<a name="edit" id="edit"></a>

<form id="form1" name="form1" method="post" action="englishQuestions.php">
  <table width="400" border="0" align="center" class="tableform1">
    <tr>
      <td width="85"> </td>
      <td width="305" rowspan="2"><strong>Edit Question</strong></td>
    </tr>
   
    <tr>
      <td> </td>
    </tr>
    <tr>
      <td width="85"><div align="right">question # </div></td>
      <td width="305"><input name="edit_questionNumber" type="text" id="edit_questionNumber" size="5" /></td>
    </tr>
   
    <tr>
      <td><div align="right">question</div></td>
      <td><input name="edit_question" type="text" id="edit_question" size="40" /></td>
    </tr>
    
<tr>
      <td><div align="right">choice A </div></td>
      <td><input name="edit_choiceA" type="text" id="edit_choiceA" /></td>
    </tr>
   
    <tr>
      <td><div align="right">choice B </div></td>
      <td><input name="edit_choiceB" type="text" id="edit_choiceB" /></td>
    </tr>
   
    <tr>
      <td><div align="right">choice C </div></td>
      <td><input name="edit_choiceC" type="text" id="edit_choiceC" /></td>
    </tr>
   
    <tr>
      <td><div align="right">choice D </div></td>
      <td><input name="edit_choiceD" type="text" id="edit_choiceD" /></td>
    </tr>
   
    <tr>
      <td><div align="right">answer</div></td>
      <td><input name="edit_answer" type="text" id="edit_answer" /></td>
    </tr>
   
    <tr>
      <td><div align="right">
          <input type="submit" name="Submit" value="edit" />
      </div></td>
      <td><input type="reset" name="Submit2" value="Reset" /></td>
    </tr>
  </table>
</form>

<div align="center"><a name="add" id="add"></a><br />
</div>

<form id="form2" name="form2" method="post" action="englishQuestions.php">
  <table width="400" border="0" align="center" class="tableform1">
    <tr>
      <td width="85"> </td>
      <td width="305" rowspan="2"><strong>Add question</strong></td>
    </tr>
   
    <tr>
      <td> </td>
    </tr>
    
<tr>
      <td><div align="right">question</div></td>
      <td><input name="add_question" type="text" id="add_question" size="40" /></td>
    </tr>
    
<tr>
      <td><div align="right">choice A </div></td>
      <td><input name="add_choiceA" type="text" id="add_choiceA" /></td>
    </tr>
    
<tr>
      <td><div align="right">choice B </div></td>
      <td><input name="add_choiceB" type="text" id="add_choiceB" /></td>
    </tr>
    
<tr>
      <td><div align="right">choice C </div></td>
      <td><input name="add_choiceC" type="text" id="add_choiceC" /></td>
    </tr>
   
    <tr>
      <td><div align="right">choice D </div></td>
      <td><input name="add_choiceD" type="text" id="add_choiceD" /></td>
    </tr>
   
    <tr>
      <td><div align="right">answer</div></td>
      <td><input name="add_answer" type="text" id="add_answer" /></td>
    </tr>
    
<tr>
      <td><div align="right">
        <input name="add" type="submit" id="add" value="add" />
      </div></td>
      <td><input type="reset" name="Submit3" value="Reset" /></td>
    </tr>
  </table>
  <div align="center"><br /></div>
</form>

<table width="400" border="0" align="center">
  <tr>
    <td><form id="form4" name="form4" method="post" action="">
      <input name="Submit4" type="button" onmouseup="MM_goToURL('parent','#top');return document.MM_returnValue" value="Back to Top" />
    </form>
    </td>
    <td><form id="form5" name="form5" method="post" action="">
      <div align="right">
        <input name="Submit5" type="button" onmouseup="MM_goToURL('parent','logout.php');return document.MM_returnValue" value="Log out" />
        </div>
    </form>
    </td>
  </tr>
</table><br />

</body>
</html>

 

please help!!! ???

Link to comment
https://forums.phpfreaks.com/topic/98935-help-in-editing-a-row/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.