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: Sun Mar 18 2001 - 21:17:37 CST

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

php-general Digest 19 Mar 2001 03:17:37 -0000 Issue 575

Topics (messages 44437 through 44478):

Re: how do i get a variable type?
44437 by: rm

Re: phpMyAdmin edit function not working
44438 by: Oktay Altunergil

Re: how to change from php Apache module to php CGI?
44439 by: Oktay Altunergil

multiple post what the hey
44440 by: PHPretard
44472 by: Paul R. Jackson

Re: confirm unsubscribe from php-generallists.php.net
44441 by: Bob DeBolt

Q - php-apache _ php-cgi
44442 by: Bart A. Verbeek

PHP script locations
44443 by: Paul O'Neil

Re: Anyone good with Java??
44444 by: Chris Anderson

Source Protection
44445 by: Chris Anderson

how do i get a variable type? - not that simple
        44446 by: phpman
        44448 by: Johnson, Kirk
        44449 by: Rick St Jean
        44450 by: Mark Charette

Problems with multiple query
44447 by: Luca Lazzeroni
44452 by: Nuno Silva

Good Free PHP Editor - And it's not Edit Plus!
44451 by: James Crowley
44467 by: news.php.net

Re: update two frames at once?
44453 by: Maron Kristófersson

Re: Combining Perl and PHP
44454 by: Henrik Hansen

Re: TraceRoute
        44455 by: Henrik Hansen
        44456 by: Kath
        44457 by: Henrik Hansen

newline in preg_split
44458 by: Jesper Blomström
44459 by: Ville Mattila

Re: MIME and headers
44460 by: Manuel Lemos

Re: dymanic forms
44461 by: Manuel Lemos

PHP & MYSQL BOOKS
        44462 by: YoBro
        44463 by: Jason Lotito
        44464 by: eschmid+sic.s.netic.de

Arrays in Classes
44465 by: Richard S. Crawford

submission of 1..N variables
44466 by: Ekkard Gerlach

Re: Undefined Variable
44468 by: David Robley

dynamically change a variable name
44469 by: Gary

pulldown population not getting the last value
44470 by: Tom Beidler

Re: Expire data from form
44471 by: Paul R. Jackson

just wondering ....
        44473 by: Peter Houchin
        44475 by: CC Zona
        44477 by: Peter Houchin
        44478 by: David Robley

Can PHP for Oracle randomly access rows in a result set?
44474 by: Andrew Halliday

Tables with scroll in HTML?
44476 by: Jose Antonio

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:

PHP, at least php 3.x, has a series of fuctions like
is_string, is_integer, is_array etc. I know they're
there...I don't us them so I don't know exactly
where...this might be what you're looking for...

--- phpman <infographicon.nu> wrote:
> hello all,
>
> let's say i have this:
> $a="varone=hello world|vartwo=2.44|varthree=100|";
>
> now i do this:
>
> $b=explode('|',$a);
> $z=count($b);
> for ($x=0;$x<$z;$x++) {
> $tmp=explode('=',$b[$x]);
> ....
>
> and i want to find out if $tmp[1] is a string or an
> integer (that's really
> all I need to determine so i can put
> together an SQL statement that puts single quotes
> around strings and none
> around integers). Obviously
> i won't know at design time all of the variables and
> their values. Thank
> you.
>
> -dave
>
>
>
> --
> 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
>

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

attached mail follows:

if you're using Windows. Check out phpfront at the address below. I must
accept that I don't completely understand your problem, but I found this
software to be more usable than the phpMyAdmin. (if your code has to know
when a field's value in the database is 'NULL' you may have problems with
phpMyAdmin, because it inserts NULLs as blank space)..

Anyway.. the limitation of this application is
1) it runs on windows only.. no web interface.
2) for some reason it doesn't let you do stuff on a table that doesn't have
a primary key defined.
http://www.anse.de/mysqlfront/

oktay
----- Original Message -----
From: "Robert Campbell" <robertsquarextreme.com>
To: <php-generallists.php.net>
Sent: Sunday, March 18, 2001 3:11 AM
Subject: [PHP] phpMyAdmin edit function not working

> I've got mysql & php running in a windows millenium
> system (yes, sad, I know), and I'm running phpmyadmin 2.1.0
>
> Anyway, I have a database with three cells of information:
>
> item_name
> item_list
> item_description
>
> Each cell contains numerous pieces of data seperated
> by a ¤ symbol (for exploding into an array). There is alot
> of data in each cell, and when I go to choose "edit" or
> "delete" the browser does nothing.
>
> I thought it was just an IE error, but the same happens
> in Netscape 6.0 and Netscape 4.8. So I skimmed through
> the source, copied the URL and pasted it into a new window.
>
> Only about half of the URL pasted. The only thing I can figure
> is that the address is too long. If this is the case, I'm trying to
> find out if anyone has tried converting phpmyadmin to use form
> buttons as opposed to parsing the data directly through the URL
> as a way to bypass this.
>
> Or if no one has tried that (and god I hope you have) does anyone
> know of another database management program like this that DOES
> use form buttons?
>
>
> --
> 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:

#from httpd.conf

#For PHP/FI (PHP2) as a cgi binary
Addtype application/x-httpd-php2 .php .php2
Action application/x-httpd-php2 /cgi-bin/php.cgi

This works for the php2 cgi installation. It might work for php3,4 as well.

oktay

----- Original Message -----
From: "Chris Chan" <chrishkseek.com>
To: <php-generallists.php.net>
Sent: Sunday, March 18, 2001 4:33 AM
Subject: [PHP] how to change from php Apache module to php CGI?

