Re: [PHP-DB] Access a database on another domain

[Bastien Koert]

On Sun, Aug 2, 2009 at 10:15 PM, Chris wrote:
> Neil Jackson wrote:
>>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Hi,
>> I host a number of running clubs websites. They are all hosted on
>> different domains on a hosting service.
>>
>> They all share a common database table of fixtures. At present I have
>> copied the database table to each domain but this time consuming.
>>
>> I want to have a central database with the individual clubs accessing
>> the table from their domains
>>
>> At present I do it like this
>>        $result = @mysql_pconnect("localhost", "username", "password");
>>        $query = "SELECT * FROM fixtures ORDER BY event_name";
>
> I haven't seen a question here, but I assume you don't know where to start.
>
> Enable remote access to mysql:
>
> http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
>
> Then connect to it:
>
> mysql_connect('server.name', 'username', 'password');
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

You should be able to access this by creating a shared mysql account
and setting the different domains to use it.

-- 

Bastien

Cat, the other other white meat

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

Re: [PHP-DB] Access a database on another domain

[Chris]

Neil Jackson wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,
I host a number of running clubs websites. They are all hosted on
different domains on a hosting service.

They all share a common database table of fixtures. At present I have
copied the database table to each domain but this time consuming.

I want to have a central database with the individual clubs accessing
the table from their domains

At present I do it like this
$result = @mysql_pconnect("localhost", "username", "password");
$query = "SELECT * FROM fixtures ORDER BY event_name";


I haven't seen a question here, but I assume you don't know where to start.

Enable remote access to mysql:

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Then connect to it:

mysql_connect('server.name', 'username', 'password');

--
Postgresql & php tutorials
http://www.designmagick.com/


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

[PHP-DB] Access a database on another domain

[Neil Jackson]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,
I host a number of running clubs websites. They are all hosted on
different domains on a hosting service.

They all share a common database table of fixtures. At present I have
copied the database table to each domain but this time consuming.

I want to have a central database with the individual clubs accessing
the table from their domains

At present I do it like this
$result = @mysql_pconnect("localhost", "username", "password");
$query = "SELECT * FROM fixtures ORDER BY event_name";

Two of the domains are www.hillcrestvillagers.co.za and www.pmb42.co.za.

Thanks for the help
Neil
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iEYEARECAAYFAkp2RfoACgkQGgk1S8edB3I48ACeODQFinlcJIFuaxFItREabRxt
zGAAn1Vde3l6f6eVZtnv/xLQRS/YOYi4
=refm
-END PGP SIGNATURE-

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

[PHP-DB] Access another server aspx page

[Lasitha Alawatta]

 Hi All,

 

 

I need to access .aspx page using .php page. It's like this.

 

01) I have a login.aspx & home.aspx pages in different server (IIS6,
already hosted at different location: www.abc.com/login.aspx  ). 

02) I have the username & password for login to the above
application (home.aspx)

03)I need to go to home.aspx page, bypassing login.aspx page. (using
php page: http://localhost/bypass.php )

 

*  Is there is a possibility to control www.abc.com/login.aspx
page events.

Ex: login.aspx page have 2 text boxes & login button.

I mean is it possible to handle login.aspx's login button's click event?

 

*  Is it possible to do my requirement using php curl function?

*  Or do you all have any suggestions?

 

Thanking you,

Best regards,

Lasitha

 

 

 

DOTW DISCLAIMER:

This e-mail and any attachments are strictly confidential and intended for the 
addressee only. If you are not the named addressee you must not disclose, copy 
or take
any action in reliance of this transmission and you should notify us as soon as 
possible. If you have received it in error, please contact the message sender 
immediately.
This e-mail and any attachments are believed to be free from viruses but it is 
your responsibility to carry out all necessary virus checks and DOTW accepts no 
liability
in connection therewith. 

This e-mail and all other electronic (including voice) communications from the 
sender's company are for informational purposes only.  No such communication is 
intended
by the sender to constitute either an electronic record or an electronic 
signature or to constitute any agreement by the sender to conduct a transaction 
by electronic means.
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Access denied for user...sometimes???

[David Robley]

Peter Beckman wrote:

> On Wed, 21 Feb 2007, James Garfield wrote:
> 
>> I've got 5.0.27-standard installed on an Intel Mac, using the
>> preinstalled version of Apache and my own installation of PHP 4.4.4. I
>> use this machine for development work and don't make it available to
>> anyone else. I've got an instance of a PHP application running, and it
>> works...but not all of the time!!! I created the user that accesses my
>> MySQL via the following commands;
>>
>> use [web_db_name];
>> grant select, insert, update, delete on *.* to '[new_user]'@'%'
>> identified by '[new_password]';
>>
>> I'm able to do everything expected from the command line mysql tool, but
>> on the PHP side it fails more than half of the time:
>>
>> Warning: mysql_connect() [function.mysql-connect]: Access denied for user
>> '[new_user]'@'[my_current_dhcp_ip]' (using password: YES) in
>> /[path]/[to]/[page]/[on]/[server]/index.php on line 66
>>
>> This leaves the question: since MySQL is behaving normally otherwise, I'm
>> using a host of '%' and my IP isn't changing, does anybody know what the
>> problem is with PHP???
>>
>> TIA,
>> James
> 
>   flush privileges

And, as it's only you using mysql from the current machine, you don't need a
network connection to your own machine - use localhost instead of your
dynamic(?) IP, and set skip-networking (or whatever it is called) to on in
your my.cnf file.




Cheers
-- 
David Robley

Useless Invention: Checkered paint.
Today is Pungenday, the 53rd day of Chaos in the YOLD 3173. 

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

Re: [PHP-DB] Access denied for user...sometimes???

[Peter Beckman]

On Wed, 21 Feb 2007, James Garfield wrote:

I've got 5.0.27-standard installed on an Intel Mac, using the preinstalled 
version of Apache and my own installation of PHP 4.4.4. I use this machine 
for development work and don't make it available to anyone else. I've got an 
instance of a PHP application running, and it works...but not all of the 
time!!! I created the user that accesses my MySQL via the following commands;


use [web_db_name];
grant select, insert, update, delete on *.* to '[new_user]'@'%' identified by 
'[new_password]';


I'm able to do everything expected from the command line mysql tool, but on 
the PHP side it fails more than half of the time:


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 
'[new_user]'@'[my_current_dhcp_ip]' (using password: YES) in 
/[path]/[to]/[page]/[on]/[server]/index.php on line 66


This leaves the question: since MySQL is behaving normally otherwise, I'm 
using a host of '%' and my IP isn't changing, does anybody know what the 
problem is with PHP???


TIA,
James


 flush privileges

---
Peter Beckman  Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---

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

[PHP-DB] Access denied for user...sometimes???

[James Garfield]

I've got 5.0.27-standard installed on an Intel Mac, using the 
preinstalled version of Apache and my own installation of PHP 4.4.4. I 
use this machine for development work and don't make it available to 
anyone else. I've got an instance of a PHP application running, and it 
works...but not all of the time!!! I created the user that accesses my 
MySQL via the following commands;


use [web_db_name];
grant select, insert, update, delete on *.* to '[new_user]'@'%' 
identified by '[new_password]';


I'm able to do everything expected from the command line mysql tool, but 
on the PHP side it fails more than half of the time:


Warning: mysql_connect() [function.mysql-connect]: Access denied for 
user '[new_user]'@'[my_current_dhcp_ip]' (using password: YES) in 
/[path]/[to]/[page]/[on]/[server]/index.php on line 66


This leaves the question: since MySQL is behaving normally otherwise, 
I'm using a host of '%' and my IP isn't changing, does anybody know what 
the problem is with PHP???


TIA,
James




--
The sender of this email subscribes to Perimeter Internetworking's email
anti-virus service. This email has been scanned for malicious code and is
believed 
to be virus free. For more information on email security please 
visit:

http://www.perimeterusa.com/email-defense-content.html

This communication is 
confidential, intended only for the named recipient(s)
above and may contain trade secrets 
or other information that is exempt from
disclosure under applicable law. Any use, 
dissemination, distribution or
copying of this communication by anyone other than the named 
recipient(s) is
strictly prohibited. If you have received this communication in error, 
please

delete the email and immediately notify our Command Center at 203-541-3444.

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

Re: [PHP-DB] access db

[Stut]

tuna3000 wrote:
im new to php, i would like to see a simple php script for manipulating an 
access database (or mysql)  for me to learn on. thanks. 


Have you tried the manual? Lots of useful and interesting stuff in 
there. Especially for people new to PHP.


Try http://php.net/odbc and http://php.net/mysql. Google tends to be 
very good too: http://www.google.co.uk/search?q=php+access+database


-Stut

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

[PHP-DB] access db

[tuna3000]

im new to php, i would like to see a simple php script for manipulating an 
access database (or mysql)  for me to learn on. thanks. 

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

Re: [PHP-DB] Access

[Robert Twitty]

You have 3 options.

Option 1: Use PHP's native odbc extension. This option is limited, and
only works on @in32 platforms.

Option 3: Use PHP's COM support. This option only works on @In32
platforms, and does not follow the function paradigm of PHP's database
extensions. Example code:
http://aspn.activestate.com/ASPN/Cookbook/PHP/Recipe/163447

Option 3: Use the ODBTP extension, available at
http://odbtp.sourceforge.net. This options allows you to remotely connect
to an Access database from any platform. It provides the best support for
MS Access. Here is an example of how to use ODBTP to call a MS Accesss
stored query: http://odbtp.sourceforge.net/storedqry_php.html

Note: All of these options are supported by PEAR DB.

-- bob

On Wed, 2 Feb 2005, Darryl wrote:

> Hay,
>
>
>
> I was just wondering if any of you had any links to websites that explained
> php programming with Access databases.
>
>
>
> Thanks in advance,
>
> Darryl
>
>

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

RE: [PHP-DB] Access

[Bastien Koert]

use the ODBC functions in php
bastien
From: "Darryl" <[EMAIL PROTECTED]>
To: 
Subject: [PHP-DB] Access
Date: Wed, 2 Feb 2005 19:49:47 +0200
Hay,

I was just wondering if any of you had any links to websites that explained
php programming with Access databases.

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

[PHP-DB] Access

[Darryl]

Hay,

 

I was just wondering if any of you had any links to websites that explained
php programming with Access databases.

 

Thanks in advance,

Darryl

Re: [PHP-DB] access denied

[water_foul]

I did set the veriables just in another script that includes this swcript
"Mikhail U. Petrov" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi!
> I think you not set this variables. Try to read your full errorlog but
> not only one part.
>
>
> Saturday, June 26, 2004, 7:37:36 PM, water_foul wrote:
>
> w> i get this error:
> w> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using
> w> password: YES) in
> w>
C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s
> w> ervices.php on line 3
> w> and the code up to line 3 is:
> w>  w> //Database Querys
> w> $connection=Mysql_connect($dbHost , $dbName , $dbPassword);
> w> 
> w> i have included this in another script that sets $dbHost, $dbName and,
> w> $dbPassword to the correct things to connect to the db
>
>
>
> -- 
> Best regards,
> Mikhail U. Petrov
> mailto:[EMAIL PROTECTED]

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

