Saving to a text file

mat0175

I have code that saves student schedules to a single file. I get the information from a mysql database that holds schedules for all the students. It is creates a very large text file (probably about 1 meg). It saves 4 lines (a single student) to a file at a time, but it only gets through half of it then proceeds to shut itself off and stops, I've set the time limit to reset after every student. It gets to the 819th student and the file size gets to 566k. I open the file like this:
$file = fopen("student_schedules.txt","w");

I save to the file after every student like this:
fputs($file,"$singleStudent",strlen($singleStudent);

and then close it with the fclose($file); function.
Is there a more efficient way to write to files for this kind of task?
Any kind of help or guidance from you would helpful

amcgrath

OUtta curiosity, if you have the information in a database,why are you writing it to a file? It doesn't make much sense....

Anon

The people in the office becuase they like going through it in paper rather then in a database so that\'s why i have to print it ot a textfile

amcgrath

well, that sucks. It does sound like the amount of processing is the source of your problem, so...can you append the student information to the end of the file, read the file into an array, sort it, and then write it back to disk? Can you paste your exeact code for review? Hope i can help...

AMC

Anon

Sure here's the code:

<?
include ('data.php3');
function tab($word,$length)
{
$totalWord = "";
$wordTrimed = trim($word);
$totalWord .= trim($word);
for($i = strlen($wordTrimed); $i <$length;$i++)
{
$totalWord.=" ";
}
$totalWord.="|";
return $totalWord;
}
$file = fopen("student_schedules.xqb", "w");
$students = d_load_all_students();
$count = count($students);
$wholeline = "\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n";
for($i = 0; $i < $count;$i++)
//for($i = 0; $i <300;$i++)
{
$singleStudent = "";
$row = $students[$i];
$hrm = $row['homeroom'];
$name = $row['text'];
$grade = $row['grdlvl'];
$id = $row['id'];
$singleStudent .=tab($name,'30');
$singleStudent .="|";
$classes = d_get_students_classes($id, "1"); //first half first semester
$classes2 = d_get_students_classes($id, "2"); //second half first semester
$classes3 = d_get_students_classes($id, "3"); //first half second semester
$classes4 = d_get_students_classes($id, "4"); //second half second semester
for($j = 1 ; $j <= 5;$j++) //counts from first class to fifth class for sem 1
{
$info = $classes[$j];
$code = $info['code'];
$singleStudent.=tab($code, '15');
}
for($j = 1 ; $j <=4;$j++) //counts from first class to fifth class for sem 2
{
$info = $classes3[$j];
$code = $info['code'];
$singleStudent.=tab($code, '15');
}
$singleStudent .="\n";
$singleStudent .=tab($hrm, '30');
$singleStudent .="|";
for($j = 1; $j <=5; $j++) //count for 1st class to 5th class for sem 1
{
$info = $classes[$j];
$checkInfo = $classes2[$j];
$room = $info['room'];
$code = $info['code'];
$codeCheck = $checkInfo['code'];
if($code != $codeCheck)
{
$room2nd = $checkInfo['room'];
$length = 15-strlen($room2nd)-strlen($room);

$singleStudent.= "$room";
for($k = 0; $k<$length;$k++)
{
$studentStudent.=" ";
}
$singleStudent.="$room2nd";
$singleStudent.= "|";
}
else
{
$singleStudent .= tab($room,'15');

}
}
for($j = 1; $j <=4; $j++) //count 1st class to 4th class for sem 1
{
$checkInfo = $classes4[$j];
$info = $classes3[$j];
$room = $info['room'];
$code = $info['code'];
$codeCheck = $checkInfo['code'];
if($code != $codeCheck)
{
$room2nd = $checkInfo['room'];
$length = 15-strlen(room2nd);
$singleStudent.=$room;
for($k = 0; $k<$length;$k++)
{
$singleStudent.=" ";
}
$singleStudent.=$room2nd;
}
else
{
$singleStudent.=tab($room,'15');
}
}
$singleStudent.="\n";
$singleStudent.=tab($grade , '30');
$singleStudent.="|";
for($j = 1; $j <= 5; $j++)
{
$info = $classes[$j];
$code = $info['code'];
$teacher_id = d_get_teacherid_from_classcode_only($code);
$teacher = d_get_teacher_from_id($teacher_id);
$checkInfo = $classes2[$j];
$checkCode = $checkInfo['code'];
if($checkCode!=$code)
{
for($k = 0; $k < 15-strlen($checkCode);$k++)
{
$singleStudent.=" ";
}
$singleStudent.=$checkCode;
$singleStudent.="|";
}
else
{
$singleStudent.=tab($teacher, '15');
}
}
for($j = 1; $j <=4; $j++)
{
$info = $classes3[$j];
$code = $info['code'];
$teacher_id = d_get_teacherid_from_classcode_only($code);
$teacher = d_get_teacher_from_id($teacher_id);
$checkInfo = $classes4[$j];
$checkCode = $checkInfo['code'];
if($checkCode!=$code)
{
for($k = 0; $k < 15-strlen($checkCode);$k++)
{
$single_student.=" ";
}
$singleStudent.= $checkCode;
$singleStudent.="|";
}
else
{
$singleStudent.=tab($teacher, '15');
}
}

$singleStudent.=$wholeline;
fputs($file,"$singleStudent",strlen($singleStudent));
set_time_limit(60);

}

fclose($file);
?>

amcgrath

eeeh, and all oyu want to do is write the data to a file? at first glance, I'd say the script is too bloated. If ya want, send me the files and delimited data and I can tighten it for ya....

mat0175

i can't send the files because there's student's phone numbers and full names, the school won't let me, the only other php file there is the data.php3 and the only things that i call from it is the d_load_all_students, which goes in the database and loads all the students into the array, along with their homeroom grade level and id, the other function i call from the data file is d_get_students_classes which loads all the students classes (for the specified semester) to an array. There actually only 2 semesters but at our school each semester is broken in half because some classes only run for half a semester, that's why there's four in total. The last function d_get_teacherid_from_classcode_only and d_get_teacher_from_id coincide with one another, the first one loads the teachers id by using the classcode, and the second one just loads the teacher from the teacher id. If you want i can copy and paste the datafile code, there's just a lot of stuff there that isn't being used by this file.