The Software Programming Experience of a Tech Lead: MySQL
» Coding Savvy FB Twitter Google
Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

How to create MySQL Database using PhpMyAdmin

Database connection is the backbone of web development, manipulating of data is what most programming languages do but what about if we are interested in strain the data for a longer period of time, then this is where database comes in. Most of the popular databases like ORACLE,SQL,SQLITE,MYSQL are all serving the same functions with some little difference such as their capacity but their primary purpose is to store data. In this tutorial we are going to discuss how to Create MySQL Database using PHPMyAdmin user interface.
How to create MySQL Database using PhpMyAdmin

Convert raw HTML data into JSON,PHP and MYSQL: Nigeria States and Local Government Updated 2017

I was recently challenged with listing the states and local government of my country but I had nowhere to turn to for the data, The available and most updated list of states and local governments is on wikipedia and it was scattered (Arranged in accordance to local governments). This might also be useful to you in case you are in thesame situation with that of your country, I believe wikipedia structure such data in similar format.
Convert raw HTML data into JSON,PHP and MYSQL: Nigeria States and Local Government

User Friendly tutorial on setting up FTP, PHP, MySQL and Apache on Amazon’s Elastic Compute Cloud, or EC2 Instance

This might not work for you due to Amazon Aws updates, Please visit Amazon aws EC2 'Elastic Cloud' Setup with Ubuntu, PHP, Apache, Node.js, MySQL and PHPMyAdmin Installation for the updated article.
I just set up my own Amazon’s Elastic Compute Cloud, or EC2, After lot of Googleling and reading I finally found a solution to it but it took me time before i got my hands on it, so if you have been in my shoes and you found this site I congratulate you because today is your lucky day. Am writing this tutorial to help people like me who are willing to create their own Amazon’s Elastic Compute Cloud, or EC2 Instance and also we are going to discuss how to link your instance to your Active Domain name. This is a very user friendly tutorial for EC2 Setup, This tutorial will lead you to huw to setup and install PHP, MySQL Apache and FTP on your EC2 instance but you can always use the same procedure to install any other type of server you wist o install too.