Re: [PHP-DB] access denied

[Mikhail U. Petrov]

Hi!
I think you not set this variables. Try to read your full errorlog but
not only one part.


Saturday, June 26, 2004, 7:37:36 PM, water_foul wrote:

w> i get this error:
w> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using
w> password: YES) in
w> C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s
w> ervices.php on line 3
w> and the code up to line 3 is:
w>  //Database Querys
w> $connection=Mysql_connect($dbHost , $dbName , $dbPassword);
w> 
w> i have included this in another script that sets $dbHost, $dbName and,
w> $dbPassword to the correct things to connect to the db



-- 
Best regards,
Mikhail U. Petrov
mailto:[EMAIL PROTECTED]

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

[PHP-DB] access denied

[water_foul]

i get this error:
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES) in
C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s
ervices.php on line 3
and the code up to line 3 is:
http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Access and PHP problem

[Jason Hawkins]

Hi,
I am trying to INSERT into a MSAccess database using PHP 4.3 -
I have a problem when I enter a name like O'Donnell. In mysql I would
normally just backslash the single quote but this doesn't work with
MSAccess.
is there a fix for this??
Thanks in adv.

Jason

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

Re: [PHP-DB] Access db

[Luke van Blerk]

Thanks Michael. I'll check it out ;)

- Luke


"Michael Mauch" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Luke Van Blerk wrote:
>
> > I'll probably just extract the data with an access to mysql script and
run
> > it on mysql.
>
> This is probably the best approach if you have access to Windows
> machine. If not,  might help.
>
> Regards...
> Michael

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

Re: [PHP-DB] Access db

[Michael Mauch]

Luke Van Blerk wrote:

> I'll probably just extract the data with an access to mysql script and run
> it on mysql.

This is probably the best approach if you have access to Windows
machine. If not,  might help.

Regards...
Michael

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

RE: [PHP-DB] Access db

[Luke van Blerk]

Thanks Robert

I'll probably just extract the data with an access to mysql script and run
it on mysql.

- Luke

Robert Twitty wrote:
> To the best of my knowledge you cannot access an Access database
> directly from UNIX or Linux.  The reason is because the Jet Engine
> has not been ported to those platforms.  Your only options may be
> something
> like EasySoft's ODBC-ODBC bridge or ODBTP.
>
> -- bob
>
> On Wed, 19 Nov 2003, Luke van Blerk wrote:
>
>> Hi everyone
>>
>> Can PHP access an access database residing on a unix / linux box? I
>> know theres and ODBC extension but is that only for windows?
>>
>> Regards
>> Luke
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/2003

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

Re: [PHP-DB] Access db

[Robert Twitty]

To the best of my knowledge you cannot access an Access database directly
from UNIX or Linux.  The reason is because the Jet Engine has not been
ported to those platforms.  Your only options may be something
like EasySoft's ODBC-ODBC bridge or ODBTP.

-- bob

On Wed, 19 Nov 2003, Luke van Blerk wrote:

> Hi everyone
>
> Can PHP access an access database residing on a unix / linux box? I know
> theres and ODBC extension but is that only for windows?
>
> Regards
> Luke
>
> --
> 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] Access db

[Luke van Blerk]

Hi everyone

Can PHP access an access database residing on a unix / linux box? I know
theres and ODBC extension but is that only for windows?

Regards
Luke

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

Re: [PHP-DB] Access 95 ODBC Annoyance

[otherguy]

If you're deleting or modifying or re-creating any linked tables, that 
might require exclusive access.  Access will automagically put you into 
exclusive mode if you do something like this.

Try closing out as soon as you've updated the DB.

-Cameron Wilhelm

On Thursday, July 17, 2003, at 02:21  PM, Will Howard wrote:

JMR,

The problem might be overcome by instructing the other users to make
certain they do not open the database in "exclusive." I no longer have 
a
copy of Access 95 around, but I seem to recall that we had this problem
when the database was opened by another user who had "open exclusive"
checked in the dialog box where they selected the database to open. If
you go to the "Open" dialog box, you may see what I am talking about.

Will Howard

-Original Message-
From: J. Michael Roberts [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 12:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Access 95 ODBC Annoyance
I'll be the first to admit this is a rather backwards system and prone
to be illogical, but it's what was handed to me and I can't do much
about that.
I've got an ancient Access 95 database that I've linked to via another
A95 database which is queried via ODBC. It was done this way because 
I'm
not allowed to touch the first database due to the insane way they
replace the data each week. (i.e.: any of my tables would be gone, so I
need to keep 'my' data safe and link to 'their' data)

While under development, I was working with a copy of the database and
got everything to work fine. In order to "go live" with the current
data, I had to go into 'my' database and update the linked tables.  
When
this was done, my interface failed miserably and returned the following
message:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot open the file 
'T:\TS\Te_rdata.mdb'.
It is already opened exclusively by another user, or you need 
permission
to view its data., SQL state S1000 in SQLExecDirect in
C:\Apache2\htdocs\projecthours\deptjobs.php on line 44

Now it gets worse: I need to be able to access the data even if someone
has it open. Read-only access isn't a problem...because that's all this
particular interface does...but I just keep getting denied. Any ideas?
Suffering under a backwards system,
--JMR
PS - Access is a hunk of crap...especially Access 95.



--
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] Access 95 ODBC Annoyance

[J. Michael Roberts]

I discovered the problem at had was in the network permissions set on 
the file (?) that was denying Apache to access it properly and the error 
code returned was the best thing the system could come up with.

I changed my Apached service to 'run as' and authorized user (me) and it 
happily viewed the data.

--JMR

J. Michael Roberts wrote:

