Web Front-endJS TutorialHow to save data of Bootstrap rich text component wysiwyg to mysql_javascript skills
bootstrap provides a rich text component called wysiwyg, which is used to display and edit rich text data, but how to save the edited data to the mysql database is unknown. in addition, it is not known how to display the data in the mysql database to wysiwyg. for these two problems, let me tell you the solutions!
1. effect display
first, let’s take a look at the effect:
the rich text contains an image and a list of numbers
we can see that the edited data is saved successfully and the corresponding display after saving.
2. rich text
du niang’s explanation of rich text is as follows:
rich text format (generally referred to as rtf) is a cross-platform document format developed by microsoft. most word processing software can read and save rtf documents. rtf is the abbreviation of rich textformat, which means multi-text format. this is a file similar to doc format (word document) and has good compatibility. it can be opened and edited using "wordpad" in windows "accessories". rtf is a very popular file structure and many text editors support it. general format settings, such as font and paragraph settings, page settings and other information can be stored in rtf format, which can realize mutual access between word and wps files to a certain extent.
if the rich text does not contain images, we can use the ordinary html transcoding method, see title 4; if the rich text contains images, ordinary html transcoding cannot satisfy us, and we need to use jquery.base64.js, see title three.
at the same time, let’s take a look at the definition of mysql fields:
`description` longtext not null comment 'project detailed description',
the field type is longtext (the maximum length of longtext is 4294967295 characters (2^32-1), although i don’t know how big it is).
3. jquery.base64
①.introduce jquery.base64.js
also set utf-8 encoding to ensure that chinese characters are not garbled.
$.base64.utf8encode = true;
②. rich text form submission
var editor = "";
key code: convert the html value of the rich text object to base64, and then encapsulate it into the form.
see the details below (a whole form submission form package, refer to the dwz framework):
/**
* 带文件上传的ajax表单提交
*
* @param {object}
* form
* @param {object}
* callback
*/
function iframecallback(form, callback) {
yunm.debug("带文件上传处理");
var $form = $(form), $iframe = $("#callbackframe");
// 富文本编辑器
$("div.editor", $form).each(
function() {
var $this = $(this);
var editor = "<input type='hidden' name='" + $this.attr("name") + "' value='"
+ $.base64.btoa($this.html()) + "' />";
$form.append(editor);
});
var data = $form.data('bootstrapvalidator');
if (data) {
if (!data.isvalid()) {
return false;
}
}
if ($iframe.size() == 0) {
$iframe = $("<iframe id='callbackframe' name='callbackframe' src='about:blank' style='display:none'></iframe>")
.appendto("body");
}
if (!form.ajax) {
$form.append('<input type="hidden" name="ajax" value="1" />');
}
form.target = "callbackframe";
_iframeresponse($iframe[0], callback || yunm.ajaxdone);
}
function _iframeresponse(iframe, callback) {
var $iframe = $(iframe), $document = $(document);
$document.trigger("ajaxstart");
$iframe.bind("load", function(event) {
$iframe.unbind("load");
$document.trigger("ajaxstop");
if (iframe.src == "javascript:'%3chtml%3e%3c/html%3e';" || // for
// safari
iframe.src == "javascript:'<html></html>';") { // for ff, ie
return;
}
var doc = iframe.contentdocument || iframe.document;
// fixing opera 9.26,10.00
if (doc.readystate && doc.readystate != 'complete')
return;
// fixing opera 9.64
if (doc.body && doc.body.innerhtml == "false")
return;
var response;
if (doc.xmldocument) {
// response is a xml document internet explorer property
response = doc.xmldocument;
} else if (doc.body) {
try {
response = $iframe.contents().find("body").text();
response = jquery.parsejson(response);
} catch (e) { // response is html document or plain text
response = doc.body.innerhtml;
}
} else {
// response is a xml document
response = doc;
}
callback(response);
});
}
③. rich text data display
$('#editor').html($.base64.atob(description, true));
decode the html code saved in the database through base64.
④、wysiwyg component
regarding the wysiwyg component encapsulation code, i have uploaded it to the csdn code library for detailed reference.
4. common html transcoding practices
function html_encode(str) {
var s = "";
if (str.length == 0)
return "";
s = str.replace(/&/g, ">");
s = s.replace(/</g, "<");
s = s.replace(/>/g, ">");
s = s.replace(/ /g, " ");
s = s.replace(/\'/g, "'");
s = s.replace(/\"/g, """);
s = s.replace(/\n/g, "<br>");
return s;
}
function html_decode(str) {
var s = "";
if (str.length == 0)
return "";
s = str.replace(/>/g, "&");
s = s.replace(/</g, "<");
s = s.replace(/>/g, ">");
s = s.replace(/ /g, " ");
s = s.replace(/'/g, "\'");
s = s.replace(/"/g, "\"");
s = s.replace(/<br>/g, "\n");
return s;
}
generally, the above two methods are used to encode and decode html data, but there is nothing you can do about saving images.
the above is the entire content of this article. i hope it will be helpful for everyone to understand the rich text component wysiwyg.
Replace String Characters in JavaScriptMar 11, 2025 am 12:07 AMDetailed explanation of JavaScript string replacement method and FAQ This article will explore two ways to replace string characters in JavaScript: internal JavaScript code and internal HTML for web pages. Replace string inside JavaScript code The most direct way is to use the replace() method: str = str.replace("find","replace"); This method replaces only the first match. To replace all matches, use a regular expression and add the global flag g: str = str.replace(/fi
Custom Google Search API Setup TutorialMar 04, 2025 am 01:06 AMThis tutorial shows you how to integrate a custom Google Search API into your blog or website, offering a more refined search experience than standard WordPress theme search functions. It's surprisingly easy! You'll be able to restrict searches to y
Build Your Own AJAX Web ApplicationsMar 09, 2025 am 12:11 AMSo here you are, ready to learn all about this thing called AJAX. But, what exactly is it? The term AJAX refers to a loose grouping of technologies that are used to create dynamic, interactive web content. The term AJAX, originally coined by Jesse J
Example Colors JSON FileMar 03, 2025 am 12:35 AMThis article series was rewritten in mid 2017 with up-to-date information and fresh examples. In this JSON example, we will look at how we can store simple values in a file using JSON format. Using the key-value pair notation, we can store any kind
10 jQuery Syntax HighlightersMar 02, 2025 am 12:32 AMEnhance Your Code Presentation: 10 Syntax Highlighters for Developers Sharing code snippets on your website or blog is a common practice for developers. Choosing the right syntax highlighter can significantly improve readability and visual appeal. T
8 Stunning jQuery Page Layout PluginsMar 06, 2025 am 12:48 AMLeverage jQuery for Effortless Web Page Layouts: 8 Essential Plugins jQuery simplifies web page layout significantly. This article highlights eight powerful jQuery plugins that streamline the process, particularly useful for manual website creation
10 JavaScript & jQuery MVC TutorialsMar 02, 2025 am 01:16 AMThis article presents a curated selection of over 10 tutorials on JavaScript and jQuery Model-View-Controller (MVC) frameworks, perfect for boosting your web development skills in the new year. These tutorials cover a range of topics, from foundatio
What is 'this' in JavaScript?Mar 04, 2025 am 01:15 AMCore points This in JavaScript usually refers to an object that "owns" the method, but it depends on how the function is called. When there is no current object, this refers to the global object. In a web browser, it is represented by window. When calling a function, this maintains the global object; but when calling an object constructor or any of its methods, this refers to an instance of the object. You can change the context of this using methods such as call(), apply(), and bind(). These methods call the function using the given this value and parameters. JavaScript is an excellent programming language. A few years ago, this sentence was
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
SublimeText3 Linux new version
SublimeText3 Linux latest version
SublimeText3 Mac version
God-level code editing software (SublimeText3)
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
