PHP - Failed To Open Stream (everythings Correct)

Here is my code, below. It is gathering the $url with the corret images. But poduces and error on line 50. Failed to open stream. No such file or directory.

By this line:     readfile($file_name);

What Am I missing, beyond strong programmer mind set.

Code: [Select]

$merch_map = "http://spot_map";
$dir = "/opt/digistrive/tmp/media/current";


class merch_imgs {
public function __construct() {
$this->merch_imgs1();
}
public function __call($method, $_) {
$count = str_replace('merch_imgs', '', $method);
echo "$count ";
$this->{"merch_imgs" . ++$count}();

}
}
class thousand_printer extends merch_imgs {
public function merch_imgs1000() {}
}



//03-2012. Location of merchant, if no image use place holder
$thumbnails = implode(',', range(1, 10000));
$ext = ".png";
for($thumbnails = 0; $thumbnails < 10000; $thumbnails++) {
$url = $merch_map.'/'.$thumbnails.''.$ext;   

echo $url . '<br>';
    //echo '<img src='.$url.' border=0/>';
   downloader($url, $dir);
}



function downloader($url){
    $file_name = basename($url);
    $generated_files = geturl($url, $url);
    //file_put_contents($file_name);
file_put_contents($url, $url = var_export($file_name,true));
$size=strlen($generated_files);
if($size==0){exit(0);("<b>Error:</b>not found!");}
//header('Content-type: application/force-download');
    //header('Content-Disposition: attachment; filename=' . $file_name);
    //header('Content-Transfer-Encoding: binary');
    //header('Expires: Sat, 26 Jul 1997 05:00:00 GMT');
    //header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    //header('Pragma: public');
    //header('Content-Length: ' . $size);
    readfile($file_name);
    unlink($file_name);
}

