Could you explain me why this outputs a white (blank) page

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Could you explain me why this outputs a white (blank) page

Post by dimitris »

I used this code between html code and the output was a blank page!Not even a title from my html code!
Look at the code and explain me what kills the output!
I repeat the same SQL instruction and i receive results!
Check out:

Code: Select all

<?php
	
	//&#945;&#961;&#954;&#953;&#954;&#959;&#960;&#959;&#953;&#942;&#963;&#949;&#953;&#962; &#956;&#949;&#964;&#945;&#946;&#955;&#951;&#964;&#974;&#957; &#947;&#953;&#945; &#957;&#945; &#956;&#951;&#957; &#941;&#967;&#959;&#965;&#956;&#949; &#966;&#945;&#953;&#957;&#972;&#956;&#949;&#957;&#945; undef var
		$id[0]='';
		$cpu[0]='';
		$ram[0]='';
		$motherboard[0]='';
		$lancard[0]='';
		$utp[0]='';
		$ip[0]='';
		$vgacard[0]='';
		$soundcard[0]='';
		$speakers[0]='';
		$keyboard[0]='';
		$mouse=[0]='';
		$monitor[0]='';
		$motherboard_report[0]='';
		$lancard_report[0]='';
		$vgacard_report[0]='';
		$soundcard_report[0]='';
		$speakers_report[0]='';
		$keyboard_report[0]='';
		$mouse_report[0]='';
		$monitor_report[0]='';
		$software[0]='';
		
	
		
	function displayResults($result,$counterA,$id,$cpu,$ram,$motherboard,$lancard,$utp,$ip,$vgacard,$soundcard,$speakers,$keyboard,$mouse,$monitor,$motherboard_report,$lancard_report,$vgacard_report,$soundcard_report,$speakers_report,$keyboard_report,$mouse_report,$monitor_report,$software) 
		  {
			$counter=0;//metritis 5adwn gia na bgainoun 5ades
			$semaphore=0;//simaforos wste na kseroume an prepei na mpei  </tr> sto telos
			printf("<table border="0">");
			
						if($counter==0)
							{
								printf("<tr>");
							}
							
			  		  
			for( $i=0;$i<$counterA;$i++ )
				 {
						echo'<td>';
						echo'<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
								  <tr>
									<td><p>ID:'.$id[$i].'</p>
									<p>UTP:'.$utp[$i].'</p>
									<p>IP:'.$ip[$i].'</p>
									<p>CPU:'.$cpu[$i].'</p>
									<p>RAM:'.$ram[$i].'</p>
									<p>Motherboard:'.$motherboard[$i].'</p>
									'.if(strlen($motherboard_report[$i])>0)
									{
									echo '<p>'.$motherboard_report[$i].'</p>';
									}.'
									<p>LANcard:'.$lancard[$i].'</p>
									'.if(strlen($lancard_report[$i])>0)
									{
									echo '<p>'.$lancard_report[$i].'</p>';
									}.'
									<p>Soundcard:'.$soundcard[$i].'</p>
									'.if(strlen($soundcard_report[$i])>0)
									{
									echo '<p>'.$soundcard_report[$i].'</p>';
									}.'
									<p>Keyboard:'.$keyboard[$i].'</p>
									'.if(strlen($keyboard_report[$i])>0)
									{
									echo '<p>'.$keyboard_report[$i].'</p>';
									}.'
									<p>Mouse:'.$mouse[$i].'</p>
									'.if(strlen($mouse_report[$i])>0)
									{
									echo '<p>'.$mouse_report[$i].'</p>';
									}.'
									<p>Monitor:'.$monitor[$i].'</p>
									'.if(strlen($monitor_report[$i])>0)
									{
									echo '<p>'.$monitor_report[$i].'</p>';
									}.'
									<p>&#913;&#957;&#945;&#966;&#959;&#961;&#940; Software:</p>
									<p>'.$software[$i].'</p>
									<form name="form1" method="post" action="update.php?id='.$id[$i].'">
									  <div align="center">
										<input name="submit" type="submit" id="submit" value="Update Info">
									  </div>
									</form>
									</td> 
								  </tr>
								</table>';
						echo'</td>';
						
						
						$counter++;//mh to mpeurdeueis me to $counterA
								
						if($counter==3)
							{
								printf("</tr>");
								$semaphore=1;
								$counter=0;
							}
				}// telos for
					if($semaphore==0)
					{
					printf("</tr>");
					}
				printf("</table>");
		###############################################################################################################################################		
	    #   if($counterA>=15)
		#	{
		#		printf("<br><br><strong><font color="#000000" size="2" face="Arial">&#931;&#949;&#955;&#943;&#948;&#949;&#962; &#945;&#960;&#959;&#964;&#949;&#955;&#949;&#963;&#956;&#940;&#964;&#969;&#957;: [&nbsp;&nbsp;</font></strong>");
		#		$y=0;
		#		for($z=$counterA;$z>0;$z-=15)
		#		{
		#			$y++;
		#			printf("<a href="view_all_page2.php?step=0&choice=%s&id=%s&z=%s" style="text-decoration: none"><strong><font color="#ffffff" size="2" face="Arial">%s &nbsp;&nbsp;</font><strong></a>", $choice ,$id , $z , $y); //to $id einai to eidos anazitiseis, to $z einai o header pou deixnei apo poia eggrafi arxizoume
		#		}
		#		printf("]");
		# 	}//telos if($counterA
		###############################################################################################################################################
		}//telos function 
		
		require_once ("../../ww/connect.inc");
						$query = "SELECT * FROM workstations";
						$result = mysql_query ($query) or die("&#913;&#948;&#965;&#957;&#945;&#956;&#943;&#945; &#949;&#954;&#964;&#941;&#955;&#949;&#963;&#951;&#962; &#949;&#961;&#969;&#964;&#942;&#956;&#945;&#964;&#959;&#962;");
						
						
					$counterA=0;//metritis stis array
					while ($row = @ mysql_fetch_array($result))
					 {
						$counterA++;//apo8ikeuw ola ta onomata se pinaka 1 x $counterA
						
						$id[$counterA]=$row['id'];
						$cpu[$counterA]=$row['cpu'];
						$ram[$counterA]=$row['ram'];
						$motherboard[$counterA]=$row['motherboard'];
						$lancard[$counterA]=$row['lancard'];
						$utp[$counterA]=$row['utp'];
						$ip[$counterA]=$row['ip'];
						$vgacard[$counterA]=$row['vgacard'];
						$soundcard[$counterA]=$row['soundcard'];
						$speakers[$counterA]=$row['speakers'];
						$keyboard[$counterA]=$row['keyboard'];
						$mouse=[$counterA]=$row['mouse'];
						$monitor[$counterA]=$row['monitor'];
						$motherboard_report[$counterA]=$row['motherboard_report'];
						$lancard_report[$counterA]=$row['lancard_report'];
						$vgacard_report[$counterA]=$row['vgacard_report'];
						$soundcard_report[$counterA]=$row['soundcard_report'];
						$speakers_report[$counterA]=$row['speakers_report'];
						$keyboard_report[$counterA]=$row['keyboard_report'];
						$mouse_report[$counterA]=$row['mouse_report'];
						$monitor_report[$counterA]=$row['monitor_report'];
						$software[$counterA]=$row['software'];
						
					 }

					 displayResults($result,$counterA,$id,$cpu,$ram,$motherboard,$lancard,$utp,$ip,$vgacard,$soundcard,$speakers,$keyboard,$mouse,$monitor,$motherboard_report,$lancard_report,$vgacard_report,$soundcard_report,$speakers_report,$keyboard_report,$mouse_report,$monitor_report,$software);
	?>
