Linking student to courses...

Language: PHP
$lastid=mysql_insert_id();

Quote
mysql_insert_id() will convert the return type of the native MySQL C API function mysql_insert_id() to a type of long (named int in PHP). If your AUTO_INCREMENT column has a column type of BIGINT (64 bits) the conversion may result in an incorrect value. Instead, use the internal MySQL SQL function LAST_INSERT_ID() in an SQL query. For more information about PHP's maximum integer values, please see the integer documentation.

Language: PHP
<?php
 
	  //inserts an associative array into a table
 
	  function add_to_table($arrdata, $tablename){
 
		  foreach($arrdata as $key=>$value){
			  $keys[] = ';`'; . $key . ';`';;
			  $values[] = "';" . mysql_real_escape_string($value) . "';";
		  }
 
		  $key_list = join(';,';, $keys);
		  $value_list = join(';, ';, $values);
		  $SQL = "INSERT INTO `" . $tablename . "` (" . $key_list . ") VALUES (" . $value_list . ")";
		  $result = mysql_query($SQL);
	  }
 
  // adds info into course_student table right after info has been added to student table
				  $snum=mysql_insert_id();
 
				  for($i=0; $i <= $numcourses; $i++){
					$courses="course".$course_ids[$i];
 
					if (isset($_POST[$courses])){
						$link=array(';sno';=>$snum,';cid';=> $course_ids[$i],';year';=> date(';Y';));
						add_to_table($link,';course_student';);
					}
 
				  }
 
?>

Language: PHP
> $lastid=mysql_insert_id();
>

Language: PHP
> <?php
> 	  
> 	  //inserts an associative array into a table
> 	  
> 	  function add_to_table($arrdata, $tablename){
> 		  
> 		  foreach($arrdata as $key=>$value){
> 			  $keys[] = ';`'; . $key . ';`';;
> 			  $values[] = "';" .
> mysql_real_escape_string($value) . "';";
> 		  }
> 		  
> 		  $key_list = join(';,';, $keys);
> 		  $value_list = join(';, ';, $values);
> 		  $SQL = "INSERT INTO `" . $tablename . "` (" .
> $key_list . ") VALUES (" . $value_list . ")";
> 		  $result = mysql_query($SQL);
> 	  }
> 
>   // adds info into course_student table right
> after info has been added to student table
> 				  $snum=mysql_insert_id();
> 				  
> 				  for($i=0; $i <= $numcourses; $i++){
> 					$courses="course".$course_ids[$i];
> 					
> 					if (isset($_POST[$courses])){
> 						$link=array(';sno';=>$snum,';cid';=>
> $course_ids[$i],';year';=> date(';Y';));
> 						add_to_table($link,';course_student';);
> 					}
> 					
> 				  }
> 
> ?>
>

Quote
Before you execute the for loop for the courses, is there a way you can check how many elements in that before you execute it?

Language: PHP
//retrieve data from course table by field
 
	  function course_data($fieldname){
 
		  $result = mysql_query("SELECT ".$fieldname." FROM course");
 
		  while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
			  $arrdata[] =  $row[$fieldname];
		  }
 
		  return $arrdata;	 
	  }
 
                  $course_ids=array();
		  $course_ids=course_data(';cid';);
		  $numcourses=count($course_ids)-1;