DB Connection problem in module

Private Joined: May 01, 2003 Posts: 42

Hey, I´m having a problem. I´m constructing a poll block, but first I´m trying to make it as a module. I installed a poll script in my webspace, and it works perfectly

You can see it right here.

This script has more that one page
-Poll.php which has only the following code:

Code:

<?php

require '/home/oc-zone/public_html/modules/Poll/booth.php';

newest_booth(1);

?>

The booth.php, where everything is made, and a config.php, which as all the db connection info (it is in require_once at booth.php).

Common.php, which as more code for poll generation.

So, I changed this page to a module, so that I could see header, footer, menus, etc, and coded it this way:

Code:

<?php
if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {

die ("You can't access this file directly...");

}

require_once("mainfile.php");

$module_name = basename(dirname(__FILE__));

include("header.php");

OpenTable();

require '/home/oc-zone/public_html/modules/Poll/booth.php';

newest_booth(1);

CloseTable();

include("footer.php");

?>

... keeping all the directories as they were, and I´m given this error:

Quote:

Warning: mysql_connect(): Access denied for user: 'nobody@localhost' (Using password: NO) in /home/oc-zone/public_html/modules/Poll/common.php on line 203
Unable to connect to the database!

Here goes the function with error:

Code:

So, anybody could help me solve the problem? I can´t understand whi this happens, since it works perfetcly as a non-module.

Thankx for any help

Corporal Joined: Aug 20, 2003 Posts: 61

If this is a module why are you writing your own db connection function when nuke has already made a connection? Just use the existing one. If you are inside of a function just make sure to "global $db" inside that function and use the sql abstraction layer already written for you.

--Hadron

Private Joined: May 01, 2003 Posts: 42

It is because I don´t know how to do that. Here´s an example of a function that demands a connection:

Code:

So, first of all I would have to delete de symp_connect ();. I didi it, and got this error:

Quote:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/oc-zone/public_html/modules/Poll/common.php on line 262

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/oc-zone/public_html/modules/Poll/common.php on line 263

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/oc-zone/public_html/modules/Poll/common.php on line 269

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/oc-zone/public_html/modules/Poll/common.php on line 271

Thanks for any help.

Corporal Joined: Aug 20, 2003 Posts: 61

Quote:

So, I changed this page to a module, so that I could see header, footer, menus, etc, and coded it this way:

Rather than "require" your code, why not just copy paste it into that section? That would be my suggestion. Regardless, you can still do the following:

Code:

function symp_poll_fetch($pid) {
global $db, ...other variables here...
if($pid == -1) {
$q1 = "SELECT pid FROM sympoll_list....";
$r1 = $db -> sql_query($q1);
.....
list($pid) = $db -> sql_fetchrow($q1);
....
$r2 = $db -> sql_query($q2);
$a2 = $db -> sql_fetchrowset($r2);
$pid = $a2['pid];
....
}

See how I "globaled" the $db resource connection? Now just use that and nuke's sql layer:

Code:

$result = $db -> sql_query($query);
$numrows = $db -> sql_numrows($result);
$affected = $db -> sql_affectedrows($result);
$numfields = $db -> sql_numfields($result);
list($var) = $db -> sql_fetchrow($result);
$var_array = $db -> sql_fetchrowset($result);

--Hadron

Private Joined: May 01, 2003 Posts: 42

Sorry, but I didn´t understand.

Meanwhile, I fixed some problems in mainfile.php, that were the cause of the failure in mysql connection, and tried again to fix the module, and now the module works perfectly. However, I wan´t to use it as a block, not a module, and I thought that it should work, as it must be the same. However, when I tried to amke it work as a block, I got the mysql problem. Changed the variables in common.php, that were the cause of the failure in connection (instead of requiring config.php, it gets the variables directly), and now I get no error, and says that I have an empty block.

How should I put this?

Code:

<?php

if (eregi("block-Poll.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}

require '/home/oc-zone/public_html/blocks/booth.php';

newest_booth(1)

?>

Thank you for your replies Hadron. Wink

Private Joined: May 01, 2003 Posts: 42

Just found out one thing. The problem I thought that was from mainfile.php, was not. The problem is that poll, that closes the mysql connection at the end. Because of that, I was receiving mysql errors. The only way is how you told me.... using the same mysql connection. Could you please explain it better to me? Or if there is a tutorial on the web, could you please tell me where?

Thankx for the help Smile

Corporal Joined: Aug 20, 2003 Posts: 61

Do you "echo" your html content out or do you place it in a $content variable? It should be $content for a block.

Other than that, I'd have to see booth.php to do much else.

--Hadron

Private Joined: May 01, 2003 Posts: 42

For blocks, I use $content varuabel, and I tried to put that inside a $content ".... "; and no go Sad

It would echo the newest_booth (1)