PHP - Listing Files Along With Description And Image?

Hi,

I have a script that currently works for uploading images and I have tried to modify it to upload PDF's and DOC's too, but I can't get it to work - it works fine with JPG or GIF.

Any ideas?

Thanks in advance.

Code: [Select]
<?php
  include "scripts/connect.php";
$idir = "../documents/";   // Path To Images Directory

if (isset ($_FILES['fupload'])){

$randomd=rand(0000,9999);

//upload the image to tmp directory
$url = $_FILES['fupload']['name'];   // Set $url To Equal The Filename For Later Use 
if ($_FILES['fupload']['type'] == "image/jpg"
|| $_FILES['fupload']['type'] == "image/jpeg"
|| $_FILES['fupload']['type'] == "image/pjpeg"
|| $_FILES['fupload']['type'] == "image/gif"
|| $_FILES['fupload']['type'] == "image/pdf"
|| $_FILES['fupload']['type'] == "image/doc") { 
$file_ext = strrchr($_FILES['fupload']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
$copy = copy($_FILES['fupload']['tmp_name'], "$idir" . "$randomd" . $_FILES['fupload']['name']);   // Move Image From Temporary Location To Permanent Location 
}
}

error_reporting (E_ALL ^ E_NOTICE);

    if ($_POST['submit']) {

$document = mysql_real_escape_string("$idir" . "$randomd" . $_FILES['fupload']['name']);
$name = mysql_real_escape_string($_POST['name']);
$description = mysql_real_escape_string($_POST['description']);


        $SQL = " INSERT INTO documents";
        $SQL .= " (document, name, description) VALUES ";
        $SQL .= " ('$document', '$name', '$description') ";

        $result = mysql_db_query($db,$SQL,$cid);
        $last=mysql_insert_id();
        
        if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    }

header("location:document-added.php?ref=$last");
exit();

    }
?>[code]

Hey guys,

I have an image upload script and it's working fine. But for some files it will not work. It says it can't get the filesize and it can't copy that file. I have tried to change the file format of that file, but with no result. So it's not the file format. Is there anything else that could confuse getfilesize and copy commands in PHP? Can you please tell me what is wrong?

include ("include/session.php");

//Pohranjivanje podataka za 1. sliku

$naziv1 = mysql_real_escape_string($_POST["naziv1"],$veza);
$opis1 = mysql_real_escape_string($_POST["opis1"],$veza);
$album_id = mysql_real_escape_string($_POST["album_id"],$veza);
$datum1 = date("Y-m-d H:i:s");


//Upload slike i thumba
//define a maxim size for the uploaded images 
define ("MAX_SIZE","10000000000"); 

// define the width and height for the thumbnail 
// note that theese dimmensions are considered the maximum dimmension and are not fixed, 
// because we have to keep the image ratio intact or it will be deformed 
define ("WIDTH","200"); 
define ("HEIGHT","150");   

// this is the function that will create the thumbnail image from the uploaded image 
// the resize will be done considering the width and height defined, but without deforming the image 

function make_thumb($img_name,$filename,$new_w,$new_h) { 

//get image extension. 
$ext=getExtension($img_name); 
//creates the new image using the appropriate function from gd library 

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext)) $src_img=imagecreatefromjpeg($img_name);   
if(!strcmp("png",$ext)) $src_img=imagecreatefrompng($img_name);  
if(!strcmp("gif",$ext)) $src_img=imagecreatefromgif($img_name);

//gets the dimmensions of the image 

$old_x=imageSX($src_img); $old_y=imageSY($src_img);   

// next we will calculate the new dimmensions for the thumbnail image 
// the next steps will be taken: 
// 1. calculate the ratio by dividing the old dimmensions with the new ones 
// 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable 
// and the height will be calculated so the image ratio will not change 
// 3. otherwise we will use the height ratio for the image 
// as a result, only one of the dimmensions will be from the fixed ones 

$ratio1=$old_x/$new_w; $ratio2=$old_y/$new_h;

if($ratio1>$ratio2) { $thumb_w=$new_w; $thumb_h=$old_y/$ratio1; } else { $thumb_h=$new_h; $thumb_w=$old_x/$ratio2; }   

// we create a new image with the new dimmensions 

$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);   

// resize the big image to the new created one 

imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y);   

// output the created image to the file. Now we will have the thumbnail into the file named by $filename

if(!strcmp("png",$ext)) imagepng($dst_img,$filename); else imagejpeg($dst_img,$filename);   

//destroys source and destination images. 
imagedestroy($dst_img); imagedestroy($src_img); }   

// This function reads the extension of the file. 
// It is used to determine if the file is an image by checking the extension. 

function getExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; }   

// This variable is used as a flag. The value is initialized with 0 (meaning no error found) 
//and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded. 

$errors=0; 

// checks if the form has been submitted 

if(isset($_POST['spremi'])) { 

//reads the name of the file the user submitted for uploading 

$image=$_FILES['slika1']['name']; 

// if it is not empty 

if ($image) { 

// get the original name of the file from the clients machine 

$filename = stripslashes($_FILES['slika1']['name']); 

// get the extension of the file in a lower case format 

$extension = getExtension($filename); $extension = strtolower($extension); 


// if it is not a known extension, we will suppose it is an error, print an error message 
//and will not upload the file, otherwise we continue 

if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif")) { echo '<h1>Unknown extension!</h1>'; $errors=1; } else { 

// get the size of the image in bytes 
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which the uploaded file was stored on the server 

$size=getimagesize($_FILES['slika1']['tmp_name']); 
$sizekb=filesize($_FILES['slika1']['tmp_name']);   


//compare the size with the maxim size we defined and print error if bigger 

if ($sizekb > MAX_SIZE*1024) { echo '<h1>You have exceeded the size limit!</h1>'; $errors=1; }   

//we will give an unique name, for example the time in unix time format 

$image_name1=mt_rand(0,9999999).'.'.$extension; 

//the new name will be containing the full path where will be stored (images folder) 

$newname="slike_natjecanja/".$image_name1; 
$copied = copy($_FILES['slika1']['tmp_name'], $newname); 

//we verify if the image has been uploaded, and print error instead 

if (!$copied) { echo '<h1>Copy unsuccessfull!</h1>'; $errors=1; } else { 

// the new thumbnail image will be placed in images/thumbs/ folder 

$thumb_name='slike_natjecanja/thumbs/thumb_'.$image_name1; 
$thumb_name1 = 'thumb_'.$image_name1;

// call the function that will create the thumbnail. The function will get as parameters 
//the image name, the thumbnail name and the width and height desired for the thumbnail 

$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT); }} }} 

//If no errors registred, print the success message and show the thumbnail image created 
if(isset($_POST['Submit']) && !$errors) { echo "<h1>Thumbnail created Successfully!</h1>"; echo '<img src="'.$thumb_name.'">'; }


if (empty($_FILES['slika1']['name'])) {
    
    echo "Prazno je!";
    die;
    
    } else {
             
    //Ubacivanje u bazu
    $upit = "INSERT INTO natjecanja_slike_sve (album_id, naziv_slike, opis_slike, datum_dodavanja_slike, slika_nat_mala, slika_nat_velika) VALUES ('$album_id', '$naziv1', '$opis1', '$datum1', '$thumb_name1', '$image_name1')";
    echo "$upit";
    die;
    $rezultat = mysql_query($upit) or die (mysql_error());
    
}

Hi

Basically I've built a CMS where by my clients can upload a number of images. On the success page I want to display the images they uploaded by file name.

The issue is the number of images can vary. They may upload 2 or 10 or 50 etc.

So far I've come up with this:

Code: [Select]
// number of files
$UN = 3; //I've set this to 3 for now, but this is passed from the upload page!

// server directories and directory names
$dir = '../properties';

$images = glob($dir.'/*.{jpg}', GLOB_BRACE); //formats to look for

$num_of_files = $UN; //number of images to display from number of uploaded files

foreach($images as $image)
{
$num_of_files--;

$newest_mtime = 0;
$image = 'BROKEN';
if ($handle = @opendir($dir)) {
while (false !== ($file = readdir($handle))) {
if (($file != '.') && ($file != '..')) {
$mtime = filemtime("$dir/$file");
if ($mtime > $newest_mtime) {
$newest_mtime = $mtime;
$image = "$file";
}
}
}
}

if($num_of_files > -1) //this made me laugh when I wrote it
echo $trimmed = ltrim($image, "../properties").'<br />'; //display images
else
break;
}
Without this piece of code:

Code: [Select]
$newest_mtime = 0;
$image = 'BROKEN';
if ($handle = @opendir($dir)) {
while (false !== ($file = readdir($handle))) {
if (($file != '.') && ($file != '..')) {
$mtime = filemtime("$dir/$file");
if ($mtime > $newest_mtime) {
$newest_mtime = $mtime;
$image = "$file";
}
}
}
}
It shows the first 3 files alphabetically. I want to view the last number of images added.

With the above code it simply shows the last image added 3 times!

So I need to get the time each image was added and then order by the newest added and limit to the number of images uploaded. Any suggestions please?

Kindest regards
Glynn

