1. Nie chce mi wyświetlać tabeli w przypadku braku hasła
2. Nie wyświetlają się tabele z dir=DESC.
3. Przy wpisywaniu w przeglądarce zmiennych get wszystko ładnie działa
4. Skopiowałem to z innej strony, ale nie było na niej searchname

[PHP] pobierz, plaintext 
<?
connect();
 
$wyborbazy = mysql_select_db("baza_matys");
 
 
if (isset($_SESSION['logged']))
$_SESSION['logged'] = filter_var($_SESSION['logged'], FILTER_SANITIZE_STRING);
 
if (isset($_GET['sortby']))
{
$_GET['sortby'] = filter_var($_GET['sortby'], FILTER_SANITIZE_STRING);
$_SESSION['sortby'] = $_GET['sortby'];
}
$sortby = $_SESSION['sortby'];
 
if (isset($_GET['dir']))
{
$_GET['dir'] = filter_var($_GET['dir'], FILTER_SANITIZE_STRING);
$_SESSION['dir'] = $_GET['dir'];
}
$dir = $_SESSION['dir'];
 
if (isset($_GET['page']))
{
$_GET['page'] = filter_var($_GET['page'], FILTER_SANITIZE_STRING);
$_SESSION['page'] = $_GET['page'];
}
$page = $_SESSION['page'];
 
if (isset($_POST['searchname']))
{
$_POST['searchname'] = filter_var($_POST['searchname'], FILTER_SANITIZE_STRING);
$_SESSION['searchname'] = $_POST['searchname'];
}
$searchname = $_SESSION['searchname'];
 
