🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 19 (from laksa061)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa019.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.tiny.cloud/blog/save-content-database/\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.tiny.cloud/blog/save-content-database/\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/www.tiny.cloud\/blog\/save-content-database\/","crawl_time":1775521057,"first_indexed_time":1687260473,"http_code":200,"src_unparsed":"cloud,tiny!www,\/blog\/save-content-database\/ s443","src_root_hash":"15564724552215073219","history_drop_reason":null,"meta_title":"How to save content to database | TinyMCE","meta_descriptions":["Learn how to seamlessly save TinyMCE content to a database using PHP and SQLite. Follow our comprehensive tutorial for efficient database integration with the powerful TinyMCE editor."],"attrs_boilerpipe_text":"Databases are all around us, and without them websites and applications wouldn’t work. Since they’re so vital to online applications, why would components included in those applications – components that claim to speed up development – cause more problems and frustration by blocking database connections?\nFor instance, the rich text editor component of an application lives at the center of content creation apps. A valuable rich text editor provides a fast and easy flow of content from the editor to the database without any roadblocks. Speed and efficiency are a part of best practice for database content management.\nTinyMCE is an trusted rich text editor\nthat allows you to save content to a database without obstacles. It’s just one example of the many ways TinyMCE is easy to implement, and this post shows you how to save TinyMCE content to a database.\nWhat is database content management?\nDatabase content management is the ability to store and serve content from the database, to anywhere it’s needed in an application. When database content management is done effectively, it shows at the very least, the following practices:\nAllows for storage of a variety of digital content, including images, text, video, and audio files\nFast and effective storage and retrieval\nFollows a standardized naming convention\nConnects metadata to each item in the database, providing information to identify content\nPlans for storage that fits the content, such as local storage, or cloud based storage.\nPlus, there’s\nmore to consider before testing out a database\nfor content management. Once you’re ready, the following sections explain the steps to save TinyMCE content to a database using an SQLite demo.\nHow to save TinyMCE content to a database with PHP\nThe first step is getting TinyMCE working. The following demo is based on\nthe TinyMCE CMS solution\n. There are some prerequisites to know about before running the demo:\nExperience with HTML and JavaScript\nFamiliarity with PHP, including prepared statements\nA text editor to adjust file content\nAccess to the command line through bash or another shell\nGetting TinyMCE started\nIn your development environment, create a new directory for the demo, create an\nindex.html\nfile in that directory. Also set up two more folders in the new directory, one for scripts, and one for PHP:\nmkdir demoApp\/\n\ncd demoApp\/\n\ntouch index.html\n\nmkdir scripts\/\nmkdir php\/\nChange into the\nscripts\nfolder and create a new JavaScript file for the TinyMCE configuration, which is set up in step 5 of this procedure:\ncd scripts\/\n\ntouch tinymceConfig.js\nChange out of the\nscripts\nfolder and then in the main directory, open the\nindex.html\nfile. Add the following starter HTML:\n<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n  <meta charset=\"utf-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n  <script src=\"https:\/\/code.jquery.com\/jquery-3.7.0.js\"><\/script>\n  <script src=\"https:\/\/cdn.tiny.cloud\/1\/no-api-key\/tinymce\/6\/tinymce.min.js\" referrerpolicy=\"origin\"><\/script>\n  <script src=\"scripts\/tinymceConfig.js\"><\/script>\n<\/head>\n\n<body>\n  <h1>TinyMCE CMS Starter Config<\/h1>\n  <textarea>\n    <h1>Visiting Norway<\/h1>\n    <p><strong><img style=\"float: right;\" src=\"https:\/\/images.pexels.com\/photos\/1559825\/pexels-photo-1559825.jpeg?auto=compress&amp;cs=tinysrgb&amp;dpr=2&amp;h=750&amp;w=1260\" alt=\"Town\" width=\"300\" height=\"375\"><\/strong>Norway, officially the Kingdom of Norway, is a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nordic_countries\">Nordic country<\/a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.<\/p>\n    <p>The remote Arctic island of Jan Mayen and the archipelago of Svalbard also form part of Norway. Bouvet Island, located in the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Subantarctic\">Subantarctic<\/a>, is a dependency of Norway; it also lays claims to the Antarctic territories of Peter I Island and Queen Maud Land. The capital and largest city in Norway is <a href=\"https:\/\/en.wikipedia.org\/wiki\/Oslo\">Oslo<\/a>.<strong><br><\/strong><\/p>\n    <p>Listen to Norway's royal anthem on Spotify:<\/p>\n    <div style=\"left: 0px; width: 100%; height: 152px; position: relative; max-width: 650px;\" data-ephox-embed-iri=\"https:\/\/open.spotify.com\/track\/6SPocux2pBpFp3lshAOek1?si=907d52cf2af94efc\"><iframe style=\"top: 0; left: 0; width: 100%; height: 100%; position: absolute; border: 0;\" src=\"https:\/\/open.spotify.com\/embed\/track\/6SPocux2pBpFp3lshAOek1?utm_source=oembed\" allow=\"clipboard-write; encrypted-media; fullscreen; picture-in-picture;\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n    <h2>Geography<\/h2>\n    <p>Norway has a total area of 385,207 square kilometres (148,729 sq mi) and had a population of 5,425,270 in January 2022. The country shares a long eastern border with Sweden at a length of 1,619 km (1,006 mi). It is bordered by Finland and Russia to the northeast and the Skagerrak strait to the south, on the other side of which are Denmark and the United Kingdom.<\/p>\n    <p>Norway has an extensive coastline, facing the North Atlantic Ocean and the Barents Sea. The maritime influence dominates Norway's climate, with mild lowland temperatures on the sea coasts; the interior, while colder, is also significantly milder than areas elsewhere in the world on such northerly latitudes. Even during polar night in the north, temperatures above freezing are commonplace on the coastline. The maritime influence brings high rainfall and snowfall to some areas of the country.<\/p>\n    <p><em>Featuring <a href=\"https:\/\/en.wikipedia.org\/wiki\/Norway\">content from Wikipedia<\/a><\/em><\/p>\n  <\/textarea>\n<\/body>\n<\/html>\nAdd a link to TinyMCE through the CDN in the head section of the document, and a link to the TinyMCE configuration file:\n <script src=\"https:\/\/cdn.tiny.cloud\/1\/no-api-key\/tinymce\/6\/tinymce.min.js\" referrerpolicy=\"origin\"><\/script>\n  <script src=\"scripts\/tinymceConfig.js\"><\/script>\nNote:\nThe CMS demo makes use of several Premium plugins. When you\nsign up for a FREE TinyMCE API key\n, you get free access to all Premium plugins for 14 days from when you replace the “no-api-key” string with your own TinyMCE API key. Adding the key also removes any domain name related errors appearing in the text area. \nChange back into the\nscripts\/tinymceConfig.js\nfile, open it, and add the following JavaScript content to get TinyMCE started:\ntinymce.init({\n  selector: \"#editor\",\n  plugins:\n    \"a11ychecker advcode advlist advtable anchor autocorrect autosave editimage image link linkchecker lists media mediaembed pageembed powerpaste searchreplace table template tinymcespellchecker typography visualblocks wordcount\",\n  toolbar:\n    \"undo redo | styles | bold italic underline strikethrough | align | table link image media pageembed | bullist numlist outdent indent | spellcheckdialog a11ycheck typography code\",\n  height: 540,\n  a11ychecker_level: \"aaa\",\n  typography_langs: [\"en-US\"],\n  typography_default_lang: \"en-US\",\n  advcode_inline: true,\n  content_style: `\n        body {\n          font-family: 'Roboto', sans-serif;\n          color: #222;\n        }\n        img {\n          height: auto;\n          margin: auto;\n          padding: 10px;\n          display: block;\n        }\n        img.medium {\n          max-width: 25%;\n        }\n        a {\n          color: #116B59;\n        }\n        .related-content {\n          padding: 0 10px;\n          margin: 0 0 15px 15px;\n          background: #eee;\n          width: 200px;\n          float: right;\n        }\n      `,\n});\nSave the changes, and then change back into the main directory. Test out the demo by opening the\nindex.html\nfile in a browser, or by running a localhost test\nwith the Python command,\nor\nPHP command\n:\nGetting the database connection established\nChange into the\nscripts\nfolder, and add the following JavaScript to the TinyMCE init script after the\ncontent_style\noption. It uses the TinyMCE setup option to listen for the change event.\nThe change event registers when the editor loses focus, or the writer presses the Enter key.\nWhen the event happens, the jQuery gets the rich text editor content, and posts it onward to the database handler file. This content is what saves TinyMCE content to the database:\n   setup: (editor) => {\n        editor.on('change', (e) => {\n          $.ajax({\n            type: 'POST',\n            url: 'php\/save.php',\n            data: {\n              editor: tinymce.get('editor').getContent()\n            },\n            success: function(data){\n              $('#editor').val('');\n              console.log(data)\n            }\n          })\n        })\n      },\nChange back to the main directory, and then change into the\nphp\nfolder. Create a new PHP file for handling interactions with the database:\ntouch connect.php\nAdd the following PHP content to the connection file. This receives the editor content, and then saves the TinyMCE content to a database file:\n<?php\n\n$connect=new SQLite3('tinymceContent.db') or die(\"Could not connect to database, and save TinyMCE content\");\n$db=\"CREATE TABLE IF NOT EXISTS `Content`(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Content TEXT)\";\n\n$connect->exec($db);\n\n?>\nSave the changes, and then close the\n.php\nfile.\nCreate a second\n.php\nfile to handle the process of inserting and saving TinyMCE content into the database, and then add the following PHP content:\ntouch save.php\n\n...\n\n<?php\n\nrequire_once 'connect.php';\n$editorContent=$_POST['editor'];\n\n$stmt = $connect->prepare(\"INSERT INTO `Content` (Content) VALUES (:Content)\");\n\n$stmt->bindParam(':Content', $editorContent);\n\n$stmt->execute();\n\necho \"Save Data\";\n\n?>\nSave the changes.\nSaving TinyMCE content to the database file with PHP and SQLite\nIn the browser, refresh the demo, and try entering some new content into the TinyMCE text area, and then clicking away from the editor or pressing the Enter key. If the PHP content is working, you’ll see a 200 status code on the command line (if you’re running the demo with a localhost for tests with Python or PHP):\n[<date and time>] [::1]:60003 [200]: GET \/\n[<date and time>] [::1]:60003 Closing\n[<date and time>] [::1]:60003 [200]: GET \/tinymceConfig.js\n[<date and time>] [::1]:60003 Closing\n[<date and time>] [::1]:60003 Accepted\n[<date and time>] [::1]:60003 [200]: POST \/php\/save.php\n[<date and time>] [::1]:60003 Closing\nThe successful command line content (code 200) indicates that the database file has been created in the\nphp\nfolder following the steps set in the\nconnect.php\nfile.\nNavigate into the\nphp\nfolder, and then open the\ntinymceContent.db\ndatabase file with the\nSQLite\ncommand:\nsqlite3 tinymceContent.db \nQuery the database Content table to see the TinyMCE content saved in the database:\nSELECT * FROM Content;\n\n…\n\n1|<h1>Visiting Norway<\/h1>\n\n<p><strong><img style=\"float: right;\" src=\"https:\/\/images.pexels.com\/photos\/1559825\/pexels-photo-1559825.jpeg?auto=compress&amp;cs=tinysrgb&amp;dpr=2&amp;h=750&amp;w=1260\" alt=\"Town\" width=\"300\" height=\"375\"><\/strong>Norway, officially the Kingdom of Norway, is a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nordic_countries\">Nordic country<\/a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.<\/p>\n\n...\nExit the database using the\n.quit\ncommand\nNext steps for saving TinyMCE content in a database\nYou can rapidly get content from the editor, and save TinyMCE content to a database making use of the process explained in the previous sections. In production, the pattern of collecting data with the\nTinyMCE Get method,\nand\nbinding parameters in prepared statements\nrepresent consistent patterns you can make use of for your project.\nFor more on getting a CMS ready using TinyMCE, check out\nthe tutorial on creating a CMS with TinyMCE\nto rival the major content management providers out there!","attrs_markdown":"Products\n\n[TinyMCEThe world's most trusted WYSIWYG HTML editor, for total control over your rich text editing.](https:\/\/www.tiny.cloud\/tinymce\/)\n\n- [Overview](https:\/\/www.tiny.cloud\/tinymce\/)\n- [Features](https:\/\/www.tiny.cloud\/tinymce\/features\/)\n- [Pricing](https:\/\/www.tiny.cloud\/pricing\/)\n- [Documentation](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/)\n- [Demos](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/full-featured-premium-demo\/)\n\n[MoxieManagerMedia file management simplified in a PHP or .NET environment.](https:\/\/www.tiny.cloud\/moxiemanager\/)\n\n[DriveFile and image management directly in the cloud.](https:\/\/www.tiny.cloud\/drive\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\nDevelopers\n\n[Developer CenterExplore frameworks, solutions, and technical guides for building with TinyMCE.](https:\/\/www.tiny.cloud\/developer-center\/)\n\n- [Frameworks](https:\/\/www.tiny.cloud\/developer-center\/frameworks\/)\n- [Use Cases](https:\/\/www.tiny.cloud\/developer-center\/use-cases\/)\n\n[Support](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/support\/)\n\n- [License Keys](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/license-key\/)\n- [Editor Loads](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/understanding-editor-loads\/)\n- [Submit a Support Request](https:\/\/support.tiny.cloud\/hc\/en-us\/)\n\n[DocumentationIn-depth documentation to help you develop with and customize Tiny products.](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/)\n\n- [Getting Started](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/getting-started\/)\n- [Basic Setup](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/basic-setup\/)\n- [API Reference](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/apis\/tinymce.root\/)\n- [Migrating to TinyMCE](https:\/\/www.tiny.cloud\/migrate-to-tinymce\/)\n- [Download TinyMCE Free](https:\/\/www.tiny.cloud\/get-tiny\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\nSolutions\n\n[Use CasesOut-of-the-box editor with infinite use cases and complete design flexibility.](https:\/\/www.tiny.cloud\/solutions\/)\n\n- [Content Management System](https:\/\/www.tiny.cloud\/solutions\/cms-editor\/)\n- [Email and Messaging Platform](https:\/\/www.tiny.cloud\/solutions\/wysiwyg-email-editor\/)\n- [Document Management System](https:\/\/www.tiny.cloud\/solutions\/dms-editor\/)\n- [Customer Relationship Management](https:\/\/www.tiny.cloud\/solutions\/crm-editor\/)\n- [Learning Management System](https:\/\/www.tiny.cloud\/solutions\/lms-editor\/)\n- [Internal & SaaS Applications](https:\/\/www.tiny.cloud\/solutions\/saas-applications-editor\/)\n- [Workflow & Collaboration](https:\/\/www.tiny.cloud\/solutions\/workflow-management-editor\/)\n\n[Roles](https:\/\/www.tiny.cloud\/html-text-editor-for-developers\/)\n\n- [Developer](https:\/\/www.tiny.cloud\/html-text-editor-for-developers\/)\n- [Product Manager](https:\/\/www.tiny.cloud\/html-text-editor-for-product-managers\/)\n- [Senior Manager](https:\/\/www.tiny.cloud\/html-text-editor-for-scaling-and-monetizing\/)\n\n[Security](https:\/\/www.tiny.cloud\/tinymce\/security\/)[Hosting](https:\/\/www.tiny.cloud\/solutions\/on-premise-or-cloud-based-text-editor\/)[Customization](https:\/\/www.tiny.cloud\/solutions\/customize-text-editor\/)[Frameworks & Integrations](https:\/\/www.tiny.cloud\/solutions\/editor-framework-integration\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\nResources\n\n[BlogRead the world's best blog on WYSIWYG HTML editors, rich text editing, and insights on building SaaS application editors.](https:\/\/www.tiny.cloud\/blog\/)\n\n[Events & WebinarsExplore upcoming and on-demand events and webinars to unlock the full potential of TinyMCE.](https:\/\/www.tiny.cloud\/events-and-webinars\/)\n\n[Case StudiesDiscover why industry leaders and scaling start-ups love, use and trust Tiny products.](https:\/\/www.tiny.cloud\/customer-stories\/)\n\n[White Papers and ReportsSee how Tiny improves ROI, grows revenue and saves development costs.](https:\/\/www.tiny.cloud\/resources\/)\n\nRead:\n\n- [Buy vs Build: The Great Debate White Paper](https:\/\/www.tiny.cloud\/buy-vs-build-whitepaper\/)\n- [Opportunity Cost of Technical Debt](https:\/\/www.tiny.cloud\/technical-debt-whitepaper\/)\n- [The State of Rich Text Editors 2025 Report](https:\/\/www.tiny.cloud\/developer-survey-results\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\n[Pricing](https:\/\/www.tiny.cloud\/pricing\/)[Contact Us](https:\/\/www.tiny.cloud\/contact\/)\n\n[Log In](https:\/\/www.tiny.cloud\/auth\/login\/)[Start Free Trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start Free Trial\")\n\n[Products]()\n\n[TinyMCE The world's most trusted WYSIWYG HTML editor, for total control over your rich text editing.](https:\/\/www.tiny.cloud\/tinymce\/)\n\n- [Overview](https:\/\/www.tiny.cloud\/tinymce\/)\n- [Features](https:\/\/www.tiny.cloud\/tinymce\/features\/)\n- [Pricing](https:\/\/www.tiny.cloud\/pricing\/)\n- [Documentation](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/)\n- [Demos](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/full-featured-premium-demo\/)\n\n[MoxieManager Media file management simplified in a PHP or .NET environment.](https:\/\/www.tiny.cloud\/moxiemanager\/)\n\n[Drive File and image management directly in the cloud.](https:\/\/www.tiny.cloud\/drive\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\n[Developers]()\n\n[Developer CenterExplore frameworks, solutions, and technical guides for building with TinyMCE.](https:\/\/www.tiny.cloud\/developer-center\/)\n\n- [Frameworks](https:\/\/www.tiny.cloud\/developer-center\/frameworks\/)\n- [Use Cases](https:\/\/www.tiny.cloud\/developer-center\/use-cases\/)\n\n[DocumentationIn-depth documentation to help you develop with and customize Tiny products.](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/)\n\n- [Getting Started](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/getting-started\/)\n- [Basic Setup](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/basic-setup\/)\n- [API Reference](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/apis\/tinymce.root\/)\n- [Migrating to TinyMCE](https:\/\/www.tiny.cloud\/migrate-to-tinymce\/)\n- [Download TinyMCE Free](https:\/\/www.tiny.cloud\/get-tiny\/)\n\n[Support](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/support\/)\n\n- [License Keys](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/license-key\/)\n- [Editor Loads](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/understanding-editor-loads\/)\n- [Submit a Support Request](https:\/\/support.tiny.cloud\/hc\/en-us\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\n[Solutions]()\n\n[Use CasesOut-of-the-box editor with infinite use cases and complete design flexibility.](https:\/\/www.tiny.cloud\/solutions\/)\n\n- [Content Management System](https:\/\/www.tiny.cloud\/solutions\/cms-editor\/)\n- [Email and Messaging Platform](https:\/\/www.tiny.cloud\/solutions\/wysiwyg-email-editor\/)\n- [Document Management System](https:\/\/www.tiny.cloud\/solutions\/dms-editor\/)\n- [Customer Relationship Management](https:\/\/www.tiny.cloud\/solutions\/crm-editor\/)\n- [Learning Management System](https:\/\/www.tiny.cloud\/solutions\/lms-editor\/)\n- [Internal & SaaS Applications](https:\/\/www.tiny.cloud\/solutions\/saas-applications-editor\/)\n- [Workflow & Collaboration](https:\/\/www.tiny.cloud\/solutions\/workflow-management-editor\/)\n\n[Roles](https:\/\/www.tiny.cloud\/html-text-editor-for-developers\/)\n\n- [Developer](https:\/\/www.tiny.cloud\/html-text-editor-for-developers\/)\n- [Product Manager](https:\/\/www.tiny.cloud\/html-text-editor-for-product-managers\/)\n- [Senior Manager](https:\/\/www.tiny.cloud\/html-text-editor-for-scaling-and-monetizing\/)\n\n[Security](https:\/\/www.tiny.cloud\/tinymce\/security\/)[Hosting](https:\/\/www.tiny.cloud\/solutions\/on-premise-or-cloud-based-text-editor\/)[Customization](https:\/\/www.tiny.cloud\/solutions\/customize-text-editor\/)[Frameworks & Integrations](https:\/\/www.tiny.cloud\/solutions\/editor-framework-integration\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\n[Resources]()\n\n[BlogRead the world's best blog on WYSIWYG HTML editors, rich text editing, and insights on building SaaS application editors.](https:\/\/www.tiny.cloud\/blog\/)\n\n[White Papers and ReportsSee how Tiny improves ROI, grows revenue and saves development costs.](https:\/\/www.tiny.cloud\/resources\/)\n\n[Events & WebinarsExplore upcoming and on-demand events and webinars to unlock the full potential of TinyMCE.](https:\/\/www.tiny.cloud\/events-and-webinars\/)\n\n[Case StudiesDiscover why industry leaders and scaling start-ups love, use and trust Tiny products.](https:\/\/www.tiny.cloud\/customer-stories\/)\n\nRead:\n\n- [Buy vs Build: The Great Debate White Paper](https:\/\/www.tiny.cloud\/buy-vs-build-whitepaper\/)\n- [Opportunity Cost of Technical Debt](https:\/\/www.tiny.cloud\/technical-debt-whitepaper\/)\n- [The State of Rich Text Editors 2025 Report](https:\/\/www.tiny.cloud\/developer-survey-results\/)\n\n[Start trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start trial\")\n\n[Pricing](https:\/\/www.tiny.cloud\/pricing\/)\n\n[Contact Us](https:\/\/www.tiny.cloud\/contact\/)\n\n[Log In](https:\/\/www.tiny.cloud\/auth\/login\/)[Start Free Trial](https:\/\/www.tiny.cloud\/auth\/signup\/ \"Start Free Trial\")\n***\n\n[Content Marketing & Design](https:\/\/www.tiny.cloud\/blog\/category\/design-and-ux\/)[Developer Insights](https:\/\/www.tiny.cloud\/blog\/category\/engineering\/)[How-to Use TinyMCE](https:\/\/www.tiny.cloud\/blog\/category\/how-tos-and-tutorials\/)[Open Source](https:\/\/www.tiny.cloud\/blog\/category\/open-source\/)[Product-Led Growth](https:\/\/www.tiny.cloud\/blog\/category\/product-management\/)[The Tiny Way](https:\/\/www.tiny.cloud\/blog\/category\/tiny-sparks\/)[World of WYSIWYG](https:\/\/www.tiny.cloud\/blog\/category\/wysiwyg-world\/)\n\n# How to save TinyMCE content to a database\nJune 20th, 2023\n\n5 min read\n\n![](data:image\/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAAAwFBMVEXZx\/\/ax\/\/cy\/\/Xx\/\/ayP\/byP\/d0Pvm5evd0fvOxfTPvuPQteTSwvPVxP3QwvzbzP\/n3\/Dgz\/XdyvLgy9DLuOfKuuy3tPKjrvDVw\/\/ZyP\/hzPDw0bXrxp332LDnz9\/VwvfSyfDWzfPX0vnc1frczP7Yx\/\/x1s792przzY7y1cTby\/\/V1N3k5t77\/Prw9\/Th1\/vZxv\/r0dTr0dDo0Njnztrbyv\/ZzOXf2+vw6\/zr6Prf0f3Zx\/7Yxv\/Xxv\/Zx\/3Yxf+hPfr8AAAAV0lEQVQI12NgwAcYkdgsEIrpHxNIlPHPf5gCFgYmRij4xPgfLsgNE2R8yfwHKijKiAB3YCoVQbzrWhDRCxCL\/oC1q0LM+AZ3iTWQd4iBwYCf4eMFBlIAAKogD0PCtkl4AAAAAElFTkSuQmCC)\n\n![The PHP element of the database represented by an elephant celebrating with TinyMCE](https:\/\/images.ctfassets.net\/s600jj41gsex\/eihtTelYKrOnMQs1CaGQn\/2b80f54539e12e93587c6878776cce28\/How_to_save_TinyMCE_content_to_a_database.png?w=2560&q=80&fit=scale)\n\n![The PHP element of the database represented by an elephant celebrating with TinyMCE](https:\/\/images.ctfassets.net\/s600jj41gsex\/eihtTelYKrOnMQs1CaGQn\/2b80f54539e12e93587c6878776cce28\/How_to_save_TinyMCE_content_to_a_database.png?w=2560&q=80&fit=scale)\n\nWritten by\n\n![Joe Robinson](data:image\/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAQCAIAAACZeshMAAAABGdBTUEAALGPC\/xhBQAACilpQ0NQaWNjAABIiZ2Wd1RT2RaHz703vVCSEIqU0GtoUgJIDb1IkS4qMQkQSsCQACI2RFRwRFGRpggyKOCAo0ORsSKKhQFRsesEGUTUcXAUG5ZJZK0Z37x5782b3x\/3fmufvc\/dZ+991roAkPyDBcJMWAmADKFYFOHnxYiNi2dgBwEM8AADbADgcLOzQhb4RgKZAnzYjGyZE\/gXvboOIPn7KtM\/jMEA\/5+UuVkiMQBQmIzn8vjZXBkXyTg9V5wlt0\/JmLY0Tc4wSs4iWYIyVpNz8ixbfPaZZQ858zKEPBnLc87iZfDk3CfjjTkSvoyRYBkX5wj4uTK+JmODdEmGQMZv5LEZfE42ACiS3C7mc1NkbC1jkigygi3jeQDgSMlf8NIvWMzPE8sPxc7MWi4SJKeIGSZcU4aNkxOL4c\/PTeeLxcwwDjeNI+Ix2JkZWRzhcgBmz\/xZFHltGbIiO9g4OTgwbS1tvijUf138m5L3dpZehH\/uGUQf+MP2V36ZDQCwpmW12fqHbWkVAF3rAVC7\/YfNYC8AirK+dQ59cR66fF5SxOIsZyur3NxcSwGfaykv6O\/6nw5\/Q198z1K+3e\/lYXjzkziSdDFDXjduZnqmRMTIzuJw+Qzmn4f4Hwf+dR4WEfwkvogvlEVEy6ZMIEyWtVvIE4gFmUKGQPifmvgPw\/6k2bmWidr4EdCWWAKlIRpAfh4AKCoRIAl7ZCvQ730LxkcD+c2L0ZmYnfvPgv59V7hM\/sgWJH+OY0dEMrgSUc7smvxaAjQgAEVAA+pAG+gDE8AEtsARuAAP4AMCQSiIBHFgMeCCFJABRCAXFIC1oBiUgq1gJ6gGdaARNIM2cBh0gWPgNDgHLoHLYATcAVIwDp6AKfAKzEAQhIXIEBVSh3QgQ8gcsoVYkBvkAwVDEVAclAglQ0JIAhVA66BSqByqhuqhZuhb6Ch0GroADUO3oFFoEvoVegcjMAmmwVqwEWwFs2BPOAiOhBfByfAyOB8ugrfAlXADfBDuhE\/Dl+ARWAo\/gacRgBAROqKLMBEWwkZCkXgkCREhq5ASpAJpQNqQHqQfuYpIkafIWxQGRUUxUEyUC8ofFYXiopahVqE2o6pRB1CdqD7UVdQoagr1EU1Ga6LN0c7oAHQsOhmdiy5GV6Cb0B3os+gR9Dj6FQaDoWOMMY4Yf0wcJhWzArMZsxvTjjmFGcaMYaaxWKw61hzrig3FcrBibDG2CnsQexJ7BTuOfYMj4nRwtjhfXDxOiCvEVeBacCdwV3ATuBm8Et4Q74wPxfPwy\/Fl+EZ8D34IP46fISgTjAmuhEhCKmEtoZLQRjhLuEt4QSQS9YhOxHCigLiGWEk8RDxPHCW+JVFIZiQ2KYEkIW0h7SedIt0ivSCTyUZkD3I8WUzeQm4mnyHfJ79RoCpYKgQo8BRWK9QodCpcUXimiFc0VPRUXKyYr1iheERxSPGpEl7JSImtxFFapVSjdFTphtK0MlXZRjlUOUN5s3KL8gXlRxQsxYjiQ+FRiij7KGcoY1SEqk9lU7nUddRG6lnqOA1DM6YF0FJppbRvaIO0KRWKip1KtEqeSo3KcRUpHaEb0QPo6fQy+mH6dfo7VS1VT1W+6ibVNtUrqq\/V5qh5qPHVStTa1UbU3qkz1H3U09S3qXep39NAaZhphGvkauzROKvxdA5tjssc7pySOYfn3NaENc00IzRXaO7THNCc1tLW8tPK0qrSOqP1VJuu7aGdqr1D+4T2pA5Vx01HoLND56TOY4YKw5ORzqhk9DGmdDV1\/XUluvW6g7ozesZ6UXqFeu169\/QJ+iz9JP0d+r36UwY6BiEGBQatBrcN8YYswxTDXYb9hq+NjI1ijDYYdRk9MlYzDjDON241vmtCNnE3WWbSYHLNFGPKMk0z3W162Qw2szdLMasxGzKHzR3MBea7zYct0BZOFkKLBosbTBLTk5nDbGWOWtItgy0LLbssn1kZWMVbbbPqt\/pobW+dbt1ofceGYhNoU2jTY\/OrrZkt17bG9tpc8lzfuavnds99bmdux7fbY3fTnmofYr\/Bvtf+g4Ojg8ihzWHS0cAx0bHW8QaLxgpjbWadd0I7eTmtdjrm9NbZwVnsfNj5FxemS5pLi8ujecbz+PMa54256rlyXOtdpW4Mt0S3vW5Sd113jnuD+wMPfQ+eR5PHhKepZ6rnQc9nXtZeIq8Or9dsZ\/ZK9ilvxNvPu8R70IfiE+VT7XPfV8832bfVd8rP3m+F3yl\/tH+Q\/zb\/GwFaAdyA5oCpQMfAlYF9QaSgBUHVQQ+CzYJFwT0hcEhgyPaQu\/MN5wvnd4WC0IDQ7aH3wozDloV9H44JDwuvCX8YYRNRENG\/gLpgyYKWBa8ivSLLIu9EmURJonqjFaMTopujX8d4x5THSGOtYlfGXorTiBPEdcdj46Pjm+KnF\/os3LlwPME+oTjh+iLjRXmLLizWWJy++PgSxSWcJUcS0YkxiS2J7zmhnAbO9NKApbVLp7hs7i7uE54Hbwdvku\/KL+dPJLkmlSc9SnZN3p48meKeUpHyVMAWVAuep\/qn1qW+TgtN25\/2KT0mvT0Dl5GYcVRIEaYJ+zK1M\/Myh7PMs4qzpMucl+1cNiUKEjVlQ9mLsrvFNNnP1IDERLJeMprjllOT8yY3OvdInnKeMG9gudnyTcsn8n3zv16BWsFd0VugW7C2YHSl58r6VdCqpat6V+uvLlo9vsZvzYG1hLVpa38otC4sL3y5LmZdT5FW0ZqisfV+61uLFYpFxTc2uGyo24jaKNg4uGnupqpNH0t4JRdLrUsrSt9v5m6++JXNV5VffdqStGWwzKFsz1bMVuHW69vctx0oVy7PLx\/bHrK9cwdjR8mOlzuX7LxQYVdRt4uwS7JLWhlc2V1lULW16n11SvVIjVdNe61m7aba17t5u6\/s8djTVqdVV1r3bq9g7816v\/rOBqOGin2YfTn7HjZGN\/Z\/zfq6uUmjqbTpw37hfumBiAN9zY7NzS2aLWWtcKukdfJgwsHL33h\/093GbKtvp7eXHgKHJIcef5v47fXDQYd7j7COtH1n+F1tB7WjpBPqXN451ZXSJe2O6x4+Gni0t8elp+N7y+\/3H9M9VnNc5XjZCcKJohOfTuafnD6Vderp6eTTY71Leu+ciT1zrS+8b\/Bs0Nnz53zPnen37D953vX8sQvOF45eZF3suuRwqXPAfqDjB\/sfOgYdBjuHHIe6Lztd7hmeN3ziivuV01e9r567FnDt0sj8keHrUddv3ki4Ib3Ju\/noVvqt57dzbs\/cWXMXfbfkntK9ivua9xt+NP2xXeogPT7qPTrwYMGDO2PcsSc\/Zf\/0frzoIflhxYTORPMj20fHJn0nLz9e+Hj8SdaTmafFPyv\/XPvM5Nl3v3j8MjAVOzX+XPT806+bX6i\/2P\/S7mXvdNj0\/VcZr2Zel7xRf3PgLett\/7uYdxMzue+x7ys\/mH7o+Rj08e6njE+ffgP3hPP78QcZjQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAADhElEQVQYGQXBy08jZQAA8Hl9M9N5dcpMh5ZOaYFSWCgokmiyiRuSjXIwrCvx4NVkL96MnvT\/8aYHX\/HgTfcBLCUuFSwsLCx9dzqdtjPtPPt9\/n741199+PrubwrLFwvLj\/ceI5Cyx3fP\/\/ohCvmHu5+qymKjblfPf15bwQ8PztKpNIbLrdsujEJZniO\/fPJNQr5HUjwAZ\/W2Xz5+Kojp0tonEDGapmGIm01l67Wj\/149Ky7MZPRYp9\/s9dgP1mdVoUddX1fTmnrjNxZzBWci1Go\/moNIU94cHV8MLHN7K\/dgZ800e24kLqyUTs\/KXePu+BJfn1\/V1CRJxIyr6q8AtHkh37PwRvOi0Rie\/vLi\/mbh\/aUs4QSN9jnJkiJHqpqYTrM40rudvsRSnueS+\/tfNJpvWyYB6GKlWvEwQSaT33\/73Uc7D0vLxa2NTYXPvqy+DhE9GQ\/Wlx9EIQo8IUK8trBL6XPzB4iGgJmGNi8IkHD27n+WL6wGZhMPxyHCUlpyNbP529lP103k+YomwRgQOv2uvvQO6bhPg2ggywqBHJzhNHEisfmry39Ojv4I7FH51UGjZ0wJqmX3Rr6IUToOfQxSICY\/2n9CrKzuFYsf41iPAR6Al4lAziqJGZpk6DgSsiTBCMQkG2f0KfA9q1L587ByddPz7r27pSgqlVS1GSl3y9koHCOkLs2ATFILKFzh5czsfCIyWYEGvJjAKY5prq3mn500a0YL0Z2l5Vlye41jCZynGTKCbQd1BtON\/EaCgNGw36rdcOFAicdDDCt3m9ulHQonJE5DBAhs8\/nR75QmKPWm4U3aVoSGAbQm0cvTw4LAjGzoDvs+4YV07Y2H6lNyU6QLWV1ie8mEwPOwfH5Jarp4bbQaXdNGtG\/3hq7LQigBMkaynIc4OrIj58QcGAFmDyuuZ\/WNIEayth3QuEi1Jo4POdu3pTgLGL4Uw6y25+viFOCjyBJA2B6HF+0Gz8ZyBcy0rbHDeyPk49hoilM4KcHAljlKIeKqm5warpWAs8m56sW\/xl09lRQz6XnptE\/IwfUNDMCAIibTIEA4CBCgOCGVMSRylMYsInIiczB5cdfaLi0oIu\/KvCyKXcupn41ykurOQXKetNEkIcVAkMrSU\/zz93aZLnQi13KHyI8m\/qiMhhgG1vUZDkCIsPKto2LBMiYjQdQXU6O3ndRWTEgpnj38H0Bj0vI5fgnbAAAAOHRFWHRpY2M6Y29weXJpZ2h0AENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueflXeTcAAAAhdEVYdGljYzpkZXNjcmlwdGlvbgBzUkdCIElFQzYxOTY2LTIuMVet2kcAAAAmdEVYdGljYzptYW51ZmFjdHVyZXIASUVDIGh0dHA6Ly93d3cuaWVjLmNoHH8ATAAAADd0RVh0aWNjOm1vZGVsAElFQyA2MTk2Ni0yLjEgRGVmYXVsdCBSR0IgY29sb3VyIHNwYWNlIC0gc1JHQkRTSKkAAAAASUVORK5CYII=)\n\n![Joe Robinson](https:\/\/images.ctfassets.net\/s600jj41gsex\/2P4AEkP8R7iCxO4eT5voCe\/d18aa214c40aa5e1ecff6f6d216c8097\/Portrait-TinyTribe-JR100px.png?w=48&q=50&fit=scale)\n\n[Joe Robinson](https:\/\/www.tiny.cloud\/blog\/author\/joseph-robinson\/)\n\nCategory\n\n[How-to Use TinyMCE](https:\/\/www.tiny.cloud\/blog\/category\/how-tos-and-tutorials\/)\n\nTagged\n\n[Configuration](https:\/\/www.tiny.cloud\/blog\/tag\/configuration\/)[TinyMCE](https:\/\/www.tiny.cloud\/blog\/tag\/tinymce\/)\n\nDatabases are all around us, and without them websites and applications wouldn’t work. Since they’re so vital to online applications, why would components included in those applications – components that claim to speed up development – cause more problems and frustration by blocking database connections?\n\nFor instance, the rich text editor component of an application lives at the center of content creation apps. A valuable rich text editor provides a fast and easy flow of content from the editor to the database without any roadblocks. Speed and efficiency are a part of best practice for database content management.\n\n[TinyMCE is an trusted rich text editor](https:\/\/www.tiny.cloud\/) that allows you to save content to a database without obstacles. It’s just one example of the many ways TinyMCE is easy to implement, and this post shows you how to save TinyMCE content to a database.\n\n## What is database content management?\nDatabase content management is the ability to store and serve content from the database, to anywhere it’s needed in an application. When database content management is done effectively, it shows at the very least, the following practices:\n\n1. Allows for storage of a variety of digital content, including images, text, video, and audio files\n2. Fast and effective storage and retrieval\n3. Follows a standardized naming convention\n4. Connects metadata to each item in the database, providing information to identify content\n5. Plans for storage that fits the content, such as local storage, or cloud based storage.\n\nPlus, there’s [more to consider before testing out a database](https:\/\/www.tableau.com\/learn\/articles\/data-management-best-practices) for content management. Once you’re ready, the following sections explain the steps to save TinyMCE content to a database using an SQLite demo.\n\n## How to save TinyMCE content to a database with PHP\nThe first step is getting TinyMCE working. The following demo is based on [the TinyMCE CMS solution](https:\/\/www.tiny.cloud\/solutions\/cms-editor\/). There are some prerequisites to know about before running the demo:\n\n1. Experience with HTML and JavaScript\n2. Familiarity with PHP, including prepared statements\n3. A text editor to adjust file content\n4. Access to the command line through bash or another shell\n### Getting TinyMCE started\n1. In your development environment, create a new directory for the demo, create an *index.html* file in that directory. Also set up two more folders in the new directory, one for scripts, and one for PHP:\n\n```\nmkdir demoApp\/\n\ncd demoApp\/\n\ntouch index.html\n\nmkdir scripts\/\nmkdir php\/\n```\nCOPY\n\n1. Change into the *scripts* folder and create a new JavaScript file for the TinyMCE configuration, which is set up in step 5 of this procedure:\n\n```\ncd scripts\/\n\ntouch tinymceConfig.js\n```\nCOPY\n\n1. Change out of the *scripts* folder and then in the main directory, open the *index.html* file. Add the following starter HTML:\n\n```\n<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n  <meta charset=\"utf-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n  <script src=\"https:\/\/code.jquery.com\/jquery-3.7.0.js\"><\/script>\n  <script src=\"https:\/\/cdn.tiny.cloud\/1\/no-api-key\/tinymce\/6\/tinymce.min.js\" referrerpolicy=\"origin\"><\/script>\n  <script src=\"scripts\/tinymceConfig.js\"><\/script>\n<\/head>\n\n<body>\n  <h1>TinyMCE CMS Starter Config<\/h1>\n  <textarea>\n    <h1>Visiting Norway<\/h1>\n    <p><strong><img style=\"float: right;\" src=\"https:\/\/images.pexels.com\/photos\/1559825\/pexels-photo-1559825.jpeg?auto=compress&amp;cs=tinysrgb&amp;dpr=2&amp;h=750&amp;w=1260\" alt=\"Town\" width=\"300\" height=\"375\"><\/strong>Norway, officially the Kingdom of Norway, is a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nordic_countries\">Nordic country<\/a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.<\/p>\n    <p>The remote Arctic island of Jan Mayen and the archipelago of Svalbard also form part of Norway. Bouvet Island, located in the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Subantarctic\">Subantarctic<\/a>, is a dependency of Norway; it also lays claims to the Antarctic territories of Peter I Island and Queen Maud Land. The capital and largest city in Norway is <a href=\"https:\/\/en.wikipedia.org\/wiki\/Oslo\">Oslo<\/a>.<strong><br><\/strong><\/p>\n    <p>Listen to Norway's royal anthem on Spotify:<\/p>\n    <div style=\"left: 0px; width: 100%; height: 152px; position: relative; max-width: 650px;\" data-ephox-embed-iri=\"https:\/\/open.spotify.com\/track\/6SPocux2pBpFp3lshAOek1?si=907d52cf2af94efc\"><iframe style=\"top: 0; left: 0; width: 100%; height: 100%; position: absolute; border: 0;\" src=\"https:\/\/open.spotify.com\/embed\/track\/6SPocux2pBpFp3lshAOek1?utm_source=oembed\" allow=\"clipboard-write; encrypted-media; fullscreen; picture-in-picture;\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n    <h2>Geography<\/h2>\n    <p>Norway has a total area of 385,207 square kilometres (148,729 sq mi) and had a population of 5,425,270 in January 2022. The country shares a long eastern border with Sweden at a length of 1,619 km (1,006 mi). It is bordered by Finland and Russia to the northeast and the Skagerrak strait to the south, on the other side of which are Denmark and the United Kingdom.<\/p>\n    <p>Norway has an extensive coastline, facing the North Atlantic Ocean and the Barents Sea. The maritime influence dominates Norway's climate, with mild lowland temperatures on the sea coasts; the interior, while colder, is also significantly milder than areas elsewhere in the world on such northerly latitudes. Even during polar night in the north, temperatures above freezing are commonplace on the coastline. The maritime influence brings high rainfall and snowfall to some areas of the country.<\/p>\n    <p><em>Featuring <a href=\"https:\/\/en.wikipedia.org\/wiki\/Norway\">content from Wikipedia<\/a><\/em><\/p>\n  <\/textarea>\n<\/body>\n<\/html>\n```\nCOPY\n\n1. Add a link to TinyMCE through the CDN in the head section of the document, and a link to the TinyMCE configuration file:\n\n```\n  <script src=\"https:\/\/cdn.tiny.cloud\/1\/no-api-key\/tinymce\/6\/tinymce.min.js\" referrerpolicy=\"origin\"><\/script>\n  <script src=\"scripts\/tinymceConfig.js\"><\/script>\n```\nCOPY\n\n> **Note:** The CMS demo makes use of several Premium plugins. When you [sign up for a FREE TinyMCE API key](https:\/\/www.tiny.cloud\/auth\/signup\/), you get free access to all Premium plugins for 14 days from when you replace the “no-api-key” string with your own TinyMCE API key. Adding the key also removes any domain name related errors appearing in the text area.\n\n1. Change back into the *scripts\/tinymceConfig.js* file, open it, and add the following JavaScript content to get TinyMCE started:\n\n```\ntinymce.init({\n  selector: \"#editor\",\n  plugins:\n    \"a11ychecker advcode advlist advtable anchor autocorrect autosave editimage image link linkchecker lists media mediaembed pageembed powerpaste searchreplace table template tinymcespellchecker typography visualblocks wordcount\",\n  toolbar:\n    \"undo redo | styles | bold italic underline strikethrough | align | table link image media pageembed | bullist numlist outdent indent | spellcheckdialog a11ycheck typography code\",\n  height: 540,\n  a11ychecker_level: \"aaa\",\n  typography_langs: [\"en-US\"],\n  typography_default_lang: \"en-US\",\n  advcode_inline: true,\n  content_style: `\n        body {\n          font-family: 'Roboto', sans-serif;\n          color: #222;\n        }\n        img {\n          height: auto;\n          margin: auto;\n          padding: 10px;\n          display: block;\n        }\n        img.medium {\n          max-width: 25%;\n        }\n        a {\n          color: #116B59;\n        }\n        .related-content {\n          padding: 0 10px;\n          margin: 0 0 15px 15px;\n          background: #eee;\n          width: 200px;\n          float: right;\n        }\n      `,\n});\n```\nCOPY\n\n1. Save the changes, and then change back into the main directory. Test out the demo by opening the *index.html* file in a browser, or by running a localhost test [with the Python command,](https:\/\/ryanblunden.com\/create-a-http-server-with-one-command-thanks-to-python-29fcfdcd240e) or [PHP command](https:\/\/www.php.net\/manual\/en\/features.commandline.webserver.php):\n\n![The TinyMCE CMS demo working in the browser and ready to be saved to the database](https:\/\/images.ctfassets.net\/s600jj41gsex\/6LO93YvgD4nqcJyVIQfpza\/5b0362977008cbb4f567cb7a9e53010f\/img-TinyMCE-save-database-0.gif)\n\n### Getting the database connection established\n1. Change into the *scripts* folder, and add the following JavaScript to the TinyMCE init script after the *content\\_style* option. It uses the TinyMCE setup option to listen for the change event.  \n     \n   The change event registers when the editor loses focus, or the writer presses the Enter key.  \n     \n   When the event happens, the jQuery gets the rich text editor content, and posts it onward to the database handler file. This content is what saves TinyMCE content to the database:\n\n```\n    setup: (editor) => {\n        editor.on('change', (e) => {\n          $.ajax({\n            type: 'POST',\n            url: 'php\/save.php',\n            data: {\n              editor: tinymce.get('editor').getContent()\n            },\n            success: function(data){\n              $('#editor').val('');\n              console.log(data)\n            }\n          })\n        })\n      },\n```\nCOPY\n\n1. Change back to the main directory, and then change into the *php* folder. Create a new PHP file for handling interactions with the database:\n\n```\ntouch connect.php\n```\nCOPY\n\n1. Add the following PHP content to the connection file. This receives the editor content, and then saves the TinyMCE content to a database file:\n\n```\n<?php\n\n$connect=new SQLite3('tinymceContent.db') or die(\"Could not connect to database, and save TinyMCE content\");\n$db=\"CREATE TABLE IF NOT EXISTS `Content`(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Content TEXT)\";\n\n$connect->exec($db);\n\n?>\n```\nCOPY\n\n1. Save the changes, and then close the *.php* file.\n2. Create a second *.php* file to handle the process of inserting and saving TinyMCE content into the database, and then add the following PHP content:\n\n```\ntouch save.php\n\n...\n\n<?php\n\nrequire_once 'connect.php';\n$editorContent=$_POST['editor'];\n\n$stmt = $connect->prepare(\"INSERT INTO `Content` (Content) VALUES (:Content)\");\n\n$stmt->bindParam(':Content', $editorContent);\n\n$stmt->execute();\n\necho \"Save Data\";\n\n?>\n```\nCOPY\n\n1. Save the changes.\n### Saving TinyMCE content to the database file with PHP and SQLite\n1. In the browser, refresh the demo, and try entering some new content into the TinyMCE text area, and then clicking away from the editor or pressing the Enter key. If the PHP content is working, you’ll see a 200 status code on the command line (if you’re running the demo with a localhost for tests with Python or PHP):\n\n```\n[<date and time>] [::1]:60003 [200]: GET \/\n[<date and time>] [::1]:60003 Closing\n[<date and time>] [::1]:60003 [200]: GET \/tinymceConfig.js\n[<date and time>] [::1]:60003 Closing\n[<date and time>] [::1]:60003 Accepted\n[<date and time>] [::1]:60003 [200]: POST \/php\/save.php\n[<date and time>] [::1]:60003 Closing\n```\nCOPY\n\nThe successful command line content (code 200) indicates that the database file has been created in the *php* folder following the steps set in the *connect.php* file.\n\n1. Navigate into the *php* folder, and then open the *tinymceContent.db* database file with the *SQLite* command:\n\n```\nsqlite3 tinymceContent.db \n```\nCOPY\n\n1. Query the database Content table to see the TinyMCE content saved in the database:\n\n```\nSELECT * FROM Content;\n\n…\n\n1|<h1>Visiting Norway<\/h1>\n\n<p><strong><img style=\"float: right;\" src=\"https:\/\/images.pexels.com\/photos\/1559825\/pexels-photo-1559825.jpeg?auto=compress&amp;cs=tinysrgb&amp;dpr=2&amp;h=750&amp;w=1260\" alt=\"Town\" width=\"300\" height=\"375\"><\/strong>Norway, officially the Kingdom of Norway, is a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nordic_countries\">Nordic country<\/a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.<\/p>\n\n...\n```\nCOPY\n\n1. Exit the database using the *.quit* command\n## Next steps for saving TinyMCE content in a database\nYou can rapidly get content from the editor, and save TinyMCE content to a database making use of the process explained in the previous sections. In production, the pattern of collecting data with the [TinyMCE Get method,](https:\/\/www.tiny.cloud\/blog\/how-to-get-content-and-set-content-in-tinymce\/) and [binding parameters in prepared statements](https:\/\/www.w3schools.com\/php\/php_mysql_prepared_statements.asp) represent consistent patterns you can make use of for your project.\n\nFor more on getting a CMS ready using TinyMCE, check out [the tutorial on creating a CMS with TinyMCE](https:\/\/www.tiny.cloud\/blog\/tinymce-for-cms\/) to rival the major content management providers out there\\!\n\n[Try TinyMCE with your database, and sign up for your FREE API key today](https:\/\/www.tiny.cloud\/get-tiny\/)\n\n[Configuration](https:\/\/www.tiny.cloud\/blog\/tag\/configuration\/)[TinyMCE](https:\/\/www.tiny.cloud\/blog\/tag\/tinymce\/)\n\n![Joe Robinson](data:image\/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAQCAIAAACZeshMAAAABGdBTUEAALGPC\/xhBQAACilpQ0NQaWNjAABIiZ2Wd1RT2RaHz703vVCSEIqU0GtoUgJIDb1IkS4qMQkQSsCQACI2RFRwRFGRpggyKOCAo0ORsSKKhQFRsesEGUTUcXAUG5ZJZK0Z37x5782b3x\/3fmufvc\/dZ+991roAkPyDBcJMWAmADKFYFOHnxYiNi2dgBwEM8AADbADgcLOzQhb4RgKZAnzYjGyZE\/gXvboOIPn7KtM\/jMEA\/5+UuVkiMQBQmIzn8vjZXBkXyTg9V5wlt0\/JmLY0Tc4wSs4iWYIyVpNz8ixbfPaZZQ858zKEPBnLc87iZfDk3CfjjTkSvoyRYBkX5wj4uTK+JmODdEmGQMZv5LEZfE42ACiS3C7mc1NkbC1jkigygi3jeQDgSMlf8NIvWMzPE8sPxc7MWi4SJKeIGSZcU4aNkxOL4c\/PTeeLxcwwDjeNI+Ix2JkZWRzhcgBmz\/xZFHltGbIiO9g4OTgwbS1tvijUf138m5L3dpZehH\/uGUQf+MP2V36ZDQCwpmW12fqHbWkVAF3rAVC7\/YfNYC8AirK+dQ59cR66fF5SxOIsZyur3NxcSwGfaykv6O\/6nw5\/Q198z1K+3e\/lYXjzkziSdDFDXjduZnqmRMTIzuJw+Qzmn4f4Hwf+dR4WEfwkvogvlEVEy6ZMIEyWtVvIE4gFmUKGQPifmvgPw\/6k2bmWidr4EdCWWAKlIRpAfh4AKCoRIAl7ZCvQ730LxkcD+c2L0ZmYnfvPgv59V7hM\/sgWJH+OY0dEMrgSUc7smvxaAjQgAEVAA+pAG+gDE8AEtsARuAAP4AMCQSiIBHFgMeCCFJABRCAXFIC1oBiUgq1gJ6gGdaARNIM2cBh0gWPgNDgHLoHLYATcAVIwDp6AKfAKzEAQhIXIEBVSh3QgQ8gcsoVYkBvkAwVDEVAclAglQ0JIAhVA66BSqByqhuqhZuhb6Ch0GroADUO3oFFoEvoVegcjMAmmwVqwEWwFs2BPOAiOhBfByfAyOB8ugrfAlXADfBDuhE\/Dl+ARWAo\/gacRgBAROqKLMBEWwkZCkXgkCREhq5ASpAJpQNqQHqQfuYpIkafIWxQGRUUxUEyUC8ofFYXiopahVqE2o6pRB1CdqD7UVdQoagr1EU1Ga6LN0c7oAHQsOhmdiy5GV6Cb0B3os+gR9Dj6FQaDoWOMMY4Yf0wcJhWzArMZsxvTjjmFGcaMYaaxWKw61hzrig3FcrBibDG2CnsQexJ7BTuOfYMj4nRwtjhfXDxOiCvEVeBacCdwV3ATuBm8Et4Q74wPxfPwy\/Fl+EZ8D34IP46fISgTjAmuhEhCKmEtoZLQRjhLuEt4QSQS9YhOxHCigLiGWEk8RDxPHCW+JVFIZiQ2KYEkIW0h7SedIt0ivSCTyUZkD3I8WUzeQm4mnyHfJ79RoCpYKgQo8BRWK9QodCpcUXimiFc0VPRUXKyYr1iheERxSPGpEl7JSImtxFFapVSjdFTphtK0MlXZRjlUOUN5s3KL8gXlRxQsxYjiQ+FRiij7KGcoY1SEqk9lU7nUddRG6lnqOA1DM6YF0FJppbRvaIO0KRWKip1KtEqeSo3KcRUpHaEb0QPo6fQy+mH6dfo7VS1VT1W+6ibVNtUrqq\/V5qh5qPHVStTa1UbU3qkz1H3U09S3qXep39NAaZhphGvkauzROKvxdA5tjssc7pySOYfn3NaENc00IzRXaO7THNCc1tLW8tPK0qrSOqP1VJuu7aGdqr1D+4T2pA5Vx01HoLND56TOY4YKw5ORzqhk9DGmdDV1\/XUluvW6g7ozesZ6UXqFeu169\/QJ+iz9JP0d+r36UwY6BiEGBQatBrcN8YYswxTDXYb9hq+NjI1ijDYYdRk9MlYzDjDON241vmtCNnE3WWbSYHLNFGPKMk0z3W162Qw2szdLMasxGzKHzR3MBea7zYct0BZOFkKLBosbTBLTk5nDbGWOWtItgy0LLbssn1kZWMVbbbPqt\/pobW+dbt1ofceGYhNoU2jTY\/OrrZkt17bG9tpc8lzfuavnds99bmdux7fbY3fTnmofYr\/Bvtf+g4Ojg8ihzWHS0cAx0bHW8QaLxgpjbWadd0I7eTmtdjrm9NbZwVnsfNj5FxemS5pLi8ujecbz+PMa54256rlyXOtdpW4Mt0S3vW5Sd113jnuD+wMPfQ+eR5PHhKepZ6rnQc9nXtZeIq8Or9dsZ\/ZK9ilvxNvPu8R70IfiE+VT7XPfV8832bfVd8rP3m+F3yl\/tH+Q\/zb\/GwFaAdyA5oCpQMfAlYF9QaSgBUHVQQ+CzYJFwT0hcEhgyPaQu\/MN5wvnd4WC0IDQ7aH3wozDloV9H44JDwuvCX8YYRNRENG\/gLpgyYKWBa8ivSLLIu9EmURJonqjFaMTopujX8d4x5THSGOtYlfGXorTiBPEdcdj46Pjm+KnF\/os3LlwPME+oTjh+iLjRXmLLizWWJy++PgSxSWcJUcS0YkxiS2J7zmhnAbO9NKApbVLp7hs7i7uE54Hbwdvku\/KL+dPJLkmlSc9SnZN3p48meKeUpHyVMAWVAuep\/qn1qW+TgtN25\/2KT0mvT0Dl5GYcVRIEaYJ+zK1M\/Myh7PMs4qzpMucl+1cNiUKEjVlQ9mLsrvFNNnP1IDERLJeMprjllOT8yY3OvdInnKeMG9gudnyTcsn8n3zv16BWsFd0VugW7C2YHSl58r6VdCqpat6V+uvLlo9vsZvzYG1hLVpa38otC4sL3y5LmZdT5FW0ZqisfV+61uLFYpFxTc2uGyo24jaKNg4uGnupqpNH0t4JRdLrUsrSt9v5m6++JXNV5VffdqStGWwzKFsz1bMVuHW69vctx0oVy7PLx\/bHrK9cwdjR8mOlzuX7LxQYVdRt4uwS7JLWhlc2V1lULW16n11SvVIjVdNe61m7aba17t5u6\/s8djTVqdVV1r3bq9g7816v\/rOBqOGin2YfTn7HjZGN\/Z\/zfq6uUmjqbTpw37hfumBiAN9zY7NzS2aLWWtcKukdfJgwsHL33h\/093GbKtvp7eXHgKHJIcef5v47fXDQYd7j7COtH1n+F1tB7WjpBPqXN451ZXSJe2O6x4+Gni0t8elp+N7y+\/3H9M9VnNc5XjZCcKJohOfTuafnD6Vderp6eTTY71Leu+ciT1zrS+8b\/Bs0Nnz53zPnen37D953vX8sQvOF45eZF3suuRwqXPAfqDjB\/sfOgYdBjuHHIe6Lztd7hmeN3ziivuV01e9r567FnDt0sj8keHrUddv3ki4Ib3Ju\/noVvqt57dzbs\/cWXMXfbfkntK9ivua9xt+NP2xXeogPT7qPTrwYMGDO2PcsSc\/Zf\/0frzoIflhxYTORPMj20fHJn0nLz9e+Hj8SdaTmafFPyv\/XPvM5Nl3v3j8MjAVOzX+XPT806+bX6i\/2P\/S7mXvdNj0\/VcZr2Zel7xRf3PgLett\/7uYdxMzue+x7ys\/mH7o+Rj08e6njE+ffgP3hPP78QcZjQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAADhElEQVQYGQXBy08jZQAA8Hl9M9N5dcpMh5ZOaYFSWCgokmiyiRuSjXIwrCvx4NVkL96MnvT\/8aYHX\/HgTfcBLCUuFSwsLCx9dzqdtjPtPPt9\/n741199+PrubwrLFwvLj\/ceI5Cyx3fP\/\/ohCvmHu5+qymKjblfPf15bwQ8PztKpNIbLrdsujEJZniO\/fPJNQr5HUjwAZ\/W2Xz5+Kojp0tonEDGapmGIm01l67Wj\/149Ky7MZPRYp9\/s9dgP1mdVoUddX1fTmnrjNxZzBWci1Go\/moNIU94cHV8MLHN7K\/dgZ800e24kLqyUTs\/KXePu+BJfn1\/V1CRJxIyr6q8AtHkh37PwRvOi0Rie\/vLi\/mbh\/aUs4QSN9jnJkiJHqpqYTrM40rudvsRSnueS+\/tfNJpvWyYB6GKlWvEwQSaT33\/73Uc7D0vLxa2NTYXPvqy+DhE9GQ\/Wlx9EIQo8IUK8trBL6XPzB4iGgJmGNi8IkHD27n+WL6wGZhMPxyHCUlpyNbP529lP103k+YomwRgQOv2uvvQO6bhPg2ggywqBHJzhNHEisfmry39Ojv4I7FH51UGjZ0wJqmX3Rr6IUToOfQxSICY\/2n9CrKzuFYsf41iPAR6Al4lAziqJGZpk6DgSsiTBCMQkG2f0KfA9q1L587ByddPz7r27pSgqlVS1GSl3y9koHCOkLs2ATFILKFzh5czsfCIyWYEGvJjAKY5prq3mn500a0YL0Z2l5Vlye41jCZynGTKCbQd1BtON\/EaCgNGw36rdcOFAicdDDCt3m9ulHQonJE5DBAhs8\/nR75QmKPWm4U3aVoSGAbQm0cvTw4LAjGzoDvs+4YV07Y2H6lNyU6QLWV1ie8mEwPOwfH5Jarp4bbQaXdNGtG\/3hq7LQigBMkaynIc4OrIj58QcGAFmDyuuZ\/WNIEayth3QuEi1Jo4POdu3pTgLGL4Uw6y25+viFOCjyBJA2B6HF+0Gz8ZyBcy0rbHDeyPk49hoilM4KcHAljlKIeKqm5warpWAs8m56sW\/xl09lRQz6XnptE\/IwfUNDMCAIibTIEA4CBCgOCGVMSRylMYsInIiczB5cdfaLi0oIu\/KvCyKXcupn41ykurOQXKetNEkIcVAkMrSU\/zz93aZLnQi13KHyI8m\/qiMhhgG1vUZDkCIsPKto2LBMiYjQdQXU6O3ndRWTEgpnj38H0Bj0vI5fgnbAAAAOHRFWHRpY2M6Y29weXJpZ2h0AENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueflXeTcAAAAhdEVYdGljYzpkZXNjcmlwdGlvbgBzUkdCIElFQzYxOTY2LTIuMVet2kcAAAAmdEVYdGljYzptYW51ZmFjdHVyZXIASUVDIGh0dHA6Ly93d3cuaWVjLmNoHH8ATAAAADd0RVh0aWNjOm1vZGVsAElFQyA2MTk2Ni0yLjEgRGVmYXVsdCBSR0IgY29sb3VyIHNwYWNlIC0gc1JHQkRTSKkAAAAASUVORK5CYII=)\n\n![Joe Robinson](https:\/\/images.ctfassets.net\/s600jj41gsex\/2P4AEkP8R7iCxO4eT5voCe\/d18aa214c40aa5e1ecff6f6d216c8097\/Portrait-TinyTribe-JR100px.png?w=48&q=50&fit=scale)\n\nby[Joe Robinson](https:\/\/www.tiny.cloud\/blog\/author\/joseph-robinson\/)\n\nTechnical and creative writer, editor, and a TinyMCE advocate. An enthusiast for teamwork, open source software projects, and baking. Can often be found puzzling over obscure history, cryptic words, and lucid writing.\n\n## Related Articles\n- ![How to Create a Laravel Project with TinyMCE](data:image\/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAABqlBMVEUJElMKE1QAB08ABk4ABU4ABE4ACE8IElMCDFEAAk4AAU0AB04EDlEJE1QAAU4cIl0tMmkkKmUtMmgrMWgqL2gzOGsyN2s1Om0zOGwhJl8AA04AAEw5O2JlZn0rL1whKGQ8Q3o6QXk+RXo9RHpCSX1BSH08Q3gxOHEdJWMAAE4ABk8tMVxWWHMcIVYjKWVbZZdseKdrdqZrd6Zsd6ZqdaVjbZ5YYpVFTYMsMmtCRW4EDlIAAU8ABU8BDlMAA08jKmRdZ5hveqlueahpdKRhbJ1aZJdBS4Nxcoq6usFJS2wAAFAOFVQEDVEmLGVaZJRpdKJoc6BpdKFkb5xgaplZYpNETIJHS3RzdIohJVgCDVIDDFABCU8iKGQ7Ro0+SpI\/SpA\/SpFAS5BAS5FDTpM1Pn8jKmkEFF4AAE0JElIAAUoOHGdTZdNwf+RvfuJygONtfOJse+J1guNxgOQuQKQaIFgUG1kLE1IABU0SIXEcKHYVI3QeKXUXJXUfKnYcKXgEFGABCEsFDlAIEFEMFFILFFQAA0sAAEIAADwAADsAAD0AAD8AAUgBCE4CC0\/x2NGcAAAAgUlEQVQIHV3BsQ2CUBRA0XvhCcYCYu0EDuJSJjS6hzs4iBs4gIWFpQnIFz9UniOKAjJJqaRP1n4YRSCwH9d9ZdRvy8oJzh7gzkWiMLsTtP6BSFszUuFsiHg8D2a4CCJozXABBcO1ydrZpRmGqKvUvLbqWPrTuVHPp9VRJVE4ubnvvvvOH3NuUin\/AAAAAElFTkSuQmCC)\n  \n  ![How to Create a Laravel Project with TinyMCE](https:\/\/images.ctfassets.net\/s600jj41gsex\/5d3MI3yLPU2yRuI7mWlOw3\/3c0ecc44fff59f8f90e95ec82267edde\/How_to_Create_a_Laravel_Project_with_TinyMCE.png?w=739&q=50&fit=scale)\n  \n  [How-to Use TinyMCE](https:\/\/www.tiny.cloud\/blog\/category\/how-tos-and-tutorials\/)\n  \n  Feb 26th, 2026\n  ### [How to Integrate TinyMCE into a Laravel Project](https:\/\/www.tiny.cloud\/blog\/how-to-add-tinymce-to-laravel\/)\n- ![How to Build a Team Collaboration App with TinyMCE + React](data:image\/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAABtlBMVEUIE1QAB08ACE8ABk8IElQIElMGElQACVEAAE8AAU8AA08ABE8ACVAADlMADlQAClEADFQAEVUHE1UeF04kGk4jGE4ODU8oGE4RDU8OC08AD1QpJFg3KFYAEVYAAVAAE1ZCMFUvJlcADFMAAFBnSkmQZEKLXENxRkh9SUiLTUhwOktGLlZNL1MAAFgACVlVM1M8KFdTOkiAVj6FVT1\/TEB2QUOFRUJ2OUZ0Nk2BOk9LIFAABlEAAlhZXHebnKddYXsAA1kAEFUACFAAAEtMQ1x7aGyCbG56X2VzWGSBZnB5XmxaKU11NE9CHE+VlqLZ2dyUlaIAAFEAA1AAAEdaXXZ\/gZKIi5qHipp4fI6FiZh0eIsADFEAAE4AAk8ACFMABlUAAFZGSmx8fo89Q2oAFloIF1dQUW2JiZeRkZ6YmaSHiJYLE1EAAEgAAE0ABE4ABFEXI1yEhZRqa4IAAFQADVlZN1E+K1YAAEwDC08wMlw+QGMxM1wvMVsABU8ZJV2IiZhub4QAAFMAElUtIlgeHlgADFIHEVMAB1AAAk4ACVQAE1gADlYABVEBEVQJE1QKE1QAB04JElMYf15lAAAAm0lEQVQIHQXBMS5EUQAF0HteXsbjxxDVZEQh0chX2oHEDuxCNEIyyZRahcJC9JagoVBPJGpiZFB950gkkSQZIkPBCOJ3SDaw3ITWAV8rE4C6C\/hYK997rDoW2iEArz3gBIDH6fspPNRtAM4AtWYHANyfs14PwCL7NxdjZMxV3fL5lOOjGZOCv9vrdlla++n70UwyH16e37Lsyt0\/AyIgqverEawAAAAASUVORK5CYII=)\n  \n  ![How to Build a Team Collaboration App with TinyMCE + React](https:\/\/images.ctfassets.net\/s600jj41gsex\/5aMx0eNy8VUErE5AO5ZkiQ\/c9d7e2d4aea4b8402e3bf3b2893ce162\/How_to_Build_a_Team_Collaboration_App_with_TinyMCE___React.png?w=739&q=50&fit=scale)\n  \n  [How-to Use TinyMCE](https:\/\/www.tiny.cloud\/blog\/category\/how-tos-and-tutorials\/)\n  \n  Feb 18th, 2026\n  ### [How to Build a Team Collaboration App with TinyMCE and React](https:\/\/www.tiny.cloud\/blog\/how-to-build-React-team-collaboration-app\/)\n- ![How to Build a Help Desk App in React with TinyMCE](data:image\/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAABsFBMVEUKE1QACE8AB08ABk4KElMJElMEDVEABU4ABk8ABU8ACVADDVMAClEACVEDCVIHD1QJElQAAU4AAEwAAEoAAEsAAEkAAE4EDFMTKFwQLl4ED1UAAVAFElURN2MSLF4BCFI2N15NTWpBQWNERGVRUW1SUm0yO2AANF4AO2EAIVUEBVITN2MLQWgAAFcAAE8AB1gKQ2kRM2ECCFIAAEdYW3SIiph8fY17fI2JiZeNjZpXboMAXHgAbYQARmgBAE4EEVUABVhZXHebnKdeYXsDD1QAB1AAAEgAQWYAYn0AXnoAX3oAUnEAZn8AXHcAFVKVlqLZ2dyUlaIAAFAAAlBPU26Fiph0eIp6f4+Ah5aNkJ1+gpEgM1wAGlMECFEOEVUJClUAClhIS2x8fo8+Q2kAE1oIFlY6O2BeXnZKSmhPTmtkY3leXXVUVG8ODE8AAE0KD1UONWQEY4cJNGQAAlcAEVkLOmMSL18DDFMKDVUIUHcAjK8IT3cIClUAA1AGElURJlsRIVoBClIABE4JElUTI1oPPWoJEVQBCVABC1IGEFQLFFQFCVIFAVIFCFIAB04LE1QrHffIAAAAnElEQVQIHWXBMQ7BYBiA4e9tv0p+pSKV2AiLSzgAk8TqEI5gEqPF5h5NLNLR4gx2i6TageRvNWmaCM+DCFJDpKCk0gBBircUBiHzKXWBwsnJRamp2+KPDvlx76MhPAOwChcvHEGHSKVNQGVGRekt+XYbU+ri5s4gvK6Oa2rOI03SZDHNDi\/f901za4zZu7I7WRvHVnAn6m3sea7RB77EJUgK3FzNAAAAAElFTkSuQmCC)\n  \n  ![How to Build a Help Desk App in React with TinyMCE](https:\/\/images.ctfassets.net\/s600jj41gsex\/4EDRrkGzEoAesCGWovUmwu\/d2955fa54b279c00374849c8e3735f51\/How_to_Build_a_Help_Desk_App_in_React_with_TinyMCE.png?w=739&q=50&fit=scale)\n  \n  [How-to Use TinyMCE](https:\/\/www.tiny.cloud\/blog\/category\/how-tos-and-tutorials\/)\n  \n  Feb 11th, 2026\n  ### [How to Build a Help Desk App in React with TinyMCE](https:\/\/www.tiny.cloud\/blog\/build-help-desk-app-with-react\/)\n\nJoin 100,000+ developers who get regular tips & updates from the Tiny team.\n\nThis site is protected by reCAPTCHA and the Google [Privacy Policy](https:\/\/policies.google.com\/privacy) and [Terms of Service](https:\/\/policies.google.com\/terms) apply.\n\nStay connected\n\n[![SOC2 compliance badge](https:\/\/www.tiny.cloud\/images\/footer\/SOC2-compliance.png)](https:\/\/www.tiny.cloud\/tinymce\/security)\n\n### Products\n- [TinyMCE](https:\/\/www.tiny.cloud\/tinymce)\n- [Drive](https:\/\/www.tiny.cloud\/drive)\n- [MoxieManager](https:\/\/www.tiny.cloud\/moxiemanager)\n\n### Pricing\n- [TinyMCE](https:\/\/www.tiny.cloud\/pricing)\n- [Drive](https:\/\/www.tiny.cloud\/pricing\/drive)\n- [MoxieManager](https:\/\/www.tiny.cloud\/pricing\/moxiemanager)\n\n### Developers\n- [Documentation](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest)\n- [Get Started](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/cloud-quick-start)\n- [Integrations](https:\/\/www.tiny.cloud\/developer-center\/editor-framework-integration)\n- [API Reference](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/apis\/tinymce.root)\n- [Roadmap](https:\/\/www.tiny.cloud\/roadmap)\n- [Support](https:\/\/www.tiny.cloud\/docs\/tinymce\/latest\/support)\n- [Blog](https:\/\/www.tiny.cloud\/blog)\n- [Get TinyMCE Free](https:\/\/www.tiny.cloud\/get-tiny)\n\n### Company\n- [About](https:\/\/www.tiny.cloud\/about)\n- [Customer Stories](https:\/\/www.tiny.cloud\/customer-stories)\n- [Careers](https:\/\/tiugotech.recruitee.com\/)\n- [Partners](https:\/\/www.tiny.cloud\/partner-directory)\n- [News](https:\/\/www.tiny.cloud\/news)\n- [Contact Us](https:\/\/www.tiny.cloud\/contact)\n- [Legal](https:\/\/www.tiny.cloud\/legal)\n- [Security](https:\/\/www.tiny.cloud\/tinymce\/security)\n- [Trust Center](https:\/\/www.tiny.cloud\/trust-center)\n- [Status Page](https:\/\/status.tiny.cloud\/)\n\n© Copyright 2026 Tiny Technologies Inc.  \nTinyMCE® and Tiny® are registered trademarks of Tiny Technologies, Inc.","attrs_readable_markdown":"Databases are all around us, and without them websites and applications wouldn’t work. Since they’re so vital to online applications, why would components included in those applications – components that claim to speed up development – cause more problems and frustration by blocking database connections?\n\nFor instance, the rich text editor component of an application lives at the center of content creation apps. A valuable rich text editor provides a fast and easy flow of content from the editor to the database without any roadblocks. Speed and efficiency are a part of best practice for database content management.\n\n[TinyMCE is an trusted rich text editor](https:\/\/www.tiny.cloud\/) that allows you to save content to a database without obstacles. It’s just one example of the many ways TinyMCE is easy to implement, and this post shows you how to save TinyMCE content to a database.\n\n## What is database content management?\nDatabase content management is the ability to store and serve content from the database, to anywhere it’s needed in an application. When database content management is done effectively, it shows at the very least, the following practices:\n\n1. Allows for storage of a variety of digital content, including images, text, video, and audio files\n2. Fast and effective storage and retrieval\n3. Follows a standardized naming convention\n4. Connects metadata to each item in the database, providing information to identify content\n5. Plans for storage that fits the content, such as local storage, or cloud based storage.\n\nPlus, there’s [more to consider before testing out a database](https:\/\/www.tableau.com\/learn\/articles\/data-management-best-practices) for content management. Once you’re ready, the following sections explain the steps to save TinyMCE content to a database using an SQLite demo.\n\n## How to save TinyMCE content to a database with PHP\nThe first step is getting TinyMCE working. The following demo is based on [the TinyMCE CMS solution](https:\/\/www.tiny.cloud\/solutions\/cms-editor\/). There are some prerequisites to know about before running the demo:\n\n1. Experience with HTML and JavaScript\n2. Familiarity with PHP, including prepared statements\n3. A text editor to adjust file content\n4. Access to the command line through bash or another shell\n### Getting TinyMCE started\n1. In your development environment, create a new directory for the demo, create an *index.html* file in that directory. Also set up two more folders in the new directory, one for scripts, and one for PHP:\n```\nmkdir demoApp\/\n\ncd demoApp\/\n\ntouch index.html\n\nmkdir scripts\/\nmkdir php\/\n```\n1. Change into the *scripts* folder and create a new JavaScript file for the TinyMCE configuration, which is set up in step 5 of this procedure:\n```\ncd scripts\/\n\ntouch tinymceConfig.js\n```\n1. Change out of the *scripts* folder and then in the main directory, open the *index.html* file. Add the following starter HTML:\n```\n<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n  <meta charset=\"utf-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n  <script src=\"https:\/\/code.jquery.com\/jquery-3.7.0.js\"><\/script>\n  <script src=\"https:\/\/cdn.tiny.cloud\/1\/no-api-key\/tinymce\/6\/tinymce.min.js\" referrerpolicy=\"origin\"><\/script>\n  <script src=\"scripts\/tinymceConfig.js\"><\/script>\n<\/head>\n\n<body>\n  <h1>TinyMCE CMS Starter Config<\/h1>\n  <textarea>\n    <h1>Visiting Norway<\/h1>\n    <p><strong><img style=\"float: right;\" src=\"https:\/\/images.pexels.com\/photos\/1559825\/pexels-photo-1559825.jpeg?auto=compress&amp;cs=tinysrgb&amp;dpr=2&amp;h=750&amp;w=1260\" alt=\"Town\" width=\"300\" height=\"375\"><\/strong>Norway, officially the Kingdom of Norway, is a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nordic_countries\">Nordic country<\/a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.<\/p>\n    <p>The remote Arctic island of Jan Mayen and the archipelago of Svalbard also form part of Norway. Bouvet Island, located in the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Subantarctic\">Subantarctic<\/a>, is a dependency of Norway; it also lays claims to the Antarctic territories of Peter I Island and Queen Maud Land. The capital and largest city in Norway is <a href=\"https:\/\/en.wikipedia.org\/wiki\/Oslo\">Oslo<\/a>.<strong><br><\/strong><\/p>\n    <p>Listen to Norway's royal anthem on Spotify:<\/p>\n    <div style=\"left: 0px; width: 100%; height: 152px; position: relative; max-width: 650px;\" data-ephox-embed-iri=\"https:\/\/open.spotify.com\/track\/6SPocux2pBpFp3lshAOek1?si=907d52cf2af94efc\"><iframe style=\"top: 0; left: 0; width: 100%; height: 100%; position: absolute; border: 0;\" src=\"https:\/\/open.spotify.com\/embed\/track\/6SPocux2pBpFp3lshAOek1?utm_source=oembed\" allow=\"clipboard-write; encrypted-media; fullscreen; picture-in-picture;\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n    <h2>Geography<\/h2>\n    <p>Norway has a total area of 385,207 square kilometres (148,729 sq mi) and had a population of 5,425,270 in January 2022. The country shares a long eastern border with Sweden at a length of 1,619 km (1,006 mi). It is bordered by Finland and Russia to the northeast and the Skagerrak strait to the south, on the other side of which are Denmark and the United Kingdom.<\/p>\n    <p>Norway has an extensive coastline, facing the North Atlantic Ocean and the Barents Sea. The maritime influence dominates Norway's climate, with mild lowland temperatures on the sea coasts; the interior, while colder, is also significantly milder than areas elsewhere in the world on such northerly latitudes. Even during polar night in the north, temperatures above freezing are commonplace on the coastline. The maritime influence brings high rainfall and snowfall to some areas of the country.<\/p>\n    <p><em>Featuring <a href=\"https:\/\/en.wikipedia.org\/wiki\/Norway\">content from Wikipedia<\/a><\/em><\/p>\n  <\/textarea>\n<\/body>\n<\/html>\n```\n1. Add a link to TinyMCE through the CDN in the head section of the document, and a link to the TinyMCE configuration file:\n```\n  <script src=\"https:\/\/cdn.tiny.cloud\/1\/no-api-key\/tinymce\/6\/tinymce.min.js\" referrerpolicy=\"origin\"><\/script>\n  <script src=\"scripts\/tinymceConfig.js\"><\/script>\n```\n> **Note:** The CMS demo makes use of several Premium plugins. When you [sign up for a FREE TinyMCE API key](https:\/\/www.tiny.cloud\/auth\/signup\/), you get free access to all Premium plugins for 14 days from when you replace the “no-api-key” string with your own TinyMCE API key. Adding the key also removes any domain name related errors appearing in the text area.\n\n1. Change back into the *scripts\/tinymceConfig.js* file, open it, and add the following JavaScript content to get TinyMCE started:\n```\ntinymce.init({\n  selector: \"#editor\",\n  plugins:\n    \"a11ychecker advcode advlist advtable anchor autocorrect autosave editimage image link linkchecker lists media mediaembed pageembed powerpaste searchreplace table template tinymcespellchecker typography visualblocks wordcount\",\n  toolbar:\n    \"undo redo | styles | bold italic underline strikethrough | align | table link image media pageembed | bullist numlist outdent indent | spellcheckdialog a11ycheck typography code\",\n  height: 540,\n  a11ychecker_level: \"aaa\",\n  typography_langs: [\"en-US\"],\n  typography_default_lang: \"en-US\",\n  advcode_inline: true,\n  content_style: `\n        body {\n          font-family: 'Roboto', sans-serif;\n          color: #222;\n        }\n        img {\n          height: auto;\n          margin: auto;\n          padding: 10px;\n          display: block;\n        }\n        img.medium {\n          max-width: 25%;\n        }\n        a {\n          color: #116B59;\n        }\n        .related-content {\n          padding: 0 10px;\n          margin: 0 0 15px 15px;\n          background: #eee;\n          width: 200px;\n          float: right;\n        }\n      `,\n});\n```\n1. Save the changes, and then change back into the main directory. Test out the demo by opening the *index.html* file in a browser, or by running a localhost test [with the Python command,](https:\/\/ryanblunden.com\/create-a-http-server-with-one-command-thanks-to-python-29fcfdcd240e) or [PHP command](https:\/\/www.php.net\/manual\/en\/features.commandline.webserver.php):\n\n![The TinyMCE CMS demo working in the browser and ready to be saved to the database](https:\/\/images.ctfassets.net\/s600jj41gsex\/6LO93YvgD4nqcJyVIQfpza\/5b0362977008cbb4f567cb7a9e53010f\/img-TinyMCE-save-database-0.gif)\n\n### Getting the database connection established\n1. Change into the *scripts* folder, and add the following JavaScript to the TinyMCE init script after the *content\\_style* option. It uses the TinyMCE setup option to listen for the change event.\n   \n   The change event registers when the editor loses focus, or the writer presses the Enter key.\n   \n   When the event happens, the jQuery gets the rich text editor content, and posts it onward to the database handler file. This content is what saves TinyMCE content to the database:\n```\n    setup: (editor) => {\n        editor.on('change', (e) => {\n          $.ajax({\n            type: 'POST',\n            url: 'php\/save.php',\n            data: {\n              editor: tinymce.get('editor').getContent()\n            },\n            success: function(data){\n              $('#editor').val('');\n              console.log(data)\n            }\n          })\n        })\n      },\n```\n1. Change back to the main directory, and then change into the *php* folder. Create a new PHP file for handling interactions with the database:\n```\ntouch connect.php\n```\n1. Add the following PHP content to the connection file. This receives the editor content, and then saves the TinyMCE content to a database file:\n```\n<?php\n\n$connect=new SQLite3('tinymceContent.db') or die(\"Could not connect to database, and save TinyMCE content\");\n$db=\"CREATE TABLE IF NOT EXISTS `Content`(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Content TEXT)\";\n\n$connect->exec($db);\n\n?>\n```\n1. Save the changes, and then close the *.php* file.\n2. Create a second *.php* file to handle the process of inserting and saving TinyMCE content into the database, and then add the following PHP content:\n```\ntouch save.php\n\n...\n\n<?php\n\nrequire_once 'connect.php';\n$editorContent=$_POST['editor'];\n\n$stmt = $connect->prepare(\"INSERT INTO `Content` (Content) VALUES (:Content)\");\n\n$stmt->bindParam(':Content', $editorContent);\n\n$stmt->execute();\n\necho \"Save Data\";\n\n?>\n```\n1. Save the changes.\n### Saving TinyMCE content to the database file with PHP and SQLite\n1. In the browser, refresh the demo, and try entering some new content into the TinyMCE text area, and then clicking away from the editor or pressing the Enter key. If the PHP content is working, you’ll see a 200 status code on the command line (if you’re running the demo with a localhost for tests with Python or PHP):\n```\n[<date and time>] [::1]:60003 [200]: GET \/\n[<date and time>] [::1]:60003 Closing\n[<date and time>] [::1]:60003 [200]: GET \/tinymceConfig.js\n[<date and time>] [::1]:60003 Closing\n[<date and time>] [::1]:60003 Accepted\n[<date and time>] [::1]:60003 [200]: POST \/php\/save.php\n[<date and time>] [::1]:60003 Closing\n```\nThe successful command line content (code 200) indicates that the database file has been created in the *php* folder following the steps set in the *connect.php* file.\n\n1. Navigate into the *php* folder, and then open the *tinymceContent.db* database file with the *SQLite* command:\n```\nsqlite3 tinymceContent.db \n```\n1. Query the database Content table to see the TinyMCE content saved in the database:\n```\nSELECT * FROM Content;\n\n…\n\n1|<h1>Visiting Norway<\/h1>\n\n<p><strong><img style=\"float: right;\" src=\"https:\/\/images.pexels.com\/photos\/1559825\/pexels-photo-1559825.jpeg?auto=compress&amp;cs=tinysrgb&amp;dpr=2&amp;h=750&amp;w=1260\" alt=\"Town\" width=\"300\" height=\"375\"><\/strong>Norway, officially the Kingdom of Norway, is a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nordic_countries\">Nordic country<\/a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.<\/p>\n\n...\n```\n1. Exit the database using the *.quit* command\n## Next steps for saving TinyMCE content in a database\nYou can rapidly get content from the editor, and save TinyMCE content to a database making use of the process explained in the previous sections. In production, the pattern of collecting data with the [TinyMCE Get method,](https:\/\/www.tiny.cloud\/blog\/how-to-get-content-and-set-content-in-tinymce\/) and [binding parameters in prepared statements](https:\/\/www.w3schools.com\/php\/php_mysql_prepared_statements.asp) represent consistent patterns you can make use of for your project.\n\nFor more on getting a CMS ready using TinyMCE, check out [the tutorial on creating a CMS with TinyMCE](https:\/\/www.tiny.cloud\/blog\/tinymce-for-cms\/) to rival the major content management providers out there\\!","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

