PHP - Dealing With File_get_contents Errors?

Hi All,

I've a loop which creates an array as follows:

$product_table[] = ['SKU' => $sku, 'Label' => $attribute_name, 'Value' => $term_obj->name ];

I'm then grouping the data by SKU code:

                        #group the products by SKU
                        $group_products = array();
                        foreach ($product_table as $element) :
                            $group_products[$element['SKU']][] = $element;
                        endforeach;

Finally, I output the data:

                        #output the data
                        foreach ($group_products as $itemName => $rows) :
                            echo '<tr>';
                            #echo '<td>', $element['SKU'], '</td>';
                            $i=0;
                            foreach ($rows as $row) : $i++;
                                #echo '<td>'. $row["SKU"]. '</td><td>'. $row["Label"]. '</td><td>'. $row["Value"]. '</td>';
                                if ($i == 1):
                                	echo '<td>'. $row["SKU"]. '</td><td>'. $row["Value"]. '</td>';
                                else:
                                	echo '<td>'. $row["Value"]. '</td>';
                                endif;
                                #echo '<td>'. $row["Value"]. '</td>';
                            endforeach;
                            echo '</tr>';
                        endforeach;
                        ?>          

And looks like:

Product code System Pack Quantity XT1CWH System 1 1 x 3m XT2CWH System 2 1 x 3m XT3CWH System 3 1 x 3m

 

This works perfectly fine. However, some products share the same SKU and therefore it causes an issue, like the below:

 

Product code System Pack Quantity XT1CLWH System 1 8 x 3m System 2 8 x 3m System 3 8 x 3m
 
Is there a way I can avoid this, so if perhaps creates the new row but shows the same SKU code?
 
Many thanks

I am using Guzzle as a HTTP client, and the following script results in the following error:

$response = $this->httpClient->request('GET', "http://$this->host:$this->port/query", ['query' => $data]);
$body = $response->getBody();
$rs=json_decode($body, true);

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 136956008 bytes) in /var/www/vendor/guzzlehttp/psr7/src/Stream.php on line 80

What are the work arounds?  Instead of trying to convert it into an array all at once, how can I do so in pieces?  I know the expected format so it seems I will need to read just the appropriate amount of bytes and then decode parts at a time.  Seems like a pain.  Are there any classes designed to do so, or can any of the following Guzzle built in methods be used?

Thanks

Guzzle Response methods:

__construct getStatusCode getReasonPhrase withStatus getProtocolVersion withProtocolVersion getHeaders hasHeader getHeader getHeaderLine withHeader withAddedHeader withoutHeader getBody withBody

Guzzle Body methods:

__construct __destruct __toString getContents close detach getSize isReadable isWritable isSeekable eof tell rewind seek read write getMetadata
 

How can I check if the text entered in a textarea field equals the text I have stored in a mysql table?

Code: [Select]
$submitted_description = trim(mysqli_real_escape_string($db,$_POST['description']));

$query = "SELECT description FROM pets";
$result = $db->query($query);
$row = $result->fetch_assoc();
$sql_description = $row['description'];
Here's what they echo:

Quote

submitted_description:
Testing...\r\n\r\n1\r\n\r\n2\r\n\r\n3

sql_description:
Testing... 1 2 3


I tried adding the following to get rid of \r\n from $submitted_description but they both still don't equal but echo the same text.

Code: [Select]
$submitted_description = str_replace(array("\r","\n",'\r','\n'),' ', $submitted_description);
They following code only matches when no spaces are entered in the textarea field.

Code: [Select]
if($submitted_description == $sql_description)
{
     echo "Match!";
}
else
{
     echo "Don't Match!";
}
How can this be done?

I also tried adding nl2br() to both variables but that didn't work either.

I have a mysql table like so

ID  OrderID  Name  Image       CatalogID
1   1             test     pic1.jpg    1
2   2             test2   pic2.jpg    1
3   1             test3   pic3.jpg    2
4   1             test4   pic4.jpg    3
5   1             test5   pic5.jpg    4
6   2             test6   pic6.jpg    4
7   3             test7   pic7.jpg    4

etc etc

(1) I want to use up and down buttons so that the OrderID can be modified to reflect the users order preference, how would I code it so it changes all the OrderID values in the table as  necessary to produce the correct order using the buttons, the only affected items each time would be the ones in the same CatalogID group.

