could anyone check this coding for me pls?
Posted: Thu Nov 04, 2010 3:34 pm
could anyone please help me with the code which is i have already displayed data from two table as a drop-down list and a multi select list but now i need to select one from drop-down list and one or more from multi select list the insert into another database table.
here is the coding. it shows no error message( blank page after submit) and nothing inserted on the test table
update_result.php
here is the coding. it shows no error message( blank page after submit) and nothing inserted on the test table
Code: Select all
<?php$con = mysql_connect("localhost","root","");
if (!$con) { die('Could not connect: ' . mysql_error()); }
error_reporting(E_ALL);
ini_set('display_errors', 1);
mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
$result = mysql_query("SELECT * FROM course") or trigger_error('MySQL error: ' . mysql_error());
echo '<select name ="cid[]" multiple="multiple" size="10">';
while($row = mysql_fetch_array($result))
{ echo '<option value="' . $row['CourseID'] . '">' . $row['CourseName'] . '</option>'; }
echo '</select>'; /
/ ----------------
$result = mysql_query("SELECT * FROM student") or trigger_error('MySQL error: ' . mysql_error());
echo '<select name="sid">'; while($row = mysql_fetch_array($result))
{ echo '<option value="' . $row['StudentID'] . '">' . $row['StudentName'] . '</option>'; }
echo '</select>';
mysql_close($con); ?>
<form id="form1" name="form1" method="post" action="update_result.php">
<label> <input type="submit" name="Submit" value="Submit" /> </label>
</form>
</body>
</html>
update_result.php
Code: Select all
<?php $con = mysql_connect("localhost","root","");
if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
if (!empty($_POST['sid']) && !empty($_POST['cid']))
{ foreach ($_POST['cid'] as $key => $course)
{ $courses .= $course."-"; } $courses = rtrim($courses,"-");
$student = $_POST['sid'];
$sql = "INSERT INTO test (StudentID, CourseID) VALUES('".mysql_real_escape_string($student)."','".mysql_real_escape_string($courses)."')";
$query = mysql_query($sql) or trigger_error('MySQL error: ' . mysql_error());
if (mysql_affected_rows() > 0)
{ echo mysql_affected_rows() . ' rows added.';
} }
mysql_close($con);
?>
</body>
</html>