Re: [PHP-DB] 'htaccess" method : how to modify passwords from PHP scripts ?

Hi, Thank you to everybody who answered my question. Unfortunately, I don't use classes in my php. Here is the solution I actually used : -- -- // Generate new line for username + modified password $line =

[PHP-DB] How to LogOut?

It looks like Logout is the \"Big Problem\"??? As the others has reccomended I\'ve tried using Realm assigning to him time() value.But It works for IE normally but not NS6.1. So can someone give me an advice??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMA

Re: [PHP-DB] Question on how to test a value

Hi, even if there was no data in the price field when the form was submited the $price variable exists and isset($price) returns true. May be you could try !empty($price) instead of isset($price) - Something like. $query7 = !empty($price) ? "INSERT INTO price (itemid, price) VALUES ($itemid, '$pr

[PHP-DB] Anyone got phpdbform working with PostgreSQL?

Hi all, phpdbform appears to be just what I need for some development work but I need to run it with PostgreSQL - I tried modifying the demo include file but I still get a connect MySQL error on phpdbform_db . . Has anyone got phpdbform files that are already working with PG? I registered on

[PHP-DB] Re: report style printing

Sommai Fongnamthip wrote: > > Hi, > When I retrieve data to display on web with PHP, it can print out from web > in Browser Stlye. How could we have some PHP code to retrieve current > display data into PC and print it with some Custom Report Style? > > Sommai Fongnamthip I'm currently

[PHP-DB] OCI Persistent Conncetion - how is shared?

A question... How is shared the connection with oracle db by using OCIPLogon() function? - One for each child web processes - One for all child web processes thanks cristiano -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comman

Re: [PHP-DB] report style printing

I'm confused - what do you mean? When you use the terms "Browser Style" and "Custom Report Style" are you referring to style sheets, a property of a particular browser, or what? If style sheets, keep in mind that different browsers react in unique ways to style sheets. As I understand PHP yo

[PHP-DB] simple database question

ok this should be an easy one, i am just blanking on it here. i want to link two tables together, a user table and address table. i create the user entry first, then create the address entry. after creating the address entry how do i get the auto_id that was entered in to enter it into the user t

RE: [PHP-DB] simple database question

What I usually do is do a SELECT COUNT(user_primary_key_column_name) and count the number of rows - then I'll know what the last autonumber added was. A more accurate way is to do your INSERT statement, then follow it immediately with a SELECT select uid,name,address1,phone from users where name

RE: [PHP-DB] simple database question

Hi Brian, Are you using MySQL? If so, you can use the function mysql_insert_id(). http://www.php.net/manual/en/function.mysql-insert-id.php That will give you the last id inserted by MySQL which you can use in the address table. Josh Hoover KnowledgeStorm, Inc. [EMAIL PROTECTED] Searching fo

[PHP-DB] Re: simple database question

oh, using ms sql "Brian Weisenthal" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > ok this should be an easy one, i am just blanking on it here. > > i want to link two tables together, a user table and address table. i create > the user entry first, then c

RE: [PHP-DB] Re: simple database question

Oops sorry I keep assuming this is a MySQL/PHP list! D'oh! Dave -Original Message- From: Brian Weisenthal [mailto:[EMAIL PROTECTED]] Sent: 26 July 2001 15:08 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: simple database question oh, using ms sql "Brian Weisenthal" <[EMAIL PROT

RE: [PHP-DB] simple database question

OK, you're using SQL Server, right? Try executing this statement after you insert the user and before you try inserting the address record: select @@identity That should give you the last inserted id, assuming it's an identity column. Josh Hoover KnowledgeStorm, Inc. [EMAIL PROTECTED] Searchi

[PHP-DB] mysql query problem

I'm trying to query my database to fill in data First Name Last Name. Using the script below I get (depending on the ContactID I enter) Contact: 1 1 or 2 2 If ContactID=0 I get Contact: Any ideas on what I am doing wrong? Thanks. Steve Fitzgerald \n", mysql_result($result,"LastName"));