>
> I need the suexec feature. so i recompile the php4 to cgi. but i have
> hundreds of php scripts under the existing web site. it's not a easy task
to
> add the line
> #!/usr/local/bin/php
> to each php file.
>
> Anyone know is there any easy way to configure the httpd.conf without
modify
> hundreds of php files? Thanks in advance
>
> ----
> Chris Chan
>
>
>
> --
> 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:

Is it just me or are they like double and triple post from everyone?

whats going on? its iritating having to delete alot of message

_________________________________________________________
Do You Yahoo!?
Get your free yahoo.com address at http://mail.yahoo.com

attached mail follows:

I think its just you

""PHPretard"" <phpretardyahoo.com> wrote in message
news:000b01c0afca$8934b000$1983bc18pixeldesire...
> Is it just me or are they like double and triple post from everyone?
>
> whats going on? its iritating having to delete alot of message
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free yahoo.com address at http://mail.yahoo.com
>
>
> --
> 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:

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 3/18/01, 9:56:16 AM, php-general-helplists.php.net wrote regarding
confirm unsubscribe from php-generallists.php.net:

> Hi! This is the ezmlm program. I'm managing the
> php-generallists.php.net mailing list.

> To confirm that you would like

> bob.debolt3web.net

> removed from the php-general mailing list, please send an empty reply
> to this address:

>
php-general-uc.984934576.kgjfeofjnmmekfgklfoi-bob.debolt=3web.netlists.php.net

> Usually, this happens when you just hit the "reply" button.
> If this does not work, simply copy the address and paste it into
> the "To:" field of a new message.

> or click here:
>
mailto:php-general-uc.984934576.kgjfeofjnmmekfgklfoi-bob.debolt=3web.netl
ists.php.net

> PLEASE NOTE: I haven't checked whether your address is currently
> on the mailing list. To see what address you used to subscribe,
> look at the messages you are receiving from the mailing list. Each
> message has your address hidden inside its return path; for
> example, maryxdd.ff.com receives messages with return path:
> <php-general-return-<number>-mary=xdd.ff.comlists.php.net.

> Some mail programs are broken and cannot handle long addresses. If you
> cannot reply to this request, instead send a message to
> <php-general-requestlists.php.net> and put the entire address listed above
> into the "Subject:" line.

> --- Administrative commands for the php-general list ---

> I can handle administrative requests automatically. Please
> do not send them to the list address! Instead, send
> your message to the correct command address:

> To subscribe to the list, send a message to:
> <php-general-subscribelists.php.net>

> To remove your address from the list, send a message to:
> <php-general-unsubscribelists.php.net>

> Send mail to the following for info and FAQ for this list:
> <php-general-infolists.php.net>
> <php-general-faqlists.php.net>

> Similar addresses exist for the digest list:
> <php-general-digest-subscribelists.php.net>
> <php-general-digest-unsubscribelists.php.net>

> To get messages 123 through 145 (a maximum of 100 per request), mail:
> <php-general-get.123_145lists.php.net>

> To get an index with subject and author for messages 123-456 , mail:
> <php-general-index.123_456lists.php.net>

> They are always returned as sets of 100, max 2000 per request,
> so you'll actually get 100-499.

> To receive all messages with the same subject as message 12345,
> send an empty message to:
> <php-general-thread.12345lists.php.net>

> The messages do not really need to be empty, but I will ignore
> their content. Only the ADDRESS you send to is important.

> You can start a subscription for an alternate address,
> for example "johnhost.domain", just add a hyphen and your
> address (with '=' instead of '') after the command word:
> <php-general-subscribe-john=host.domainlists.php.net>

> To stop subscription for this address, mail:
> <php-general-unsubscribe-john=host.domainlists.php.net>

> In both cases, I'll send a confirmation message to that address. When
> you receive it, simply reply to it to complete your subscription.

> If despite following these instructions, you do not get the
> desired results, please contact my owner at
> php-general-ownerlists.php.net. Please be patient, my owner is a
> lot slower than I am ;-)

> --- Enclosed is a copy of the request I received.

> Return-Path: <bob.debolt3web.net>
> Received: (qmail 12770 invoked from network); 18 Mar 2001 16:56:16 -0000
> Received: from unknown (HELO smtp2.cybersurf.net) (209.197.145.112)
> by va.php.net with SMTP; 18 Mar 2001 16:56:16 -0000
> Received: from thetoy ([209.197.155.223]) by smtp2.cybersurf.net
> (Netscape Messaging Server 4.15) with SMTP id GAEKLD00.F2A for
> <php-general-unsubscribelists.php.net>; Sun, 18 Mar 2001
10:00:49 -0700
> From: Bob DeBolt <bob.debolt3web.net>
> Date: Sun, 18 Mar 2001 17:06:35 GMT
> Message-ID: <20010318.17063566mis.configured.host>
> To: php-general-unsubscribelists.php.net
> X-Mailer: Mozilla/3.0 (compatible; StarOffice/5.2;Win32)
> X-Priority: 3 (Normal)
> MIME-Version: 1.0
> Content-Type: multipart/alternative; boundary=
> "------------=_4D4800998E76041A9EE4"
> Content-Transfer-Encoding: 7bit

> --------------=_4D4800998E76041A9EE4
> Content-Description: filename="text1.txt"
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable

> --------------=_4D4800998E76041A9EE4
> Content-Description: filename="text1.html"
> Content-Type: text/html
> Content-Transfer-Encoding: quoted-printable

> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"CONTENT-TYPE" CONTENT=3D"text/html;
charset=3Diso-8=
> 859-1">
> <TITLE></TITLE>
> <META NAME=3D"GENERATOR" CONTENT=3D"StarOffice/5.2 (Win32)">
> <META NAME=3D"CREATED" CONTENT=3D"20010318;10062824">
> <META NAME=3D"CHANGEDBY" CONTENT=3D"Bob DeBolt">
> <META NAME=3D"CHANGED" CONTENT=3D"20010318;10063489">
> </HEAD>
> <BODY>
> <P><BR><BR>
> </P>
> </BODY>
> </HTML>
> --------------=_4D4800998E76041A9EE4--

attached mail follows:

Hello,
I'm kind of new to serverside management and got a little question.
PHP can run on a server in different ways; as an Apache-module and as a
cgi-module.
- What is the biggest diffence between these two ways of running?
- When I write scripts for both do I have to pay attention to something or
keep an important aspect in mind..?

I hope you people can clear this out for me....
Thanks in advance,
Bart

attached mail follows:

Dumb question here but where does one typically keep there PHP form scripts,
like

web/index.htm
images/image.jpg
phpscripts/login.php
cgi-bin/perlscript.pl
secure/secureforms.here

Is there a problem keeping everything in the WEB directory, is it a security
issue or management of files issue? Both?

attached mail follows:

Close, But I meant this:
drop downs have <Dog><cat><fish>
if I select Dog from the first box the rest contain
<cat><fish>
but if I chnage it to <fish> the others would have
<dog><cat>
----- Original Message -----
From: "Dennis Gearon" <gearondcvc.net>
To: "Chris Anderson" <chrisdersonameritech.net>; "PHP"
<php-generallists.php.net>
Sent: Saturday, March 17, 2001 10:41 PM
Subject: RE: Anyone good with Java??

> >I know php can't do this but I hoped somehere would know how. I have a
page
> >with many select boxes(drop downs). I want it so that if someone selects
a
> >value, it is removed from all the others. And if they change it, the old
> >value is returned to the other boxes. Any help would be appreciatedI
think you need >Javascript?
> >
> >And I'd love s similar thing, select one and it changes other to
appropriate sub >menus.
>
> So,
> so selecting pets would get you <dogs><cats><etc> in the next pull down
> over.
> selelecting <dogs> would get you <bysize><byfunction> in the next pull
> down over.
> and selecting one of those would get the categories below that, etc, in
> the next pull down over.
>
> Pets
> Dogs
> bysize
> Poodles
> Pekinese
> Minatures
> small
> medium
> large
> huge
> byfunction
> indoor pet
> rodent catching
> hunting small animals
> hunting birds
> hunting big animals
> shepharding
> guard dogs
> Cats
> <etc>
> --
> ________________________________________________________________
> Sites by friends of mine: http://www.myhiddentreasures.com/
> ________________________________________________________________
> WARNING personal propaganda signature
> TAKE WHAT YOU LIKE AND LEAVE THE REST
>
> SINCE OUR GOVERNMENT WON'T PRESERVE OUR CLIMATE, IT'S UP TO US!
> Imagine ** yourself ** and your kids now an endangered species
> <1>Inflate automobile tires to near maximum in summer, -2psi in winter
> <2>add insulation to house and hot water heater, and refrigerator,
> <3>combine trips in cars, make less of them <4>buy cars, sports
> vehicles and recreational vehicles with good if not best mileage
> <4>put awnings over windows is summer, remove in winter. <5> add
> solar hot water heating. <6>Push for energy recycling clothes
> dryers <7> walk more, play outside with your kids! <8> let your
> grass grow to 3-4 inches, chokes weeds, saves water and energy,
> keeps house cooler <9> Put WHITE or REFLECTIVE materials on
> roofs to send energy back into space. <10> Vote for burial of
> logging slash onsite in logging areas for better watersheds
> and less burned vegetation. <11> compost your leaves and grass,
> bury in flower beds, lawns, gardens, or give away. <12> VOTE
> for energy and CO2 ratings on ALL products and foods. KNOW how
> much damage your purchases do to the climate. <13> Give your kids
> less stuff and more of you. <14> recycle everything you can <15>
> limit your children to an average 1 per adult between all your
> marriages. (Only REPLACE yourself, not expand the population)
>

attached mail follows:

After realizing that The Zend Encoder is 2000$ I've decided that wont work for a college student(me). Is there any other way to protect source in my components?

attached mail follows:

No guys. that doesn't work. Take this code for example...

$a="3";
echo(gettype($a));

this returns string
i need to find it as an integer or real or float for the sql. which by the
way is MySQL.

thank you for responding, but I already know that gettype and all the other
is_* don't work for this.

