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

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

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