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> 2000-03

Subject: php3 Digest 10 Mar 2000 06:00:02 -0000 Issue 1528
From: php3-digest-helplists.php.net
Date: Fri Mar 10 2000 - 00:00:02 CST

Next message: php3-digest-helplists.php.net: "php3 Digest 10 Mar 2000 18:00:01 -0000 Issue 1529"
Previous message: php3-digest-helplists.php.net: "php3 Digest 9 Mar 2000 18:00:02 -0000 Issue 1527"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php3 Digest 10 Mar 2000 06:00:02 -0000 Issue 1528

Topics (messages 80538 through 80627):

Script problems
        80538 by: "James R. Edgar" <edgarwebt.com>
        80539 by: "Xuejia Miao" <xmiaorevelex.com>
        80552 by: "James R. Edgar" <edgarwebt.com>
        80554 by: "James R. Edgar" <edgarwebt.com>

FAO admin: Too much spam
80540 by: Christopher Ditty <CDittyemail.usps.gov>

help: how to report a number as integer??
80541 by: Kumar Unnikrishnan <unnikrishnangocubs.com>

multiple selects (was getting values from. . .)
        80542 by: Jorge Ruben Macias <jmaciasprotel.net.mx>
        80545 by: "Margie Wiers" <productiproductivetravel.com>
        80546 by: Joshua Hoover <plan10compfactory.com>

Instructions for PHP, Apache, MySQL,PHPLIB
80543 by: "Justin" <justinbigcity.nu>
80551 by: "J. Horner" <jhorner2jnetworks.com>

Parsing in PHP3
80544 by: Kumar Unnikrishnan <unnikrishnangocubs.com>

PostgreSQL Support on Win32?
80547 by: "Basil Hussain" <basil.hussainreserve.co.uk>
80550 by: Michael Stearne <mstearneeisolutions.com>

php3 & security
        80548 by: "kesl (my mailing lists)" <kesl-listssofthome.net>
        80556 by: Ben Johnson <benblarg.net>
        80579 by: Mark Lo <marklokynetvigator.com>
        80582 by: Ben Johnson <benblarg.net>

php & oracle
80549 by: "kesl (my mailing lists)" <kesl-listssofthome.net>

PHP UK [NEWS]
80553 by: "James Moore" <JamesProspect-enterprises.co.uk>

solution: odbc, primary key, default value, decimal point info and so on...
80555 by: André Langhorst <A.Langhorstitbnet.de>

pdflib 3.0
80557 by: Jim Ide <JIdemadentech.com>

Database in PHP?
        80558 by: "Kevin Old" <kevindddusa.com>
        80560 by: "James R. Edgar" <edgarwebt.com>
        80562 by: Michael Stearne <mstearneeisolutions.com>

basic question, sorry
80559 by: Glenn Becker <glennicarus.usanetworks.com>

ODBC/Sybase Stored Procedure w/Output Variables
80561 by: "Homsher, Dave" <DVHomsherbemis.com>

Basic filemtime() question
80563 by: "Jason Murray" <jmurraydicatech.com>
80565 by: "Boget, Chris" <chriswild.net>

wddx? oo db? xml
80564 by: André Langhorst <A.Langhorstitbnet.de>

create view in mysql
        80566 by: Boaz Yahav <berbernetvision.net.il>
        80573 by: Ben Johnson <benblarg.net>
        80576 by: Michael Stearne <mstearneeisolutions.com>

mysql_create_table?
80567 by: "Luis Madaleno" <ocxmail.telepac.pt>
80570 by: "Jason Cox" <jasoncwebpipe.net>

Apache
80568 by: wmphpgetlost.com.au (Warren)

array is empty ??
80569 by: "sufi malak" <sufi_mhotmail.com>

Simple Question
80571 by: "Doug Williams" <dwilliamssoftec-e.com>
80572 by: eschmid <eschmid+sics.netic.de>

Query Failed Message
80574 by: "Jean-Claude Bateau" <jbateaulvcm.com>

Parse
80575 by: Nazar Kulynych <nazarkregister.com>
80590 by: Kumar Unnikrishnan <unnikrishnangocubs.com>

CRC in PHP3
80577 by: Warren Grant <wgrantmaplesquare.com>
80581 by: "Henry F. Marquardt" <hankyerpso.net>

SSL???
80578 by: Mark Lo <marklokynetvigator.com>

test
80580 by: "Yurais Fernandez Leal" <yuraismedired.scu.sld.cu>

OCIFetch
80583 by: "Valdir" <valdiralbra.com.br>

escape charactor help
80584 by: James Bowen <jsbowen2crew.com>

How to get the referral URL
80585 by: christourneyland.com
80586 by: "Jason Cox" <jasoncwebpipe.net>

link action: function call
80587 by: Kit Plummer <designiosite.com>

libmcrypt saga - the end
80588 by: "Roberto P.Martins Jr." <robertointermega.com.br>

PHP && Oracle8i under Linux?
80589 by: "VANTASSLE, GEORDON M. (AIT)" <GEORDON.M.VANTASSLEmsg.ameritech.com>

PHP/MySQL optimization question
80591 by: sashamysql.com

Screwed by Safe Mode?
80592 by: Shane Hussel <husselintlsigns.com>

Executing external programs in BG
80593 by: Raul Dias <chaosswi.com.br>

Three-tier model with PHP
80594 by: "Manuel Lemos" <mlemosacm.org>

Screwed by Safe Mode - New Information
80595 by: Shane Hussel <husselintlsigns.com>

parsing a varible with txt2html
80596 by: "pdg" <pgreggwspa.com>

PHP3 - Help on Install
80597 by: "D Mynatt" <dmynattaustin.cc.tx.us>
80598 by: "Roberto P.Martins Jr." <robertointermega.com.br>

PHP/Postgres Parse Error
        80599 by: Michael Fork <mforktoledolink.com>
        80601 by: Max Pyziur <pyzpanix.com>
        80616 by: Michael Fork <mforktoledolink.com>

GIF files with PHP/MYSQL
80600 by: Paul Cohen <pcohennetworkoil.com>

PHP & WML
        80602 by: Geoffrey Makstutis <gmaklinux.local>
        80613 by: Alex Belits <abelitsphobos.illtel.denver.co.us>
        80614 by: "Rossi Designs" <webmasterrossidesigns.net>

***Can't find server name for address 192.168.1.1: Non-existent host/domain
80603 by: Ðìº½ÌÎ <xhtctiwx.com.cn>

php-4.0b4pl1+apache1.3.9+oracle8i+mysql.
80604 by: Ðìº½ÌÎ <xhtctiwx.com.cn>

PHP and session management
        80605 by: "Tiago Hermans" <thermanshawaii.rr.com>
        80606 by: "Peter Kocks" <peter.kocksbaygate.com>
        80607 by: "Tiago Hermans" <thermanshawaii.rr.com>
        80610 by: "Peter Kocks" <peter.kocksbaygate.com>
        80611 by: "Tiago Hermans" <thermanshawaii.rr.com>

stripslashes() / htmlspecialchars() : 3 questions
80608 by: "Margie Wiers" <productiproductivetravel.com>

TurboLinux Security Announcement
80609 by: idban secandri <idbansatunet.com>

PHP debugger
80612 by: tbaskansuperonline.com

MySQL, phpMyAdmin Problems....
80615 by: "Donovan J. Edye" <donovannamsys.com.au>
80617 by: idban secandri <idbansatunet.com>

