ЛИНК

[formy]

Здравейте!!!!

<?php
//$select = $_POST["base"];
//$text = $_POST["mes"];
//echo $select;
//echo $text;
$host="localhost";
$user="root";
$password="";
$db="bgsites";

$connect=mysql_connect("localhost","root","");
if (!$connect) { echo("ERROR: " . mysql_error() . "\n"); }

mysql_select_db($db) or die ("no select DB");
$query="SELECT url FROM urls";

if (!$query) {echo("ERROR:". mysql_error()."\n");}
$result=mysql_query($query);


echo "<table border=2 width=200 height=80 >";
echo "<tr><td><b>Domain<a href=domainfor.php></td>";

$count = 0;

while ($row = mysql_fetch_array($result))

{
echo "<tr><td >".++$count."." .$row["url"]."</td>";
}
echo "</table>";
mysql_close( );

?>



Въпроса ми е следният как да сложа линк към резултата. Т.е искам всеки резултат да е препратка към цялата информация която имам в базата? Малко е объркано , ама :shock: И да добавя че съм сложила тоя a href евентуално за да мога да ви покажа какво искам.

 

[jooorooo]

<?php 
//$select = $_POST["base"]; 
//$text = $_POST["mes"]; 
//echo $select; 
//echo $text; 
$host="localhost"; 
$user="root"; 
$password=""; 
$db="bgsites"; 

$connect=mysql_connect("localhost","root",""); 
if (!$connect) { echo("ERROR: " . mysql_error() . "\n"); } 

mysql_select_db($db) or die ("no select DB"); 
$query="SELECT url FROM urls"; 

if (!$query) {echo("ERROR:". mysql_error()."\n");} 
$result=mysql_query($query); 


echo "<table border=2 width=200 height=80 >"; 
echo "<tr><td><b>Domain<a href=domainfor.php></td>"; 

$count = 0; 

while ($row = mysql_fetch_array($result)) 

{ 
echo "<tr><td >".++$count.".<a href=\"" .$row["url"]."\">" .$row["url"]."</a></td>"; 
} 
echo "</table>"; 
mysql_close( ); 

?>

 

[formy]

Ще те помоля за оше малко помощ , трябва да го вържа със скрипт


<?php
$select = $_POST["base"];
$text = $_POST["mes"];
//echo $select;
//echo $text;
$host="localhost";
$user="root";
$password="";
$db="bgsites";

$connect=mysql_connect("localhost","root","");
if (!$connect) { echo("ERROR: " . mysql_error() . "\n"); }

mysql_select_db($db) or die ("no select DB");
$query="SELECT url,text,contactFROM urls";
//echo $query;
//exit;
if (!$query) {echo("ERROR:". mysql_error()."\n");}
$result=mysql_query($query);
echo "<table border=2 width=800 height=50>";
echo "<tr><td><b>DOMAIN</td><td><b>INFORMATION</td><td><b>Contact</td>";
$count = 0;

while ($row = mysql_fetch_array($result))

{
echo "<tr><td >".++$count."." .$row["url"]."</td><td>".$row["text"]."</td><td>".$row["contact"]."</td></tr>";
}
echo "</table>";
mysql_close( );

?>


Ще ми кажеш ли това как да го променя,и да го вържа с горният.

 

[jooorooo]

Тогава ще стане така. ако имаш id в базата.

<?php 
//$select = $_POST["base"]; 
//$text = $_POST["mes"]; 
//echo $select; 
//echo $text; 
$host="localhost"; 
$user="root"; 
$password=""; 
$db="bgsites"; 

$connect=mysql_connect("localhost","root",""); 
if (!$connect) { echo("ERROR: " . mysql_error() . "\n"); } 

mysql_select_db($db) or die ("no select DB"); 
$query="SELECT url FROM urls"; 

if (!$query) {echo("ERROR:". mysql_error()."\n");} 
$result=mysql_query($query); 


echo "<table border=2 width=200 height=80 >"; 
echo "<tr><td><b>Domain<a href=domainfor.php></td>"; 

$count = 0; 

while ($row = mysql_fetch_array($result)) 

{ 
echo "<tr><td >".++$count.".<a href=\"info.php?id=" .$row["url"]."\">" .$row["url"]."</a></td>"; 
} 
echo "</table>"; 
mysql_close( ); 

?>

и този съм го кръстил info.php ако искаш да е с друго име в горния код намери където пише info.php и го смени с друго.

ето го info.php

<?php 
$select = $_POST["base"]; 
$text = $_POST["mes"]; 
//echo $select; 
//echo $text; 
$host="localhost"; 
$user="root"; 
$password=""; 
$db="bgsites"; 
id=$_GET['id'];

$connect=mysql_connect("localhost","root",""); 
if (!$connect) { echo("ERROR: " . mysql_error() . "\n"); } 

mysql_select_db($db) or die ("no select DB"); 
$query="SELECT url,text,contact FROM urls WHERE id='$id'"; 
//echo $query; 
//exit; 
if (!$query) {echo("ERROR:". mysql_error()."\n");} 
$result=mysql_query($query); 
echo "<table border=2 width=800 height=50>"; 
echo "<tr><td><b>DOMAIN</td><td><b>INFORMATION</td><td><b>Contact</td>"; 
$count = 0; 

while ($row = mysql_fetch_array($result)) 

{ 
echo "<tr><td >".++$count."." .$row["url"]."</td><td>".$row["text"]."</td><td>".$row["contact"]."</td></tr>"; 
} 
echo "</table>"; 
mysql_close( ); 

?>