Please help me i'm confused!
I can expect wrong output or some mistakes but not a blank page! :?
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

don't know if this will help, but try add this in the while loop

Code: Select all

displayResults($result,$counterA,$id,$cpu,$ram,$motherboard,$lancard,$utp,$ip,$vgacard,$soundcard,$speakers,$keyboard,$mouse,$monitor,$motherboard_report,$lancard_report,$vgacard_report,$soundcard_report,$speakers_report,$keyboard_report,$mouse_report,$monitor_report,$software);
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

Illusionist wrote:don't know if this will help, but try add this in the while loop

Code: Select all

displayResults($result,$counterA,$id,$cpu,$ram,$motherboard,$lancard,$utp,$ip,$vgacard,$soundcard,$speakers,$keyboard,$mouse,$monitor,$motherboard_report,$lancard_report,$vgacard_report,$soundcard_report,$speakers_report,$keyboard_report,$mouse_report,$monitor_report,$software);
I tried it with no use!
But there is no need for this change
I want to store all the values of the database into these arrays and then use them in the function which produces rows of 5 pcs each!
The strange is that i have used similar code to another webserver with logical results!
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Re: Could you explain me why this outputs a white (blank) pa

Post by dimitris »

I don't know if that is the key but i have never used before code with arrays in this webserver!
This isn't reasonable!I don't get even a single mistake btw a blank page!
And this destroys even the html code!
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

i think is is your main problem. This is really sloppy. My suggestion: redo all those nasty echo's. When you get done with the HTML part, then end the echo, continue with PHP, then start another echo...

