Variable help for a newbie?

[phpnoob]

Hi. I'm just starting with PHP and this looks like a good place to ask my question. Thanks in advance!

I have the GD (Graphic Draw) Library working...sort of. It will display the default "PHP Rules" image from a stream, but I need it to use the binary stream from my database, instead.

My code is:

Code: Select all

<?php
header('Content-Type: image/jpeg');
$data = 'iVBORw0KGgoAAAANSUhEUgAAABwAAAASCAMAAAB/2U7WAAAABl'
. 'BMVEUAAAD///+l2Z/dAAAASUlEQVR4XqWQUQoAIAxC2/0vXZDr'
. 'EX4IJTRkb7lobNUStXsB0jIXIAMSsQnWlsV+wULF4Avk9fLq2r'
. '8a5HSE35Q3eO2XP1A1wQkZSgETvDtKdQAAAABJRU5ErkJggg==';
$data = base64_decode($data);
$im = imagecreatefromstring($data);
if($im !== false) imagejpeg($im);
else echo 'An error occurred.';
?>
<?php 
session_start();
$_SESSION['empcode'] = $empcode;
$_SESSION['middle'] = $middle;
$_SESSION['firstname'] = $firstname;
$_SESSION['lastname'] = $lastname;
$_SESSION['leavehours'] = $leavehours;
?>
<?php
//CONNECTION STATEMENT. Can also be plugged into an .inc file, then just refer to the .inc file.
$conn = mssql_connect("*DATABASE*","*USERNAME*","*PASSWORD*") or die ("Could Not Connect to Database.<br>Please Notify Computer Services.");
mssql_select_db('Database',$conn);
?>
<?php
 
$RESULTDS=mssql_query("SELECT DISTINCT LH.[Employee Number], M2.[HRYRAT], M2.[EMPNO], M2.[MANLAP], M2.[PAYCTR], M2.[MANLAC], M2.[MANLTC], M2.[MSKLAB], M2.[MSKLTC], M2.[NAMEMI], M2.[NAMEL], M2.[NAMEF], EH.[DATE], EH.[ENETPA], LH.[LOCC], EH.[EGRSER], EH.[EREGHR], EH.[EDEDUC], EH.[EROTHR], EH.[EFWHD], EH.[EPEDAT], EH.[ESSDED], EH.[EHOSPD], EH.[ELIFED], EH.[ECRUD], M2.[POSITN], M2.[MCTDWH], M2.[MHDATE], M2.[MCTDCS], M2.[MO3TOT], M2.[MCTDLD], M2.[MCTDGE], M2.[MALPPP], M2.[MSLPPP], M2.[MWHSTA], M2.[MWHALL], M2.[MWHADD], EH.[EGARND], EP.[EMPNO], DP.[EMPNO], EI.[DDEPTN], EI.[NEWOCC], EI.[HRYRAT], EI.[MEMPAD], EI.[MEMPCS], EI.[MEMPZI], view_EmployeeInfo.[EmpPicture]
FROM LEAVHST LH 
JOIN MASTERL2 M2 
ON LH.[Employee Number]=M2.EMPNO JOIN EARNHIST EH
ON EH.[EEMPNO]=M2.EMPNO JOIN EMPPICTURE EP
ON EP.[EMPNO]=EH.EEMPNO JOIN Departments DP
ON DP.[EMPNO]=EP.EMPNO JOIN View_EmployeeInfo EI
ON EI.[EMPNO]=M2.EMPNO
WHERE M2.[EMPNO] = '".$_POST['employeenumber']."' and 
M2.[MSSNO] = '".$_POST['password']."' 
 
ORDER BY EH.[DATE] desc"); 
$RESULT=mssql_fetch_assoc($RESULTDS) or die("<CENTER><img src=\"http://orserva/images/invalidnumber.gif\"></CENTER><BR><CENTER><table width=60 //border=0><tr><td><font size=\"3\" color=\"#000000\" face=\"arial\">Need help? Here is an example entry:</font></td></tr><tr><td align=center><img //src=\"http://orserva/images/leaveexample.gif\"></td></tr><tr><td><font size=\"3\" color=\"#000000\" //face=\"arial\">Enter your Employee Number<BR>Enter your password (Social Security Number)<BR>Click Submit<BR><BR>If you're still having difficulty, click here to </font><font size=\"3\" color=\"#ff0000\" //face=\"arial\"><BR><a href=\"mailto:HelpDesk@cortn.org? subject=Problem with the Pay Stubs On Demand //System\"><b>E-mail the HelpDesk</b></a></font></td></tr></table></CENTER>");
 
?>

I need the $data variable to point to the employee image in the database, BUT.... since the header info has to be at the top of the page, that variable doesn't yet "exist" at the point where the code is run.

The code above is displaying the "PHP Rules" image, so the GD Library works.

Any help is greatly appreciated.


EDIT: The code above is in a file called "showpic.php." I call it by using <img src="showpic.php"> in another file.

[ukgeoff]

You need to use;

ob_start();

to buffer the output so the header doesn't get sent while you run through the rest of the code.

When everything is set to go, use;

ob_end_flush();

to flush the output buffer and send everything on its way.

[phpnoob]

Originally Posted by ukgeoff

You need to use;

ob_start();

to buffer the output so the header doesn't get sent while you run through the rest of the code.

When everything is set to go, use;

ob_end_flush();

to flush the output buffer and send everything on its way.

Would you be so kind as to show a moron where these functions go in my code? Sorry, but I'm a PHP newbie.

Thanks!

[ukgeoff]

Place ob_start(); as the first line of code in your file. Before any other php or html.

When you have processsed the last of your php, place the ob_end_flush(); line there.