Creating .htaccess password file from mysql table
80618 by: Ron Chmara <ronOpus1.COM>

what to do ???
80619 by: "Armando" <infoota-s.si>
80620 by: plummerkokinawa.usmc-mccs.org

PostgreSQL Object ID from INSERT
80621 by: Andrew Hill <listfornax.net>

Refresh two frames in a window in a single click.
80622 by: "Stephen Cope" <kimihiamaxnet.co.nz>

web hosting research
80623 by: "Stephen Cope" <kimihiamaxnet.co.nz>

ATTN: "Brad"
80624 by: "Stephen Cope" <kimihiamaxnet.co.nz>

index.php3 Forbidden Errors
80625 by: Michael <mikeinfinitywd.com>
80627 by: "Jason Brooke" <jasonqgl.org>

select command denied to user
80626 by: Juan de la Cruz <staffvasia.com>

Administrivia:

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

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

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

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

attached mail follows:

I am having a major problem. When you go to run the script from the browser
it will just sit there and continue loading but it does not finish it gets
stuck in the while loop. I have attached the code that is causing me the
problem. If anyone has any feedback I would greatly appreciate it. I am
connecting to a SQL server using the odbc functions.

If you need any other info please ask. Any help would be greatly appreciated
and thanks in advance.
The CODE
----------

        <table width="100%" border="0" cellspacing="0" cellpadding="3">
          <tr bgcolor="#313463">
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">Short / Long</font></td>
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">Date In</font></td>
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">Date Out</font></td>
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">Price In</font></td>
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">Price Out</font></td>
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">No. Of Shares</font></td>
            <td><font face="Arial, Verdana, sans-serif" size="2"
color="#FFFFFF">P/L</font></td>
          </tr>
          <?
        $newconnection =
odbc_connect("*********","***********","*************",""); // "*" is just
filler for security purposes.
        $newquery = "SELECT * FROM transxn where symbol='$sym' AND
new_close='CLOSE'";
        $newresult = odbc_do($newconnection, $newquery);
        $color = 0;
        $z = 0;
        while (odbc_fetch_into($newresult, $i, &$fields))
                {
                $sl = $fields[1];
                $di = $fields[2];
                $do = $fields[3];
                $buy = $fields[4];
                $sell = $fields[5];
                $qty = $fields[7];
        //Run price in and price out data
                if ($sl == "SHORT")
                {
                $pricein = $sell;
                $priceout = $buy;

$pl = $sell - $buy;
}

                if ($sl == "LONG")
                {
                $pricein = $buy;
                $priceout = $sell;

$pl = $sell - $buy;
}

                if ($color == 0)
                        {
                        $tcolor = "#DEAA42";
                        $text = "#313463";
                        $color = 1;
                        }
                else
                        {
                        $tcolor = "#313463";
                        $text = "#FFFFFF";
                        $color = 0;
                        }

                        print("<tr bgcolor=\"$tcolor\">\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">$sl</font></td>\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">$di</font></td>\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">$do</font></td>\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">$pricein</font></td>\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">$priceout</font></td>\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">$qty</font></td>\n");
                    print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"$text\">");
                    $money = $qty*$pl;
                    $sum = $sum + $money;
                    printf("%0.2f",$money);
                    print("</font></td>\n");
                  print("</tr>\n\n");
                }
        print("<tr bgcolor=\"#FFFFFF\">\n");
        print("<td colspan=\"5\"><font face=\"Arial, Verdana, sans-serif\"
size=\"2\" color=\"$text\"> </font></td>\n");
        print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"#000000\">Total Profit/Loss:</font></td>\n");
        print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
color=\"#000000\">\n");
        printf("%0.2f",$sum);
        print("</font></td>\n");
        print("</tr>\n");
        ?>
        </table>

attached mail follows:

It look likt you didn't change rownumbers $i in your while statement.
so script always fetch same row records, dead loop appears.

Increase $i in your while loop!

----- Original Message -----
From: "James R. Edgar" <edgarwebt.com>
To: "PHP" <php3lists.php.net>
Sent: Thursday, March 09, 2000 12:04 PM
Subject: [PHP3] Script problems

> I am having a major problem. When you go to run the script from the
browser
> it will just sit there and continue loading but it does not finish it gets
> stuck in the while loop. I have attached the code that is causing me the
> problem. If anyone has any feedback I would greatly appreciate it. I am
> connecting to a SQL server using the odbc functions.
>
> If you need any other info please ask. Any help would be greatly
appreciated
> and thanks in advance.
> The CODE
> ----------
>
> <table width="100%" border="0" cellspacing="0" cellpadding="3">
> <tr bgcolor="#313463">
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">Short / Long</font></td>
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">Date In</font></td>
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">Date Out</font></td>
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">Price In</font></td>
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">Price Out</font></td>
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">No. Of Shares</font></td>
> <td><font face="Arial, Verdana, sans-serif" size="2"
> color="#FFFFFF">P/L</font></td>
> </tr>
> <?
> $newconnection =
> odbc_connect("*********","***********","*************",""); // "*" is just
> filler for security purposes.
> $newquery = "SELECT * FROM transxn where symbol='$sym' AND
> new_close='CLOSE'";
> $newresult = odbc_do($newconnection, $newquery);
> $color = 0;
> $z = 0;
> while (odbc_fetch_into($newresult, $i, &$fields))
> {
> $sl = $fields[1];
> $di = $fields[2];
> $do = $fields[3];
> $buy = $fields[4];
> $sell = $fields[5];
> $qty = $fields[7];
> file://Run price in and price out data
> if ($sl == "SHORT")
> {
> $pricein = $sell;
> $priceout = $buy;
>
> $pl = $sell - $buy;
> }
>
> if ($sl == "LONG")
> {
> $pricein = $buy;
> $priceout = $sell;
>
> $pl = $sell - $buy;
> }
>
> if ($color == 0)
> {
> $tcolor = "#DEAA42";
> $text = "#313463";
> $color = 1;
> }
> else
> {
> $tcolor = "#313463";
> $text = "#FFFFFF";
> $color = 0;
> }
>
> print("<tr bgcolor=\"$tcolor\">\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">$sl</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">$di</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">$do</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">$pricein</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">$priceout</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">$qty</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"$text\">");
> $money = $qty*$pl;
> $sum = $sum + $money;
> printf("%0.2f",$money);
> print("</font></td>\n");
> print("</tr>\n\n");
> }
> print("<tr bgcolor=\"#FFFFFF\">\n");
> print("<td colspan=\"5\"><font face=\"Arial, Verdana, sans-serif\"
> size=\"2\" color=\"$text\"> </font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"#000000\">Total Profit/Loss:</font></td>\n");
> print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\"
> color=\"#000000\">\n");
> printf("%0.2f",$sum);
> print("</font></td>\n");
> print("</tr>\n");
> ?>
> </table>
>
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net
>
>

attached mail follows:

That did not work. Here is the URL so you can see what happens. If need be I
will give you the script for the whole page there are a couple of other
scripts included into this one. Here is the URL.

http://www.systems-traders.com/secdetails.php3?sym=EBAY
or you can try this one so you can see it happens to any $sym given
http://www.systems-traders.com/secdetails.php3?sym=TIF

-----Original Message-----
From: Xuejia Miao [mailto:xmiaorevelex.com]
Sent: Thursday, March 09, 2000 2:18 PM
To: James R. Edgar
Cc: php3lists.php.net
Subject: Re: [PHP3] Script problems