>I'll be the first to admit this is a rather backwards system and prone to
be
>illogical, but it's what was handed to me and I can't do much about that.
>
>I've got an ancient Access 95 database that I've linked to via another A95
>database which is queried via ODBC. It was done this way because I'm not
>allowed to touch the first database due to the insane way they replace the
>data each week. (i.e.: any of my tables would be gone, so I need to keep
>'my' data safe and link to 'their' data)
>
>While under development, I was working with a copy of the database and got
>everything to work fine. In order to "go live" with the current data, I had
>to go into 'my' database and update the linked tables.  When this was done,
>my interface failed miserably and returned the following message:
>
>Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft
>Jet database engine cannot open the file 'T:\TS\Te_rdata.mdb'. It is
already
>opened exclusively by another user, or you need permission to view its
>data., SQL state S1000 in SQLExecDirect in
>C:\Apache2\htdocs\projecthours\deptjobs.php on line 44
>
>Now it gets worse: I need to be able to access the data even if someone has
>it open. Read-only access isn't a problem...because that's all this
>particular interface does...but I just keep getting denied. Any ideas?
>
>Suffering under a backwards system,
>--JMR
>
>PS - Access is a hunk of crap...especially Access 95.
>
>
>  
>

RE: [PHP-DB] Access 95 ODBC Annoyance

[Will Howard]

JMR,

The problem might be overcome by instructing the other users to make
certain they do not open the database in "exclusive." I no longer have a
copy of Access 95 around, but I seem to recall that we had this problem
when the database was opened by another user who had "open exclusive"
checked in the dialog box where they selected the database to open. If
you go to the "Open" dialog box, you may see what I am talking about.

Will Howard

-Original Message-
From: J. Michael Roberts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 17, 2003 12:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Access 95 ODBC Annoyance


I'll be the first to admit this is a rather backwards system and prone
to be illogical, but it's what was handed to me and I can't do much
about that.

I've got an ancient Access 95 database that I've linked to via another
A95 database which is queried via ODBC. It was done this way because I'm
not allowed to touch the first database due to the insane way they
replace the data each week. (i.e.: any of my tables would be gone, so I
need to keep 'my' data safe and link to 'their' data)

While under development, I was working with a copy of the database and
got everything to work fine. In order to "go live" with the current
data, I had to go into 'my' database and update the linked tables.  When
this was done, my interface failed miserably and returned the following
message:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot open the file 'T:\TS\Te_rdata.mdb'.
It is already opened exclusively by another user, or you need permission
to view its data., SQL state S1000 in SQLExecDirect in
C:\Apache2\htdocs\projecthours\deptjobs.php on line 44

Now it gets worse: I need to be able to access the data even if someone
has it open. Read-only access isn't a problem...because that's all this
particular interface does...but I just keep getting denied. Any ideas?

Suffering under a backwards system,
--JMR

PS - Access is a hunk of crap...especially Access 95.



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

Re: [PHP-DB] Access 95 ODBC Annoyance

[Robert Twitty]

If the other application opens the database exclusively, then you will not
be able to open it, even for read only.  The only solution to modify the
sharing option used by the other application.  Another problem you may
encounter is that the ODBC driver for Access is not thread safe.

-- bob

On Thu, 17 Jul 2003, J. Michael Roberts wrote:

> I'll be the first to admit this is a rather backwards system and prone to be
> illogical, but it's what was handed to me and I can't do much about that.
>
> I've got an ancient Access 95 database that I've linked to via another A95
> database which is queried via ODBC. It was done this way because I'm not
> allowed to touch the first database due to the insane way they replace the
> data each week. (i.e.: any of my tables would be gone, so I need to keep
> 'my' data safe and link to 'their' data)
>
> While under development, I was working with a copy of the database and got
> everything to work fine. In order to "go live" with the current data, I had
> to go into 'my' database and update the linked tables.  When this was done,
> my interface failed miserably and returned the following message:
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft
> Jet database engine cannot open the file 'T:\TS\Te_rdata.mdb'. It is already
> opened exclusively by another user, or you need permission to view its
> data., SQL state S1000 in SQLExecDirect in
> C:\Apache2\htdocs\projecthours\deptjobs.php on line 44
>
> Now it gets worse: I need to be able to access the data even if someone has
> it open. Read-only access isn't a problem...because that's all this
> particular interface does...but I just keep getting denied. Any ideas?
>
> Suffering under a backwards system,
> --JMR
>
> PS - Access is a hunk of crap...especially Access 95.
>
>


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

[PHP-DB] Access 95 ODBC Annoyance

[J. Michael Roberts]

I'll be the first to admit this is a rather backwards system and prone to be
illogical, but it's what was handed to me and I can't do much about that.

I've got an ancient Access 95 database that I've linked to via another A95
database which is queried via ODBC. It was done this way because I'm not
allowed to touch the first database due to the insane way they replace the
data each week. (i.e.: any of my tables would be gone, so I need to keep
'my' data safe and link to 'their' data)

While under development, I was working with a copy of the database and got
everything to work fine. In order to "go live" with the current data, I had
to go into 'my' database and update the linked tables.  When this was done,
my interface failed miserably and returned the following message:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft
Jet database engine cannot open the file 'T:\TS\Te_rdata.mdb'. It is already
opened exclusively by another user, or you need permission to view its
data., SQL state S1000 in SQLExecDirect in
C:\Apache2\htdocs\projecthours\deptjobs.php on line 44

Now it gets worse: I need to be able to access the data even if someone has
it open. Read-only access isn't a problem...because that's all this
particular interface does...but I just keep getting denied. Any ideas?

Suffering under a backwards system,
--JMR

PS - Access is a hunk of crap...especially Access 95.

[PHP-DB] Access denied for user: '@localhost'

[Sean Burlington]

Hi,
  this problem seems to have appeared after a system upgrade ...
command line works fine

mysql -uschool -pbonfire school

BUT


/* Connecting, selecting database */
$link = mysql_connect("localhost", "school", "bonfire")
or die("Could not connect : " . mysql_error());
print "Connected successfully";
mysql_select_db("school") or die("Could not select database". 
mysql_error());

?>

results in the following error

Connected successfully
Could not select database
Access denied for user: '@localhost' to database 'school'
the logfile shows this ...

030602 18:47:01  33 Connect [EMAIL PROTECTED] as anonymous on
 33 Init DB Access denied for user: 
'@localhost' to database 'school'
 33 Quit

Any ideas why the connection is being made as anonymous instead of with 
the details supplied ???

I'm running debian/testing which is up to date and all relavent systems 
are default install with some config changes...

I've tried re-building from scratch apache + php using the latest 
tarballs (installed to a different location) and still get the same error

I've also tried connecting to a different mysql server (same error) - in 
fact php still tries to connect to localhost !

I'll try installing a new version of mysql ... but any other ideas would 
be much appreciated

--

Sean

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

[PHP-DB] Access querys to a csv

[Donald S. Booth]

Hi all,
 I am trying to dump an Access db query and form it into a comma delimited
file.
I get the query ok. I can get it into a table with odbc_result_all.
If I print the variable, it shows the first value from the first row...
Any hints on the path I should take?
Thanks,
D



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

Re: [PHP-DB] access mysql db with DW

[Jason Wong]

On Sunday 09 February 2003 10:29, Terry L. Ensley wrote:
> You found it -
>
> It works like a charm -
>
> Thanks Dennis
>
>
> "Dennis Cole Jr" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> > Part of the problem is
> >
> > $insertGoTo = "booking_details.php?email=".HTTP_POST_VARS["email"]."";
> >
> > should be
> >
> > $insertGoTo = "booking_details.php?email="$HTTP_POST_VARS["email"]."";

For people wondering _why_ it "works like a charm" the correct statement 
should in fact be:

  $insertGoTo = "booking_details.php?email=".$HTTP_POST_VARS["email"]."";

-- 
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
--
/*
You need no longer worry about the future.  This time tomorrow you'll be dead.
*/


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

Re: [PHP-DB] access mysql db with DW

[Terry L. Ensley]

You found it -

It works like a charm -

Thanks Dennis


"Dennis Cole Jr" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Part of the problem is
>
> $insertGoTo = "booking_details.php?email=".HTTP_POST_VARS["email"]."";
>
> should be
>
> $insertGoTo = "booking_details.php?email="$HTTP_POST_VARS["email"]."";



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

RE: [PHP-DB] access mysql db with DW

[Dennis Cole Jr]

Part of the problem is

$insertGoTo = "booking_details.php?email=".HTTP_POST_VARS["email"]."";

should be

$insertGoTo = "booking_details.php?email="$HTTP_POST_VARS["email"]."";

-Original Message-
From: Terry L. Ensley [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 7:53 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] access mysql db with DW


I created a database in mysql - running php via apache on a XP os.  I get a
good connection in dreamweaver with the database panel - no problems
connecting and viewing tables in dw.

I created a form that I want to load the user info to the table.  My run
line is:
ttp://127.0.0.1:8080/dreamweaverhotel/bookings/add_user_record.php  - the
page shows blank - in the view source I get a basic shell of html -






