include "express/Connections/dbConnect.php";
mysql_select_db($database_dbConnect, $dbConnect);
$query_ref = "SELECT table1.*, rubrike.rubrika FROM table1 LEFT JOIN rubrike ON table1.idc=rubrike.idc WHERE (table1.idc='".mysql_escape_string($_GET['idc'])."' AND table1.objavi=1) ORDER BY table1.tvrtka ASC";
$ref = mysql_query($query_ref, $dbConnect) or die(mysql_error());
$row_ref = mysql_fetch_assoc($ref);
$totalRows_ref = mysql_num_rows($ref);
function slika($id, $string) {
return 'slike/'.date("Y/m/d/$id/", filemtime(substr($string,strpos($string,'slike/src/'), strlen($string)-strpos($string,'slike/src/')))).substr($string, strrpos($string,'/')+1,strlen($string)-strrpos($string,'/'));
}
?>
Libra - reference
REFERENCE
switch ($_GET['idc']) {
case 1: echo 'PROJEKTI'; break;
case 2: echo 'PROJEKTI'; break;
case 3: echo 'FOTOGRAFIJE'; break;
case 4: echo 'UPUTE'; break;
case 5: echo 'FOTOGRAFIJE'; break;
}?>
if ($_GET['idc']!=4) {
if ($_GET['id']) $ajdi=" AND id=".$_GET['id'];
$query_projekt = "SELECT * FROM table1 WHERE (idc=".$_GET['idc']." AND objavi=1".$ajdi.") ORDER BY prvi DESC, id DESC";
$projekt = mysql_query($query_projekt, $dbConnect) or die(mysql_error());
$row_projekt = mysql_fetch_assoc($projekt);
if ($row_projekt) {
$query_slike = "SELECT * FROM table2 WHERE parent=".$row_projekt['id']." ORDER BY objavi DESC, id ASC";
$slike = mysql_query($query_slike, $dbConnect) or die(mysql_error());
$row_slike = mysql_fetch_assoc($slike);
}
?>
Klijent:
if ($row_slike) {
$velika=$row_slike['putanja'];
do {
$dimensions = GetImageSize(slika(2,$row_slike['putanja']));
$h=$dimensions[1];
?>