if (isset($_SESSION['searchname']))
{
    if (!empty($_SESSION['searchname']))
    {
 
        $_SESSION['searchname'] = $_POST["searchname"];
        $searchname = $_SESSION['searchname'];
        $query = "
            SELECT * from table_books
            WHERE author LIKE '%$searchname%' OR book_name LIKE '%$searchname%'
 
            ";
        $result = mysql_query($query) or die(mysql_error());
    }
    if (empty($query))
    {
        echo "";
    }
    else
    {
        $counter = mysql_num_rows($result);
        $num_of_pages = ceil($counter/10);
        if (isset($_GET['page']))
        {
            if (!empty($_GET['page']) )
            {
 
                $_GET['page'] = filter_var($_GET['page'], FILTER_SANITIZE_STRING);
 
 
 
                if (($_GET['page'] > $num_of_pages) )
                {
                    echo "Site not exist!";
                    exit;
                }
 
 
                if ($_GET['page']!=NULL)
                if (!is_numeric($_GET['page']))
                {
                    echo "Site not exist!";
                    exit;
                }
            }
 
        }
        function sort_first_table()
        {
            echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
            <th>LP</th>
            <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
            <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
            <th><a href='searchbooks.php?sortby=author&dir=ASC'>Author &or;</a></th>
            <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
            <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
            <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
            <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
            </tr>";
        }
    if ((!empty($_SESSION['sortby'])) && (!empty($_SESSION['dir'])))
    {
 
 
 
 
 
 
[PHP] pobierz, plaintext 

...



Dalsza część kodu

[PHP] pobierz, plaintext 
if ($_SESSION['sortby'] == "book_id")
        {
            if ($_SESSION['dir'] == "ASC")
            {
                echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                <th>LP</th>
                <th><a href='searchbooks.php?sortby=book_id&dir=DESC'>ID &and;</a></th>
                <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
                <th><a href='searchbooks.php?sortby=author&dir=ASC'>Author &or;</a></th>
                <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
                <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
                <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
                <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
                </tr>";
            }
 
            else if ($_SESSION['dir'] == "DESC")
            {
                sort_first_table();
            }
        }
            if ($_SESSION['sortby'] == "book_name")
            {
                if ($_SESSION['dir'] == "ASC")
                {
                    echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                    <th>LP</th>
                    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
                    <th><a href='searchbooks.php?sortby=book_name&dir=DESC'>Book Name &and;</a></th>
                    <th><a href='searchbooks.php?sortby=author&dir=ASC'>Author &or;</a></th>
                    <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
                    <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
                    <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
                    <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
                    </tr>";
                }
 
                else if ($_SESSION['dir'] == "DESC")
                {
                    sort_first_table();
                }
            }
 
            if ($_SESSION['sortby'] == "author")
            {
                if ($_SESSION['dir'] == "ASC")
                {
 
                    echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                    <th>LP</th>
                    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
                    <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
                    <th><a href='searchbooks.php?sortby=author&dir=DESC'>Author &and;</a></th>
                    <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
                    <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
                    <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
                    <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
                    </tr>";
                }
 
                else if ($_SESSION['dir'] == "DESC")
                {
                    sort_first_table();
                }
        }
 
 
            if ($_SESSION['sortby'] == "publishing_house")
            {
                if ($_SESSION['dir'] == "ASC")
                {
                    echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                    <th>LP</th>
                    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
                    <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
                    <th><a href='searchbooks.php?sortby=author&dir=ASC'>Author &or;</a></th>
                    <th><a href='searchbooks.php?sortby=publishing_house&dir=DESC'>Publishing house &and;</a></th>
                    <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
                    <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
                    <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
                    </tr>";
                }
 
                else if ($_SESSION['dir'] == "DESC")
                {
                    sort_first_table();
                }
           }
 
            if ($_SESSION['sortby'] == "year_of_publication")
            {
                if ($_SESSION['dir'] == "ASC")
                {
 
                    echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                    <th>LP</th>
                    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
                    <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
                    <th><a href='searchbooks.php?sortby=author&dir=ASC'>Author &or;</a></th>
                    <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
                    <th><a href='searchbooks.php?sortby=year_of_publication&dir=DESC'>Year of publication &and;</a></th>
                    <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
                    <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
                    </tr>";
                    }
 
                else if ($_SESSION['dir'] == "DESC")
                {
                    sort_first_table();
                }
            }
 
 
            if ($_SESSION['sortby'] == "binding")
            {
                if ($_SESSION['dir'] == "ASC")
                {
 
                    echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                    <th>LP</th>
                    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
                    <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
                    <th><a href='searchbooks.php?sortby=author&dir=ASSC'>Author &or;</a></th>
                    <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
                    <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
                    <th><a href='searchbooks.php?sortby=binding&dir=DESC'>Binding &and;</a></th>
                    <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th>
                    </tr>";
                    }
 
                else if ($_SESSION['dir'] == "DESC")
                {
                    sort_first_table();
                }
            }
 
            if ($_SESSION['sortby'] == "availability")
            {
                if ($_SESSION['dir'] == "ASC")
                {
 
                    echo  "<table bgcolor=#EEEEEE border=1 align=center width='920'><tr>
                    <th>LP</th>
                    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
                    <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
                    <th><a href='searchbooks.php?sortby=author&dir=ASSC'>Author &or;</a></th>
                    <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
                    <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
                    <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
                    <th><a href='searchbooks.php?sortby=availability&dir=DESC'>Availability &and;</a></th>
                    </tr>";
                 }
 
                else if ($_SESSION['dir'] == "DESC")
                {
                    sort_first_table();
                }
            }
        }
    }
 
}
 
else 
    {
    echo
    "<table bgcolor=#EEEEEE border=1 align=center  width='920'><tr>
    <th>LP</th>
    <th><a href='searchbooks.php?sortby=book_id&dir=ASC'>ID &or;</a></th>
    <th><a href='searchbooks.php?sortby=book_name&dir=ASC'>Book Name &or;</a></th>
    <th><a href='searchbooks.php?sortby=author&dir=ASC'>Author &or;</a></th>
    <th><a href='searchbooks.php?sortby=publishing_house&dir=ASC'>Publishing house &or;</a></th>
    <th><a href='searchbooks.php?sortby=year_of_publication&dir=ASC'>Year of publication &or;</a></th>
    <th><a href='searchbooks.php?sortby=binding&dir=ASC'>Binding &or;</a></th>
    <th><a href='searchbooks.php?sortby=availability&dir=ASC'>Availability &or;</a></th></tr>";
    }
?>
[PHP] pobierz, plaintext 

Jeszcze taki searchbar na początku

[HTML] pobierz, plaintext 
<form name="searchbar" method="post" action="searchbooks.php">
                                                    <input name="searchname" type="text" size="30" maxlength="40">
                                                    <input type="submit" value="Search book">
                                                </form>
[HTML] pobierz, plaintext