PHP与MySQL：在HTML中显示Base64编码图片教程

本教程详细介绍了如何使用PHP从MySQL数据库中检索Base64编码的图片数据，并将其正确地嵌入到HTML页面中进行。我们将探讨常见的显示问题解决方案，包括数据库存储格式、PHP提取数据方法以及HTML zuojiankuohaophpcnimggt；标签的正确使用，确保图片能够高效准确地读取在网页上。理解Base64图片与数据URI

在web开发中，将图片直接嵌入到html或css中并单独的图片文件中，通常通过base64编码实现。base64是一种将二进制数据转换为ascii字符串的编码方式。当图片被base64编码后，它通常会标记一个“datauri”解码，格式为data：[lt；mediatypegt；][；base64]，lt；datagt；。例如，一张jpeg图片的base64编码可能为data：image/jpeg；base64，/9j/4aaqsk... 这个是告诉浏览器数据的类型和编码方式，可以直接解析并显示图片。

当我们将Base64编码的图片存储到MySQL数据库时，通常会选择 LONGBLOB 或 TEXT/LONGTEXT 类型。如果存储带有数据URI邻近的完整Base64字符串，那么在从数据库读取并显示时，再次进行Base64编码。常见的图片显示问题

在尝试从数据库中提取Base64图片并显示时，开发者经常遇到以下问题：图片显示为破碎图标或空白：这通常是由于lt；imggt；标签的src属性值不正确导致的。可能的原因：数据库中存储的Base64字符串不完整或损坏。PHP在提取数据时发生了错误，导致src属性为空或包含非Base64数据。数据URI远端（如data：image/jpeg；base64，）恢复或错误。对已经Base64编码的数据重新进行了base64_encode()处理。从数据库查询结果中提取数据的方式不正确，例如，尝试对整个$行包括 队列进行 implode() 或 substr() 操作，而不是直接访问包含Base64数据的特定列。数据库设计与数据存储