function geturl($url, $referer) {
    $headers[] = 'Accept: image/png';
    $headers[] = 'Connection: Keep-Alive';
    $headers[] = 'Content-type: application/x-www-form-urlencoded;charset=UTF-8';
    $user_agent = 'ONLY_MY_HOST';
//$useragent = $url;
    $process = curl_init($url);
    curl_setopt($process, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($process, CURLOPT_HEADER, 0);
    curl_setopt($process, CURLOPT_USERAGENT, $user_agent);
    curl_setopt($process, CURLOPT_REFERER, $referer);
    curl_setopt($process, CURLOPT_TIMEOUT, 30);
    curl_setopt($process, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($process, CURLOPT_FOLLOWLOCATION, 1);
    $return = curl_exec($process);
    curl_close($process);
    return $return;
}







//downloader($dir, $url);



//Merchant Images
if($url && $user_agent){
file_get_contents($url);
die();
}

Hello, this is my first post I hope you guys can help me out here, basically whats going on is I declare a variable "$diree" then I insert it in a function  but its not getting recognized, here is the code:

$institutea "some directory";
$dire = str_replace(" ","-",$institutea);


   # SETTINGS
   $max_width = 110;
   $max_height = 130;
   
   $per_page = 5;
   $page = $_GET['page'];
   
   $has_previous = false;
   $has_next = false;
   
   function getPictures() {
      global $page, $per_page, $has_previous, $has_next;
      if ( $handle = opendir($diree.'/') ) { // done changes here
         $lightbox = rand();
?><table border="1"><tr><td>
         <form action="pro.php" method="post">
      
            
            
         <?php
         echo "<ul id='pictures'>";
         
         $count = 1;
         $skip = $page * $per_page;

         if ( $skip != 0 )
            $has_previous = true;
         
         while ( $count < $skip && ($file = readdir($handle)) !== false ) {
            if ( !is_dir($file) && ($type = getPictureType($file)) != '' )
               $count++;
         }
         $count = 1;
         while ( $count < $per_page && ($file = readdir($handle)) !== false ) {
            if ( !is_dir($file) && ($type = getPictureType($file)) != '' ) {
            
               if ( ! is_dir($dire .'/') ) {  // done changes here
                  mkdir($dire .'/'); // done changes here
               }
               if ( ! file_exists($dire .'/'.$file) ) {
                  makeThumb( $file, $type );
               }
               
               
               echo '<li>';
               echo '<img src="'.$dire .'/'.$file.'" alt="" / width="110" height="110"><br/><input type="checkbox" name="food[]" value='.$file.'>'; // done changes here
               echo '</li>';
               
               $count++;

            }
         }
         echo '</ul>';
         ?>
            </td></tr><tr><td><div align="center"><input type="submit" value="Add"></div></td></tr>
</tr></table></form>
               <?php
         while ( ($file = readdir($handle)) !== false ) {
            if ( !is_dir($file) && ($type = getPictureType($file)) != '' ) {
               $has_next = true;
               break;
            }
         }
      }
   }
   
   function getPictureType($file) {
      $split = explode($dire .'/', $file);
      $ext = $split[count($split) - 1];
      if ( preg_match('/jpg|jpeg/i', $ext) ) {
         return 'jpg';
      } else if ( preg_match('/png/i', $ext) ) {
         return 'png';
      } else if ( preg_match('/gif/i', $ext) ) {
         return 'gif';
      } else {
         return '';
      }
   }
   
   function makeThumb( $file, $type ) {
      global $max_width, $max_height;
      if ( $type == 'jpg' ) {
         $src = imagecreatefromjpeg($file);
      } else if ( $type == 'png' ) {
         $src = imagecreatefrompng($file);
      } else if ( $type == 'gif' ) {
         $src = imagecreatefromgif($file);
      }
      if ( ($oldW = imagesx($src)) < ($oldH = imagesy($src)) ) {
         $newW = $oldW * ($max_width / $oldH);
         $newH = $max_height;
      } else {
         $newW = $max_width;
         $newH = $oldH * ($max_height / $oldW);
      }
      $new = imagecreatetruecolor($newW, $newH);
      imagecopyresampled($new, $src, 0, 0, 0, 0, $newW, $newH, $oldW, $oldH);
      if ( $type == 'jpg' ) {
         imagejpeg($new, $dire .'/'.$file);
      } else if ( $type == 'png' ) {
         imagepng($new, $dire .'/'.$file);
      } else if ( $type == 'gif' ) {
         imagegif($new, $dire .'/'.$file);
      }
      imagedestroy($new);
      imagedestroy($src);
   }
?>

Hello there.
I used this code so many times long ago, but I still don't remeber and don't know what I'm doing wrong.
http://circus.ka-blooey.net/

If I try to click on any link below the post, I got the error:
Code: [Select]
Warning: include(.php) [function.include]: failed to open stream: No such file or directory in /home/kablooey/public_html/circus/index.php on line 5

Warning: include(.php) [function.include]: failed to open stream: No such file or directory in /home/kablooey/public_html/circus/index.php on line 5

Warning: include() [function.include]: Failed opening '.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kablooey/public_html/circus/index.php on line 5
-----------------------x

My index is:

Code: [Select]
<?php
include("header.php");
?>

<? if (empty($_GET["boo"])) {$boo="news/show_news";} include "$boo.php"; ?>

<?php
include("footer.php");
?>
and the footer, where the links are is:

Code: [Select]
<br />
<div id="menu"><center><a href="http://circus.ka-blooey.net">clear</a> ---x--- <a href="?boo=out">links out</a> ---x--- <a href="?boo=credits">credits</a></center></div><br />
<br />
<br />
<div id="footer"><img src="http://circus.ka-blooey.net/layout/circus_footer.jpg" /></div>
</div>
</div>
</div>

</body>
</html>
Help please? =/

Hi Guys!

I'm new here at PHPFreaks, I have this problem using simplexml_load_file function.

I am retrieving an XML from another sub-domain of my project, it's working fine on my local server (win xp, php 5.2.14) but when I try to execute it on our testing server (linux, php 5.2.14) it returns an error something like this..

Warning: simplexml_load_file([url of the script]) [function.simplexml-load-file]: failed to open stream: Connection timed out in [absolute path of the script] on line 3

i have tried cURL and file_get_contents, still get no luck.

please note that the XML is validated via w3c.org and works really fine on my local server..

Thanks in advanced!

I'm trying to copy an existing file using a php script, run on the command line.
I've tried copy() and also a script from the comments on copy() http://www.php.net/manual/en/function.copy.php#102320

No matter how I try to open the file I get " failed to open stream: No such file or directory".
I tried changing the name of the file, and the ext, and both.
The file does exist, and if I run cp old new, the file gets copied fine.

Current code
Code: [Select]
<?php
$source = '/www/documents/myfile.pdf';
$destination = '/www/documents/mypdf.pdf.bak';
copy($source, $destination);
?>

Warning: copy(/www/documents/myfile.pdf): failed to open stream: No such file or directory in /www/cron/historic.php on line 3

Code: [Select]
~$ ls /www/hua/compucom113dev/client/documents/
myfile.pdf
~$ cp /www/documents/myfile.pdf /www/documents/myfile.pdf.bak
~$ ls /www/hua/compucom113dev/client/documents/
myfile.pdf
myfile.pdf.bak

I had chmod in the script at one point to make sure the directory had the permissions needed but it didn't make a difference so I removed it. I can add it back if someone can help explain what to set it to. I was doing 0777 then back to 0755 at the end.

Hi there,

I'm a .net developer and I've inherited a partially complete php project. I'm trying get part of it running on my pc and am running into some issues due to my fairly limited knowledge with php/apache web server.

I'm using Windows Vista, I have Apache HTTP server 2.2 running and am using PHP 5.2.17.

The aim is to send some data to the web server.

I'm using this function below -

public static function push_data($data)
{
$data = base64_encode(gzdeflate(ot::encrypt(serialize($data), otCRYPT_KEY), 9));
      $data = http_build_query(array(otDATA_KEY => $data));
      $opts = array (
         'http' => array (
            'method' => 'POST',
            'header'=> "Content-type: application/x-www-form-urlencoded\r\n"
               . "Content-Length: " . strlen($data) . "\r\n",
            'content' => $data
         )
      );
      $ctx = stream_context_create($opts);
      return file_get_contents(otDATA_URL, 0, $ctx);
   }

And am getting this message back -

PHP Warning: file_get_contents(http://localhost/Epointment/ot/backend/data.php): failed to open stream: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host failed to respond.

I've echoed $ctx and get Resource ID #15
and echoed otDATA_URL and get http://localhost/Epointment/ot/backend/data.php, which is correct.

I've run a test php script actually on the web server and it works, so at least I know the server is running
and PHP works on it.

I'm not sure if this is an issue with the Apache settings or the PHP script or php.ini settings

thanks for any help,

Hi I am really frustrated because I got my php code working fine and then I had to make some minor changes to my html form and now the php is not working. I am reciec=ving this message:

Warning: move_uploaded_file(upload/carey.bmp) [function.move-uploaded-file]: failed to open stream: No such file or directory in /home/content/19/6550319/html/ipad/listing.php on line 35

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpIEUQLo' to 'upload/carey.bmp' in /home/content/19/6550319/html/ipad/listing.php on line 35
Sorry, there was a problem uploading your file.03/10/11 : 20:50:08

I wrote it twice because it keeps coming out twice. I guess it means that it cant upload the image because there is no image but I really dont understand why. I havent changed the image part of the form. Does anyone have any ideas? It is much appreciated.

Here is the code

Code: [Select]
<?php




//This is the directory where images will be saved
$target = "upload/";
$target = $target . basename( $_FILES['photo']['name']);

//This gets all the other information from the form
$price=$_POST['price'];
$pic=($_FILES['photo']['name']);
$pic2=($_FILES['phototwo']['name']);
$pic3=($_FILES['photothree']['name']);
$pic4=($_FILES['photofour']['name']);
$description=$_POST['iPadDescription'];
$condition=$_POST['condition'];
$gig=$_POST['giga'];
$yesg=$_POST['yesg'];
$fname=$_POST['firstName'];
$lname=$_POST['lastName'];
$email=$_POST['email'];



// Connects to your Database
mysql_connect ("taken out for security", "taken out", "taken out") or die(mysql_error()) ;
mysql_select_db("taken out") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO ipadlist (price,photo,phototwo,photothree,photofour,iPadDescription,condition,giga,yesg,firstName,lastName,email)
VALUES ('$price', '$pic', '$pic2', '$pic3', '$pic4', '$description', '$condition', '$gig', '$yesg', '$fname', '$lname', '$email')") ;

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}

echo date("m/d/y : H:i:s", time()) 


?>

Hi,   I hope someone can help. I am fairly new to php and have the following problem that I cannot get a solution for.   We are building a logon system for a website and are receiving the following error.   ?>PHP Warning: require_once(classes/Config.php): failed to open stream: No such file or directory in C:\Domains\hellopoker.co.za\wwwroot\test\php\core\init.php on line 22 PHP Fatal error: require_once(): Failed opening required 'classes/Config.php' (include_path='.;C:\php\pear') in C:\Domains\hellopoker.co.za\wwwroot\test\php\core\init.php on line 22     Code for index.php   <?php

require_once 'core/init.php';

echo Config::get('mysql/host');

?>
  Code for config.php   <?php

class Config{
    public static function get ($path = null){
        if ($path){
            $config = $GLOBALS['config'];
            $path = explore('/',$path);
            
            foreach($path as $bit){
                if(isset($config[$bit])){
                    echo 'Set';
                }
            }
        }
    }

}

?>     Code for init.php     <?php

session_start();

$GLOBALS['config'] = array(
    'mysql' => array(
        'mysql' => 'xxxxxxx',
        'username' => 'xxxxxx',
        'password' => 'xxxxxxx',
        'db' => 'xxxxxxx'
        ),
        'remember' => array(
            'cookie_name' => 'hash',
            'cookie_expiry' => 604800
        ),
        'session' => array(
            'session_name' => 'user'
        )
);

spl_autoload_register(function($class) {
    require_once 'classes/' . $class . '.php';
});

?>



?>     Any help will be greatly be appreciated.    

The Script:

<?php
if (isset($_POST['submit'])) {
    $j = 0; //Variable for indexing uploaded image 
    
	$target_path = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/uploads/"; //Declaring Path for uploaded images

    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {//loop to get individual element from the array

        $validextensions = array("jpeg", "jpg", "png");  //Extensions which are allowed
        $ext = explode('.', basename($_FILES['file']['name'][$i]));//explode file name from dot(.) 
        $file_extension = end($ext); //store extensions in the variable

        $new_image_name = md5(uniqid()) . "." . $ext[count($ext) - 1];
		$target_path = $target_path . $new_image_name;//set the target path with a new name of image
        $j = $j + 1;//increment the number of uploaded images according to the files in array       
      
	  if (($_FILES["file"]["size"][$i] < 100000) //Approx. 100kb files can be uploaded.
                && in_array($file_extension, $validextensions)) {
            if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $target_path)) {//if file moved to uploads folder
                echo $j. ').<span id="noerror">Image uploaded successfully!.</span><br/><br/>';



                for ($i = 0; $i < count($_FILES['file']['name']); $i++) {
                    $tqs = "INSERT INTO images (`original_image_name`, `image_file`, `date_created`) VALUES ('" . $_FILES['file']['name'][$i] . "', '" . $new_image_name  . "', now())";
                    $tqr = mysqli_query($dbc, $tqs);
                }



                // To create the thumbnails.
                function make_thumb($src, $dest, $desired_width) {

                    /* read the source image */
                    $source_image = imagecreatefromjpeg($src);
                    $width = imagesx($source_image);
                    $height = imagesy($source_image);

                    /* find the "desired height" of this thumbnail, relative to the desired width  */
                    $desired_height = floor($height * ($desired_width / $width));

                    /* create a new, "virtual" image */
                    $virtual_image = imagecreatetruecolor($desired_width, $desired_height);

                    /* copy source image at a resized size */
                    imagecopyresampled($virtual_image, $source_image, 0, 0, 0, 0, $desired_width, $desired_height, $width, $height);

                    /* create the physical thumbnail image to its destination */
                    imagejpeg($virtual_image, $dest);
                }


                $src = $target_path;

                $dest = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/thumbs/";

                $desired_width = 100;

                make_thumb($src, $dest, $desired_width);




            } else {//if file was not moved.
                echo $j. ').<span id="error">please try again!.</span><br/><br/>';
            }
        } else {//if file size and file type was incorrect.
            echo $j. ').<span id="error">***Invalid file Size or Type***</span><br/><br/>';
        }
    }

}


