PHP和Access数据库 [英] PHP and Access databases

问题描述

你好


我是一名网页设计师，他正在慢慢地想要了解更多关于网页的信息。
开发。我有一个客户想要使用数据库驾驶他们的网站

，所以我现在处于完美状态，以提高我的

技能。


我对数据库或脚本语言有一点了解

将它们连接到网页（这是正确的术语吗？！）但我是

决心提高我在这方面的技能。


但是，我有一些约束：


我对数据库的了解很少访问所以我

如果可以的话，我更愿意使用它。我玩过MySQL但看到

因为我是新手，我觉得使用起来有点棘手。


另外，我的所有客户都使用unix服务器所以，经过一番研究，我得知结果是PHP是我唯一的选择 - 这是

正确的假设吗？

所以，我的主要问题是：我可以一起使用Access和PHP吗？而且，如果

我可以，任何人都可以推荐一本很好的教程/书籍，我可以按照

开始吗？


提前感谢您提供给我的任何帮助。


Jo

解决方案

Jo写道：

所以，我的主要问题是：我可以一起使用Access和PHP吗？而且，如果我可以，有人可以推荐一本很好的教程/书，我可以跟着我开始吗？

我已经从来没有将两者结合使用，但使用

ODBC不应该是一个问题。 Windows PHP声称内置了ODBC，所以应该很容易

足够 - 函数记录在
http://uk.php.net/odbc 。我不知道有关于此的任何教程，但

a快速谷歌显示有相当多的人试过这个组合。


Luke

Jo写道：

你好

我是一名网页设计师，正在慢慢地尝试了解有关网站开发的更多信息。我有一个客户想要使用数据库来驾驶他们的网站，所以我现在处于完美的状态，以提高我的技能。

我对数据库有一点了解或者将它们连接到网页的脚本语言（这是正确的术语？！）但我决心提高我在这方面的技能。

然而，我有一些约束：

我对数据库的了解很少以Access为中心，所以如果可以的话我宁愿使用它。我玩过MySQL，但是因为我是新手，所以我发现它有点棘手。

此外，我的所有客户都使用unix服务器，经过一番研究后，我得出的结论是PHP是我唯一的选择 - 这是正确的假设吗？

所以，我的主要问题是：我可以一起使用Access和PHP吗？而且，如果我能，我可以推荐一本很好的教程/书籍，我可以按照这个来开始吗？

提前感谢您提供给我的任何帮助。

Jo

很久以前使用过访问权限，我肯定知道你可以阅读

SQL查询完美。

知道这一点我肯定建议你把PHP和MySQL作为数据库来看看。

你想的并不是那么难，只是带你说出来你的

头，构造它们逻辑然后写你的SQL语句。


/ Andreas


-

Registeret Linux用户＃292411

>我对数据库知之甚少，以Access为中心，所以我

更愿意使用它，如果可以的话。我玩过MySQL但看到
因为我是新手，我觉得使用起来有点棘手。


有一些不错的前端，我建议你在

中查看这些长期运行它会更有利。访问是垃圾:)

此外，我的所有客户都使用unix服务器，所以经过一些研究，我得出的结论是PHP是我唯一的选择 - 这是

没有yuhave其他人，但PHP是更好的他们neway ...我已经使用

可能Fusion，ASP等但总是回去/转换ppl到PHP！

所以，我的主要问题是：我可以一起使用Access和PHP吗？而且，如果我可以，有人可以推荐一本好的教程/书，我可以跟着我开始吗？

但是如果你是受限于访问PHP将通过ODBC工作，因为

somone建议...我已经完成了这个但是网络服务器是在Windows上运行Apache / PHP的
机器只需将系统DSN设置为访问数据库...

观察它是否锁定了自己！ - 另一个推理自己的原因是：或者将
推向MySQL或者postgres（这也应该有一些GUI）。


对于mysql gui'' s http://www.mysql.com/downloads/index.html看看

图形客户端还有：


http://mysqlfront.venturemedia.de/in .. .a6a4fbf290d6b6


还有一些基于网络的界面像phpMyAdmin一样，我也建议你这么推荐。

Hello

I am a web designer who is slowly trying to learn more about web
development. I have a client who would like to drive their website
using a database so I am now in the perfect situation to move my
skills forward.

I know a little about databases or the scripting languages that
connect them to web pages (is that the right terminology?!) but I am
determined to improve my skills in this area.

However, I have a few constraints:

The little that I know about databases is centered around Access so I
would prefer to use that if I can. I have played with MySQL but seeing
as I am a novice, I find it a little tricky to work with.

Also, all my clients use unix servers so, after a little research, I
have come to the conclusion that PHP is my only option - is this the
correct assumption?

So, my main question is: can I use Access and PHP together? And, if
I can, could anyone recommend a good tutorial/book I can follow to get
me started?

Thanks in advance for any help you can give me.

Jo

解决方案

Hi,

Jo wrote:

So, my main question is: can I use Access and PHP together? And, if
I can, could anyone recommend a good tutorial/book I can follow to get
me started?

I''ve never used the two together, but it shouldn''t be a problem using
ODBC. Windows PHP claims to have ODBC built in so it should be easy
enough - the functions are documented on
http://uk.php.net/odbc . I''m not aware of any tutorials about this but
a quick google reveals that a fair number of people have tried this combo.

Luke

Jo wrote:

Hello

I am a web designer who is slowly trying to learn more about web
development. I have a client who would like to drive their website
using a database so I am now in the perfect situation to move my
skills forward.

I know a little about databases or the scripting languages that
connect them to web pages (is that the right terminology?!) but I am
determined to improve my skills in this area.

However, I have a few constraints:

The little that I know about databases is centered around Access so I
would prefer to use that if I can. I have played with MySQL but seeing
as I am a novice, I find it a little tricky to work with.

Also, all my clients use unix servers so, after a little research, I
have come to the conclusion that PHP is my only option - is this the
correct assumption?

So, my main question is: can I use Access and PHP together? And, if
I can, could anyone recommend a good tutorial/book I can follow to get
me started?

Thanks in advance for any help you can give me.

Jo

Having used access a long time back, I know for sure that you can read the
SQL queries perfectly.
Knowing this I surely recommend you look into PHP and MySQL as database.
It''s not as difficult at you might think, just take you words out of your
head, contruct them logical and then write your SQL statements.

/Andreas

--
Registeret Linux user #292411

> The little that I know about databases is centered around Access so I

would prefer to use that if I can. I have played with MySQL but seeing
as I am a novice, I find it a little tricky to work with.
There are a few decent front ends, I would reccomend you look into these in
the long-run it''ll be more beneficial. Access is crap :)
Also, all my clients use unix servers so, after a little research, I
have come to the conclusion that PHP is my only option - is this the
correct assumption?
No yuhave others but PHP is the better out of them neway... I have used
Could Fusion, ASP etc but always go back/convert ppl to PHP!
So, my main question is: can I use Access and PHP together? And, if
I can, could anyone recommend a good tutorial/book I can follow to get
me started?

However if you are constrained to Access PHP will work with it thru ODBC as
somone has suggested... I have done this but the webservers was on a windows
machine running Apache/PHP and just set up system DSN to the access DB...
watch oput for it locking itself tho! - yet another reason to push yourself
to either MySQL or postgres (this should have a few GUI''s too).

For mysql gui''s http://www.mysql.com/downloads/index.html look under
Graphical clients and also:

MySQL Front was good

http://mysqlfront.venturemedia.de/in...a6a4fbf290d6b6

And also there is a few web-based interfaces sush as phpMyAdmin which I
reccomend too.

这篇关于PHP和Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！