473,811 Members | 3,220 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

database types for php?

nc
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
Dec 2 '05 #1
6 3633
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.

Dec 2 '05 #2
C.
> Anyone able to help me out and tell me if there is a
default datafile type installed with PHP?
No - its a programming language.
what would be the most
common type of datafile


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.

Dec 2 '05 #3
nc
"Sean" <or**********@g mail.com> wrote:
I assume you mean by datafile a database?
Yes, exactly (.dbf, .mdb, .csv, .asc, ...). Thanks for
the correct inference.
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.
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.
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.


Are you refering to a particular version of IIS?

Thanks much.

Ralph.

Dec 3 '05 #4
NC
nc wrote:

Anyone able to help me out and tell me if there is a
default datafile type installed with PHP?
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.
If there is no default datafile type,
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.
what would be the most common type of datafile
The database management system most commonly used with PHP is MySQL.
and does the server type matter (ie, IIS / apache)
matter in this instance?


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

Dec 3 '05 #5
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

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.

Dec 4 '05 #6
Sean wrote:
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


Besides PHPMyAdmin I can recommend SQLYog:
http://www.webyog.com/sqlyog/download_sqlyogfree.html

It's very extensive and easy to use.

HTH.
Peter.
--
http://www.phpforums.nl
Dec 4 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4383
by: Kunle Odutola | last post by:
I have a database that tracks players for children's sports clubs. I have included representative DDL for this database at the end of this post. A single instance of this database supports multiple clubs. I would like to add support for letting each club define and store custom information about arbitrary entities. Basically, allows the clubs to define custom entities (i.e tables) and associated custom attributes (i.e. fields) that may be...
5
674
by: Don Vaillancourt | last post by:
Hello all, Over the years as I design more database schemas the more I come up with patterns in database design. The more patterns I recognize the more I want to try to design some kind of generic design patterns that can be used and shared amongst many sub-schemas. For example, the grouping of entities. I may have the following tables: employee, product and client. These tables have no direct relationship with each other. But...
6
3040
by: richard.pasco | last post by:
Hey all I am trying to write a script that allows users to search through a database of names. But rather than give a search string and then return all those that match, I would like it to search each time the user types a new letter in the text box. That's badly explained - this example might help! The user types "r" and I displays all the names with r in them. The
5
6578
by: Seok Bee | last post by:
Dear Experts, I currently trying to use the FileUpload control from asp.net 2.0 to upload files. The uploading of the file I would like to store it in the Access Database. Unfortunately, I've no idea how I can do that. Can anyone provide me some solution by writing the code in vb.net? Many thanks in advance. Regards,
2
1319
by: Seok Bee | last post by:
Dear Experts, I'm using the asp.net 2.0 fileupload control to upload files into Access Database. The file types that being uploaded may be in word, excel or image format. Therefore, I would like to seek your help to show me how can I have a link in my webpage to view this file by reading from the database? Your feedback/help is very much appreaciated. Regards,
1
1992
by: Seok Bee | last post by:
Dear Experts, I'm using the asp.net 2.0 fileupload control to upload files into Access Database. The file types that being uploaded may be in word, excel or image format. Therefore, I would like to seek your help to show me how can I have a link in my webpage to view this file by reading from the database? Your feedback/help is very much appreaciated. Regards,
5
5278
by: MadDiver | last post by:
Guys, I need to create an application that handles several product types/ categories. Each product type can have totally different fields to describe it. For instance a car would have Year, Make, Model, and Miles, whereas a house would have Year, Address, SQ Feet, Amenities, etc. These are just examples but you get my drift. the application needs a form to input, show and search the data for
0
1182
by: jehugaleahsa | last post by:
Try this instead: // T - the type you are attempting to retrieve. // o - the data that you want to turn into a T T get<T>(object o) { // handle nulls - turns Nullables into null, reference types to null and value types to 0. if (o == null || o == DBNull.Value) {
4
1669
by: jehugaleahsa | last post by:
Hello: Say I were to query the schema tables from a database management system. Say I got a DataType field that held the string 'VARCHAR2'. Now, I know that VARCHAR2 associates to System.String. However, different DBMSs have different types and worse, even some with the same type turn out to be different .NET types. I would like DMBS-independent way of getting a .NET type from a DataType string. Now, I have existing code that gets the...
0
16383
debasisdas
by: debasisdas | last post by:
DATABASE LINK =============== A database link is a path through which a remote user in another database can connect to any other database. Once created database link exists as an object in the user schema. DATABASE LINK -3 TYPES ======================= PRIVATE--DEFAULT--A PRIVATE DBLINK IS ONLY AVAILABLE TO THE USER WHO HAS CREATED IT.IT IS NOT POSSIBLE FOR A USER TO GRANT ACCESS ON A PRIVATE DBLINK TO OTHER USERS. ------- PUBLIC--IT...
0
9605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10651
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10403
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7671
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6893
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5555
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5693
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4341
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3020
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.