?>

With this:

$dest = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/thumbs/";

I get this error message:

Warning: imagejpeg(C:/xampp/htdocs/gallerysite/multiple_image_upload/thumbs/): failed to open stream: No such file or directory in C:\xampp\htdocs\gallerysite\multiple_image_upload\upload.php on line 49

With this:

$dest = "http://localhost/gallerysite/multiple_image_upload/thumbs/";

I get this error message:

Warning: imagejpeg(http://localhost/gallerysite/multiple_image_upload/thumbs/): failed to open stream: HTTP wrapper does not support writeable connections in C:\xampp\htdocs\gallerysite\multiple_image_upload\upload.php on line 49

When I try deleting the "thumbs" folder and then try to upload an image, then I get this error message:

Warning: imagejpeg(C:/xampp/htdocs/gallerysite/multiple_image_upload/thumbs/): failed to open stream: Invalid argument in C:\xampp\htdocs\gallerysite\multiple_image_upload\upload.php on line 49

The spot of line 49 is this, at the spot where the script creates the thumbnails:

/* create the physical thumbnail image to its destination */
                    imagejpeg($virtual_image, $dest);
                }

Also, with this part right here I am not getting an error message, which means that this part works fine in comparison:

$target_path = $_SERVER['DOCUMENT_ROOT'] . "/gallerysite/multiple_image_upload/uploads/"; //Declaring Path for uploaded images

