Results 1 to 20 of 20
Hybrid View
-
30th August 2013 11:12 #1Registered User
Join Date: Jan:2012
Location: Nova Zagora
Posts: 134
5 (select) ( )
-
30th August 2013 11:20 #2
ajax - , JS , javascript - , -. -, - ajax -, . 1-2 , .
-
30th August 2013 11:32 #3Registered User
Join Date: Jan:2012
Location: Nova Zagora
Posts: 134
ajax SQL-
-
30th August 2013 18:11 #4
Join Date: Apr:2006
Location:
Posts: 8,666
ajax, (APC ) , .
-
31st August 2013 15:26 #5
:
, .
, : 5 data- - .
display:none , .
$('a[data-autor!="5"]').hide();
-
31st August 2013 18:26 #6Registered User
Join Date: Jan:2012
Location: Nova Zagora
Posts: 134
ANDPHP 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 ");
}
-
31st August 2013 20:59 #7
Join Date: Apr:2006
Location:
Posts: 8,666
isset-
-
31st August 2013 21:08 #8Registered User
Join Date: Jul:2006
Location:
Posts: 1,071
( , ):
: smelkomar , , SQL ... mysql_real_escape_string() , "" magic_quotes = On.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());
-
31st August 2013 21:41 #9Registered User
Join Date: Jan:2012
Location: Nova Zagora
Posts: 134
-
31st August 2013 22:52 #10
Join Date: Apr:2006
Location:
Posts: 8,666
SQL . . , 'date' 2008-01-01, 'album' , ?
$_SERVER['REQUEST_METHOD'] $_POST $_GET . ,
mialy, - . .
, ... PDO you must
-
2nd September 2013 07:36 #11
:
Code:// validation here $where = 'WHERE 1=1'; if ($user) { $where .= " AND username = '$user'"; } if ($cat) { $where .= " AND kategoriq = '$cat'"; } // ...
-
2nd September 2013 10:32 #12
-
2nd September 2013 12:46 #13




Reply With Quote
.
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in