(2) How do I re number the OrderID when an item is deleted so that it moves all the items below it in the same CatalogID group up one value to still reflect the correct order and not skip OrderID values.

I'm dealing with data that WordPress creates for Users when they register and subscribe, and to use it for other purposes, I have to wrap my head around serialized data.  It's not sinking in well.  The below code works well for what I wanted at the time. 

It takes into consideration where the Subscriber lives (divided up into five areas) and counts how many I have.  That is noted by wp_s2member_custom_fields and ANY s2member_level.  There are three levels, and I need to actually note how many there are at each Member level. 

There is another line of data for each user_id
meta_key = wp_capabilities
meta_value = a:1:{s:15:"s2member_level2";s:1:"1";}


Code: [Select]

$custom = 'SELECT * FROM wp_usermeta WHERE meta_key = "wp_s2member_custom_fields" AND user_id IN (SELECT user_id FROM wp_usermeta WHERE meta_value LIKE "%s2member_level%")';
$c_results = mysql_query($custom);

$region = array();

while($line = mysql_fetch_assoc($c_results)) {

$meta_value = unserialize($line['meta_value']);

$region[$meta_value['county']]++;
};

foreach ($region as $key => $value) {

echo "Region $key: $value members<br>";
}

Hi

I am new to PHP / mySQL although not to programming and am trying to work out how to deal with the following situation:

I have a form for a user to add a book to a database, along with the genres that the book belongs to. Each book can have a number of genres
.

There are 3 tables, books, genres and bg_xref  in the following formats
table: books
fields: id, title, author, date published

table: genres
fields: id, genre

table: bg_xref
fields: id, book_id, genre_id

I am now trying to build the form that allows the user to update an existing entry for a book. the genres are selectable from a multi-selection list which I am populating from all the possible values in the genres table.

Currently I have the following database selections:
mysql_select_db($database_conn, $conn1);
$query_rs_getBooks = "SELECT books.id, books.title, books.author, bg_xref.genre_id
         FROM books LEFT JOIN bg_xref ON books.id = bg_xref.book_id";
$rs_getBooks = mysql_query($query_rs_getBooks, $conn1) or die(mysql_error());
$row_rs_getBooks = mysql_fetch_assoc($rs_getBooks);

mysql_select_db($database_conn, $conn1);
$query_rs_getGenre = "SELECT * FROM book_genres ORDER BY genre ASC";
$rs_getGenre = mysql_query($query_rs_getGenre, $conn1) or die(mysql_error());
$row_rs_getGenre = mysql_fetch_assoc($rs_getGenre);

I have then created a form that the user uses to update the book, but am trying to work out how to prepopulate the selection list based on teh results of the join e.g.

<form method="POST" action="<?php echo $editFormAction; ?>" name="update_book">
<fieldset class="full">
<legend>Enter book details below</legend>
<table>
<tr><td>Title: </td><td><input type="text" size="50" value="<?php echo htmlentities($row_rs_getBooks['title'], ENT_COMPAT, 'iso-8859-1'); ?>" name="title"></td></tr>
<tr><td>Author: </td><td><input type="text" size="30" value="<?php echo htmlentities($row_rs_getBooks['author'], ENT_COMPAT, 'iso-8859-1'); ?>" name="author_surname"></td></tr>

<tr><td>Genre(s)</td><td><select name="genre" multiple size="4">
  <?php do {  ?>
    <?php if (($row_rs_getBooks['genre_id']) != $row_rs_getGenre['id']) { ?>
      <option value="<?php echo $row_rs_getGenre['id']?>"><?php echo $row_rs_getGenre['description']?></option>
   <?php } else { ?>
    <option value="<?php echo $row_rs_getGenre['id']?>" selected><?php echo $row_rs_getGenre['description']?></option>
    <?php }
        } while ($row_rs_getGenre = mysql_fetch_assoc($rs_getGenre));
   $rows = mysql_num_rows($rs_getGenre);
   if($rows > 0) {
      mysql_data_seek($rs_getGenre, 0);
      $row_rs_getGenre = mysql_fetch_assoc($rs_getGenre);
  }
?>
</select></td></tr>
</table>
</fieldset>
<input type="hidden" name="id" value="<?php echo $row_rs_getBooks['id']; ?>">
<input type="submit" value="Update book details">
<input type="hidden" name="MM_update" value="update_book">
</form>