Code: Select all

echo'<td>';
                  echo'<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
                          <tr>
                           <td><p>ID:'.$id[$i].'</p>
                           <p>UTP:'.$utp[$i].'</p>
                           <p>IP:'.$ip[$i].'</p>
                           <p>CPU:'.$cpu[$i].'</p>
                           <p>RAM:'.$ram[$i].'</p>
                           <p>Motherboard:'.$motherboard[$i].'</p>
                           '.if(strlen($motherboard_report[$i])>0)
                           {
                           echo '<p>'.$motherboard_report[$i].'</p>';
                           }.'
                           <p>LANcard:'.$lancard[$i].'</p>
                           '.if(strlen($lancard_report[$i])>0)
                           {
                           echo '<p>'.$lancard_report[$i].'</p>';
                           }.'
                           <p>Soundcard:'.$soundcard[$i].'</p>
                           '.if(strlen($soundcard_report[$i])>0)
                           {
                           echo '<p>'.$soundcard_report[$i].'</p>';
                           }.'
                           <p>Keyboard:'.$keyboard[$i].'</p>
                           '.if(strlen($keyboard_report[$i])>0)
                           {
                           echo '<p>'.$keyboard_report[$i].'</p>';
                           }.'
                           <p>Mouse:'.$mouse[$i].'</p>
                           '.if(strlen($mouse_report[$i])>0)
                           {
                           echo '<p>'.$mouse_report[$i].'</p>';
                           }.'
                           <p>Monitor:'.$monitor[$i].'</p>
                           '.if(strlen($monitor_report[$i])>0)
                           {
                           echo '<p>'.$monitor_report[$i].'</p>';
                           }.'
                           <p>&#913;&#957;&#945;&#966;&#959;&#961;&#940; Software:</p>
                           <p>'.$software[$i].'</p>
                           <form name="form1" method="post" action="update.php?id='.$id[$i].'">
                             <div align="center">
                              <input name="submit" type="submit" id="submit" value="Update Info">
                             </div>
                           </form>
                           </td>
                          </tr>
                        </table>';
                  echo'</td>';
something like:

Code: Select all

echo "<table><tr><td>Hello!</td></tr>";
if ($name){
echo "<tr><td>$name</td></tr>";
}else{
echo "<tr><td>Guest</td></tr>";
}
echo "</table>";
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

[quote="Illusionist"]
So you suggest to test each piece of code!
I'll try to test everything even the database to be sure!
#UPDATE: I looked again and i saw that i have used similar techniques to present data in that webserver!So the problem isn't arrays themselves!
It is frustrating!It is a problem with no sense! :x
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

For those who want to test the whole code:

Code: Select all

