I would like to know How can I insert data into a Blob field in Interbase through SQL statement.That is how to insert data into Blob field through database procedures and queries.
Thanx.

    ref:storing images in mysql(phpbuilder:http://www.phpbuilder.com/columns/florian19991014.php3)
    do some thing like this..
    CREATE TABLE binary_data (
    id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    description CHAR(50),
    bin_data LONGBLOB,
    filename CHAR(50),
    filesize CHAR(50),
    filetype CHAR(50)
    );

    <?php

    // More information can be found at http://www.phpbuilder.com/
    ?>

    <HEAD><TITLE>Store binary data into SQL Database</TITLE></HEAD>
    <BODY>

    <?php
    // code that will be executed if the form has been submitted:

    if ($submit) {

    // connect to the database
    // (you may have to adjust the hostname,username or password)
    
    MYSQL_CONNECT("localhost","root","password");
    mysql_select_db("binary_data");
    
    $data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
    
    $result=MYSQL_QUERY("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
        "VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");
    
    $id= mysql_insert_id();
    print "<p>This file has the following Database ID: <b>$id</b>";
    
    MYSQL_CLOSE();

    } else {

    // else show the form to submit new data:

    ?>

    <form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
    File Description:<br>
    <input type="text" name="form_description"  size="40">
    <INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
    <br>File to upload/store in database:<br>
    <input type="file" name="form_data"  size="40">
    <p><input type="submit" name="submit" value="submit">
    </form>

    <?php

    }

    ?>

      Write a Reply...