NEOHAPSIS - Peace of Mind Through Integrity and Insight

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com

Neohapsis > Archives > PHP Discussion Digest> 2001-03

From: php-general-digest-helplists.php.net
Date: Thu Mar 22 2001 - 10:38:22 CST

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php-general Digest 22 Mar 2001 16:38:22 -0000 Issue 582

Topics (messages 45071 through 45136):

Installing PEAR
45071 by: RalphGzman.aol.com
45081 by: Paul rees

How to delete a row from MySql
        45072 by: YoBro
        45073 by: Peter Houchin
        45086 by: Jeff Armstrong

Re: IBill - Can you recommend a script?
45074 by: Rick St Jean

Web Directory
45075 by: toto

Passthru Question
45076 by: Michael Bartlett

Errors caused by php or apache(or buggy explorer)?
45077 by: Vidar Tyldum

big problem
45078 by: Salim Meethoo
45082 by: Tobias Talltorp

Re: file height and width
45079 by: Kazazic Almir

Re: linking classes together
45080 by: Stewart Taylor

PAM authentification
45083 by: Daniel Svensson, Coretrek

dbm support broken? Please help!
45084 by: AK47

Re: Simple question about mail() limitations (if any :)
45085 by: Greig, Euan

XML Problems
45087 by: Niel Zeeman

Oracle, Win2000, Apache, OCI
45088 by: Greig, Euan
45117 by: Brooks, Ken

Re: Ack! Cookie Problems!
45089 by: Jeff Armstrong

Re: Getting a header without ANY mime type
45090 by: Christian Reiniger
45136 by: Spunk S. Spunk III

Re: trim string - try array/join()
45091 by: Jeff Armstrong

Re: files with html extension
45092 by: Harshdeep S Jawanda
45101 by: Jeff Armstrong

please help with this simple problem
        45093 by: adam
        45095 by: Stewart Taylor
        45100 by: adam
        45104 by: rui.websolut.net
        45105 by: Stewart Taylor
        45106 by: adam
        45107 by: adam

Re: Booking by Date/Time in mySQL
45094 by: Jeff Armstrong

multiple selection dropdown lists
45096 by: Angie Bauer
45099 by: Stewart Taylor

Re: URIs as variables
        45097 by: Issac Goldstand
        45102 by: rui.websolut.net
        45103 by: Jeff Armstrong

Re: Lostpassword script Error
45098 by: techzeus.pacific.net.sg

Only 5 lines
        45108 by: Dennis Haller
        45109 by: Michael Bartlett
        45110 by: Michael Bartlett
        45112 by: Dennis Haller

Only 5 lines (now with the right script :/ )
        45111 by: Dennis Haller
        45120 by: Jack Sasportas
        45128 by: Dennis Haller

Free Web Space
        45113 by: PIS Alaiddin Tayeh
        45115 by: Jon Haworth
        45123 by: Philip Olson

Re: try catch in php?
45114 by: elias

LDAP problem
45116 by: Kazazic Almir

Oracle ODBC sql [ORA-00972: identifier is too long]
        45118 by: Brooks, Ken
        45119 by: Greig, Euan
        45121 by: Brooks, Ken
        45125 by: Brooks, Ken
        45127 by: Brooks, Ken

Form help
        45122 by: Good Fella
        45124 by: Jon Haworth
        45126 by: Philip Olson
        45130 by: Jon Haworth
        45131 by: Rick St Jean

regexp on us tele number
45129 by: Kurth Bemis

Unwanted signs!
        45132 by: Brian Rosenkrantz
        45133 by: Stewart Taylor
        45134 by: Philip Olson

True64 installation
45135 by: John Tran

Administrivia:

To subscribe to the digest, e-mail:
php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
php-generallists.php.net

----------------------------------------------------------------------

attached mail follows:

Ok, IM a bit confused as to how PEAR is installed. I read through the README file in the php source but found no explanation.

I am tryin to use the PEARs DB abstracion. I have DB.php and DB/ in /usr/local/lib/php. I added: 'include_once(DB/mysql.php);' to the top of my script but it failed since it is not finding it. Do I need to assign a path in the php.ini file or have I missed an installation step?

Can somebody please explain or point me to some docs on how I get up and going with PEAR.

