unix

manvela

Hi,

I would like to know if php runs in the unix server as it does in Linux server.

Currently, I am planning to create a product table (from the sources of ms-access database) in the website (html format), how can php help in this? What are example scripts for the newbie?

bastien

yes php will run the same on the unix as linux...one of the nice things is that for the most part PHP is platform independant...excluding certains windows functions like COM

might have trouble with access on unix...usually a win32 platform program...consider switching to mysql...better db anyway

manvela

Hi, again,

For mysql, I don't have much idea. I have only applied asp (sample script) with the ms-acccess database on the webpage.
If not MS-Access, what type of tools I should use when I design the database with php in unix platform? For example, ms-word, excel, ....??? Or I don't need them at all. Instead I should input the database details inside the php script.

As I understand the workflow of asp, the developer can manage the dataabase at the ms-access only. Then asp script can connect the field of the asscess database to the html page.

However, what is the case about php? What does mysql do on the part of database? Waiting for your professional advice.

Thank you & regards,

greg252

(whistle!)
We have a long journey ahead of us.
Forget MS Access- according to the MS SQL handbook, Access is NOT a dedicated db system and should not be used as such. It is better suited for 1 client and simple design work.

MYSQL is a db server. Check out www.mysql.com for more into. If you want a more graphical tool to work with MYSQL, take a look at phpmyadmin.
Which brings us to PHP (www.php.net).
PHP is a programming language with built-in functions to connect to MYSQL db's and is very suited to web programming in that you can embed HTML within PHP.

Read through the mans and try to get these tools to do what you want.

If you get stuck, do a search on this site. If you can't find the answer, post your question AND the code and I'm sure one of the great people on this board will help.

Best of luck.

greg252

I have to ask, and I am not being mean, I just need to know if you have any db experience? Any server-side scripting experience? HTML?

From what I can tell from your post, you are thinking about this wrong.
The DB runs as a service at root level (though not root user). You design a database/tables with phpmyadmin (it's the best I have found). Then, you create a script to connect to the DB and display the results in HTML.

Database design is an art form in itself and takes quite a long time to master. PHP is a very rich programming language that takes not only time but practice. Then you have to learn SQL -> the language of database systems.
There is no easy way to program for the web effectively without learning these technologies.
Read the mans!

{
It doesn't matter if you upload to the same folder because you can point to any folder within a php script.
}

manvela

Thank you for message.

Actually, you have pointed out the reason why I have been in "newbie" forum. The fact is I don't have programming background at all. I am a fair user of html (normally by dreamweaver) and beginner of asp (less than 2 weeks). Anyway, you are right. There is no shortcut if one wanna to be a professional in one field.

Be honest, I like this forum because I am not talking to the air.

Regarding the php, I wonder what I can use to handle the raw data. Like asp, it uses MS-Acccess to store the raw data and asp sql inside the asp script can retrieve the data from the database which is uploaded to the server together. I don't think I should input all raw data inside the php script. Am I wrong again?

bastien

ASP and PHP are similiar languages in terms of scope and ability...PHP is easier to learn, as it is a more mature and fully developed language, though I found ASP quicker to master as I came from a VB background...

ASP and PHP work the same way with databases, both can create SQL statements, then open a connection (PHP handles this better than ASP), runs the query and returns the result...

my advice, given that you don't have much ASP experience, is to stick with PHP. Master it, breathe it and love it...you will find it a much more rewarding experience especially now that ASP is moving to ASP.NET which is an entirely new creature using VB.NET or C# (C sharp) to create the code...

The other thing to consider is that a true ASP IDE will run about $1000 (for visual studio, which includes VB, Visual Interdev(web tool), C++, and MS Java (J++))though there are some good free or cheaper tools out there. PHP has a plethora of IDEs that are availalbe with many being free (PHP Edit amoung others)

hth