Using PHP Recordsets with Dreamweaver

Dreamweaver recordsets issue

[PepePH]

Hi everybody,

I just ventured in the world of dynamic websites with MySQL and PHP, this time I tried using the Dreamweaver's recorsets, but although everything seem to be working fine and I managed to make the connection to the database without problems, when I upload the page to the server and try to load it on the browser nothing appears! just a blank page as if it was empty.

I tried many things but at this point I am feeling hopeless as nothing seems to work. Does anyone is kind enough to give me a hand with this?

Thanks

[volatilegx]

Welcome to WebmasterWorld, PepePH :)

Have you viewed the source of the page? Is the PHP code being executed at all?

[PepePH]

Hi Volatilegx,

Thanks for your reply, I've checked the source page and aparently the PHP code looks all right, however, when the page is on the remote server I'm unable to see anything when opening the source view... I am attaching here part of the header where the PHP code can be seen:

<?php virtual('/Connections/databas.php');?>
<?php
$colname_contenttab = "-1";
if (isset($_GET['ID'])) {
$colname_contenttab = (get_magic_quotes_gpc())? $_GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database_dabas, $databas);
$query_contenttab = sprintf("SELECT * FROM content WHERE ID = %s", $colname_contenttab);
$contenttab = mysql_query($query_contenttab, $databas) or die(mysql_error());
$row_contenttab = mysql_fetch_assoc($contenttab);
$totalRows_contenttab = mysql_num_rows($contenttab);
?>

Must be mentioned that sometimes the server shows the following message, but curiously is not shown everytime I load the page...

Fatal error: Call to undefined function virtual() in c:\http\sites\..\untitled-5.php on line 1

[edited by: PepePH at 6:55 am (utc) on Aug. 22, 2006]

[brealmz]

you need to change virtual() to include_once() and dont forget to upload the included files.

[PepePH]

Thanks Breamzl

I tried, and unfortunately I only see a large list of warnings...

[PepePH]

this are the messages, should you whish to know;

Warning: include_once() [function.include-once]: open_basedir restriction in effect. File(c:\/Connections/regalaturism.php) is not within the allowed path(s): (c:\http\sites;c:\PHP_5.1.4\uploadtemp;c:\PHP_5.1.4\sessiondata;\\192.168.1.153\administe;./libraries;./lang;./config.header.inc.php;./config.footer.inc.php;./themes;) in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 1

Warning: include_once(/Connections/regalaturism.php) [function.include-once]: failed to open stream: Operation not permitted in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 1

Warning: include_once() [function.include]: Failed opening '/Connections/regalaturism.php' for inclusion (include_path='.;C:\php5\pear') in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 1

Notice: Undefined variable: database_regalaturism in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 7

Notice: Undefined variable: regalaturism in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 7

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 7

Notice: Undefined variable: regalaturism in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 9

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\http\sites\regalaturismorural.com\script\untitled-5.php on line 9