In the editor it looks like that:

Usually you use the cms syntax e. g. [b]bold[/] and HTML and PHP are not interpreted. But you can switch to HTML!

[h:]
Now we are in an HTML-section. Here the cms syntax is not interpreted (except some commands. In this section HTML is interpreted, so bold is now <strong>bold</strong>.

<br /><br />

Here you even can use PHP, if you set

$executephp='onallpages';

in the config file config.php of your u5CMS installation (and further, eval() must NOT be deactivated on your server!); here a PHP-example:

<br /><br />

<?php
echo 'Hello world!';
?>

<br /><br />

Let's now switch back to standard cms syntax mode.
[:h]

From here its again [b]bold[/] and not <strong>bold</strong> and
<?php
echo 'Hello world!';
?>
does nothing!

The vertical red line does not appear in the editor, it is only shown here for better understanding.

If you need such generated content “naked”, i. e. without the surrounding template/css, call u5sys.content.php instead of index.php, e. g. http://yoursite.com/u5sys.content.php?c=pagename

The string src="r/... is automatically translated to an u5CMS-specific command in the background. That may disturb your code which is between [h:] and [:h]. Avoid this by adding point slash, e. g. src="./r/... .

However, let the system do the job (i. e. do not add point slash) when src= is pointing to a login protected object which you have uploaded in the u5CMS backend, e. g. [h:]<img src="r/animage/animage_2n.jpg" />[:h]

Calculate something with JavaScript:
Notice: In u5CMS, variable names, function names a.s.o must be strings of non-special characters e. g. a-z
[h:]
<script>
a=1;
b=2;
document.write(a+b);
</script>
[:h]

Calculate something with PHP:
Notice 1: In u5CMS, variable names, function names a.s.o must be strings of non-special characters e. g. a-z
Notice 2: Do NOT use Short Open Tags <? use Full Tag <?php
Notice 3: PHP must be switched on in your u5CMS's config.php (there, look for "Where PHP code shall be executed")
[h:]
<?php
$a=1;
$b=2;
echo $a+$b;
?>
[:h]

Calculate something with jQuery (e. g. decode HTML entities):
[h:]
<script>
varTitle = jQuery('<'+'textarea />').html("Chris&apos; corner").text();
alert(varTitle);
</script>
[:h]

Important note for u5CMS versions before 4.2.x

×

When using jQuery, write the full command jQuery not the abbreviation $ !

Thanks to the ability of u5CMS to execute PHP on its pages, you easily may directly query the u5CMS tables.

There is no need to establish a connection to the database, it is already activated IF you use the old fashioned mysql-extension syntax as shown below (u5CMS transforms this automatically to mysqli-extension syntax in the background). Therefore, with old fashioned mysql-extension syntax, you can directly start like this (if you use mysqli-extension syntax, you have to establish the connection first):

[h:]
<?php
$sql_a="SELECT content_1 FROM resources WHERE name='".mysql_real_escape_string($_GET['c'])."'";
$result_a=mysql_query($sql_a);

if ($result_a==false) echo 'SQL_a-Query did not work!<p>'.mysql_error().'<p><font color=red>'.$sql_a.'</font><p>';

$num_a = mysql_num_rows($result_a);

for ($i_a=0; $i_a<$num_a; $i_a++) {
$row_a = mysql_fetch_array($result_a);
echo $row_a['content_1'];
}
?>
[:h]

How to read a value of a field in datacsv of table formdata

Remarks (mysql-syntax, preloaded functions for you)

You have to know, that the content of your u5CMS site is in table resources and there in the following columns:
1st language in column content_1
2nd language in column content_2
3rd language in column content_3

So IF you do direct querying, and your first language is e. g. English (contained in column content_1), the second language French (contained in content_2) and the third language Deutsch (contained in conent_3), it becomes a bit brain stuffy for you, but it keeps your mind fit!

For the functionality described on the page at hand, make sure you are using a current u5CMS version. You'll find the version number by surfing to your website and switching your browser to show the HTML source code. At the very bottom of the source code you'll find a line like this:

<!-- This site runs with u5CMS version 12.4.3 from https://yuba.ch/u5cms -->

If there is no such line or no version number or one lower than V8.3.3, see the following instructions: