Where I am making a mistake?

Ali_baba

Hello everybody,

I am making a mistake somewhere but I am unable to figure out. The browser is not displaying the result FROM QUERY. Can somebody please look this code and point my mistake out?

<?php
if ($_POST['verify_ktl']=="ok") {
echo <<<EOD
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">\n
<head>
<title>KTL - Kansanterveyslaitos</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<br />
<br />
<br />
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tbody>
       <tr>
       <td align="right" valign="top" bgcolor="#FFFFFF">
        <img src="ktl.gif" alt="" width="286" height="69" /></td>
       </tr>
</tbody>
</table>
<br />
<br />
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tbody>
       <tr>
       <td><b>Terveyskeskus/TK jako</b></td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td><b>Paikkakoodi</b></td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td><b>Sairaanhoitopiiri</b></td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       </tr>
       <tr>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
       </tr>
EOD;
require ('access.php');
$result = mysql_query("SELECT record_id,sairaanhoitopiiri,toimipaikkatyyppi,kuntayhtym,mukanahankkeessa,yksikko,paikkakoodi,sokerirasituskokeennytteenottopa,glukoosinmritysmenetelm,yhteyshenkilo,terveyskeskus,tkjatko,katuosoite,postiosoite,puhelin,toinenyhteyshenkilo,note,toim_joh_laa FROM ktl_epshp ORDER BY ktl_epshp.paikkakoodi");
$i=0;
while ($array = mysql_fetch_array($result))  {
   echo "<tr>";
   echo "<td>".$array['terveyskeskus']."&nbsp;/&nbsp;".$array['tkjatko']."</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>".$array['paikkakoodi']."</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>".$array['sairaanhoitopiiri']."</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<form name=\"".$i."\" action=\"view_epshp.php\" method =\"post\">";
   echo "<td><input type=\"hidden\" name=\"value\" value=\"" . $array['paikkakoodi'] . "\"><input type=\"hidden\" name=\"verify_list\" value=\"ok\"</td>";
   echo "<td><input type=\"submit\" value=\"View\"></td>";
   echo "</form>";
   echo "</tr>\n";
   $i++;
}
$result1 = mysql_query("SELECT record_id,sairaanhoitopiiri,toimipaikkatyyppi,kuntayhtym,mukanahankkeessa,yksikko,paikkakoodi,sokerirasituskokeennytteenottopa,glukoosinmritysmenetelm,yhteyshenkilo,terveyskeskus,tkjatko,katuosoite,postiosoite,puhelin,toinenyhteyshenkilo,note,toim_joh_laa FROM ktl_ksshp ORDER BY ktl_ksshp.paikkakoodi");
$i1=0;
while ($array1 = mysql_fetch_array($result1))  {
   echo "<tr>";
   echo "<td>".$array['terveyskeskus']."&nbsp;/&nbsp;".$array1['tkjatko']."</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>".$array1['paikkakoodi']."</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>".$array1['sairaanhoitopiiri']."</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
   echo "<form name=\"".$i1."\" action=\"view_epshp.php\" method =\"post\">";
   echo "<td><input type=\"hidden\" name=\"value\" value=\"" . $array1['paikkakoodi'] . "\"><input type=\"hidden\" name=\"verify_list\" value=\"ok\"</td>";
   echo "<td><input type=\"submit\" value=\"View\"></td>";
   echo "</form>";
   echo "</tr>\n";
   $i1++;
}
echo <<<EOD
</tbody>
</table>
EOD;
}
else {
echo <<<EOD
Direct access is denied.
<br />
EOD;
}
?>

harmor

that is poorly written code.
I'll rewrite and hopefully fix you problem in the process.

Ali_baba

Thanks a lot sir for helping me.

I tried it again and I am unable to figure out the problem.

Ali_baba

still no luck 😕

edcellgavin

are there no db errors? if none, try printing the number or records, if any, with mysql_num_rows() - also to find out if you have satisfied your 'IF' statement...

Ali_baba

Hello,

Thanks for reply.

No, there is no error in db and db is not corrput at all. I could access it from other scripts very well...But what's wrong with this script. Everything is written well :bemused:

wilku

At the very beginning of a script put error_reporting(E_ALL); and see if there's still no error message for something.

paulnaj

Hi Ali,

First thing I'd do is check the SQL independently ... there could be a spelling mistakes with names as long as that.

Anyway, I've boiled your code down to ...

<?php 
if ($_POST['verify_ktl']=="ok") { 
?>
<head><title>KTL - Kansanterveyslaitos</title></head> 
<body> 
<table border="0" cellspacing="0" cellpadding="0" align="center"> 
	<tr> 
		<td><b>Terveyskeskus/TK jako</b></td> 
		<td><b>Paikkakoodi</b></td> 
		<td><b>Sairaanhoitopiiri</b></td> 
		<td>&nbsp;</td>
	</tr> 
<?php
	require ('access.php'); 
	$result = mysql_query("
	SELECT		sairaanhoitopiiri
			, 	paikkakoodi
			, 	terveyskeskus
			, 	tkjatko
	FROM 		ktl_ksshp 
	ORDER BY 	paikkakoodi
	"); 
	$i = 0; 
	while ($array = mysql_fetch_array($result))  { 
?>
	<tr>
		<td><?php echo $array['terveyskeskus']."&nbsp;/&nbsp;".$array['tkjatko']; ?></td>
		<td><?php echo $array['paikkakoodi']; ?></td>
		<td><?php echo $array['sairaanhoitopiiri']; ?></td>
		<td>
			<form name="frm_<?php echo $i++; ?>" action="view_epshp.php" method ="post">
				<input type="hidden" name="paikkakoodi" value="<?php echo $array['paikkakoodi']; ?>">
				<input type="hidden" name="verify_list" value="ok"</td>
				<input type="submit" value="View">
			</form>
		</td>
	</tr>
<?php
	} // END WHILE
?>
</table> 
<?php
} else { 
?>
Direct access is denied. 
<br /> 
<?php
} 
?>

See how you get on with that. I could have easily left in some typo's because I can't debug it!!

Paul 🙂

Ali_baba

Thanks Paulnaj,

Thanks for debugging my code and giving some time to it 🙂

I tried your code but it didn't work. However, when I placed my script in other directory then it was working. Even my previous script was working as well.

That is quite strange 😕

paulnaj

Hi Ali,

It's no good just saying 'it didn't work'.

What didn't work?
Did you get an error message?
Did anything print?

Paul.

Ali_baba

Hello paulnaj,

I apalogize for the confusion. I mean your script and my script work but only when I kept them in other directory. I don't know why and how can a change in directory can effect.

The first directory was /project/ktl
Scripts didn't work
I changed the directory to /project/ktl_l
scripts worked 🙂

paulnaj

Hi Ali,

It might be a 'permissions' issue ... check to see if scripts can be executed in 'ktl' ... or if there are any differences between 'ktl' and 'ktl_l'.

Paul.

Ali_baba

Hello,

sorry for my late reply.

the permissions are ok and there is no change whatsoever 🙂

I guess that I shall try to transfer the variables by a middle script 🙂

justsomeone

I see that you have "require" statements in there that don't provide a path to the required file. In that case, the script will only work if it is in the same directory as the required file. Could that be the reason why it works in one directory and not in another?

Ali_baba

oh yes!

fool me
fool me
fool me :mad: :mad: :mad: :mad:

For the last 17 hours, I am trying different solutions but I didn't put the required "access.php" in the same directory as the script is

:mad: :mad:

Sometimes things are infront of you but you can't see them

Thanks a lot for everybody who tried to help me in this problem.You guys are just great 😃 🙂 😉

justsomeone

a fresh pair of eyes always helps!

hivelord

I'm having a similar problem.

I don't know what I need to do to let an included file link to images.

Example:
index.php includes header.php
header.php has <img src> lines in it for the interface.

Currently I only use include "header.php";

Should I do something else?

justsomeone

Request the page using a browser, and then use the view source option. That should help you identify the problem...