The script itself works fine. The script also uses javascript for multiple image upload.   I am using XAMPP. The folder "thumbs" is set to "read-only", when I try to uncheck the "read-only" option in the properties in Windows then it sets itself back again to "read-only". Then again, the script works fine when it comes to the "uploads" folder. This is mentioned in comparison to the "thumbs" folder.   Any suggestions on how to solve this?   EDIT:   I am using XAMPP. The folder "thumbs" is set to "read-only", when I try to uncheck the "read-only" option in the properties in Windows then it sets itself back again to "read-only". I am wondering if I would have issue that the option sets itself back again with Linux?
Edited by glassfish, 11 October 2014 - 05:35 PM.

Hey all,

I viewed this tutorial and the guy used $_SERVER['DOCUMENT_ROOT'] to reference a view layout for his specific index file. So I tried to imitate and did exactly what he did, but for me I got the following error:
Code: [Select]
Warning: include(/Users/jmerlino/Sites/mark/public/diet/views/layouts/shop.php) [function.include]: failed to open stream: No such file or directory in /Users/jmerlino/Sites/diet/index.php on line 22

Warning: include() [function.include]: Failed opening '/Users/jmerlino/Sites/mark/public/diet/views/layouts/shop.php' for inclusion (include_path='.:/usr/lib/php') in /Users/jmerlino/Sites/diet/index.php on line 22
This is the php code that is causing this error:

