输入文件更新数据库中的图像

所以我试图改变已经在数据库中的图像,但我似乎不能让它工作,我一直在看教程和其他相关问题,但找不到确切的解决方案。

这是我在php中所拥有的。

// Als de knop van de formulier is ingedrukt update de data dat van de database afkomt

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


if (isset($_GET['id'])) {
          $chauffeurs_id = $_GET['id'];
        }


if (isset($_POST['Chauffeurs_foto'])) {
            $Chauffeurs_foto = $_POST['Chauffeurs_foto'];
        }


$sql = "SELECT * FROM chauffeurs ORDER BY 'chauffeurs_geboortedatum ASC";
        $sql = "UPDATE `chauffeurs`
        SET `Chauffeurs_foto`=$Chauffeurs_foto
        WHERE `id`='$chauffeurs_id'";


$result = $conn->query($sql);

        if ($result == TRUE){
            echo "Aanpassingen zijn voltooid.";
        }else{
            echo "Error:" . $sql . "<br>" . $conn->error;
        }
    }




if (isset($_GET['id'])) {
      $id = $_GET['id'];


$sql = "SELECT * FROM `chauffeurs` WHERE `id`='$id'";



$result = $conn->query($sql);



if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $id = $row['id'];
            $chauffeurs_foto = $row['chauffeurs_foto'];
}
$backId = $_SESSION['krijgid'];

下面是我的html代码:

<!-- Formulier waar alles in komt om te veranderen -->  
<form action="" method="post" enctype='multipart/form-data' >
          <fieldset>
           <legend>Gegevens chauffeur:</legend>
             <div class="form-group col-md-4">


//I did it like this so i could style the input file

<input type="file" name="file" id="file"  class="inputfile" value="data:image/jpeg;base64, <?php.base64_encode($row['chauffeurs_foto']).?>" />
<label class="btn btn primary"for="file">Choose a file</label>

<input type="submit" value="Chauffeur Aanpassen" name="update">
</fieldset>
</form>
</div>

如果你们中有谁有解决方案,我将非常感谢,因为我需要在实习时完成它,如果没有,我将继续寻找。

转载请注明出处:http://www.ccclzm.com/article/20230330/2174179.html