Databases
StackOverflow2013
Postsdbo
POWordpress manually Attach Images to Post using SQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWordpress manually Attach Images to Post using SQL
    primarykey
    data
    text
    <p>I have created a custom post type called products and need to associate multiple images with one product. The actual data already exists in a different non-wordpress database in a table called productimages that simply has a productid, imageurl, and image title. I need to convert this data into wordpress format so wordpress can display everything I need. This is something that will be done regularly using sql automatically deleting products and meta data related and re-adding from our main database which changes regularly.</p> <p>From what I can tell, the best way to make this work is to manually use sql to insert the productimages as attachment posts just like wordpress does when you upload media to wordpress. Then to associate the image with a product I have to manually insert records into postmeta but the data in postmeta is serialized or something and I am unsure how I would insert the data in the correct serialize format using mysql. Is it even possible to do this with mysql?</p> <p>Am I going about this wrong? Should I be doing something different? I was originally going to use custom fields till I realized a custom field can only have one value and I needed two values: imageurl and imagetitle for each image. So it seems programatically creating a post type of attachment for each image is the best way to go. yes?</p> <p>I look forward to anyone's response to help in this matter.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USgreatwolf
    1. USJesse
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWordpress manually Attach Images to Post using SQL
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POWordpress manually Attach Images to Post using SQL
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou know that serialization exists; now you should realize that even though a custom field can only have one value, that value can be a serialized form of many values. It can be as simple as separating the imageurl and imagetitle by a comma, then separating the string at the comma in your template. You can also have infinite custom fields for each post, so you can have infinite imageurl and imagetitle entries.
      singulars
      1. POWordpress manually Attach Images to Post using SQL
      1. USDan Grossman
    2. COyes I understand serialization would be a great solution.... I just need to figure out how to write a simple php script that uses serialzation. I'm unsure is serialization special to wordpress or can i use it outside of wordpress to serialize a multi dimensional array and then within wordpress unserialize it on a wordpress template page to display to the end user or is there some special serialize settings wordpress uses? Any such resources in regards to this?
      singulars
      1. POWordpress manually Attach Images to Post using SQL
      1. USJesse
    3. COYou must learn to start referencing the PHP manual. Heck, just type "php [word]" into Google. "php serialize" would immediately lead you to the manual page and you'd see it's nothing special to WordPress (and you could write your own serialization method damn easily anyway, I already described how mentioning separating two values by a comma) [serialize](http://php.net/manual/en/function.serialize.php), [unserialize](http://php.net/manual/en/function.unserialize.php), [implode](http://us2.php.net/manual/en/function.implode.php), [explode](http://us2.php.net/manual/en/function.explode.php).
      singulars
      1. POWordpress manually Attach Images to Post using SQL
      1. USDan Grossman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload