image contraining

[deansaddigh]

I have an upload script which uploads photos.

 

However i want them to all be resized to the same size, as at the moment im having to manually hardcode the dimensions when i want to show them on the front end.

 

Heres my code

 

<?php
    include("includes/connection.php");

    // Where the file is going to be placed 
    $schoolimage = "SchoolImages/";
    
    //This path will be stored in the database as it does not contain the filename
    $currentdir = getcwd();
    $path = $currentdir . '/' . $schoolimage;
    
    // Get the schoolid for the image and school linker table
    $schoolid = $_POST['schoolid'];
    
    //Get the school name
    $query = "SELECT * FROM school WHERE school_id = ".$schoolid;
    $result = mysql_query($query) 
        or die("Error getting school details");
    $row = mysql_fetch_assoc($result);
    $schoolname = $row['name']; 
        
    //Use this path to store the path of the file in the database.
    $filepath = $schoolimage . $schoolname;
    
    
    //Create the folder if it does not already exist
    if(!file_exists('SchoolImages'))
    {
        if(mkdir('SchoolImages'))
        {
            echo 'Folder ' . 'SchoolImages' . ' created.';
        }
        else
        {
            echo 'Error creating folder ' . 'SchoolImages';
        }
    }
    
    
    //Store the folder for the course title.
    if(!file_exists( $filepath ))
    {
        if(mkdir( $filepath ))
        {
            echo 'Folder ' . $schoolname . ' created.';
        }
        else
        {
            echo 'Error creating folder ' . $schoolname;
        }
    }
    
    
    // Where the file is going to be placed 
    $target_path = $filepath;
    
    // Add the original filename to our target path. Result is "uploads/filename.extension"
    echo $target_path = $target_path . '/' . basename( $_FILES['uploadedfile']['name']); 
    
    if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) 
    {
        echo "The file ".  basename( $_FILES['uploadedfile']['name'])." has been uploaded";
        $filename =  $_FILES['uploadedfile']['name'];
        
        //Store the filename, path other criteria in the database 
        echo $query = "INSERT INTO image(image_id, name, path)
        VALUES(0, '$filename', '$filepath')";
        
        //Perform the query
        $add = mysql_query($query, $conn)
            or die("Unable to add the image details to the database");
        $imageid = mysql_insert_id();
        
        //Store the filename, path other criteria in the database 
        echo $query = "INSERT INTO image_school( image_id, school_id )
        VALUES('$imageid', '$schoolid')";
        
        //Perform the query
        $add = mysql_query($query, $conn)
            or die("Unable to add the image details to the database");
        
        $message = 'Upload Successful';
    } 
    else
    {    
        $message = 'There was an error uploading the file, please try again!';
    }
    
    //Close the connection to the database    
    mysql_close($conn);
    header("Location: add_school_photo_form.php? message={$message}&schoolid={$schoolid}");
    //header("Location: add_school_photo_form.php? message=$message, schoolid=$schoolid");
    exit();
    
?>

 

If anyone can help me that would be brilliant because i have no idea, how to implement it

even after searching google.

 

thanks guys

[litebearer]

perhaps

 

http://www.nstoia.com/toh/imageresize.php

[deansaddigh]

Many thanks, this looks easy enough to follow.