How to Restore MySQL Database from SQL File using PHP


restore-import-mysql-database-from-sql-file-php-codexworld

Generally, the import section of phpMyAdmin is used to import or restore the database from a SQL file. You can restore the database from PHP script without login to your hosting server or phpMyAdmin. Restore database from PHP script is very useful when you want to allow the user to restore the database from SQL file in your web application.


Upload and Store Image File in Database using PHP and MySQL


upload-store-image-file-in-database-php-mysql-codexworld

Server-side file upload can be easily implemented using PHP. There are various ways available to upload image to server and display images on the webpage. Generally, in a dynamic web application, the uploaded image is stored in a directory of the server and the file name is inserted in the database. Later, the images are retrieved from the server based on the file name stored in the database and display in the web page.


How to Upload Image in TinyMCE Editor using PHP


tinymce-upload-image-to-server-from-computer-php-codexworld

Image upload is a common feature in the WYSIWYG HTML editor. If you're using TinyMCE editor in the textarea, the image can be easily inserted in the editor. Server-side upload always a better option to insert the image in a TinyMCE editor. TinyMCE editor supports local file picking and image uploading. But, to make these features functional you required to configure the server-side upload handler.


Setup Maintenance Mode in CodeIgniter


codeigniter-maintenance-mode-page-setup-codexworld

Maintenance mode helps to improve user experience by showing a notification when the site is going through maintenance. When the web application needs an update, it's always a good idea to display a well-designed maintenance page instead of showing error on the website. CodeIgniter's Hooks feature provides an ability to implement maintenance mode functionality in CodeIgniter.


Add a Local File Picker to Image Dialog in TinyMCE


add-local-file-picker-to-image-dialog-tinymce-codexworld

TinyMCE is web-based WYSIWYG editor that converts HTML elements to an editor and instant ability to add HTML editor to textarea. You can easily add TinyMCE editor to HTML element by writing minimal JavaScript Code. TinyMCE has many advanced features which make your WYSIWYG editor more powerful and user-friendly. This tutorial will show you how to add a local file picker to image dialog in TinyMCE editor.


Inline Table Editing using jQuery Ajax PHP and MySQL


inline-table-edit-delete-jquery-ajax-php-mysql-codexworld

Inline editing provides an easy way to edit data in table cells. If your web application has data grid functionality, inline edit & delete is the must-have feature. The user can edit and delete content on the same page by clicking the row in the table. Inline table editing provides better user experience and makes the web application user-friendly. Live table editing functionality can be easily integrated with jQuery and Ajax.


Ajax File Upload with Form Data using PHP


ajax-file-upload-submit-form-data-jquery-php-mysql-codexworld

File upload functionality is the most used feature for the web application. Generally, a form is submitted to upload file in PHP. IF you want to provide a better user interface, jQuery and Ajax can be used to upload file without page refresh. The FormData object compiles a set of key/value pairs to send using XMLHttpRequest. The files can also be sent using FormData by including a file input element in your the form.


Credit Card Validation using jQuery


credit-card-number-validation-jquery-codexworld

Credit card validation is the must-have functionality on the payment form. It helps to validate credit card number and other details before submitting the payment. You can easily implement the credit card validation on the payment form using jQuery. We will create a simple jQuery plugin for credit card number validation. This jQuery plugin detects and validate credit card numbers, and instantly check whether the card is valid.


Convert Array to XML and XML to Array in PHP


convert-array-to-xml-parse-read-file-php-codexworld

XML is used in many ways in the web application. If you're concerned about database size and want to reduce database uses, XML can help you to free the space from the database. Instead of the database you can store the data in the XML file and retrieve data from XML file without connecting to the database. This tutorial shows how to convert PHP associative or multidimensional array to XML and stored in the XML file.