₦airaland Forum

I recently dived into exploring different frameworks and CMS, Today it was google .blospot turn I was able to transform a blogger website into a premium design try to view this blog. and reply with your comment or contribution.

http://recentjobvacanciesinnigeria..com/

As a programmer i started getting my hands dirty with google . site but I id not know how to customize the designs, After some research I was able to crack it open.

I noticed mos of the upcoming bloggers and developers in Nigerian can't afford a premium domain so they start with . site but as soon as they get enough money to create a premium site they always abandon it for wordpress, Some get to transfer the articles but most don't, This is due to complexity in modifying and customizing blogger websites.
Now you can stay with blogger and manipulate it to suit your taste without loosing any traffic article and also this will improve user experience.

Am willing to write the tutorial and share it with all the programmers in the room but I want to know the level of interests of everyone before I start. so that it will no be a wasted effort.

Nairaland was build with SMF forum CMS, but it has under gone a whole lot of modifications for security,speed and user friendliness purposes.

The reason why you are seeing an ugly code is because,If you want your website to load faster you need to compress the source codes which is known a minify : you can read more here:http://www.codingsavvy.com/2015/05/how-scripts-images-and-css-minify-can.html
You will have two version of your website which is compressed and uncompressed, It is the compressed version that will be deployed to the web while the uncompressed version is useful for further updates and developments.

Nigerians don't pay programmers much, In fact they don't value you for your work after all those sleepless nights, body each and time you spent developing stuffs they see it as if they are helping you by buying it meanwhile you build to make their life easier.

I will recommend that you build for the we, contribute to open sources,Create wordpress,Joomla designs i.e themes, plugins that you can sell on Themeforest or other shops,
Start blogging (It might be hard communicating with people after coding ,Try to relax and write to humans not computer).

Create some free online applications and put ads on it.


That's how we survive here in the North.

For those that had it and never shared it, Shame on you God bless Nigeria.
All states and local governments in Nigeria in JSON, PHP and MySQL readymade in format/Structure.
I believe this is useful to all programmers respective of the language you code in because JSON data structure cut across all languages.
I was able to give all States and Local Governments and Index ID which make it easy for you to use both JSON and MySQL format together without sending a Query into the database, The ID in the JSON will be used as the index ID in the MYSQL tables for states and local Governments.
I have included JQuery to avoid cross browser issues in the JavaScript but if you don’t user JQuery you can easily crack it into a native code, but the JS code might be longer.
See the Demo Below to see how it’s done:
//START CODE
(The post was too long, use the link below to view the code)
//END CODE
Using it as above will really save you time from writing bunch of AJAX codes to request for a whole select box.
I will recommend that you keep the nigeria variable in a separate javaScript source file.

Here is the MySQL data that rhyms with the nigeria vars.

This might be a very long scroll:

//MYSQL STATRT (You can copy and send this as query directly into you database.)
(The post was too long, use the link below to view the code)
//MYSQL END
I case you have errors with this data it might be that the forum text editor has modified it.

To be sincere I had to got through wikipedia and extract the whole table as it was arranged and make the arrangement alphabetically using just a mini extractor I created through the night with JavaScript/PHP codes
I am mentioning this in case you are faced with the-same situation which might not be exact, This will give you have to bypass some of those long queue of copy and paste.

You can download the complete source code in a zip package and tutorial on how the extraction of all states and local governments
from wikipedia was converted to JSON and MySQL on my blog: http://www.codingsavvy.com/2015/06/convert-raw-html-data-into-jsonphp-and.html