Post generated from SQL table

  • Dear all,
    I am looking for a simple and elegant way to auto generate post from a sql table.
    In short, I have an sql table that include different field, like
    $country, $capital, $population, $www.country.gov, $other_link.com.

    I would like that the query will generate me a post that will look like this:

    ———–
    Title: $Country
    Category: Page+$country
    —
    post text
    —–
    Capital is $capital, population is $population,

    [wpdatatable id=18 var1=’$country’] (a table generated with wptable plug in)

    [toggles title=”Government site”] [iframe src=”www.country.gov” width=”60%” height=”1300″][/toggles]

    and so on.

    Thank you very much for anybody would give me an easy way to implement it, php or plugin to use will be very welcome.
    Thanks.

Viewing 1 replies (of 1 total)

  • Hi,

    You may consider using pods to extend posts and store the post specific data in custom fields. this can easily be done using pods template and post template. some of the short code can be stored as post content, or in the post template.

    If you need to keep the sql table to integrate with other system, you may also use pods advanced content types.

Viewing 1 replies (of 1 total)
  • The topic ‘Post generated from SQL table’ is closed to new replies.