[PHP-DB] PHP and Informix installation

Hi, I installed php y my UNIX SCO Openserver and it works fine. Now, in the same server is installed the Informix Online 5.10. I want to access the Informix databases then I run the next commands successfully: cd php-4.0.6 ./configure --with-apache=../apache_1.3.20 --enable-track-vars --with-info

RE: [PHP-DB] mysql query problem

In your query, do you need the single ticks around the $ContactID? Is the ContactID column a char/varchar field which would require the single ticks? I'm wondering if that's causing your problem. Also, what if you do that query via the MySQL client? What do you get then? Josh Hoover KnowledgeS

Re: [PHP-DB] OCI Persistent Conncetion - how is shared?

On Thu, Jul 26, 2001 at 01:18:11PM +0200, cristiano wrote: > A question... > How is shared the connection with oracle db by using OCIPLogon() function? > > - One for each child web processes that's the way it works... tc -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] mysql query problem

ContactID is setup as a tinyint so I dropped the single ticks. No luck. I ran the query in the MySQL client and got the ERROR 1054: Unknown column '$ContactID' in 'where clause'. I know the column ContactID exists. Steve "Josh Hoover" <[EMAIL PROTECTED]> wrote in message E973048AB322D411AE9900

[PHP-DB] Re: Oracle 9i Support

Well I found out that the reason I got the error message was that the --with-oci8 option was looking for libclntsh.so.8.0 I made a symlink of this which pointed to the libclntsh.so.9.0 that comes with oracle 9i. This was enough to fool the configure script and allowed php to compile, but none of

Re: [PHP-DB] Re: Oracle 9i Support

On Thu, Jul 26, 2001 at 01:17:57PM -0500, Lee Whatley (System Admin) wrote: > Well I found out that the reason I got the error message was > that the > --with-oci8 option was looking for libclntsh.so.8.0 > I made a symlink of this which pointed to the libclntsh.so.9.0 that > comes with oracle 9i.

Re: [PHP-DB] Re: Oracle 9i Support

Well, I was able to modify the main configure script and the configure.m4 script in the ext/oci8 directory to detect 9i, and doing so allowed the configure process to complete and php to compile. When I did a phpinfo() command it showed php as having oracle support, but did not list anything unde

Re: [PHP-DB] mysql query problem

on 7/26/01 11:11 AM, Steve Fitzgerald ([EMAIL PROTECTED]) wrote: > ran the query in the MySQL client and got the ERROR 1054: Unknown column > '$ContactID' in 'where clause'. I know the column ContactID exists. Of course it did. It can't find the text $ContactID in the table. Try putting in a

Re: [PHP-DB] Re: Oracle 9i Support

On Thu, Jul 26, 2001 at 01:50:37PM -0500, Lee Whatley (System Admin) wrote: > Well, I was able to modify the main configure script and the > configure.m4 script in the ext/oci8 directory to detect 9i, and doing so > allowed the configure process to complete and php to compile. When I > did a phpi

Re: [PHP-DB] Re: Oracle 9i Support

Ok I'm a dumbass :) $ORACLE_HOME was set to mode 770. That seemed to fix the problem. I'll have to do some more stuff besides loging-on to the database to make sure all the functions work right though. When I get some time I'll send you those patches for configure and configure.m4. In the meanti

[PHP-DB] Using PHP/MySQL with IIS and MS Proxy Client

Apparently, php won't connect to MySQL if MS Proxy Client is running. I uninstalled Proxy Client and everything worked fine. However, I need the client for all my other internet apps to work. Does anyone know a work around for this problem?? -- PHP Database Mailing List (http://www.php.net/

[PHP-DB] PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

Here is a patch that will allow configure to properly detect oracle 9i If your mail server filters out attachments you can download it from http://www.cba.ua.edu/~spaff/php-4.0.6-oci8-oracle9i.patch The patch should be applied from directly outside of the php source tree. I am not a coder by any

[PHP-DB] Re: PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

On Thu, Jul 26, 2001 at 04:57:29PM -0500, Lee Whatley (System Admin) wrote: > Here is a patch that will allow configure to properly detect > oracle 9i > If your mail server filters out attachments you can download it from > http://www.cba.ua.edu/~spaff/php-4.0.6-oci8-oracle9i.patch > > The patch

[PHP-DB] (preg_match ?

What's wrong with this use of preg_match? $search = "TheName" $data = "TheName,TheAddress,ThePhone" if (preg_match('"/\b'.$search.'\b/i"', $data)) { echo "True"; } else { echo "False"; } I am trying to see if the search name matches exactly a name in the $data. Thanks Dave -- PHP Database Mai

[PHP-DB] Re: (preg_match ?

This works only if the list is space delimited because of the \b: $search = "TheName"; $data = "TheName TheAddress ThePhone"; if (preg_match("/\b$search\b/i", $data)) { echo "True"; } else { echo "False"; } However as your list is now this works: $search = "TheName"; $data = "TheName,TheAddress,

[PHP-DB] porting from ms sql to mysql

anyone know of a good website for information on taking on the task of porting from ms sql to mysql? -- 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: [EMAI

[PHP-DB] Interbase - transactions that disappear then reappear

Greetings. I have a data-entry web application that runs on: PHP 4.0.5 Interbase 6.01 (open source) Apache 1.3.19 Windows NT Server The users report an unreproducible problem: 1. A record is entered. 2. Some time later (hours, days, weeks), user wished to update record. Yet, record does no

[Fwd: [PHP-DB] How to LogOut?]Still no answer????

Somebody give me a advice??? Original Message Subject: [PHP-DB] How to LogOut? Date: 26 Jul 2001 07:59:29 - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] It looks like Logout is the \"Big Problem\"??? As the others has reccomended I\'ve tried using Realm assigning to him

RE: [PHP-DB] report style printing

i am also a tad confused. i have produced numerous reports in differing formats from PHP and a mysql database, using things such as many figures to calculate hours/dollar value for work in a timesheet format, text-based "comment" reports and simple archive reports for student details, these were a

Re: [PHP-DB] PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

Hi, I have oracle 8i in Linux server. How could I connect it with PHP (on other server)? SF At 16:57 26/7/2001 -0500, Lee Whatley (System Admin) wrote: >Here is a patch that will allow configure to properly detect oracle 9i >If your mail server filters out attachments you can download

RE: [PHP-DB] report style printing

OK. How do I operate when finished generate text file or report file in server? Could I download it and to view / print from client report viewer? Sommai At 09:32 27/7/2001 +0800, Beau Lebens wrote: >i am also a tad confused. >i have produced numerous reports in differing formats from PHP and

Re: [Fwd: [PHP-DB] How to LogOut?]Still no answer????

on 7/26/01 6:25 PM, Ariunbold Gerelt-Od at [EMAIL PROTECTED] wrote: > Somebody give me a advice??? You probably should try your question on the PHP General list: This list should be reserved for messages related to using databases with PHP. Sincerely, Paul Burney

[PHP-DB] ODBC failed

Hi, php 405 IIS 5.0 / W2K MS Access 2000 I had a simple script that will connect to MS Access DB. I had created the DSN and it was tested ok on the dos promopt. When I tested using the IIS, it failed: Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no defau

[PHP-DB] PHP informix function ifx_error problem

when I trying to execute the following php code: and stored procedure is: CREATE PROCEDURE TEST() RAISE EXCEPTION -746, 0, "testing..."; END PROCEDURE I expect to see "testting..." but see nothing :-( After some debuging I found out that while sqlca.sqlcode is equal -746, sqlca.sqlerrm is em