i need to count the number of image files on a remote server not in my network.  ive come across a suggestion to use

@getimagesize($img_url)

the above works but is really slow.  anyone able to suggest a better method?

Hi I have the following code, this code is suppose to get the data from the galleries table and the pages table. I think my problem is the sql statement but I'm not sure.

Code: [Select]
public function galleries(){

foreach($this->_params['list'] as $gallery){
$id = $gallery['id'];
$name = $gallery['name'];


$select = "SELECT * FROM pages, galleries
WHERE pages.name = {$gallery['name']}";


$this->_params['item'] = $this->_model->get(array("pages.name = 'galleries.name'"));
   }

the code
Code: [Select]
$this->_params['item'] = $this->_model->get(array("pages.name = 'galleries.name'"));
works just fine with the home page and all the other pages.

I have 2 galleries called gallery 1 and gallery 2, now my problem is that I need the sql to go through the galleries table look for the name and then look through the pages table and get the meta data from the same name. There is no foreign id because I only need it for the galleries and nothing else.

Thank you

Hi,

I've been passed the below code which converts rss to php and then displays HTML. It works well.
However, I've 2 issues with it:
1) I'd like to set it so only say 5 posts are shown
2) How can I truncate the description, so it only shows say 100 chars or 20 words?

Any help is much appreciated.

Here's the code:

<?php

// DO NOT EDIT BELOW THIS LINE

date_default_timezone_set("GMT");

$itemArray = array();

if($text = preg_replace("/[\t\r\n]/", " ", htmlentities(@file_get_contents($rss_feed_url), ENT_QUOTES)))
{
while(strpos($text, "&acirc;") == true)
{
$text = substr($text, 0, strpos($text, "&acirc;")) ."'". substr($text, strpos($text, "&acirc;")+9, strlen($text));
}

$items = explode("<item>", html_entity_decode($text));

foreach($items as $item)
{
$title = "";
$link = "";
$desc = "";
$pubdate = "";
$image = "";

$item = html_entity_decode($item, ENT_QUOTES);
$item = preg_replace('/&(?!amp;|quot;|nbsp;|gt;|lt;|laquo;|raquo;|copy;|reg;|bul;|rsquo;|mdash;|#)/', '&amp;', $item); 
$item = str_replace("<![CDATA[","", $item);
$item = str_replace("]]>","", $item);

if(stripos($item, "</item>") == true)
{
if(preg_match('|<title>(.*)</title>|', $item, $match))
{
$title = $match[1];
}

if(preg_match('|<pubDate>(.*)</pubDate>|', $item, $match))
{
$pubdate = strtotime($match[1]);
}

if(preg_match('|url="(.*)|', $item, $match))
{
$search = $match[1];
$imageArray = explode('"', $search);
$image = $imageArray[0];
}

if(preg_match('|<description>(.*)</description>|', $item, $match))
{
$desc = $match[1];
$desc = strip_tags($desc);
}

if(preg_match('|<link>(.*)</link>|', $item, $match))
{
$link = $match[1];
$link = end(explode("*", $link));
}

if($title && $link && $desc)
{
array_push($itemArray, "$pubdate|$title|$link|$desc|$image|");
}
}
}
}
else
{
print "<p>Whoops! We could not connect to: <a href=\"$rss_feed_url\">$rss_feed_url</a></p>";
}

if(sort($itemArray))
{
foreach(array_reverse($itemArray) as $iA)
{
list($pubdate,$title,$link,$desc,$image) = explode("|", $iA);

$timenow = time();

$difference = $timenow-$pubdate;

$days = 0;
$hours = 0;
$minutes = 0;

print "<p>";

if($hotlink_images && $image)
{
if($open_links_in_new_window)
{
print "<a class=\"thumb\" href=\"$link\" onclick=\"openInNewWindow('$link'); return false\">" .
  "<img src=\"$image\" alt=\"$title\"></a>";
}
else
{
print "<a class=\"thumb\" href=\"$link\"><img src=\"$image\" alt=\"$title\"></a>";
}
}

if($open_links_in_new_window)
{
print "<a href=\"$link\" onclick=\"openInNewWindow('$link'); return false\">$title</a><br>";
}
else
{
print "<a href=\"$link\">$title</a><br>";
}

if($pubdate)
{
print "<span class=\"sub\">Posted ";

if(sprintf("%01.0d", $difference/(60*60*24)))
{
$days = sprintf("%01.0d", $difference/(60*60*24));
$difference -= $days*(60*60*24);

if($days > 1)
{
print "$days days ";
}
else
{
print "$days day ";
}
}

if(!(sprintf("%01.0d", $difference/(60*60*24))) && sprintf("%01.0d", $difference/(60*60)))
{
$hours = sprintf("%01.0d", $difference/(60*60));
$difference -= $hours*(60*60);

if($hours > 1)
{
print "$hours hours ";
}
else
{
print "$hours hour ";
}
}

if(!(sprintf("%01.0d", $difference/(60*60*24))) && sprintf("%01.0d", $difference/60))
{
$minutes = sprintf("%01.0d", $difference/60);

if($minutes > 1)
{
print "$minutes minutes ";
}
else
{
print "$minutes minute ";
}
}

print "ago</span><br>";
}

print "$desc</p>\n<div class=\"hr\">&nbsp;</div>\n";
}
}

