Code: Select all
function deptIDNum($dept){
include("connect.inc");
//Create your SQL statement
$sql = "SELECT pkDeptID ";
$sql .= "FROM tblDept ";
$sql .= "WHERE fldDeptName ='" . $dept . "'";
$results = $myDatabase->select($sql);
return $results;
}Code: Select all
<?php
$lines = file('http://giraffe.uvm.edu/~rgweb/batch/curr_enroll_fall.txt');
$i=1;
//files to connect to database
include("db.inc");
include("error.inc");
include("mydb.inc");
include ("validation_functions.php");
while ($i <= 3030)
{
list($dept, $num, $title) =
explode(",", $lines[$i]);
// create sql statements to insert into table
$sql = "INSERT INTO ";
$sql .= "tblClasses ";
$sql .= "SET ";
$sql .= "fkDeptID='" . $j . "',";
$sql .= "fldClassNum='" . $num . "',";
$sql .= "fldClassName='" . $title . "';";
$j=deptIDNum($dept);
echo $j;
//Make a connection
include("connect.inc");
// execute SQL statement
//$className=$myDatabase->insert($sql);
$i++;
}
?>