Forum

Cod: Selectaţi tot

<?php
$cuvant=$_GET['q'];

$conn = mysql_connect("localhost", "cautari", "cautari") 
    or die("Unable to connect to MySQL"); 
$selectdb = mysql_select_db('cautari'); 
$interogare = "SELECT * FROM siteuri WHERE cuvinte_cheie LIKE '%$cuvant%'"; 
$rezultat = mysql_query($interogare); 
if (mysql_errno()) { 
    echo "<br />". mysql_errno(). " : ". mysql_error(). "<br />"; 
} 
$nr_campuri = mysql_num_fields($rezultat); 
if (mysql_num_rows($rezultat) == 0) { 
    echo '<br><br>Ne pare rau dar nu am gasit nici un rezultat pentru cautarea <font color="red"><b>'.$cuvant.'</b></font><br><br>'; 
} 
else { 
    while ($rand = mysql_fetch_assoc($rezultat)) {    


echo '<table>
<tr>
<td><br><font size="1pt"><font size="5"><a href="'. $rand['link_site']. '">'. $rand['nume_site']. '</a></font><br><font color="green" size="4">'. $rand['descriere_site']. '</font><br><font color="red" size="4">'. $rand['link_site']. '</font><br><br></font></td><td align="right"><br></td>
</tr><tr>
<td><font size="1pt"></font></td><td align="right"></td>
</tr><tr>
<td align="center" colspan="2">
<br>
</tr>
</table>';
  }
}
?>

Cod: Selectaţi tot

<?php
$cuvant=$_GET['q'];

$conn = mysql_connect("localhost", "cautari", "cautari") 
    or die("Unable to connect to MySQL"); 
$selectdb = mysql_select_db('cautari'); 
$interogare = "SELECT * FROM siteuri WHERE cuvinte_cheie LIKE '%$cuvant%'"; 
$rezultat = mysql_query($interogare); 
if (mysql_errno()) { 
    echo "<br />". mysql_errno(). " : ". mysql_error(). "<br />"; 
} 
$nr_campuri = mysql_num_fields($rezultat); 
$num_rows = mysql_numrows($rezultat);{
    echo '<br><br>Ne pare rau dar nu am gasit nici un rezultat pentru cautarea <font color="red"><b>'.$cuvant.'</b></font><br><br>'; 
} 

    while ($rand = mysql_fetch_assoc($rezultat)) {    


echo "$num_rows ";
  }
?>