PHP/MYSQL Displaying records

[Ydot]

Hey guys,

I am pretty new to php/mysql but have just finished makeing a database of trip reports and a php/html form so users can submit there trip reports directly to the mysql databse.

I have read how to output all this information but what i really need to do is output in a specific way:

I need to only display about 120 characters of the the trip report (as most are over 800 characters) but with a link to a new page where the full trip report can be read.

Is there any way of doing this and also is there anyway php can generate a new page for each record that is submitted? as in if records id 406 is just submitted it has its own page of 406.php?

hope that makes sense and hope you can help!!

[sannbe]

check php.net

Good information and check the forum. There might be someone there with an answer to your question also.

[Ydot]

well ive looked absoloutly everywhere and feel like im now going round in circles.

I have managed to put together some php that displays the last 5 records from my database (excluding the trip report as its very long) but i need to add a link to the data that gets outputted so that when its clicked it takes u to a new page that displays that record u clicked with all its information (trip report included)

been looking at some file.php?id=234 but tried it and no luck - am i on the right track?? for some reason when i go that route just displays the information already displayed?!?!

if anyone can help would be VERY much appreciated!!

[c010depunkk]

Yea, that looks good. If you put the requested id in the link (ex. http://www.yoursite.com/file.php?id=234) then you can read it out like this: $_GET['id'] or $_REQUEST['id']; and use that to read the right trip out of the databank and output it.

Here's an example of how you could do it using PHP and mySQL:

PHP: Select all

<?php
$output="";
if(isset($_GET['id'])) { // output the requested trip report
    $query=mysql_query("SELECT * FROM table_name WHERE id = '".$_GET['id']."'");
    if($row=mysql_fetch_object($query)) {
        $output.="<p>".$row->trip_report."</p>";
    } else {
        $output.="Requested id not found in the databank.";
    }
} else { // read out all the trip reports
    $query=mysql_query("SELECT * FROM table_name");
    while($row=mysql_fetch_object($query)) {
        $output.="<a href=\"?id=".$row->id."</a>";
    }
}
// output the generated content
echo($output);
?>

[Ydot]

Thank you c010depunkk we have a genius in our presence!!

All seems to be working nicely (just gotta get rid of some kinks and tweak a little my end)

Thanks again!

[Ydot]

Ok getting close!!! heres my code:

Code: Select all

<?php
$connection = mysql_connect("localhost", "*******", "******") or die("Error connecting to database");
mysql_select_db("paramou4_tripreports", $connection);
if(isset($_GET['id'])) { // output the requested trip report
    $result=mysql_query("SELECT * FROM details WHERE id = '".$_GET['id']."'");
} else
$result = mysql_query("SELECT * FROM details ORDER BY id DESC LIMIT 0, 3", $connection) or die("error querying database");
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<tr <?php if($i%2 == 1){ echo "class='body2'"; }else{echo "class='body1'";}?>>
      <td><strong>Player Name:</strong> 
        <?php echo $result_ar['playername']; ?>
      </td>
      <br />
      <td> <strong>Player Location: </strong> 
        <?php echo $result_ar['location']; ?>
      </td>
      <br />
<td> <strong>Rooms Visited: </strong>
        <?php echo $result_ar['rooms']; ?><br />
      </td>
      <td> <strong>Summary: </strong>
        <?php echo $result_ar['summary']; ?><br />
        <?php echo "<a href=\"index.php?id=".$result_ar['id']."More</a>"; ?>
 
 
<br />
<br />
      </td>
 
</tr>
<?php
$i+=1;
}
mysql_close();
?>

All working ok except for the link comes up as some crazy "index.php?id=7More</a><br /><br /> </td></tr><tr class='body2'> <td><strong>Player Name:</strong> Joe new </td> <br /> <td> <strong>Player Location: </strong> essex new </td> <br /><td> <strong>Rooms Visited: </strong> MGM Bellagio bellagiosas<br /> </td> <td> <strong>Summary: </strong> <br /> <a href="

and links all the records and rows after the first record?? It seems to not close the <a href> tag? tried playing about with it but seems something very small im overlooking? help would be much appreciated and sorry for being a pain!

[c010depunkk]

You forgot to close the quotation marks and the tag on the link. This should work:

PHP: Select all

<?php
$connection = mysql_connect("localhost", "*******", "******") or die("Error connecting to database");
mysql_select_db("paramou4_tripreports", $connection);
if(isset($_GET['id'])) { // output the requested trip report
    $result=mysql_query("SELECT * FROM details WHERE id = '".$_GET['id']."'");
} else {
$result = mysql_query("SELECT * FROM details ORDER BY id DESC LIMIT 0, 3", $connection) or die("error querying database");
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<tr <?php if($i%2 == 1) { echo "class='body2'"; } else { echo "class='body1'"; } ?>>
      <td><strong>Player Name:</strong> 
        <?php echo $result_ar['playername']; ?>
      </td>
      <br />
      <td> <strong>Player Location: </strong> 
        <?php echo $result_ar['location']; ?>
      </td>
      <br />
<td> <strong>Rooms Visited: </strong>
        <?php echo $result_ar['rooms']; ?><br />
      </td>
      <td> <strong>Summary: </strong>
        <?php echo $result_ar['summary']; ?><br />
        <?php echo "<a href=\"index.php?id=".$result_ar['id']."\">More</a>"; ?>
 
 
<br />
<br />
      </td>
 
</tr>
<?php
$i+=1;
}
mysql_close();
?>