Using PHAkT v1.0: Connecting to a MySQL Database using JDBC Support Product Page
This topic was archived
Windows Paths, How to display recordset, etc.
Asked 13 Aug 2001 03:14:28
1
has this question
13 Aug 2001 03:14:28 Starman Seven posted:
My query tests fine but the code is written with funky (e.g. ./file:///C|/Program%20Files/Apache%) file paths, and when executed gives this error: Fatal error: Failed opening required './file:///C|/Program%20Files/Apache%20Group/Apache/htdocs/UD4_PHP/adodb/adodb.inc.php' (include_path='.;c:\php\includes;C:\Program Files\Apache Group\Apache\htdocs\UD4_PHP\adodb') in c:\program files\apache group\apache\htdocs\ud4_php\untitled-1.php on line 7
As you can see I have the adodb path in my php.ini (does this matter?). When I change the funky path to normal (e.g. C:/foo/bar moo/etc), the code executes w/o error but the recordset isn't displayed. I'm surely missing something (like display code) but what is it? What of the file path issue? Below is the code for my recordset that returns zilch or an error depending on how the require path is written .... Thanks, Bill
<?php
// Copyright (c) Interakt Online 2001
// www.interakt.ro/
require("./file:///C|/Program%20Files/Apache%20Group/Apache/htdocs/UD4_PHP/adodb/adodb.inc.php"
;require("./file:///C|/Program%20Files/Apache%20Group/Apache/htdocs/UD4_PHP/Connections/connUD4_PHP.php"
;?>
<?php
$Recordset1=$connUD4_PHP->Execute("SELECT artist, title, year, label, tracks, review FROM cds"
or DIE($connUD4_PHP->ErrorMsg());$Recordset1_numRows=0;
$Recordset1__totalRows=$Recordset1->RecordCount();
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
</body>
</html>
<?php
$Recordset1->Close();
?>
I saw the message about adding a DB behavior before an initial saving of the file causing the weird file paths. Saving the file first, re-opening then adding db recordsets puts nicer ./ releative paths in, but preview in browser with TMP5b891hzixw.php type files still error out. However, the real file does work - even if displaying no data, again my code probably doesn't display but only querys? I tried show region if not empty but still no dice!
Edited by - starman7 on 08/13/2001 04:39:05
Replies
Replied 13 Aug 2001 10:52:32
13 Aug 2001 10:52:32 Tim Green replied:
Bill,
This isn't really the right forum for your problem, as it isn't really anything to do with my behaviour.
There is a dedicated PHP Forum in the TalkZones for just this kind of thing.
However, just as a pointer, if you put the path to ADODB in your PHP.ini then you will break all include files in your code, as this path will be prepended to ALL of the included statements given on the page, therefore breaking them.
I suspect this is why your page refuses to work.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
This isn't really the right forum for your problem, as it isn't really anything to do with my behaviour.
There is a dedicated PHP Forum in the TalkZones for just this kind of thing.
However, just as a pointer, if you put the path to ADODB in your PHP.ini then you will break all include files in your code, as this path will be prepended to ALL of the included statements given on the page, therefore breaking them.
I suspect this is why your page refuses to work.
Tim Green
Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>
Replied 13 Aug 2001 13:55:37
13 Aug 2001 13:55:37 Starman Seven replied:
Thanks, What is the proper forum? And, what should be in the include path in php.ini? I removed adodb but am still getting a similar error.