""phpman"" <infographicon.nu> wrote in message
news:99132e$ol8$1toye.p.sourceforge.net...
> hello all,
>
> let's say i have this:
> $a="varone=hello world|vartwo44|varthree0|";
>
> now i do this:
>
> $bplode('|',$a);
> $zunt($b);
> for ($x
> $tmpplode('=',$b[$x]);
> ....
>
> and i want to find out if $tmp[1] is a string or an integer (that's
really
> all I need to determine so i can put
> together an SQL statement that puts single quotes around strings and none
> around integers). Obviously
> i won't know at design time all of the variables and their values. Thank
> you.
>
> -dave
>
>
>
> --
> 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:

How about a regex check for numeric characters with and without a decimal
point (and no leading zeros), versus alphanumerics? Just an "off the top of
my head suggestion", back to work...

Kirk

> -----Original Message-----
>
> ""phpman"" <infographicon.nu> wrote in message
> news:99132e$ol8$1toye.p.sourceforge.net...
> > hello all,
> >
> > let's say i have this:
> > $a="varone=hello world|vartwo=2.44|varthree=100|";
> >
> > now i do this:
> >
> > $b=explode('|',$a);
> > $z=count($b);
> > for ($x=0;$x<$z;$x++) {
> > $tmp=explode('=',$b[$x]);
> > ....
> >
> > and i want to find out if $tmp[1] is a string or an integer (that's
> really
> > all I need to determine so i can put
> > together an SQL statement that puts single quotes around
> strings and none
> > around integers).

attached mail follows:

I would right a function that would return a result and try an match within
the different types.

if (isdate($a))
{
Dtype = date;
}
if (isdigit($a))
{
Dtype = int;
}

return (Dtype);

etc..

At 01:44 PM 3/18/01 -0500, phpman wrote:
>No guys. that doesn't work. Take this code for example...
>
>$a="3";
>echo(gettype($a));
>
>this returns string
>i need to find it as an integer or real or float for the sql. which by the
>way is MySQL.
>
>thank you for responding, but I already know that gettype and all the other
>is_* don't work for this.
>
>
>
>""phpman"" <infographicon.nu> wrote in message
>news:99132e$ol8$1toye.p.sourceforge.net...
> > hello all,
> >
> > let's say i have this:
> > $a="varone=hello world|vartwo=2.44|varthree=100|";
> >
> > now i do this:
> >
> > $b=explode('|',$a);
> > $z=count($b);
> > for ($x=0;$x<$z;$x++) {
> > $tmp=explode('=',$b[$x]);
> > ....
> >
> > and i want to find out if $tmp[1] is a string or an integer (that's
>really
> > all I need to determine so i can put
> > together an SQL statement that puts single quotes around strings and none
> > around integers). Obviously
> > i won't know at design time all of the variables and their values. Thank
> > you.
> >
> > -dave
> >
> >
> >
> > --
> > 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

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

Personally I'd perform a query into MySQL and get what _it_ thinks the
values should be ... before doing anything else. It allows generality in
your error checking code.

Look at mysql_list_fields() et al.

mark C.

----- Original Message -----
From: "phpman" <infographicon.nu>
To: <php-generallists.php.net>
Sent: Sunday, March 18, 2001 12:44 PM
Subject: [PHP] how do i get a variable type? - not that simple

> No guys. that doesn't work. Take this code for example...
>
> $a="3";
> echo(gettype($a));
>
> this returns string
> i need to find it as an integer or real or float for the sql. which by the
> way is MySQL.
>
> thank you for responding, but I already know that gettype and all the
other
> is_* don't work for this.
>
>
>
> ""phpman"" <infographicon.nu> wrote in message
> news:99132e$ol8$1toye.p.sourceforge.net...
> > hello all,
> >
> > let's say i have this:
> > $a="varone=hello world|vartwo=2.44|varthree=100|";
> >
> > now i do this:
> >
> > $b=explode('|',$a);
> > $z=count($b);
> > for ($x=0;$x<$z;$x++) {
> > $tmp=explode('=',$b[$x]);
> > ....
> >
> > and i want to find out if $tmp[1] is a string or an integer (that's
> really
> > all I need to determine so i can put
> > together an SQL statement that puts single quotes around strings and
none
> > around integers). Obviously
> > i won't know at design time all of the variables and their values. Thank
> > you.
> >
> > -dave
> >
> >
> >
> > --
> > 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
>
>

attached mail follows:

Hi,
I've recently migrated a system with PHP 4.0.3pl1 and PostgreSQL 7.0.2 -
RedHat Linux 5.1 (yes 5) to a new one with PHP 4.0.4pl1 - PostgreSQL 7.0.2 -
RedHat Linux 7.0.

All my database applications work fine except one which does strange things:
this is a piece of code:

----8<------- CUT ----

$conn = pg_connect("dbname=aaaa user=yyyyy password=xxxxxx");

$sql = "select * from table_a where condition_a";
$qry1 = pg_exec ($conn,$sql);

$obj1 = pg_fetchobject($qry1,0);

// Until here everything works fine

$sql2 = "select * from table_b where condition_b=".$obj1->value_a;
$qry2 = pg_exec ($conn,$sql2);

----8<------- CUT ----

The second query is nested in a for-loop running for every object in the
first query; for performance reason I need to maintain the two queries
independent.

After executing (correctly) the first one, the system starts doing strange
things with the second one:

Warning: Unable to jump to row 0 on PostgreSQL result index 23 in cerca.php3
on line 467

and it fails to read data.
The strange thing is that the system does the same things for EVERY database
where I must use two consecutive queries !

Is there anyone who can help me ?

Thanks in advance

Luca Lazzeroni

attached mail follows:

Hello,

if the second query loops inside a _for_ statement and needs values from
the first query you have two options:

1. save all the results from query one to some array and then loop
inside the array within the _for_ statement executing new sql;
2. open two separate connections to the database and work with the two.
like this:
$conn1 = pg_connect(...);
$conn2 = pg_connect(...);
...
qry1 = pg_exec($conn1, $sql1);
...
for ($i=.....) {
        ...
        $qry2 = pg_exec($conn2, $sql2);
        ...
}

Hope this helps,
Nuno Silva

Luca Lazzeroni wrote:

> Hi,
> I've recently migrated a system with PHP 4.0.3pl1 and PostgreSQL 7.0.2 -
> RedHat Linux 5.1 (yes 5) to a new one with PHP 4.0.4pl1 - PostgreSQL 7.0.2 -
> RedHat Linux 7.0.
>
> All my database applications work fine except one which does strange things:
> this is a piece of code:
>
> ----8<------- CUT ----
>
> $conn = pg_connect("dbname=aaaa user=yyyyy password=xxxxxx");
>
> $sql = "select * from table_a where condition_a";
> $qry1 = pg_exec ($conn,$sql);
>
> $obj1 = pg_fetchobject($qry1,0);
>
> // Until here everything works fine
>
> $sql2 = "select * from table_b where condition_b=".$obj1->value_a;
> $qry2 = pg_exec ($conn,$sql2);
>
> ----8<------- CUT ----
>
> The second query is nested in a for-loop running for every object in the
> first query; for performance reason I need to maintain the two queries
> independent.
>
> After executing (correctly) the first one, the system starts doing strange
> things with the second one:
>
> Warning: Unable to jump to row 0 on PostgreSQL result index 23 in cerca.php3
> on line 467
>
> and it fails to read data.
> The strange thing is that the system does the same things for EVERY database
> where I must use two consecutive queries !
>
> Is there anyone who can help me ?
>
> Thanks in advance
>
> Luca Lazzeroni

attached mail follows:

Dear All,

Given the recent discussion regarding a PHP editor, I thought you would
like to know that VB Web Development have finally released Developers Pad
BETA 2. This program is open source, and free. It's features include syntax
highlighting (fully customizable), powerful project view, auto-indent, quick
HTML tag insert, open linked file and more.

It is available for download at
http://developerspad.vbdiamond.com/download/
and you can talk to me (and everyone else) about it at
http://developerspad.vbdiamond.com/forum/

If you have any problems with the new release, don't have any hestitation in
contacting me.

New Features for BETA 2:
- Enhanced Project View
   * Virtual folders
   * Saved in XML Format
   * Can open VB, VC++ and .NET Project Files
- Enhanced Editor Window
   * Open Linked File Shortcut
   * Jump-To Procedure List
   * Quick HTML Tag Insert
- Extended Language Support
   * Now includes support for SQL, VB.NET and C#
- Less Bugs!
- Improved Add-In Support
   * New Add-In Object Model

We are currently looking for sponsors! If there is a company out there
interested in sponsoring Developers Pad and its site, please e-mail me.

Regards,

- James

Editor, VB Web
==================
Web - http://www.vbweb.co.uk
Email - jamesvbweb.co.uk
ICQ# - 60612011
==================

attached mail follows:

just a note:

afaik editplus is no freeware.

--
(::sebas::)
___________________________________________________
www.nijmegen.de & sebas.tweakers.net & www.weblab-online.de
""James Crowley"" <jamesvbweb.co.uk> wrote in message
news:LPBBLAEJJBODDGEDDCNOCECNEAAA.jamesvbweb.co.uk...
> Dear All,
>
> Given the recent discussion regarding a PHP editor, I thought you would
> like to know that VB Web Development have finally released Developers Pad
> BETA 2. This program is open source, and free. It's features include
syntax
> highlighting (fully customizable), powerful project view, auto-indent,
quick
> HTML tag insert, open linked file and more.
>
> It is available for download at
> http://developerspad.vbdiamond.com/download/
> and you can talk to me (and everyone else) about it at
> http://developerspad.vbdiamond.com/forum/
>
> If you have any problems with the new release, don't have any hestitation
in
> contacting me.
>
> New Features for BETA 2:
> - Enhanced Project View
>    * Virtual folders
>    * Saved in XML Format
>    * Can open VB, VC++ and .NET Project Files
> - Enhanced Editor Window
>    * Open Linked File Shortcut
>    * Jump-To Procedure List
>    * Quick HTML Tag Insert
> - Extended Language Support
>    * Now includes support for SQL, VB.NET and C#
> - Less Bugs!
> - Improved Add-In Support
>    * New Add-In Object Model
>
> We are currently looking for sponsors! If there is a company out there
> interested in sponsoring Developers Pad and its site, please e-mail me.
>
> Regards,
>
> - James
>
> Editor, VB Web
> ==================
> Web   - http://www.vbweb.co.uk
> Email - jamesvbweb.co.uk
> ICQ#  - 60612011
> ==================
>
>
> --
> 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:

I don't know if this is possible in PHP don't think so but you can do some very nifty things using JavaScript.

Let's say you got two frames named links and main. Then you can for example do something like this in a page called contacts.php in the main frame

Then in your links.php page you could have this php code.

if(isset($page)) { include("./links/$page.inc"); }

As you can see, the value of $page can be whatever you want. So when you then browse to another page, lets say companies.php then you could include the special functions for that page in the links page.

This can be very usable for webbased applications when you wan't to keep the functions on the right for each page, but want to change them whenever you change pages.

There is a con to this all though. When you use this method and hit the back button you will only be taken one step back, so the links page will only be taken back but not the main screen. Best way to fix this is to set up a pretty obvious back button that is in the path of the user going to the left corner to the screen. The link on that one would then be: <a href="Javascript:history.back(-2)"> instead of the usual -1.

Hope this helps,

Maron Kristofersson Reykjavik Iceland http://www.discovericeland.is/

-----Original Message----- From: Michael George [mailto:georgemintcity.com] Sent: 12. mars 2001 21:06 To: php-generallists.php.net Subject: [PHP] update two frames at once?

Hello al!

Is it possible to have two frames updated when cliking on one link? I have a page that is broken into 4 parts: master title section title d section screen i r .

what I want is that when a link is clicked on in the directory (the left column), I'd like to update the section title *and* the section screen...

It seemed a cool layout at the time, but I'm thinking this isn't easily possible and I might just have to incorporate a section title on the section screen... But before I rewrite it, I thought I'd ask here.

Thanks!

-Michael

P.S. I'd like to commend the regular posters to this list on being SOOO informative and patient! Every small question to this list always gets several useful answers, even when I've seen questions asked over and again.

-- No, my friend, the way to have good and safe government, is not to trust it all to one, but to divide it among the many, distributing to every one exactly the functions he is competent to. It is by dividing and subdividing these republics from the national one down through all its subordinations, until it ends in the administration of every man's farm by himself; by placing under every one what his own eye may superintend, that all will be done for the best. -- Thomas Jefferson, to Joseph Cabell, 1816

-- 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:

"Matthew Hanna" <hannaCLEMSON.EDU> wrote:

> Has anyone heard of calling Perl libraries from PHP? I have seen it done with Java classes > but it would be great if there was a way to do it with Perl.

The only thing i can think of is virtual() and exec(), take a look at those.

-- Henrik Hansen

attached mail follows:

"Mick" <twdoptushome.com.au-nospam> wrote:

> Hi, > > Anyone able to tell me where i can get a traceroute php script from?

http://www.google.com/search?q=php+traceroute+script&hl=da&lr=

-- Henrik Hansen

attached mail follows:

I tried emailing him 5 times with this, but I could never get through :|

I even found the script for him and tried to send it to him :|

- Kath

----- Original Message ----- From: "Henrik Hansen" <hhmailserver.dk> To: "Mick" <twdoptushome.com.au-nospam> Cc: <php-generallists.php.net> Sent: Sunday, March 18, 2001 4:58 PM Subject: Re: [PHP] TraceRoute

> "Mick" <twdoptushome.com.au-nospam> wrote: > > > Hi, > > > > Anyone able to tell me where i can get a traceroute php script from? > > http://www.google.com/search?q=php+traceroute+script&hl=da&lr= > > -- > Henrik Hansen > > > -- > 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:

"Kath" <kathkathweb.net> wrote:

> I tried emailing him 5 times with this, but I could never get through :| > > I even found the script for him and tried to send it to him :| > > - Kath

heh i got an error too, lets just hope he read the group :)

-- Henrik Hansen

attached mail follows:

Hi!

I have text file looking something like this:

core 010105 business 070344 core 020202 ...

The textfile is a result from a database question and I am trying to parse the file in order to retrieve each line. I have tried using the explode()-method but I can´t get it to work with the delimiter \n (or \r or \\n...). I have also tried to use the preg_split()-method which takes a RE-argument but that doesn´t seem to work either (have tried in a lot of ways).

Can anyone give me a clue how to solve this problem?

Many thanks from Stockholm, Sweden!

Jesper Blomstroem

--
Jesper Blomström
08-370 317 (Hem)
08-566 280 08 (Arbete)
070-3024911
Ångermannagatan 113
162 64 Vällingby

attached mail follows:

Hello,

If you read the file with file()-function, you can get as a result an array which includes each row of the file.

For example: $rows = file("c:\thisfile.txt");

echo $rows[0]; echo $rows[1]; echo $rows[2];

The result should be now like following: core 010105 business 070344 core 020202

Note that also \n and \r -characters are included to the array.

Cheers, - Ville

----- Original Message ----- From: Jesper Blomström <jeppepartitur.se> To: <php-generallists.php.net> Sent: Monday, March 19, 2001 12:31 AM Subject: [PHP] newline in preg_split

> Hi! > > I have text file looking something like this: > > core 010105 > business 070344 > core 020202 > ... > > > The textfile is a result from a database question and I am trying to parse > the file in order to retrieve each line. I have tried using the > explode()-method but I can´t get it to work with the delimiter \n (or \r or > \\n...). > I have also tried to use the preg_split()-method which takes a RE-argument > but that doesn´t seem to work either (have tried in a lot of ways). > > Can anyone give me a clue how to solve this problem? > > Many thanks from Stockholm, Sweden! > > Jesper Blomstroem > > > > -- > > Jesper Blomström > 08-370 317 (Hem) > 08-566 280 08 (Arbete) > 070-3024911 > > Ångermannagatan 113 > 162 64 Vällingby > > > > > > -- > 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:

Hello Peter,

On 06-Mar-01 21:11:00, you wrote:

>Can some one please tell me what the relationship between mime and email >headers is ....I have not been able to find a straight answer off the net >..so if any one knows of a good site can you please give me the url so i can >look at it .. thanks Peter Houchin Sun Rentals peterhsunrentals.com.au

If your message headers contain non-ASCII characters they need to be encoded according to MIME q-encoding algorithm.

You may want to try this MIME message composing and sending PHP Class that can encode headers using q-encoding:

http://phpclasses.UpperDesign.com/browse.html/package/9

Regards, Manuel Lemos

Web Programming Components using PHP Classes. Look at: acm.org">http://phpclasses.UpperDesign.com/?user=mlemosacm.org

-- E-mail: mlemos

acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

attached mail follows:

Hello george,

On 06-Mar-01 09:16:39, you wrote:

>I am trying to build a form which can be geberated dynamically >by the user selecting the number of fields up to a max of 10.

Maybe you would like to try this PHP class that lets you generate forms programmatically.

http://phpclasses.UpperDesign.com/browse.html/package/1

Regards, Manuel Lemos

Web Programming Components using PHP Classes. Look at: acm.org">http://phpclasses.UpperDesign.com/?user=mlemosacm.org

-- E-mail: mlemos

acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

attached mail follows:

Hello,

Does anybody know any good books & websites to recommend for PHP & MySql together. I am looking to advance my knowledge and would really appreciate a helpful tip.

Really looking for a book that explains all the advanced features of PHP4 and MySql as a compliment.

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:

> -----Original Message----- > From: YoBro [mailto:nospambrochures.co.nz] > Sent: Sunday, March 18, 2001 3:13 PM > To: php-generallists.php.net > Subject: [PHP] PHP & MYSQL BOOKS > > > Hello, > > Does anybody know any good books & websites to recommend for PHP & MySql > together. I am looking to advance my knowledge and would really > appreciate a > helpful tip. > > Really looking for a book that explains all the advanced features of PHP4 > and MySql as a compliment. > > Regards, > > > YoBro

I have found the following books very userful: PHP Developer's Cookbook WROX's Beginning PHP 4 Core PHP Programming SQL In A Nutshell

The following websites as well: www.phpbuilder.com (which, if I may say, I had an article accepted there, and it will soon be released.=)) www.phpdeveloper.org www.phpbeginner.com www.hotscripts.com (Check out the PHP Tutorials section) www.newbienetwork.net (My site...=P) www.webmonkey.com www.devshed.com

attached mail follows:

On Sun, Mar 18, 2001 at 06:43:27PM -0800, Jason Lotito wrote: > > From: YoBro [mailto:nospambrochures.co.nz]

> > Does anybody know any good books & websites to recommend for PHP & MySql > > together. I am looking to advance my knowledge and would really > > appreciate a > > helpful tip. > > > > Really looking for a book that explains all the advanced features of PHP4 > > and MySql as a compliment.

> I have found the following books very userful: > PHP Developer's Cookbook > WROX's Beginning PHP 4 > Core PHP Programming > SQL In A Nutshell > > The following websites as well: > www.phpbuilder.com (which, if I may say, I had an article accepted there, > and it will soon be released.=)) > www.phpdeveloper.org > www.phpbeginner.com > www.hotscripts.com (Check out the PHP Tutorials section) > www.newbienetwork.net (My site...=P) > www.webmonkey.com > www.devshed.com

The most useful book about MySQL and PHP is the New Riders book from Paul DuBois. This book is more readable than the PHP or MySQL online docus. You can buy a copy at php.net/books.php -> related reading.

-Egon

-- LinuxTag, Stuttgart, Germany: July 5-8 2001: http://www.linuxtag.de/ All known books about PHP and related books: http://php.net/books.php Concert Band of the University of Hohenheim: http://www.concert-band.de/ First and second bestselling book in German: http://www.php-buch.de/

attached mail follows:

I'm quite new at object-oriented programming in PHP. Here's what I want to do.

I want to create a class of objects called "lists". The properties I want to have for list objects include:

owner of the list number of items in the list the list itself

Each item in the list, of course, has several properties of their own: the date the item was added, the name of the item, and a link to the item. I figured that the list would be contained in an array of associative arrays... such as,

item[0]["item"]="Palm Pilot" item[0]["dateAdded"]="2001-03-18" item[0]["link"]="http://www.palm.com"

The lists will be built from a database which contains information about users and the lists that they maintain. The database part I have down pat.

Properties of the list objects can be retrieved like this, of course...

$myList=new List($userID); $num=$myList->numItems; $name=$myList->listOwner;

What I'm wondering is, can I do something like this:

for($i=0;$i<$num;$i++) $itemList[$i]["item"]=$myList->item[$i]["item"];

If so, how???

attached mail follows:

Hi,

n variables reach my php-programm by submission:

A0 A1 ... An

Depending on Ai is set I want to run some actions.

How can I evaluate Ai ??

if (isset (A1) then # entrance { i=0; while( isset($Ai)) { /* Of course $Ai is not working !!! */ { $B= $Ai ... action ... } }

I tried a lot with eval , with backticks, ... but no suceess.

Anybody an Idea?

tia Ekkard

attached mail follows:

On Sun, 18 Mar 2001 00:13, Jorge Alvarez wrote: > Hi there, > > I get this error every time I try to use a variable that has not been > declared. Is this new to PHP4? I do not recall this error in the past, > echo $MYVAR echoed nothing if $MYVAR was not set but no error was > raised. > > How can I revert PHP behavior to 'no-error' with undeclared variables? > > Many thanks in advance, > > Jorge Alvarez > PHP4 new user

You may need to play around with the value of error_reporting in your php.ini file.

-- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA

attached mail follows:

Is there a way to dynamically change a variable name? For example: I want to change the variable name $DWG to $DWG1 $DWG2 $DWG3 with a for loop. Is there a way to do this?

Thanks, Gary

attached mail follows:

I'm trying to create a pulldown menu with distinct names from the found set. For some reason I never get the last name. Here's my code;

$contact_query = "SELECT DISTINCT name FROM request" . " WHERE id <= '5' OR demo_id = '$demo_id'" . " ORDER BY name"; $contact_result = mysql_query ($contact_query) or die ("Cannot build contact");

while ($contact_row = mysql_fetch_array ($contact_result)) { $name = $contact_row["name"]; $option_contact .= "<OPTION value=\"$name\">$name</OPTION>\n"; }

What gives?

Any help would be appreciated.

Thanks, Tom

>>.>>.>>>.>>>>>.>>>>>>>>>.>>>>>>>> Tom Beidler Orbit Tech Services 805.682.8972 (phone) 805.682.5833 (fax) tomorbittechservices.com http://www.orbittechservices.com/ >>.>>.>>>.>>>>>.>>>>>>>>>.>>>>>>>>

attached mail follows:

Sheni,

I needed to do a similar thing as this. When creating the form have a hidden value which is the current time. The when procesing the form check the time. If its to old just say page expired.

I found this worked fine. Hope this helps.

Paul

""Sheni R. Meledath"" <shenicyber-gear.com> wrote in message news:5.0.0.25.2.20010318114641.01f1c2f0cyber-gear.com... > Hi, > > I have set up a form to register the users to the site. The users are > allowed to register only once. When the user submits the form the same > script will check the validity of the form and displays error messages and > if okay, updates the database. > I want to set up an option in the form in which when the user once submits > and after that if they click on the back button (browser back) it should > say the 'page expired' as I have seen with some Perl scripts. The users > should not be allowed to go back to the page and resubmit. Can any body > suggest a way to accomplish this. > > thanks > Sheni R Meledath > shenicyber-gear.com > > > -- > 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 I have a email script and use the mail() function ... am i able to do this ..

mail(values); if ($mail=1){ do this } else { error }

is that possible? if not could some one suggest a way i could get the same effect?

Thanks

Peter Houchin peterhsunrentals.com.au ========================================================= _____ __ /\ /_/_/_\ / |_/ \ /_/_/_ __ __ __ __ / \ \_/_/_\ /_/ /_/ /_/ /_/ \ _ / ___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/ \_//_/_/ /_/_/_/ /_/ \/_/ v ________ ________________________________________ /_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ /_/_ _/_/ ______ __ __ /_/ ____ __ ______ /_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/ /_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\ /_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/ ========================================================= Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755 ************* We rent the dot in .COM! **************

attached mail follows:

In article <NFBBJNAGDIPHLCGPBLKDAENNCAAA.peterhsunrentals.com.au>, peterhvfsa.com.au ("Peter Houchin") wrote:

> If I have a email script and use the mail() function ... am i able to do > this .. > > mail(values); > if ($mail=1){ > do this > } > else { > error > }

Are you trying to test whether mail() returned true?

if (mail(values)){ do this } else { error }

(Keeping in mind that when mail() returns true, it's not saying whether the mail really reached the destination server, only that it the function executed successfully.)

-- CC

attached mail follows:

What am going to try & do is get it so mail() returns true then run this script else do this

Peter

-----Original Message----- From: CC Zona [mailto:cczonanospam.invalid] Sent: Monday, March 19, 2001 2:02 PM To: php-generallists.php.net Subject: Re: [PHP] just wondering ....

In article <NFBBJNAGDIPHLCGPBLKDAENNCAAA.peterhsunrentals.com.au>, peterhvfsa.com.au ("Peter Houchin") wrote:

> If I have a email script and use the mail() function ... am i able to do > this .. > > mail(values); > if ($mail=1){ > do this > } > else { > error > }

Are you trying to test whether mail() returned true?

if (mail(values)){ do this } else { error }

(Keeping in mind that when mail() returns true, it's not saying whether the mail really reached the destination server, only that it the function executed successfully.)

-- CC

attached mail follows:

Followups moved to bottom of message for legibility!

> -----Original Message----- > > > In article <NFBBJNAGDIPHLCGPBLKDAENNCAAA.peterhsunrentals.com.au>, > > peterhvfsa.com.au ("Peter Houchin") wrote: > > If I have a email script and use the mail() function ... am i able to > > do this .. > > > > mail(values); > > if ($mail=1){ > > do this > > } > > else { > > error > > }

> From: CC Zona [mailto:cczonanospam.invalid] > Sent: Monday, March 19, 2001 2:02 PM > To: php-generallists.php.net > Subject: Re: [PHP] just wondering .... > > Are you trying to test whether mail() returned true? > > if (mail(values)){ > do this > } > else { > error > } > > (Keeping in mind that when mail() returns true, it's not saying whether > the mail really reached the destination server, only that it the > function executed successfully.) > > -- > CC

On Mon, 19 Mar 2001 01:34, Peter Houchin wrote: > What am going to try & do is get it so mail() returns true then run > this script else do this > > Peter

Like most functions in PHP, mail() returns a value - boolean according to the manual. So you could do something like

$mail = mail(values); if ($mail){ do this } else { error }

But as has been pointed out above, a return of TRUE only means that mail() has handed the data off to something else, which something else may or may not succeed in sending the message.

attached mail follows:

Can PHP for Oracle randomly access rows in a result set?

I have read documentation for both Oracle functions (ora_*) and Oracle 8 functions (OCI_*) but cant seem to find a way to randomly access rows in a result set like you can with PostgreSQL or MySQL ... whats the story here?! Are we FORCED to access the result set sequentially with an Oracle database? Is that a restriction of the DB or PHP?

All help appreciated,

AndrewH

attached mail follows:

Is any way to make a dinamic table with its own scroll?

I'm trying make a table/form with a checkbox in every row and a submit button, but, when the table becomes long, I have to scroll down ALL the page to find the SUBMIT button. When you have make this operaton 3 times, it becomes bored.

I have tryed to make several frames, but, if a put the submit button in a diferent frame, how can i know wich are the selected rows of the form in the other frame?

If I could make a table with a fixed size and its own scroll bar, the interface would became more efficient.

Can anyone help me to make this? Any JAVA solution?

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