How to make url and email fields from a database clickable..

Sergeant Joined: Dec 15, 2003 Posts: 77

Hi,

I've made a simple page in wich a title, url, name and e-mail can be sumbitted with a form. The values are stored in a database.

I've managed to convert a found e-mail address into a clickable link.
The problem is, this address is placed on top of the table, and I want it in the e-mail column.

can anyone help me with this?

This is the code that needs to be altered

Code:

<?php session_start(); ?>
<?php /* no security */ ?>
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php include ("db.php") ?>
<?php include ("function.php") ?>
<?php
$displayRecs = 20;
$recRange = 10;

// Get table name
$tablename = "`titles`";
$dbwhere = "";
$a_search = "";
$b_search = "";
?>

<?php
// Get search criteria for basic search
$pSearch = @$HTTP_GET_VARS["psearch"];
if ($pSearch != "")
{
$pSearch = (!get_magic_quotes_gpc()) ? addslashes($pSearch) : $pSearch;
$b_search .= "`title` LIKE '%".$pSearch."%' OR ";
$b_search .= "`url` LIKE '%".$pSearch."%' OR ";
$b_search .= "`name_author` LIKE '%".$pSearch."%' OR ";
$b_search .= "`e-mail` LIKE '%".$pSearch."%' OR ";
}
if (strlen($b_search) > 4)
{
$b_search = substr($b_search, 0, strlen($b_search)-4);
$b_search = "(".$b_search.")";
}
?>
<?php
//Build search criteria
if ($a_search != "")
{
$dbwhere .= $a_search; //advance search
} elseif ($b_search!="") {
$dbwhere .= $b_search; //basic search
}

//Save search criteria
if ($dbwhere != "")
{
 $HTTP_SESSION_VARS["tablename"] = $tablename;
$HTTP_SESSION_VARS["dbwhere"] = $dbwhere;
//reset start record counter
$startRec = 1;
$HTTP_SESSION_VARS["titles_REC"] = $startRec;
} else {
if ($tablename == @$HTTP_SESSION_VARS["tablename"])
{
 $dbwhere = $HTTP_SESSION_VARS["dbwhere"];
} else {
 //reset search criteria
$dbwhere = "";
$HTTP_SESSION_VARS["dbwhere"] = $dbwhere;
}
}

//Get clear search cmd
$cmd = @$HTTP_GET_VARS["cmd"];
if (strtoupper($cmd)=="RESET")
{
//reset search criteria
$dbwhere = "";
$HTTP_SESSION_VARS["dbwhere"] = $dbwhere;
}
?>
<?php
// Load Default Order
$DefaultOrder = "";
$DefaultOrderType = "";

// Check for an Order parameter
$OrderBy = @$HTTP_GET_VARS["order"];

if ($OrderBy != "")
{
// Check if an ASC/DESC toggle is required
if ($HTTP_SESSION_VARS["titles_OB"] == $OrderBy)
{
 if ($HTTP_SESSION_VARS["titles_OT"] == "ASC")
 {
 $HTTP_SESSION_VARS["titles_OT"] = "DESC";
 } else {
 $HTTP_SESSION_VARS["titles_OT"] = "ASC";
 }
} else {
 $HTTP_SESSION_VARS["titles_OT"] = "ASC";
}
$HTTP_SESSION_VARS["titles_OB"] = $OrderBy;
$HTTP_SESSION_VARS["titles_REC"] = 1;
} else {
$OrderBy = @$HTTP_SESSION_VARS["titles_OB"];
if ($OrderBy == "")
{
 $OrderBy = $DefaultOrder;
 $HTTP_SESSION_VARS["titles_OB"] = $OrderBy;
 $HTTP_SESSION_VARS["titles_OT"] = $DefaultOrderType;
}
}

// Check for a START parameter
$startRec = @$HTTP_GET_VARS["start"];

if ($startRec != "")
{
$HTTP_SESSION_VARS["titles_REC"] = $startRec;
} else {
$startRec = @$HTTP_SESSION_VARS["titles_REC"];
if ($startRec == "")
{
 //reset start record counter
 $startRec = 1;
 $HTTP_SESSION_VARS["titles_REC"] = $startRec;
}
}