include($_SERVER['DOCUMENT_ROOT'].'/'.'diet/views/layouts/'.$controller.'.php');

I'm not sure why it's going to:
/Users/jmerlino/Sites/mark/public/diet/views/layouts/shop.php
instead of:
/Users/jmerlino/Sites/diet/views/layouts/shop.php

Thanks for any response

My images generator comprises an array of image names extracted form an images table from a database using a select statement a random number generator, and a string that builds the correct pathname for the selected file. To select one of the images for display, i generate a random number between 1 and the length of the array. Though the generator is working, I noticed one of the random numbers is throwing up this error: Warning: getimagesize(images/): failed to open stream: No such file or directory in An inspection of the array reveals 2 array elements (representing my number of images) but one array element is NULL ( the first entry in the banner table   image_generator.php

require_once('connection.inc.php');
    $sql = 'SELECT `filename` FROM  banner';
    $result = $mysqli->query($sql, MYSQLI_STORE_RESULT) or die(mysqli_error());
    $row = $result->fetch_array(MYSQLI_ASSOC);//an array of image names
    $count = $result->num_rows;
    for ($i = 1; $i <= $count; ++$i) 
    {
       $row[$i] = $result->fetch_array(MYSQLI_ASSOC);
    }
    $i = rand(1, $count); //a random number generator,
       //The random number is used in the final line to build the correct pathname for the selected file.
       $selectedImage = "images/{$row[$i]['filename']}"; 
      if (file_exists($selectedImage) && is_readable($selectedImage)) 
      {
        $imageSize = getimagesize($selectedImage);
      }

var_dump($row)

array (size=1)
    'filename' => string 'ginsomin2.jpg' (length=13)
    null

RANDON IMAGE DISPLAY

require_once 'image_generator.php';
<div id="banner" class="wrapper clearfix">
      <img src="<?php echo $selectedImage; ?>" alt="banner">
   </div>

Kindly advice how i may proceed from here? Thanks.

I'm getting this error when I try to fwrite to a directory:
Quote

failed to open stream: Permission denied



I have added the user www-data to the group which has permission to the directory?

The directory is this:
/home/directory1/documents

directory1 = drwxr-x---
documents = drwxrwx---

Does anyone know whats going on?

It's pretty simple to see what I am trying to do here. For some reason all results in the table are the same exact cityName replacing all existing records. The echoed results are correct. I've include a small dump of my table as well.

$query = "SELECT cityName FROM sys_city_dev_2";
      $resource = mysqli_query($cxn, $query) or die("MySQL error: " . mysqli_error($cxn) . "<hr>\nQuery: $query");
      
  while($result = mysqli_fetch_assoc($resource)) {

          $nox = $result['cityName'];

          $toUpper = ucfirst($nox);
  echo "$toUpper" . "<br />";

          $setString = "UPDATE sys_city_dev_2 SET cityName = '" . $toUpper ."' WHERE cityName != ''";
          mysqli_query($cxn,$setString);


      } 

100 Records of table dump (pre running my script above):

--
-- Table structure for table `sys_city_dev_2_backup`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev_2_backup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev_2_backup`
--

INSERT INTO `sys_city_dev_2_backup` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'dothan', 0, 0, 0),
(84011, 1, 'alabaster', 0, 0, 0),
(84012, 1, 'birmingham', 0, 0, 0),
(84013, 2, 'flagstaff', 0, 0, 0),
(84014, 1, 'auburn', 0, 0, 0),
(84015, 1, 'florence', 0, 0, 0),
(84016, 1, 'gadsden', 0, 0, 0),
(84017, 1, 'huntsville', 0, 0, 0),
(84018, 1, 'mobile', 0, 0, 0),
(84019, 1, 'montgomery', 0, 0, 0),
(84020, 1, 'tuscaloosa', 0, 0, 0),
(84021, 2, 'mohave valley', 0, 0, 0),
(84022, 2, 'phoenix', 0, 0, 0),
(84023, 2, 'prescott', 0, 0, 0),
(84024, 2, 'sierra vista', 0, 0, 0),
(84025, 2, 'tucson', 0, 0, 0),
(84026, 2, 'yuma', 0, 0, 0),
(84027, 3, 'bakersfield', 0, 0, 0),
(84028, 3, 'chico', 0, 0, 0),
(84029, 3, 'fresno / madera', 0, 0, 0),
(84030, 3, 'gold country', 0, 0, 0),
(84031, 3, 'humboldt county', 0, 0, 0),
(84032, 3, 'imperial', 0, 0, 0),
(84033, 3, 'inland empire', 0, 0, 0),
(84034, 3, 'los angeles', 0, 0, 0),
(84035, 3, 'alhambra', 0, 0, 0),
(84036, 3, 'merced', 0, 0, 0),
(84037, 49, 'fayetteville', 0, 0, 0),
(84038, 49, 'fort smith', 0, 0, 0),
(84039, 49, 'jonesboro', 0, 0, 0),
(84040, 49, 'little rock', 0, 0, 0),
(84041, 49, 'arkadelphia', 0, 0, 0),
(84042, 49, 'texarkana', 0, 0, 0),
(84043, 3, 'modesto', 0, 0, 0),
(84044, 3, 'alta sierra', 0, 0, 0),
(84045, 3, 'alpine', 0, 0, 0),
(84046, 3, 'pedley', 0, 0, 0),
(84047, 3, 'redding', 0, 0, 0),
(84048, 3, 'alondra park', 0, 0, 0),
(84049, 3, 'sacramento', 0, 0, 0),
(84050, 4, 'canon city', 0, 0, 0),
(84051, 3, 'san luis obispo', 0, 0, 0),
(84052, 3, 'santa barbara', 0, 0, 0),
(84053, 3, 'stockton', 0, 0, 0),
(84054, 3, 'aliso viejo', 0, 0, 0),
(84055, 3, 'visalia', 0, 0, 0),
(84056, 3, 'yuba city', 0, 0, 0),
(84057, 4, 'boulder', 0, 0, 0),
(84058, 4, 'colorado springs', 0, 0, 0),
(84059, 4, 'denver', 0, 0, 0),
(84060, 4, 'applewood', 0, 0, 0),
(84061, 4, 'pueblo', 0, 0, 0),
(84062, 4, 'air force academy', 0, 0, 0),
(84063, 5, 'avon', 0, 0, 0),
(84064, 5, 'hartford', 0, 0, 0),
(84065, 5, 'new haven', 0, 0, 0),
(84066, 5, 'ansonia', 0, 0, 0),
(84067, 5, 'fairfield', 0, 0, 0),
(84068, 7, 'daytona beach', 0, 0, 0),
(84069, 7, 'sebastian', 0, 0, 0),
(84070, 5, 'wallingford center', 0, 0, 0),
(84071, 8, 'belvedere park', 0, 0, 0),
(84072, 7, 'sarasota springs', 0, 0, 0),
(84073, 7, 'sandalfoot cove', 0, 0, 0),
(84074, 7, 'san carlos park', 0, 0, 0),
(84075, 7, 'st. augustine', 0, 0, 0),
(84076, 7, 'tallahassee', 0, 0, 0),
(84077, 7, 'safety harbor', 0, 0, 0),
(84078, 7, 'ruskin', 0, 0, 0),
(84079, 8, 'athens-clarke county', 0, 0, 0),
(84080, 8, 'atlanta', 0, 0, 0),
(84081, 8, 'augusta-richmond county', 0, 0, 0),
(84082, 8, 'brunswick', 0, 0, 0),
(84083, 8, 'columbus', 0, 0, 0),
(84084, 8, 'americus', 0, 0, 0),
(84085, 8, 'acworth', 0, 0, 0),
(84086, 8, 'valdosta', 0, 0, 0),
(84087, 10, 'boise', 0, 0, 0),
(84088, 10, 'ammon', 0, 0, 0),
(84089, 10, 'moscow', 0, 0, 0),
(84090, 10, 'blackfoot', 0, 0, 0),
(84091, 10, 'twin falls', 0, 0, 0),
(84092, 10, 'meridian', 0, 0, 0),
(84093, 10, 'jerome', 0, 0, 0),
(84094, 10, 'idaho falls', 0, 0, 0),
(84095, 11, 'addison', 0, 0, 0),
(84096, 10, 'garden city', 0, 0, 0),
(84097, 10, 'eagle', 0, 0, 0),
(84098, 10, 'chubbuck', 0, 0, 0),
(84099, 10, 'caldwell', 0, 0, 0),
(84100, 12, 'bloomington', 0, 0, 0),
(84101, 12, 'evansville', 0, 0, 0),
(84102, 12, 'fort wayne', 0, 0, 0),
(84103, 12, 'indianapolis', 0, 0, 0),
(84104, 12, 'muncie / anderson', 0, 0, 0),
(84105, 12, 'lafayette / west lafayette', 0, 0, 0),
(84106, 12, 'south bend / michiana', 0, 0, 0),
(84107, 12, 'terre haute', 0, 0, 0),
(84108, 12, 'northwest indiana', 0, 0, 0),
(84109, 13, 'ames', 0, 0, 0);

I am creating a stream for my website similar to facebook's news feed where users can post to, add photos too ect.

When a user uploads a photo it gets added to the photos table and a new row to the stream

Code: [Select]
mysql_query("INSERT INTO photos VALUES ('','$id','$username','$photo','$time')");
mysql_query("INSERT INTO stream VALUES ('','$id','$username','$time','No comment','$photo','')");

Which displays the image on the stream fine but what i am looking to do is if the user uploads more images one after another instead of adding a new post to the stream for every picture i want to show all of the new pictures in one post like what Facebook does. I can't figure out how i would do this.