2006/11/10 8:30
ibetino
Just popping in
Posts: 1
Since: 2006/11/10
<FORM ACTION="SEARCH.PHP" METHOD="POST"> Input a code: <INPUT NAME="code"><INPUT TYPE="submit"> FORM>
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);
$link=mysql_connect("localhost","user","passw"); $db ="Database name";
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 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 Username Password Remember me Reset Search Advanced Search Recent Posts Help Needed with Custom Module Development in XOOPS Today 6:25 remel24354 Re: sbadmin5 - Bootstrap 5 Theme 10/5 15:37 Mage Re: sbadmin5 - Bootstrap 5 Theme 9/29 9:11 goffy Re: sbadmin5 - Bootstrap 5 Theme 9/29 6:59 Mamba Re: sbadmin5 - Bootstrap 5 Theme 9/27 8:00 goffy Re: sbadmin5 - Bootstrap 5 Theme 9/26 0:57 Mamba sbadmin5 - Bootstrap 5 Theme 9/25 18:15 goffy Re: XoopsFaq for 2.5.10 9/18 18:21 Mamba XoopsFaq for 2.5.10 9/16 16:22 Skype-Fr Re: activate block by default 9/3 16:09 goffy Who's Online 317 user(s) are online (95 user(s) are browsing Support Forums) Members: 0 Guests: 317 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 Latest GitHub Commits {{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }} {{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}
2006/11/22 12:44
hervet
Friend of XOOPS
Posts: 2267
Since: 2003/11/4
include_once '../../mainfile.php'; ?>
Advanced Search
317 user(s) are online (95 user(s) are browsing Support Forums)
Members: 0
Guests: 317