script stops and outputs to html before end

[abyss]

Hello everyone!
I am very new to php, and I have to implement a mysql database, using php and apache as a server. I am on Windows XP.

It all goes well with querying the database. But I also need to collect some information from an html webpage. I wrote a function to do this and it seemed to work fine. However I have to call that function in a for loop to populate a table in html as my output. But it only works for the first two fields in the table and then it stops and returns the html page.
I have tried extending the maximum execution time and input time in php.ini, but it didn't solve the problem.

Does anyone know why is this happening and how to solve it?

Thanks for all the help you can give me.
Happy New Year!

[Rodney_H_]

I believe that someone may have a better chance of helping you solve it if you post your code...

[abyss]

This is the code of the function I am using.
It is called in a loop to fill-in the html table.

thanks for the help you can give me.

function calcsimil($acc1, $acc2)
{
$acc1 = ltrim($acc1, 'GO:');
$acc2 = ltrim($acc2, 'GO:');
$err = 'NA';
$url='http://xldb.fc.ul.pt/rebil/tools/ssm/getSSM.php?acc1='. $acc1.'&acc2='.$acc2.'&type=go&measure=JiangConrathGraSM';

$handle = fopen ($url, 'rb');
$webpage = " ";
if ($handle)
{
while (!feof($handle))
{
	$buffer = fgets($handle, 4096);
	$webpage = $webpage . $buffer;

}
fclose($handle);
$cut = substr($webpage, 1137, 220);

$tok = strtok($cut, '<>');
for($i=0; $i<22;$i++)
{
	$tok = strtok('<>');


}

return $tok;

}

[bradgrafelman]

First thing I noticed in the code you posted is that it's not in the forum's

 tags.

Second thing I noticed in the code that you posed is that it's not indented and very illegible.

Last thing I noticed is that you're missing a '}'.

[abyss]

As I've said before, I am new here, I looked around on how to make php tags, but haven't found out how to do it. If you could explain I would appreciate it.
I tried to post again my code, but the indentation was lost when I posted it.
The missing } was just missing here and not in my original code. I really need help on how to use the php tags.

This really isn't working, and I have been googling like mad, and going through some php books, and nothing seems to be the answer. Remember this works when it is called just once, but when called in a loop to fill in the html table it stops after 2 or 3 iterations.

I'm sure someone experienced in php could help me with this. But I am not sure if this problem should be a post in the newbie forum. If I should post it someplace else please advise me where.
I was told this was the best forum to ge help on php.