That's it! - the path is good - I loaded some other php files that work in
there and they run fine.  My phpMyAdmin works great - So I know the
localhost connection is good and php is working and mysql is fine I can
access it through phpMyAdmin or dw in database panel, those parts are
working.  So there is obviously something wrong with my add_user.php file
(the one that won't work).  Now DW has put the connection variables in my
code - can anyone tell me what is wrong? - hopefully.

This was all created with DW.

And here is what is in the connHotel.php file:



Thanks - This is just the php part - the html form part goes below - I
didn't want to lload too much.








--
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] access mysql db with DW

[Dennis Cole Jr]

Part of the problem is

$insertGoTo = "booking_details.php?email=".HTTP_POST_VARS["email"]."";

should be

$insertGoTo = "booking_details.php?email="$HTTP_POST_VARS["email"]."";

-Original Message-
From: Terry L. Ensley [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 7:53 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] access mysql db with DW


I created a database in mysql - running php via apache on a XP os.  I get a
good connection in dreamweaver with the database panel - no problems
connecting and viewing tables in dw.

I created a form that I want to load the user info to the table.  My run
line is:
ttp://127.0.0.1:8080/dreamweaverhotel/bookings/add_user_record.php  - the
page shows blank - in the view source I get a basic shell of html -






That's it! - the path is good - I loaded some other php files that work in
there and they run fine.  My phpMyAdmin works great - So I know the
localhost connection is good and php is working and mysql is fine I can
access it through phpMyAdmin or dw in database panel, those parts are
working.  So there is obviously something wrong with my add_user.php file
(the one that won't work).  Now DW has put the connection variables in my
code - can anyone tell me what is wrong? - hopefully.

This was all created with DW.

And here is what is in the connHotel.php file:



Thanks - This is just the php part - the html form part goes below - I
didn't want to lload too much.








--
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] access mysql db with DW

[Terry L. Ensley]

I created a database in mysql - running php via apache on a XP os.  I get a
good connection in dreamweaver with the database panel - no problems
connecting and viewing tables in dw.

I created a form that I want to load the user info to the table.  My run
line is:
ttp://127.0.0.1:8080/dreamweaverhotel/bookings/add_user_record.php  - the
page shows blank - in the view source I get a basic shell of html -






That's it! - the path is good - I loaded some other php files that work in
there and they run fine.  My phpMyAdmin works great - So I know the
localhost connection is good and php is working and mysql is fine I can
access it through phpMyAdmin or dw in database panel, those parts are
working.  So there is obviously something wrong with my add_user.php file
(the one that won't work).  Now DW has put the connection variables in my
code - can anyone tell me what is wrong? - hopefully.

This was all created with DW.

And here is what is in the connHotel.php file:



Thanks - This is just the php part - the html form part goes below - I
didn't want to lload too much.








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

[PHP-DB] Access Violation in ISAPI version

[Ryan Jameson (USA)]

Has anyone else had problems with the error "PHP has encountered an Access Violation 
at 098029AE" ...

It's talked about at:
http://bugs.php.net/bug.php?id=15333 


The most frustrating thing is our ISP went above the call of duty to install PHP for 
me, and now his response is... well read for yourselves:

>>
I read through all the stuff at php.net.  The long and short of it is this:
Nobody really knows what is causing the problem. 
It appears to be a problem with a dual-processor machine (which is what you're using) 
It is believed that 4.2.3 solves the problem (that is the latest version and the 
version we are using) 
Setting the security model to "low" on the site helps in many cases (doesn't eliminate 
the problem, just reduces how often it occurs)

Ergo, this has been my problem with "public domain" scripting languages such as PHP.  
There is not a single source that can be held accountable for ensuring a problem is 
solved.  It is the reason that we have standardized on CF, because when it's bad, 
Macromedia HAS to fix it.
 
All that being said, and consistent with our terms of installation, I will take some 
time to see if I can "trim up" the configuration and improve the situation.  However, 
because this problem crashes the server completely, if we can't find a resolution 
soon, I will opt to remove it from the system.
 
One of our key responsibilities is system stability and reliability.  Again, I'll see 
if I can modify the config to alleviate this, however, the php resource was very 
little help.
>>

I'm pretty disappointed that this hasn't been fixed yet. Has anyone had any luck 
fixing it?

Thanks!
<>< Ryan

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

RE: [PHP-DB] Access a Flat File DB - How?

[John W. Holmes]

> On another topic...Does MySQL handle record locking and prevent
multiple
> open edits by different users?

Yes.

---John Holmes...



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

Re: [PHP-DB] Access a Flat File DB - How?

[Crony]

On another topic...Does MySQL handle record locking and prevent multiple
open edits by different users?

"Maxim Maletsky" <[EMAIL PROTECTED]> wrote in message
news:20021112130532.1DE5.MAXIM@;php.net...
>
> Risks are to share properly the data. You can never rely on the accuracy
> of data in the flat files as those could be changing at the same
> instance as your application is reading it. RDMS (not mySQL) can handle
> it under relational logic mechanisms, meaning they would not read the
> data that is currently being written and would not write the data that
> is currently being read.
>
>
> --
> Maxim Maletsky
> [EMAIL PROTECTED]
>
>
>
> "Crony" <[EMAIL PROTECTED]> wrote... :
>
> > I have written a few small apps in PHP and MySQL. These were mostly
copy,
> > paste and change and fairly easy. I now wnat ot connect to a flat file
dbase
> > that is used by another enterprise app. Then I want to start normal PHP
> > programming. Is there any risk in doing this? Where do I start?
> >
> >
> >
> >
> > --
> > 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] Access a Flat File DB - How?

[Maxim Maletsky]

Risks are to share properly the data. You can never rely on the accuracy
of data in the flat files as those could be changing at the same
instance as your application is reading it. RDMS (not mySQL) can handle
it under relational logic mechanisms, meaning they would not read the
data that is currently being written and would not write the data that
is currently being read.


--
Maxim Maletsky
[EMAIL PROTECTED]



"Crony" <[EMAIL PROTECTED]> wrote... :

> I have written a few small apps in PHP and MySQL. These were mostly copy,
> paste and change and fairly easy. I now wnat ot connect to a flat file dbase
> that is used by another enterprise app. Then I want to start normal PHP
> programming. Is there any risk in doing this? Where do I start?
> 
> 
> 
> 
> -- 
> 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] Access a Flat File DB - How?

[Crony]

I have written a few small apps in PHP and MySQL. These were mostly copy,
paste and change and fairly easy. I now wnat ot connect to a flat file dbase
that is used by another enterprise app. Then I want to start normal PHP
programming. Is there any risk in doing this? Where do I start?




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

Re: [PHP-DB] access DB via PHP classes

[Ruth Zhai]

Thank you again, Wilmar.

As a newbie for OOP, I will keep my option open when I design this
application.  I have not come to a conclusion which way is better than
another (I wish I had time to test all possibilities).  I appreciate your
comments, and will keep them in mind.

Regards

Ruth

- Original Message -
From: "Wilmar Perez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 12:10 AM
Subject: Re: [PHP-DB] access DB via PHP classes


> Well, what about building a basic class without any database conection in
the
> constructor and then have a inherited class with the needed database
> conection? and then use whichever you need to generate the pages.
>
> You can even just have  the basic class and execute some code in the
> constructor that connects or not to the database depending on a parameter
you
> pass to it.
>
> As I told you before, I'm very newbie to OOP as well, but think that may
work
> well.
>
> Hope it helps
>
> Bye
>
> ***
>  Wilmar Pérez
>  Network Administrator
>Library System
>   Tel: ++57(4)2105145
> University of Antioquia
>Medellín - Colombia
>   2002
> ***
>
>
>
> --
> 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] access DB via PHP classes

[Wilmar Perez]

Well, what about building a basic class without any database conection in the 
constructor and then have a inherited class with the needed database 
conection? and then use whichever you need to generate the pages.

You can even just have  the basic class and execute some code in the 
constructor that connects or not to the database depending on a parameter you 
pass to it.

As I told you before, I'm very newbie to OOP as well, but think that may work 
well.

Hope it helps

Bye

***
 Wilmar Pérez
 Network Administrator
   Library System
  Tel: ++57(4)2105145
University of Antioquia
   Medellín - Colombia
  2002
***
 
 

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

Re: [PHP-DB] access DB via PHP classes

[Ruth Zhai]

Thanks Wilmar, for sharing your experience with me.  My problem now is that
I have already got a class to do every thing related to database.  If I
don't use this DB class within other classes, I will have a lot of
duplicated code.  If I do use the DB class within other classes, I am not
sure if it is efficient.