Thanks.

attached mail follows:

In article <11.1177ad96.27ead90baol.com>, RalphGzmanaol.com writes
>Ok, IM a bit confused as to how PEAR is installed. I read through the README
>file in the php source but found no explanation.
>
>I am tryin to use the PEARs DB abstracion. I have DB.php and DB/ in
>/usr/local/lib/php. I added: 'include_once(DB/mysql.php);' to the top of my
>script but it failed since it is not finding it. Do I need to assign a path in
>the php.ini file or have I missed an installation step?
>
>Can somebody please explain or point me to some docs on how I get up and going
>with PEAR.

Hi,

Try something like:

<?php
require_once ('DB.php');

// connection
$db_type = "mysql"; // type of database - must correspond to a PEAR type
$db_user = "user"; // database access username
$db_pswd = "password"; // database access password
$db_host = "localhost"; // hostname of database
$db_name = "you_db_name"; // database name

$db_connectString = "$db_type://$db_user:$db_pswd$db_host/$db_name"; // the above,
collected here for convenience

$usePersistentConnects = true; // true - uses persistent connects to the database
(always leaves a link open, false - not)

if (! $db_con)
$db_con = DB::connect ($db_connectString, $usePersistentConnects);

$sql = "SELECT column FROM $tableName WHERE whatever = '$whatever'";

if (DB::isError ($result = $db_con -> query ($sql)))
        handle_db_error ($result);
else
        $resultArray = $result -> fetchRow (DB_FETCHMODE_ASSOC);

$db_con -> commit();

if ($db_con && (! $usePersistentConnects))
$db_con -> disconnect();

?>
I hope the line wraps still leave the above readable.

I made a separate function of my own, handle_db_error (), to handle errors - you
might like to do something like:

echo DB::errorMessage($result);

... instead.

I recommend putting all the db connection stuff in a file which resides outside of
the document root and including it where you need it.

The following links may prove useful - the user comments in the phpbuilder article
were particularly helpful in pointing me in the right direction.

http://cvs.php.net/viewcvs.cgi/php4/pear/DB/
http://www.phpdoc.de/pear/index2.html
http://www.phpbuilder.com/columns/allan20010115.php3
http://pear.php.net
http://www.php.net/manual/en/pear.php

All the best,

-- Paul Rees

Web Application Programmer/Developer

surfEU.com GmbH

attached mail follows:

Hello,

Does anybody know how to make a text link delete items from a MySql Database.

I have a PHP page that reads from the database and displays the results, but i want to include an option at then end of each row to delete that information. Alot like in phpMyAdmin. I have looked at that code, but can't figure it out.

Any help on this would be really great.

-- Regards,

YoBro ------------------------------------------------------------- DO NOT REPLY TO THIS VIA EMAIL PLEASE USE THE NEWSGROUP All emails sent to this address are automatically deleted. This is to avoid SPAM! -------------------------------------------------------------

attached mail follows:

db connection here

if ($delete){ $rs = "DELETE FROM users WHERE id=$id";

$result = mysql_query($rs);

echo "<font face=\"Helvetica, sans-serif\" size=\"3\" color=\"#003399\">Record Deleted <P> "; }

$id = $myrow["id"]; printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a></td></tr>", $PHP_SELF, $myrow["id"]);

-----Original Message----- From: YoBro [mailto:nospambrochures.co.nz] Sent: Thursday, March 22, 2001 3:29 PM To: php-generallists.php.net Subject: [PHP] How to delete a row from MySql

Hello,

Does anybody know how to make a text link delete items from a MySql Database.

Any help on this would be really great.

-- Regards,

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

curious of Hither Green writes:

> printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a></td></tr>", $PHP_SELF, $myrow["id"]);

Is there a reason why you're not using interpolation? This looks simpler to me, and I thought that a lot of effort went into optimising PHP interpolation.

echo "<A HREF='$PHP_SELF?id=$myrow[id]&delete=yes'>Delete $myrow[id]</A>";

cheers, Jeff

-----Original Message----- From: Peter Houchin [mailto:peterhvfsa.com.au] Sent: Thursday, March 22, 2001 4:38 AM To: YoBro; php-generallists.php.net Subject: RE: [PHP] How to delete a row from MySql