Book id = 1 is classified against genres 1 and 5, so my SQL query returns 2 rows:
book.id = 1 + bg_xref.genre_id = 1
book.id = 1 + bg_xref.genre_id = 5

At the moment the form is generated for the first row of the results set with
<tr><td>Genre(s)</td><td><select name="genre" multiple size="4">
                 <option value="5">Humour</option>
             <option value="4">Non Fiction</option>
             <option value="2">Novel</option>
             <option value="3">Picture Books</option>
             <option value="1" selected>Poetry</option>
            
with a second entry in the results set  for book 1 and genre 5.

What I need to end up with is a second occurence of book 1 with both genres 1 and 5 set in the form.

Thanks

Stuart

MySQL returns an error in the form of a number, a state, and a message. Without parsing the message you will not be able to determine what column is duplicated.While parsing the error code, I have also notice that, if you have multiple unique fields as duplicates, only the first duplicate encountered will be returned in the message. This is not very helpful to the end user.   Is there any way to parse the returned error code to reflect all duplicate fields, please see sample code below?

$error=array();
$sql = 'INSERT INTO staff(username, email, phone)
VALUES (?, ?, ?)';
$stmt = $conn->stmt_init();
$stmt = $conn->prepare($sql);
// bind parameters and insert the details into the database
$stmt->bind_param('sss', $username, $email, $phone);
$stmt->execute();
if ($stmt->errno == 1062) {
$errors[] = "One of the fields is already in use.";
}

Okay, so I'm trying to make a service to detect proxies. Heres what I need to know..
This is how I have it set up:
1. I have a file on mysite.com/check.php
2. My clients create a page to load my check.php file on THEIR website using file_get_contents(); Like: file_get_contents("http://mysite.com/check.php?ip=$_SERVER['REMOTE_ADDR']");
3. My system checks for a proxy using HTTP vars, how would I get them?? Like.. if I echo $_SERVER['REMOTE_ADDR']; out on the page on MY end, it will echo the servers IP to check is using step #2 with file_get_contents();

Can anyone please help me? I am willing to pay a little, if needed :/
Thanks in advance!

This works great but I only need part of the page for example the right column...can I do this with a class or some how.  What this is is pulling information from another site.

Code: [Select]

<?php $g = file_get_contents("http://www.site.com/index.php");
echo ($g);
?>

Hi heres what I would like to do, im sure its not the best way to do it but its the only way I have used in the past .

getting content string
<?php $file = file_get_contents('contents.txt', 'r'); echo $file; ?>

usualy I would use a edit link with this code
<?php if(session_is_registered(myusername)){ ?><a href="javascript:open1()"><div id="edit_link">Edit</a></div><?php } ?>

But what I would like to do now is to skip the edit link and just make the content string a link once the user is logged in they will be able to click on the content string and it will activate the javascript:open1()

Many thanks for your help

Hello I wanted to query something from an API, but now I have 2 times money see example below. How can I only output one of them I have already looked for a solution but cannot find any or I am looking wrong

{
  "result": [
    {


      "Money": 45674569.88764
    },
    {


      "Money": 546.6544356456
    }
  ],


  "test": 0
}

 <?php
              $myData = file_get_contents("");
              $myObject = json_decode($myData);
              $myObjectMap = $myObject->result;
?>
<?php foreach($myObjectMap as $key => $item): ?>
<?PHP echo $item->Money; ?>

 

im trying to display the contents of a file within a div. plain html is fine but i need this file to have php variables within it.
eg:

the file tos.php

<?php $foo = 'bar'; ?>
<p></php echo $foo; ?></p>


the code to display it:

file_get_contents(tos.php);


but this func only displays the html and doesnt print the contents of anything between php tags.
any ideas?

<?php


$1 = file_get_contents("");
$2 = json_decode($1);
$3 = $2->result;

var_dump($myData1);
 foreach($3 as $key => $item): 
     echo $item->Users->UserObject->UserName; 
endforeach; 

?>

{
  "result": [
    {
      "ID": 1,
     
      "Users": [
        {
          "UserObject": {
            "UserName": "test1"
          },
          "...": 2
        },
        {
          "UserObject": {
            "UserName": "test2"
          },
          "...": 2
        }
      ],
    
      "IsActive": true
    }
  ],
  "error": false
  
}

I get this error Notice: Trying to get property 'UserObject' of non-object in C:\xampp\htdocs\dashboard-master\chart.php on line 10

