Find solution
How To Avoid Power Cut?

How do I develop a power cut timetable system to embed in my WordPress website?

  • Hie Guys, I live in a country called Zimbabwe. As you may already know its a country whose leadership has been squabbling with EU and the US, who is wrong there, is a discussion for another day but bottom line the economy and life has deteriorated over the years. Now,we have been having power outages for years now because our electricity demands are higher than the output produced by the power company. now its winter and the power company has stepped up the power cuts,imagine the horror of power being cut off when you are cooking or bathing or watching a movie. You have no idea when they are going to cut power. Now the power company has released power cuts schedule and no one in my country as far as i know has developed an app or some kind of system that can be embeded in a website. my knowledge of code is very limited but i run a news blog and i think it would be very helpful for my countrymen if i were to put up such a system on my blog. its running on wordpress. i envision something with a simple interface where the user simply enters the area he resides in, then when it queries the database, it must display the date and times electricity will be off in that area . below is a sample of the power outages from the power company Please help me out guys

  • Answer:

    This sounds like a great assignment for students so it doesn't sound difficult. Sorry I don't have time to implement it all or go into detail. You could create tables with these columns (all text data) table T1: WEEKDAY TIMEPERIOD CODE table T2: REGION         (if there are more than one) CODE SUBURB T1 rows like "MONDAY","0500-1300","H2" "MONDAY","0500-1300","H4" "MONDAY","1300-2100","H1" T2 rows like "HARARE","H1","Alex Park - Part"      (bad idea to have same suburb text for both H1 and H7?) "HARARE","H16","Glen Norah" That's the base information although the commands to search and put the view together would be important too. I use relational databases like MySQL but there would be lots of options. I won't have time to go over selects and joins but I hope it helps to see how to arrange simple tables. Their tables are meant to be more human-readable, perhaps confusing for programming.

Jeff Smith at Quora Visit the source

Was this solution helpful to you?

Other answers

To sum up your requirements, your looking for a way to create a data table on you website which allows users to sort, filter and search the data. The plugins mentioned below will accept Excel CSV documents as input and will create a HTML table for you. They also accept other data inputs: DB, JSON etc. Check out this free plugins:  https://wordpress.org/plugins/tablepress/ Read this quick overview of Tablepress: http://tidyrepo.com/tablepress/ There is also a paid plugin that will do the job: http://codecanyon.net/item/wpdatatables-responsive-tables-in-wordpress/3958969 FYI - these plugins are actually based on https://datatables.net/ I hope this helps you out.

Chirag Gude

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.