database types for php?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Anyone able to help me out and tell me if there is a
default datafile type installed with PHP? If there is
no default datafile type, what would be the most
common type of datafile and does the server type
matter (ie, IIS / apache) matter in this instance?

Thanks alot for any help.


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 . 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

Re: database types for php?

Quoted text here. Click to load it

Yes, exactly (.dbf, .mdb, .csv, .asc, ...). Thanks for
the correct inference.

Quoted text here. Click to load it

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

Quoted text here. Click to load it

Are you refering to a particular version of IIS?

Thanks much.


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

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:
Quoted text here. Click to load it

Besides PHPMyAdmin I can recommend SQLYog:

It's very extensive and easy to use.


Re: database types for php?

Quoted text here. Click to load it

No - its a programming language.

Quoted text here. Click to load it

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.


Re: database types for php?

nc wrote:
Quoted text here. Click to load it

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.

Quoted text here. Click to load it

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.

Quoted text here. Click to load it

The database management system most commonly used with PHP is MySQL.

Quoted text here. Click to load it

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.

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

Site Timeline