How can I update a blob mysql field using php

Question

How can I update a blob mysql field using php

Navigation

#1 by (0 votes)

1

if(isset($_POST['submit_edit'])) {
         if (empty($_POST['imagem'])){
                                    $titulo = $_POST['titulo'];
                                    $texto = $_POST['texto'];
                                    $query ="UPDATE SERVICOS SET TITULO=\"$titulo\",TEXTO=\"$texto\" WHERE ID_SERVICO=$id";
                                    mysql_query($query);
                                    header("Location:index.php?ver=servicos.php");
                        }else {


                        $titulo = $_POST['titulo'];
                        $texto = $_POST['texto'];
                        $pFoto = $_FILES["imagem"]["tmp_name"];   
                        $pont = fopen($pFoto, "r"); 
                        $pTipo = $_FILES['imagem']["type"]; 
                        $mysqlImg = addslashes(fread($pont, filesize($pFoto))); 
                        $query = "UPDATE SERVICOS SET TITULO=\"$titulo\",TEXTO=\"$texto\",IMAGEM=\"$mysqlImg\",TIPO=\"$pTipo\" WHERE ID_SERVICO=$id";
                        mysql_query($query);
                        header("Location:index.php?ver=servicos.php");
                    }

                    }

I just want to update if the field that uploads the image is populated

php mysql

asked by anonymous 02.08.2014 / 12:41

1 answer

Consume data from an external web service, such as instantiating the class after the "import" of the WSDL? Hide or Display div via a RadioButton via Jquery

score 0 · Accepted Answer

I do not particularly like repeating code, so when I can, I only condition the affected part:

if(isset($_POST['submit_edit'])) {

    $titulo = $_POST['titulo'];
    $texto = $_POST['texto'];

    $query = "UPDATE SERVICOS SET TITULO=\"$titulo\",TEXTO=\"$texto\"";

    if (is_uploaded_file($_FILES["imagem"]["tmp_name"])) {
        $pFoto = $_FILES["imagem"]["tmp_name"];   
        $pont = fopen($pFoto, "r"); 
        $pTipo = $_FILES['imagem']["type"]; 
        $mysqlImg = addslashes(fread($pont, filesize($pFoto))); 
        $query .= ",IMAGEM=\"$mysqlImg\",TIPO=\"$pTipo\"";
    }

    $query .= " WHERE ID_SERVICO=$id";

    mysql_query($query);
    header("Location:index.php?ver=servicos.php");

}