db connection here

if ($delete){ $rs = "DELETE FROM users WHERE id=$id";

$result = mysql_query($rs);

echo "<font face=\"Helvetica, sans-serif\" size=\"3\" color=\"#003399\">Record Deleted <P> "; }

$id = $myrow["id"]; printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a></td></tr>", $PHP_SELF, $myrow["id"]);

-----Original Message----- From: YoBro [mailto:nospambrochures.co.nz] Sent: Thursday, March 22, 2001 3:29 PM To: php-generallists.php.net Subject: [PHP] How to delete a row from MySql

Hello,

Does anybody know how to make a text link delete items from a MySql Database.

Any help on this would be really great.

-- Regards,

attached mail follows:

We have dealt a lot with iBill. They are great. The best interface to them that I know of is the opayc solution from Inline. The advantage is you will be able to do charge backs and the solution can be ported to any platform. php, CF, vb. Also opayc will handle the updates to the api, if it changes. You just download the new dll.

At 07:17 PM 3/21/01 -0800, you wrote: >I have a client who wants to set up iBill. Has anyone had any good >experiences with any of the commercially avaliable or open source iBill >administration scripts out there? Good Bad or Otherwise, please let me know. > >Many thanks for any light you can shed on this topic. > >Matt Friedman > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

########################################################## # Rick St Jean, # rstjeaninternet.look.ca # President of Design Shark, # http://www.designshark.com/ # Quick Contact: http://www.designshark.com/messaging.ihtml # Tel: 905-684-2952 ##########################################################

attached mail follows:

Hi all,

can some body tell me where can i find articles and technical support about develop web directory ?

thanx.

-toto-

attached mail follows:

Hi all,

Having a weird problem running the passthru() function on quite an old version of PHP3 (3.0.7). Pasted below is the php source code:

=============================== <HTML> <HEAD> <TITLE>Tape Status Check</TITLE> </HEAD> <BODY> if this page is blank - that is good!

passthru ('/usr/bin/mt rewind',$res); echo $res; ?> ===============================

When I run this in a shell (as the apache user as well!) it works perfectly as illustrated below:

=============================== su-2.03$ /usr/local/bin/php index.php3 Content-type: text/html

<HTML> <HEAD> <TITLE>Tape Status Check</TITLE> </HEAD> <BODY> if this page is blank - that is good!

mt: /dev/nrsa0: Device not configured ===============================

When I run this in apache by accessing the URL, I get (pasted HTML from view-source):

=============================== <HTML> <HEAD> <TITLE>Tape Status Check</TITLE> </HEAD> <BODY> if this page is blank - that is good!

1 ===============================

As you can see, its not outputting the passthru output stuff. Any ideas?

Mike

attached mail follows:

I'm having some trouble with apache+php4. Sometimes when i access my very simple php-site, not everything gets parsed, some things just get printed..

For instance, my tables sometimes gets freaked an IE shows me the tags [<table bla bla bla]. I rarely experience this elsewhere on the web, so i kinda doubt it is IE's fault.

Could it be apache or php? If so, how can I correct this problem? Using Apache 1.3.17 and PHP/4.04.pl1.

Thanks, Vidar Tyldum

attached mail follows:

hello there, can somebody help me out with my scripts while running this: <? .................................. $myfile = fopen("data.txt","w"); .........................................etc; ?> i get the following error message: Warning: fopen("compteur","w") - Permission denied in cmguestcount.inc.php3 on line 11 i'm using php3 and this scripts are for a counter of my page . thanks Salim

attached mail follows:

You need to set the permissions in that folder so that you can write. PHP acts like IUSR(computernmae), so set IUSR(computername) permission to write. This is Windows, by the way...

// Tobias

""Salim Meethoo"" <salimalienworkers.com> wrote in message news:99c90k$83u$1toye.p.sourceforge.net... > hello there, > can somebody help me out with my scripts while running this: > <? > .................................. > $myfile = fopen("data.txt","w"); > .........................................etc; > ?> > i get the following error message: > Warning: fopen("compteur","w") - Permission denied in cmguestcount.inc.php3 > on line 11 > i'm using php3 and this scripts are for a counter of my page . > thanks > Salim > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

