Beg PHP6-Ch7, pg 180-181

drgnhiker · March 5th, 2010, 05:09 PM

Code is posted below but here is/are the problem(s):

This is the error message I get when I run check_image.php

Fatal error: Call to undefined function mysql_insert_is() in C:\wamp\www\htdocs\check_image.php on line 72

When I view source on the error page this is what I get.

 
Notice: Undefined index: uploadfile in C:\wamp\www\htdocs\check_image.php on line 10 
 
Notice: Undefined index: caption in C:\wamp\www\htdocs\check_image.php on line 37 
 
Notice: Undefined index: username in C:\wamp\www\htdocs\check_image.php on line 38 
 
Fatal error: Function name must be a string in C:\wamp\www\htdocs\check_image.php on line 39 

My thanks to anyone who can assist.....

Code:

<?php
$db = mysql_connect('localhost', 'bp6am', 'bp6ampass') or
    die ('Unable to connect. Check your connection parameters.');
  mysql_select_db('moviesite', $db) or die(mysql_error($db));

//this path is for the image directory
$dir ='C:/wamp/www/htdocs/images';

//ensure uploaded file transfer was successful - line 9
if ($_FILES['uploadfile']['error'] !=UPLOAD_ERR_OK) {
    switch ($_FILES['uploadfile']['error']) {
    case UPLOAD_ERR_INI_SIZE:
        die('The uploaded file exceeds the upload_max_filesize directive ' . 'in php.ini.');
      break;
    case UPLOAD_ERR_FORM_SIZE:
        die('The uploaded file exceeds the MAX_FILE_SIZE directive that ' . 'was specified in the HTML            form');
      break;
    case UPLOAD_ERR_PARTIAL_SIZE:
        die('The uploaded file was only partially uploaded.');
      break;
    case UPLOAD_ERR_NO_FILE:
        die('No file was uploaded.');
      break;
    case UPLOAD_ERR_NO_TMP_DIR:
        die('The server is missing a temporary file.');
      break;
    case UPLOAD_ERR_CANT_WRITE:
        die('The server failed to write the uploaded file to disk.');
      break;
    case UPLOAD_ERR_EXTENSION:
        die('File upload stopped by extension.');
      break;
    }
  }

//get info about the image being uploaded - line 36
$image_caption = $_POST['caption'];
$image_username = $_POST['username'];
$image_date = date('Y-m-d');
list($width, $height, $type, $attr) = 
    getimagesize($_FILES['uploadfile']['tmp_name']);

//make sure the uploaded file is really a supported image - line 42
switch ($type) {
case IMAGETYPE_GIF:
    $image = imagecreatefromgif($_FILES['uploadfile']['tmp_name']) or
        die('The file you uploaded was not a supported filetype.');
    $ext = '.gif';
    break;
case IMAGETYPE_JPEG:
    $image = imagecreatefromjpeg($_FILES['uploadfile']['tmp_name']) or
        die('The file you uploaded was not a supported filetype.');
    $ext = '.jpg';
    break;
case IMAGETYPE_PNG:
    $image = imagecreatefromjpeg($_FILES['uploadfile']['tmp_name']) or
        die('The file you uploaded was not a supported filetype.');
    $ext = '.png';
    break;
default:
     die('The file you uploaded was not a supported filetype.');
}

//insert information into image table - line 62
$query = 'INSERT INTO images
    (image_caption, image_username, image_date)
VALUES
    ("' . $image_caption . '", "' . $image_username . '", "' . $image_date . '")';
$result = mysql_query($query, $db) or die (mysql_error($db));

//retrieve the image_id that MYSQL generated automatically when we inserted the new record
$last_id = mysql_insert_is();

//because the id is unique, we can use it as the image name too and to make sure we don't 
//overwrite another image that already exists - line 72
$imagename = $last_id . $ext;

//update the image table now that the final filename is known
$query = 'UPDATE images
    SET image_filename = "' . $imagename .'"
    WHERE image_id = ' . $last_id;
$result = mysql_query($query, $db) or die (mysql_error($db));

//save the image to its final destination - line 81
switch ($type) {
case IMAGETYPE_GIF:
    imagegif($image, $dir . '/' . $imagename);
    break;
case IMAGETYPE_JPEG:
    imagejpeg($image, $dir . '/' . $imagename, 100);
    break;
case IMAGETYPE_PNG:
    imagepng($image, $dir . '/' . $imagename);
    break;
}
imagedestroy($image);
?>
<html>
 <head>
  <title>Here is your picture!</title>
 </head>
 <body>
  <h1>So how does it feel to be famous?</h1>
  <p>Here is the picture upi just uploaded:</p>
   <img src="images/<?php echo $imagename; ?>" style="float:left;">
  <table>
   <tr><td>Image saved as: </td><td><?php echo $imagename; ?></td></tr>
   <tr><td>Image type: </td><td><?php echo $ext; ?></td></tr>
   <tr><td>Image height: </td><td><?php echo $height; ?></td></tr>
   <tr><td>Image width: </td><td><?php echo $width; ?></td></tr>
   <tr><td>Image upload date: </td><td><?php echo $image_date; ?></td></tr>
  </table>
 </body>
</html>

PeterPeiGuo · March 23rd, 2010, 09:10 PM

mysql_insert_id(), not mysql_insert_is().

drgnhiker · March 23rd, 2010, 09:43 PM

and thanks again.....i had given up on this and went on to the next set of lessons......i'm going to fix it right now.....Thanks again