Insert PHP code in Elxis

[mrjack]

Is it possible to use previously created PHP code and integrate it in Elxis?

[ks-net]

As far as i know this is only possible in  a wrapper(include a php page)... not in content items or custom modules

[Coursar]

You can create mambot, module or component.

[datahell]

The creation of a component is easier than you think. A simple component (not installable) can be just one file of php that will include everything you like. Example:

components/com_mytest/mytest.php

And you call it from the URL like this:
http://www.mysite.com/index.php?option=com_mytest&Itemid=XX

Of course you need to create a menu Itemd (XX in the above example) that points to that component. In order to do this the component should have an installer but you can alternatively install it manually by just adding one row in table #__components. Then you will be able to create a menu item that will point to that component via Elxis administration.

If you wish to have SEO PRO support for that component you will have to create a seo pro extension for that component and add it inside folder includes/seopro/ as com_mytest.php.

After this your component will be accessible like this:
http://www.mysite.com/com_mytest/

[mrjack]

Thanks for the help . Now I'd like to integrate my php page output in Elxis. What do I have to do? Include some elxis file?

[datahell]

It depends on what is this "my php page" you are talking about. Elxis is a CMS and it has its own content system. You can copy the articles from your old site to Elxis content items. You can use the wrapper component to "wrap" your old page inside elxis. You can do many things.

[Dangerfield]

Hello. Now trying to work with Elxis.
I would like to use some php code in the content items.
I want to connect to another database, using forms to insert and edit data.. also using tables for retrieving and read data. Using other cms I had some problems with charset encoding.. so I'm hoping Elxis can solve.

Understand I have to use "wrapper" but I really don't know how to use it. Think I can work without WYSIWYG Editor.

Here some code to explain what I would like to do:

Reading from database for now..

Code: [Select]

include("config.php");

$query = mysql_query("SELECT DISTINCT name FROM table ORDER BY name");

while($row = mysql_fetch_array($query)) {

echo $row["name"];
}

Thanks in advance for any help

[Coursar]

Component wrapper used for display some site inside your site, but not for execute php-code. You have to create component for used another database and execute php-code.

Read http://www.elxis-downloads.com/documentation/e-books/component-development-guide.html

P.S. If you use TinyMCE (wysiwyg editor) or standart editor, when you save content item - you only put text from editor field to database.

[datahell]

Elxis can be connected to many databases simultaneously even of different type. For example you can open a connection to mysql, an other one to Oracle and a third one to a second mysql!

Do not use mysql native functions insde Elxis. Elxis has his own database handling functions located at includes/Core/database.php. Behind these function there is the ADOdb library.

Open connection to the 1st database:
$database1 = new database($host1, $user1, $password1, $db1, $dbprefix1, $dbtype1);

Open connection to the 2nd database:
$database2 = new database($host2, $user2, $password2, $db2, $dbprefix2, $dbtype2);

$dbtype1/2 can be mysql, postgresql, oci8, etc

Query the database:
$database->setQuery("SELECT x FROM #__YYY WHERE ....");

Various methods of loading results:
$rows = $database->loadObjectList();
$rows = $database->loadRowList();
$database->loadObject($row);
$row = $database->loadRow();
$result = $database->loadResult();

See includes/Core/database.php for more.

[horowo]

_________________________________________________________________

It depends on what is this "my php page" you are talking about. Elxis is a CMS and it has its own content system. You can copy the articles from your old site to Elxis content items. You can use the wrapper component to "wrap" your old page inside elxis. You can do many things.

___________________________________________________________________________________________


Tnx, its work!
I only began to study elxis, I hope that find here all answers with your help.
Thank!