?>

Thanks again

I set up the following code to successfully individual items based on the id number. ?id=1 etc.  However, I thought it would be simple to change to show another row so I changed all the terms to 'description'.  However, if I enter ?description=abcde it shows nothing.  But if I type in ?description=description is bizarrely shows everything.

The only thing I can only put it down to is numbers.  Does $_GET react differently react differently to numbers or does it require commas surrounding the string?




<?php
if( isset($_GET['description']))
$_GET['description'];
$query = "SELECT * FROM productfeed WHERE description = $description LIMIT 0, 10";
$fetchdata = mysql_query($query) or die("query: $query<br>This has an error: " . mysql_error() . '<br>');
while($row = mysql_fetch_array($fetchdata)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];





echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image'/></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
} 
?>

Hi

I am trying to pull title and meta description from an URL..

To pull the URL I am using the code from http://www.dreamincode.net/code/snippet4625.htm...
function getTitle($Url){
        $str = file_get_contents($Url);
        if(strlen($str)>0){
                preg_match("/\<title\>(.*)\<\/title\>/",$str,$title);
                return $title[1];
        }
}
//Example:
echo getTitle("http://www.cnn.com");

And to pull the meta description I am using the code from http://php.net/manual/en/function.get-meta-tags.php.
// Assuming the above tags are at www.example.com
$tags = get_meta_tags('http://www.cnn.com/')
 or die("Could not fetch meta tags");

// Notice how the keys are all lowercase now, and
// how . was replaced by _ in the key.
echo $tags['author'];      // name
echo $tags['keywords'];    // php documentation
echo $tags['description'];  // a php manual
echo $tags['geo_position']; // 49.33;-86.59

So my complete code looks like this:
<html>
<head>
</head>
<body>
<?php
function getTitle($Url){
        $str = file_get_contents($Url);
        if(strlen($str)>0){
                preg_match("/\<title\>(.*)\<\/title\>/",$str,$title);
                return $title[1];
        }
}
//Example:
echo getTitle("http://www.cnn.com");


// Assuming the above tags are at www.example.com
$tags = get_meta_tags('http://www.cnn.com/')
 or die("Could not fetch meta tags");

// Notice how the keys are all lowercase now, and
// how . was replaced by _ in the key.
echo $tags['author'];      // name
echo $tags['keywords'];    // php documentation
echo $tags['description'];  // a php manual
echo $tags['geo_position']; // 49.33;-86.59

?>
Test!
</body>
</html>

But it wont work... All I get is "Could not fetch meta tags".. I've tried different URLs and such but still wont work ..

Anyone have an idea?

so i set names for every pages, like

$pageName = 'home'; //index page

Code: [Select]
  if($pageName == 'categories'){
  $find = "Birds &amp; Bees";
  $result = strpos($title,$find);
  echo '1';
  }else if($pageName == 'categories'){
  $find1 = "Money &amp; Honey";
  $result = strpos($title,$find1);
  echo '2'; 
  }

now the issue is with categories.php page, which is just one page but displays different title and according to matching title i wish to change the description but its not happening, everywhere only 1 prints, why?

I have a website here [redacted] and it is an affiliate website where I just find products and promote them. All I have to do is give product a title, affiliate url, the description, an image and a price. I am trying to make the product description area hold more text than it does now, because at the moment in the admin side of my website it says "product description 275 max characters" That is really a short sentence. Can anyone please help me I have no php skills but really wish I did, if you need more info I will be happy to share anything I need to. 

Edited October 27, 2019 by requinix
removed link

hi all,   Firstly I am new to the php language, hopefully this is not a silly question or a no brainer.   I have looked over my code.. and for some reason when I insert data from a cms into a mySql database thers two fields that swop around..   HERES THE CODE IM WORKING WITH :

<?php

