RE: [PHP-DB] Apache configuration on Win32

2001-01-15 Thread Jon Haworth

From my Apache config:

LoadModule php4_module d:/php/sapi/php4apache.dll
AddType application/x-httpd-php .php .php4

I have 1.3.14 running on NT4, but this should work for you too. Change the
path in the first line to point to wherever your dll is.

HTH
Jon



| -Original Message-
| From: Andris Jancevskis [mailto:[EMAIL PROTECTED]]
| Sent: 15 January 2001 12:54
| To: [EMAIL PROTECTED]
| Subject: [PHP-DB] Apache configuration on Win32
| 
| 
| Hi,
| 
|   I have problems to configure Apache 1.3.12 to work with 
| php4.0.2 on winnt4.0
|   workstation. In Readme.txt I found instructions only for 
| IIS and PWS.
| 
|   Could you tell me what shpuld I need to add to httpd.conf?
| 
| Thanx,
| Andris Jancevskis
| 
| 
| 
| -- 
| PHP Database Mailing List (http://www.php.net/)
| To unsubscribe, e-mail: [EMAIL PROTECTED]
| For additional commands, e-mail: [EMAIL PROTECTED]
| To contact the list administrators, e-mail: 
| [EMAIL PROTECTED]
| 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Linked Tables Problem

2001-01-15 Thread Stas Trefilov

Hello, Justin Smith!
You wrote:

 It's definitely a security issue, not allowing access to 
 the linked tables
 in a database with its own security even though the 
 database I'm connected
 to via ODBC has full access.  Any tips on how to get 
 around this?  Any help
 would be greatly appreciated.
 

Your script must be running under IUSR_host account. Does 
it have network permissions? You can also try to relink 
tables in your .MDB using full paths (I mean 
\\server\share\table.dbf)

HTH

-- 
Piloteers do it on the road


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] ENUM type

2001-01-15 Thread Paul DuBois

At 9:49 PM +0700 1/15/01, Cahyo S. Aji wrote:
I don't know what is the benefit if we use ENUM type.
can everybody explain it?

Examples:

It looks like a character column, but it's represented as an integer,
so operations on it can be quite fast.  The numeric representation
also takes less space, in most cases.

By using it, you make the legal values for a column explicit in the
column definition.

You can look up the legal values for the column from within programs.
For example, you can parse SHOW COLUMNS LIKE 'col_name' output to get
the legal enumeration values, then use them to construct a set of
radio buttons or a popup menu in a web form. That way your form always
presents exactly the legal options for the column.

You can also use the column definition when validating submitted forms
to make sure the value submitted is legal.

-- 
Paul DuBois, [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Transactions. How?

2001-01-15 Thread Stas Trefilov

Hello, "Marko Perich"!
You wrote:

 I need to make a transaction over several pages and 
 commit it after
 validating the last one.

Insert line on the first page, update on next, mark as 
commited on the last. Each hour drop uncommited lines. You 
may also provide current time of transaction start when 
inserting on 1st page to prevent uncommited transactions 
that are in progress (started in last 10 minutes).

-- 
Piloteers do it on the road


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] exporting databse from oracle to msql

2001-01-15 Thread Stas Trefilov

Hello, sajid jamal!
You wrote:

 can anyone help me out ,in how to export my oracle
 databse i.e sql to mysql database.

Use Oracle Export tool to produce a text datafile, then 
load it to MySQL with its import command. Look docs for 
syntax of both commands.

-- 
Piloteers do it on the road


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] another dumb newbie question - backslash before single quote

2001-01-15 Thread Timothy Wright

Hello -

I have set up a calendar database with MySQL and PHP that uses simple text
and tinytext fields for events and event descriptions.  The problem is,
whenever I enter an event that uses an apostrophe ( St. Patrick's Day) or a
description (4 o'clock) it stores and returns ( St. Patrick\'s Day) from the
database.  Any suggestions?

Thanks in advance,

Tim Wright

:::
::: :::
:::   Timothy Wright:::
:::   mailto:[EMAIL PROTECTED]   :::
:::   Digital Network Enterprises   :::
:::   http://www.01network.com  :::
::: :::
:::   secure e-mail by request  :::
:::   (PGP signature and/or encryption) :::
:::


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] another dumb newbie question - backslash before single quote

2001-01-15 Thread Kevin McCarthy

store the value in a named variable, then call the variable with the 
stripslashes() function before inserting it into the DB.
a la:

$event = "St. Patrick's Day";
$event = stripslashes($event);

insert table values('$event'); 

At 02:13 PM 1/15/2001 -0500, Timothy Wright wrote:
Hello -

I have set up a calendar database with MySQL and PHP that uses simple text
and tinytext fields for events and event descriptions.  The problem is,
whenever I enter an event that uses an apostrophe ( St. Patrick's Day) or a
description (4 o'clock) it stores and returns ( St. Patrick\'s Day) from the
database.  Any suggestions?

Thanks in advance,

Tim Wright

:::
::: :::
:::   Timothy Wright:::
:::   mailto:[EMAIL PROTECTED]   :::
:::   Digital Network Enterprises   :::
:::   http://www.01network.com  :::
::: :::
:::   secure e-mail by request  :::
:::   (PGP signature and/or encryption) :::
:::


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Kevin McCarthy  Body  Soul
http://www.bodynsoul.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] hello

2001-01-15 Thread MacBane

Has anyone got some code to display the first say 15 records from a query
then get the next 15 then next for a mysql database



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]