php help

[Dipesh Khacharia]

Hello,

I am Dipesh from BG Broadband, India.. I have configured freetds with php
as well as apache.

I am also able to connect to the sql server 2000 server through the tsql
utility of the freetds. But when I am connecting with the php script by the
mssql_connect or sybase_connect function then the error log shows that the
connection is refused or the user is denied permission.

The same thing done manually works but via php doesn't

Can u help me

Thanx in advance

Regards,
Dipesh

[eddo32]

I created a sql database in phpMyAdmin. my pictures tables include fields of
pic & pId (blob field w/ mime type of image/jpeg: inline). Once I create the
recordset in Dreamweaver, how can I get the pictures to display, because right
now I'm only seeing the binary code???

Thanks for the help . . .

[David Powers]

eddo32 wrote:

> I created a sql database in phpMyAdmin. my pictures tables include fields of
> pic & pId (blob field w/ mime type of image/jpeg: inline). Once I create the
> recordset in Dreamweaver, how can I get the pictures to display, because right
> now I'm only seeing the binary code???

Storing your images in a database is *not* a good idea (as you've just
discovered). The most practical way to handle images and databases is to
store the images in a normal filesystem, and to store the location of
the image in the database. In other words, put your images in a folder
called "images" (or whatever), and store names like "mayflower.jpg" in
the database. You then just put the image name as the src attribute iin
an img tag in your pages. Much simpler.

If you do want to do things the hard way, though, there's an article
about it here:

[url]http://www.onlamp.com/pub/a/onlamp/2002/05/09/webdb2.html[/url]

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[eddo32]

David,

Thanks for the suggestion. After I do this, is there a way to realte the image path to display the actual image through a recordset??

[David Powers]

eddo32 wrote:

> David,
>
> Thanks for the suggestion. After I do this,

After you do what? If you want to put the images in a database, you'll
have to follow the instructions in the article. If you do things the
sensible way, you just store the filename in the database, and use the
Bindings panel to insert the filename into the src attribute of an <img>
tag. Let's say all your files are in a folder called images, your code
would look like this:

<img src="images/<?php echo $row['image']; ?>" alt="...

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[eddo32]

i made a couple of test pages for my website using php. when i preview them in
dreamweaver, they display fine, but when i try typing the url in or click on a
link to this page, it comes back with:

Warning: main(Connections/davis.php): failed to open stream: No such file or
directory in /home/davisfur/public_html/staff.php on line 1

Fatal error: main(): Failed opening required 'Connections/davis.php'
(include_path='.:/usr/lib/php:/usr/local/lib/php') in
/home/davisfur/public_html/staff.php on line 1

does anyone have any ideas?

thanks . . .

[eddo32]

never mind, i figured it out.