It look likt you didn't change rownumbers $i in your while statement.
so script always fetch same row records, dead loop appears.

Increase $i in your while loop!

----- Original Message -----
From: "James R. Edgar" <edgarwebt.com>
To: "PHP" <php3lists.php.net>
Sent: Thursday, March 09, 2000 12:04 PM
Subject: [PHP3] Script problems

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Use viewdemo as user/pass

Edgar

-----Original Message----- From: Xuejia Miao [mailto:xmiaorevelex.com] Sent: Thursday, March 09, 2000 2:18 PM To: James R. Edgar Cc: php3lists.php.net Subject: Re: [PHP3] Script problems

It look likt you didn't change rownumbers $i in your while statement. so script always fetch same row records, dead loop appears.

Increase $i in your while loop!

----- Original Message ----- From: "James R. Edgar" <edgarwebt.com> To: "PHP" <php3lists.php.net> Sent: Thursday, March 09, 2000 12:04 PM Subject: [PHP3] Script problems

> I am having a major problem. When you go to run the script from the browser > it will just sit there and continue loading but it does not finish it gets > stuck in the while loop. I have attached the code that is causing me the > problem. If anyone has any feedback I would greatly appreciate it. I am > connecting to a SQL server using the odbc functions. > > If you need any other info please ask. Any help would be greatly appreciated > and thanks in advance. > The CODE > ---------- > > <table width="100%" border="0" cellspacing="0" cellpadding="3"> > <tr bgcolor="#313463"> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">Short / Long</font></td> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">Date In</font></td> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">Date Out</font></td> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">Price In</font></td> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">Price Out</font></td> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">No. Of Shares</font></td> > <td><font face="Arial, Verdana, sans-serif" size="2" > color="#FFFFFF">P/L</font></td> > </tr> > <? > $newconnection = > odbc_connect("*********","***********","*************",""); // "*" is just > filler for security purposes. > $newquery = "SELECT * FROM transxn where symbol='$sym' AND > new_close='CLOSE'"; > $newresult = odbc_do($newconnection, $newquery); > $color = 0; > $z = 0; > while (odbc_fetch_into($newresult, $i, &$fields)) > { > $sl = $fields[1]; > $di = $fields[2]; > $do = $fields[3]; > $buy = $fields[4]; > $sell = $fields[5]; > $qty = $fields[7]; > file://Run price in and price out data > if ($sl == "SHORT") > { > $pricein = $sell; > $priceout = $buy; > > $pl = $sell - $buy; > } > > if ($sl == "LONG") > { > $pricein = $buy; > $priceout = $sell; > > $pl = $sell - $buy; > } > > if ($color == 0) > { > $tcolor = "#DEAA42"; > $text = "#313463"; > $color = 1; > } > else > { > $tcolor = "#313463"; > $text = "#FFFFFF"; > $color = 0; > } > > print("<tr bgcolor=\"$tcolor\">\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">$sl</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">$di</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">$do</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">$pricein</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">$priceout</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">$qty</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"$text\">"); > $money = $qty*$pl; > $sum = $sum + $money; > printf("%0.2f",$money); > print("</font></td>\n"); > print("</tr>\n\n"); > } > print("<tr bgcolor=\"#FFFFFF\">\n"); > print("<td colspan=\"5\"><font face=\"Arial, Verdana, sans-serif\" > size=\"2\" color=\"$text\"> </font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"#000000\">Total Profit/Loss:</font></td>\n"); > print("<td><font face=\"Arial, Verdana, sans-serif\" size=\"2\" > color=\"#000000\">\n"); > printf("%0.2f",$sum); > print("</font></td>\n"); > print("</tr>\n"); > ?> > </table> > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

address at home for this list and have never received any spam under that account.

Same goes for this email address here. The only spam I get here is from maillists that I signed up on that won't take me off.

CDitty

______________________________ Reply Separator _________________________________ Subject: [PHP3] FAO admin: Too much spam Author: php3-return-80522-CDitty=email.usps.govlists.php.net at INTERNET Date: 3/9/00 12:12 PM

Since joining this list, I have started getting *HUGE AMOUNTS OF SPAM*. Is the 'who' function disabled?

I also keep getting bounces from expired accounts when I post to the list.

The list is a valuable resource, but its becoming expense to use!

Colin

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Try

echo (int)$items;

On Thu, 09 March 2000, Kris Dahl wrote:

> > on 3/9/00 6:56 AM, David Scatigna at davidtomato.it wrote: > > > he following code return me a number in the format #.0 > > > > How I Can eliminate the ".0"??? > > > > if ($items!=0): > > if ($items=="1"): > > echo "Il carrello contiene "; > > echo $items; > > echo " prodotto"; > > else: > > echo "Il carrello contiene "; > > echo $items; > > echo " prodotti"; > > endif; > > endif; > > sprintf() is what you'll want to use. There is documentation for this in > the PHP manual. > > -k > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

______________________________________________________________ Go Cubs Email - The Official Email Service of the Chicago Cubs Get your free Go Cubs Email account http://www.cubs.com

attached mail follows:

You may do

if ($colors) { for ($x=0;$x<count($colors)-1;$x++) echo $colors[$x]. ", "; echo $colors[$x]; }

so the last echo is out of the for, that's why you get out of it at count-1.

hope this works for you

-----Mensaje original----- De: Margie Wiers [SMTP:productiproductivetravel.com] Enviado el: Thursday, March 09, 2000 10:30 AM Para: php3lists.php.net Asunto: Re: [PHP3] multiple selects (was getting values from. . .)

Hello all,

Thanks to all for previous help. Now, I have just one more thing to fix in selecting multiple colors on my html form. On the results page this works nicely.

