XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / How to access a xoopsDatabase
Register
1
ibetino
How to access a xoopsDatabase

  • 2006/11/10 8:30

  • ibetino

  • Just popping in

  • Posts: 1

  • Since: 2006/11/10


Hi,

I want to do a HTML file with a single searchform that access a new table of my XOOPS database, but I don´t know how to do it:

INDEX.HTML
<FORM ACTION="SEARCH.PHP" METHOD="POST">
Input a code: <INPUT NAME="code"><INPUT TYPE="submit">
FORM>


SEARCH.PHP
include("CONECTION.PHP");
include("FUNC.PHP");

$sql = "SELECT * FROM xoops_tablecodes WHERE code =  '$code'";

If ($res=send_sql($db,$sql))  {
   echo "OK. 
 Results: 
";
}
tab_out($res);


CONECTION.PHP
$link=mysql_connect("localhost","user","passw");
$db ="Database name";


FUNC.PHP
function send_sql($db, $sql) 
    {
         if (! $res=mysql_db_query($db, $sql))
    {
           echo mysql_error();
           exit;
    }
           return $res;
    }


function tab_out($result) 
    {
        $cant=mysql_num_fields($result);
        $ancho=100/$cant."%";
        echo "";
        echo "";
        for ($i=0;$i<$cant;$i++)
    {
    echo "$ancho'> ";
    echo mysql_field_name($result,$i);
    echo " ";
    }
    echo "";
    echo "";
    
    $num = mysql_num_rows($result);
    for ($j = 0; $j < $num; $j++) 
    
    {
        $row = mysql_fetch_array($result);
        echo "";
        echo "";
        for ($k=0;$k<$cant;$k++)
    {
        $fn=mysql_field_name($result,$k);
        echo " $ancho'>  $row[$fn]   " ;
    }
        echo "";
        echo "";
    }
        echo "";
    }



I need to do this in XOOPS and using de xoopsdatabase!!!!

Thanks and sorry by my english!!!
2
hervet
Re: How to access a xoopsDatabase

  • 2006/11/22 12:44

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


Hello,

the minimum, in your php script, is to write this :
include_once '../../mainfile.php';

?>

use the search of this site and try to find the "empty module".

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

187 user(s) are online (76 user(s) are browsing Support Forums)

Members: 0

Guests: 187

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits