Wordpress sync to database

  • Durum: Closed
  • Ödül: $50
  • Alınan Girdiler: 1

Yarışma Özeti

I need a simple solution for synchronizing a Wordpress blog contents FROM a database: Create/update/delete a post on the blog for each item created/updated/deleted in the database. The point is to keep the blog in sync with the database, on an ongoing basis. Individual blog posts must be created for each row in the database table.

MORE DETAILS:

I need someone to write for me a WP plug-in which executes automatically every 5 minutes and performs {SELECT * FROM TABLE} on a database to retrieve 3 columns: ID (int), TITLE (varchar), CONTENT(text), PHOTO_URL(varchar). Each row of data is used for creating a new Post inside of WP, if the ID does not already exist. If it exists, the Post is updated instead. If an ID is removed from the database, the Post is updated with the status {This post has been removed from the database}. The work must be done 100% inside of Wordpress and packaged for delivery as a zipfile plug-in (no root access to machine).

HOW TO TEST YOUR SOLUTION:

Please make your own database table (with just 4 columns: ID, TITLE, CONTENT,PHOTO_URL) with some sample data and install your own Wordpress on localhost. I will not supply any servers or testdata or any other resources.

HOW TO SUBMIT YOUR ENTRY:

This is an open-source competition. You must upload your solution to [login to view URL] using a GPL v3 license and submit the URL here. We will check timestamps to ensure late submissions are not copying code from early submissions. Only the FIRST working solution will be awarded.

Tavsiye Edilen Beceriler

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • afterhourstech
    Yarışma Sahibi
    • 4 ay önce

    PRIZE IS INCREASED TO $50.

    • 4 ay önce
  • afterhourstech
    Yarışma Sahibi
    • 4 ay önce

    I need something similar to this https://wordpress.org/plugins/sqltable/

    • 4 ay önce
  • gehlot
    gehlot
    • 4 ay önce

    Describe more about task .

    • 4 ay önce
    1. afterhourstech
      Yarışma Sahibi
      • 4 ay önce

      I have updated the contest description, please check. Prize is increased to $25.

      • 4 ay önce
  • VisionXTech
    VisionXTech
    • 4 ay önce

    Hi You need Plugin in Wordpress by using which you will be able to take the backup of your database like the blog posts that you have created, you can also take their backup on daily basis or whenever you need right? If this is so you can contact me over chat by going to my profile.

    • 4 ay önce
    1. afterhourstech
      Yarışma Sahibi
      • 4 ay önce

      No this is not correct. I have empty blog and I have a database of information and I need to populate blog with the contents from database.

      • 4 ay önce
  • afterhourstech
    Yarışma Sahibi
    • 4 ay önce

    THE PRIZE HAS BEEN INCREASED TO $25

    • 4 ay önce

Daha fazla yorum göster

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!