4 hours ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://www.tiny.cloud/blog/save-content-database/
Last Crawled	2026-04-07 00:17:37 (4 hours ago)
First Indexed	2023-06-20 11:27:53 (2 years ago)
HTTP Status Code	200
Meta Title	How to save content to database \| TinyMCE
Meta Description	Learn how to seamlessly save TinyMCE content to a database using PHP and SQLite. Follow our comprehensive tutorial for efficient database integration with the powerful TinyMCE editor.
Meta Canonical	null
Boilerpipe Text	Databases are all around us, and without them websites and applications wouldn’t work. Since they’re so vital to online applications, why would components included in those applications – components that claim to speed up development – cause more problems and frustration by blocking database connections? For instance, the rich text editor component of an application lives at the center of content creation apps. A valuable rich text editor provides a fast and easy flow of content from the editor to the database without any roadblocks. Speed and efficiency are a part of best practice for database content management. TinyMCE is an trusted rich text editor that allows you to save content to a database without obstacles. It’s just one example of the many ways TinyMCE is easy to implement, and this post shows you how to save TinyMCE content to a database. What is database content management? Database content management is the ability to store and serve content from the database, to anywhere it’s needed in an application. When database content management is done effectively, it shows at the very least, the following practices: Allows for storage of a variety of digital content, including images, text, video, and audio files Fast and effective storage and retrieval Follows a standardized naming convention Connects metadata to each item in the database, providing information to identify content Plans for storage that fits the content, such as local storage, or cloud based storage. Plus, there’s more to consider before testing out a database for content management. Once you’re ready, the following sections explain the steps to save TinyMCE content to a database using an SQLite demo. How to save TinyMCE content to a database with PHP The first step is getting TinyMCE working. The following demo is based on the TinyMCE CMS solution . There are some prerequisites to know about before running the demo: Experience with HTML and JavaScript Familiarity with PHP, including prepared statements A text editor to adjust file content Access to the command line through bash or another shell Getting TinyMCE started In your development environment, create a new directory for the demo, create an index.html file in that directory. Also set up two more folders in the new directory, one for scripts, and one for PHP: mkdir demoApp/ cd demoApp/ touch index.html mkdir scripts/ mkdir php/ Change into the scripts folder and create a new JavaScript file for the TinyMCE configuration, which is set up in step 5 of this procedure: cd scripts/ touch tinymceConfig.js Change out of the scripts folder and then in the main directory, open the index.html file. Add the following starter HTML: <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="https://code.jquery.com/jquery-3.7.0.js"></script> <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script> <script src="scripts/tinymceConfig.js"></script> </head> <body> <h1>TinyMCE CMS Starter Config</h1> <textarea> <h1>Visiting Norway</h1> <p><strong><img style="float: right;" src="https://images.pexels.com/photos/1559825/pexels-photo-1559825.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260" alt="Town" width="300" height="375"></strong>Norway, officially the Kingdom of Norway, is a <a href="https://en.wikipedia.org/wiki/Nordic_countries">Nordic country</a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.</p> <p>The remote Arctic island of Jan Mayen and the archipelago of Svalbard also form part of Norway. Bouvet Island, located in the <a href="https://en.wikipedia.org/wiki/Subantarctic">Subantarctic</a>, is a dependency of Norway; it also lays claims to the Antarctic territories of Peter I Island and Queen Maud Land. The capital and largest city in Norway is <a href="https://en.wikipedia.org/wiki/Oslo">Oslo</a>.<strong><br></strong></p> <p>Listen to Norway's royal anthem on Spotify:</p> <div style="left: 0px; width: 100%; height: 152px; position: relative; max-width: 650px;" data-ephox-embed-iri="https://open.spotify.com/track/6SPocux2pBpFp3lshAOek1?si=907d52cf2af94efc"><iframe style="top: 0; left: 0; width: 100%; height: 100%; position: absolute; border: 0;" src="https://open.spotify.com/embed/track/6SPocux2pBpFp3lshAOek1?utm_source=oembed" allow="clipboard-write; encrypted-media; fullscreen; picture-in-picture;" allowfullscreen="allowfullscreen"></iframe></div> <h2>Geography</h2> <p>Norway has a total area of 385,207 square kilometres (148,729 sq mi) and had a population of 5,425,270 in January 2022. The country shares a long eastern border with Sweden at a length of 1,619 km (1,006 mi). It is bordered by Finland and Russia to the northeast and the Skagerrak strait to the south, on the other side of which are Denmark and the United Kingdom.</p> <p>Norway has an extensive coastline, facing the North Atlantic Ocean and the Barents Sea. The maritime influence dominates Norway's climate, with mild lowland temperatures on the sea coasts; the interior, while colder, is also significantly milder than areas elsewhere in the world on such northerly latitudes. Even during polar night in the north, temperatures above freezing are commonplace on the coastline. The maritime influence brings high rainfall and snowfall to some areas of the country.</p> <p><em>Featuring <a href="https://en.wikipedia.org/wiki/Norway">content from Wikipedia</a></em></p> </textarea> </body> </html> Add a link to TinyMCE through the CDN in the head section of the document, and a link to the TinyMCE configuration file: <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script> <script src="scripts/tinymceConfig.js"></script> Note: The CMS demo makes use of several Premium plugins. When you sign up for a FREE TinyMCE API key , you get free access to all Premium plugins for 14 days from when you replace the “no-api-key” string with your own TinyMCE API key. Adding the key also removes any domain name related errors appearing in the text area. Change back into the scripts/tinymceConfig.js file, open it, and add the following JavaScript content to get TinyMCE started: tinymce.init({ selector: "#editor", plugins: "a11ychecker advcode advlist advtable anchor autocorrect autosave editimage image link linkchecker lists media mediaembed pageembed powerpaste searchreplace table template tinymcespellchecker typography visualblocks wordcount", toolbar: "undo redo \| styles \| bold italic underline strikethrough \| align \| table link image media pageembed \| bullist numlist outdent indent \| spellcheckdialog a11ycheck typography code", height: 540, a11ychecker_level: "aaa", typography_langs: ["en-US"], typography_default_lang: "en-US", advcode_inline: true, content_style: ` body { font-family: 'Roboto', sans-serif; color: #222; } img { height: auto; margin: auto; padding: 10px; display: block; } img.medium { max-width: 25%; } a { color: #116B59; } .related-content { padding: 0 10px; margin: 0 0 15px 15px; background: #eee; width: 200px; float: right; } `, }); Save the changes, and then change back into the main directory. Test out the demo by opening the index.html file in a browser, or by running a localhost test with the Python command, or PHP command : Getting the database connection established Change into the scripts folder, and add the following JavaScript to the TinyMCE init script after the content_style option. It uses the TinyMCE setup option to listen for the change event. The change event registers when the editor loses focus, or the writer presses the Enter key. When the event happens, the jQuery gets the rich text editor content, and posts it onward to the database handler file. This content is what saves TinyMCE content to the database: setup: (editor) => { editor.on('change', (e) => { $.ajax({ type: 'POST', url: 'php/save.php', data: { editor: tinymce.get('editor').getContent() }, success: function(data){ $('#editor').val(''); console.log(data) } }) }) }, Change back to the main directory, and then change into the php folder. Create a new PHP file for handling interactions with the database: touch connect.php Add the following PHP content to the connection file. This receives the editor content, and then saves the TinyMCE content to a database file: <?php $connect=new SQLite3('tinymceContent.db') or die("Could not connect to database, and save TinyMCE content"); $db="CREATE TABLE IF NOT EXISTS `Content`(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Content TEXT)"; $connect->exec($db); ?> Save the changes, and then close the .php file. Create a second .php file to handle the process of inserting and saving TinyMCE content into the database, and then add the following PHP content: touch save.php ... <?php require_once 'connect.php'; $editorContent=$_POST['editor']; $stmt = $connect->prepare("INSERT INTO `Content` (Content) VALUES (:Content)"); $stmt->bindParam(':Content', $editorContent); $stmt->execute(); echo "Save Data"; ?> Save the changes. Saving TinyMCE content to the database file with PHP and SQLite In the browser, refresh the demo, and try entering some new content into the TinyMCE text area, and then clicking away from the editor or pressing the Enter key. If the PHP content is working, you’ll see a 200 status code on the command line (if you’re running the demo with a localhost for tests with Python or PHP): [<date and time>] [::1]:60003 [200]: GET / [<date and time>] [::1]:60003 Closing [<date and time>] [::1]:60003 [200]: GET /tinymceConfig.js [<date and time>] [::1]:60003 Closing [<date and time>] [::1]:60003 Accepted [<date and time>] [::1]:60003 [200]: POST /php/save.php [<date and time>] [::1]:60003 Closing The successful command line content (code 200) indicates that the database file has been created in the php folder following the steps set in the connect.php file. Navigate into the php folder, and then open the tinymceContent.db database file with the SQLite command: sqlite3 tinymceContent.db Query the database Content table to see the TinyMCE content saved in the database: SELECT * FROM Content; … 1\|<h1>Visiting Norway</h1> <p><strong><img style="float: right;" src="https://images.pexels.com/photos/1559825/pexels-photo-1559825.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260" alt="Town" width="300" height="375"></strong>Norway, officially the Kingdom of Norway, is a <a href="https://en.wikipedia.org/wiki/Nordic_countries">Nordic country</a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.</p> ... Exit the database using the .quit command Next steps for saving TinyMCE content in a database You can rapidly get content from the editor, and save TinyMCE content to a database making use of the process explained in the previous sections. In production, the pattern of collecting data with the TinyMCE Get method, and binding parameters in prepared statements represent consistent patterns you can make use of for your project. For more on getting a CMS ready using TinyMCE, check out the tutorial on creating a CMS with TinyMCE to rival the major content management providers out there!
Markdown	Products [TinyMCEThe world's most trusted WYSIWYG HTML editor, for total control over your rich text editing.](https://www.tiny.cloud/tinymce/) - [Overview](https://www.tiny.cloud/tinymce/) - [Features](https://www.tiny.cloud/tinymce/features/) - [Pricing](https://www.tiny.cloud/pricing/) - [Documentation](https://www.tiny.cloud/docs/tinymce/latest/) - [Demos](https://www.tiny.cloud/docs/tinymce/latest/full-featured-premium-demo/) [MoxieManagerMedia file management simplified in a PHP or .NET environment.](https://www.tiny.cloud/moxiemanager/) [DriveFile and image management directly in the cloud.](https://www.tiny.cloud/drive/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") Developers [Developer CenterExplore frameworks, solutions, and technical guides for building with TinyMCE.](https://www.tiny.cloud/developer-center/) - [Frameworks](https://www.tiny.cloud/developer-center/frameworks/) - [Use Cases](https://www.tiny.cloud/developer-center/use-cases/) [Support](https://www.tiny.cloud/docs/tinymce/latest/support/) - [License Keys](https://www.tiny.cloud/docs/tinymce/latest/license-key/) - [Editor Loads](https://www.tiny.cloud/docs/tinymce/latest/understanding-editor-loads/) - [Submit a Support Request](https://support.tiny.cloud/hc/en-us/) [DocumentationIn-depth documentation to help you develop with and customize Tiny products.](https://www.tiny.cloud/docs/tinymce/latest/) - [Getting Started](https://www.tiny.cloud/docs/tinymce/latest/getting-started/) - [Basic Setup](https://www.tiny.cloud/docs/tinymce/latest/basic-setup/) - [API Reference](https://www.tiny.cloud/docs/tinymce/latest/apis/tinymce.root/) - [Migrating to TinyMCE](https://www.tiny.cloud/migrate-to-tinymce/) - [Download TinyMCE Free](https://www.tiny.cloud/get-tiny/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") Solutions [Use CasesOut-of-the-box editor with infinite use cases and complete design flexibility.](https://www.tiny.cloud/solutions/) - [Content Management System](https://www.tiny.cloud/solutions/cms-editor/) - [Email and Messaging Platform](https://www.tiny.cloud/solutions/wysiwyg-email-editor/) - [Document Management System](https://www.tiny.cloud/solutions/dms-editor/) - [Customer Relationship Management](https://www.tiny.cloud/solutions/crm-editor/) - [Learning Management System](https://www.tiny.cloud/solutions/lms-editor/) - [Internal & SaaS Applications](https://www.tiny.cloud/solutions/saas-applications-editor/) - [Workflow & Collaboration](https://www.tiny.cloud/solutions/workflow-management-editor/) [Roles](https://www.tiny.cloud/html-text-editor-for-developers/) - [Developer](https://www.tiny.cloud/html-text-editor-for-developers/) - [Product Manager](https://www.tiny.cloud/html-text-editor-for-product-managers/) - [Senior Manager](https://www.tiny.cloud/html-text-editor-for-scaling-and-monetizing/) [Security](https://www.tiny.cloud/tinymce/security/)[Hosting](https://www.tiny.cloud/solutions/on-premise-or-cloud-based-text-editor/)[Customization](https://www.tiny.cloud/solutions/customize-text-editor/)[Frameworks & Integrations](https://www.tiny.cloud/solutions/editor-framework-integration/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") Resources [BlogRead the world's best blog on WYSIWYG HTML editors, rich text editing, and insights on building SaaS application editors.](https://www.tiny.cloud/blog/) [Events & WebinarsExplore upcoming and on-demand events and webinars to unlock the full potential of TinyMCE.](https://www.tiny.cloud/events-and-webinars/) [Case StudiesDiscover why industry leaders and scaling start-ups love, use and trust Tiny products.](https://www.tiny.cloud/customer-stories/) [White Papers and ReportsSee how Tiny improves ROI, grows revenue and saves development costs.](https://www.tiny.cloud/resources/) Read: - [Buy vs Build: The Great Debate White Paper](https://www.tiny.cloud/buy-vs-build-whitepaper/) - [Opportunity Cost of Technical Debt](https://www.tiny.cloud/technical-debt-whitepaper/) - [The State of Rich Text Editors 2025 Report](https://www.tiny.cloud/developer-survey-results/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") [Pricing](https://www.tiny.cloud/pricing/)[Contact Us](https://www.tiny.cloud/contact/) [Log In](https://www.tiny.cloud/auth/login/)[Start Free Trial](https://www.tiny.cloud/auth/signup/ "Start Free Trial") [Products]() [TinyMCE The world's most trusted WYSIWYG HTML editor, for total control over your rich text editing.](https://www.tiny.cloud/tinymce/) - [Overview](https://www.tiny.cloud/tinymce/) - [Features](https://www.tiny.cloud/tinymce/features/) - [Pricing](https://www.tiny.cloud/pricing/) - [Documentation](https://www.tiny.cloud/docs/tinymce/latest/) - [Demos](https://www.tiny.cloud/docs/tinymce/latest/full-featured-premium-demo/) [MoxieManager Media file management simplified in a PHP or .NET environment.](https://www.tiny.cloud/moxiemanager/) [Drive File and image management directly in the cloud.](https://www.tiny.cloud/drive/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") [Developers]() [Developer CenterExplore frameworks, solutions, and technical guides for building with TinyMCE.](https://www.tiny.cloud/developer-center/) - [Frameworks](https://www.tiny.cloud/developer-center/frameworks/) - [Use Cases](https://www.tiny.cloud/developer-center/use-cases/) [DocumentationIn-depth documentation to help you develop with and customize Tiny products.](https://www.tiny.cloud/docs/tinymce/latest/) - [Getting Started](https://www.tiny.cloud/docs/tinymce/latest/getting-started/) - [Basic Setup](https://www.tiny.cloud/docs/tinymce/latest/basic-setup/) - [API Reference](https://www.tiny.cloud/docs/tinymce/latest/apis/tinymce.root/) - [Migrating to TinyMCE](https://www.tiny.cloud/migrate-to-tinymce/) - [Download TinyMCE Free](https://www.tiny.cloud/get-tiny/) [Support](https://www.tiny.cloud/docs/tinymce/latest/support/) - [License Keys](https://www.tiny.cloud/docs/tinymce/latest/license-key/) - [Editor Loads](https://www.tiny.cloud/docs/tinymce/latest/understanding-editor-loads/) - [Submit a Support Request](https://support.tiny.cloud/hc/en-us/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") [Solutions]() [Use CasesOut-of-the-box editor with infinite use cases and complete design flexibility.](https://www.tiny.cloud/solutions/) - [Content Management System](https://www.tiny.cloud/solutions/cms-editor/) - [Email and Messaging Platform](https://www.tiny.cloud/solutions/wysiwyg-email-editor/) - [Document Management System](https://www.tiny.cloud/solutions/dms-editor/) - [Customer Relationship Management](https://www.tiny.cloud/solutions/crm-editor/) - [Learning Management System](https://www.tiny.cloud/solutions/lms-editor/) - [Internal & SaaS Applications](https://www.tiny.cloud/solutions/saas-applications-editor/) - [Workflow & Collaboration](https://www.tiny.cloud/solutions/workflow-management-editor/) [Roles](https://www.tiny.cloud/html-text-editor-for-developers/) - [Developer](https://www.tiny.cloud/html-text-editor-for-developers/) - [Product Manager](https://www.tiny.cloud/html-text-editor-for-product-managers/) - [Senior Manager](https://www.tiny.cloud/html-text-editor-for-scaling-and-monetizing/) [Security](https://www.tiny.cloud/tinymce/security/)[Hosting](https://www.tiny.cloud/solutions/on-premise-or-cloud-based-text-editor/)[Customization](https://www.tiny.cloud/solutions/customize-text-editor/)[Frameworks & Integrations](https://www.tiny.cloud/solutions/editor-framework-integration/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") [Resources]() [BlogRead the world's best blog on WYSIWYG HTML editors, rich text editing, and insights on building SaaS application editors.](https://www.tiny.cloud/blog/) [White Papers and ReportsSee how Tiny improves ROI, grows revenue and saves development costs.](https://www.tiny.cloud/resources/) [Events & WebinarsExplore upcoming and on-demand events and webinars to unlock the full potential of TinyMCE.](https://www.tiny.cloud/events-and-webinars/) [Case StudiesDiscover why industry leaders and scaling start-ups love, use and trust Tiny products.](https://www.tiny.cloud/customer-stories/) Read: - [Buy vs Build: The Great Debate White Paper](https://www.tiny.cloud/buy-vs-build-whitepaper/) - [Opportunity Cost of Technical Debt](https://www.tiny.cloud/technical-debt-whitepaper/) - [The State of Rich Text Editors 2025 Report](https://www.tiny.cloud/developer-survey-results/) [Start trial](https://www.tiny.cloud/auth/signup/ "Start trial") [Pricing](https://www.tiny.cloud/pricing/) [Contact Us](https://www.tiny.cloud/contact/) [Log In](https://www.tiny.cloud/auth/login/)[Start Free Trial](https://www.tiny.cloud/auth/signup/ "Start Free Trial") *** [Content Marketing & Design](https://www.tiny.cloud/blog/category/design-and-ux/)[Developer Insights](https://www.tiny.cloud/blog/category/engineering/)[How-to Use TinyMCE](https://www.tiny.cloud/blog/category/how-tos-and-tutorials/)[Open Source](https://www.tiny.cloud/blog/category/open-source/)[Product-Led Growth](https://www.tiny.cloud/blog/category/product-management/)[The Tiny Way](https://www.tiny.cloud/blog/category/tiny-sparks/)[World of WYSIWYG](https://www.tiny.cloud/blog/category/wysiwyg-world/) # How to save TinyMCE content to a database June 20th, 2023 5 min read ![](data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAAAwFBMVEXZx//ax//cy//Xx//ayP/byP/d0Pvm5evd0fvOxfTPvuPQteTSwvPVxP3QwvzbzP/n3/Dgz/XdyvLgy9DLuOfKuuy3tPKjrvDVw//ZyP/hzPDw0bXrxp332LDnz9/VwvfSyfDWzfPX0vnc1frczP7Yx//x1s792przzY7y1cTby//V1N3k5t77/Prw9/Th1/vZxv/r0dTr0dDo0Njnztrbyv/ZzOXf2+vw6/zr6Prf0f3Zx/7Yxv/Xxv/Zx/3Yxf+hPfr8AAAAV0lEQVQI12NgwAcYkdgsEIrpHxNIlPHPf5gCFgYmRij4xPgfLsgNE2R8yfwHKijKiAB3YCoVQbzrWhDRCxCL/oC1q0LM+AZ3iTWQd4iBwYCf4eMFBlIAAKogD0PCtkl4AAAAAElFTkSuQmCC) ![The PHP element of the database represented by an elephant celebrating with TinyMCE](https://images.ctfassets.net/s600jj41gsex/eihtTelYKrOnMQs1CaGQn/2b80f54539e12e93587c6878776cce28/How_to_save_TinyMCE_content_to_a_database.png?w=2560&q=80&fit=scale) ![The PHP element of the database represented by an elephant celebrating with TinyMCE](https://images.ctfassets.net/s600jj41gsex/eihtTelYKrOnMQs1CaGQn/2b80f54539e12e93587c6878776cce28/How_to_save_TinyMCE_content_to_a_database.png?w=2560&q=80&fit=scale) Written by ![Joe Robinson](data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAQCAIAAACZeshMAAAABGdBTUEAALGPC/xhBQAACilpQ0NQaWNjAABIiZ2Wd1RT2RaHz703vVCSEIqU0GtoUgJIDb1IkS4qMQkQSsCQACI2RFRwRFGRpggyKOCAo0ORsSKKhQFRsesEGUTUcXAUG5ZJZK0Z37x5782b3x/3fmufvc/dZ+991roAkPyDBcJMWAmADKFYFOHnxYiNi2dgBwEM8AADbADgcLOzQhb4RgKZAnzYjGyZE/gXvboOIPn7KtM/jMEA/5+UuVkiMQBQmIzn8vjZXBkXyTg9V5wlt0/JmLY0Tc4wSs4iWYIyVpNz8ixbfPaZZQ858zKEPBnLc87iZfDk3CfjjTkSvoyRYBkX5wj4uTK+JmODdEmGQMZv5LEZfE42ACiS3C7mc1NkbC1jkigygi3jeQDgSMlf8NIvWMzPE8sPxc7MWi4SJKeIGSZcU4aNkxOL4c/PTeeLxcwwDjeNI+Ix2JkZWRzhcgBmz/xZFHltGbIiO9g4OTgwbS1tvijUf138m5L3dpZehH/uGUQf+MP2V36ZDQCwpmW12fqHbWkVAF3rAVC7/YfNYC8AirK+dQ59cR66fF5SxOIsZyur3NxcSwGfaykv6O/6nw5/Q198z1K+3e/lYXjzkziSdDFDXjduZnqmRMTIzuJw+Qzmn4f4Hwf+dR4WEfwkvogvlEVEy6ZMIEyWtVvIE4gFmUKGQPifmvgPw/6k2bmWidr4EdCWWAKlIRpAfh4AKCoRIAl7ZCvQ730LxkcD+c2L0ZmYnfvPgv59V7hM/sgWJH+OY0dEMrgSUc7smvxaAjQgAEVAA+pAG+gDE8AEtsARuAAP4AMCQSiIBHFgMeCCFJABRCAXFIC1oBiUgq1gJ6gGdaARNIM2cBh0gWPgNDgHLoHLYATcAVIwDp6AKfAKzEAQhIXIEBVSh3QgQ8gcsoVYkBvkAwVDEVAclAglQ0JIAhVA66BSqByqhuqhZuhb6Ch0GroADUO3oFFoEvoVegcjMAmmwVqwEWwFs2BPOAiOhBfByfAyOB8ugrfAlXADfBDuhE/Dl+ARWAo/gacRgBAROqKLMBEWwkZCkXgkCREhq5ASpAJpQNqQHqQfuYpIkafIWxQGRUUxUEyUC8ofFYXiopahVqE2o6pRB1CdqD7UVdQoagr1EU1Ga6LN0c7oAHQsOhmdiy5GV6Cb0B3os+gR9Dj6FQaDoWOMMY4Yf0wcJhWzArMZsxvTjjmFGcaMYaaxWKw61hzrig3FcrBibDG2CnsQexJ7BTuOfYMj4nRwtjhfXDxOiCvEVeBacCdwV3ATuBm8Et4Q74wPxfPwy/Fl+EZ8D34IP46fISgTjAmuhEhCKmEtoZLQRjhLuEt4QSQS9YhOxHCigLiGWEk8RDxPHCW+JVFIZiQ2KYEkIW0h7SedIt0ivSCTyUZkD3I8WUzeQm4mnyHfJ79RoCpYKgQo8BRWK9QodCpcUXimiFc0VPRUXKyYr1iheERxSPGpEl7JSImtxFFapVSjdFTphtK0MlXZRjlUOUN5s3KL8gXlRxQsxYjiQ+FRiij7KGcoY1SEqk9lU7nUddRG6lnqOA1DM6YF0FJppbRvaIO0KRWKip1KtEqeSo3KcRUpHaEb0QPo6fQy+mH6dfo7VS1VT1W+6ibVNtUrqq/V5qh5qPHVStTa1UbU3qkz1H3U09S3qXep39NAaZhphGvkauzROKvxdA5tjssc7pySOYfn3NaENc00IzRXaO7THNCc1tLW8tPK0qrSOqP1VJuu7aGdqr1D+4T2pA5Vx01HoLND56TOY4YKw5ORzqhk9DGmdDV1/XUluvW6g7ozesZ6UXqFeu169/QJ+iz9JP0d+r36UwY6BiEGBQatBrcN8YYswxTDXYb9hq+NjI1ijDYYdRk9MlYzDjDON241vmtCNnE3WWbSYHLNFGPKMk0z3W162Qw2szdLMasxGzKHzR3MBea7zYct0BZOFkKLBosbTBLTk5nDbGWOWtItgy0LLbssn1kZWMVbbbPqt/pobW+dbt1ofceGYhNoU2jTY/OrrZkt17bG9tpc8lzfuavnds99bmdux7fbY3fTnmofYr/Bvtf+g4Ojg8ihzWHS0cAx0bHW8QaLxgpjbWadd0I7eTmtdjrm9NbZwVnsfNj5FxemS5pLi8ujecbz+PMa54256rlyXOtdpW4Mt0S3vW5Sd113jnuD+wMPfQ+eR5PHhKepZ6rnQc9nXtZeIq8Or9dsZ/ZK9ilvxNvPu8R70IfiE+VT7XPfV8832bfVd8rP3m+F3yl/tH+Q/zb/GwFaAdyA5oCpQMfAlYF9QaSgBUHVQQ+CzYJFwT0hcEhgyPaQu/MN5wvnd4WC0IDQ7aH3wozDloV9H44JDwuvCX8YYRNRENG/gLpgyYKWBa8ivSLLIu9EmURJonqjFaMTopujX8d4x5THSGOtYlfGXorTiBPEdcdj46Pjm+KnF/os3LlwPME+oTjh+iLjRXmLLizWWJy++PgSxSWcJUcS0YkxiS2J7zmhnAbO9NKApbVLp7hs7i7uE54Hbwdvku/KL+dPJLkmlSc9SnZN3p48meKeUpHyVMAWVAuep/qn1qW+TgtN25/2KT0mvT0Dl5GYcVRIEaYJ+zK1M/Myh7PMs4qzpMucl+1cNiUKEjVlQ9mLsrvFNNnP1IDERLJeMprjllOT8yY3OvdInnKeMG9gudnyTcsn8n3zv16BWsFd0VugW7C2YHSl58r6VdCqpat6V+uvLlo9vsZvzYG1hLVpa38otC4sL3y5LmZdT5FW0ZqisfV+61uLFYpFxTc2uGyo24jaKNg4uGnupqpNH0t4JRdLrUsrSt9v5m6++JXNV5VffdqStGWwzKFsz1bMVuHW69vctx0oVy7PLx/bHrK9cwdjR8mOlzuX7LxQYVdRt4uwS7JLWhlc2V1lULW16n11SvVIjVdNe61m7aba17t5u6/s8djTVqdVV1r3bq9g7816v/rOBqOGin2YfTn7HjZGN/Z/zfq6uUmjqbTpw37hfumBiAN9zY7NzS2aLWWtcKukdfJgwsHL33h/093GbKtvp7eXHgKHJIcef5v47fXDQYd7j7COtH1n+F1tB7WjpBPqXN451ZXSJe2O6x4+Gni0t8elp+N7y+/3H9M9VnNc5XjZCcKJohOfTuafnD6Vderp6eTTY71Leu+ciT1zrS+8b/Bs0Nnz53zPnen37D953vX8sQvOF45eZF3suuRwqXPAfqDjB/sfOgYdBjuHHIe6Lztd7hmeN3ziivuV01e9r567FnDt0sj8keHrUddv3ki4Ib3Ju/noVvqt57dzbs/cWXMXfbfkntK9ivua9xt+NP2xXeogPT7qPTrwYMGDO2PcsSc/Zf/0frzoIflhxYTORPMj20fHJn0nLz9e+Hj8SdaTmafFPyv/XPvM5Nl3v3j8MjAVOzX+XPT806+bX6i/2P/S7mXvdNj0/VcZr2Zel7xRf3PgLett/7uYdxMzue+x7ys/mH7o+Rj08e6njE+ffgP3hPP78QcZjQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAADhElEQVQYGQXBy08jZQAA8Hl9M9N5dcpMh5ZOaYFSWCgokmiyiRuSjXIwrCvx4NVkL96MnvT/8aYHX/HgTfcBLCUuFSwsLCx9dzqdtjPtPPt9/n741199+PrubwrLFwvLj/ceI5Cyx3fP//ohCvmHu5+qymKjblfPf15bwQ8PztKpNIbLrdsujEJZniO/fPJNQr5HUjwAZ/W2Xz5+Kojp0tonEDGapmGIm01l67Wj/149Ky7MZPRYp9/s9dgP1mdVoUddX1fTmnrjNxZzBWci1Go/moNIU94cHV8MLHN7K/dgZ800e24kLqyUTs/KXePu+BJfn1/V1CRJxIyr6q8AtHkh37PwRvOi0Rie/vLi/mbh/aUs4QSN9jnJkiJHqpqYTrM40rudvsRSnueS+/tfNJpvWyYB6GKlWvEwQSaT33/73Uc7D0vLxa2NTYXPvqy+DhE9GQ/Wlx9EIQo8IUK8trBL6XPzB4iGgJmGNi8IkHD27n+WL6wGZhMPxyHCUlpyNbP529lP103k+YomwRgQOv2uvvQO6bhPg2ggywqBHJzhNHEisfmry39Ojv4I7FH51UGjZ0wJqmX3Rr6IUToOfQxSICY/2n9CrKzuFYsf41iPAR6Al4lAziqJGZpk6DgSsiTBCMQkG2f0KfA9q1L587ByddPz7r27pSgqlVS1GSl3y9koHCOkLs2ATFILKFzh5czsfCIyWYEGvJjAKY5prq3mn500a0YL0Z2l5Vlye41jCZynGTKCbQd1BtON/EaCgNGw36rdcOFAicdDDCt3m9ulHQonJE5DBAhs8/nR75QmKPWm4U3aVoSGAbQm0cvTw4LAjGzoDvs+4YV07Y2H6lNyU6QLWV1ie8mEwPOwfH5Jarp4bbQaXdNGtG/3hq7LQigBMkaynIc4OrIj58QcGAFmDyuuZ/WNIEayth3QuEi1Jo4POdu3pTgLGL4Uw6y25+viFOCjyBJA2B6HF+0Gz8ZyBcy0rbHDeyPk49hoilM4KcHAljlKIeKqm5warpWAs8m56sW/xl09lRQz6XnptE/IwfUNDMCAIibTIEA4CBCgOCGVMSRylMYsInIiczB5cdfaLi0oIu/KvCyKXcupn41ykurOQXKetNEkIcVAkMrSU/zz93aZLnQi13KHyI8m/qiMhhgG1vUZDkCIsPKto2LBMiYjQdQXU6O3ndRWTEgpnj38H0Bj0vI5fgnbAAAAOHRFWHRpY2M6Y29weXJpZ2h0AENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueflXeTcAAAAhdEVYdGljYzpkZXNjcmlwdGlvbgBzUkdCIElFQzYxOTY2LTIuMVet2kcAAAAmdEVYdGljYzptYW51ZmFjdHVyZXIASUVDIGh0dHA6Ly93d3cuaWVjLmNoHH8ATAAAADd0RVh0aWNjOm1vZGVsAElFQyA2MTk2Ni0yLjEgRGVmYXVsdCBSR0IgY29sb3VyIHNwYWNlIC0gc1JHQkRTSKkAAAAASUVORK5CYII=) ![Joe Robinson](https://images.ctfassets.net/s600jj41gsex/2P4AEkP8R7iCxO4eT5voCe/d18aa214c40aa5e1ecff6f6d216c8097/Portrait-TinyTribe-JR100px.png?w=48&q=50&fit=scale) [Joe Robinson](https://www.tiny.cloud/blog/author/joseph-robinson/) Category [How-to Use TinyMCE](https://www.tiny.cloud/blog/category/how-tos-and-tutorials/) Tagged [Configuration](https://www.tiny.cloud/blog/tag/configuration/)[TinyMCE](https://www.tiny.cloud/blog/tag/tinymce/) Databases are all around us, and without them websites and applications wouldn’t work. Since they’re so vital to online applications, why would components included in those applications – components that claim to speed up development – cause more problems and frustration by blocking database connections? For instance, the rich text editor component of an application lives at the center of content creation apps. A valuable rich text editor provides a fast and easy flow of content from the editor to the database without any roadblocks. Speed and efficiency are a part of best practice for database content management. [TinyMCE is an trusted rich text editor](https://www.tiny.cloud/) that allows you to save content to a database without obstacles. It’s just one example of the many ways TinyMCE is easy to implement, and this post shows you how to save TinyMCE content to a database. ## What is database content management? Database content management is the ability to store and serve content from the database, to anywhere it’s needed in an application. When database content management is done effectively, it shows at the very least, the following practices: 1. Allows for storage of a variety of digital content, including images, text, video, and audio files 2. Fast and effective storage and retrieval 3. Follows a standardized naming convention 4. Connects metadata to each item in the database, providing information to identify content 5. Plans for storage that fits the content, such as local storage, or cloud based storage. Plus, there’s [more to consider before testing out a database](https://www.tableau.com/learn/articles/data-management-best-practices) for content management. Once you’re ready, the following sections explain the steps to save TinyMCE content to a database using an SQLite demo. ## How to save TinyMCE content to a database with PHP The first step is getting TinyMCE working. The following demo is based on [the TinyMCE CMS solution](https://www.tiny.cloud/solutions/cms-editor/). There are some prerequisites to know about before running the demo: 1. Experience with HTML and JavaScript 2. Familiarity with PHP, including prepared statements 3. A text editor to adjust file content 4. Access to the command line through bash or another shell ### Getting TinyMCE started 1. In your development environment, create a new directory for the demo, create an index.html file in that directory. Also set up two more folders in the new directory, one for scripts, and one for PHP: ``` mkdir demoApp/ cd demoApp/ touch index.html mkdir scripts/ mkdir php/ ``` COPY 1. Change into the scripts folder and create a new JavaScript file for the TinyMCE configuration, which is set up in step 5 of this procedure: ``` cd scripts/ touch tinymceConfig.js ``` COPY 1. Change out of the scripts folder and then in the main directory, open the index.html file. Add the following starter HTML: ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="https://code.jquery.com/jquery-3.7.0.js"></script> <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script> <script src="scripts/tinymceConfig.js"></script> </head> <body> <h1>TinyMCE CMS Starter Config</h1> <textarea> <h1>Visiting Norway</h1> <p><strong><img style="float: right;" src="https://images.pexels.com/photos/1559825/pexels-photo-1559825.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260" alt="Town" width="300" height="375"></strong>Norway, officially the Kingdom of Norway, is a <a href="https://en.wikipedia.org/wiki/Nordic_countries">Nordic country</a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.</p> <p>The remote Arctic island of Jan Mayen and the archipelago of Svalbard also form part of Norway. Bouvet Island, located in the <a href="https://en.wikipedia.org/wiki/Subantarctic">Subantarctic</a>, is a dependency of Norway; it also lays claims to the Antarctic territories of Peter I Island and Queen Maud Land. The capital and largest city in Norway is <a href="https://en.wikipedia.org/wiki/Oslo">Oslo</a>.<strong><br></strong></p> <p>Listen to Norway's royal anthem on Spotify:</p> <div style="left: 0px; width: 100%; height: 152px; position: relative; max-width: 650px;" data-ephox-embed-iri="https://open.spotify.com/track/6SPocux2pBpFp3lshAOek1?si=907d52cf2af94efc"><iframe style="top: 0; left: 0; width: 100%; height: 100%; position: absolute; border: 0;" src="https://open.spotify.com/embed/track/6SPocux2pBpFp3lshAOek1?utm_source=oembed" allow="clipboard-write; encrypted-media; fullscreen; picture-in-picture;" allowfullscreen="allowfullscreen"></iframe></div> <h2>Geography</h2> <p>Norway has a total area of 385,207 square kilometres (148,729 sq mi) and had a population of 5,425,270 in January 2022. The country shares a long eastern border with Sweden at a length of 1,619 km (1,006 mi). It is bordered by Finland and Russia to the northeast and the Skagerrak strait to the south, on the other side of which are Denmark and the United Kingdom.</p> <p>Norway has an extensive coastline, facing the North Atlantic Ocean and the Barents Sea. The maritime influence dominates Norway's climate, with mild lowland temperatures on the sea coasts; the interior, while colder, is also significantly milder than areas elsewhere in the world on such northerly latitudes. Even during polar night in the north, temperatures above freezing are commonplace on the coastline. The maritime influence brings high rainfall and snowfall to some areas of the country.</p> <p><em>Featuring <a href="https://en.wikipedia.org/wiki/Norway">content from Wikipedia</a></em></p> </textarea> </body> </html> ``` COPY 1. Add a link to TinyMCE through the CDN in the head section of the document, and a link to the TinyMCE configuration file: ``` <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script> <script src="scripts/tinymceConfig.js"></script> ``` COPY > Note: The CMS demo makes use of several Premium plugins. When you [sign up for a FREE TinyMCE API key](https://www.tiny.cloud/auth/signup/), you get free access to all Premium plugins for 14 days from when you replace the “no-api-key” string with your own TinyMCE API key. Adding the key also removes any domain name related errors appearing in the text area. 1. Change back into the scripts/tinymceConfig.js file, open it, and add the following JavaScript content to get TinyMCE started: ``` tinymce.init({ selector: "#editor", plugins: "a11ychecker advcode advlist advtable anchor autocorrect autosave editimage image link linkchecker lists media mediaembed pageembed powerpaste searchreplace table template tinymcespellchecker typography visualblocks wordcount", toolbar: "undo redo \| styles \| bold italic underline strikethrough \| align \| table link image media pageembed \| bullist numlist outdent indent \| spellcheckdialog a11ycheck typography code", height: 540, a11ychecker_level: "aaa", typography_langs: ["en-US"], typography_default_lang: "en-US", advcode_inline: true, content_style: ` body { font-family: 'Roboto', sans-serif; color: #222; } img { height: auto; margin: auto; padding: 10px; display: block; } img.medium { max-width: 25%; } a { color: #116B59; } .related-content { padding: 0 10px; margin: 0 0 15px 15px; background: #eee; width: 200px; float: right; } `, }); ``` COPY 1. Save the changes, and then change back into the main directory. Test out the demo by opening the index.html file in a browser, or by running a localhost test [with the Python command,](https://ryanblunden.com/create-a-http-server-with-one-command-thanks-to-python-29fcfdcd240e) or [PHP command](https://www.php.net/manual/en/features.commandline.webserver.php): ![The TinyMCE CMS demo working in the browser and ready to be saved to the database](https://images.ctfassets.net/s600jj41gsex/6LO93YvgD4nqcJyVIQfpza/5b0362977008cbb4f567cb7a9e53010f/img-TinyMCE-save-database-0.gif) ### Getting the database connection established 1. Change into the scripts folder, and add the following JavaScript to the TinyMCE init script after the content\_style option. It uses the TinyMCE setup option to listen for the change event. The change event registers when the editor loses focus, or the writer presses the Enter key. When the event happens, the jQuery gets the rich text editor content, and posts it onward to the database handler file. This content is what saves TinyMCE content to the database: ``` setup: (editor) => { editor.on('change', (e) => { $.ajax({ type: 'POST', url: 'php/save.php', data: { editor: tinymce.get('editor').getContent() }, success: function(data){ $('#editor').val(''); console.log(data) } }) }) }, ``` COPY 1. Change back to the main directory, and then change into the php folder. Create a new PHP file for handling interactions with the database: ``` touch connect.php ``` COPY 1. Add the following PHP content to the connection file. This receives the editor content, and then saves the TinyMCE content to a database file: ``` <?php $connect=new SQLite3('tinymceContent.db') or die("Could not connect to database, and save TinyMCE content"); $db="CREATE TABLE IF NOT EXISTS `Content`(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Content TEXT)"; $connect->exec($db); ?> ``` COPY 1. Save the changes, and then close the .php file. 2. Create a second .php file to handle the process of inserting and saving TinyMCE content into the database, and then add the following PHP content: ``` touch save.php ... <?php require_once 'connect.php'; $editorContent=$_POST['editor']; $stmt = $connect->prepare("INSERT INTO `Content` (Content) VALUES (:Content)"); $stmt->bindParam(':Content', $editorContent); $stmt->execute(); echo "Save Data"; ?> ``` COPY 1. Save the changes. ### Saving TinyMCE content to the database file with PHP and SQLite 1. In the browser, refresh the demo, and try entering some new content into the TinyMCE text area, and then clicking away from the editor or pressing the Enter key. If the PHP content is working, you’ll see a 200 status code on the command line (if you’re running the demo with a localhost for tests with Python or PHP): ``` [<date and time>] [::1]:60003 [200]: GET / [<date and time>] [::1]:60003 Closing [<date and time>] [::1]:60003 [200]: GET /tinymceConfig.js [<date and time>] [::1]:60003 Closing [<date and time>] [::1]:60003 Accepted [<date and time>] [::1]:60003 [200]: POST /php/save.php [<date and time>] [::1]:60003 Closing ``` COPY The successful command line content (code 200) indicates that the database file has been created in the php folder following the steps set in the connect.php file. 1. Navigate into the php folder, and then open the tinymceContent.db database file with the SQLite command: ``` sqlite3 tinymceContent.db ``` COPY 1. Query the database Content table to see the TinyMCE content saved in the database: ``` SELECT * FROM Content; … 1\|<h1>Visiting Norway</h1> <p><strong><img style="float: right;" src="https://images.pexels.com/photos/1559825/pexels-photo-1559825.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260" alt="Town" width="300" height="375"></strong>Norway, officially the Kingdom of Norway, is a <a href="https://en.wikipedia.org/wiki/Nordic_countries">Nordic country</a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.</p> ... ``` COPY 1. Exit the database using the .quit command ## Next steps for saving TinyMCE content in a database You can rapidly get content from the editor, and save TinyMCE content to a database making use of the process explained in the previous sections. In production, the pattern of collecting data with the [TinyMCE Get method,](https://www.tiny.cloud/blog/how-to-get-content-and-set-content-in-tinymce/) and [binding parameters in prepared statements](https://www.w3schools.com/php/php_mysql_prepared_statements.asp) represent consistent patterns you can make use of for your project. For more on getting a CMS ready using TinyMCE, check out [the tutorial on creating a CMS with TinyMCE](https://www.tiny.cloud/blog/tinymce-for-cms/) to rival the major content management providers out there\! [Try TinyMCE with your database, and sign up for your FREE API key today](https://www.tiny.cloud/get-tiny/) [Configuration](https://www.tiny.cloud/blog/tag/configuration/)[TinyMCE](https://www.tiny.cloud/blog/tag/tinymce/) ![Joe Robinson](data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAQCAIAAACZeshMAAAABGdBTUEAALGPC/xhBQAACilpQ0NQaWNjAABIiZ2Wd1RT2RaHz703vVCSEIqU0GtoUgJIDb1IkS4qMQkQSsCQACI2RFRwRFGRpggyKOCAo0ORsSKKhQFRsesEGUTUcXAUG5ZJZK0Z37x5782b3x/3fmufvc/dZ+991roAkPyDBcJMWAmADKFYFOHnxYiNi2dgBwEM8AADbADgcLOzQhb4RgKZAnzYjGyZE/gXvboOIPn7KtM/jMEA/5+UuVkiMQBQmIzn8vjZXBkXyTg9V5wlt0/JmLY0Tc4wSs4iWYIyVpNz8ixbfPaZZQ858zKEPBnLc87iZfDk3CfjjTkSvoyRYBkX5wj4uTK+JmODdEmGQMZv5LEZfE42ACiS3C7mc1NkbC1jkigygi3jeQDgSMlf8NIvWMzPE8sPxc7MWi4SJKeIGSZcU4aNkxOL4c/PTeeLxcwwDjeNI+Ix2JkZWRzhcgBmz/xZFHltGbIiO9g4OTgwbS1tvijUf138m5L3dpZehH/uGUQf+MP2V36ZDQCwpmW12fqHbWkVAF3rAVC7/YfNYC8AirK+dQ59cR66fF5SxOIsZyur3NxcSwGfaykv6O/6nw5/Q198z1K+3e/lYXjzkziSdDFDXjduZnqmRMTIzuJw+Qzmn4f4Hwf+dR4WEfwkvogvlEVEy6ZMIEyWtVvIE4gFmUKGQPifmvgPw/6k2bmWidr4EdCWWAKlIRpAfh4AKCoRIAl7ZCvQ730LxkcD+c2L0ZmYnfvPgv59V7hM/sgWJH+OY0dEMrgSUc7smvxaAjQgAEVAA+pAG+gDE8AEtsARuAAP4AMCQSiIBHFgMeCCFJABRCAXFIC1oBiUgq1gJ6gGdaARNIM2cBh0gWPgNDgHLoHLYATcAVIwDp6AKfAKzEAQhIXIEBVSh3QgQ8gcsoVYkBvkAwVDEVAclAglQ0JIAhVA66BSqByqhuqhZuhb6Ch0GroADUO3oFFoEvoVegcjMAmmwVqwEWwFs2BPOAiOhBfByfAyOB8ugrfAlXADfBDuhE/Dl+ARWAo/gacRgBAROqKLMBEWwkZCkXgkCREhq5ASpAJpQNqQHqQfuYpIkafIWxQGRUUxUEyUC8ofFYXiopahVqE2o6pRB1CdqD7UVdQoagr1EU1Ga6LN0c7oAHQsOhmdiy5GV6Cb0B3os+gR9Dj6FQaDoWOMMY4Yf0wcJhWzArMZsxvTjjmFGcaMYaaxWKw61hzrig3FcrBibDG2CnsQexJ7BTuOfYMj4nRwtjhfXDxOiCvEVeBacCdwV3ATuBm8Et4Q74wPxfPwy/Fl+EZ8D34IP46fISgTjAmuhEhCKmEtoZLQRjhLuEt4QSQS9YhOxHCigLiGWEk8RDxPHCW+JVFIZiQ2KYEkIW0h7SedIt0ivSCTyUZkD3I8WUzeQm4mnyHfJ79RoCpYKgQo8BRWK9QodCpcUXimiFc0VPRUXKyYr1iheERxSPGpEl7JSImtxFFapVSjdFTphtK0MlXZRjlUOUN5s3KL8gXlRxQsxYjiQ+FRiij7KGcoY1SEqk9lU7nUddRG6lnqOA1DM6YF0FJppbRvaIO0KRWKip1KtEqeSo3KcRUpHaEb0QPo6fQy+mH6dfo7VS1VT1W+6ibVNtUrqq/V5qh5qPHVStTa1UbU3qkz1H3U09S3qXep39NAaZhphGvkauzROKvxdA5tjssc7pySOYfn3NaENc00IzRXaO7THNCc1tLW8tPK0qrSOqP1VJuu7aGdqr1D+4T2pA5Vx01HoLND56TOY4YKw5ORzqhk9DGmdDV1/XUluvW6g7ozesZ6UXqFeu169/QJ+iz9JP0d+r36UwY6BiEGBQatBrcN8YYswxTDXYb9hq+NjI1ijDYYdRk9MlYzDjDON241vmtCNnE3WWbSYHLNFGPKMk0z3W162Qw2szdLMasxGzKHzR3MBea7zYct0BZOFkKLBosbTBLTk5nDbGWOWtItgy0LLbssn1kZWMVbbbPqt/pobW+dbt1ofceGYhNoU2jTY/OrrZkt17bG9tpc8lzfuavnds99bmdux7fbY3fTnmofYr/Bvtf+g4Ojg8ihzWHS0cAx0bHW8QaLxgpjbWadd0I7eTmtdjrm9NbZwVnsfNj5FxemS5pLi8ujecbz+PMa54256rlyXOtdpW4Mt0S3vW5Sd113jnuD+wMPfQ+eR5PHhKepZ6rnQc9nXtZeIq8Or9dsZ/ZK9ilvxNvPu8R70IfiE+VT7XPfV8832bfVd8rP3m+F3yl/tH+Q/zb/GwFaAdyA5oCpQMfAlYF9QaSgBUHVQQ+CzYJFwT0hcEhgyPaQu/MN5wvnd4WC0IDQ7aH3wozDloV9H44JDwuvCX8YYRNRENG/gLpgyYKWBa8ivSLLIu9EmURJonqjFaMTopujX8d4x5THSGOtYlfGXorTiBPEdcdj46Pjm+KnF/os3LlwPME+oTjh+iLjRXmLLizWWJy++PgSxSWcJUcS0YkxiS2J7zmhnAbO9NKApbVLp7hs7i7uE54Hbwdvku/KL+dPJLkmlSc9SnZN3p48meKeUpHyVMAWVAuep/qn1qW+TgtN25/2KT0mvT0Dl5GYcVRIEaYJ+zK1M/Myh7PMs4qzpMucl+1cNiUKEjVlQ9mLsrvFNNnP1IDERLJeMprjllOT8yY3OvdInnKeMG9gudnyTcsn8n3zv16BWsFd0VugW7C2YHSl58r6VdCqpat6V+uvLlo9vsZvzYG1hLVpa38otC4sL3y5LmZdT5FW0ZqisfV+61uLFYpFxTc2uGyo24jaKNg4uGnupqpNH0t4JRdLrUsrSt9v5m6++JXNV5VffdqStGWwzKFsz1bMVuHW69vctx0oVy7PLx/bHrK9cwdjR8mOlzuX7LxQYVdRt4uwS7JLWhlc2V1lULW16n11SvVIjVdNe61m7aba17t5u6/s8djTVqdVV1r3bq9g7816v/rOBqOGin2YfTn7HjZGN/Z/zfq6uUmjqbTpw37hfumBiAN9zY7NzS2aLWWtcKukdfJgwsHL33h/093GbKtvp7eXHgKHJIcef5v47fXDQYd7j7COtH1n+F1tB7WjpBPqXN451ZXSJe2O6x4+Gni0t8elp+N7y+/3H9M9VnNc5XjZCcKJohOfTuafnD6Vderp6eTTY71Leu+ciT1zrS+8b/Bs0Nnz53zPnen37D953vX8sQvOF45eZF3suuRwqXPAfqDjB/sfOgYdBjuHHIe6Lztd7hmeN3ziivuV01e9r567FnDt0sj8keHrUddv3ki4Ib3Ju/noVvqt57dzbs/cWXMXfbfkntK9ivua9xt+NP2xXeogPT7qPTrwYMGDO2PcsSc/Zf/0frzoIflhxYTORPMj20fHJn0nLz9e+Hj8SdaTmafFPyv/XPvM5Nl3v3j8MjAVOzX+XPT806+bX6i/2P/S7mXvdNj0/VcZr2Zel7xRf3PgLett/7uYdxMzue+x7ys/mH7o+Rj08e6njE+ffgP3hPP78QcZjQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAADhElEQVQYGQXBy08jZQAA8Hl9M9N5dcpMh5ZOaYFSWCgokmiyiRuSjXIwrCvx4NVkL96MnvT/8aYHX/HgTfcBLCUuFSwsLCx9dzqdtjPtPPt9/n741199+PrubwrLFwvLj/ceI5Cyx3fP//ohCvmHu5+qymKjblfPf15bwQ8PztKpNIbLrdsujEJZniO/fPJNQr5HUjwAZ/W2Xz5+Kojp0tonEDGapmGIm01l67Wj/149Ky7MZPRYp9/s9dgP1mdVoUddX1fTmnrjNxZzBWci1Go/moNIU94cHV8MLHN7K/dgZ800e24kLqyUTs/KXePu+BJfn1/V1CRJxIyr6q8AtHkh37PwRvOi0Rie/vLi/mbh/aUs4QSN9jnJkiJHqpqYTrM40rudvsRSnueS+/tfNJpvWyYB6GKlWvEwQSaT33/73Uc7D0vLxa2NTYXPvqy+DhE9GQ/Wlx9EIQo8IUK8trBL6XPzB4iGgJmGNi8IkHD27n+WL6wGZhMPxyHCUlpyNbP529lP103k+YomwRgQOv2uvvQO6bhPg2ggywqBHJzhNHEisfmry39Ojv4I7FH51UGjZ0wJqmX3Rr6IUToOfQxSICY/2n9CrKzuFYsf41iPAR6Al4lAziqJGZpk6DgSsiTBCMQkG2f0KfA9q1L587ByddPz7r27pSgqlVS1GSl3y9koHCOkLs2ATFILKFzh5czsfCIyWYEGvJjAKY5prq3mn500a0YL0Z2l5Vlye41jCZynGTKCbQd1BtON/EaCgNGw36rdcOFAicdDDCt3m9ulHQonJE5DBAhs8/nR75QmKPWm4U3aVoSGAbQm0cvTw4LAjGzoDvs+4YV07Y2H6lNyU6QLWV1ie8mEwPOwfH5Jarp4bbQaXdNGtG/3hq7LQigBMkaynIc4OrIj58QcGAFmDyuuZ/WNIEayth3QuEi1Jo4POdu3pTgLGL4Uw6y25+viFOCjyBJA2B6HF+0Gz8ZyBcy0rbHDeyPk49hoilM4KcHAljlKIeKqm5warpWAs8m56sW/xl09lRQz6XnptE/IwfUNDMCAIibTIEA4CBCgOCGVMSRylMYsInIiczB5cdfaLi0oIu/KvCyKXcupn41ykurOQXKetNEkIcVAkMrSU/zz93aZLnQi13KHyI8m/qiMhhgG1vUZDkCIsPKto2LBMiYjQdQXU6O3ndRWTEgpnj38H0Bj0vI5fgnbAAAAOHRFWHRpY2M6Y29weXJpZ2h0AENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueflXeTcAAAAhdEVYdGljYzpkZXNjcmlwdGlvbgBzUkdCIElFQzYxOTY2LTIuMVet2kcAAAAmdEVYdGljYzptYW51ZmFjdHVyZXIASUVDIGh0dHA6Ly93d3cuaWVjLmNoHH8ATAAAADd0RVh0aWNjOm1vZGVsAElFQyA2MTk2Ni0yLjEgRGVmYXVsdCBSR0IgY29sb3VyIHNwYWNlIC0gc1JHQkRTSKkAAAAASUVORK5CYII=) ![Joe Robinson](https://images.ctfassets.net/s600jj41gsex/2P4AEkP8R7iCxO4eT5voCe/d18aa214c40aa5e1ecff6f6d216c8097/Portrait-TinyTribe-JR100px.png?w=48&q=50&fit=scale) by[Joe Robinson](https://www.tiny.cloud/blog/author/joseph-robinson/) Technical and creative writer, editor, and a TinyMCE advocate. An enthusiast for teamwork, open source software projects, and baking. Can often be found puzzling over obscure history, cryptic words, and lucid writing. ## Related Articles - ![How to Create a Laravel Project with TinyMCE](data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAABqlBMVEUJElMKE1QAB08ABk4ABU4ABE4ACE8IElMCDFEAAk4AAU0AB04EDlEJE1QAAU4cIl0tMmkkKmUtMmgrMWgqL2gzOGsyN2s1Om0zOGwhJl8AA04AAEw5O2JlZn0rL1whKGQ8Q3o6QXk+RXo9RHpCSX1BSH08Q3gxOHEdJWMAAE4ABk8tMVxWWHMcIVYjKWVbZZdseKdrdqZrd6Zsd6ZqdaVjbZ5YYpVFTYMsMmtCRW4EDlIAAU8ABU8BDlMAA08jKmRdZ5hveqlueahpdKRhbJ1aZJdBS4Nxcoq6usFJS2wAAFAOFVQEDVEmLGVaZJRpdKJoc6BpdKFkb5xgaplZYpNETIJHS3RzdIohJVgCDVIDDFABCU8iKGQ7Ro0+SpI/SpA/SpFAS5BAS5FDTpM1Pn8jKmkEFF4AAE0JElIAAUoOHGdTZdNwf+RvfuJygONtfOJse+J1guNxgOQuQKQaIFgUG1kLE1IABU0SIXEcKHYVI3QeKXUXJXUfKnYcKXgEFGABCEsFDlAIEFEMFFILFFQAA0sAAEIAADwAADsAAD0AAD8AAUgBCE4CC0/x2NGcAAAAgUlEQVQIHV3BsQ2CUBRA0XvhCcYCYu0EDuJSJjS6hzs4iBs4gIWFpQnIFz9UniOKAjJJqaRP1n4YRSCwH9d9ZdRvy8oJzh7gzkWiMLsTtP6BSFszUuFsiHg8D2a4CCJozXABBcO1ydrZpRmGqKvUvLbqWPrTuVHPp9VRJVE4ubnvvvvOH3NuUin/AAAAAElFTkSuQmCC) ![How to Create a Laravel Project with TinyMCE](https://images.ctfassets.net/s600jj41gsex/5d3MI3yLPU2yRuI7mWlOw3/3c0ecc44fff59f8f90e95ec82267edde/How_to_Create_a_Laravel_Project_with_TinyMCE.png?w=739&q=50&fit=scale) [How-to Use TinyMCE](https://www.tiny.cloud/blog/category/how-tos-and-tutorials/) Feb 26th, 2026 ### [How to Integrate TinyMCE into a Laravel Project](https://www.tiny.cloud/blog/how-to-add-tinymce-to-laravel/) - ![How to Build a Team Collaboration App with TinyMCE + React](data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAABtlBMVEUIE1QAB08ACE8ABk8IElQIElMGElQACVEAAE8AAU8AA08ABE8ACVAADlMADlQAClEADFQAEVUHE1UeF04kGk4jGE4ODU8oGE4RDU8OC08AD1QpJFg3KFYAEVYAAVAAE1ZCMFUvJlcADFMAAFBnSkmQZEKLXENxRkh9SUiLTUhwOktGLlZNL1MAAFgACVlVM1M8KFdTOkiAVj6FVT1/TEB2QUOFRUJ2OUZ0Nk2BOk9LIFAABlEAAlhZXHebnKddYXsAA1kAEFUACFAAAEtMQ1x7aGyCbG56X2VzWGSBZnB5XmxaKU11NE9CHE+VlqLZ2dyUlaIAAFEAA1AAAEdaXXZ/gZKIi5qHipp4fI6FiZh0eIsADFEAAE4AAk8ACFMABlUAAFZGSmx8fo89Q2oAFloIF1dQUW2JiZeRkZ6YmaSHiJYLE1EAAEgAAE0ABE4ABFEXI1yEhZRqa4IAAFQADVlZN1E+K1YAAEwDC08wMlw+QGMxM1wvMVsABU8ZJV2IiZhub4QAAFMAElUtIlgeHlgADFIHEVMAB1AAAk4ACVQAE1gADlYABVEBEVQJE1QKE1QAB04JElMYf15lAAAAm0lEQVQIHQXBMS5EUQAF0HteXsbjxxDVZEQh0chX2oHEDuxCNEIyyZRahcJC9JagoVBPJGpiZFB950gkkSQZIkPBCOJ3SDaw3ITWAV8rE4C6C/hYK997rDoW2iEArz3gBIDH6fspPNRtAM4AtWYHANyfs14PwCL7NxdjZMxV3fL5lOOjGZOCv9vrdlla++n70UwyH16e37Lsyt0/AyIgqverEawAAAAASUVORK5CYII=) ![How to Build a Team Collaboration App with TinyMCE + React](https://images.ctfassets.net/s600jj41gsex/5aMx0eNy8VUErE5AO5ZkiQ/c9d7e2d4aea4b8402e3bf3b2893ce162/How_to_Build_a_Team_Collaboration_App_with_TinyMCE___React.png?w=739&q=50&fit=scale) [How-to Use TinyMCE](https://www.tiny.cloud/blog/category/how-tos-and-tutorials/) Feb 18th, 2026 ### [How to Build a Team Collaboration App with TinyMCE and React](https://www.tiny.cloud/blog/how-to-build-React-team-collaboration-app/) - ![How to Build a Help Desk App in React with TinyMCE](data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAMAAABI111xAAABsFBMVEUKE1QACE8AB08ABk4KElMJElMEDVEABU4ABk8ABU8ACVADDVMAClEACVEDCVIHD1QJElQAAU4AAEwAAEoAAEsAAEkAAE4EDFMTKFwQLl4ED1UAAVAFElURN2MSLF4BCFI2N15NTWpBQWNERGVRUW1SUm0yO2AANF4AO2EAIVUEBVITN2MLQWgAAFcAAE8AB1gKQ2kRM2ECCFIAAEdYW3SIiph8fY17fI2JiZeNjZpXboMAXHgAbYQARmgBAE4EEVUABVhZXHebnKdeYXsDD1QAB1AAAEgAQWYAYn0AXnoAX3oAUnEAZn8AXHcAFVKVlqLZ2dyUlaIAAFAAAlBPU26Fiph0eIp6f4+Ah5aNkJ1+gpEgM1wAGlMECFEOEVUJClUAClhIS2x8fo8+Q2kAE1oIFlY6O2BeXnZKSmhPTmtkY3leXXVUVG8ODE8AAE0KD1UONWQEY4cJNGQAAlcAEVkLOmMSL18DDFMKDVUIUHcAjK8IT3cIClUAA1AGElURJlsRIVoBClIABE4JElUTI1oPPWoJEVQBCVABC1IGEFQLFFQFCVIFAVIFCFIAB04LE1QrHffIAAAAnElEQVQIHWXBMQ7BYBiA4e9tv0p+pSKV2AiLSzgAk8TqEI5gEqPF5h5NLNLR4gx2i6TageRvNWmaCM+DCFJDpKCk0gBBircUBiHzKXWBwsnJRamp2+KPDvlx76MhPAOwChcvHEGHSKVNQGVGRekt+XYbU+ri5s4gvK6Oa2rOI03SZDHNDi/f901za4zZu7I7WRvHVnAn6m3sea7RB77EJUgK3FzNAAAAAElFTkSuQmCC) ![How to Build a Help Desk App in React with TinyMCE](https://images.ctfassets.net/s600jj41gsex/4EDRrkGzEoAesCGWovUmwu/d2955fa54b279c00374849c8e3735f51/How_to_Build_a_Help_Desk_App_in_React_with_TinyMCE.png?w=739&q=50&fit=scale) [How-to Use TinyMCE](https://www.tiny.cloud/blog/category/how-tos-and-tutorials/) Feb 11th, 2026 ### [How to Build a Help Desk App in React with TinyMCE](https://www.tiny.cloud/blog/build-help-desk-app-with-react/) Join 100,000+ developers who get regular tips & updates from the Tiny team. This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply. Stay connected [![SOC2 compliance badge](https://www.tiny.cloud/images/footer/SOC2-compliance.png)](https://www.tiny.cloud/tinymce/security) ### Products - [TinyMCE](https://www.tiny.cloud/tinymce) - [Drive](https://www.tiny.cloud/drive) - [MoxieManager](https://www.tiny.cloud/moxiemanager) ### Pricing - [TinyMCE](https://www.tiny.cloud/pricing) - [Drive](https://www.tiny.cloud/pricing/drive) - [MoxieManager](https://www.tiny.cloud/pricing/moxiemanager) ### Developers - [Documentation](https://www.tiny.cloud/docs/tinymce/latest) - [Get Started](https://www.tiny.cloud/docs/tinymce/latest/cloud-quick-start) - [Integrations](https://www.tiny.cloud/developer-center/editor-framework-integration) - [API Reference](https://www.tiny.cloud/docs/tinymce/latest/apis/tinymce.root) - [Roadmap](https://www.tiny.cloud/roadmap) - [Support](https://www.tiny.cloud/docs/tinymce/latest/support) - [Blog](https://www.tiny.cloud/blog) - [Get TinyMCE Free](https://www.tiny.cloud/get-tiny) ### Company - [About](https://www.tiny.cloud/about) - [Customer Stories](https://www.tiny.cloud/customer-stories) - [Careers](https://tiugotech.recruitee.com/) - [Partners](https://www.tiny.cloud/partner-directory) - [News](https://www.tiny.cloud/news) - [Contact Us](https://www.tiny.cloud/contact) - [Legal](https://www.tiny.cloud/legal) - [Security](https://www.tiny.cloud/tinymce/security) - [Trust Center](https://www.tiny.cloud/trust-center) - [Status Page](https://status.tiny.cloud/) © Copyright 2026 Tiny Technologies Inc. TinyMCE® and Tiny® are registered trademarks of Tiny Technologies, Inc.
Readable Markdown	Databases are all around us, and without them websites and applications wouldn’t work. Since they’re so vital to online applications, why would components included in those applications – components that claim to speed up development – cause more problems and frustration by blocking database connections? For instance, the rich text editor component of an application lives at the center of content creation apps. A valuable rich text editor provides a fast and easy flow of content from the editor to the database without any roadblocks. Speed and efficiency are a part of best practice for database content management. [TinyMCE is an trusted rich text editor](https://www.tiny.cloud/) that allows you to save content to a database without obstacles. It’s just one example of the many ways TinyMCE is easy to implement, and this post shows you how to save TinyMCE content to a database. ## What is database content management? Database content management is the ability to store and serve content from the database, to anywhere it’s needed in an application. When database content management is done effectively, it shows at the very least, the following practices: 1. Allows for storage of a variety of digital content, including images, text, video, and audio files 2. Fast and effective storage and retrieval 3. Follows a standardized naming convention 4. Connects metadata to each item in the database, providing information to identify content 5. Plans for storage that fits the content, such as local storage, or cloud based storage. Plus, there’s [more to consider before testing out a database](https://www.tableau.com/learn/articles/data-management-best-practices) for content management. Once you’re ready, the following sections explain the steps to save TinyMCE content to a database using an SQLite demo. ## How to save TinyMCE content to a database with PHP The first step is getting TinyMCE working. The following demo is based on [the TinyMCE CMS solution](https://www.tiny.cloud/solutions/cms-editor/). There are some prerequisites to know about before running the demo: 1. Experience with HTML and JavaScript 2. Familiarity with PHP, including prepared statements 3. A text editor to adjust file content 4. Access to the command line through bash or another shell ### Getting TinyMCE started 1. In your development environment, create a new directory for the demo, create an index.html file in that directory. Also set up two more folders in the new directory, one for scripts, and one for PHP: ``` mkdir demoApp/ cd demoApp/ touch index.html mkdir scripts/ mkdir php/ ``` 1. Change into the scripts folder and create a new JavaScript file for the TinyMCE configuration, which is set up in step 5 of this procedure: ``` cd scripts/ touch tinymceConfig.js ``` 1. Change out of the scripts folder and then in the main directory, open the index.html file. Add the following starter HTML: ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="https://code.jquery.com/jquery-3.7.0.js"></script> <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script> <script src="scripts/tinymceConfig.js"></script> </head> <body> <h1>TinyMCE CMS Starter Config</h1> <textarea> <h1>Visiting Norway</h1> <p><strong><img style="float: right;" src="https://images.pexels.com/photos/1559825/pexels-photo-1559825.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260" alt="Town" width="300" height="375"></strong>Norway, officially the Kingdom of Norway, is a <a href="https://en.wikipedia.org/wiki/Nordic_countries">Nordic country</a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.</p> <p>The remote Arctic island of Jan Mayen and the archipelago of Svalbard also form part of Norway. Bouvet Island, located in the <a href="https://en.wikipedia.org/wiki/Subantarctic">Subantarctic</a>, is a dependency of Norway; it also lays claims to the Antarctic territories of Peter I Island and Queen Maud Land. The capital and largest city in Norway is <a href="https://en.wikipedia.org/wiki/Oslo">Oslo</a>.<strong><br></strong></p> <p>Listen to Norway's royal anthem on Spotify:</p> <div style="left: 0px; width: 100%; height: 152px; position: relative; max-width: 650px;" data-ephox-embed-iri="https://open.spotify.com/track/6SPocux2pBpFp3lshAOek1?si=907d52cf2af94efc"><iframe style="top: 0; left: 0; width: 100%; height: 100%; position: absolute; border: 0;" src="https://open.spotify.com/embed/track/6SPocux2pBpFp3lshAOek1?utm_source=oembed" allow="clipboard-write; encrypted-media; fullscreen; picture-in-picture;" allowfullscreen="allowfullscreen"></iframe></div> <h2>Geography</h2> <p>Norway has a total area of 385,207 square kilometres (148,729 sq mi) and had a population of 5,425,270 in January 2022. The country shares a long eastern border with Sweden at a length of 1,619 km (1,006 mi). It is bordered by Finland and Russia to the northeast and the Skagerrak strait to the south, on the other side of which are Denmark and the United Kingdom.</p> <p>Norway has an extensive coastline, facing the North Atlantic Ocean and the Barents Sea. The maritime influence dominates Norway's climate, with mild lowland temperatures on the sea coasts; the interior, while colder, is also significantly milder than areas elsewhere in the world on such northerly latitudes. Even during polar night in the north, temperatures above freezing are commonplace on the coastline. The maritime influence brings high rainfall and snowfall to some areas of the country.</p> <p><em>Featuring <a href="https://en.wikipedia.org/wiki/Norway">content from Wikipedia</a></em></p> </textarea> </body> </html> ``` 1. Add a link to TinyMCE through the CDN in the head section of the document, and a link to the TinyMCE configuration file: ``` <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script> <script src="scripts/tinymceConfig.js"></script> ``` > Note: The CMS demo makes use of several Premium plugins. When you [sign up for a FREE TinyMCE API key](https://www.tiny.cloud/auth/signup/), you get free access to all Premium plugins for 14 days from when you replace the “no-api-key” string with your own TinyMCE API key. Adding the key also removes any domain name related errors appearing in the text area. 1. Change back into the scripts/tinymceConfig.js file, open it, and add the following JavaScript content to get TinyMCE started: ``` tinymce.init({ selector: "#editor", plugins: "a11ychecker advcode advlist advtable anchor autocorrect autosave editimage image link linkchecker lists media mediaembed pageembed powerpaste searchreplace table template tinymcespellchecker typography visualblocks wordcount", toolbar: "undo redo \| styles \| bold italic underline strikethrough \| align \| table link image media pageembed \| bullist numlist outdent indent \| spellcheckdialog a11ycheck typography code", height: 540, a11ychecker_level: "aaa", typography_langs: ["en-US"], typography_default_lang: "en-US", advcode_inline: true, content_style: ` body { font-family: 'Roboto', sans-serif; color: #222; } img { height: auto; margin: auto; padding: 10px; display: block; } img.medium { max-width: 25%; } a { color: #116B59; } .related-content { padding: 0 10px; margin: 0 0 15px 15px; background: #eee; width: 200px; float: right; } `, }); ``` 1. Save the changes, and then change back into the main directory. Test out the demo by opening the index.html file in a browser, or by running a localhost test [with the Python command,](https://ryanblunden.com/create-a-http-server-with-one-command-thanks-to-python-29fcfdcd240e) or [PHP command](https://www.php.net/manual/en/features.commandline.webserver.php): ![The TinyMCE CMS demo working in the browser and ready to be saved to the database](https://images.ctfassets.net/s600jj41gsex/6LO93YvgD4nqcJyVIQfpza/5b0362977008cbb4f567cb7a9e53010f/img-TinyMCE-save-database-0.gif) ### Getting the database connection established 1. Change into the scripts folder, and add the following JavaScript to the TinyMCE init script after the content\_style option. It uses the TinyMCE setup option to listen for the change event. The change event registers when the editor loses focus, or the writer presses the Enter key. When the event happens, the jQuery gets the rich text editor content, and posts it onward to the database handler file. This content is what saves TinyMCE content to the database: ``` setup: (editor) => { editor.on('change', (e) => { $.ajax({ type: 'POST', url: 'php/save.php', data: { editor: tinymce.get('editor').getContent() }, success: function(data){ $('#editor').val(''); console.log(data) } }) }) }, ``` 1. Change back to the main directory, and then change into the php folder. Create a new PHP file for handling interactions with the database: ``` touch connect.php ``` 1. Add the following PHP content to the connection file. This receives the editor content, and then saves the TinyMCE content to a database file: ``` <?php $connect=new SQLite3('tinymceContent.db') or die("Could not connect to database, and save TinyMCE content"); $db="CREATE TABLE IF NOT EXISTS `Content`(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Content TEXT)"; $connect->exec($db); ?> ``` 1. Save the changes, and then close the .php file. 2. Create a second .php file to handle the process of inserting and saving TinyMCE content into the database, and then add the following PHP content: ``` touch save.php ... <?php require_once 'connect.php'; $editorContent=$_POST['editor']; $stmt = $connect->prepare("INSERT INTO `Content` (Content) VALUES (:Content)"); $stmt->bindParam(':Content', $editorContent); $stmt->execute(); echo "Save Data"; ?> ``` 1. Save the changes. ### Saving TinyMCE content to the database file with PHP and SQLite 1. In the browser, refresh the demo, and try entering some new content into the TinyMCE text area, and then clicking away from the editor or pressing the Enter key. If the PHP content is working, you’ll see a 200 status code on the command line (if you’re running the demo with a localhost for tests with Python or PHP): ``` [<date and time>] [::1]:60003 [200]: GET / [<date and time>] [::1]:60003 Closing [<date and time>] [::1]:60003 [200]: GET /tinymceConfig.js [<date and time>] [::1]:60003 Closing [<date and time>] [::1]:60003 Accepted [<date and time>] [::1]:60003 [200]: POST /php/save.php [<date and time>] [::1]:60003 Closing ``` The successful command line content (code 200) indicates that the database file has been created in the php folder following the steps set in the connect.php file. 1. Navigate into the php folder, and then open the tinymceContent.db database file with the SQLite command: ``` sqlite3 tinymceContent.db ``` 1. Query the database Content table to see the TinyMCE content saved in the database: ``` SELECT * FROM Content; … 1\|<h1>Visiting Norway</h1> <p><strong><img style="float: right;" src="https://images.pexels.com/photos/1559825/pexels-photo-1559825.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260" alt="Town" width="300" height="375"></strong>Norway, officially the Kingdom of Norway, is a <a href="https://en.wikipedia.org/wiki/Nordic_countries">Nordic country</a> in Northern Europe, the mainland territory of which comprises the western and northernmost portion of the Scandinavian Peninsula.</p> ... ``` 1. Exit the database using the .quit command ## Next steps for saving TinyMCE content in a database You can rapidly get content from the editor, and save TinyMCE content to a database making use of the process explained in the previous sections. In production, the pattern of collecting data with the [TinyMCE Get method,](https://www.tiny.cloud/blog/how-to-get-content-and-set-content-in-tinymce/) and [binding parameters in prepared statements](https://www.w3schools.com/php/php_mysql_prepared_statements.asp) represent consistent patterns you can make use of for your project. For more on getting a CMS ready using TinyMCE, check out [the tutorial on creating a CMS with TinyMCE](https://www.tiny.cloud/blog/tinymce-for-cms/) to rival the major content management providers out there\!
Shard	19 (laksa)
Root Hash	15564724552215073219
Unparsed URL	cloud,tiny!www,/blog/save-content-database/ s443