Errors when inserting images in mysql

Question

Errors when inserting images in mysql

Navigation

#1 by (3 votes)

0

Hello, I would like to insert images into the database for a personal project. The image is sent to the bank yes, but not without showing 3 errors, it follows the code and the errors:

<?php
$servidor = 'localhost';
$banco    = 'banco_tcc';
$usuario  = 'root';
$senha    = '';
$link     = mysql_connect($servidor, $usuario, $senha);
$db       = mysql_select_db($banco,$link);

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

    $foto = $_FILES["foto"];

    if (!empty($foto["name"])) {

        $largura = 2000;
        $altura = 2000;
        $tamanho = 99999999999999999999999999;

        if(preg_match ("/image(jpeg|png)$/", $foto["type"])) { 
           $error[1] = "Isso não é uma imagem.";
        } 

        $dimensoes = getimagesize($foto["tmp_name"]);

        if($dimensoes[0] > $largura) {
            $error[2] = "A largura da imagem não deve ultrapassar ".$largura." pixels";
        }

        if($dimensoes[1] > $altura) {
            $error[3] = "Altura da imagem não deve ultrapassar ".$altura." pixels";
        }

        if($foto["size"] > $tamanho) {
            $error[4] = "A imagem deve ter no máximo ".$tamanho." bytes";
        }

        if (count($error) == 0) {

            preg_match("/.(gif|bmp|png|jpg|jpeg){1}$/i", $foto["name"], $ext);

            $nome_imagem = md5(uniqid(time())) . "." . $ext[1];

            $caminho_imagem = "tmp_name/" . $nome_imagem;

            move_uploaded_file($foto["Fotos"], $caminho_imagem);

            $sql = mysql_query("INSERT INTO ManterGaleria VALUES ('','".$nome_imagem."')");

        }

 if (count($error) != 0) {
            foreach ($error as $erro) {
                echo $erro . " ";
            }
        }
    }
}

Undefined variable: Error in line 52

Undefined index: Photos in line 60

Undefined variable: Error in line 66

How could I fix them without completely changing the code?

php mysql imagem

asked by anonymous 04.11.2015 / 11:29

1 answer

Not recognizing js file when it is in 2 folders How to pass a .sh file as a parameter to a code in C?

score 3 · Accepted Answer

Undefined variable: Error in line 52

Undefined variable: Error in line 66

Here it says that the variable $error has not been started. Start array of the variable near the parameters of your sql connection, just above the first if :

$servidor = 'localhost';
$banco    = 'banco_tcc';
$usuario  = 'root';
$senha    = '';
$link     = mysql_connect($servidor, $usuario, $senha);
$db       = mysql_select_db($banco,$link);

$error    =  Array();

Undefined index: Photos in line 60

This error says that the index $foto['Fotos'] has not been defined, check that in your html which is the correct name of the index of the form of upload and change in the line informed.