if it is about logos and stuff that may be changed put it simply in a include and include it from all over or make a function and call it -almir

-----Ursprüngliche Nachricht----- Von: darion mapp [mailto:godd_mapplycos.com] Gesendet: Mittwoch, 21. März 2001 23:05 An: almir Betreff: Re: [PHP] file height and width

I think that the DB approach is not bad at all. It allows you to format your page quite easily and create different formatting for different sections of your site with great ease.

How ever where the work comes is in the geration of the page. You will have to echo the height and width to ensure that it is done. The name if the image can also be done that way. This allows you to maintain things like a company logo file with ease.

pluse adding a new page becomes easier once you take a modular approah to it.

suggestion:

<img src="<?php echo "$imglocation" ?>" height="<?php echo "$height" ?>" ......

now that SHOULD work provided that you get the data from the DB and place them in their variables as needed.

you can even use arrays to hold all that data and echo what is needed by using a dumy variable to hold the index that you would like to echo.

Any problems you can contact me

--
On Wed, 21 Mar 2001 22:57:24  
 almir wrote:
>1) why put it into db , i dont think it is good idea to do it, put it in
>file sytem , check it with image funrtions and than do what you want to or
>even easier use stiles to format it with html so that it doesn4t metter how
>big file actualy is
>
>-almir
>
>
>""george"" <chiefmonkeywisemonkeydesign.co.uk> schrieb im Newsbeitrag
>news:99akou$rsc$1toye.p.sourceforge.net...
>>
>> Chris,
>>
>>                It's going straigt into a db and is then pulled out and
>> displayed on the page. I want the image to be a specific size.
>>
>> Thanks
>>
>> george
>>
>>
>>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: php-general-unsubscribelists.php.net
>> For additional commands, e-mail: php-general-helplists.php.net
>> To contact the list administrators, e-mail: php-list-adminlists.php.net
>>
>
>
>
>-- 
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-general-unsubscribelists.php.net
>For additional commands, e-mail: php-general-helplists.php.net
>To contact the list administrators, e-mail: php-list-adminlists.php.net
>
>
Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html

attached mail follows:

Your need to define $db as a property of your sessions class. e.g.

class sessions { var $db; function sessions { $this->db = new mysql_connect; }

function testprint() { $this->db->connect() } } $sess = new sessions; $sess-> testprint();

-----Original Message----- From: Tobias Talltorp [mailto:tobiastalltorp.com] Sent: 21 March 2001 22:38 To: php-generallists.php.net Subject: [PHP] linking classes together

I have two classes, one with mysql-connections and one with session-stuff. The session-class relies on the mysql to check if the user is registered and such.

What is the proper way to connect/link these classes together?

I got it working if I created a $db = new mysql_connect; in the function, but there are other functions that need to be able to connect to a database aswell. Putting the $db = new mysql_connect; in the constructor did not work. (See code below)

// This works ---> class sessions

function testprint() { $db = new mysql_connect; $db-> connect() } } $sess = new sessions; $sess-> testprint();

// This does not work --> class sessions { function sessions { $db = new mysql_connect; }

function testprint() { $db-> connect() } } $sess = new sessions; $sess-> testprint();

Any thoughts? // Tobias

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Hi there!

I wonder if there is someone out there who can help me out with some advices regarding authentification with PAM (Pluggable Authentication Modules) using PHP.

The main reason for using PAM is that I want to connect to Novell NDS/eDirectory to get info about a user based on a supplied username and password. This info will then be presented to the user on a web page when they are logged in.

We are currently running freeBSD on our webservers, but may consider to set up a machine with Linux if necessary.

So, if any of you people could help me out here, that would be really appreciated!

/Daniel

attached mail follows:

I'm trying to build php 4.0.4pl1 with dbm support on my RedHat Linux 6.2 box. I need it to be able to work with apache 1.3.14 mod_auth_dbm. Each time I run:

