Форум программистов [Powered by Invision Power Board]

Код


<form name="search_form" method="GET" action=<?php echo $_SERVER['PHP_SELF']; ?>>
    <table cellpadding="2" cellspacing="4" bordercolordark="black" bordercolorlight="black">
        <tr>
            <td width="965" valign="top" align="center"><input type="text" name="search"></td>
        </tr>
        <tr>
            <td width="965" valign="top" align="center"><input type="submit" value="OK" name=go></td>
        </tr>
    </table>
</form>

<?php
include "./conn.php";

mysql_connect("$dbHost", "$dbUser", "$dbPass");
mysql_select_db("$dbName");

$search= " ";
$sname= ' ';

if(!empty($_GET['go']))
{
//$_GET['search'] = $sname;
$sname = $_GET['search'] ;

}



$result = mysql_query("SELECT * FROM $tablename  WHERE name LIKE '%$sname%' ORDER BY name LIMIT 15");
if (mysql_num_rows($result) != 0) {
while($query_data = mysql_fetch_row($result)){

 
echo "</table>"; 

print "<table cellpadding=2 cellspacing=2 width=100% bordercolordark=black bordercolorlight=black>
    <tr>
        <td width=965 bgcolor=#39393B>

            <p><img src=images/for_menu_2.gif border=0 align=absmiddle>
 <a href=# 
 onclick=JavaScript:window.open('$query_data[2]','','width=400,height=100,toolbar=no,resizable=no')
title=Size:&nbsp;$query_data[3]&nbsp;mb&nbsp;/&nbsp;Downloads:
>&nbsp;$query_data[1]</a></p>

        </td>
    </tr>
</table>";

}
} else {
    
   print "<p class=p><font color=white>Sorry! But nothing is found!</font></b></p>";
}

mysql_close();

print "<p>&nbsp;</p>";
print "<p align=center>&nbsp;Place for your reklam here!</p><br>";
print "<center> <table width=476 cellpadding=0 cellspacing=0 bordercolordark=black bordercolorlight=black>
                            <tr>
                                <td width=476 bgcolor=#3A3A3A align=center valign=top height=17>
                                    <p><font color=black>1 2 3</font></p>
                                </td>
                            </tr>
                        </table></center><p>&nbsp;</p>";
?>