Thanks again.

Ruth


- Original Message -
From: "Wilmar Perez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 11:53 AM
Subject: Re: [PHP-DB] access DB via PHP classes


> Well, I'll tell you what I do.
>
> I'm not a OOP expert so if someone feel like I'm doing it wrong I'll
welcome
> any comment about .
>
> I've got a main class which I use to generate every page in my website
(some
> are actually generated by inherited classes but that's the main idea).  As
I
> need a database conection for every page I write the connection threat in
the
> main class constructor using mysql_pconnect which handles a persistent
> connection.
>
> So far it is workin alright for me.  As I said before any comments will be
> welcome.
>
> Hope it helps
>
> ***
>  Wilmar Pérez
>  Network Administrator
>Library System
>   Tel: ++57(4)2105145
> University of Antioquia
>Medellín - Colombia
>   2002
> ***
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Hi All,
Although I am not so new to PHP (not expert either), this is the first time
for me to use PHP class.

I am starting a project, and plan to use partially OOP and partially
traditional programming.  I use PHP/MySQL.  I have one class, DB_Do, which
does every thing to do with database, and several other classes.  When I
start my design, I realized that very often, other classes need to access
database, eg. I have an "Access_Control" class which controls all accesses
to pages in the application.  One of methods in this class is to
authenticate the user login via user name and password stored in the
database.  I am not sure if I should use an object of DB_Do within the
method of Access_Control or write separate code to access the database for
the user name and password.  It seems that I loose purpose of OOP if I write
the separate code.  However, I am not sure if creating the object within
other class is efficient?

I would appreciate if some one there could give me some suggestions about
this.

Thanks in advance.

Ruth




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

Re: [PHP-DB] access DB via PHP classes

[Wilmar Perez]

Well, I'll tell you what I do. 

I'm not a OOP expert so if someone feel like I'm doing it wrong I'll welcome 
any comment about .

I've got a main class which I use to generate every page in my website (some 
are actually generated by inherited classes but that's the main idea).  As I 
need a database conection for every page I write the connection threat in the 
main class constructor using mysql_pconnect which handles a persistent 
connection.

So far it is workin alright for me.  As I said before any comments will be 
welcome.

Hope it helps

***
 Wilmar Pérez
 Network Administrator
   Library System
  Tel: ++57(4)2105145
University of Antioquia
   Medellín - Colombia
  2002
***
 
 

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

[PHP-DB] access DB via PHP classes

[Ruth Zhai]

Hi All,
Although I am not so new to PHP (not expert either), this is the first time
for me to use PHP class.

I am starting a project, and plan to use partially OOP and partially
traditional programming.  I use PHP/MySQL.  I have one class, DB_Do, which
does every thing to do with database, and several other classes.  When I
start my design, I realized that very often, other classes need to access
database, eg. I have an "Access_Control" class which controls all accesses
to pages in the application.  One of methods in this class is to
authenticate the user login via user name and password stored in the
database.  I am not sure if I should use an object of DB_Do within the
method of Access_Control or write separate code to access the database for
the user name and password.  It seems that I loose purpose of OOP if I write
the separate code.  However, I am not sure if creating the object within
other class is efficient?

I would appreciate if some one there could give me some suggestions about
this.

Thanks in advance.

Ruth



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

RE: [PHP-DB] Access to Mysql

[Richard Black]

Funnily enough, I had to do something similar last week...

Command line utility which will create a sql file to create the MySQL 
database.

No guarantees that it works for everything, but it fulfilled my purposes...

Syntax is:

php -q odbc2mysql.php new_db output_file dsn [user] [password]

And will create a file which contains statements to set up the structure 
(creating ), and import the data.

DOESN'T bring across any indexes, or primary keys, cos I couldn't get the 
php odbc commands to work against Access. Dunno why. But you'll have to set 
those up yourself...

HTH,


Richy


==
Richard Black
Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com
Tel: 0141 435 3504
Email: [EMAIL PROTECTED]


-Original Message-
From:   Alex Francis [SMTP:[EMAIL PROTECTED]]
Sent:   13 February 2002 09:55
To: [EMAIL PROTECTED]
Subject:    [PHP-DB] Access to Mysql

I am a complete newbie at this so please excuse me if I seem stupid.

I have a guestbook on one site which was created using ASP and an Access
database. I have created a new site using the much more friendly PHP and
wish to get the data into my mysql database. Can I do this easily, and if 
so
can anyone point me to the required information

--
Alex Francis
Cameron Design
35, Drumillan Hill
Greenock PA16 0XD

Tel 01475 798106
[EMAIL PROTECTED]
http://www.camerondesign.co.uk

This message is sent in confidence for the addressee only. It may contain
legally privileged information.
Unauthorised recipients are requested to preserve this confidentiality and
to advise the sender
immediately of any error in transmission.



--
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] Access to Mysql

[Alex Francis]

I am a complete newbie at this so please excuse me if I seem stupid.

I have a guestbook on one site which was created using ASP and an Access
database. I have created a new site using the much more friendly PHP and
wish to get the data into my mysql database. Can I do this easily, and if so
can anyone point me to the required information

--
Alex Francis
Cameron Design
35, Drumillan Hill
Greenock PA16 0XD

Tel 01475 798106
[EMAIL PROTECTED]
http://www.camerondesign.co.uk

This message is sent in confidence for the addressee only. It may contain
legally privileged information.
Unauthorised recipients are requested to preserve this confidentiality and
to advise the sender
immediately of any error in transmission.



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

Re: [PHP-DB] access stored proc

[Harry N. C. Ng]

Here's one I used:

Example of Php program invoking a PL/SQL anonymous block.  The block can
then call a PL/SQL compiled function or stored procedure on the
server.  The OCIBindByName function is used to pass values into or out
of the PL/SQL anonymous block.  In this example, a compiled PL/SQL
function on PRD1 (get_eicsum) is invoked.  Two variables are passed
in (SCC and SIC) and one is returned (result).

";

   OCIFreeStatement($stmt);
   OCILogoff($conn);
?>




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] access stored proc

[Mohd Nizar Abdul Najib]

how do i access oracle stored procedure that return value 0 or 1 in PHP.
Does anyone know?

Thank you

Regards,
Mohd Nizar



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Access with PHP on Linux?

[Andrew Hill]

Steve,

To clarify, you cannot run Access on Linux.
You can install ODBC support for PHP on Linux, and use ODBC drivers to talk
to an Access db on Windows.

ODBC support for PHP under Linux requires linking PHP with an ODBC Driver
Manager.
iODBC (www.iodbc.org) is your best bet, and there are HOWTO's on that site
for linking --with-iodbc.

Also, you will need ODBC drivers; OpenLink provides a free download of our
commercial drivers at www.openlinksw.com.

Please let me know if you require further assistance.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers

