Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not familiar with WP but if you get your categories with some function like <code>get_categories()</code> then you can use <a href="http://php.net/manual/en/function.implode.php" rel="nofollow">implode</a> to make a string from all categories.</p> <pre><code>&lt;?php $categories = get_categories(); ?&gt; &lt;?php $categories = implode(' ', $categories); ?&gt; &lt;li class="&lt;?php echo $categories; ?&gt;"&gt;...&lt;/li&gt; </code></pre> <p>Could you provide what is returning <code>get_categories()</code>?</p> <h2>EDIT:</h2> <pre><code>function get_class_attr() { $classes = get_post_class(); $classes = substr($classes, 7, -1); $arr = array(); $arr = explode(' ', $classes); $classes = 'class="'; foreach($arr as $class_name) { if(strpos($class_name, 'category-') !== false) { $classes .= substr($class_name, 9).' '; } } $classes = substr_replace($classes, '"', -1, 1); echo $classes; } get_class_attr(); // output: class="3d web" </code></pre> <p>Also note that <code>3d</code> is not a valid class name, you can use something like <code>movie3d</code> or <code>film3d</code>. </p> <p>Alternative way is to create your class value a little bit earlier and then <code>echo</code> it:</p> <pre><code>&lt;?php $classes = array(); if ( in_category('category-3d')) { $classes[] = "3d"; } if ( in_category('category-animation')) { $classes[] = "animation"; } if ( in_category('category-motion')) { $classes[] = "motion"; } if ( in_category('category-shortfilm')) { $classes[] = "shortfilm";} if(count($classes)) { $classes = implode(' ', $classes); } else { $classes = ''; } ?&gt; &lt;li class="&lt;?php $classes ?&gt;"&gt;&lt;/li&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPhp syntax for echoing multiple classes with a space between them
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USenenen
    1. USenenen
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you guys but all your codes returned me errors. Maybe I did somthing wrong... And I wish I could stick as much as possible with what I've already written (or at least keep the logic of it) and just add the condition that could echo the rest of my classes. That way I can control what WP displays and understand it since I'm learning at the same time. Is there something wrong with the part I've written? (cc @feeela )
      singulars
      1. PO
      1. USwyem
    2. COOk, how did you get the categories for a specific post? As I said I'm not familiar with WP but there should be a function like `get_categories()` or something like that to get an array with the categories.
      singulars
      1. PO
      1. USenenen
    3. COWhen I create a post, I just add a category name and then it's stored somewhere. When I call `<?php post_class(); ?>` in my `li`, it echoes this `class="post-54 post type-post status-publish format-standard hentry category-3d category-web"` which is waaay too much. So with my little piece of code, I try to echo only the 2 or 3 items I need. Not sure I'm very clear... :)
      singulars
      1. PO
      1. USwyem
 

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