<?php
session_start(); 
header("Cache-control: private");
if(isset($HTTP_POST_VARS&#1111;'submit']))&#123;
	
		if((strlen($HTTP_POST_VARS&#1111;'new_id'])>0)&#123; 
		
				require_once ("../../ww/connect.inc");
				
				$motherboard_report = ereg_replace("\r\n","<br>",$motherboard_report); 
				$lancard_report = ereg_replace("\r\n","<br>",$lancard_report);
				$vgacard_report = ereg_replace("\r\n","<br>",$vgacard_report);
				$soundcard_report = ereg_replace("\r\n","<br>",$soundcard_report);
				$keyboard_report = ereg_replace("\r\n","<br>",$keyboard_report);
				$mouse_report = ereg_replace("\r\n","<br>",$mouse_report);
				$monitor_report = ereg_replace("\r\n","<br>",$monitor_report);
				$speakers_report = ereg_replace("\r\n","<br>",$speakers_report);
				$software = ereg_replace("\r\n","<br>",$software);
				 
				$query = "UPDATE workstations SET id='$new_id',cpu='$cpu',utp='$utp',ip='$ip',ram='$ram',motherboard='$motherboard',lancard='$lancard',vgacard='$vgacard',soundcard='$soundcard',
				keyboard='$keyboard',mouse='$mouse',monitor='$monitor',speakers='$speakers',
				motherboard_report='$motherboard_report',lancard_report='$lancard_report',vgacard_report='$vgacard_report',soundcard_report='$soundcard_report',keyboard_report='$keyboard_report',
				mouse_report='$mouse_report',monitor_report='$monitor_report',speakers_report='$speakers_report,software='$software' WHERE id='$id' LIMIT 1";
				$query_result = mysql_query ($query);
				
				if($query_result)&#123;
						echo '<b><font color="green"> &#917;&#960;&#953;&#964;&#965;&#967;&#951;&#956;&#941;&#957;&#951; &#949;&#947;&#947;&#961;&#945;&#966;&#942;! </font></b>';
						echo "<br>\n";
						echo'<b>&#928;&#949;&#961;&#953;&#956;&#941;&#957;&#949;&#964;&#949; &#955;&#943;&#947;&#959;, &#952;&#945; &#947;&#943;&#957;&#949;&#953; &#945;&#957;&#945;&#957;&#941;&#969;&#963;&#951; &#964;&#951;&#962; &#946;&#940;&#963;&#951;&#962;...</b>';
						echo'<meta http-equiv="Refresh" content="1;url=update.php">';
	
	
					&#125;else&#123;
						echo '<b><font color="red"> &#913;&#960;&#959;&#964;&#965;&#967;&#951;&#956;&#941;&#957;&#951; &#949;&#947;&#947;&#961;&#945;&#966;&#942;! </font></b>';
					&#125;//telos if($query_result)
					mysql_close();
				&#125;else&#123;
					echo '<b><font color="red"> &#926;&#941;&#967;&#945;&#963;&#949;&#962; &#954;&#940;&#964;&#953;! &#913;&#960;&#959;&#964;&#965;&#967;&#951;&#956;&#941;&#957;&#951; &#949;&#947;&#947;&#961;&#945;&#966;&#942;! </font></b>';
					
				&#125;//telos if(strlen...
		&#125;//telos if(isset(...
		require_once ("../../ww/connect.inc");
		$query = "SELECT * FROM workstations WHERE id='$id'";
		$result = mysql_query ($query) or die("&#913;&#948;&#965;&#957;&#945;&#956;&#943;&#945; &#949;&#954;&#964;&#941;&#955;&#949;&#963;&#951;&#962; &#949;&#961;&#969;&#964;&#942;&#956;&#945;&#964;&#959;&#962;");
		$row = @ mysql_fetch_array($result);
				$row&#1111;'motherboard_report']=ereg_replace("<br>","\r",$row&#1111;'motherboard_report']); 
				$row&#1111;'lancard_report']=ereg_replace("<br>","\r",$row&#1111;'lancard_report']);
				$row&#1111;'vgacard_report']=ereg_replace("<br>","\r",$row&#1111;'vgacard_report']);
				$row&#1111;'soundcard_report']=ereg_replace("<br>","\r",$row&#1111;'soundcard_report']);
				$row&#1111;'keyboard_report']=ereg_replace("<br>","\r",$row&#1111;'keyboard_report']);
				$row&#1111;'mouse_report']=ereg_replace("<br>","\r",$row&#1111;'mouse_report']);
				$row&#1111;'monitor_report']=ereg_replace("<br>","\r",$row&#1111;'monitor_report']);
				$row&#1111;'speakers_report']=ereg_replace("<br>","\r",$row&#1111;'speakers_report']);
				$row&#1111;'software']=ereg_replace("<br>","\r",$row&#1111;'software']);

echo'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>..:: Update Workstation Info @ CS-LABS WATCH v.1.00::..</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1253">
<style type="text/css">
<!--
body,td,th &#123;
	font-family: Arial, Helvetica, sans-serif;
&#125;
a:link &#123;
	color: #666666;
	text-decoration: none;
&#125;
.style3 &#123;color: #666666;
	font-weight: bold;
&#125;
.style4 &#123;font-size: 14px&#125;
a:visited &#123;
	text-decoration: none;
&#125;
a:hover &#123;
	text-decoration: underline;
&#125;
a:active &#123;
	text-decoration: none;
&#125;
.style5 &#123;
	font-size: 14;
	font-weight: bold;
&#125;
.style6 &#123;font-size: 12px&#125;
.style7 &#123;font-size: 12px; font-weight: bold; &#125;
.style8 &#123;color: #666666; font-weight: bold; font-size: 14px; &#125;
-->
</style></head>

<body>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="15"><img src="images/textbox_topleft.jpg" width="19" height="29"></td>
    <td width="938" background="images/textbox_topmid_rt.jpg"><span class="style3">.:Update Workstation Info:.</span></td>
    <td width="31"><img src="images/textbox_toprt.jpg" width="26" height="29"></td>
  </tr>
  <tr>
    <td background="images/textbox_sideleft.jpg">&nbsp;</td>
    <td bgcolor="#EDEEF0"><form name="form1" method="post" action="'.$PHP_SELF.'">
      <table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td width="50" bgcolor="#FFFFCC"><span class="style5"><span class="style6">&#908;&#957;&#959;&#956;&#945;</span>:</span></td>
          <td width="231" bgcolor="#FFFFCC"><input name="new_id" type="text" class="style6" id="new_id" value="'.$row&#1111;'id'].'"></td>
          <td width="32" bgcolor="#FFFFCC"><span class="style7">CPU</span></td>
          <td width="487" bgcolor="#FFFFCC"><input name="cpu" type="text" class="style6" id="cpu" value="'.$row&#1111;'cpu'].'"></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style5"><span class="style6">UTP</span>:</span></td>
          <td bgcolor="#FFFFCC"><input name="utp" type="text" class="style6" id="utp" value="'.$row&#1111;'utp'].'"></td>
          <td bgcolor="#FFFFCC"><span class="style5"><span class="style6">RAM</span>:</span></td>
          <td bgcolor="#FFFFCC"><input name="ram" type="text" class="style6" id="ram" value="'.$row&#1111;'ram'].'"></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style7">IP:</span></td>
          <td bgcolor="#FFFFCC"><input name="ip" type="text" class="style6" id="ip" value="'.$row&#1111;'ip'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style6"><strong>&#924;&#951;&#964;&#961;&#953;&#954;&#942;:</strong></span></td>
          <td><input name="motherboard" type="text" class="style6" id="motherboard" value="'.$row&#1111;'motherboard'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="motherboard_report" cols="100" id="motherboard_report">'.$row&#1111;'motherboard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#922;&#940;&#961;&#964;&#945; &#948;&#953;&#954;&#964;&#973;&#959;&#965;:</strong></span></td>
          <td bgcolor="#FFFFCC"><input name="lancard" type="text" class="style6" id="lancard" value="'.$row&#1111;'lancard'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="lancard_report" cols="100" id="lancard_report">'.$row&#1111;'lancard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td><span class="style6"><strong>&#922;&#940;&#961;&#964;&#945; &#947;&#961;&#945;&#966;&#953;&#954;&#974;&#957;: </strong></span></td>
          <td><input name="vgacard" type="text" class="style6" id="vgacard" value="'.$row&#1111;'vgacard'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="vgacard_report" cols="100" id="vgacard_report">'.$row&#1111;'vgacard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#922;&#940;&#961;&#964;&#945; &#942;&#967;&#959;&#965;: </strong></span></td>
          <td bgcolor="#FFFFCC"><input name="soundcard" type="text" class="style6" id="soundcard" value="'.$row&#1111;'soundcard'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="soundcard_report" cols="100" id="soundcard_report">'.$row&#1111;'soundcard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td><span class="style6"><strong>&#928;&#955;&#951;&#954;&#964;&#961;&#959;&#955;&#972;&#947;&#953;&#959;:</strong></span></td>
          <td><input name="keyboard" type="text" class="style6" id="keyboard" value="'.$row&#1111;'keyboard'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="keyboard_report" cols="100" id="keyboard_report">'.$row&#1111;'keyboard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#928;&#959;&#957;&#964;&#943;&#954;&#953;</strong></span></td>
          <td bgcolor="#FFFFCC"><input name="mouse" type="text" class="style6" id="mouse" value="'.$row&#1111;'vgacard'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="mouse_report" cols="100" id="mouse_report">'.$row&#1111;'mouse_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td><span class="style6"><strong>&#927;&#952;&#972;&#957;&#951;</strong></span></td>
          <td><input name="monitor" type="text" class="style6" id="monitor" value="'.$row&#1111;'monitor'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:<strong>
            <textarea name="monitor_report" cols="100" id="monitor_report">'.$row&#1111;'monitor_report'].'</textarea>
          </strong></strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#919;&#967;&#949;&#943;&#945;</strong></span></td>
          <td bgcolor="#FFFFCC"><input name="speakers" type="text" class="style6" id="speakers" value="'.$row&#1111;'speakers'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:</strong></span>
            <textarea name="speakers_report" cols="100" id="speakers_report">'.$row&#1111;'speakers_report'].'</textarea></td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><p><span class="style7">Software:</span>            
              <textarea name="software" cols="100" rows="10" id="software">'.$row&#1111;'software'].'</textarea>
          </p>            </td>
          </tr>
      </table>
      <p>
        <input name="submit" type="submit" id="submit" value="Confirm Update">
        <input name="reset" type="reset" id="reset" value="Reset to old values">
</p>
      </form>      
      <p>&nbsp;</p>
    <p>&nbsp;</p></td>
    <td background="images/textbox_sidert.jpg">&nbsp;</td>
  </tr>
  <tr>
    <td><img src="images/textbox_botleft.jpg" width="19" height="37" align="right"></td>
    <td background="images/textbox_botmid_rt.jpg"><span class="style4"> <a href="logoff.php"><img src="images/icon_mini_login.gif" width="15" height="13" border="0"></a></span><span class="style8"><a href="logoff.php">&#904;&#958;&#959;&#948;&#959;&#962;</a></span><span class="style4"><span class="style3">|<a href="schedule.php">Schedule</a>|<a href="add_workstation.php">&#928;&#961;&#959;&#963;&#952;&#941;&#963;&#964;&#949; &#957;&#941;&#959; &#963;&#964;&#945;&#952;&#956;&#972; &#949;&#961;&#947;&#945;&#963;&#943;&#945;&#962;</a>|<a href="mailto:takis@myrealbox.com?Bug%20in%20CS-LABS%20WATCH=">Report Bugs</a></span></span></td>
    <td><img src="images/textbox_botrt.jpg" width="26" height="37"></td>
  </tr>
</table>';
?>
</body>
</html>
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

This works just fine:

Code: Select all

<?php
		require_once ("../../ww/connect.inc");
		$query = "SELECT * FROM workstations WHERE id='$id'";
		$result = mysql_query ($query) or die("&#913;&#948;&#965;&#957;&#945;&#956;&#943;&#945; &#949;&#954;&#964;&#941;&#955;&#949;&#963;&#951;&#962; &#949;&#961;&#969;&#964;&#942;&#956;&#945;&#964;&#959;&#962;");
		$row = @ mysql_fetch_array($result);
		$row['motherboard_report']=ereg_replace("<br>","\r",$row['motherboard_report']); 
				$row['lancard_report']=ereg_replace("<br>","\r",$row['lancard_report']);
				$row['vgacard_report']=ereg_replace("<br>","\r",$row['vgacard_report']);
				$row['soundcard_report']=ereg_replace("<br>","\r",$row['soundcard_report']);
				$row['keyboard_report']=ereg_replace("<br>","\r",$row['keyboard_report']);
				$row['mouse_report']=ereg_replace("<br>","\r",$row['mouse_report']);
				$row['monitor_report']=ereg_replace("<br>","\r",$row['monitor_report']);
				$row['speakers_report']=ereg_replace("<br>","\r",$row['speakers_report']);
				$row['software']=ereg_replace("<br>","\r",$row['software']);
		

echo '<p>'.$row['id'].'</p>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="15"><img src="images/textbox_topleft.jpg" width="19" height="29"></td>
    <td width="938" background="images/textbox_topmid_rt.jpg"><span class="style3">.:Update Workstation Info:.</span></td>
    <td width="31"><img src="images/textbox_toprt.jpg" width="26" height="29"></td>
  </tr>
  <tr>
    <td background="images/textbox_sideleft.jpg">&nbsp;</td>
    <td bgcolor="#EDEEF0"><form name="form1" method="post" action="'.$PHP_SELF.'">
      <table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td width="50" bgcolor="#FFFFCC"><span class="style5"><span class="style6">&#908;&#957;&#959;&#956;&#945;</span>:</span></td>
          <td width="231" bgcolor="#FFFFCC"><input name="new_id" type="text" class="style6" id="new_id" value="'.$row['id'].'"></td>
          <td width="32" bgcolor="#FFFFCC"><span class="style7">CPU</span></td>
          <td width="487" bgcolor="#FFFFCC"><input name="cpu" type="text" class="style6" id="cpu" value="'.$row['cpu'].'"></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style5"><span class="style6">UTP</span>:</span></td>
          <td bgcolor="#FFFFCC"><input name="utp" type="text" class="style6" id="utp" value="'.$row['utp'].'"></td>
          <td bgcolor="#FFFFCC"><span class="style5"><span class="style6">RAM</span>:</span></td>
          <td bgcolor="#FFFFCC"><input name="ram" type="text" class="style6" id="ram" value="'.$row['ram'].'"></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style7">IP:</span></td>
          <td bgcolor="#FFFFCC"><input name="ip" type="text" class="style6" id="ip" value="'.$row['ip'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style6"><strong>&#924;&#951;&#964;&#961;&#953;&#954;&#942;:</strong></span></td>
          <td><input name="motherboard" type="text" class="style6" id="motherboard" value="'.$row['motherboard'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="motherboard_report" cols="100" id="motherboard_report">'.$row['motherboard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#922;&#940;&#961;&#964;&#945; &#948;&#953;&#954;&#964;&#973;&#959;&#965;:</strong></span></td>
          <td bgcolor="#FFFFCC"><input name="lancard" type="text" class="style6" id="lancard" value="'.$row['lancard'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="lancard_report" cols="100" id="lancard_report">'.$row['lancard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td><span class="style6"><strong>&#922;&#940;&#961;&#964;&#945; &#947;&#961;&#945;&#966;&#953;&#954;&#974;&#957;: </strong></span></td>
          <td><input name="vgacard" type="text" class="style6" id="vgacard" value="'.$row['vgacard'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="vgacard_report" cols="100" id="vgacard_report">'.$row['vgacard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#922;&#940;&#961;&#964;&#945; &#942;&#967;&#959;&#965;: </strong></span></td>
          <td bgcolor="#FFFFCC"><input name="soundcard" type="text" class="style6" id="soundcard" value="'.$row['soundcard'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="soundcard_report" cols="100" id="soundcard_report">'.$row['soundcard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td><span class="style6"><strong>&#928;&#955;&#951;&#954;&#964;&#961;&#959;&#955;&#972;&#947;&#953;&#959;:</strong></span></td>
          <td><input name="keyboard" type="text" class="style6" id="keyboard" value="'.$row['keyboard'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="keyboard_report" cols="100" id="keyboard_report">'.$row['keyboard_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#928;&#959;&#957;&#964;&#943;&#954;&#953;</strong></span></td>
          <td bgcolor="#FFFFCC"><input name="mouse" type="text" class="style6" id="mouse" value="'.$row['vgacard'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:
            <textarea name="mouse_report" cols="100" id="mouse_report">'.$row['mouse_report'].'</textarea>
          </strong></span></td>
          </tr>
        <tr>
          <td><span class="style6"><strong>&#927;&#952;&#972;&#957;&#951;</strong></span></td>
          <td><input name="monitor" type="text" class="style6" id="monitor" value="'.$row['monitor'].'"></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:<strong>
            <textarea name="monitor_report" cols="100" id="monitor_report">'.$row['monitor_report'].'</textarea>
          </strong></strong></span></td>
          </tr>
        <tr>
          <td bgcolor="#FFFFCC"><span class="style6"><strong>&#919;&#967;&#949;&#943;&#945;</strong></span></td>
          <td bgcolor="#FFFFCC"><input name="speakers" type="text" class="style6" id="speakers" value="'.$row['speakers'].'"></td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
          <td bgcolor="#FFFFCC">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><span class="style6"><strong>&#913;&#957;&#945;&#966;&#959;&#961;&#940;:</strong></span>
            <textarea name="speakers_report" cols="100" id="speakers_report">'.$row['speakers_report'].'</textarea></td>
        </tr>
        <tr bgcolor="#FFFFCC">
          <td colspan="4"><p><span class="style7">Software:</span>            
              <textarea name="software" cols="100" rows="10" id="software">'.$row['software'].'</textarea>
          </p>            </td>
          </tr>
      </table>
      <p>
        <input name="submit" type="submit" id="submit" value="Confirm Update">
        <input name="reset" type="reset" id="reset" value="Reset to old values">
</p>
      </form>      
      <p>&nbsp;</p>
    <p>&nbsp;</p></td>
    <td background="images/textbox_sidert.jpg">&nbsp;</td>
  </tr>
  <tr>
    <td><img src="images/textbox_botleft.jpg" width="19" height="37" align="right"></td>
    <td background="images/textbox_botmid_rt.jpg"><span class="style4"> <a href="logoff.php"><img src="images/icon_mini_login.gif" width="15" height="13" border="0"></a></span><span class="style8"><a href="logoff.php">&#904;&#958;&#959;&#948;&#959;&#962;</a></span><span class="style4"><span class="style3">|<a href="schedule.php">Schedule</a>|<a href="add_workstation.php">&#928;&#961;&#959;&#963;&#952;&#941;&#963;&#964;&#949; &#957;&#941;&#959; &#963;&#964;&#945;&#952;&#956;&#972; &#949;&#961;&#947;&#945;&#963;&#943;&#945;&#962;</a>|<a href="mailto:takis@myrealbox.com?Bug%20in%20CS-LABS%20WATCH=">Report Bugs</a></span></span></td>
    <td><img src="images/textbox_botrt.jpg" width="26" height="37"></td>
  </tr>
</table>';
?>
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post by Straterra »

Good god! Why are you using echo to echo that big ass ammount of code? I would suggest heredoc.
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

Straterra wrote:Good god! Why are you using echo to echo that big ass ammount of code? I would suggest heredoc.
thanks for the advice i'll keep it in mind but after i tested and splitted the code i discovered that this part of code which i put to another page generates a blank page :(

Code: Select all

<?php
if(isset($HTTP_POST_VARS['submit'])){
		if((strlen($HTTP_POST_VARS['new_id'])>0){ 
				require_once ("../../ww/connect.inc");
				$motherboard_report = ereg_replace("\r\n","<br>",$motherboard_report); 
				$lancard_report = ereg_replace("\r\n","<br>",$lancard_report);
				$vgacard_report = ereg_replace("\r\n","<br>",$vgacard_report);
				$soundcard_report = ereg_replace("\r\n","<br>",$soundcard_report);
				$keyboard_report = ereg_replace("\r\n","<br>",$keyboard_report);
				$mouse_report = ereg_replace("\r\n","<br>",$mouse_report);
				$monitor_report = ereg_replace("\r\n","<br>",$monitor_report);
				$speakers_report = ereg_replace("\r\n","<br>",$speakers_report);
				$software = ereg_replace("\r\n","<br>",$software);
				 
				$query = "UPDATE workstations SET id='$new_id',cpu='$cpu',utp='$utp',ip='$ip',ram='$ram',motherboard='$motherboard',lancard='$lancard',vgacard='$vgacard',soundcard='$soundcard',
				keyboard='$keyboard',mouse='$mouse',monitor='$monitor',speakers='$speakers',
				motherboard_report='$motherboard_report',lancard_report='$lancard_report',vgacard_report='$vgacard_report',soundcard_report='$soundcard_report',keyboard_report='$keyboard_report',
				mouse_report='$mouse_report',monitor_report='$monitor_report',speakers_report='$speakers_report',software='$software' WHERE id='$id' LIMIT 1";
				$query_result = mysql_query ($query);
				
				if($query_result){
						echo '<b><font color="green"> &#917;&#960;&#953;&#964;&#965;&#967;&#951;&#956;&#941;&#957;&#951; &#949;&#947;&#947;&#961;&#945;&#966;&#942;! </font></b>';
						echo "<br>\n";
						echo'<b>&#928;&#949;&#961;&#953;&#956;&#941;&#957;&#949;&#964;&#949; &#955;&#943;&#947;&#959;, &#952;&#945; &#947;&#943;&#957;&#949;&#953; &#945;&#957;&#945;&#957;&#941;&#969;&#963;&#951; &#964;&#951;&#962; &#946;&#940;&#963;&#951;&#962;...</b>';
						echo'<meta http-equiv="Refresh" content="1;url=update.php?id='.$id.'">';
	
	
					}else{
						echo '<b><font color="red"> &#913;&#960;&#959;&#964;&#965;&#967;&#951;&#956;&#941;&#957;&#951; &#949;&#947;&#947;&#961;&#945;&#966;&#942;! </font></b>';
						echo'<meta http-equiv="Refresh" content="1;url=update.php?id='.$id.'">';
					}//telos if($query_result)
					mysql_close();
				}else{
					echo '<b><font color="red"> &#926;&#941;&#967;&#945;&#963;&#949;&#962; &#954;&#940;&#964;&#953;! &#913;&#960;&#959;&#964;&#965;&#967;&#951;&#956;&#941;&#957;&#951; &#949;&#947;&#947;&#961;&#945;&#966;&#942;! </font></b>';
					echo'<meta http-equiv="Refresh" content="1;url=update.php?id='.$id.'">';
					
				}//telos if(strlen...
		}//telos if(isset(...*/

?>
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post by Straterra »

Where is $id being defined?
Illusionist
Forum Regular
Posts: 903
Joined: Mon Jan 12, 2004 9:32 pm

Post by Illusionist »

are you using an older version of PHP? because this

Code: Select all

$HTTP_POST_VARS['submit']
is now

Code: Select all

$_POST['submit'];
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

Illusionist wrote:are you using an older version of PHP? because this

Code: Select all

$HTTP_POST_VARS['submit']
is now

Code: Select all

$_POST['submit'];
I use the first option as works in other scripts in this webserver!
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post by Straterra »

Can you run this code for me please?

Code: Select all

<?php 
echo '<pre>'; 
echo 'PHP Version: '.phpversion()."\n"; 
echo 'Display Errors: '.(ini_get('display_errors') == '1' ? 'On' : 'Off')."\n"; 
echo 'Error Level: '.(ini_get('error_reporting') == '2047' ? 'E_ALL' : 'Not E_ALL')."\n"; 
echo 'Register Globals: '.(ini_get('register_globals') == '' ? 'Off' : 'On')."\n"; 
echo '</pre>'; 

/* 
PHP Version: 4.3.4RC2-dev 
Display Errors: On 
Error Level: E_ALL 
Register Globals: Off 
*/ 
?>
(This code was written by JAM and posted here.)
User avatar
dimitris
Forum Contributor
Posts: 110
Joined: Wed Jan 14, 2004 3:47 am
Location: Athens, Greece

Post by dimitris »

[quote="Straterra"]Can you run this code for me please?

Thanks!I was just looking to find this script for check!
Wait a minute please!
Post Reply