SPIP

Les articles publiés sur le site

• The HTML structure of forms in SPIP 2

  17 août 2010, par Mark — Interactivity
  A reference document detailing how forms in SPIP should be structured HTML structure A basic form is structured as follows: A legend An explanatory text Email #AIDERarttitre Label explanation Error message The surrounding div is assigned the generic class formulaire_spip. Data entry forms in (...)

• Joins between tables

  17 août 2010, par Mark — A few examples of loops
  Some examples of loops that generate multiple joins between 3 tables [spip 2.0.9] We would like, in a single loop, to retrieve the data from some articles from one (or several) sections to which a predetermined keyword has been assigned. will generate the following SQL query: SELECT (...)

• {collecte}

  17 août 2010, par Mark — Criteria
  The collecte criteria is used to specify the "collation" to use for the request generated by the loop (by making a call with the "COLLATE" clause in MySQL [1]). The collecte criterion, (since SPIP 2.0), is used to force the SQL query generated by the loop to which it is attached to use a (...)

• { !criterion operator value}

  17 août 2010, par Mark — Criteria
  This is the logical operator for Complementarity, indicating that the complement of the operation should be executed. This syntax is principally useful for loops that involve multiple joins between tables, e.g. keywords/articles or documents/articles, etc. It makes it possible to select not (...)

• {criterion !operator value}

  17 août 2010, par Mark — Criteria
  This is the logical negation operator; it inverts the meaning of whatever operator immediately follows it. id_rubrique != 12: returns the data from sections with an (#ID_RUBRIQUE) ID that is not equal to 12. titre !== ^(a|e|i|o|u|y): returns data from the objects (articles, sections...) which (...)