//if form has been submitted process it
if(isset($_POST['submit'])){

		$_POST = array_map( 'stripslashes', $_POST );

		//collect form data
		extract($_POST);

		//very basic validation
		if($title ==''){
			$error[] = 'Please enter the title.';
		}


		if(!isset($error)){

			try {

				//insert into database
				$stmt = $handler->prepare('INSERT INTO event_calendar (title,event_date,description) VALUES (:title, :description, :event_date)') ;
				$stmt->execute(array(
					':title' => $title,
					':description' => $description,
					':event_date' => date('Y-m-d')
				));

				//redirect to index page
				header('Location: index.php?action=added');
				exit;

			} catch(PDOException $e) {
			    echo $e->getMessage();
			}

		}

	}

	//check for any errors
	if(isset($error)){
		foreach($error as $error){
			echo '<p class="error">'.$error.'</p>';
		}
	}
	?>
	<form action='' method='post'>

		<p><label>Title</label>	<input type='text' name='title' value='<?php if(isset($error)){ echo $_POST['title'];}?>'></p>

		<p><label>Description</label><br />
		<textarea name='description' cols='50' rows='5'><?php if(isset($error)){ echo $_POST['description'];}?></textarea></p>

		<p><label>Date of Event : (y-m-d) :</label><input name="event_date" type="date" value='<?php if(isset($error)){ echo $_POST['event_date'];}?>'></p>

		<p><input type='submit' name='submit' value='Submit'></p>

	</form>

Could anyone please just look through it.. My database structure is simple.. id, title, description, event_date Thanks in advance  

G'day all, i've got this script that I found on the net some time back but not entirely sure where, however it works well except I want to add a feature so it shows the image details from a txt file. Here is the gallery script:

<?php

function getDirectory( $path = '.', $level = 0 ){ 
    $ignore = array( 'cgi-bin', '.', '..' ); 
    $dh = @opendir( $path ); 
    while( false !== ( $file = readdir( $dh ) ) ){ 
        if( !in_array( $file, $ignore ) ){ 
            if( is_dir( "$path/$file" ) ){ 
$dir = $path . $file; 
                echo "<h2>$file</h2><p>"; 
                $dh1 = @opendir( $dir ); 
                while( false !== ( $image = readdir( $dh1 ) ) ){ 
                    if( !in_array( $image, $ignore ) ){ 
                        if( !is_dir( "$dir/$image" ) ){ 
      if (preg_match("/.jpg/", $image)) {
echo "<a href=\"$dir/$image\" rel=\"lightbox\"><img src=\"gallery-thumbnail.php?file=$file/$image\" border=2 style='border-color: #981C1E'></a>\n"; 
}
                        } 
                    } 
                } 
echo "</p>";
                $level++; 
            } 
        } 
    } 
    closedir( $dh ); 
} 
getDirectory('gallery/'); 
?>


Now, what i'm wanting is to read a txt file either in the root or 'gallery' directory, where it has the file name, title, description, photographer. (something like filename.jpg|title of image|description about image|J King).
so when the image is displayed, a script reads the text file and will show the image info beside it.

Now i've got this bit of snippet from an old script I used once, but can't seem to get it to work anywhere, so any help is greatly appreciated.

$text = "gallery.txt";

$fh=fopen($text, "r"); 

while(!feof($fh)) 
{ 
  $temp = explode("|", $line); 
  $title[$temp[0]] = $temp[1];
  $description[$temp[0]] = $temp[2];
  $photographer[$temp[0]] = $temp[3];
  $line=fgets($fh); 
  unset($temp); 
} 

On the index page of http://www.sportskevesti.co i have the meta tags of Title, Description, Keyword.... and other element, but it is necessary to show them in name of the other pages, socer, basketbal, handbal, tennis...., and there fore news spetial.

in this moment, i have this meta tag double.

for example:

www.sportskevesti.co/index.php
Quote

<meta name="title" content="Sportske Vesti">
<meta name="description" content="Najnovije sportske vesti iz Srbije i ostatka sveta. Sve na jednom mestu.">
<meta name="keywords" content="sport, vesti, fudbal, tenis, kosarka, odbojka, rukomet, auto, moto, trke">



http://sportskevesti.co/index.php?opcija=vest&vest_id=60067
Quote

<meta name="title" content="Sportske Vesti">
<meta name="description" content="Najnovije sportske vesti iz Srbije i ostatka sveta. Sve na jednom mestu.">
<meta name="keywords" content="sport, vesti, fudbal, tenis, kosarka, odbojka, rukomet, auto, moto, trke">

<meta name="title" content="Danas je derbi!" />
<meta name="description" content="Na stadionu Crvene zvezde danas se igra ..." />
<meta name="keywords" content="danas, derbi, "/>



Since I assume that this is not good for SEO optimization, how to avoid this and show only one meta per page ?