PHP - Special Restriction Of Some Sort?

Hi All

i am wanting a column list like this

http://extensions.joomla.org/extensions

basically the database is set up as
(id, category, parent)

I want the parent to group the category section and list like the the joomla example in three columns

search various threads throughout the internet but none seem to cover this entirely

can any one please help?????

Hi,
I want to restrict my registered user to see video only once per day...
Can anyone guide me how can i do this with php???
Thanks

hi once again, i got a form that uploads an image, checks  formats and all that.. i need to add the filesize restriction.
something like this:

define ("max_size","20"); //<- 20kb size
$size=filesize($_FILES['image']['tmp_name'])

if ($size > max_size*1024){
echo "too big filesize";
} else {
  //......
}



how do i put that code, into this code? :

<?php

$allowedfiletypes = array("jpeg","jpg","gif","png");
$uploadfolder = "uploads/" ;
$thumbnailheight = 100; //in pixels
$thumbnailfolder = $uploadfolder."thumbs/" ;


$action = $_POST['action'];
if ($action == "upload") {
    //echo "<p>Uploading image... " ;

    if(empty($_FILES['uploadimage']['name'])){
        echo '<script type="text/javascript"> {alert("Pasirinkite faila");} </script>';
    } else {
        $uploadfilename = $_FILES['uploadimage']['name'];
        $fileext = strtolower(substr($uploadfilename,strrpos($uploadfilename,".")+1));

        if (!in_array($fileext,$allowedfiletypes)) { 
echo '<script type="text/javascript"> {alert("Blogas failo tipas");} </script>';
} else {
            $fulluploadfilename = $uploadfolder.$uploadfilename ;


            if (move_uploaded_file($_FILES['uploadimage']['tmp_name'], $fulluploadfilename)) {
           echo '<script type="text/javascript"> {alert("Failas irasytas");} </script>';
            $im = imagecreatefromjpeg($fulluploadfilename);

                if (!$im) {
 echo '<script type="text/javascript"> {alert("Nepavyko sugeneruoti thumbnail");} </script>'; 
} else {
                    $imw = imagesx($im); // uploaded image width
                    $imh = imagesy($im); // uploaded image height
                    $nh = $thumbnailheight; // thumbnail height
                    $nw = round(($nh / $imh) * $imw); //thumnail width
                    $newim = imagecreatetruecolor ($nw, $nh);
                    imagecopyresampled ($newim,$im, 0, 0, 0, 0, $nw, $nh, $imw, $imh) ;
                    $thumbfilename = $thumbnailfolder.$uploadfilename ;
                    imagejpeg($newim, $thumbfilename) or die('<script type="text/javascript"> {alert("Nepavyko issaugoti thumbnail");} </script>');
                }
            } else { 
echo '<script type="text/javascript"> {alert("Nepavyko issaugoti failo");} </script>'; 
}
        }
    }

function watermark($original_image,$original_watermark,$destination="")
{
$image=imagecreatefromjpeg($original_image);
list($imagewidth,$imageheight)=getimagesize($original_image);

$watermark  =  imagecreatefrompng($original_watermark); 
list($watermarkwidth,$watermarkheight)=getimagesize($original_watermark);

if($watermarkwidth>$imagewidth || $watermarkheight>$imageheight)
{
$water_resize_factor = $imagewidth / $watermarkwidth;
$new_watermarkwidth  = $watermarkwidth * $water_resize_factor;
$new_watermarkheight = $watermarkheight * $water_resize_factor;

$new_watermark = imagecreatetruecolor($new_watermarkwidth , $new_watermarkheight);

imagealphablending($new_watermark , false);
imagecopyresampled($new_watermark , $watermark, 0, 0, 0, 0, $new_watermarkwidth, $new_watermarkheight, $watermarkwidth, $watermarkheight);

$watermarkwidth  = $new_watermarkwidth; 
$watermarkheight = $new_watermarkheight; 
$watermark       = $new_watermark;
}
$startwidth  =  ($imagewidth  -  $watermarkwidth)  / 2; 
$startheight  =  ($imageheight  -  $watermarkheight) / 2;

imagecopy($image, $watermark, $startwidth, $startheight, 0, 0, $watermarkwidth, $watermarkheight); 
if(!empty($destination))
imagejpeg($image,$destination);
else 
imagejpeg($image);
}


$original_directory = "uploads/thumbs/";
$watermarked_images = "uploads/thumbs/watermarkedthumbs/";

if ($handle = opendir($original_directory)) 
{
    while (false !== ($file = readdir($handle))) 
    {
     /*
     exif_imagetype checks if our file is
     a .jpg file. See manual for more info
     */
     if(!is_file($original_directory.$file))
     continue;
        if(exif_imagetype($original_directory.$file)==2)
        {
         watermark($original_directory.$file,"watermark.png",$watermarked_images.$file);
              }
    }
    closedir($handle);
}
}


?>
<form name="newad" method="post" enctype="multipart/form-data"  action="">
 <label for="file" id="label">Pasirinkti fail&#261;: </label>
 <input type="hidden" name="action" value="upload" />
 <input type="file" name="uploadimage" id="file">
 <input name="Submit" type="submit" value="&#303;kelti" id="submit">
</form>


i tried smth like this, but it shows some error ("Warning: filesize() [function.filesize]: stat failed for 1.jpg in")

<?php

/* $allowedfiletypes = array("jpeg","jpg","gif","png");
$uploadfolder = "uploads/" ;
$thumbnailheight = 100; //in pixels
$thumbnailfolder = $uploadfolder."thumbs/" ; */
define ("max_size","20"); 
$size=filesize($_FILES['uploadimage']['name']);

/* $action = $_POST['action'];
if ($action == "upload") {
    //echo "<p>Uploading image... " ;

    if(empty($_FILES['uploadimage']['name'])){
        echo '<script type="text/javascript"> {alert("Pasirinkite faila");} </script>';
    } else {
        $uploadfilename = $_FILES['uploadimage']['name'];
        $fileext = strtolower(substr($uploadfilename,strrpos($uploadfilename,".")+1));

        if (!in_array($fileext,$allowedfiletypes)) { 
echo '<script type="text/javascript"> {alert("Blogas failo tipas");} </script>';
} else {
            $fulluploadfilename = $uploadfolder.$uploadfilename ; */