//Set the last record to display
$stopRec = $startRec + $displayRecs - 1;

// Open Connection to the database
$conn = mysql_connect(HOST, USER, PASS);
mysql_select_db(DB);

// Build Query
$strsql = "SELECT * FROM `titles`";

if ($dbwhere != "")
{
$strsql .= " WHERE ".$dbwhere;
}

if ($OrderBy != "")
{
$strsql .= " ORDER BY `".$OrderBy."` ".@$HTTP_SESSION_VARS["titles_OT"];
}

$rs = mysql_query($strsql, $conn) or die(mysql_error());

$totalRecs = mysql_num_rows($rs);
?>
<?php include ("header.php") ?>
TABLE: titles

<form action="titleslist.php">
<table border="0" cellspacing="1" cellpadding="4">
<tr>
 <td>Quick Search (*)</td>
 <td>
 <input type="Text" name="psearch" size=10>
 <input type="Submit" name="Submit" value="GO!">
 </td>
 <td><a href="titleslist.php?cmd=reset">Show All</a></td>
</tr>
</table>
</form>

<table border="0" cellspacing="0" cellpadding="0">
<tr>
 <td height="0" align="left"><a href="titlesadd.php">Submit a title-Rip link</a></td>
</tr>
</table>


<form>
<table width="90%" border="1" cellpadding="5" cellspacing="1" bordercolor="#000000" bgcolor="#CCCCCC">
<tr background="../themes/fisubsilversh/forums/images/cellpic1.gif">
<td> <a href="titleslist.php?order=<?php echo urlencode("title"); ?>">Movie
title  (*)</a> </td>
<td> <a href="titleslist.php?order=<?php echo urlencode("url"); ?>">Download
url (*)</a> </td>
<td> <a href="titleslist.php?order=<?php echo urlencode("name_author"); ?>">Name
author (*)</a> </td>
<td> <a href="titleslist.php?order=<?php echo urlencode("e-mail"); ?>">E
mail (*)</a> </td>
<td> </td>
</tr>
<?php
$recCount = $startRec - 1;
@mysql_data_seek($rs, $recCount);
while (($row = mysql_fetch_assoc($rs)) && ($recCount < $stopRec))
{
$recCount++;
if (intval($recCount) >= intval($startRec))
{
 //set row color
 $bgcolor="#FFFFFF";
?>
<?php
 // Display alternate color for rows
 if ($recCount % 2 != 0)
 {
 $bgcolor = "#F5F5F5";
 }
?>
<?php
$x_title = $row["title"];
$x_url = $row["url"];
$x_name_author = $row["name_author"];
$x_e2Dmail = $row["e-mail"];
$szEmail = $myrow["league_email"] ;
$x_e2Dmail = preg_replace(Array("/\@/", "/\./"), Array("@", "."), $x_e2Dmail);
print "Email: <a href=\"mailto:".$x_e2Dmail." class=\"data\">".$x_e2Dmail."</a> \n";
?>

<tr bgcolor="#FFFFFF">
<td> <?php echo $x_title ?>  </td>
<td> <?php echo $x_url ?>  </td>
<td> <?php echo $x_name_author ?>  </td>
<td> <?php echo $x_e2Dmail ?></td>
<td><a href="<?php
if ($row["url"] != NULL)
{ echo "titlesview.php?key=".urlencode($row["url"]); }
else
{ echo "javascript:alert('Invalid Record! Key is null.');"; }
?>">View</a></td>
</tr>
<?php
}
}

