I would like to have a Wordpress plugin developed to access a single MySQL database on a different server than the server the plugin shall exist on.
Anyone using this plugin shall be given read-only credentials for that database. I will provide those credentials [as needed] when my plugin is installed on a new site. I shall provide the developer with credentials for developing the plugin.
The user name shall be hidden in the table code so that I can display the page coding (view the HTML) for the page it appears on [to allow me to confirm the username assigned to the site where the plugin might be displayed]. This would allow me to shut them down [by deleting their database credentials] if the site was abusing my database, being used on a site not authorized to use it, or being used on a site with objectionable material(s).
The plugin shall download a set number of records [randomly] from the database. Each record will have three fields (name, sortcode, and url). Only the name and url values shall be displayed in the table. Currently, that database has over a thousand records. But I expect it to grow considerably with time].
It shall sort the records displayed according to the strings stored in the sortcode fields.
Then it shall create a table displaying each name value linked to the corresponding url value. When a site visitor clicks on one of the links, it should open in a new browser tab.
The site administrator shall have an alternate means of displaying the name linked to the url to be displayed in a bulleted list. The site administrator shall select to display a table or a bulleted list using a joined pair of radio buttons.
The table or bulleted list shall be displayed in a widget so it can be placed in a header, footer, sidebar, or block on the WordPress site where the plugin is installed.
The administrator shall enter his database credentials into fields in the plugin when it is initially configured. The URL directing the plugin to the database server shall be constant (not to be configurable by the site administrator (not to be included in the configuration fields)).
The table must be customizable by giving the site administrator the freedom to set the table columns to a single value from 1 to 10, the table rows to a single value from 1 to 5, to set the background, text, and visited link colors by entering the desired hex code values (there shall be default values to be used until the site administrator changes them), and to set the width of the table border from 1 to 8 pixels.
The end result is that the table shall display a random set of links in the sortcode order. Each time the table is viewed [or its page is reloaded], a new set of random links shall be displayed.
I have attached an image showing a sample of what the table might look like for review.
Alternatively, the list must be customizable by giving the site administrator the freedom to set the number of bullets to a single value from 1 to 10. The background, text, and visited link colors shall match the page it is displayed on.
If the database is not contacted [or if the login is unsuccessful], the table or list shall be made transparent except to the site administrator [for whom it should display an error message], The site administrator shall also receive an email notification that the plugin is unable to connect to the database so corrective action can be taken. The notification should be limited to one message until the login issue is corrected [to avoid flooding his/her mailbox.
I shall develop and provide any writing necessary to include in the instructions displayed to the site administrator for use of this plugin.
This is a for fun project. It is not a money maker. So the funds I have to work with are limited.
If you are interested in doing this project for me, please submit a bid. If your bid is within the limits of what I can afford, I will seriously consider engaging your help on this project.
14 freelancers are bidding on average $213 for this job
Hi there, I have read your requirements and would love to help you in this project. Can we discuss more over chat. Awaiting for your positive response. Thanks
Dear Employer, I understand that you want to make MySQL Display Plugin [with Widget] for WordPress. I have good experience with below listed skills: PHP WordPress MySQL HTML Regards, Sunil