Product Tables

  • RustyFish

    (@rustyfish)


    13 years, 2 months ago

    Hello, Good Morning, Good Afternoon Everyone,

    Looking for some advice if I may.

    I want to create a product table that will be linked to a table created within the wordpress database. The tables will be a list of parts, with field such as part number, sizes, datasheets (pdf link), etc

    I had looked at using wp-table reloaded, but I want to keep it easy to update, so feel doing the product table directly in the SQL database and using a front engine to update it will work best.

    However, I was wondering what the best way to get the info and tabulate it on a page is. Is there a plug, any raw code examples, tutorials etc??

    Any help would be hugely appreciated

    Thanks
    Rustyfish

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter RustyFish

    (@rustyfish)

    13 years, 2 months ago

    Hi All,

    Ive actually managed to solve this now using the $wpdb commands straight in to my database.

    However, this leads me on to another question. Within this table is a field for a product image. I have set the field as a Varchar, and then added the address to this line. Example: /httpdocs/wordpress/wp-content/uploads/images/example.png

    Unfortunately, it does not seem to pick up and show the image, so Im wondering if I have done this right?

    Any help??

    Thread Starter RustyFish

    (@rustyfish)

    13 years, 2 months ago

    Im struggling to get this to display the image, any ideas??

    <?php
    global $wpdb;
    $products = $wpdb->get_results(“SELECT * FROM mydatabase”);
    echo “<table border=1>”;
    foreach($products as $part_num){
    echo “<tr>”;
    echo “<td>”.$part_num->part_num.”</td>”;
    echo ‘<td> <img src=”.$part_num->image.”> </td>’;
    echo “</tr>”;
    }
    echo “</table>”;
    ?>

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Product Tables’ is closed to new replies.