./configure \ --with-zlib=shared \ --with-xml=shared \ --with-gd=shared \ --with-interbase=shared \ --with-db \ --enable-dba=shared \ --with-dbm \ --with-gdbm \ --with-ndbm \ --with-db2 \ --with-imap=shared \ --with-openssl=/usr \ --with-config-file-path=/etc/httpd/conf \ --enable-versioning \ --with-apxs=/usr/sbin/apxs \ --enable-memory-limit \ --enable-trans-sid \ --enable-sysvsem \ --enable-sysvshm \ --enable-gd-imgstrttf \ --enable-track-vars

I get the following error:

configure: error: cannot find necessary header file(s)

If I remove the line "--with-dbm" everything works fine. What should I do or what should I need to build dbm support into php?

I need "dbm", since looks like other formats are not compatible with mod_auth_dbm (and ... Yes, dbmmanage works fine).

Thanks

P.S.

I've also tried with php-4.0.5RC1 but the result was still the same.

attached mail follows:

< on IIS it is much better solution for more than few mails is to put them < simply in pickup directory of smtp server, I am also sure that there is a < similar possibility on linux

How can I identify the location of the pickup directory for the smtp server (on NT)?

Euan Greig Technical Consultant BRANN DATA euan.greigbrann.com 01285 645997

************************************************************************** Any opinions expressed in this email are those of the individual and not necessarily the Company. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.

**************************************************************************

attached mail follows:

Hi Folks Has anyone had problems with thej xml parser causing an Internal server error?

I'm running IIS5 with the ISAPI module

Thnx

attached mail follows:

< I have seen -many- messages and spent an entire day reading, and haven't < found < what I'm looking for so i hope this is the correct place to ask.

< When I try to make an ora_logon or ocilogon, I get < the error: Fatal error: Call to undefined function: ora_logon()

< Is this an incorrect PHP setup or is this due to the fact that I don't have < Oracle 8.1.6 installed? < (I have 7.x)

< I have uncommented the php_oracle and php_oci8.dll lines in the php.ini < file. Do I need to do more than that? < (I am using the latest php4 windows binary).

I too have had a lot of "fun" with this. I seem to have finally got it cracked, with help from this list, and from searches on the web.

First, have you checked the setting of your extension directory in php.ini? It should point to the location of php_oracle.dll etc.

I think there is something about the distribution of php from php.net that doesn't enable oracle properly. Try downloading it from http://php.weblogs.com/easywindows.

The following post (from this list) may help with your next problem! ie Net80/SqlNet. It also helps to install at least the client software for Oracle 8.1.6. I have successfully connected to a 7.3.4 database using ora_logon, but haven't tried ocilogon, as I think this is intended for v8.

From: Leon Santos Filho [mailto:leonrosch.com.br] Sent: 13 March 2001 16:15 To: Herbert Groot Jebbink; php-windowslists.php.net Subject: Re: [PHP-WIN] Can't connect to Oracle

Hi! I get this code here and it works very well. It was a Jean-Christophe suggestion. You can obtain TNS string from file TNSNAMES.ORA. Good Luck!

Leon

<?php putenv("ORACLE_SID=badm"); putenv("ORACLE_HOME=D:\ORANT"); $tns = "(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = bhz_oracle_1)(PORT = 1521))) (CONNECT_DATA = (SID = badm) ) )"; $connect=OCIPLogon("user","password",$tns) or die("It's not possible to connect"); $sql = "select * from CentrosCusto";

$result = OCIParse($connect,$sql); OCIExecute($result) or die("It's not possible to query");

echo("<TABLE>"); while(OCIFetch($result)) { $CC = OCIResult($result,1); $CCNome = OCIResult($result,2); echo('<TR><TD>' . $CC . '</TD><TD>' . $CCNome . '</TD></TR>'); } echo("</TABLE>");

Euan Greig Technical Consultant BRANN DATA euan.greigbrann.com 01285 645997

**************************************************************************

attached mail follows:

Thanks guys. I'm going to try and tackle this later today. I was soooo happy just to get ODBC and oracle working yesterday.

I had to install the oracle 8.1.6 client. Then i rolled back to php3.

Works fine.

I'm going to try the OCI stuff later, i'll letcha know.

-ken

-----Original Message----- From: Greig, Euan [mailto:Euan.Greigbrann.com] Sent: Thursday, March 22, 2001 5:37 AM To: php-generallists.php.net Subject: [PHP] Oracle, Win2000, Apache, OCI