if ($size > max_size*1024){
echo '<script type="text/javascript"> {alert("Per didelis failas");} </script>';
} else {

           /* if (move_uploaded_file($_FILES['uploadimage']['tmp_name'], $fulluploadfilename)) {
           echo '<script type="text/javascript"> {alert("Failas irasytas");} </script>';
            $im = imagecreatefromjpeg($fulluploadfilename);

                if (!$im) {
 echo '<script type="text/javascript"> {alert("Nepavyko sugeneruoti thumbnail");} </script>'; 
} else {
                    $imw = imagesx($im); // uploaded image width
                    $imh = imagesy($im); // uploaded image height
                    $nh = $thumbnailheight; // thumbnail height
                    $nw = round(($nh / $imh) * $imw); //thumnail width
                    $newim = imagecreatetruecolor ($nw, $nh);
                    imagecopyresampled ($newim,$im, 0, 0, 0, 0, $nw, $nh, $imw, $imh) ;
                    $thumbfilename = $thumbnailfolder.$uploadfilename ;
                    imagejpeg($newim, $thumbfilename) or die('<script type="text/javascript"> {alert("Nepavyko issaugoti thumbnail");} </script>');
                }
            } else { 
echo '<script type="text/javascript"> {alert("Nepavyko issaugoti failo");} </script>'; 
}
        }
    }
}
function watermark($original_image,$original_watermark,$destination="")
{
$image=imagecreatefromjpeg($original_image);
list($imagewidth,$imageheight)=getimagesize($original_image);

$watermark  =  imagecreatefrompng($original_watermark); 
list($watermarkwidth,$watermarkheight)=getimagesize($original_watermark);

if($watermarkwidth>$imagewidth || $watermarkheight>$imageheight)
{
$water_resize_factor = $imagewidth / $watermarkwidth;
$new_watermarkwidth  = $watermarkwidth * $water_resize_factor;
$new_watermarkheight = $watermarkheight * $water_resize_factor;

$new_watermark = imagecreatetruecolor($new_watermarkwidth , $new_watermarkheight);

imagealphablending($new_watermark , false);
imagecopyresampled($new_watermark , $watermark, 0, 0, 0, 0, $new_watermarkwidth, $new_watermarkheight, $watermarkwidth, $watermarkheight);

$watermarkwidth  = $new_watermarkwidth; 
$watermarkheight = $new_watermarkheight; 
$watermark       = $new_watermark;
}
$startwidth  =  ($imagewidth  -  $watermarkwidth)  / 2; 
$startheight  =  ($imageheight  -  $watermarkheight) / 2;

imagecopy($image, $watermark, $startwidth, $startheight, 0, 0, $watermarkwidth, $watermarkheight); 
if(!empty($destination))
imagejpeg($image,$destination);
else 
imagejpeg($image);
}


$original_directory = "uploads/thumbs/";
$watermarked_images = "uploads/thumbs/watermarkedthumbs/";

if ($handle = opendir($original_directory)) 
{
    while (false !== ($file = readdir($handle))) 
    {
     /*
     exif_imagetype checks if our file is
     a .jpg file. See manual for more info
     */ /*
     if(!is_file($original_directory.$file))
     continue;
        if(exif_imagetype($original_directory.$file)==2)
        {
         watermark($original_directory.$file,"watermark.png",$watermarked_images.$file);
              }
    }
    closedir($handle);
}
}

*/
?>


any ideas?
thanks

Hello everybody  ,
This is my first topic here and I hope I will find the solution for my problem.
I want to restrict access to file (for exemple: http://www.mysite.com/files/file0000.zip) to a just a specific IP that will be read from the database. And also store all other IPs trying to access this file.
Can this be done, maybe through some php and htaccess?

Thank you for any help or any other ideas.

i want to share my problem in my website

For the better understandng of my website, I want to tell all the details.

1. I have a database and i has a 2 tables 1 for the tbllogin which consist of Username and Department, and the second table is caltbl which i use for the calendar events.

2.When my website run the first webpage is the login form. If the Username and Department is correct she can browse the other webpages, like the calendar event.


3. In the calendar event you can see the calendar and when you click the date theirs a link "new event" appear and if theirs no existing event theres a text saying "No Events", when you click the link you can add events. I want that theirs a specific person that can only add events for the restriction of adding events. I want to happen that if the user is xxx and her department is yyy the link shoud appear and she can add events. i want that only to her the link should be appear..

here is my code:

<?php 
$host = "localhost"; 
  
    $username = ""; 
  
    $password = ""; 
  
    $dbCnx = @mysql_connect($host, $username, $password) or die('Could not Connect to the database'); 
  
    $dbName = 'dspi'; 
  
    mysql_select_db($dbName);     
?> 
<script> 
function goLastMonth(month, year){ 
// If the month is January, decrement the year 
if(month == 1){ 
--year; 
month = 13; 
} 
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year; 
} 
//next function 
function goNextMonth(month, year){ 
// If the month is December, increment the year 
if(month == 12){ 
++year; 
month = 0; 
} 
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year; 
}  
  
function remChars(txtControl, txtCount, intMaxLength) 
{ 
if(txtControl.value.length > intMaxLength) 
txtControl.value = txtControl.value.substring(0, (intMaxLength-1)); 
else 
txtCount.value = intMaxLength - txtControl.value.length; 
} 
  
function checkFilled() { 
var filled = 0 
var x = document.form1.calName.value; 
//x = x.replace(/^\s+/,""); // strip leading spaces 
if (x.length > 0) {filled ++} 
  
var y = document.form1.calDesc.value; 
//y = y.replace(/^s+/,""); // strip leading spaces 
if (y.length > 0) {filled ++} 
  
if (filled == 2) { 
document.getElementById("Submit").disabled = false; 
} 
else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased 
  
} 
  
</script> 
<html> 
<body> 
<?php 
//$todaysDate = date("n/j/Y"); 
//echo $todaysDate; 
// Get values from query string 
$day = (isset($_GET["day"])) ? $_GET['day'] : ""; 
$month = (isset($_GET["month"])) ? $_GET['month'] : ""; 
$year = (isset($_GET["year"])) ? $_GET['year'] : ""; 
//comparaters for today's date 
//$todaysDate = date("n/j/Y"); 
//$sel = (isset($_GET["sel"])) ? $_GET['sel'] : ""; 
//$what = (isset($_GET["what"])) ? $_GET['what'] : ""; 
  
//$day = (!isset($day)) ? $day = date("j") : $day = ""; 
if(empty($day)){ $day = date("j"); } 
  
if(empty($month)){ $month = date("n"); } 
  
if(empty($year)){ $year = date("Y"); }  
//set up vars for calendar etc 
$currentTimeStamp = strtotime("$year-$month-$day"); 
$monthName = date("F", $currentTimeStamp); 
$numDays = date("t", $currentTimeStamp); 
$counter = 0; 
//$numEventsThisMonth = 0; 
//$hasEvent = false; 
//$todaysEvents = "";  
//run a selec statement to hi-light the days 
function hiLightEvt($eMonth,$eDay,$eYear){ 
//$tDayName = date("l"); 
$todaysDate = date("n/j/Y"); 
$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear; 
if($todaysDate == $dateToCompare){ 
//$aClass = '<span>' . $tDayName . '</span>'; 
$aClass='class="today"'; 
}else{ 
//$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear; 
//echo $todaysDate; 
//return; 
$sql="select count(calDate) as eCount from calTbl where calDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'"; 
//echo $sql; 
//return; 
$result = mysql_query($sql); 
while($row= mysql_fetch_array($result)){ 
if($row['eCount'] >=1){ 
$aClass = 'class="event"'; 
}elseif($row['eCount'] ==0){ 
$aClass ='class="normal"'; 
} 
} 
} 
return $aClass; 
} 
?> 
<div id="Calendar_Event"> 
<table width="350" cellpadding="0" cellspacing="0"> 
<tr> 
<td width="50" colspan="1"> 
<input type="button" value=" < " onClick="goLastMonth(<?php echo $month . ", " . $year; ?>);"> 
</td> 
<td width="250" colspan="5"> 
<span class="title" style="color:#FFFFFF"><?php echo $monthName . " " . $year; ?></span><br> 
</td> 
<td width="50" colspan="1" align="right"> 
<input type="button" value=" > " onClick="goNextMonth(<?php echo $month . ", " . $year; ?>);"> 
</td> 
</tr>  
<tr> 
<th>M</td> 
<th>T</td> 
<th>W</td> 
<th>T</td> 
<th>F</td> 
<th>S</td> 
<th>S</td> 
</tr> 
<tr> 
<?php 
for($i = 1; $i < $numDays+1; $i++, $counter++){ 
$dateToCompare = $month . '/' . $i . '/' . $year; 
$timeStamp = strtotime("$year-$month-$i"); 
//echo $timeStamp . '<br/>'; 
if($i == 1){ 
// Workout when the first day of the month is 
$firstDay = date("N", $timeStamp); 
for($j = 1; $j < $firstDay; $j++, $counter++){ 
echo "<td>&nbsp;</td>"; 
}  
} 
if($counter % 7 == 0 ){ 
?> 
</tr><tr> 
<?php 
} 
?> 
<!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?=$_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?=$i;?></a></td>  
<?php 
} 
?> 
</table> 
</div> 
<div id="New_Event"> 
<?php 
if(isset($_GET['v'])){ 
if(isset($_POST['Submit'])){ 
$sql="insert into calTbl(calName,calDesc,calDate,calStamp) values('" . $_POST['calName'] ."','" . $_POST['calDesc'] . "','" . $_POST['calDate'] . "',now())"; 
mysql_query($sql); 
} 
$sql="select calName,calDesc, DATE_FORMAT(calStamp, '%a %b %e %Y') as calStamp from calTbl where calDate = '" . $month . '/' . $day . '/' . $year . "'"; 
//echo $sql; 
//return; 
$result = mysql_query($sql); 
$numRows = mysql_num_rows($result); 
  
$check=mysql_query("SELECT * FROM tbllogin WHERE Username='rhoda.barrera@dunlop.ph' AND Department='MIS'"); 
if (mysql_num_rows($check)>0){  
?> 
<a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">Add Even</a><a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">t</a><?php 
}else{ 
echo 'You cannot Add New Event'; 
}?> 
</div> 
<div id="Cal_Event"> 
<?php 
if(isset($_GET['f'])){ 
include 'calForm.php'; 
} 
if($numRows == 0 ){ 
echo ''; 
}else{ 
//echo '<ul>'; 
echo '<h3>Event Listed</h3>'; 
while($row = mysql_fetch_array($result)){ 
?> 
  
<h5><?=$row['calName'];?></h5> 
<?=$row['calDesc'];?><br/> 
Listed On: <?=$row['calStamp'];?> 
<?php 
} 
} 
} 
?> 
</div> 
</body> 
</html>