Joomla+Mysql+php

[AcidicOne]

So i have a database I've been compiling for a game i currently play. I also have a Joomla based site composed for the group am currently with. I've been trying numerous add ons etc to make php function inside of joomla itself along with html. Has anyone done anything similar ? Am just basically just looking for a way to add pages to the site that allow me to display information from the data base for the time being

[pavansss91]

joomla has a plugin which enables u to write php code in between some default plugin symbol ( like ($) or something )

actually the problem is that i don't remember it
But i am sure u can have a plugin installed on joomla which allow u to write php code in the content box

[AcidicOne]

I did some more searching after the post, And yes there are plenty of components and modules that allow you to use php code in either. My problem was finding one that would allow me to actually run commands to say a query to the mysql server to use the php/html to display the contents of a db from mysql.

I have found such add in i believe (it will run a simple current time script)
http://www.kksou.com/php-gtk2/Joomla/DirectPHP-plugin.php

[karnedge]

http://docs.joomla.org/Tutorial:Creating_a_Hello_World_Module_for_Joomla_1.5
http://developer.joomla.org/tutorials/184-how-to-create-a-joomla-plugin.html

I would honestly make your own plugin or module, that will allow you to use Joomla's Database abstraction and you can display content with a module and place it dynamically without hardcoding anything. Plus, you'll be able to install/uninstall it at anytime with no hassles.

[AcidicOne]

yeah belive me i debated that option, but given my lack of php skills or coding skills in general I passed on that option.Especially considering all i need to do is display db info in a html table within say a article,possibly with options for different sorting methods if possible.

[karnedge]

yeah belive me i debated that option, but given my lack of php skills or coding skills in general I passed on that option.Especially considering all i need to do is display db info in a html table within say a article,possibly with options for different sorting methods if possible.

Eh, no offense... but it doesn't really have much to do with BBG's even in general. This is kinda a generic question that's more focused on Joomla usage. I would go to their forums and ask if anyone is working on or if there already is a module that displays a table of sortable information from a database.

Otherwise grab a module that allows you to parse PHP code:

Code: [Select]

$sort = isset($_GET['sort']) ? $_GET['sort'] : 'field1';
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$rows = mysql_query("SELECT * FROM tablename ORDER BY $sort ASC");
echo '<table>';
echo '<tr><th><a href="/path/to/module.php?sort=field1">Field1</a></th><th><a href="/path/to/module.php?sort=field2">Field2</a></th></tr>';
while($row = mysql_fetch_assoc($rows)){
echo '<tr><td>'.$row['field1'].'</td><td>'.$row['field2'].'</td></tr>';
}
echo '</table>';
mysql_select_db($joomlaDatabaseName); // To go back to original database for joomla to continue

This should help somewhat... but I'm willing to bet there's a Joomla module that does this already.

[AcidicOne]

Oh not arguing the bbg thing at all,just i know this community has helped me tons with my game coding help, and figured i would post here as well seeing this is just the code help section but yes i found a plugin for it, now i just get the fun job of including html in my php code >.<

Not to mention now that i figured this out, i may just attempt to include my bg in my joomla site, make them handle the security/login code so i can concentrate more on the game itself.

[Crazy-T]

Code: [Select]

$sort = isset($_GET['sort']) ? $_GET['sort'] : 'field1';
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
$rows = mysql_query("SELECT * FROM tablename ORDER BY $sort ASC");
echo '<table>';
echo '<tr><th><a href="/path/to/module.php?sort=field1">Field1</a></th><th><a href="/path/to/module.php?sort=field2">Field2</a></th></tr>';
while($row = mysql_fetch_assoc($rows)){
echo '<tr><td>'.$row['field1'].'</td><td>'.$row['field2'].'</td></tr>';
}
echo '</table>';
mysql_select_db($joomlaDatabaseName); // To go back to original database for joomla to continueI made a userlist like that but bit different, i was able to exploit it so i used a array() and in_array(), to stop it. How i exploited it was like changing the $_GET['sort'] from the Url..

[karnedge]

I made a userlist like that but bit different, i was able to exploit it so i used a array() and in_array(), to stop it. How i exploited it was like changing the $_GET['sort'] from the Url..

This is just for demonstration. It's very easy to exploit this because of the open $_GET variable and how I don't escape it either. Just to point him in the right direction.