mysql_free_result($rs);
mysql_close($conn);
?>
</table>
</form>
<?php
if ($totalRecs > 0)
{
// Find out if there should be Backward or Forward Buttons on the table.
if ($startRec == 1)
{
 $isPrev = false;
} else {
 $isPrev = true;
 $PrevStart = $startRec - $displayRecs;
 if ($PrevStart < 1)
 {
 $PrevStart = 1;
 }
?>
<hr size="1" noshade>
<a href="titleslist.php?start=<?php echo $PrevStart; ?>">[<< Prev]</a>
<?php
}

// Display Page numbers
if ($isPrev||(!($totalRecs == 0)))
{
if (!$isPrev)
{
?>
<hr size="1" noshade>
<?php
 }

 $x = 1;
$y = 1;

$dx1 = intval(($startRec - 1)/($displayRecs*$recRange))*$displayRecs*$recRange + 1;
 $dy1 = intval(($startRec - 1)/($displayRecs*$recRange))*$recRange + 1;
if (($dx1 + $displayRecs*$recRange - 1) > $totalRecs)
 {
 $dx2 = intval($totalRecs/$displayRecs)*$displayRecs + 1;
 $dy2 = intval($totalRecs/$displayRecs) + 1;
 } else {
 $dx2 = $dx1 + $displayRecs*$recRange - 1;
 $dy2 = $dy1 + $recRange - 1;
 }

 while ($x <= $totalRecs)
{
 if (($x >= $dx1)&&($x <= $dx2))
{
 if (intval($startRec) == intval($x))
 {
?>
<?php echo $y; ?>
<?php
 } else {
?>
<a href="titleslist.php?start=<?php echo $x; ?>"><?php echo $y; ?></a>
<?php
 }
 $x = $x + $displayRecs;
 $y = $y + 1;
} elseif (($x >= ($dx1 - $displayRecs*$recRange))&&($x <= ($dx2 + $displayRecs*$recRange)))
{

 if ($x + $recRange*$displayRecs < $totalRecs)
 {
?>
 <a href="titleslist.php?start=<?php echo $x; ?>"><?php echo $y; ?>-<?php echo $y + $recRange - 1; ?></a>
<?php
 } else {
 $ny = intval(($totalRecs - 1)/$displayRecs) + 1;
 if ($ny == $y)
 {
?>
 <a href="titleslist.php?start=<?php echo $x; ?>"><?php echo $y; ?></a>
<?php
 } else {
?>
 <a href="titleslist.php?start=<?php echo $x; ?>"><?php echo $y; ?>-<?php echo $ny; ?></a>
<?php
 }
 }
 $x = $x + $recRange*$displayRecs;
 $y = $y + $recRange;
 } else {
 $x = $x + $recRange*$displayRecs;
 $y = $y + $recRange;
 }
 }
}

// Next link
if ($totalRecs >= $startRec + $displayRecs)
{
 $NextStart = $startRec + $displayRecs;
 $isMore = true;
?>
<a href="titleslist.php?start=<?php echo $NextStart; ?>">[Next >>]</a>
<?php
} else {
 $isMore=false;
}
?>
<hr size="1" noshade>
<?php
if ($stopRec > $recCount)
{
$stopRec = $recCount;
}
?>
Records <?php echo $startRec; ?> to <?php echo $stopRec; ?> of <?php echo $totalRecs; ?>
<?php
} else {
?>
 
No records found!
 
<?php
}
?>
<?php include ("footer.php") ?>

Also, I would like an extra field that displays the time and date of an added item.

cheers,

Tjendol

Sergeant Joined: Dec 15, 2003 Posts: 77

Ok, I got the e-mail code working.

Now I want the same thing for urls. Which parts do I have to change?

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Do you have this available on the net to view?

Sergeant Joined: Dec 15, 2003 Posts: 77

I sent you an e-mail with the link.

Sergeant Joined: Dec 15, 2003 Posts: 77

I fixed it! thnx anyway

Posted: Fri Dec 26, 2003 4:11 am

Dear Zhen-Xjell,

Regarding above scripts for gmtime(), I use similar one at the coppermine e-card, which sends very incorrect date(time is correct) to receiver, i.e. 2003-01-12, .... instead of actual date 2003-12-26,....

My PWS server is win2k/apache2/nuke7.0/coppermine1.2.1rc5.
Coppermine said that it should be my server problem.
And I checked my machine date is correct.
What should be wrong, Doctor.

Sergeant Joined: Dec 15, 2003 Posts: 77

I still have a question too. It seems that only filling in "<a href"-works because that's just html.

But i want to covert http:// links into clickable links as well...what code do I need for this and where do I put it?

Sergeant Joined: Dec 15, 2003 Posts: 77

Lol...i want the thing that happens to the http:// text in my post above on my website Smile