And also I would like to know if bradgrafelman, didn't really look at my code because it was not indented and between php tags, or if he did and really counldn't find anything wrong with it apart the missing {.

Help both on this and on how to do the php tags would be very welcome!

🙂

[Installer]

Here's your code formatted and tagged for others to look at, with a missing "}" added at the bottom. It looks like you're overwriting "$tok" everytime you call "strtok()" (in the for loop), so all that's returned is the last one.

function calcsimil($acc1, $acc2)
{
    $acc1 = ltrim($acc1, 'GO:');
    $acc2 = ltrim($acc2, 'GO:');
    $err = 'NA';
    $url = 'http://xldb.fc.ul.pt/rebil/tools/ssm/getSSM.php' .
           '?acc1=' . $acc1 . '&acc2=' . $acc2 . 
           '&type=go&measure=JiangConrathGraSM';

$handle = fopen ($url, 'rb');
$webpage = " ";
if ($handle) {
    while (!feof($handle)) {
        $buffer = fgets($handle, 4096);
        $webpage = $webpage . $buffer;
    }
    fclose($handle);
    $cut = substr($webpage, 1137, 220);

    $tok = strtok($cut, '<>');
    for($i = 0; $i < 22; $i++) {
        $tok = strtok('<>');
    }
    return $tok;
}
}

To tag your code, hover over the 'php' icon above the edit box on the "Reply to Thread" page. The tool tip will pretty much tell you what to do.

[abyss]

Thank you so much, Installer! 🙂

Actually all I really want from this function is the last $tok, it corresponds to the data I need from that url. I am starting to believe that there is nothing really wrong with my function, so I will post the code where I call the function.

<table border>
<?php

$fields = mysql_num_fields($result);
$nbrows = mysql_num_rows($result);

echo '<tr>';
echo '<td></td>';

$i = 0;
while ($row = mysql_fetch_array($result))
{
	 echo('<td>'.$row[go_acc].'</td>');
	 $goh[$i]=$row[go_acc];
	$i++;
}

echo '</tr>';
$b = 0;
$reset = mysql_data_seek($result, $b);

while ($row = mysql_fetch_array($result))
{
	for ($j=0;$j<$fields;$j++)
	{
		echo '<tr>';
		echo ('<td>'.$row[$j].'</td>');

	for ($a=0; $a<$nbrows; $a++)
	{
		echo '<td>'. calcsimil($goh[$a], $row[$j]).'</td>';
	}
	echo '</tr>';

}
}
?>

</table>

So what I am trying to do wth this is to create a matrix that displays the relationships between the values I get from my database query. I get the relationships by accessing the url above, and I build my matrix as mysql values x mysql values (first row and first collumn have the same values).
However my problem is that I can only fill the first 2 or 3 fields of the table. Then it just stops and returns an incomplete table.
What do you think might be happening here? What can be preventing the conclusion of the loop?
I have tried the exact same code with a simpler function ( used a string concatenation one) and it worked out fine.

I am very new to php, any help would be appreciated! I am really really puzzled by this... :bemused:

katya

[Installer]

Sorry, I can't figure out from the code just what you're trying to do. I guess I'd need to see the db table. But try this code. It will probably do the same as before, but it's a little cleaned up, and a little more "array-oriented", if you will. I also added a couple echo statements to help debug.

$fields = mysql_num_fields($result);
echo '$fields = ' . $fields . '<br />';
$nbrows = mysql_num_rows($result);
echo '$nbrows = ' . $nbrows . '<br />';

echo '<table>';
echo '<tr>';
echo '<td></td>';

while ($row = mysql_fetch_array($result)) {
    echo '<td>' . $row['go_acc'] . '</td>';
    $goh[] = $row['go_acc'];
}

echo '</tr>';
$reset = mysql_data_seek($result, 0);

while ($row = mysql_fetch_array($result)) {
    foreach ($row as $row_value) {
        echo '<tr>';
        echo '<td>' . $row_value . '</td>';
        foreach ($goh as $goh_value) {
            echo '<td>' . calcsimil($goh_value, $row_value) . '</td>';
        }
        echo '</tr>';
    }
}

echo '<table>';

When you post php code to the forum, use the "php" icon, not the "html" one.

[abyss]

Thank you Installer!
Your code sure looks better than mine!

Unfortunately it still gives the same result as mine did.

I can post here a sample of my query result given as a table, and an example of what I want my table to look.

The result from my query can be returned as the following table:
|GO:000011|
|GO:000022|
|GO:001232|

But this is not what I need my user to see. What I want my user to see is a table like this:

|_________|GO:000011|GO:000022|GO:001232|
|GO:000011| 100% | 50% | 0% |
|GO:000022| 50% | 100% | 0% |
|GO:001232| 0% | 0% | 100% |

The percentages are obtained from that url (that's what the calcsimil function returns as $tok)

However my code gives a table like this:

|_________|GO:000011|GO:000022|GO:001232|
|GO:000011| 100% | 50% |

So the function is getting the result it should be getting but it does not go all the way through my table!

I am sorry for insisting, but I hope you guys can help me now that I explained things a little better!

I was really enjoying learning php (it's for a course I am doing) but then I came to this problem, and I feel very frustrated because I don't have sufficient knowledge and experience to deal with this.

Thank you again Installer for your help! (sorry about using the wrong tags... won't happen again 🙂 )

katya

[Installer]

Try this:

echo '<table><tr><td></td>';

while ($row = mysql_fetch_array($result)) {
    echo '<td>' . $row['go_acc'] . '</td>';
    $goh[] = $row['go_acc'];
}

foreach ($goh as $goh_value_1) {
    echo '<tr><td>' . $goh_value_1 . '</td>';
    foreach ($goh as $goh_value_2) {
        echo '<td>' . calcsimil($goh_value_1, $goh_value_2) . '</td>';
    }
    echo '</tr>';
}

echo '<table>';

[abyss]

Than you for your time and patience, Installer.
This seems to work a little better because it fills in 4 cells.
What could be the problem here?
I am completely lost....

🙁
katya