Notice: Trying to get property 'UserName' of non-object in C:\xampp\htdocs\dashboard-master\chart.php on line 10

What I am trying to do is pull the content of another page which works fine and then do echo statements.  It does display the content of the page but not the echo statements.

outside page

Code: [Select]

lorem ipsum lorem ipsum lorem ipsum lorem ipsum lorem ipsum <?php echo $stateinsert ?> lorem ipsum lorem ipsum lorem ipsum lorem ipsum lorem ipsum <?php echo $cityinsert ?> <?php echo $stateinsert ?> lorem ipsum lorem ipsum lorem ipsum lorem ipsum  <?php echo $countyinsert ?> Lorum Ipsom Lorum Ipsom Lorum Ipsom </p>


Code: [Select]
<?php 
$cityinsert = "Auburn";
$stateinsert = "Alabama";
$countyinsert = "Jefferson";
$table = "auburnAL"; 

?>
<?php
$d = file_get_contents("http://mysite.com/includes/leftcopy.php");
echo ($d);
?>


It displays the lorem ipsum  but won't display the echo statements.

I coded this, it has over 600 lines... Im not sure if I should post all of it so I will.
When using a account that does not exist it gives an "failed to open stream Error".

Code: [Select]
<?php
$user = "S U  O  M I";
$user1 = "Tezz";

if(isset($_GET['user']))
{
if(!empty($_GET['user']))
{
$user = $_GET['user'];
}
}
if(isset($_GET['user1']))
{
if(!empty($_GET['user1']))
{
$user1 = $_GET['user1'];
}
}

//Skill Grabs
$order = array("Overall", 
                        "Attack", 
                        "Defence", 
                        "Strength", 
                        "Hitpoints", 
                        "Ranged", 
                        "Prayer", 
                        "Magic", 
                        "Cooking", 
                        "Woodcutting", 
                        "Fletching", 
                        "Fishing", 
                        "Firemaking", 
                        "Crafting", 
                        "Smithing", 
                        "Mining", 
                        "Herblore", 
                        "Agility", 
                        "Thieving", 
                        "Slayer", 
                        "Farming", 
                        "Runecraft", 
                        "Hunter", 
                        "Construction", 
                        "Summoning",
                        "Dungeoneering"); 

$get = file_get_contents("http://hiscore.runescape.com/index_lite.ws?player=$user");
$get = explode("\n", $get);
$i = 0;

foreach ($order as $key => $value)
{
        $value = strtolower($value);
        $temp = explode(",", $get[$i]);
        $temp = array("rank" => $temp[0], "level" => $temp[1], "exp" => $temp[2]);
        $stats[$value] = $temp;
        $eval = "\$$value = array(\$temp[\"rank\"], \$temp[\"level\"], \$temp[\"exp\"]);";
        eval($eval);
        $i++;
}

//End Skill Grabs

$order1 = array("Overall1", 
                        "Attack1", 
                        "Defence1", 
                        "Strength1", 
                        "Hitpoints1", 
                        "Ranged1", 
                        "Prayer1", 
                        "Magic1", 
                        "Cooking1", 
                        "Woodcutting1", 
                        "Fletching1", 
                        "Fishing1", 
                        "Firemaking1", 
                        "Crafting1", 
                        "Smithing1", 
                        "Mining1", 
                        "Herblore1", 
                        "Agility1", 
                        "Thieving1", 
                        "Slayer1", 
                        "Farming1", 
                        "Runecraft1", 
                        "Hunter1", 
                        "Construction1", 
                        "Summoning1",
                        "Dungeoneering1"); 

$get1 = file_get_contents("http://hiscore.runescape.com/index_lite.ws?player=$user1");
$get1 = explode("\n", $get1);
$i1 = 0;

foreach ($order1 as $key1 => $value1)
{
        $value1 = strtolower($value1);
        $temp1 = explode(",", $get1[$i1]);
        $temp1 = array("rank1" => $temp1[0], "level1" => $temp1[1], "exp1" => $temp1[2]);
        $stats1[$value1] = $temp1;
        $eval1 = "\$$value1 = array(\$temp1[\"rank1\"], \$temp1[\"level1\"], \$temp1[\"exp1\"]);";
        eval($eval1);
        $i1++;
}

