[RESOLVED] Display Graphics instead of Data

[ee12csvt]

Hi All,

I have compiled a dB and appropriate PHP/MYSQL pages on my local server to create a list where I can view contributors to my online site and also view the photographs that they have contributed. It all works, but I am trying to refine it to make it easier for me to browse!

Data that the contributors page shows is

Code - This is a code unique to each contributor
Status - Whether the contributor wants to be advised before use, after use or not advised when their material is used.
Name - The published name on their material
Contact Mail - e-Mail address to use
Link - Link to the contributors website.

<table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="40" class="tblhead">Code</td>
          <td width="40" class="tblhead2">Status</td>
          <td width="200" class="tblhead1">Name</td>
          <td width="190" class="tblhead2">Contact</td>
          <td width="283" class="tblhead1">Link</td>
          <td width="80" class="tblhead2">View Pix</td>
        </tr>
        <?php do { ?>
        <tr>
          <td class="tbl1b"><?php echo $row_view['PGR_INIT']; ?></td>
          <td class="tbl3"><?php echo $row_view['PGR_PERM']; ?></td>
          <td class="tbl2"><?php echo $row_view['PGR_PN']; ?></td>
          <td class="tbl3"><a href="mailto:<?php echo $row_view['PGR_CM']; ?>?subject=Contributions%20to%20English%20Electric%20Growl,%20www.12csv.com"><?php echo $row_view['PGR_CM']; ?></a></td>
          <td class="tbl2"><a href="<?php echo $row_view['PGR_LNK']; ?>" target="_blank"><?php echo $row_view['PGR_LNK']; ?></a></td>
          <td class="tbl4" align="center"><input type="submit" name="PGR_INIT" class="textfld" id="PGR_INIT" value="<?php echo $row_view['PGR_INIT']; ?>"></td>
        </tr>
        <?php } while ($row_view = mysql_fetch_assoc($view)); ?>
      </table>

There are two things I need advice for

I do not need all the Email address to be displayed, perhaps only the first 10 to 15 letters, I have seen this done on many sites, but I have had difficulty finding how it is done!

Not all contributors have their own website, so I want to create a php program that will check if the PGR_LNK is empty or filled with information. If empty I want to display an image of a 'X' in the results, but if filled display an image of a 'Tick' which when clicked will link to the site identified in PGR_LNK

Any advice would be much appreciated

Phil

[bpat1434]

To see if PGR_LNK is empty, you can use the [man]empty/man function.

if(empty($row_view['PGR_LNK']))
{
    // Display the "X" image
}
else
{
    // Display the "tick" image
}

As for the first 10 to 15 letters, you can do something like:

$email = substr($row_view['PGR_CM'], 0, 5) . '...' . strrchr($row_view['PGR_CM'], '@');

Now $email will contain something like "[e-mail]" which is similar to the way google groups hides email addresses.

[ee12csvt]

Thanks for the speedy reply bpat1434

I'll give your suggestions a try.

Phil

[ee12csvt]

OK Dokey,

I have played around with a few things and my code now looks like this

<table width="840" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="50" class="tblhead">Code</td>
          <td width="50" class="tblhead2">STATE</td>
          <td width="260" class="tblhead1">Published Name</td>
          <td width="339" class="tblhead2">Contact</td>
          <td width="40" class="tblhead1">Link</td>
          <td width="80" class="tblhead2">View Pix</td>
        </tr>
        <?php do { ?>
        <tr>
          <td class="tbl1b"><?php echo $row_view['PGR_INIT']; ?></td>
          <td class="tbl3"><?php echo $row_view['PGR_PERM']; ?></td>
          <td class="tbl2"><?php echo $row_view['PGR_PN']; ?></td>
          <td class="tbl3"><a href="mailto:<?php echo $row_view['PGR_CM']; ?>?subject=Contributions%20to%20English%20Electric%20Growl,%20www.12csv.com"><?php echo $row_view['PGR_CM']; ?></a></td>
          <td class="tbl5"><?php if(empty($row_view['PGR_LNK']))
{
    print "<IMG SRC=http://localhost/photos/images/cross.gif alt=No Link Available height=12 width=12>";


}
else
{
    print "<IMG SRC=http://localhost/photos/images/tick.gif alt=Click to visit website height=12 width=12>";

}?></td>
          <td class="tbl4" align="center"><input type="submit" name="PGR_INIT" id="PGR_INIT" value="<?php echo $row_view['PGR_INIT']; ?>" class="pgselect"></td>
        </tr>
        <?php } while ($row_view = mysql_fetch_assoc($view)); ?>
      </table>

It all displays OK, but I cannot get the images to display in the Link box on the table.

I have also attempted to get a link to an external site when the 'Tick' is clicked, but I get errors when I try to do this.

Phil

[bpat1434]

When putting strings with spaces in them as alternate items, you should use quotes around them:

print '<img src="http://localhost/photos/images/tick.gif" alt="Click to visit website" height=12 width=12 target="_blank" />';

The target="_blank" should make it come up in a new window.

What errors are you getting, and do you have a working example for us to see?

[ee12csvt]

I have sorted the image problem, it was a simple mistake on my part!

        <?php do { ?>
        <tr>
          <td class="tbl1b"><?php echo $row_view['PGR_INIT']; ?></td>
          <td class="tbl4"><?php echo $row_view['PGR_PERM']; ?></td>
          <td class="tbl2"><?php echo $row_view['PGR_PN']; ?></td>
          <td class="tbl3"><a href="mailto:<?php echo $row_view['PGR_CM']; ?>?subject=Contributions%20to%20English%20Electric%20Growl,%20www.12csv.com"><?php echo $row_view['PGR_CM']; ?></a></td>
          <td class="tbl5"><?php if(empty($row_view['PGR_LNK']))
{
    print '<IMG SRC="../image/cross.gif" alt="No Link Available" height="12" width="12">';


}
else
{
    print '<a href="?????" target="_blank"><IMG SRC="../image/tick.gif" alt="Click to visit website" height="12" width="12" Border="0"></a>';

}?></td>

I am not sure what I need to put in the link instead of the ?????. The website addresses for the links are held in PGR_LNK.

I have tried the coding I usual use, i.e. <?php echo $row_view['PGR_LNK']; ?> but this returns an error, Parse error: syntax error, unexpected T_STRING in C:\wamp\www\photos\cont\index.php on line 110

line 110 is

print '<a href="?????" target="_blank"><IMG SRC="../image/tick.gif" alt="Click to visit website" height="12" width="12" Border="0"></a>';

The site is only for my local server, so it has not been uploaded to the net.

Phil

[Weedpacket]

 print '<a href="?????" target="_blank"><IMG SRC="../image/tick.gif" alt="Click to visit website" height="12" width="12" Border="0"></a>';

That's because you're already in PHP; trying to enter it again confuses it.

 print '<a href="'.$row_view['PGR_LINK'].'" target="_blank"><IMG SRC="../image/tick.gif" alt="Click to visit website" height="12" width="12" Border="0"></a>';

[ee12csvt]

Many Thanks Weedpacket and bpat1434, it is now working fine.

I am quite new to PHP and appreciate the help, it has been good to see where I went wrong.

Best regards,

Phil