Page 1 of 1

could anyone check this coding for me pls?

Posted: Thu Nov 04, 2010 3:34 pm
by mtvaran
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

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>



Re: could anyone check this coding for me pls?

Posted: Thu Nov 04, 2010 3:54 pm
by Jonah Bron
Please edit your post and format your code. It is unreadable in it's current form. Thank you.

Re: could anyone check this coding for me pls?

Posted: Thu Nov 04, 2010 4:06 pm
by mtvaran
i have done! is that ok now?

Re: could anyone check this coding for me pls?

Posted: Thu Nov 04, 2010 4:43 pm
by Jonah Bron
Ugh, unreadable. This is what I had in mind:

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>
Edit your post and paste this in, and format the other block the same way.

You will get a lot more answers if you do this :)