How to create link on the text retrieve from the database..!

  • asad_black
  • Graduate
  • Graduate
  • asad_black
  • Posts: 131
  • Loc: pakistan

Post 3+ Months Ago

hi,

i am a newbie in PHP...!
i want to retrieve record from the database and create link on the text of the records...!
and i also save the link on the database...!

this is my search code:

<?php

// Get the search variable from URL

$var = @$_GET['q'] ;
$trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10;

if ($trimmed == "")
{
echo "<p>Please enter a search...</p>";
exit;
}

// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}


mysql_connect("localhost","sample","123");

mysql_select_db("sample") or die("Unable to select database"); //select which database we're using


$query = "select * from image_table where fname like \"%$trimmed%\"
order by id";

$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);


if ($numrows == 0)
{
echo "<h4>Results</h4>";
echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
echo "<p><a href=\"http://www.google.com/search?q="
. $trimmed . "\" target=\"_blank\" title=\"Look up
" . $trimmed . " on Google\">Click here</a> to try the
search on google</p>";
}

// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}

// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot;</p>";


//my table addition
echo "<table border='1'>
<tr>
<th>LAST NAME</th>
<TR>";







// begin to show results set
//echo "Results";
$count = 1 + $s ;




while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['fname'] . "</td>";
$count++ ;
}

// now you can display the results returned
/* while ($row= mysql_fetch_array($result)) {
$title = $row["lname"];

echo "$count.)&nbsp;$title" ;
$count++ ;
}*/

$currPage = (($s/$limit) + 1);

//break before paging
echo "<br />";

// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
Prev 10</a>&nbsp&nbsp;";
}

// calculate number of pages needing links
$pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}

// check to see if last page
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

// not last page so give NEXT link
$news=$s+$limit;

echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
}

$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo "<p>Showing results $b to $a of $numrows</p>";

?>


now i want to create link on the records of first name..!

for example :
output is
ASAD
ALI
KHAN

when user click on the ASAD go to yahoo.com
when user click on the ALI go to hotmail.com
when user click on the KHAN go to ozzu.com


but remember all the above link will be save in the table of the database.


Regards,
Asad Mairaj
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Birmingham
  • Beginner
  • Beginner
  • User avatar
  • Posts: 47
  • Loc: Birmingham, UK

Post 3+ Months Ago

very complicated code you have there. if you're just a newbie, better work on making it simpler. first job is to turn the selected mysql rows into php arrays. then it's easy from there.

what does your databse look like? can you give me an example of your "sample"?
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8388
  • Loc: USA

Post 3+ Months Ago

Assuming that the names is the variable $row['fname'] and the URL to the site to go is $row['fsite'] you can simply do
PHP Code: [ Select ]
while($row = mysql_fetch_array($result))
{
   echo "<tr>";
   echo "<td><a href=\"{$row['fsite']}\">{$row['fname']}</a></td>";
   $count++;
}
  1. while($row = mysql_fetch_array($result))
  2. {
  3.    echo "<tr>";
  4.    echo "<td><a href=\"{$row['fsite']}\">{$row['fname']}</a></td>";
  5.    $count++;
  6. }

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 130 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.