For you lot who are using PC to prepare website using PHP in addition to SQL locally on your estimator must travel familiar amongst programs similar XAMPP. But how nearly similar apps on Android? One of most pop is KSWEB, but they are paid app. There are a lot of other gratuitous apps but most of them using outdated version of PHP / SQL. And forthwith I volition portion you lot the gratuitous Android apps, yet they are using the updated version of PHP in addition to SQL, in addition to most cracking are they are opened upward source, it is Esminis Server Packages (APK).
What I similar from the apps that they provided dissimilar version of servers. For illustration PHP server, the app already include PHP 7.20 piece most of other spider web server Android app withal using PHP 5.xx. Additionally, you lot tin too download in addition to utilisation PHP 5.xx instead if you lot want!.
Sorry if I misname the publisher, I conduct keep "Esminis" from their app bundle id :D . The iii Android apps I'm going to portion correct forthwith are alone the minimum requirement or mandatory inward fellowship for us to stimulate an integrated spider web server thence nosotros tin stimulate website locally on our Android device using PHP in addition to SQL. They are "HTTP Server Powered yesteryear Apache", "Server for Apache", in addition to "MariaDB Server". You tin download all of them for gratuitous on Play Store, but if you lot postulate apk file you lot tin detect it at the terminate of thid post.
Installing HTTP Server, PHP Server, in addition to MariaDB Server on Android
Before installing these servers, brand certain you lot conduct keep plenty gratuitous infinite inward your Android device internal storage. On my Android device, the iii servers conduct keep amount of +-700 MB of my internal storage.
- Installing PHP. Download in addition to install "Server for PHP" app on your Android device.
You tin download other PHP Server available if you lot want, or only install the latest PHP version provided inward the app. Wait until installation is done (might conduct keep a while)
After the PHP is complete installed, alter the server address selection to "127.0.0.1"
- Installing HTTP server. Download in addition to install "HTTP Server Powered yesteryear Apache" app on your Android device to setup HTTP server.
You tin download other versions, or straight install the latest version provided inward the app. Wait until the installation done (might conduct keep a while).
After the server is complete installed, alter the server address selection to "127.0.0.1".
Now acquire to the app setting (tap on gear icon), tap on "CGI" section. And banking concern tally the selection to enable CGI from Server for PHP app. This volition enable us to utilisation PHP scripting on the HTTP server.
- Installing MariaDB / SQL server. Download in addition to install "MariaDB Server" app on your Android.
Launch the app, in addition to install the latest MariaDB server provided inward the app or you lot tin download in addition to conduct other version. Wait until the server is complete installed.
"Where is MYSQL?" MariaDB is a gratuitous in addition to ascent opened upward source projection created to stimulate amend in addition to faster database server. Now many people are switching from MySQL to MariaDB. What's the deviation betwixt them? Almost goose egg major is dissimilar except their extension (how nosotros utilisation ascendence to acces them). You tin googling to know to a greater extent than nearly MariaDB in addition to its history.
After the server is complete installed, alter the server address to "127.0.0.1".
- Starting the server.
Launch "HTTP Server Powered yesteryear Apache" app, in addition to tap "Start Server" to start out the HTTP server in addition to PHP. If this is the outset fourth dimension you lot start out it, it mightiness volition conduct keep a while.
Launch "MariaDB Server" app, in addition to tap "Start Server" to start out the SQL / database server thence you lot tin start out working using database.
Done! Now you lot tin access your alive local website yesteryear accessing http://localhost:8000 using your browser.
Upload your website files in addition to PHP scripts to SdCard/htdocs/public/ directory.
How to install phpMyAdmin
Allright that forthwith your server is alive on your Android device, you lot desire to utilisation phpMyAdmin to deal your database correct forthwith but can't detect it? You conduct keep to install phpMyAdmin manually. Don't worry, follow the next slowly steps:
- Download phpMyAdmin on the official website: www.phpmyadmin.net/downloads/, If you lot are confused you lot tin download it from mirror link at the terminate of this post.
- Extract phpMyAdmin archive file in addition to and motion the root extraction folder to SdCard/htdocs/public/ directory. Note that you lot should rename the phpMyAdmin root folder (phpMyAdminxxxxxxxxx) into something brusk similar "pma" thence nosotros tin easily access it through url later.
- Start the HTPP in addition to MariaDB server. Now access phpMyAdmin setup page, I conduct keep renamed my phpMyAdmin root folder to "pma", thence to access it is yesteryear visiting http://localhost:8000/pma/setup/index.php using browser. Now inward phpMyAdmin setup page, click "New Server ".
- In the "Basics settings" tab, stimulate total the next fields:
Server hostname: localhost:3306
In the "Server configuration" tab, banking concern tally "Allow logins without a password". After all done, click "Apply" push inward the bottom.
The other tabs are optional, you lot tin stimulate total it if you lot already an advance user. Besides, no postulate to intend things similar extra safety if nosotros alone postulate to run servers locally on our Android device for testing / learning utilisation right?
- Now you lot are redirected dorsum to setup index page, click "Display" push inward the bottom, in addition to re-create all the generated configuration file text.
Next, exercise a novel empty file using your file manager named "config.inc.php" inward the phpMyAdmin root folder directory (in my instance it is within SdCard/htdocs/public/pma/), thence glue the configuration file text you lot copied at that spot in addition to save.
- Done! Start login to phpMyAdmin yesteryear accessing http://localhost:8000/pma/index.php using your browser. Use "root" every bit the username amongst blank/empty password to login.
Demo of JohnCMS I conduct keep installed on my Android telephone yesteryear using Esminis server apps.
Esminis Server Apps APK Android apps download link
Tested on: Samsung Galaxy V SM-G313HZ
-> PHPMYADMIN v. 4.7.9-english.tar.gz (5.7 MB)