Skip to main content

Practicing PHP and SQL on an Android phone(full guide) x-droov

Practicing PHP and SQL on a phone is difficult because they aren’t like html, JavaScript and css that are  read by the browser. JavaScript and CSS are browser specific in such a case that every browser has its own JavaScript or css readers. Php and SQL on the other end provide service in a webserver. Most webservers come with PHP and SQL preinstalled.
The webservers also provide ftp engines for you to transfer files easily. Ftp(File Transfer Protocol) is the same as HTTP(Hypertext Transfer Protocol), but instead of transferring Hypertext, it transfers files. If you know reading logs, you can also analyze your logs because they are provided by the server. If you don’t know logs, these are records of how users come into your site and how they navigate through it. The logs also contain IP addresses of all your visitors.
I know that you are anxious to practice php and SQL on your phone and I am going to guide you through the whole process. Learning to work with servers is a skill you need to acquire to succeed online and you need to know one server-side language like php or asp.  Don't be scared because you can follow my article on learning any language in weeks. 
In a server, you can’t store user data without server processing ability. 
It’s also difficult to switch from saving html code and simply running it to saving php or html pages and running them by using a URL on any browser in your device so read carefully to analyze the difference.

How do servers work

Servers have ports which are like ears. The server listens through a certain port for all signals referring to its IP address. When a signal comes, the server processes it. If the signal calls for an HTML document, then it’ll simply be sent to the requesting browser. If, on the other hand, the signal requests for a PHP script, the server processes the PHP code turning it into HTML then sends it back as HTML. Servers have several states, but only two are common. 

1. Root port 8080

This is a server confined to the phone or computer local network. Take an example of a signal being run by cable. The signals from the server to the browser and back are not transmitted by the phone’s radio transmitter like the normal URL calls, but they are transferred as digital signals through the phone.

2. Web port 80

This is to make your website available online. Instead of spreading the signal through the phone’s infrastructure, the server broadcasts the radio signal which is transmitted far away to a requesting browser using the internet service provider's wide-range radio transmitters.

Which server can process your PHP and SQL code on Android

Here, I will have to be precise. Download Awebserver from any apk site. This server comes with the whole pack of resources to make a full backend website or great web applications.  If you’ve never created a working login form field, great time, because with Awebserver, you can make it.
Awebserver comes with php installed, mysql mariaDb installed, working ftp engine, a log machine and a text editor for you. You may try other webserver options, but you’ll realize that some of them require you to download the sql and php installations manually. Some may also need their own compilers to be downloaded.
Awebserver can make your html editor quite useless because it’s a full pack. One key note that I can give a php or server beginner is not to consider php different from html, but instead see it as JavaScript for the browser.
To run PHP code on a server, you don’t open the php file directly in the browser, but you refer to it with a URL for example; If you have a bb.php file in the main server file, to access it locally you may need to enter something like:

Http://0.0.0.0:8080/bb.php

Seen? It’s real web stuff. You have to change your view of web pages to a different server way of thinking. To sum up, I have some three great tasks that a server can do for you.

What a PHP and SQL server can do

1. Form fields

With the server, you can process login forms, search input, email subscription, autosuggestion,  and many more form-based fields. With the server, you can create search aids, but not search engines because search engines have robots that collect information for them. That’s opposed to php search fields that depend on MySQL databases.

2. One time website creation

With a server like Awebserver, you can create one skeleton html page like a home page then create all the other pages dynamically by simply changing values of certain HTML elements. That means that you have a great opportunity for automation because you can create a posts database where you just feed in your content and the server creates the actual pages.

3. Dynamic pages

With server technology, you can decide to load only part of a web page and not change the whole page. This is using the xmlHttprequest or the JavaScript API for backend connection.

Conclusion

You need to learn how to use a server and mostly how to connect with your database because that’s where the world has moved to. Look at x-droov as a site. It’s created dynamically by Google servers. Keep learning. If you wish, you can also create a blogger site and obviously check on my review of the blogger mobile app.
If you didn't understand any concept, don’t be scared to let me know in the comments section. And I would like to know why you want to learn server side programming. Thanks for reading.

AUTHOR 

Emmy Jayson x-droov

Emmy Jayson

Comments