为了有效地存储Base64编码的图片，MySQL中的视频表结构可以如下：CREATE TABLE `video` ( `ID` int(11) NOT NULL AUTO_INCRMENT， `Video` longblob NOT NULL， -- 存储Base64编码的图片字符串 PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4；登录后复制

视频列使用 longblob 类型，因为它能够存储非常大的二进制数据，非常适合Base64编码后的图片字符串（即使是文本形式）。重要的是，确保Arduino或其他上传机制在将图片存入数据库时​​，已经包含了完整的数据 URI 外部。

立即学习“PHP免费学习笔记（研究）”；

例如，数据库中视频列的数据可能看起来像这样：data：image/jpeg；base64，/9j/4AAQSkZJRgABAQEAAAAAAAD/2wBDAAwICQsJCAwLCgsODQwOEh4UEhEREiUaHBYeLCYuLSsmKikwNkU7MDNBNCkqP FI9QUdKTU5NLzpVW1RLWkVMTUr/2wBDAQ0ODhIQEiMUFCNKMioySkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkpKSkr/xAAfAAABBQ EBAQEBAAAAAAAAAAAAQIDBAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5 jp6vHy8/T19vf4 fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0REVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoCg4SFhoeIiYqSlJOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5 jp6vHy8/T19vf4 fr/wAARCAJYAyADASEAAhEBAxEB/9oADAMBAAIRAxEAPwDzvFGcUSK3Db36UnGMfrWaJsCj9KB97NWgDmkNKyGhCO1GOKobAj9BxSgZX/ClewtApMUALThz60iiVBU4qZK4kSDpSYz71KAkpwHFIBcUYqbjG09abYh KZtzSAbjilz604jJBQaXUq4yk96tiHU6kDGUw0W1JSHCndadrDEOOlNxQg1ENLimMO1NpoSDFFQACnYqriEIphpobE203bSJGFKbiqELsp22mBIFp KgAxS4plBijFLUQ2kxRcAxTcUDGYpNtUSGKXbSYeguKShBYSigLC0hoGNpKQ2gpaCRtNqmAhopIBaSmA00UhCd6WmAlIaQCGiqASkoYWEpKYEpOKaR71cXbcqzQufXml XuN1SPoIcAcClBwPmobJQ09KU42jtzxQAnaikVcKQ9s81Athc0tAdRN1KlWrD2JlqwKiUhXuPBpelZlD1p9MQtNLUWBEeealBpsodmmmlcBpNCGjoJkm70o5q

dgGH0opjF70tABTafUAo lCQtJVCEo70aj2QtJSAMUUDACnUNiYlNxVCDFJtoEMK03FUAtPxQIcKdQAlFQMWkoAbSUxBkZxmiqGMNMNAMM06puKwU00wQZoJoGNzSZqRiUE0yQzTKsBM0A80gFzSZoAM00mkAgpc0ANJozVAJmkpCCkzQO4hoDUXAsEEHjrTceop2KYHOcUmM0mibi4YtwOAKTlvwqLDYEc0h7fWtbBzCnpTf4vzoFcUUneosVEWkqxXEp4zQDJkPFSjpUtCjclXpR3qLBzDxS 1DXQtD6aTQhbDad2ptjQ6ilYBDSrTaGGQO9HO4/nagApTQMSndqYhKKBXGmlxVC1HYpMVNxiYoFIBaMUwA0lLlGOFLTEJikpAJS4qgG7abimIKdQIXFFFhDaSmMdRmoAZmm5p2E GaXtTGNphNMBBuacKNBAabk00guNJpKAFzRmlYBtMzQgDNFMBM03NMAzSUCDNJmlYYmaXNMLjaM00AZpM0WATNJUTEhmkqikJRSsCLP/Aiv0paZbGkZ/wDrUmcCjcncD70oo6CkL tIeDzUp3ASkqhi0d6EMOOxo47VLJWolKOuKroMkFSqakXMSin1FykhaeDipZVxd1HensISikFx4pam4 ghFNqmwHYpRUXYWF680hqkO4Zp1MSDFJihPQBKBTGPFFBI2koEOpaQ0I1JVAPFFTcEJTc5pjCikITNNJqrEjc04GrsAuaa1IoZmlzTJFpCaQxmabupgG6k3UwGk00mmAZozSH0EJpmaZIZozSGGabQIbuozVDDNNzQITNJQAUlAATSUgBS0hoSkzTEFFI ApKAA0lACUtACUlMApaGwLfAo59sUMr1EpOtSwEpRT6EAetJg1LuWkFKaaC2gneilcEHFFMnqFJmmUKKelFxFhe1TLUMB2KcKT1KHYp2KBWDGaTFS9wsJ7VJS2HYKbU7sQCnrVjFxikbrSuMZTlpobH0jClcRHuoDU2IeDQaBkZpMiqsSh27NLuqbFXGk0 3NMVw3Uu6mMCeKYaaENzRupisGaQtRYBuaM1QdA3UhagQ3dSZoQBupN1AmJmm5oATNGaLAG6mE00DCkzQFg3UUANzSUDCkzQIM0lMBKKQBSUAgooASigApKAA0lACUtMBKKQFnNNNN6FPcKKCeo2in0GkLRn1NTuAUVT2EFFIYvailcTQ3FOpsYUjdKA1A UpNHUBwajNAgFBqb6gFJmmAuaKLAFGTRuO1gzSfjTAKOlJsBaKBISkpvYYtFAhaSgApaAEoqgQlLS6gLSUAJ3oqgF7UlSAUUAFLTAKWhgNopAFFCAWkpgFFSCCko3AKKYBSUAFFIAooAKshAFJTAWg0mMSgUCCkpgGKKVwCigQUUhhSUgEoqiQooZRZO31

xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQCUUw EooAWkpALSUAFFACUUXAKKLggooAsilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQooZRZ O31xTKL33DUU5xnHNIalDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhu ozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQooZ RZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApa QCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQ ooZRZO31xTKL33DUU5xnHNIalLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnm imNhuozQFgooTAXvRSsAgpabEJ3paGowUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFM ApaQCUUwEooAWkpALSUAFFACUUXAKKLggooAsilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoq iQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYt FMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooAsilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUg EoqiQooZRZO31xTKL33DUU5xnHNIalLDDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlp

XBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhS UgEoqiQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1Qg pKKYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUU hhSUgEoqiQooZRZO31xTKL33DUU5xnHNIalLDEajFWMAaKgkXrsZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJni gkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQ UUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDA Sg1QgpKkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwC igQUUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIalLDDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMO oNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKV wCigQUUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloA

SlNDASg1QgpKkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1Qgp KkYtFMApaQCUUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQC UUwEooAWkpALSUAFFACUUXAKKLggooASilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIaLDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3okAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWCkzQ0MKKLh1EpaoQUc0ALzSUgCloASlNDASg1QgpKkYtFMApaQCUUwEooAWkpA LSUAFFACUUXAKKLggooAsilYAooAWloBiUGgBKKAF7UlAUUUCCkpgGKKVwCigQUUhhSUgEoqiQooZRZO31xTKL33DUU5xnHNIaLDDEajFWMAaKgkXrSZoWgxe9LmgGhOlH8NHqAlL3o kAvekzQMOoNJnigkWlpXBBnmimNhuozQFgooTAXvRSsAgpabEJ3paGOwUUA9ApaBWC登录后复制

以上就是PHP文章与MySQL：在HTML中显示Base64编码图片教程的详细，更多请关注乐哥常识网其他相关内容！