> -Original Message-
> From: Steve Farmer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 13, 2001 10:32 PM
> To: Andreas D. Landmark; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Access with PHP on Linux?
>
>
> Hi Andreas,
>
> At 11:54 PM + 13/11/01, Andreas D. Landmark wrote:
> >At 13.11.2001 23:23, Chris Payne wrote:
> >>Hi there everyone,
>
> [snip]
>
> >>
> >>I want to keep it an access DB if possible as i've had problems
> >>changing the DB to MySQL.
> >
> >Install ODBC, that would let you interface with degenerate
> database formats
> >as access et al.
>
> When you say install ODBC, I assume you mean on the Linux box.  Could
> you give me a pointer as to the best way to achieve this ?
>
> [snip
> >
> >
> >--
> >Andreas D Landmark / noXtension
>
> Regards
> Steve
> --
> -
> "Minds are like parachutes, they work best when open"
> Support free speech; visit http://www.efa.org.au/
>
> Heads Together Systems Pty Ltd http://www.hts.com.au
> Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access with PHP on Linux?

[Steve Farmer]

Hi Andreas,

At 11:54 PM + 13/11/01, Andreas D. Landmark wrote:
>At 13.11.2001 23:23, Chris Payne wrote:
>>Hi there everyone,

[snip]

>>
>>I want to keep it an access DB if possible as i've had problems 
>>changing the DB to MySQL.
>
>Install ODBC, that would let you interface with degenerate database formats
>as access et al.

When you say install ODBC, I assume you mean on the Linux box.  Could 
you give me a pointer as to the best way to achieve this ?

[snip
>
>
>--
>Andreas D Landmark / noXtension

Regards
Steve
-- 
-
"Minds are like parachutes, they work best when open"
Support free speech; visit http://www.efa.org.au/

Heads Together Systems Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access with PHP on Linux?

[Andreas D. Landmark]

At 13.11.2001 23:23, Chris Payne wrote:
>Hi there everyone,
>
>I have had abit of an emergency, I have a website for a client based on 
>ASP and ACCESS 2000, but the current server is giving us problems so I 
>want to move over to my own server.  The problem is my server is a Linux 
>server - is ACCESS 2000 possible?
>
>My server has support for PHP, ASP, MySQL, etc .. and it says that PHP 
>is able to interface with ACCESS - but how to hell do you do that?  I 
>haven't got a clue - could anyone please help me as it is dead easy using 
>a DSN-LESS connection on the current server, but I don't know where to 
>start here.
>
>My server runs the latest Red Hat Linux Apache system, with ASP (Don't 
>remember which version I only know it's not Chilishoft - sorry :-(  Latest 
>PHP, MySQL, FP2000 Ext... CGI and so on.
>
>I want to keep it an access DB if possible as i've had problems changing 
>the DB to MySQL.

Install ODBC, that would let you interface with degenerate database formats
as access et al.

Your best solution however would be to ditch Access and go a decent 
database solution,
one that doesn't tend to break under load (and doesn't impose strange 
limitations
on itself with regards to throughput).

(on a totally different not, I'd ditch FP extensions aswell, as they've 
proved to be a bit of
a nightmare on the security front in the past, don't know how they're doing 
at the moment,
but anything that tries to imitate something undocumented is a no-no in my 
production
environments).


-- 
Andreas D Landmark / noXtension
Real Time, adj.:
 Here and now, as opposed to fake time, which only occurs there
and then.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access with PHP on Linux?

[Chris Payne]

Hi there everyone,

I have had abit of an emergency, I have a website for a client based on ASP and ACCESS 
2000, but the current server is giving us problems so I want to move over to my own 
server.  The problem is my server is a Linux server - is ACCESS 2000 possible?

My server has support for PHP, ASP, MySQL, etc .. and it says that PHP is able to 
interface with ACCESS - but how to hell do you do that?  I haven't got a clue - could 
anyone please help me as it is dead easy using a DSN-LESS connection on the current 
server, but I don't know where to start here.

My server runs the latest Red Hat Linux Apache system, with ASP (Don't remember which 
version I only know it's not Chilishoft - sorry :-(  Latest PHP, MySQL, FP2000 Ext... 
CGI and so on.

I want to keep it an access DB if possible as i've had problems changing the DB to 
MySQL.

Thank you for your help it's very much appreciated.

Regards

Chris Payne
www.planetoxygene.com

Re: [PHP-DB] Access to MySQL denied

[Dommers]

If your php-script runs on the same server as mysql, you should try
'localhost' as the hostname.
That worked for me in most cases.

"Russ Michell" <[EMAIL PROTECTED]> schreef in bericht
news:SIMEON.10110260917.B@k1c. anglia.ac.uk...
> >Of course, it works perfectly fine on my home computer, so I guess it
musthave something to do
> >with the configuration of PHP (or, possibly, MySQL?)
>
> How do you connect to MySQl from home?
> It sounds as if the user trying to connect to MySQL doesn't have the right
privileges to connect
> top the server.
>
> Make sure the 'username' @lsh101.siteprotect.com has been granted all the
right privileges on the
> desired database:
>
> GRANT SELECT,INSERT,UPDATE,DELETE
> ON mydb.*
> TO username@localhost (or [EMAIL PROTECTED])
> IDENTIFIED BY 'your_password';
> FLUSH PRIVILIGES;
>
> HTH.
> Russ
>
> On Fri, 26 Oct 2001 04:48:56 -0400 Kirill Safarov <[EMAIL PROTECTED]>
wrote:
>
> > I cannot connect to MySQL database located at the webhost.  The command:
> > $link = mysql_connect('hostname:3306','username','password') or die
("Could
> > not connect");
> > (with the proper hostname of course) returns this error message:
> > MySQL Connection Failed: Access denied for user:
> > '[EMAIL PROTECTED]' (Using password: YES)
> >
> > Of course, it works perfectly fine on my home computer, so I guess it
must
> > have something to do with the configuration of PHP (or, possibly,
MySQL?)
> >
> > Can anyone tell me what's going on?
> >
> > Thanks,
> > Kirill :)
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> #---#
>
>   "Believe nothing - consider everything"
>
>   Russ Michell
>   Anglia Polytechnic University Webteam
>   Room 1C 'The Eastings' East Road, Cambridge
>
>   e: [EMAIL PROTECTED]
>   w: www.apu.ac.uk/webteam
>
>   www.theruss.com
>
> #---#
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access to MySQL denied

[Kirill Safarov]

I am new to MySQL (I am more used to Microsoft SQL), but it seems to me that
if I provide "username" string as the username parameter, that's what MySQL
should use to login into the database.  Why is "@lsh101.siteprotect.com "
being appended to it? The "username" was provided by the webhost, and
according to them it has full priviledges.

Kirill.





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access to MySQL denied

[Russ Michell]

>Of course, it works perfectly fine on my home computer, so I guess it musthave 
>something to do 
>with the configuration of PHP (or, possibly, MySQL?)

How do you connect to MySQl from home?
It sounds as if the user trying to connect to MySQL doesn't have the right privileges 
to connect 
top the server.

Make sure the 'username' @lsh101.siteprotect.com has been granted all the right 
privileges on the 
desired database:

GRANT SELECT,INSERT,UPDATE,DELETE
ON mydb.* 
TO username@localhost (or [EMAIL PROTECTED])
IDENTIFIED BY 'your_password';
FLUSH PRIVILIGES;

HTH.
Russ

On Fri, 26 Oct 2001 04:48:56 -0400 Kirill Safarov <[EMAIL PROTECTED]> wrote:

> I cannot connect to MySQL database located at the webhost.  The command:
> $link = mysql_connect('hostname:3306','username','password') or die ("Could
> not connect");
> (with the proper hostname of course) returns this error message:
> MySQL Connection Failed: Access denied for user:
> '[EMAIL PROTECTED]' (Using password: YES)
> 
> Of course, it works perfectly fine on my home computer, so I guess it must
> have something to do with the configuration of PHP (or, possibly, MySQL?)
> 
> Can anyone tell me what's going on?
> 
> Thanks,
> Kirill :)
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#---#

  "Believe nothing - consider everything"   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com

#---#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access to MySQL denied

[Kirill Safarov]

I cannot connect to MySQL database located at the webhost.  The command:
$link = mysql_connect('hostname:3306','username','password') or die ("Could
not connect");
(with the proper hostname of course) returns this error message:
MySQL Connection Failed: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)

Of course, it works perfectly fine on my home computer, so I guess it must
have something to do with the configuration of PHP (or, possibly, MySQL?)

Can anyone tell me what's going on?

Thanks,
Kirill :)



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Access to MySQL Conversion question

[Tony McCrory]

select max(idfield) from table



> -Original Message-
> From: Brad Harriger [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 7:32 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Access to MySQL Conversion question
> 
> 
> I have several MS Access databases that I need to convert to MySQL.
> Each table is indexed on an ID field.   How do I find the last index
> number in the existing table so that I can increment it for the next
> record that is added?
> 
> Thanks,
> 
> Brad
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Access to MySQL Conversion question

[Rick Emery]

Once it's loaded into MySQL:

SELECT ID FROM mytable ORDER BY ID DESC LIMIT 1;

This will provide the highest ID index.

Set your new ID index in MySQL with the AUTO_INCREMENT attribute.  This will
automatically increment ID when a new record is added.

-Original Message-
From: Brad Harriger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 1:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Access to MySQL Conversion question


I have several MS Access databases that I need to convert to MySQL.
Each table is indexed on an ID field.   How do I find the last index
number in the existing table so that I can increment it for the next
record that is added?

Thanks,

Brad


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access to MySQL Conversion question

[Brad Harriger]

I have several MS Access databases that I need to convert to MySQL.
Each table is indexed on an ID field.   How do I find the last index
number in the existing table so that I can increment it for the next
record that is added?

Thanks,

Brad


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] access denied

[its me]

Warning: MySQL Connection Failed: Access denied for user: 'rehab@localhost' (Using 
password: YES) in /home/sites/site92/web/mall/confirmregistration.php on line 14

Error connecting to host localhost, by user rehab 


should i use this:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
   ON mall.*
   TO rehab@localhost
   IDENTIFIED BY 'mall';

or what???
and how should i write this grant statment???
just put it there or like:
mysql_query(grant select...)???






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] access my cgi-bin

[Andrey Hristov]

I'm not sure that this will work. I think that c:/apache/htdocs is visible to web, so 
../cgi-bin/ will return to
http://host/cgi-bin/test.php .hmmm this will work because there is mapping ScriptAlias 
/cgi-bin/ to /apache/cgi-bin/ but this is not
clear it is effect. better action="/cgi-bin/test.php"

Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS


- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'its me'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 11, 2001 4:25 PM
Subject: RE: [PHP-DB] access my cgi-bin


> yeah, that should have worked.
>
> 
>
> -Original Message-
> From: its me [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 11, 2001 3:19 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] access my cgi-bin
>
>
> here is my folders tree:
> (i'm on windows)
> c:/apache/cgi-bin/test.php
> c:/apache/htdocs/click.html
>
> i want to call test.php from click.html.
> what is the syntax?
> is it something like:  ../cgi-bin/test.php?
>
>
>
> 
> 
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] access my cgi-bin

[Rick Emery]

yeah, that should have worked.



-Original Message-
From: its me [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2001 3:19 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] access my cgi-bin


here is my folders tree:
(i'm on windows)
c:/apache/cgi-bin/test.php
c:/apache/htdocs/click.html

i want to call test.php from click.html.
what is the syntax?
is it something like:  ../cgi-bin/test.php?






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] access my cgi-bin

[its me]

here is my folders tree:
(i'm on windows)
c:/apache/cgi-bin/test.php
c:/apache/htdocs/click.html

i want to call test.php from click.html.
what is the syntax?
is it something like:  ../cgi-bin/test.php?






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access tables to PostgreSQL

[Alexandre Santos]

Grant wrote:
> 
> On Wed, 22 Aug 2001, Tim O'Brien wrote:
> 
> > What is the best method to move data from access tables to postgreSQL?
> >
> > Are there are php functions that are available?
> >
> Unfortunately, only Access reads Access very well, but you can use ODBC
> and linked tables in Access to copy it to PostgreSQL.
I copied tables from Access to Postgres using this method:
1. Install the ODBC Driver in your Windows Box.
2. Export the tables to Postgres.
If the second pass doesn't work, create the tables in POstgres and then
link them in Access and build a append query that copies all the
information from the acess tables to the postgres tables.

Alex

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access tables to PostgreSQL

[grant]

On Wed, 22 Aug 2001, Tim O'Brien wrote:

> What is the best method to move data from access tables to postgreSQL?
>
> Are there are php functions that are available?
>
Unfortunately, only Access reads Access very well, but you can use ODBC
and linked tables in Access to copy it to PostgreSQL.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access tables to PostgreSQL

[Tim O'Brien]

What is the best method to move data from access tables to postgreSQL?

Are there are php functions that are available?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Access counter

[Walter, Marcel]

Another idea of mine:
You could start sessions  and register a variable...
and everytime a new user wants to request a page you can find 
out whether its a new user or not if you check the variable ...

If it is new, then do the stuff below ... elso don´t ...

Cheers, 
Marcel

> -Original Message-
> From: leo g. divinagracia iii [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 24, 2001 06:25
> Cc:   PHP-DB
> Subject:      Re: [PHP-DB] Access counter
> 
> in a simple way, yes.
> 
> if you really want unique users, you can setup a table and insert the IP
> addresses in their and query it everytime.
> 
> the PHP variable that keeps track of the user'a IP address can also be
> checked by storing it in a variable and re-checked each time the page is
> loaded.
> 
> Shahmat Dahlan wrote:
> > 
> > If I do the below, like you stated, that means the counter will update
> > everytime a visitor refreshes the content.
> > 
> > Would it be possible for the counter script not to increase the value by
> 1
> > when a visitor merely refreshes. Is it possible to let the script
> increase the
> > value by only by one, only if the the visitor for a new content (by
> clearing
> > the cache, e.g.).
> > 
> > Thanks you replying..
> > 
> > "leo g. divinagracia iii" wrote:
> > 
> > > in pseudo-code:
> > >
> > > make a text file - associate it a URL
> > >
> > > when a user comes along, have a PHP script on top of the web page to
> > >
> > > 1. open the text file
> > > 2. counter = counter +1
> > > 3. write update
> > > 3.5 print number of hits somewhere on webpage
> > > 4. close file...
> > >
> > > Shahmat Dahlan wrote:
> > > >
> > > > I'd like to do a counter with PHP, how do you do this? I thought
> maybe I
> > > > could either use cookie or session or session? Which should I use ?
> > > >
> 
> 
> -- 
> Leo G. Divinagracia III
> [EMAIL PROTECTED]
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


If you have received this e-mail in error or wish to read our e-mail disclaimer 
statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/ or contact the sender.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access counter

[leo g. divinagracia iii]

in a simple way, yes.

if you really want unique users, you can setup a table and insert the IP
addresses in their and query it everytime.

the PHP variable that keeps track of the user'a IP address can also be
checked by storing it in a variable and re-checked each time the page is
loaded.

Shahmat Dahlan wrote:
> 
> If I do the below, like you stated, that means the counter will update
> everytime a visitor refreshes the content.
> 
> Would it be possible for the counter script not to increase the value by 1
> when a visitor merely refreshes. Is it possible to let the script increase the
> value by only by one, only if the the visitor for a new content (by clearing
> the cache, e.g.).
> 
> Thanks you replying..
> 
> "leo g. divinagracia iii" wrote:
> 
> > in pseudo-code:
> >
> > make a text file - associate it a URL
> >
> > when a user comes along, have a PHP script on top of the web page to
> >
> > 1. open the text file
> > 2. counter = counter +1
> > 3. write update
> > 3.5 print number of hits somewhere on webpage
> > 4. close file...
> >
> > Shahmat Dahlan wrote:
> > >
> > > I'd like to do a counter with PHP, how do you do this? I thought maybe I
> > > could either use cookie or session or session? Which should I use ?
> > >


-- 
Leo G. Divinagracia III
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access counter

[Shahmat Dahlan]

If I do the below, like you stated, that means the counter will update
everytime a visitor refreshes the content.

Would it be possible for the counter script not to increase the value by 1
when a visitor merely refreshes. Is it possible to let the script increase the
value by only by one, only if the the visitor for a new content (by clearing
the cache, e.g.).

Thanks you replying..


"leo g. divinagracia iii" wrote:

> in pseudo-code:
>
> make a text file - associate it a URL
>
> when a user comes along, have a PHP script on top of the web page to
>
> 1. open the text file
> 2. counter = counter +1
> 3. write update
> 3.5 print number of hits somewhere on webpage
> 4. close file...
>
> Shahmat Dahlan wrote:
> >
> > I'd like to do a counter with PHP, how do you do this? I thought maybe I
> > could either use cookie or session or session? Which should I use ?
> >
> > regards and thanks is adnved
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> Leo G. Divinagracia III
> [EMAIL PROTECTED]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access counter

[leo g. divinagracia iii]

in pseudo-code:

make a text file - associate it a URL

when a user comes along, have a PHP script on top of the web page to 

1. open the text file
2. counter = counter +1
3. write update
3.5 print number of hits somewhere on webpage
4. close file...


Shahmat Dahlan wrote:
> 
> I'd like to do a counter with PHP, how do you do this? I thought maybe I
> could either use cookie or session or session? Which should I use ?
> 
> regards and thanks is adnved
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
Leo G. Divinagracia III
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access counter

[Shahmat Dahlan]

I'd like to do a counter with PHP, how do you do this? I thought maybe I
could either use cookie or session or session? Which should I use ?

regards and thanks is adnved


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access Violation PLEASE HELP.

[PHPFAN]

I have the following setup.

PHP 4.04 running on windows 2000 using SQL Server 7.0

The script runs fine for sometime, then I get the following errors
PHP has encountered Access Violation at 013A2466. So I have to reboot
everytime. This happens
almost every 2 to 3 hours or so. I have to use PHP on windows 2000.

Please help.

Thank you
PHPFAN



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] access to a access db via php

[Matthias Machnik]

Hello NG,
it's the first time I use this NG and I'm not sure whether I'm I right here
or not.
The problem: I'm a beginner in php (just started to read the first
introductions). I created a "guestbook" with FP2000. The entrys where safed
in and shown from a db. FP 2000 nearly created it by itself using asp. The
problem is that my provider doesn't support a db connection via asp. They
told me that php3 is supported. My question: Can I use the created db (where
my guestbook entrys are safed) and edit and show results via php? I think
yes but all tutorials I found about it described a odbc connection and I
think the provider I'm using doesn't support this , too. Is there any
possibilty to work in an access DB without any odbc connection (cause then I
need a server which supports DNS and so on and all Servers I knew are too
expensive for me at the moment). Maybe I can access the db via php like a
text file?
There are many question I have, sorry if this description isn't precise
enough. I'm glad about any hints, comments, suggestions, links or whatsoever
that would help me.
Thanks in advance to read and answer this long posting.
MFG Matthias



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: Command line PHP + DB access

[Dan Fitzpatrick]

Jor,

You will need to have the Informix environment variables defined in your
shell environment:

INFORMIXDIR
INFORMIXSERVER

Make sure that the command line PHP binary you are using is compiled
with Informix support. 

Dan


>Subject: Command line PHP + DB access
>   Date: Fri, 18 May 2001 11:08:17 +0200
>   From: Jordi Campos i Miralles <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
>
>Hello everybody!
>
>I'm trying to access an Informix DB from a PHP script that has to be
>executed from the console with "php -q"...
>
>The script include some libraries I've done, and one of them is used to
>connect to the DB.
>
>Well, when this library is used through a PHP script executed by Apache
>there are no problems,
>
>BUT when the same library is used through a PHP script directly executed
>from the command line, the error:
>
>"Call to undefined function:  ifx_connect()"... appear
>
>So, does anybody know how should I call the PHP script from the command
>line in order to let the database functions work?
>
>Thanks in advance.
>
>jor:)i

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Command line PHP + DB access

[Jordi Campos i Miralles]

Hello everybody!

I'm trying to access an Informix DB from a PHP script that has to be
executed from the console with "php -q"...

The script include some libraries I've done, and one of them is used to
connect to the DB.

Well, when this library is used through a PHP script executed by Apache
there are no problems,

BUT when the same library is used through a PHP script directly executed
from the command line, the error:

"Call to undefined function:  ifx_connect()"... appear

So, does anybody know how should I call the PHP script from the command
line in order to let the database functions work?

Thanks in advance.

jor:)i

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] access Rows