//End Skill Grabs
echo "<table border='1' cellpadding='5'>";
echo "<tr>";
echo "<td colspan='4'><b><center>".strtoupper($user)."</center></b></td>";
echo "<td></td>";
echo "<td colspan='4'><b><center>".strtoupper($user1)."</center></b></td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Skills</b></td>";
echo "<td><b>Rank</b></td>";
echo "<td><b>Level</b></td>";
echo "<td><b>XP</b></td>";
echo "<td></td>";
echo "<td><b>Skills</b></td>";
echo "<td><b>Rank</b></td>";
echo "<td><b>Level</b></td>";
echo "<td><b>XP</b></td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Overall</b></td>";
echo "<td>";if($overall[0]<=-1){echo "Not Ranked";}else{echo $overall[0];}
echo "</td>";
echo "<td>".$overall[1]."</td>";
echo "<td>".$overall[2]."</td>";
echo "<td>";
if ($overall[2] == $overall1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($overall[2] <= $overall1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($overall[2] >= $overall1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Overall</b></td>";
echo "<td>";if($overall1[0]<=-1){echo "Not Ranked";}else{echo $overall1[0];}
echo "</td>";
echo "<td>".$overall1[1]."</td>";
echo "<td>".$overall1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Attack</b></td>";
echo "<td>";if($attack[0]<=-1){echo "Not Ranked";}else{echo $attack[0];}
echo "</td>";
echo "<td>".$attack[1]."</td>";
echo "<td>".$attack[2]."</td>";
echo "<td>";
if ($attack[2] == $attack1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($attack[2] <= $attack1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($attack[2] >= $attack1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Attack</b></td>";
echo "<td>";if($attack1[0]<=-1){echo "Not Ranked";}else{echo $attack1[0];}
echo "</td>";
echo "<td>".$attack1[1]."</td>";
echo "<td>".$attack1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Defence</b></td>";
echo "<td>";if($defence[0]<=-1){echo "Not Ranked";}else{echo $defence[0];}
echo "</td>";
echo "<td>".$defence[1]."</td>";
echo "<td>".$defence[2]."</td>";
echo "<td>";
if ($defence[2] == $defence1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($defence[2] <= $defence1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($defence[2] >= $defence1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Defence</b></td>";
echo "<td>";if($defence1[0]<=-1){echo "Not Ranked";}else{echo $defence1[0];}
echo "</td>";
echo "<td>".$defence1[1]."</td>";
echo "<td>".$defence1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Strength</b></td>";
echo "<td>";if($strength[0]<=-1){echo "Not Ranked";}else{echo $strength[0];}
echo "</td>";
echo "<td>".$strength[1]."</td>";
echo "<td>".$strength[2]."</td>";
echo "<td>";
if ($strength[2] == $strength1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($strength[2] <= $strength1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($strength[2] >= $strength1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Strength</b></td>";
echo "<td>";if($strength1[0]<=-1){echo "Not Ranked";}else{echo $strength1[0];}
echo "</td>";
echo "<td>".$strength1[1]."</td>";
echo "<td>".$strength1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Constitution</b></td>";
echo "<td>";if($hitpoints[0]<=-1){echo "Not Ranked";}else{echo $hitpoints[0];}
echo "</td>";
echo "<td>".$hitpoints[1]."</td>";
echo "<td>".$hitpoints[2]."</td>";
echo "<td>";
if ($hitpoints[2] == $hitpoints1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($hitpoints[2] <= $hitpoints1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($hitpoints[2] >= $hitpoints1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Constitution</b></td>";
echo "<td>";if($hitpoints1[0]<=-1){echo "Not Ranked";}else{echo $hitpoints1[0];}
echo "</td>";
echo "<td>".$hitpoints1[1]."</td>";
echo "<td>".$hitpoints1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Ranged</b></td>";
echo "<td>";if($ranged[0]<=-1){echo "Not Ranked";}else{echo $ranged[0];}
echo "</td>";
echo "<td>".$ranged[1]."</td>";
echo "<td>".$ranged[2]."</td>";
echo "<td>";
if ($ranged[2] == $ranged1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($ranged[2] <= $ranged1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($ranged[2] >= $ranged1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Ranged</b></td>";
echo "<td>";if($ranged1[0]<=-1){echo "Not Ranked";}else{echo $ranged1[0];}
echo "</td>";
echo "<td>".$ranged1[1]."</td>";
echo "<td>".$ranged1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Prayer</b></td>";
echo "<td>";if($prayer[0]<=-1){echo "Not Ranked";}else{echo $prayer[0];}
echo "</td>";
echo "<td>".$prayer[1]."</td>";
echo "<td>".$prayer[2]."</td>";
echo "<td>";
if ($prayer[2] == $prayer1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($prayer[2] <= $prayer1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($prayer[2] >= $prayer1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Prayer</b></td>";
echo "<td>";if($prayer1[0]<=-1){echo "Not Ranked";}else{echo $prayer1[0];}
echo "</td>";
echo "<td>".$prayer1[1]."</td>";
echo "<td>".$prayer1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Magic</b></td>";
echo "<td>";if($magic[0]<=-1){echo "Not Ranked";}else{echo $magic[0];}
echo "</td>";
echo "<td>".$magic[1]."</td>";
echo "<td>".$magic[2]."</td>";
echo "<td>";
if ($magic[2] == $magic1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($magic[2] <= $magic1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($magic[2] >= $magic1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Magic</b></td>";
echo "<td>";if($magic1[0]<=-1){echo "Not Ranked";}else{echo $magic1[0];}
echo "</td>";
echo "<td>".$magic1[1]."</td>";
echo "<td>".$magic1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Cooking</b></td>";
echo "<td>";if($cooking[0]<=-1){echo "Not Ranked";}else{echo $cooking[0];}
echo "</td>";
echo "<td>".$cooking[1]."</td>";
echo "<td>".$cooking[2]."</td>";
echo "<td>";
if ($cooking[2] == $cooking1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($cooking[2] <= $cooking1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($cooking[2] >= $cooking1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Cooking</b></td>";
echo "<td>";if($cooking1[0]<=-1){echo "Not Ranked";}else{echo $cooking1[0];}
echo "</td>";
echo "<td>".$cooking1[1]."</td>";
echo "<td>".$cooking1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Woodcutting</b></td>";
echo "<td>";if($woodcutting[0]<=-1){echo "Not Ranked";}else{echo $woodcutting[0];}
echo "</td>";
echo "<td>".$woodcutting[1]."</td>";
echo "<td>".$woodcutting[2]."</td>";
echo "<td>";
if ($woodcutting[2] == $woodcutting1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($woodcutting[2] <= $woodcutting1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($woodcutting[2] >= $woodcutting1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Woodcutting</b></td>";
echo "<td>";if($woodcutting1[0]<=-1){echo "Not Ranked";}else{echo $woodcutting1[0];}
echo "</td>";
echo "<td>".$woodcutting1[1]."</td>";
echo "<td>".$woodcutting1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Fletching</b></td>";
echo "<td>".$fletching[0]."</td>";
echo "<td>".$fletching[1]."</td>";
echo "<td>".$fletching[2]."</td>";
echo "<td>";
if ($fletching[2] == $fletching1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($fletching[2] <= $fletching1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($fletching[2] >= $fletching1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Fletching</b></td>";
echo "<td>";if($fletching1[0]<=-1){echo "Not Ranked";}else{echo $fletching1[0];}
echo "</td>";
echo "<td>".$fletching1[1]."</td>";
echo "<td>".$fletching1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Fishing</b></td>";
echo "<td>";if($fishing[0]<=-1){echo "Not Ranked";}else{echo $fishing[0];}
echo "</td>";
echo "<td>".$fishing[1]."</td>";
echo "<td>".$fishing[2]."</td>";
echo "<td>";
if ($fishing[2] == $fishing1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($fishing[2] <= $fishing1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($fishing[2] >= $fishing1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Fishing</b></td>";
echo "<td>";if($fishing1[0]<=-1){echo "Not Ranked";}else{echo $fishing1[0];}
echo "</td>";
echo "<td>".$fishing1[1]."</td>";
echo "<td>".$fishing1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Firemaking</b></td>";
echo "<td>";if($firemaking[0]<=-1){echo "Not Ranked";}else{echo $firemaking[0];}
echo "</td>";
echo "<td>".$firemaking[1]."</td>";
echo "<td>".$firemaking[2]."</td>";
echo "<td>";
if ($firemaking[2] == $firemaking1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($firemaking[2] <= $firemaking1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($firemaking[2] >= $firemaking1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Firemaking</b></td>";
echo "<td>";if($firemaking1[0]<=-1){echo "Not Ranked";}else{echo $firemaking1[0];}
echo "</td>";
echo "<td>".$firemaking1[1]."</td>";
echo "<td>".$firemaking1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Crafting</b></td>";
echo "<td>";if($crafting[0]<=-1){echo "Not Ranked";}else{echo $crafting[0];}
echo "</td>";
echo "<td>".$crafting[1]."</td>";
echo "<td>".$crafting[2]."</td>";
echo "<td>";
if ($crafting[2] == $crafting1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($crafting[2] <= $crafting1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($crafting[2] >= $crafting1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Crafting</b></td>";
echo "<td>";if($crafting1[0]<=-1){echo "Not Ranked";}else{echo $crafting1[0];}
echo "</td>";;
echo "<td>".$crafting1[1]."</td>";
echo "<td>".$crafting1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Smithing</b></td>";
echo "<td>";if($smithing[0]<=-1){echo "Not Ranked";}else{echo $smithing[0];}
echo "</td>";
echo "<td>".$smithing[1]."</td>";
echo "<td>".$smithing[2]."</td>";
echo "<td>";
if ($smithing[2] == $smithing1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($smithing[2] <= $smithing1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($smithing[2] >= $smithing1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Smithing</b></td>";
echo "<td>";if($smithing1[0]<=-1){echo "Not Ranked";}else{echo $smithing1[0];}
echo "</td>";
echo "<td>".$smithing1[1]."</td>";
echo "<td>".$smithing1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Mining</b></td>";
echo "<td>";if($mining[0]<=-1){echo "Not Ranked";}else{echo $mining[0];}
echo "</td>";
echo "<td>".$mining[1]."</td>";
echo "<td>".$mining[2]."</td>";
echo "<td>";
if ($mining[2] == $mining1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($mining[2] <= $mining1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($mining[2] >= $mining1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Mining</b></td>";
echo "<td>";if($mining1[0]<=-1){echo "Not Ranked";}else{echo $mining1[0];}
echo "</td>";
echo "<td>".$mining1[1]."</td>";
echo "<td>".$mining1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Herblore</b></td>";
echo "<td>";if($herblore[0]<=-1){echo "Not Ranked";}else{echo $herblore[0];}
echo "</td>";
echo "<td>".$herblore[1]."</td>";
echo "<td>".$herblore[2]."</td>";
echo "<td>";
if ($herblore[2] == $herblore1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($herblore[2] <= $herblore1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($herblore[2] >= $herblore1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Herblore</b></td>";
echo "<td>";if($herblore1[0]<=-1){echo "Not Ranked";}else{echo $herblore1[0];}
echo "</td>";
echo "<td>".$herblore1[1]."</td>";
echo "<td>".$herblore1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Agility</b></td>";
echo "<td>";if($agility[0]<=-1){echo "Not Ranked";}else{echo $agility[0];}
echo "</td>";
echo "<td>".$agility[1]."</td>";
echo "<td>".$agility[2]."</td>";
echo "<td>";
if ($agility[2] == $agility1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($agility[2] <= $agility1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($agility[2] >= $agility1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Agility</b></td>";
echo "<td>";if($agility1[0]<=-1){echo "Not Ranked";}else{echo $agility1[0];}
echo "</td>";
echo "<td>".$agility1[1]."</td>";
echo "<td>".$agility1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Thieving</b></td>";
echo "<td>";if($thieving[0]<=-1){echo "Not Ranked";}else{echo $thieving[0];}
echo "</td>";
echo "<td>".$thieving[1]."</td>";
echo "<td>".$thieving[2]."</td>";
echo "<td>";
if ($thieving[2] == $thieving1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($thieving[2] <= $thieving1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($thieving[2] >= $thieving1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Thieving</b></td>";
echo "<td>";if($thieving1[0]<=-1){echo "Not Ranked";}else{echo $thieving[0];}
echo "</td>";
echo "<td>".$thieving1[1]."</td>";
echo "<td>".$thieving1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Slayer</b></td>";
echo "<td>";if($slayer[0]<=-1){echo "Not Ranked";}else{echo $slayer[0];}
echo "</td>";
echo "<td>".$slayer[1]."</td>";
echo "<td>".$slayer[2]."</td>";
echo "<td>";
if ($slayer[2] == $slayer1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($slayer[2] <= $slayer1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($slayer[2] >= $slayer1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Slayer</b></td>";
echo "<td>";if($slayer1[0]<=-1){echo "Not Ranked";}else{echo $slayer1[0];}
echo "</td>";
echo "<td>".$slayer1[1]."</td>";
echo "<td>".$slayer1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Farming</b></td>";
echo "<td>";if($farming[0]<=-1){echo "Not Ranked";}else{echo $farming[0];}
echo "</td>";
echo "<td>".$farming[1]."</td>";
echo "<td>".$farming[2]."</td>";
echo "<td>";
if ($farming[2] == $farming1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($farming[2] <= $farming1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($farming[2] >= $farming1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Farming</b></td>";
echo "<td>";if($farming1[0]<=-1){echo "Not Ranked";}else{echo $farming[0];}
echo "</td>";
echo "<td>".$farming1[1]."</td>";
echo "<td>".$farming1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Runecrafting</b></td>";
echo "<td>";if($runecraft[0]<=-1){echo "Not Ranked";}else{echo $runecraft[0];}
echo "</td>";
echo "<td>".$runecraft[1]."</td>";
echo "<td>".$runecraft[2]."</td>";
echo "<td>";
if ($runecraft[2] == $runecraft1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($runecraft[2] <= $runecraft1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($runecraft[2] >= $runecraft1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Runecrafting</b></td>";
echo "<td>";if($runecraft1[0]<=-1){echo "Not Ranked";}else{echo $runecraft1[0];}
echo "</td>";
echo "<td>".$runecraft1[1]."</td>";
echo "<td>".$runecraft1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Hunter</b></td>";
echo "<td>";if($hunter[0]<=-1){echo "Not Ranked";}else{echo $hunter[0];}
echo "</td>";
echo "<td>".$hunter[1]."</td>";
echo "<td>".$hunter[2]."</td>";
echo "<td>";
if ($hunter[2] == $hunter1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($hunter[2] <= $hunter1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($hunter[2] >= $hunter1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Hunter</b></td>";
echo "<td>";if($hunter1[0]<=-1){echo "Not Ranked";}else{echo $hunter1[0];}
echo "</td>";
echo "<td>".$hunter1[1]."</td>";
echo "<td>".$hunter1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Construction</b></td>";
echo "<td>";if($construction[0]<=-1){echo "Not Ranked";}else{echo $construction[0];}
echo "</td>";
echo "<td>".$construction[1]."</td>";
echo "<td>".$construction[2]."</td>";
echo "<td>";
if ($construction[2] == $construction1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($construction[2] <= $construction1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($construction[2] .= $construction1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Construction</b></td>";
echo "<td>";if($construction1[0]<=-1){echo "Not Ranked";}else{echo $construction1[0];}
echo "</td>";
echo "<td>".$construction1[1]."</td>";
echo "<td>".$construction1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Summoning</b></td>";
echo "<td>";if($summoning[0]<=-1){echo "Not Ranked";}else{echo $summoning[0];}
echo "</td>";
echo "<td>".$summoning[1]."</td>";
echo "<td>".$summoning[2]."</td>";
echo "<td>";
if ($summoning[2] == $summoning1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($summoning[2] <= $summoning1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($summoning[2] >= $summoning1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Summoning</b></td>";
echo "<td>";if($summoning1[0]<=-1){echo "Not Ranked";}else{echo $summoning[0];}
echo "</td>";
echo "<td>".$summoning1[1]."</td>";
echo "<td>".$summoning1[2]."</td>";
echo "</tr>";

echo "<tr>";
echo "<td><b>Dungeoneering</b></td>";
echo "<td>";if($dungeoneering[0]<=-1){echo "Not Ranked";}else{echo $dungeoneering[0];}
echo "</td>";
echo "<td>".$dungeoneering[1]."</td>";
echo "<td>".$dungeoneering[2]."</td>";
echo "<td>";
if ($dungeoneering[2] == $dungeoneering1[2]){
echo "<img src='images/equal.png' />";
}
elseif ($dungeoneering[2] <= $dungeoneering1[2]){
echo "<img src='images/downArrow.png' />";
}
elseif ($dungeoneering[2] >= $dungeoneering1[2]){
echo "<img src='images/upArrow.png' />";
}
echo "</td>";
echo "<td><b>Dungeoneering</b></td>";
echo "<td>";if($dungeoneering1[0]<=-1){echo "Not Ranked";}else{echo $dungeoneering1[0];}
echo "</td>";
echo "<td>".$dungeoneering1[1]."</td>";
echo "<td>".$dungeoneering1[2]."</td>";
echo "</tr>";
echo "</table>";

?>
How would I go about fixing this error?