database types for php?

Re: database types for php?

I assume you mean by datafile a database?

The most common database used with php is mysql. Linux, Apache, MySQL,
PHP are used so routinely together that the group of technologies sis
simply called LAMP. (might include perl or python as well).

However php 5 does come with a database bundled with it called sqlite.
Docs on this are http://php.net/sqlite. It supports view and
transactions and is actually quite handy.

PHP will work on apache with mod_php and IIS. Most prefer to use php
with apache; I personally would never use php with IIS for a production
environment, mainly because IIS is complete crap and extensive crap at
that. But I know people who have php on IIS and have no problems with
it.

Re: database types for php?

> Anyone able to help me out and tell me if there is a[color=blue]
> default datafile type installed with PHP?[/color]

No - its a programming language.
[color=blue]
> what would be the most
> common type of datafile[/color]

erm....PDf for documents, JPEG/GIF/PNG for images although soem image
types may be happier in a different format (e.g. TIFF for faxes).
Ogg/Mp3/Wav for audio....

Of course there's nothing to prevent you creating your own file format.

I guess it depends what you are trying to acheive.

C.

Re: database types for php?

"Sean" <oreilly.sean@g mail.com> wrote:[color=blue]
>I assume you mean by datafile a database?[/color]

Yes, exactly (.dbf, .mdb, .csv, .asc, ...). Thanks for
the correct inference.
[color=blue]
> The most common database used with php is mysql.
> Linux, Apache, MySQL, PHP are used so routinely
> together that the group of technologies sis simply
> called LAMP. (might include perl or python as well).
>
> However php 5 does come with a database bundled
> with it called sqlite. Docs on this are http://php.net/sqlite.
> It supports view and transactions and is actually quite
> handy.[/color]

The server is running apache with php 4.3. And there's
MySQL there as well. Do you (or anyone else) know
if there's a tool similar to Access for creating visual
links and such when messing with MySQL? If no,
anyone know of any suggested links for getting feet wet?
And possibly something describing the details of how it's
set up, ie database filenames used to store the files, db
file formats, etc. I'd like to get a hold of a file and view
it with a hex-editor. You were right on (target) in your
inferences.
[color=blue]
> PHP will work on apache with mod_php and IIS. Most
> prefer to use php with apache; I personally would never
> use php with IIS for a production environment, mainly
> because IIS is complete crap and extensive crap at
> that. But I know people who have php on IIS and
> have no problems with it.[/color]

Are you refering to a particular version of IIS?

Thanks much.

Ralph.

Re: database types for php?

nc wrote:[color=blue]
>
> Anyone able to help me out and tell me if there is a
> default datafile type installed with PHP?[/color]

No. PHP can be configured to work with ODBC and almost any major
database management system, both commercial (Oracle, SQL Server, DB2,
etc.) and open-source (MySQL, PostgreSQL, SQLite). The key word,
however, is CAN. If you plan on deploying your application on
third-party servers (such as Web hosting services), you need to know
what database connectivity these servers have, because their
administrators will most likely be unwilling to accommodate your
requests for changes in PHP configuration and installing database
servers you want.
[color=blue]
> If there is no default datafile type,[/color]

I think you should change your terminology. "Datafile type" is
something you deal with in desktop databases. When writing PHP
applications, you work with a client-server system, with PHP operating
the client and the database management system working as the server.
SQLite is about the only exception to this rule.
[color=blue]
> what would be the most common type of datafile[/color]

The database management system most commonly used with PHP is MySQL.
[color=blue]
> and does the server type matter (ie, IIS / apache)
> matter in this instance?[/color]

No, as long as PHP is configured correctly. Moreover, PHP and the
database server can even reside on different physical machines under
different operating systems.

Cheers,
NC
[No, this is not a message to myself... :) ]

Re: database types for php?

If you want a visual interface for editing and administrating mysql you
should get phpmyadmin. It's probably one of the best php open source
tools ever, and takes about 3 to 4 seconds to set up. phpmyadmin comes
with help buttons all over the place detailing what things are, what db
types to use and will even format your sql queries into php useable
code.



There are loads of hex editors about there, however if you are looking
for some editor to edit mysql files directly I would strongly suggest
against that.

PHP should run on IIS 3 and up.

Re: database types for php?

Sean wrote:[color=blue]
> If you want a visual interface for editing and administrating mysql you
> should get phpmyadmin. It's probably one of the best php open source
> tools ever, and takes about 3 to 4 seconds to set up. phpmyadmin comes
> with help buttons all over the place detailing what things are, what db
> types to use and will even format your sql queries into php useable
> code.
>
> http://www.phpmyadmin.net/home_page/index.php[/color]

Besides PHPMyAdmin I can recommend SQLYog:


It's very extensive and easy to use.

HTH.
Peter.
--