[phobo]

Many of the DBMS's allow you to choose which row to fetch.

Eg with MySQL, you can use mysql_data_seek() (see
http://www.php.net/manual/en/function.mysql-data-seek.php)

Similar equivilents exist for ODBC, MS SQL etc.
Eg: odbc_fetch_row($result, $rownumber);

What is it about row 5 for example that is special ? You should be using the
DBMS to choose the rows ... the WHERE clause of a select is very powerful,
and you could be overlooking something there?

Siggy

- Original Message -
From: "Johannes Janson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 13, 2001 7:40 AM
Subject: Re: [PHP-DB] access Rows


> Hi,
>
> If you exactly know which row you want you could use LIMIT yourRow, 1.
> If you copy the RS into an array first you would have to use a while
> statement
> aswell, or not?
>
> Cheers
> Johannes
>
> ""Mike"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> 9b4e4n$gmh$[EMAIL PROTECTED]">news:9b4e4n$gmh$[EMAIL PROTECTED]...
> > I want to be able to access the rows of a resultset,but I want to
specify
> > which ones.(Lets say $row[5]).Do I have to copy the RS into a seperate
> array
> > first?Most examples enumerate with "while" statements.I dont want to do
> > that.
> > Thanks
> > Mike P
> > [EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] access Rows

[Johannes Janson]

Hi,

If you exactly know which row you want you could use LIMIT yourRow, 1.
If you copy the RS into an array first you would have to use a while
statement
aswell, or not?

Cheers
Johannes

""Mike"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
9b4e4n$gmh$[EMAIL PROTECTED]">news:9b4e4n$gmh$[EMAIL PROTECTED]...
> I want to be able to access the rows of a resultset,but I want to specify
> which ones.(Lets say $row[5]).Do I have to copy the RS into a seperate
array
> first?Most examples enumerate with "while" statements.I dont want to do
> that.
> Thanks
> Mike P
> [EMAIL PROTECTED]
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] access Rows

