Hey there,

I was wondering if any of you knows how to parse a text file similar to this:

quote:

---

"Advertisements"
{
    "1"
    {
        "type"        "S"
        "text"        "Ad1"
    }
    "2"
    {
        "type"        "S"
        "text"        "Ad2"
    }
    "3"
    {
        "type"        "S"
        "text"        "Ad3"
    }
}

---

quote:

---

1) Ad1
2) Ad2
3) Ad3

---

Use regexp and read up on your preg_match_all

Should be simple enough to do

This would be so much easier if the system making the text file used json_encode, and decrypted it with json_decode

json_encoded arrays look very similar to the text you want parsed, if you cannot change the initial text file and how it's generated....follow JAndertons advice

Thanks, and yeah, I cannot change the original text file as its read by something else, that can only read in that format. Anway, I managed to come up with this:

php code:

---

<?php
$text = file_get_contents('advertisements.txt');
preg_match_all('~"text"\s+"([^"]*)~', $text, $matches);
$arr = str_replace('\n', "<br>", $matches[1]);
echo ("<li>");
echo implode("<br /><li>\n", $arr);
?>

---

if you want you can just do it like this:

code:

---

<?php

$c = file_get_contents('./ads.txt');
preg_match_all('/\s*"text"\s*"([^"]*)"/',$c,$m);
echo "<ol>";
for($i=0;$i<count($m[1]);$i++){
    echo "<li>".$m[1][$i]."</li>";
}
echo "</ol>";

?>

---

Thanks NanaFreak

Do you know how I would go about changing the colour/font of each Ad, so for example, make Ad1 blue, Ad2, white, Ad3, black?

you are either able to hard code that information, but if you want to make it dynamic, you can add another element to the text document...

method 1:

code:

---

<?php

$a = array('blue','white','black');

$c = file_get_contents('./ads.txt');
preg_match_all('/\s*"text"\s*"([^"]*)"/',$c,$m);
echo "<ol>";
for($i=0;$i<count($m[1]);$i++){
    echo "<li><span style='color:".$a[$i]."'>".$m[1][$i]."</span></li>";
}
echo "</ol>";

?>

---

code:

---

"Advertisements"
{
    "1"
    {
        "type"        "S"
        "text"        "Ad1"
        "color"       "blue"
    }
    "2"
    {
        "type"        "S"
        "text"        "Ad2"
        "color"       "white"
    }
    "3"
    {
        "type"        "S"
        "text"        "Ad3"
        "color"       "black"
    }
}

---

code:

---

<?php

$c = file_get_contents('./ads.txt');
preg_match_all('/\s*"text"\s*"([^"]*)"/',$c,$m);
preg_match_all('/\s*"color"\s*"([^"]*)"/',$c,$a);
echo "<ol>";
for($i=0;$i<count($m[1]);$i++){
    echo "<li><span style='color:".$a[1][$i]."'>".$m[1][$i]."</span></li>";
}
echo "</ol>";

?>

---

Thanks again nanafreak

As you seem to be a php genius, I have something else you may be able to solve.

I am trying to query a database using the following code (censored):

php code:

---

<?php echo '<table class="sortable2" id="reports" name="reports">
<tr>
<th><font face="Arial, Helvetica, sans-serif" size="3">SteamID</font></th>
<th><font face="Arial, Helvetica, sans-serif" size="3">Server Date/Time</font></th>
<th><font face="Arial, Helvetica, sans-serif" size="3">Server name</font></th>
<th><font face="Arial, Helvetica, sans-serif" size="3">Player name</font></th>
<th><font face="Arial, Helvetica, sans-serif" size="3">Reason</font></th>
<th><font face="Arial, Helvetica, sans-serif" size="3">Reporter</font></th>
</tr>';
?>

<?
mysql_connect("***","***","****");
   
mysql_select_db("servers");

$search=$_POST["search"];

$result = mysql_query("SELECT * FROM reports4 WHERE playername LIKE '%$search%'");

while($r=mysql_fetch_array($result))
{   
   $steam=$r["steamid"];
   $dt=$r["datetime"];
   $pn=$r["playername"];
   $rs=$r["reason"];
   $rp=$r["reporter"];
   $sn=$r["servername"];
   
  echo "<tr><td> $steam </td><br> <td>$dt </td><td>$sn</td><td>$pn</td><td>$rs</td><td>$rp</td></tr>";
}

?>
</table>

---

would you be able to post all of the code for the search.php page, as the stuff you have posted doesnt seem to be enough and some parts are missing...

right now, i am thinking that it might be some sort of errors that arent getting displayed correctly, but i dont know right now...

html code:

---

</td><br> <td>

---

@Nana, what I posted above is the whole search.php.
I use

html code:

---

<form method="post" action="search.php">
<input type="text" value="Enter Player Name" name="search" size=25 maxlength=25>
<input type="Submit" name="Search" value="Search">
</form>

---

quote:

---

Originally posted by Jimbo
@Nana, what I posted above is the whole search.php.

---

html code:

---

<div id="header">
<a href="http://sammyservers.com/reports/?sort=33">Return to Reports table</a>
</div>

---

quote:

---

Originally posted by WDZ

html code:

---

</td><br> <td>

---

What's that <br> doing in there, outside of a table cell?

---

quote:

---

Originally posted by NanaFreak

quote:

---

Originally posted by Jimbo
@Nana, what I posted above is the whole search.php.

---

it isnt because nowhere on that page is there this html:

html code:

---

<div id="header">
<a href="http://sammyservers.com/reports/?sort=33">Return to Reports table</a>
</div>

---

---

btw, i just tested it again and it worked fine... =\

Also, read about sql injection.