if ($colors) { for ($x=0;$x<count($colors);$x++) { echo $colors[$x]. ", ";

As you can see, all the multiple selections are nicely separated commas. However, it would be nice if I didn't have a comma at the end of the list because now it prints

Favorite color(s): Red, Orange, Blue, / / final comma

But I want

Favorite color(s): Red, Orange, Blue / / no final comma

I've fiddled around to try to make it work, but is there a not-to-complicated way to do this ?

TIA, Margie

attached mail follows:

Thank you, Jorge.

It is working as I wanted it. Thank you everyone for your suggestions. It is helpful to see different approaches to one problem.

Margie

> You may do > > if ($colors) { > for ($x=0;$x<count($colors)-1;$x++) > echo $colors[$x]. ", "; > echo $colors[$x]; > } > > so the last echo is out of the for, that's why you get out of it at count-1. > > hope this works for you > > --------------------------------------- > Thanks to all for previous help. Now, I have just one more thing to fix in > selecting multiple colors on my html form. On the results page this works > nicely. > > if ($colors) { > for ($x=0;$x<count($colors);$x++) { > echo $colors[$x]. ", "; > > As you can see, all the multiple selections are nicely separated commas. > However, it would be nice if I didn't have a comma at the end of the list > because now it prints > > Favorite color(s): Red, Orange, Blue, / / final comma > > But I want > > Favorite color(s): Red, Orange, Blue / / no final comma > > I've fiddled around to try to make it work, but is there a > not-to-complicated way to do this ? > > TIA, > Margie > >

attached mail follows:

I think you have the code mixed up or I gave it to you wrong :)

Here is what it should look like:

echo ( "<B>Your Favorite Color(s): </B>" );

if ($colors) { for ($x=0;$x<count($colors);$x++) { if(($x+1) >= count($colors)) { echo $colors[$x]; } else { echo $colors[$x]. ", "; } } }

Notice the open bracket after the else statement. That was missing from your code below. Also, I don't think I put a "$" before the variable x when doing the if statement. Sorry.

That should work.

-Josh

> / / -------#1 all commas still print, even at the end---------- > > echo ( "<B>Your Favorite Color(s): </B>" ); > > if ($colors) { > for ($x=0;$x<count($colors);$x++) { > if((X+1)>=count($colors)) { > echo $colors[$x]; > } > else > > echo $colors[$x]. ", "; > } > } > }

attached mail follows:

Does anyone have any good instructions for installing PHP, Apache, MySQL,PHPLIB? All the ones I have found do not work. I think I may have it all installed now via Redhat RPMS, but from what I understand the PHP will not support MySQL. I am new at this so please do not kill me for asking a dumb question.

Thanks- Justin justinbigcity.nu

attached mail follows:

On Thu, 9 Mar 2000, Justin wrote:

> > Does anyone have any good instructions for installing PHP, Apache, > MySQL,PHPLIB? All the ones I have found do not work. I think I may have it > all installed now via Redhat RPMS, but from what I understand the PHP will > not support MySQL. I am new at this so please do not kill me for asking a > dumb question. > > Thanks- > Justin > justinbigcity.nu > >

I had good success with the _Programming Browser Based Applications with PHP_ book.

Jon

J. J. Horner Linux, Apache, Perl, Unix, Stronghold jhornerknoxlug.org http://www.knoxlug.org System has been up: 26 days.

attached mail follows:

instead of converting it to array, you can use ereg_replace function.

have a look at http://www.php.net/manual/function.ereg-replace.php3 Anyway, all string variables are already an array.

On Thu, 09 March 2000, James Bowen wrote:

> > I need to be able to parse what is returned from a field in MYSQL to > check and make sure that there are no spaces or '#'s in the string. > I need two arrays to do this, i think. But how do I use pointers in > php3? How do I make the string $var into an array that I can traverse > and search for charactors. > > Ex: I need to turn $var= : Test #1 > Into : Test/ /#1 > > All i am given is that $var is what is pulled from the "name" field of > my database, or it is entered into a form by a user. > > Thanks, > > James > > jsbowen2crew.com > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

______________________________________________________________ Go Cubs Email - The Official Email Service of the Chicago Cubs Get your free Go Cubs Email account http://www.cubs.com

attached mail follows:

Unfortunately, ODBC isn't really applicable in my situation... I'm sure ODBC would work well, yes, but my purpose for needing to access PostgreSQL natively is so that I can develop locally on my Windows machine, and then copy the final result straight to the Unix Apache/PHP3/PostgreSQL server my scripts are destined for.

Anyway, I've hunted in the mailing list archives and found several old threads that seem to give the impression that all you need to do to use the pg_xxx() functions is to get a copy of libpq.dll from the PG Win32 client distribution (which I have) and enable it as extension of PHP3 in the .ini file. Is this true?

------------------------------------------- Basil Hussain (basil.hussainreserve.co.uk) Webmaster, Inter-Mediates Ltd.

----- Original Message ----- From: Michael Stearne <mstearneeisolutions.com> To: Basil Hussain <basil.hussainreserve.co.uk> Cc: <php3lists.php.net> Sent: 09 March 2000 18:49 Subject: Re: [PHP3] PostgreSQL Support on Win32?

> There is support through ODBC, but I haven't heard of support for the native > PostgresSQL functions un Win32. > > Michael > > > Basil Hussain wrote: > > > I have a need to access a PostgreSQL database from the Win32 version of > > PHP3. Looking at the distribution, I see no DLL extension for it (i.e. > > something like php3_pgsql.dll). > > > > Is there PostgreSQL support in the Win32 version of PHP? I would've assumed > > there would be, as there is a Windows client utility at least (as well as a > > server version that purports to run under NT - haven't tried it though). > > > > ------------------------------------------- > > Basil Hussain (basil.hussainreserve.co.uk) > > Webmaster, Inter-Mediates Ltd.

attached mail follows:

Basil Hussain wrote:

> > Anyway, I've hunted in the mailing list archives and found several old > threads that seem to give the impression that all you need to do to use the > pg_xxx() functions is to get a copy of libpq.dll from the PG Win32 client > distribution (which I have) and enable it as extension of PHP3 in the .ini > file. Is this true? >

I don't know but I kind of doubt it, I would assume that PG has to be compiled into the win32 binary, like --with-postgres. An I don't know if there are any issues with doing that. If you look at phpinfo() it would say which things are compiled in.

But I don't know so try what you saw in the posts, change the .ini and get the dll.

Michael

> > ------------------------------------------- > Basil Hussain (basil.hussainreserve.co.uk) > Webmaster, Inter-Mediates Ltd. > > ----- Original Message ----- > From: Michael Stearne <mstearneeisolutions.com> > To: Basil Hussain <basil.hussainreserve.co.uk> > Cc: <php3lists.php.net> > Sent: 09 March 2000 18:49 > Subject: Re: [PHP3] PostgreSQL Support on Win32? > > > There is support through ODBC, but I haven't heard of support for the > native > > PostgresSQL functions un Win32. > > > > Michael > > > > > > Basil Hussain wrote: > > > > > I have a need to access a PostgreSQL database from the Win32 version of > > > PHP3. Looking at the distribution, I see no DLL extension for it (i.e. > > > something like php3_pgsql.dll). > > > > > > Is there PostgreSQL support in the Win32 version of PHP? I would've > assumed > > > there would be, as there is a Windows client utility at least (as well > as a > > > server version that purports to run under NT - haven't tried it though). > > > > > > ------------------------------------------- > > > Basil Hussain (basil.hussainreserve.co.uk) > > > Webmaster, Inter-Mediates Ltd. > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hello,

are there any security problems with php3? I mean - how secure is php? I heard someone saying its very unsecure??? Can you tell me more?

Matjaz

attached mail follows:

It's designed to be more secure than other common cgi languages. Because other languages such as perl were designed primarily for other purposes they do not have the safety features built in that php does. php was designed as a web scripting tool and it's security model was designed with that in mind.

still php can only be as secure as your web server.

whoever you overheard saying that php is 'very unsecure' either doesn't know what he/she is talking about, or is the kind of person who throws a fit over having to attach a computer to a network because of the all the security problems.

- Ben

On Thu, Mar 09, 2000 at 07:58:29PM +0100, kesl (my mailing lists) wrote: > > Hello, > > are there any security problems with php3? I mean - how secure is php? > I heard someone saying its very unsecure??? Can you tell me more? > > Matjaz > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi,

You mean we can enable secure mode in PHP like SSL???? As far as I know, there is only one security offered by PHP3 which is require and include function. If I am wong, please correct me.

Mark LO

Mark Lo

Ben Johnson wrote:

> It's designed to be more secure than other common cgi languages. > Because other languages such as perl were designed primarily for other > purposes they do not have the safety features built in that php does. > php was designed as a web scripting tool and it's security model was > designed with that in mind. > > still php can only be as secure as your web server. > > whoever you overheard saying that php is 'very unsecure' either doesn't > know what he/she is talking about, or is the kind of person who throws a > fit over having to attach a computer to a network because of the all the > security problems. > > - Ben > > On Thu, Mar 09, 2000 at 07:58:29PM +0100, kesl (my mailing lists) wrote: > > > > Hello, > > > > are there any security problems with php3? I mean - how secure is php? > > I heard someone saying its very unsecure??? Can you tell me more? > > > > Matjaz > > > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

SSL will be handled by the web server, if the web server is a secure server. php traffic, like all other http traffic, is encrypted while running under a secure server.

I don't know what security benefits require() and include() give.

The security enhancements php offers are, unless I'm mistaken, all selected and configured at compile time. There's securety info at the php.net site.

- Ben

On Fri, Mar 10, 2000 at 04:58:24AM +0800, Mark Lo wrote: > Hi, > > You mean we can enable secure mode in PHP like SSL???? As far as I know, there > is only one security offered by PHP3 which is require and include function. > If I am wong, please correct me. > > Mark LO > > > Mark Lo > > Ben Johnson wrote: > > > It's designed to be more secure than other common cgi languages. > > Because other languages such as perl were designed primarily for other > > purposes they do not have the safety features built in that php does. > > php was designed as a web scripting tool and it's security model was > > designed with that in mind. > > > > still php can only be as secure as your web server. > > > > whoever you overheard saying that php is 'very unsecure' either doesn't > > know what he/she is talking about, or is the kind of person who throws a > > fit over having to attach a computer to a network because of the all the > > security problems. > > > > - Ben > > > > On Thu, Mar 09, 2000 at 07:58:29PM +0100, kesl (my mailing lists) wrote: > > > > > > Hello, > > > > > > are there any security problems with php3? I mean - how secure is php? > > > I heard someone saying its very unsecure??? Can you tell me more? > > > > > > Matjaz > > > > > > > > > > > > -- > > > PHP 3 Mailing List <http://www.php.net/> > > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi,

is oracle fully supported in php? Which version?

What do you guys suggest for a large database anyway? Or a database which has 300 accesses / second? Would linux box survive it?

Matjaz

attached mail follows:

Hi all

Heres a bit of info about the UK user Group, Ive had a response from about 15 - 20 people so I will get one set up an going, any ideas, offers of help are greatly appreciated. I have set up a PHP UK mailing list, if those of you who are intrested could subscribe so we dont bore non UK PHP users

to subscribe Send an email to: phpuk-requestbraintester.com with the subject Subscribe or click below

mailto:phpuk-requestbraintester.com?subject=subscribe

I will send out some infomation on the phpuk list early next week but if you have any ideas or anything at all email me.

James

-- James Moore http://www.prospect-enterprises.co.uk

attached mail follows:

Hi, I just posted this messages to have it archived. I found a solution for a problem with odbc. It was not possible to retrieve the primary key, dec point, default value, not null information and so on with standard php commands. I tried several things out, and I think that it´s not possible with an unified call to retrieve this info. Searching a lot in the Adabas Docs revealed me to do a select this way:

select pos,columnname,mode,datatype,len,dec from columns where tablename='$source_table' order by keypos

simple, not? that works with adabas, I do not know if other dbs will do so

greets, andré

-- ********************************************************** Teamleiter Anwendungsentwicklung André Langhorst - Tel. (05 71) 87 09 60 ITB Ingenieurgesellschaft mbH http://www.itbnet.de Ringstrasse 94 - 32427 Minden Fax (05 71) 87 09 - 40 **********************************************************

attached mail follows:

Hello -

I am trying to get pdflib to work with php3. I have copied example 2 from http://www.php.net/manual/html/ref.pdf.html <http://www.php.net/manual/html/ref.pdf.html> into a file called pdf.php3:

Example 2. Creating a PDF document with pdflib 2.x 1 2 <?php 3 $fp = fopen("test.pdf", "w"); 4 $pdf = PDF_open($fp); 5 pdf_set_info_author($pdf, "Uwe Steinmann"); <snip>

When I open the file in netscape, I get the following error:

Fatal error: Call to unsupported or undefined function pdf_open() in /www/pdf.php3 on line 3

I am using a new install of RedHat 6.1. I have compiled the components as follows. Can someone please tell me what I am doing wrong?

Thanks - Jim Ide

-----

goto http://www.pdflib.com/pdflib/download/ get pdflib-3.0.tar.gz (save in /usr/local/src) cd /usr/local/src tar -xvzf pdflib-3.0.tar.gz cd /usr/local/src/pdflib-3.0 ./configure --prefix=/usr/local \ --enable-shared=yes \ --with-pnglib=no \ --with-tifflib=no \ --with-zlib=no make make test make install

goto http://www.apache.org/dist get apache_1.3.12.tar.gz (save in /usr/local/src) cd /usr/local/src tar -xvzf apache_1.3.12.tar.gz cd /usr/local/src/apache_1.3.12 ./configure

goto http://www.php.net/download-php.php3 get php-3.0.15.tar.gz (save in /usr/local/src) cd /usr/local/src tar -xvzf php-3.0.15.tar.gz cd /usr/local/src/php-3.0.15 ./configure --with-mysql=/usr/local/mysql \ --with-apache=/usr/local/src/apache_1.3.12 \ --with-config-file-path=/usr/local/lib \ --with-pdflib=/usr/local/lib \ --enable-track-vars make make install

cd /usr/local/src/apache_1.3.12 ./configure --prefix=/usr/local/apache \ --activate-module=src/modules/php3/libphp3.a make make install

attached mail follows:

Hello,

I am just learning PHP, but seem to have a good grasp on the the concepts and I want to use PHP to program a new project in our office.

We want to setup a database to be our rolodex for clients, track our time sheets, and tally up all of the time spent on a client among all users that have worked on that client and print out a "Total hours worked" sheet for each client.

I know this is a simple database, but it is kind of like combining 3 databases together. Can PHP do something this?

How can I use what we have to achieve this type of database.

We have a NT 4.0 server and will be running everything off of it. We have MS Access as a database on there now. Will PHP work with Access or will we need to use other software?

Suggestions welcome.

Your help is appreciated.

Kevin kevindddusa.com

attached mail follows:

Kevin, PHP has functions for odbc which will work with MS Access. And yes php can do what you want to do in regards to the office project. -----Original Message----- From: Kevin Old [mailto:kevindddusa.com] Sent: Thursday, March 09, 2000 2:51 PM To: php3lists.php.net Subject: [PHP3] Database in PHP?

Hello,

I am just learning PHP, but seem to have a good grasp on the the concepts and I want to use PHP to program a new project in our office.

I know this is a simple database, but it is kind of like combining 3 databases together. Can PHP do something this?

How can I use what we have to achieve this type of database.

We have a NT 4.0 server and will be running everything off of it. We have MS Access as a database on there now. Will PHP work with Access or will we need to use other software?

Suggestions welcome.

Your help is appreciated.

Kevin kevindddusa.com

attached mail follows:

PHP can do this no problem. You should think about looking into projects people have already started that are similiar to yours. Check out the http://www.php.net/projects.php3 page on the PHP.net site.

Michae

Kevin Old wrote:

> Hello, > > I am just learning PHP, but seem to have a good grasp on the the > concepts and I want to usePHP to program a new project in our office. > > We want to setup a database to be our rolodex for clients, track our > time sheets, and tally up all of the time spent on a client among all > users that have worked on that client and print out a "Total hours > worked" sheet for each client. > > > > I know this is a simple database, but it is kind of like combining 3 > databases together. Can PHP do something this? > > How can I use what we have to achieve this type of database. > > We have a NT 4.0 server and will be running everything off of it. We > have MS Access as a database on there now. Will PHP work with Access > or will we need to use other software? > > Suggestions welcome. > > Your help is appreciated. > > Kevin > kevindddusa.com

attached mail follows:

All,

I have just started using the Wrox "Professional PHP Programming" book and have attempted to run some of the intro/simple scripts both on the server at my job and on another server I have access to.

In both cases, my attempts to run the scripts yield an error 405, method POST not allowed.

What would the reason for this be, and can I remedy it w/o having to ask busy sysadmins for favors? If not it isn't a big deal, since I'm running Linux/Apache/MySQL at home.

Thanks for any insight or advice.

Glenn

_________________________________________________________________________ | // G l e n n B e c k e r | | // The last ideology, Capitalism, is no more than a skin-disease of the | // Very Late Neolithic. It's a desiring-machine running on empty. | // -- Hakim Bey | | // glennscifi.com | _________________________________________________________________________|

attached mail follows:

Hi all,

I am running into some database difficulty and am in desperate need of assistance ... !

I am trying to run a stored procedure from Sybase using an ODBC connection. The SP has two output variables. When I run the same SQL code (obviously with the appropriate values) from an ISQL window, I receive two results, one returns no rows, and the other returns the desired values. When I try to run the SP using the following code, I can only retrieve the result that returns no rows. I am guessing that I need to use the odbc_prepare function, but I cannot find good enough documentation to tell. Maybe I need do this as a transaction ??? how ??? Any help would be greatly appreciated ...

<% $connection_id = odbc_connect("TEST", "user", "password");

$query = "DECLARE error_hdr varchar(50), error_msg varchar(255)\n". "EXEC sys_com_err_msg_sp\n". "err_key = \"$error_key\",\n". "err_code = $error_code,\n". "err_level = \"$error_level\",\n". "hdr = error_hdr output,\n". "msg = error_msg output\n". "SELECT error_hdr, error_msg";

$result_id = odbc_exec($query); odbc_result_all($prepare_id, "border=1 width=90%"); odbc_close($connection_id); %>

Thanks! Dave Homsher MACtac Information Technology "He who controls the past controls the future. He who controls the present controls the past." - George Orwell, "1984"

attached mail follows:

Hi, I need some basic help with filemtime(). Just for background, I am running the PHP 4.0b4pl1 as an Apache module on a RH 6.0 Linux machine. I call this routine and print the result with the following code fragment:

$last_backup = filemtime("/sysback"); echo "The last system backup was performed on $last_backup";

The output that I see is:

The last system backup was performed on 952631687

My problem is that I don't know what format filemtime() returns (it is obviously not 3/2/00 9:55:11), and I cant find this info in the PHP documentation. Can anyone tell me how 952631687 relates to a human-readable date/time stamp?

Regards, Jason C. Murray

Email Address: jmurraydicatech.com DICA Technologies, Inc. 207 High Point Avenue Portsmouth RI 02871 Web Address: www.dicatech.com

attached mail follows:

> machine. I call this routine and print the result with the following > code fragment: > $last_backup = filemtime("/sysback"); > echo "The last system backup was performed on $last_backup"; > The output that I see is: > The last system backup was performed on 952631687 > My problem is that I don't know what format filemtime() returns (it is > obviously not 3/2/00 9:55:11), and I cant find this info in the PHP > documentation. Can anyone tell me how 952631687 relates to a > human-readable > date/time stamp?

It's a unix time stamp. It represents the number of seconds since Dec. 31, 1969.

Look up the date() function to see how you can output the results how you want.

Chris

attached mail follows:

Hi, does anyone know if wddx is the best technique to exchange data structured data via web? I looked on their site and the last news is from dec '98 are there newer specs, techs or similar? I want to exchange XML data via web.

Does anyone know of an object orientated free db just what mysql is for relational data?

Can anyone provide usefull links on this topic and how to use PHP with all of it?

thx, andré

attached mail follows:

Can MySQL use views at all? I know MSSQL have views but I never heard of views in mysql.

interesting...

berber

-----Original Message----- From: Tyrone Watt [mailto:tyroneintercape.co.za] Sent: Monday, March 09, 1998 3:48 PM To: PHP list Subject: Re: [PHP3] create view in mysql

I dont know mysql but the SQL statement to create a view is

create view MYVIEW (MYCOL1, MYCOL2, MYCOL3) as select COL3, COL9, COL23 from MYTABLE where COL7='abc';

Enter that in your sql monitor or whatever, where MYVIEW is the name of the view, MYCOL is the name of the columns in the view. The select statement can be any normal SQL select. Cheers Tyrone

----- Original Message ----- From: fota <fotasopronbutor.hu> To: PHP list <php3lists.php.net> Sent: Thursday, March 09, 2000 2:25 PM Subject: [PHP3] create view in mysql

> Hi, everybody! > > I want to create a view table, but I don't know how I can do it. > > Please help me! > > > Fonyi Tamás > fotasopronbutor.hu > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net >

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

I believe in the very latest version of mysql you can create a temporary table. The table is only visible by the connection that created it, and the table is destroyed when the connection disappears. I guess that would be a cursor, right? not a view. as far as I know mysql has no support for views, but this cursor could be a very good half step in that direction.

It's done with the create table command. a select clause has been added to the end of the create table command also, so the table can be populated at the same time it's created.

- Ben

On Thu, Mar 09, 2000 at 10:16:43PM +0200, Boaz Yahav wrote: > Can MySQL use views at all? > I know MSSQL have views but I never heard of views in mysql. > > interesting... > > berber > > > -----Original Message----- > From: Tyrone Watt [mailto:tyroneintercape.co.za] > Sent: Monday, March 09, 1998 3:48 PM > To: PHP list > Subject: Re: [PHP3] create view in mysql > > > I dont know mysql but the SQL statement to create a view is > > create view MYVIEW (MYCOL1, MYCOL2, MYCOL3) as > select COL3, COL9, COL23 from > MYTABLE where COL7='abc'; > > Enter that in your sql monitor or whatever, where MYVIEW is the > name of the view, MYCOL is the name of the columns in the view. > The select statement can be any normal SQL select. > Cheers > Tyrone > > ----- Original Message ----- > From: fota <fotasopronbutor.hu> > To: PHP list <php3lists.php.net> > Sent: Thursday, March 09, 2000 2:25 PM > Subject: [PHP3] create view in mysql > > > > Hi, everybody! > > > > I want to create a view table, but I don't know how I can do it. > > > > Please help me! > > > > > > Fonyi Tamás > > fotasopronbutor.hu > > > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

I think this feature is more for sub selects. Views are more permanent structures. You can read in the manual 5.4.6 that mysql doesn't support views but it is on the TODO list.

Michael

Ben Johnson wrote:

> I believe in the very latest version of mysql you can create a > temporary table. The table is only visible by the connection that > created it, and the table is destroyed when the connection disappears. > I guess that would be a cursor, right? not a view. as far as I know > mysql has no support for views, but this cursor could be a very good > half step in that direction. > > It's done with the create table command. a select clause has been added > to the end of the create table command also, so the table can be > populated at the same time it's created. > > - Ben > > On Thu, Mar 09, 2000 at 10:16:43PM +0200, Boaz Yahav wrote: > > Can MySQL use views at all? > > I know MSSQL have views but I never heard of views in mysql. > > > > interesting... > > > > berber > > > > > > -----Original Message----- > > From: Tyrone Watt [mailto:tyroneintercape.co.za] > > Sent: Monday, March 09, 1998 3:48 PM > > To: PHP list > > Subject: Re: [PHP3] create view in mysql > > > > > > I dont know mysql but the SQL statement to create a view is > > > > create view MYVIEW (MYCOL1, MYCOL2, MYCOL3) as > > select COL3, COL9, COL23 from > > MYTABLE where COL7='abc'; > > > > Enter that in your sql monitor or whatever, where MYVIEW is the > > name of the view, MYCOL is the name of the columns in the view. > > The select statement can be any normal SQL select. > > Cheers > > Tyrone > > > > ----- Original Message ----- > > From: fota <fotasopronbutor.hu> > > To: PHP list <php3lists.php.net> > > Sent: Thursday, March 09, 2000 2:25 PM > > Subject: [PHP3] create view in mysql > > > > > > > Hi, everybody! > > > > > > I want to create a view table, but I don't know how I can do it. > > > > > > Please help me! > > > > > > > > > Fonyi Tamás > > > fotasopronbutor.hu > > > > > > > > > > > > -- > > > PHP 3 Mailing List <http://www.php.net/> > > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > > To search the mailing list archive, go to: > > http://www.php.net/mailsearch.php3 > > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > > > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: > > http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > > > -- > > PHP 3 Mailing List <http://www.php.net/> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > > To contact the list administrators, e-mail: php-list-adminlists.php.net > > -- > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

I can't find a way to create a table in mySql from a PHP3 script.

There is a mysql_create_db but I can't find any mysql_create_table in the php manual.

Can anyone help me with this one. I am starting to move from perl to php.

Regards,

Luis Madaleno OCX SoftWare

attached mail follows:

You can use a query and do something like "create table [name] ..." I believe that is how I've done it in the past.

Regards, Jason

> -----Original Message----- > From: Luis Madaleno [mailto:ocxmail.telepac.pt] > Sent: Thursday, March 09, 2000 1:20 PM > To: php3lists.php.net > Subject: [PHP3] mysql_create_table? > > > I can't find a way to create a table in mySql from a PHP3 script. > > There is a mysql_create_db but I can't find any mysql_create_table in the > php manual. > > Can anyone help me with this one. I am starting to move from perl to php. > > Regards, > > Luis Madaleno > OCX SoftWare > > > > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

_______________________________________________________ Site Design, Hosting, and E-Commerce at www.webpipe.net

attached mail follows:

Closest i've found is

comp.infosystems.www.servers.unix

Warren On 9 Mar 2000 06:22:25 -0800, you wrote:

>Folks > >Can you direct me to a similar list for Apache. >TIA

attached mail follows:

Hi I have a problem, I have a file that starts with this : <?php include("class.graph"); include("data.php3"); $a = array( $key1, array(95,70,85), // Goals for this year $data1);

and data.php3 : <?php putenv("ORACLE_HOME=/usr/local/oracle/8i/app/oracle/product/8.1.5"); $conn = OCILogon("majido","majid0","test"); $sql = "select ETMN,MTMN, STMN from scores"; $sql .= " where year = '98'and "; $sql .= " did in ( select did from districts where dist = '$dist')"; $stmt1 = OCIParse($conn, $sql);

OCIExecute($stmt1); $nrows = OCIFetchStatement($stmt1,$results); while ( list( $key, $val ) = each( $results )) { $key1[] = $key; }

for ( $i = 0; $i < $nrows; $i++ ) { reset($results);

while ( $column = each($results) ) { $data = $column['value']; $data1[] = $data[$i]; } } OCIFreeStatement($stmt1); OCILogoff($conn);

My prblem is the variable array $key1 is ok but the array $data1 is empty. but when I test data.php3 alone, and print the element of each arrays, it works fine, could you please help me. Regards

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

attached mail follows:

I have searched PHP3 doc several times, specifically the file system functions. I see how to create files and directories and remove directories but *not* how to remove a file! Am I just blind?

There is a rmdir to remove a directory but no rm to remove a file! How do you delete a file?

- Doug

attached mail follows:

On Thu, 9 Mar 2000, Doug Williams wrote:

> I have searched PHP3 doc several times, specifically the file system functions. I see how to create files and directories and remove directories but *not* how to remove a file! Am I just blind? > > There is a rmdir to remove a directory but no rm to remove a file! How do you delete a file?

It's unlink(), see also the dummy entry delete().

-Egon

PS: Please make some linebreaks in your paragraphs.

-- Grueninger Str. 6, 70599 Stuttgart http://php.net/manual/, http://php.net/books.php3 http://www.uni-hohenheim.de/~windband

attached mail follows:

I just can not figure out why the following query failed:

/* After selecting the database,we can send our query to the server,extract the result,display it, and free the result set as follows: */

$Query = 'LOAD DATA LOCAL INFILE "Kennedy.txt" INTO TABLE labeltracking FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY "\"" LINES TERMINATED BY ";"';

$result = mysql_query ($Query) or die ("Query failed");

I would appreciate a response, please.

thanks

Jean-Claude Bateau Mailto:webmasterjbateau.com 702-338-7748

text/plain attachment: Query_failed_Message.txt

attached mail follows:

Hello,

I am getting an array that looks like this "3.33" Hex: 33 2E 33 33 How can I parse 3.33 ouyt of it.

Thanx

attached mail follows:

You can use 'explode' function with "\"".

On Thu, 09 March 2000, Nazar Kulynych wrote:

> > Hello, > > I am getting an array that looks like this > "3.33" Hex: 33 2E 33 33 > How can I parse 3.33 ouyt of it. > > Thanx > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

______________________________________________________________ Go Cubs Email - The Official Email Service of the Chicago Cubs Get your free Go Cubs Email account http://www.cubs.com

attached mail follows:

Hi folks,

Does anyone know how I would go about creating a CRC of a given string and a given file?

I would like to be able to save a CRC of a URL and a CRC of the page represented by that URL to my mysql database. This can then be used to determine if the URL has changed and if the file contents of the webpage have changed. I have not found a function for this, and do not know the algorithm that would be required to do this. I understand that CRCs can be calculated at varying levels of detail - I would prefer the greatest reasonable level to ensure that it is least likely that I will end up with duplicate values on different pages or URLs.

Any help is greatly appreciated.

I am using PHP v3.015 with Apache 1.3.9 on FreeBSD 3.4 if that has any bearing on the issue (at least without checking I believe these are correct - I did not set up the server).

Warren Grant Webmaster Maple Square - http://www.maplesquare.com

attached mail follows:

Warren,

You could certainly code your own crc routine, but why not just use the md5 function? OK, other than that it returns 32bytes rather than a long int?:)

Hank

-----Original Message----- From: Warren Grant [mailto:wgrantmaplesquare.com] Sent: Thursday, March 09, 2000 3:18 PM To: php3lists.php.net Subject: [PHP3] CRC in PHP3

Hi folks,

Does anyone know how I would go about creating a CRC of a given string and a given file?

Any help is greatly appreciated.

I am using PHP v3.015 with Apache 1.3.9 on FreeBSD 3.4 if that has any bearing on the issue (at least without checking I believe these are correct - I did not set up the server).

Warren Grant Webmaster Maple Square - http://www.maplesquare.com

-- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe

lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe

lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Hi,,

Please give me some idea of how does SSL works?? I mean do i need to write the script to make it work.. Also, I am located outside US. Could you please tell me some information on which SSL is available outside US and also could be able to use with PHP and MySQL.

Thank You for your valuable informations.

Mark Lo

attached mail follows:

Yurais Fernández LealTest, Would like to know if I directed the mail to the right place.-..

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

Yurais Fernández Leal MediRed Network SysAdmin. yuraismedired.scu.sld.cu Phone: (226) 54204 ICQ: 33792610 ICQ-IntraNet-UIN: 1001 Pager: http://www.icq.com/33792610 URL: http://facimed.scu.sld.cu/

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

attached mail follows:

From: "Valdir" <valdir

albra.com.br> To: <php3

lists.php.net> Date: Thu, 9 Mar 2000 18:24:27 -0300 Message-ID: <01bf8a0d$d9ded2d0$2b00a8c0

oracle> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0092_01BF89F4.B4919AD0" Subject: OCIFetch

------=_NextPart_000_0092_01BF89F4.B4919AD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi all,

I'm using PHP 3.0.14, Linux 2.2.13 and Apache 1.3.9.

Configuration: ./configure '--with-apxs' '--with-shared-apache=/home/httpd' '--with-apache=/home/httpd' '--with-gd=no' '--with-oracle=/home/oracle/product/8.0.5' '--with-config-file-path=/tmp/apache' '--enable-safe-mode=yes' '--with-exec-dir=/tmp/apache' '--enable-track-vars=yes' '--enable-magic-quotes=yes' '--enable-debugger=yes' '--enable-force-cgi-redirect=yes'

Oracle is in WinNT4.0 Server. PHP is using OCI8 to access Oracle.

When selecting columns that have more than "X" chars on its name, the result is truncated. Sometime nothing returns in such column.

Executing the same query in PLSQL all works fine...

What is the best way to work (in PHP) with the result from a Query?

OCIFetch/OciResult, OCIDefineByName or OCIFetchStatement?

Thanks in advance,

Valdir Dias Sao Paulo Brazil

------=_NextPart_000_0092_01BF89F4.B4919AD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD>

<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type> <META content='"MSHTML 4.71.1712.3"' name=GENERATOR> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT color=#000000 size=2>Hi all,</FONT></DIV> <DIV><FONT color=#000000 size=2></FONT> </DIV> <DIV><FONT color=#000000 size=2>I'm using PHP 3.0.14, Linux 2.2.13 and Apache 1.3.9.</FONT></DIV> <DIV><FONT color=#000000 size=2></FONT> </DIV> <DIV><FONT color=#000000 size=2>Configuration: ./configure '--with-apxs' '--with-shared-apache=/home/httpd' '--with-apache=/home/httpd' '--with-gd=no' '--with-oracle=/home/oracle/product/8.0.5' '--with-config-file-path=/tmp/apache' '--enable-safe-mode=yes' '--with-exec-dir=/tmp/apache' '--enable-track-vars=yes' '--enable-magic-quotes=yes' '--enable-debugger=yes' '--enable-force-cgi-redirect=yes'</FONT></DIV> <DIV><FONT color=#000000 size=2></FONT> </DIV> <DIV><FONT size=2>Oracle is in WinNT4.0 Server. PHP is using OCI8 to access Oracle.</FONT></DIV> <DIV><FONT size=2></FONT> </DIV> <DIV><FONT color=#000000 face="" size=2>When selecting columns that have more than "X" chars on its name, the result is truncated. Sometime nothing returns in such column.</FONT></DIV> <DIV><FONT color=#000000 face="" size=2></FONT> </DIV> <DIV><FONT color=#000000 face="" size=2>Executing the same query in PLSQL all works fine...</FONT></DIV> <DIV><FONT color=#000000 face="" size=2></FONT> </DIV> <DIV><FONT size=2>What is the best way to work (in PHP) with the result from a Query?</FONT></DIV> <DIV><FONT size=2></FONT> </DIV> <DIV><FONT size=2>OCIFetch/OciResult, </FONT><FONT size=2>OCIDefineByName or OCIFetchStatement?</FONT></DIV> <DIV><FONT size=2></FONT> </DIV> <DIV><FONT size=2>Thanks in advance,</FONT></DIV> <DIV><FONT size=2></FONT> </DIV> <DIV><FONT size=2>Valdir Dias</FONT></DIV> <DIV><FONT size=2>Sao Paulo</FONT> </DIV> <DIV><FONT size=2>Brazil</FONT> </DIV></BODY></HTML>

------=_NextPart_000_0092_01BF89F4.B4919AD0--

attached mail follows:

I am passing the string 'Test#1' from one php3 page to another php3 page. Somewhare along the way, PHP drops off the '#1'. what escape charactors are necessary for me to avoid this?

Test'#'1 Test/#1

none of these above work, and i don't know php well enough to know what charactors i need to use to ensure that the # stays in the string.

Thanks,

James

attached mail follows:

How can I ge the referring document in a PHP script? It would be very nice for debugging to be able to print the page that led to an error, but I couldn't fine a function or variable to do this in the docs or my PHP book. Am I missing something?

- Chris

attached mail follows:

Try $HTTP_REFERER . For more system variable, check phpinfo()

Good Luck, Jason Cox

> -----Original Message----- > From: christourneyland.com [mailto:christourneyland.com] > Sent: Thursday, March 09, 2000 2:32 PM > To: php3lists.php.net > Subject: [PHP3] How to get the referral URL > > > How can I ge the referring document in a PHP script? It would be very nice > for debugging to be able to print the page that led to an error, but I > couldn't fine a function or variable to do this in the docs or my > PHP book. > Am I missing something? > > - Chris > > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: > http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

_______________________________________________________ Site Design, Hosting, and E-Commerce at www.webpipe.net

attached mail follows:

Anybody know if it is possible to call a predefined function from a hypertext link? onClick or something of the sort?

I think I am just going to have to put the functionality in a new php document...

Thanks.

Kit Plummer

attached mail follows:

Hi all,

I finaly could compile php 3.0.15 with mcrypt support and get it running without core dumps. I followed a note on the PHP site's mcrypt reference where it says to compile php 3.0.15 with libmcrypt 2.2.6 it should be compiled with --disable-posix-threads.

Thanks, Roberto.

attached mail follows:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Anyone tried this configuration yet? Any opinions on how well (or not) it works? I just got an Oracle8i CD-ROM (Developer license) and am itching to try it out. Thanks! Geordon VanTassle, MCP

-----BEGIN PGP SIGNATURE----- Version: PGP 6.5.1i for non-commercial use <http://www.pgpi.com/> Comment: It's just like an envelope...

iQA/AwUBOMgh+6hTQhgLnpE/EQIXWgCg2XQGn/LBPag2zk/NT+P8tpIWrxQAoIM1 M8TX2QP9BKOMwLLiWzGMGT/K =LTy5 -----END PGP SIGNATURE-----

application/octet-stream attachment: VANTASSLE__GEORDON_M.__AIT_.vcf

image/gif attachment: Tech_Tools.gif

attached mail follows:

"Robert V. Zwink" wrote: > > I am running a rather extensive LEFT JOIN (php and MySQL) to produce desired > results from a very normalized database. Hopefully I'm not out of line to > ask, but I am hoping for hints to attain an accurate benchmark of my queries > efficiency, as well as references to query syntax/table optimization > information. > > Currently I use a function that displays time of query in milliseconds, and > I also multiply the results of the EXPLAIN "rows" column to show total > possible rows queried. Are there other ways to test time/efficiency? > > Attached are table descriptions, and specific SQL query. I appreciate any > input large or small.

mysql> DESCRIBE system; +-----------------------------+--------------------------------------------------+------+-----+---------+----------------+ | Field | Ty