[Mike]

I want to be able to access the rows of a resultset,but I want to specify
which ones.(Lets say $row[5]).Do I have to copy the RS into a seperate array
first?Most examples enumerate with "while" statements.I dont want to do
that.
Thanks
Mike P
[EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] access insert problem

[Andreas Karajannis]

Fredrik Stark wrote:

> Hi,
> Im using php4.0.3pl1 on a NT5 with an Access 2000 database.
> I use the database to store text and numbers. I just realised that
> the text-field can only store 255 characters so I changed the
> type from "text" to "memo". And now i get "Syntax Error" when
> i try to insert a value to the "memo" field...
> 
> Anyone got a solution?
> 
> /stark

You probably can't pass your value literally. Try using SQL Parameters:



See also the manual entries for odbc_prepare() / odbc_execute().

-Andreas

-- 
Andreas Karajannis
mediaworx berlin  AG

Fon (0 30) 2 75 80 - 266
Fax (0 30) 2 75 80 - 200


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] access insert problem

[Fredrik Stark]

Hi,
Im using php4.0.3pl1 on a NT5 with an Access 2000 database.
I use the database to store text and numbers. I just realised that
the text-field can only store 255 characters so I changed the
type from "text" to "memo". And now i get "Syntax Error" when
i try to insert a value to the "memo" field...

Anyone got a solution?

/stark


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Access & MS SQL idnetical thru ODBC ??

[Andrew Hill]

Siggy,

It should work fine, as long as you use SQL92 syntax (or SQL89, depending on
the ODBC driver).

The only problem comes when you use SQL syntax that Access accepts that is
not really valid in the SQL specification.  I believe 'limit' is one
example, but I'm sure someone will correct me if I am wrong.  I'm also not
sure about 'top'.

I believe you have OpenLink's drivers installed? I'll open up access to an
SQLServer database for you tomorrow if you want to test the relevant queries
yourself.

Let me know.

Best regards,
Andrew
--
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology


On 1/21/01 7:52 PM, "Sigurd Magnusson" <[EMAIL PROTECTED]> wrote:

> I have written a small program which uses ODBC to connect to a Access
> Database. I am simply wanting to know if this would also work with MS SQL
> without any modifications what so ever, or does ODBC not really accomplish
> what it was designed for ?
> 
> The SQL statments used are very simple; the INSERT / UPDATE / DELETE are the
> same syntax as mysql, so i assume would also work under mSsql, and the
> SELECTs, although looking complex, don't perform JOINs or anything (eg: SELECT
> TOP 10 RECORD_NR, StatusField, ExtendedStatusField, PICTURE, SURNAME,
> FIRSTNAME, FORM, DOB, DESTINATION, EXPIRY FROM (SELECT TOP 20 * FROM WELLGIRLS
> ORDER BY RECORD_NR ASC,RECORD_NR ASC) ORDER BY RECORD_NR DESC,RECORD_NR DESC
> ).
> 
> As I dont have access to a MSSQL server, can you someone please validate
> whether all this would work fine with MSSQL, and what problems/benefits (other
> than speed/security) I might have to deal with.
> 
> Siggy
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access & MS SQL idnetical thru ODBC ??

[Sigurd Magnusson]

I have written a small program which uses ODBC to connect to a Access Database. I am 
simply wanting to know if this would also work with MS SQL without any modifications 
what so ever, or does ODBC not really accomplish what it was designed for ?

The SQL statments used are very simple; the INSERT / UPDATE / DELETE are the same 
syntax as mysql, so i assume would also work under mSsql, and the SELECTs, although 
looking complex, don't perform JOINs or anything (eg: SELECT TOP 10 RECORD_NR, 
StatusField, ExtendedStatusField, PICTURE, SURNAME, FIRSTNAME, FORM, DOB, DESTINATION, 
EXPIRY FROM (SELECT TOP 20 * FROM WELLGIRLS ORDER BY RECORD_NR ASC,RECORD_NR ASC) 
ORDER BY RECORD_NR DESC,RECORD_NR DESC ).

As I dont have access to a MSSQL server, can you someone please validate whether all 
this would work fine with MSSQL, and what problems/benefits (other than 
speed/security) I might have to deal with.

Siggy

Re: [PHP-DB] Access 2000 to PostgreSQL

[Larry Rivera]

I belive that Acceess can export to a comma delimited file, so you can do
that then dump it into you new database ;)

- Original Message -
From: "Julio Cuz, Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 3:33 PM
Subject: [PHP-DB] Access 2000 to PostgreSQL


> Hi--
>
> Does anyone have a tutorial or sample commands on how to EXPORT data FROM
> MS ACCESS 2000 to POSTGRESQL?
>
> Thanks!
>
> Julio Cuz, Jr.
> Riverside Community College
> [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Access 2000 to PostgreSQL

[Julio Cuz, Jr.]

Hi--

Does anyone have a tutorial or sample commands on how to EXPORT data FROM 
MS ACCESS 2000 to POSTGRESQL?

Thanks!

Julio Cuz, Jr.
Riverside Community College
[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]