Results 1 to 20 of 20

Thread:

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jan:2012
    Location: Nova Zagora
    Posts: 134


    5 (select) ( )

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    ajax - , JS , javascript - , -. -, - ajax -, . 1-2 , .

  3. #3
    Registered User
    Join Date: Jan:2012
    Location: Nova Zagora
    Posts: 134
    ajax SQL-

  4. #4

    Join Date: Apr:2006
    Location:
    Posts: 8,666
    ajax, (APC ) , .

  5. #5
    a.k.a. Bibi Flower's Avatar
    Join Date: Aug:2006
    Location: Sofia, Bulgaria
    Posts: 562
    :
    , .
    , : 5 data- - .
    display:none , .
    $('a[data-autor!="5"]').hide();

  6. #6
    Registered User
    Join Date: Jan:2012
    Location: Nova Zagora
    Posts: 134
    PHP Code:
    if (isset($_SESSION['kategoriq']) || isset($_SESSION['avtor']) || isset($_SESSION['date']) || isset($_SESSION['album'])) {
        if (isset(
    $_SESSION['kategoriq']) &&
                isset(
    $_SESSION['avtor']) &&
                isset(
    $_SESSION['date']) &&
                isset(
    $_SESSION['album'])) {
            
    $parts "kategoriq='".$_SESSION['kategoriq']."'" .
                    
    "username='".$_SESSION['avtor']."'" .
                    
    "dateup='".$_SESSION['date']."'" .
                    
    "album='".$_SESSION['album']."'";
        }
        elseif (isset(
    $_SESSION['kategoriq']) &&
                isset(
    $_SESSION['avtor']) &&
                isset(
    $_SESSION['date']) &&
                !isset(
    $_SESSION['album'])) {
            
    $parts "kategoriq='".$_SESSION['kategoriq'] . "'" .
                    
    "username='".$_SESSION['avtor'] . "'" .
                    
    "dateup='".$_SESSION['date']."'";
        }
        elseif (isset(
    $_SESSION['kategoriq']) &&
                isset(
    $_SESSION['avtor']) &&
                !isset(
    $_SESSION['date']) &&
                !isset(
    $_SESSION['album'])) {
            
    $parts "kategoriq='" $_SESSION['kategoriq']."'" .
                    
    "username='" $_SESSION['avtor']."'";
        }
        elseif (isset(
    $_SESSION['kategoriq']) &&
                !isset(
    $_SESSION['avtor']) &&
                !isset(
    $_SESSION['date']) &&
                !isset(
    $_SESSION['album'])) {
            
    $parts "kategoriq='".$_SESSION['kategoriq']."'";
        }elseif(
        
        )
        
    $query mysql_query("SELECT * FROM image WHERE $parts LIMIT 1") or die(mysql_error());
    } else {
        
    $query mysql_query("SELECT * FROM image ORDER BY RAND() LIMIT 1 ");

    AND

  7. #7

    Join Date: Apr:2006
    Location:
    Posts: 8,666
    isset-

  8. #8
    Registered User
    Join Date: Jul:2006
    Location:
    Posts: 1,071
    ( , ):
    PHP Code:
    $parts = array();

    //       
    $parts[] = isset($_SESSION['avtor'])         ? "`username`= '" $_SESSION['avtor']."' "        '';
    $parts[] = isset($_SESSION['kategoriq'])     ? "`kategoriq`= '" $_SESSION['kategoriq']."' "   '';
    $parts[] = isset($_SESSION['date'])          ? "`dateup`= '" $_SESSION['date']."' "           '';
    $parts[] = isset($_SESSION['album'])         ? "`album`= '" $_SESSION['album']."' "           '';

    //    
    $parts array_filter($parts); 

    // ""  WHERE         $parts...
    $where count($parts) ? "WHERE " implode(" AND "$parts) : "";

    //     ORDER BY RAND()    
    $query mysql_query("SELECT * FROM image $where LIMIT 1") or die(mysql_error()); 
    : smelkomar , , SQL ... mysql_real_escape_string() , "" magic_quotes = On.

  9. #9
    Registered User
    Join Date: Jan:2012
    Location: Nova Zagora
    Posts: 134

  10. #10

    Join Date: Apr:2006
    Location:
    Posts: 8,666
    SQL . . , 'date' 2008-01-01, 'album' , ?
    $_SERVER['REQUEST_METHOD'] $_POST $_GET . ,

    mialy, - . .

    , ... PDO you must

  11. #11
    a.k.a. Bibi Flower's Avatar
    Join Date: Aug:2006
    Location: Sofia, Bulgaria
    Posts: 562
    :

    Code:
    // validation here
    $where = 'WHERE 1=1';
    if ($user) {
        $where .= " AND username = '$user'";
    }
    if ($cat) {
        $where .= " AND kategoriq = '$cat'";
    }
    // ...

  12. #12
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    Quote Originally Posted by Flower View Post
    :

    Code:
    // validation here
    $where = 'WHERE 1=1';
    if ($user) {
        $where .= " AND username = '$user'";
    }
    if ($cat) {
        $where .= " AND kategoriq = '$cat'";
    }
    // ...
    .
    ( ), , where- , 1=1 . sql-.

  13. #13

    Join Date: Apr:2006
    Location:
    Posts: 8,666
    Quote Originally Posted by Flower View Post
    :
    , filter_input_array , - .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |