[PHP-DB] Re: Test

[JeRRy]

Date: Mon, 02 Aug 2004 10:40:31 +0400 
From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> 
To: [EMAIL PROTECTED] 
Subject: Test 

test



-


What was the test for? ;)

This list is actualy active!

J

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Connect to a ms access on a remote drive

[Paul Kain]

I am aware that theres a problem with connecting to an MS ACCESS DB on
a remote drive.

Anyoone how to do it correctly ?

Please? :(

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Remote mysql

[Dylan Barber]

Okay,  I am new to PHP but very good with many other scripting languages.  

I use 'mysql_connect("localhost" yada yada'

to connect to a database from the domain but I want to put this code on a few sites 
and have it access one database on the primary domain.  

How do I write that command?  I googled for about an hour this morning at 3:00am so I 
might have missed it but if someone can point me to where I might find an example 
command?

Thanks

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Remote mysql

[jeffrey_n_Dyke]

>Okay,  I am new to PHP but very good with many other scripting languages.


>I use 'mysql_connect("localhost" yada yada'

>to connect to a database from the domain but I want to put this code on a
few sites and have it access one database >on the primary domain.

>How do I write that command?  I googled for about an hour this morning at
3:00am so I might have missed it but if >someone can point me to where I
might find an example command?

Its same command, except you use your hosts address/DNS in lieu of
localhost
mysql_connect('123.132.123.123','yadda','yadda');
or
mysql_connect('mydomain.tld','yadda','yadda');

Of course you need to make sure that you can connect remotely to the MySQL
db, by assiging the appropriate permissions with GRANT, and ensure that any
firewall ports are opened, if applicable.

HTH
Jeff

>Thanks

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Enabling LDAP support

[Philip Thompson]

Hi again all.
Sorry to bug you again. But I thought I would throw this out here again 
and see if anyone has any input. It would be greatly appreciated.

I am running PHP on a Windows 2000 Server, and I need to enable LDAP 
support. So I have viewed the 
 page on how to get LDAP 
running. However, I have run into a snag.

I have copied the two required .dlls (libeay32 & ssleay32) into the 
system folder. I also put the configuration option 'ldap.max_links = 
-1' in my php.ini file. Is there anything else I need to add to the 
.ini file? I tried uncommenting the extension for php_ldap.dll, 
thinking that that might make it work... but it didn't.

Anyone have any suggestions b/c I'm stuck?
Thanks,
~Philip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test

[Mubashar-Hotmail]

I m new here (k)

Re: [PHP-DB] Connect to a ms access on a remote drive

[Robert Twitty]

Assuming your PHP script is located on a Win32 server, you will have to
run the web server under a user account that has permission to access the
remote drive.  You then have to reference the MS Access database by its
UNC path.

-- bob

On Mon, 2 Aug 2004, Paul Kain wrote:

> I am aware that theres a problem with connecting to an MS ACCESS DB on
> a remote drive.
>
> Anyoone how to do it correctly ?
>
> Please? :(
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sendmail

[Aaron Todd]

So far, I have been doing ok with PHP.  I feel that I have picked it up
rather easily.  But now I need some help.  I am trying to use the sendmail
functions to send data entered in a form to my email address.  Currently its
not working at all.  I am getting a

Fatal Error:  Call to undefined function: sendmail() in
/home/virtual/site341/fst/var/www/html/register.php on line 87

I havent found very much info on the sendmail function so I was shooting in
the dark with it.  I did read in the manual some stuff about seting it u in
the php.ini file that just went over my head.  Can anyone enlighten me on
this function.

Thanks,

Aaron

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connect to a ms access on a remote drive

[Karen Resplendo]

How about mapping a drive on the web server to the folder where the MS Access mdb is? 
Need to give the web user account permissions. Then all you have to do is reference 
the mapped drive in the path, I believe. Not sure of the security ramifications here, 
however.

Robert Twitty <[EMAIL PROTECTED]> wrote:Assuming your PHP script is located on a Win32 
server, you will have to
run the web server under a user account that has permission to access the
remote drive. You then have to reference the MS Access database by its
UNC path.

-- bob

On Mon, 2 Aug 2004, Paul Kain wrote:

> I am aware that theres a problem with connecting to an MS ACCESS DB on
> a remote drive.
>
> Anyoone how to do it correctly ?
>
> Please? :(
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [PHP-DB] sendmail

[Matt M.]

On Mon, 2 Aug 2004 14:31:49 -0400, Aaron Todd <[EMAIL PROTECTED]> wrote:
> So far, I have been doing ok with PHP.  I feel that I have picked it up
> rather easily.  But now I need some help.  I am trying to use the sendmail
> functions to send data entered in a form to my email address.  Currently its
> not working at all.  I am getting a

have you tried 

mail()

http://us4.php.net/manual/en/function.mail.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] sendmail

[Philip Thompson]

Aaron,
On Aug 2, 2004, at 1:31 PM, Aaron Todd wrote:
So far, I have been doing ok with PHP.  I feel that I have picked it up
rather easily.  But now I need some help.  I am trying to use the 
sendmail
functions to send data entered in a form to my email address.  
Currently its
not working at all.  I am getting a

Fatal Error:  Call to undefined function: sendmail() in
/home/virtual/site341/fst/var/www/html/register.php on line 87
You might want to consider using the 'mail()' function instead. It's 
given at:
http://us2.php.net/manual/en/ref.mail.php

I use it, and it works perfectly!
I havent found very much info on the sendmail function so I was 
shooting in
the dark with it.  I did read in the manual some stuff about seting it 
u in
the php.ini file that just went over my head.  Can anyone enlighten me 
on
this function.

Thanks,
Aaron
Hope that helps you!
~Philip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: sendmail

[Aaron Todd]

Thanks to you both...Matt M. and Philip Thompson.

Your suggestion of using the mail() function instead worked perfectly.

Thanks again,

Aaron


"Aaron Todd" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> So far, I have been doing ok with PHP.  I feel that I have picked it up
> rather easily.  But now I need some help.  I am trying to use the sendmail
> functions to send data entered in a form to my email address.  Currently
its
> not working at all.  I am getting a
>
> Fatal Error:  Call to undefined function: sendmail() in
> /home/virtual/site341/fst/var/www/html/register.php on line 87
>
> I havent found very much info on the sendmail function so I was shooting
in
> the dark with it.  I did read in the manual some stuff about seting it u
in
> the php.ini file that just went over my head.  Can anyone enlighten me on
> this function.
>
> Thanks,
>
> Aaron

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] LAMP

[Gavin Amm]

I'd really like to find a Linux distro that is a LAMP system right out
of the box.
(Linux, Apache, MySQL, PHP)
Are there any out there?

Cheers,
Gav

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LAMP

[jeffrey_n_Dyke]

> I'd really like to find a Linux distro that is a LAMP system right out
> of the box.
> (Linux, Apache, MySQL, PHP)
> Are there any out there?

You should be able to activate all with Fedora and SuSe, from the disks.
You may still have to build PHP(on FC?), but IMO you'll want to do that
anyway based on what you wish to use it for.  If you're just looking for
the basics, get it from rpm.  from rpmfind.net

HTH
Jeff


> Cheers,
> Gav

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LAMP

[Steve Morgan]

Almost all major Linux distros. come with Apache and PHP. I know that 
redhat 9 even had php/mysql. Fedora core has it too, however none of 
them have php 5 that i know of.

Steve
Gavin Amm wrote:
I'd really like to find a Linux distro that is a LAMP system right out
of the box.
(Linux, Apache, MySQL, PHP)
Are there any out there?
Cheers,
Gav
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] oop?

[Steve Morgan]

For awhile i didn't touch OOP PHP, classes etc... because people talked 
about how slow it was, but now i'm working on a site that has to do 
things the exact same on page to page, but i think that going with 
classes and funcitons might be better, because we have to carry a lot of 
data from function to function. Is the speed/performance that much of an 
issue? the site i'm doing is www.dinowax.com  it gets quite a few hits a 
day (100k-200k). i know a lot of speed things that i've seen are like... 
1.4 seconds of php compared to a class doing it in like 5... but all my 
current scripts, which use classes all go in under 1 second, and thats 
when the server is under strain. Any explanation would be appreciated.
Steve

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Eval a file, and it gives parse error because it uses a preg_match statement with \$

[Josh Acecool M]

And well, this is kind of annoying aswell..

A variable isnt getting passed to the files it Evals..

Basically, its the new template engine im coding, its a class, its about 8x
faster than the old method of buffering.

In the class I evaluate the template, but variables from files included by
the evaluated files do not work, also variables from the main engine dont
pass to the file.

Globals are obviously off, and will stay off.

eval("?>" . $this -> The_Template_Sys . "http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Enabling LDAP support

[Jason Wong]

On Monday 02 August 2004 21:27, Philip Thompson wrote:

> Sorry to bug you again. But I thought I would throw this out here again
> and see if anyone has any input. It would be greatly appreciated.

Yes, second time you post about this problem, yet ...

> I am running PHP on a Windows 2000 Server, and I need to enable LDAP
> support. So I have viewed the
>  page on how to get LDAP
> running. However, I have run into a snag.

... you're still keeping it a secret as to what your snag is.

> I have copied the two required .dlls (libeay32 & ssleay32) into the
> system folder. I also put the configuration option 'ldap.max_links =
> -1' in my php.ini file. Is there anything else I need to add to the
> .ini file? I tried uncommenting the extension for php_ldap.dll,
> thinking that that might make it work... but it didn't.

So HOW didn't it work? 

> Anyone have any suggestions b/c I'm stuck?

1) post some *concise* code that illustrates your problem

2) state exactly what and how it is not working

3) post any error messages that you get (having first made sure that FULL 
error reporting is enabled).

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
"Hello again, Peabody here..."
-- Mister Peabody
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Eval a file, and it gives parse error because it uses a preg_match statement with \$

[John Holmes]

Josh Acecool M wrote:
eval("?>" . $this -> The_Template_Sys . "Can you give an example of what $this->The_Template_Sys returns that is 
causing the parse error?

--
John Holmes
php|architect - The magazine for PHP professionals - http://www.phparch.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problem with this query?

[Dylan Barber]

Okay maybe its late or something but this should work, however I get this

#1064 - You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SELECT tblVideos.PerformerID

FROM tblVideos

WHERE 1  =1 AND tbl



Anybody got a good clue whats wrong with this SQL?

SELECT tblPerformers.ID, tblPerformers.StageName, tblPics.PicName
FROM tblPerformers, tblPics
WHERE 1 =1 AND tblPerformers.ID = tblPics.PerformerID AND tblPics.Active =
'yes' AND tblPics.Type = 'name' AND tblPerformers.ID
IN ( SELECT UNIQUE tblVideos.PerformerID
FROM tblVideos
WHERE 1 =1 AND tblVideos.Active = 'yes')
ORDER BY tblPics.ID DESC 
LIMIT 0 , 6 

 
Dylan Barber

 
 www.codegalaxy.com - A webservices company 

DotNetNuke Portal  Specialists

Simple Affordable & Reliable - Web Design, and Programming 

 

Re: [PHP-DB] Problem with this query?

[John Holmes]

Dylan Barber wrote:
Okay maybe its late or something but this should work, however I get this
#1064 - You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SELECT tblVideos.PerformerID
FROM tblVideos
WHERE 1  =1 AND tbl

Anybody got a good clue whats wrong with this SQL?
SELECT tblPerformers.ID, tblPerformers.StageName, tblPics.PicName
FROM tblPerformers, tblPics
WHERE 1 =1 AND tblPerformers.ID = tblPics.PerformerID AND tblPics.Active =
'yes' AND tblPics.Type = 'name' AND tblPerformers.ID
IN ( SELECT UNIQUE tblVideos.PerformerID
FROM tblVideos
WHERE 1 =1 AND tblVideos.Active = 'yes')
ORDER BY tblPics.ID DESC 
LIMIT 0 , 6 
What version of MySQL are you using? It looks like you're using a 
version that doesn't support sub selects.

--
John Holmes
php|architect - The magazine for PHP professionals - http://www.phparch.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Problem with this query?

[Dylan Barber]

2.5.4 - the docs imply it does

Dylan Barber

www.codegalaxy.com - A webservices company 

DotNetNuke Portal  Specialists

Simple Affordable & Reliable - Web Design, and Programming 

 

> -Original Message-
> From: John Holmes [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 03, 2004 12:19 AM
> To: Dylan Barber
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Problem with this query?
> 
> Dylan Barber wrote:
> > Okay maybe its late or something but this should work, 
> however I get 
> > this
> > 
> > #1064 - You have an error in your SQL syntax.  Check the 
> manual that 
> > corresponds to your MySQL server version for the right 
> syntax to use 
> > near 'SELECT tblVideos.PerformerID
> > 
> > FROM tblVideos
> > 
> > WHERE 1  =1 AND tbl
> > 
> > 
> > 
> > Anybody got a good clue whats wrong with this SQL?
> > 
> > SELECT tblPerformers.ID, tblPerformers.StageName, 
> tblPics.PicName FROM 
> > tblPerformers, tblPics WHERE 1 =1 AND tblPerformers.ID = 
> > tblPics.PerformerID AND tblPics.Active = 'yes' AND tblPics.Type = 
> > 'name' AND tblPerformers.ID IN ( SELECT UNIQUE 
> tblVideos.PerformerID 
> > FROM tblVideos WHERE 1 =1 AND tblVideos.Active = 'yes') ORDER BY 
> > tblPics.ID DESC LIMIT 0 , 6
> 
> What version of MySQL are you using? It looks like you're 
> using a version that doesn't support sub selects.
> 
> -- 
> 
> John Holmes
> 
> php|architect - The magazine for PHP professionals - 
> php|http://www.phparch.com
> 
> --
> PHP Database Mailing List (http://www.php.net/) To 
> unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Problem with this query?

[Dylan Barber]

Sorry wrong line

4.0.16

Dylan Barber

www.codegalaxy.com - A webservices company 

DotNetNuke Portal  Specialists

Simple Affordable & Reliable - Web Design, and Programming 

 

> -Original Message-
> From: John Holmes [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 03, 2004 12:19 AM
> To: Dylan Barber
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Problem with this query?
> 
> Dylan Barber wrote:
> > Okay maybe its late or something but this should work, 
> however I get 
> > this
> > 
> > #1064 - You have an error in your SQL syntax.  Check the 
> manual that 
> > corresponds to your MySQL server version for the right 
> syntax to use 
> > near 'SELECT tblVideos.PerformerID
> > 
> > FROM tblVideos
> > 
> > WHERE 1  =1 AND tbl
> > 
> > 
> > 
> > Anybody got a good clue whats wrong with this SQL?
> > 
> > SELECT tblPerformers.ID, tblPerformers.StageName, 
> tblPics.PicName FROM 
> > tblPerformers, tblPics WHERE 1 =1 AND tblPerformers.ID = 
> > tblPics.PerformerID AND tblPics.Active = 'yes' AND tblPics.Type = 
> > 'name' AND tblPerformers.ID IN ( SELECT UNIQUE 
> tblVideos.PerformerID 
> > FROM tblVideos WHERE 1 =1 AND tblVideos.Active = 'yes') ORDER BY 
> > tblPics.ID DESC LIMIT 0 , 6
> 
> What version of MySQL are you using? It looks like you're 
> using a version that doesn't support sub selects.
> 
> -- 
> 
> John Holmes
> 
> php|architect - The magazine for PHP professionals - 
> php|http://www.phparch.com
> 
> --
> PHP Database Mailing List (http://www.php.net/) To 
> unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with this query?

[John Holmes]

Dylan Barber wrote:
4.0.16
Quote: Starting with MySQL 4.1, all subquery forms and operations that 
the SQL standard requires are supported, as well as a few features that 
are MySQL-specific.

http://dev.mysql.com/doc/mysql/en/Subqueries.html
--
John Holmes
php|architect - The magazine for PHP professionals - http://www.phparch.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: LAMP

[Lester Caine]

Gavin Amm wrote:
I'd really like to find a Linux distro that is a LAMP system right out
of the box.
(Linux, Apache, MySQL, PHP)
Are there any out there?
Thankfully not ;)
I want LAFP but LAPP seems still to be more popular on Linux.
WHY does everybody run lemming like after MySQL. It STILL has to catch 
up with the better FREE database engines ;)

--
Lester Caine
-
L.S.Caine Electronic Services
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LAMP

[Steve Davies]

Hi Gav
SuSE will work outta the box. Just make sure you've selected the 
components and Yast will configure more or less everything to work 
together before installing

cheers
Steve
Gavin Amm wrote:
I'd really like to find a Linux distro that is a LAMP system right out
of the box.
(Linux, Apache, MySQL, PHP)
Are there any out there?
Cheers,
Gav
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: LAMP

[Jason Wong]

On Tuesday 03 August 2004 14:14, Lester Caine wrote:

> I want LAFP but LAPP seems still to be more popular on Linux.
>
> WHY does everybody run lemming like after MySQL. It STILL has to catch
> up with the better FREE database engines ;)

It depends on your needs. For simple storage of data (involving few 
relationships) then MySQL is more than sufficient and a tried and tested 
solution. This probably covers the vast majority of the data storage needs of 
web apps. No sense in going for a DB with features you're never ever going to 
use and is probably slower to boot.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
Experience is what you get when you didn't get what you wanted.
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php