database types for php?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • nc

    database types for php?

    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.

    Ralph


  • Sean

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

    Comment

    • C.

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

      Comment

      • nc

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



        Comment

        • NC

          #5
          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... :) ]

          Comment

          • Sean

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

            Comment

            • Peter van Schie

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

              Comment

              Working...