binary data manipulation

[shailajaAdiga]

Hi All..

I am new to php programming. I know how to insert and delete images in database. But I would like to know how we can modify the existed image. i.e. already image is stored in databse. Now i have to change that image say for the same user. I have tried this with UPDATE. But its taking time to load new image. I have to refresh the page many times to display changed image.

Is there any other method to modify?

Thanking all


Shailaja

[r035198x]

Hi All..

I am new to php programming. I know how to insert and delete images in database. But I would like to know how we can modify the existed image. i.e. already image is stored in databse. Now i have to change that image say for the same user. I have tried this with UPDATE. But its taking time to load new image. I have to refresh the page many times to display changed image.

Is there any other method to modify?

Thanking all


Shailaja

Perhaps the delay is something to do with the code you are using for the connection and the manner in which you are updating the image.
Without seeing the code no one can tell what the problem is, so post the code you are using.

[shailajaAdiga]

Perhaps the delay is something to do with the code you are using for the connection and the manner in which you are updating the image.
Without seeing the code no one can tell what the problem is, so post the code you are using.

Thank you for your reply...
......Here is the code to update image

    # change the image
    if (isset($_POST['change_image'])){
        $image_id = $_POST['image_id'];
 
        $imageUpload = $_FILES['image_2_upload']["tmp_name"];
        $imageUpload_name = $_FILES['image_2_upload']['name'];
        $imageUpload_type = $_FILES['image_2_upload']['type'];
        $imageUpload_size = $_FILES['image_2_upload']['size'];
 
        # check file was uploaded via HTTP POST
        if (is_uploaded_file($imageUpload)) { 
            $imageHandle = fopen($imageUpload, "r");
            $imageContent = fread($imageHandle, $imageUpload_size);
            $imageContent = addslashes($imageContent);
 
            $sql = "UPDATE organization_logos SET  image = '{$imageContent}' ,image_type= '{$imageUpload_type}' WHERE image_id = '{$image_id}' ";
            $result = mysql_query($sql) or die(mysql_error());
            $num = mysql_affected_rows();
            if ($num) {
                header ("Location: logo_actions.php?changed=yes&org_id={$org_id}");
               }
        } # end if (is_uploaded_file($imageUpload))
        else {
          header ("Location: logo_actions.php?changed=no&org_id={$org_id}");
         }
    } # end if (isset($_POST['change']))
 
 
database connection..(include file)
 
<?php # Connections/web_user.php
/* ---------------------------------------------------------------- */
# general web user connection
 
/* ---------------------------------------------------------------- */
$hostname = "localhost";
$username = "webuser";
$password = "sdg7234";
$db_conn = mysql_connect($hostname, $username, $password) or die(error_message("dbconnect_error"));
?>
 

In main file...

mysql_select_db('authentication');
 

Thank you very much..