OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Subject: php3 Digest 7 May 2000 04:55:02 -0000 Issue 1655
From: php3-digest-helplists.php.net
Date: Sat May 06 2000 - 23:55:02 CDT


php3 Digest 7 May 2000 04:55:02 -0000 Issue 1655

Topics (messages 89331 through 89358):

WAP / WML Beta Testers Needed
        89331 by: Dieter Kneffel <datawap4.com>

php editing tool of choice?
        89332 by: "Patrick Rea" <preacsolve.net>
        89333 by: Rob Hardowa <hardowask.sympatico.ca>
        89334 by: "Mark Maggelet" <maggeletmminternet.com>

Date operation
        89335 by: Massimiliano Belletti <mbellettigalactica.it>

problems with second time validation
        89336 by: "hakan gezgin" <webamigohotmail.com>
        89338 by: Alfred Perlstein <brightwintelcom.net>

Rasmus hailed as the coolest coporate suit in the known universe.
        89337 by: "Phil Driscoll" <phildialsolutions.co.uk>
        89349 by: Paul DuBois <paulsnake.net>

php 3.0.16 and htdig 3.1.5
        89339 by: Joseph Cheek <josephcheek.com>
        89340 by: "Manuel Lemos" <mlemosacm.org>
        89352 by: Rasmus Lerdorf <rasmusphp.net>

MIPS libphp3.so file needed
        89341 by: Mark Selby <selby_markyahoo.com>

New Win32 PHP editor in the works.
        89342 by: "Tony Kirk" <tkirkcablespeed.com>

oracle and PHP
        89343 by: Ron Chmara <ronOpus1.COM>
        89356 by: Mark Nold <marknalverstone.com.au>
        89358 by: Allen Francom <aefprismnet.com>

f2s.com WAS RE: [PHP3] PHP Value Hosting
        89344 by: "A Robertson" <elite2000btinternet.com>

Installation
        89345 by: Jue Jin <jinjuecoe.neu.edu>

A very odd request
        89346 by: Vidyut Luther <vluthergotslack.com>

Profile Page
        89347 by: "Matt Fox" <coa_projecthotmail.com>

How we defaced www.apache.org (fwd from BugTraq)
        89348 by: sashamysql.com

Virus detector for upload files!!!
        89350 by: Mark Lo <marklokynetvigator.com>

XML Parser question - sooooo close to working for a needed HTML problem...
        89351 by: Allen Francom <aefprismnet.com>

PHP training
        89353 by: Scott Gray <scottycm.math.uiuc.edu>

PERL QUESTION:alive or dead?
        89354 by: Dean James <sacramonemediaone.net>

search not working
        89355 by: curt <curtpdxinetarena.com>
        89357 by: Allen Francom <aefprismnet.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 need some volunteers to test our WAP/WML portal at
http://mopilot.com/portal/main.php3 You will need a
WAP/WML Browser or a WAP-compatible mobile-phone
in order to access the pages.

In particular, we need to evaluate the proper function if the
cache-headers, forms, etc - just all dynamic information that is
passed from and to the client when using a WAP-browser or
WAP-gateway.

This also includes the implemented session-management. We
noticed some problems with transparent proxys and headers!
[can someone tell me what the 'Age:' header is about????]

Upon your first visit, an email with your password is generated
and sent to you.

Also, if you have a mobile phone or some uncommon device, please
go to http://mopilot.com/ and give us feedback by using our form,
found at the option 'having problems'; This gives us also information
about your user-agent and the used wap-gateway

Your advice and tips are higly appreciated!
Thanks,

dieter

PS: If you have own WAP/WML pages, feel free to add them to our
search engine at http://mopilot.com ( using a normal html-browser )

attached mail follows:


Subject: RE: [PHP3] php editing tool of choice?
> > if you need good search and replace/grep features and php
> > syntax highlighting try editplus for pc. www.editplus.com (it
> > also has builtin ftp, macros, everything homesite has) and
> > it's faster and only $30.
>
> But can it interface with some sort of Source Control (such
> as VSS)?
>

Anyhting can be dropped into Source Safe. You may have to do it manually but
it is easy. Personally, I use VSS to back up my mechanical design files
(ACAD 14) as well as circuit board layouts (ProCAD).
Because PHP is text based (like all source code) you will still be able to
do a DIFF and History easily.

Patrick Rea
Toronto

attached mail follows:


Wow,

Nobody even mentioned some of the Linux editors.....

I use a bunch of them depending on what I'm doing. Most of the Linux ones are
somewhat early in development, but at the some time a small number are in rapid
change and very good. Here's a list of what I use:

* Bluefish
   Has drop-down list that inserts ANY PHP function (shows prototype as well)
* Quanta
*Webmaker
*Webdesigner
*JCC

I particularly use Bluefish for the PHP drop-down function prototype
list/function inserter...and custom syntax highlighting. To get the highlighter
to work well from stock mode make sure you use <SCRIPT LANGUAGE ="PHP">
</SCRIPT> instead of <? ?> or your script will be highlighted in all red.

I'm not sure of the URLs of these at the moment...I'm in a bit of a
hurry.....but you can find them at http://linux.davecentral.com or
http://www.linuxberg.com

Rob

--
 FORTRAN rots the brain.
		-- John McQuillin
--------------------------------------------------------
 This mail proudly composed and transmitted without the  
 interference of any Micro$oft products or protocols. 
--------------------------------------------------------

attached mail follows:


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

On 5/5/00 at 10:17 PM wmphpgetlost.com.au wrote:

>On 5 May 2000 chriswild.net ("Boget, Chris") wrote about EditPlus: > >>But can it interface with some sort of Source Control (such >>as VSS)? > >hmm, dunno haven't tried , but probably because it (EditPlus) allows >you to define a whole bunch of programming tools which can then be >activated by a button and the message output is collected in an output >window. These programmming tool buttons can be easily set up to run >compilers and other programs and pass the file names as comand line >parameters.

right, I forgot to mention that. This is the main feature that editplus has that homesite doesn't, being able to run a free compiler like javac or borlands c++ tools and seeing the output nicely in an output window makes it compete very well with expensive IDE's like devstudio. On the other hand homesite has the layout mode which is nice for web designers (i guess, I never used it). So if you're mainly a web designer you might like homesite better, but a programmer will probably like editplus better.

>another feature of edit plus that i love is block indenting ie select >a bunch of code and press and tab and it all indents, press shift-tab >and it reverse indents.

that's nice but I think any good editor also has this. I know emacs and homesite will do this too.

- Mark

attached mail follows:


Hi,

there is as short way to diff two date?

Thanks in advance

---------- Massimiliano Belletti

attached mail follows:


hi,

I wrote a little test program with 3 pages to let some simple validation work. it can be tested by beginning at: www.startboxes.com/test/validation/first_name.php3

When I'm on page "first_name.php3" and I don't fill in anything it stays on page "first_name.php3" until I fill in my name. (that's what I want) then I fill my name. When I'm on page "last_name.php3" and I don't fill in anything then it supposed to stay on page "last_name.php3" but it goes to page "first_name.php3", what do I do wrong?

thanks in advance...

THE CODE: --------------------------------------------------------

www.startboxes.com/test/validation/first_name.php3

<html> <head> <title>Untitled</title> </head> <body> <FORM METHOD="post" ACTION="last_name.php3"> <TABLE> <TR> <TD>What's your first name? : </TD> <TD><INPUT name="first_name"></TD> </TR> <TR> <TD></TD><TD><INPUT type=submit value=" Continue! "></TD> </TR> </TABLE> </FORM> </body> </html>

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

www.startboxes.com/test/validation/last_name.php3

<?php if ($first_name =="") { header("Location:http://www.startboxes.com/test/validation/first_name.php3"); exit(); } ?>

<html> <head> <title>Untitled</title> </head> <body> <FORM METHOD="post" ACTION="fathers_name.php3"> <TABLE> <TR> <TD>What's your last name? : </TD> <TD><INPUT name="last_name"></TD> </TR> <TR> <TD></TD><TD><INPUT type=submit value=" Continue! "></TD> </TR> </TABLE> </FORM> </body> </html>

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

www.startboxes.com/test/validation/fathers_name.php3

<?php if ($last_name =="") { header("Location:http://www.startboxes.com/test/validation/last_name.php3"); exit(); } ?>

<html> <head> <title>Untitled</title> </head> <body> <FORM METHOD="post" ACTION="friends.php3"> <TABLE> <TR> <TD>What's your fathers name? : </TD> <TD><INPUT name="name"></TD> </TR> <TR> <TD></TD><TD><INPUT type=submit value=" Continue! "></TD> </TR> </TABLE> </FORM> </body> </html>

________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

attached mail follows:


* hakan gezgin <webamigohotmail.com> [000506 13:21] wrote: > hi, > > I wrote a little test program with 3 pages to let > some simple validation work. > it can be tested by beginning at: > www.startboxes.com/test/validation/first_name.php3 > > When I'm on page "first_name.php3" and I don't fill in > anything it stays on page "first_name.php3" until I fill > in my name. (that's what I want) then I fill my name. > When I'm on page "last_name.php3" and I don't fill in > anything then it supposed to stay on page "last_name.php3" > but it goes to page "first_name.php3", what do I do wrong?

:)

Ok, when you're on last_name.php and don't enter anything in then you go to father_name, father name will redirect you to last_name which notices that now first_name is unset and then redirects you yet again to first_name.php.

You need this in father_name:

header("Location:http://www.startboxes.com/test/validation/last_name.php3?first_name=$first_name");

You also need this in the form on the last_name page:

<input type=hidden value="<?=$first_name?>">

so you can pass first_name off to fathers_name.php

best of luck, -Alfred Perlstein - [brightwintelcom.net|alfredfreebsd.org] "I have the heart of a child; I keep it in a jar on my desk."

> -------------------------------------------------------- > > www.startboxes.com/test/validation/first_name.php3 > > <html> > <head> > <title>Untitled</title> > </head> > <body> > <FORM METHOD="post" ACTION="last_name.php3"> > <TABLE> > <TR> > <TD>What's your first name? : </TD> <TD><INPUT name="first_name"></TD> > </TR> > <TR> > <TD></TD><TD><INPUT type=submit value=" Continue! "></TD> > </TR> > </TABLE> > </FORM> > </body> > </html> > > --------------------------------------------------------- > > www.startboxes.com/test/validation/last_name.php3 > > <?php > if ($first_name =="") { > header("Location:http://www.startboxes.com/test/validation/first_name.php3"); > exit(); > } > ?> > > <html> > <head> > <title>Untitled</title> > </head> > <body> > <FORM METHOD="post" ACTION="fathers_name.php3"> > <TABLE> > <TR> > <TD>What's your last name? : </TD> <TD><INPUT name="last_name"></TD> > </TR> > <TR> > <TD></TD><TD><INPUT type=submit value=" Continue! "></TD> > </TR> > </TABLE> > </FORM> > </body> > </html> > > --------------------------------------------------------- > > www.startboxes.com/test/validation/fathers_name.php3 > > <?php > if ($last_name =="") { > header("Location:http://www.startboxes.com/test/validation/last_name.php3"); > exit(); > } > ?> > > <html> > <head> > <title>Untitled</title> > </head> > <body> > <FORM METHOD="post" ACTION="friends.php3"> > <TABLE> > <TR> > <TD>What's your fathers name? : </TD> <TD><INPUT name="name"></TD> > </TR> > <TR> > <TD></TD><TD><INPUT type=submit value=" Continue! "></TD> > </TR> > </TABLE> > </FORM> > </body> > </html> >

attached mail follows:


Check out the report on The Register about the apache.org defacing.

http://www.theregister.co.uk/000506-000002.html

-- 
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org

attached mail follows:


I think I'd be insulted to be referred to as a "suit". :-)

-- 
Paul DuBois, paulsnake.net

attached mail follows:


i just recently upgraded php to 3.0.16 and htdig to 3.1.5 and now notice a problem. htdig 3.1.5 uses semicolons [;] as separators for CGI variables, and php doesn't recognize semicolons as parameter separators.

as an example, a search that would have been called as

http://search.cheek.com/results.php?words=scsi&config=linuxkb-scsi&method=and&format=long

is now being called as

http://search.cheek.com/results.php?words=scsi;config=linuxkb-scsi;method=and;format=long

my results.php wrapper [around htsearch] expects $words, $config, $method, and $format to be set when entering the page, but instead of

$words == "scsi" $config == "linuxkb-scsi" $method == "and", and $format == "long"

i now get

$words == "scsi;config=linuxkb-scsi;method=and;format=long" $config == "" $method == "", and $format == ""

is there any way to force php3 to recognize the semicolon as a parameter separator? or will i have to parse these by hand?

thanks!

joe

--
Joseph Cheek, Senior Linux Consultant, LinuxCare NW
425 990-1072 voice, 425 990-1074 fax, 206 679-6838 cell
jcheeklinuxcare.com, http://www.linuxcare.com/
Linuxcare.  Sport for the Revolution. 8-)

finger josephcheek.com for .plan and .project info

attached mail follows:


Hello Joseph,

On 06-May-00 18:25:11, you wrote:

>i just recently upgraded php to 3.0.16 and htdig to 3.1.5 and now notice >a problem. htdig 3.1.5 uses semicolons [;] as separators for CGI >variables, and php doesn't recognize semicolons as parameter separators.

AFAIK, you don't have to pass arguments to htsearch separated by semi-colons. You may want to look in this PHP Class that is used to simplify the configuration, indexing and searching of pages using htdig.

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

Regards, Manuel Lemos

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

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

attached mail follows:


Edit your php3.ini file and add this line:

arg_separator = ";"

-Rasmus

On Sat, 6 May 2000, Joseph Cheek wrote:

> i just recently upgraded php to 3.0.16 and htdig to 3.1.5 and now notice > a problem. htdig 3.1.5 uses semicolons [;] as separators for CGI > variables, and php doesn't recognize semicolons as parameter separators. > > as an example, a search that would have been called as > > http://search.cheek.com/results.php?words=scsi&config=linuxkb-scsi&method=and&format=long > > is now being called as > > http://search.cheek.com/results.php?words=scsi;config=linuxkb-scsi;method=and;format=long > > my results.php wrapper [around htsearch] expects $words, $config, > $method, and $format to be set when entering the page, but instead of > > $words == "scsi" > $config == "linuxkb-scsi" > $method == "and", and > $format == "long" > > i now get > > $words == "scsi;config=linuxkb-scsi;method=and;format=long" > $config == "" > $method == "", and > $format == "" > > is there any way to force php3 to recognize the semicolon as a parameter > separator? or will i have to parse these by hand? > > thanks! > > joe > > -- > Joseph Cheek, Senior Linux Consultant, LinuxCare NW > 425 990-1072 voice, 425 990-1074 fax, 206 679-6838 cell > jcheeklinuxcare.com, http://www.linuxcare.com/ > Linuxcare. Sport for the Revolution. 8-) > > finger josephcheek.com for .plan and .project info > > >

attached mail follows:


Hi all,

Anyone have libphp3.so module for MIPS (Cobalt Cube) platform, or perhaps add wisdom to rebuilding the rpm or src on Intel (obviously with MIPS target for the build) without screwing up the current install?

Any help appreciated,

Mark.

__________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

attached mail follows:


Hello I'm currently writing a PHP editor for Windows 9x/NT/2000. The project is currently in PRE-Alpha state, but is for the most part functional.

Anyone who is interested in checking it out and giving feed back can visit: http://3gurus.com/phpdevstudio/

There is download available and a message forum on the site. If you have any questions or comments please email me directly or use the message forum on the site. This will prevent un-needed threads in this group.

Thanks, Tony Kirk

attached mail follows:


Arthur wrote: > RL: > >I'm a little flabberfasted that you have $250,000 to spend but don't need > >transactions and subselects, but hey, what do I know? > Thanks for the info. Sorry for not being more clear. I was wondering if > anyone had experience with Oracle + Oracle App Server versus Oracle + PHP4. > I'm not the one who has 250K to donate to Oracle, and I'm just as > flabbergasted at the intended use of such a budget. It's a company which > has a DB with about 1 million rows in one table and a few thousand in say 3 > others, and they need to do multiple table joins to generate search > results.

So, if they're text records <1024 chars, it's a *really* tiny db right now.

> Hit-rate is not known at this stage as they're still in dev. They > *may* get into e-commerce later, but I see no need to use Oracle/Oracle App > Server until they get to that stage. By the time they do it, 250K will buy > a bigger box even from Sun.

Exactly. Moore's law pretty much means that platform investments are only good for 18 months at most. Add in the fact that your first system will be wrong (Brooke's Law), and you don't really _want_ to throw the entire ball of wax into one investment, one company, until you know exactly what you need, and how you need to do it.

> My question is: cost aside, > does PHP4 + MySQL actually perform as well or better than Oracle + Oracle > App Server when the task is simple and does not require transactions and > subselects.

When the task is simple, yes. MySQL excels at smallish, flattish, high speed transactions. You cannot have the same kind of design as you would be able to have with Oracle. You will, however, have faster, tighter, design....

> When a DB like this does get massive hits, will PHP4 + MySQL > scale well when a more powerful box is used?

Up to parallel, yes. Then you want to have a two tier (PHP box, MySQL box) system. Assuming you're using cheapie boxes, (as compared to Oracle on Sun), you can do thousands of hits a second on off the shelf dual X86 CPU's, with 512 Mb of RAM, on *nix. As long as you have really tiny transactions, in the right table design, almost any db app can be designed to handle that transaction level.

On NT, well, you've got a bit more overhead there, but even a 600Mhz machine running IIS can take thousands of hits a second.... the usual bottleneck is _not_ the CPU, it'a the bandwidth of the site, the actual internet connection. Here, I'll put it this way: If you have a tiny webpage, say, ten 12KByte graphics, another 4 KByte of text, you have a 124KB site. To send that over the net a thousand times in one second, you need a Gigabit LAN connection. That's 1,024,000 KB per second from two NICs, or a 1 GB internet link. Or, put another way, since a T-1 will drive 1.544 Megabits, or .193 MegaBytes per second, you'll need, oh, 5305 T-1's.

Er.. I doubted my math, so crunch it yourself. See how much of your problem needs to be fixed by _redundant_, _mirroring_ db's and servers, vs a "big box" somewhere. This is why there are db's with powerful replication, so there can be a server hanging off of each major backbone. This is where the high cost db's count in web serving, in *replication* to reduce overall site costs. Try calling your ISP and asking for 5305 T-1's. :-) That's what you need to send out that much per second in web pages, after your transactions. ...

So, here's another way to ask the question: How much of the db cost is for redundancy and replication features? And how long do you think it'll be before your site has 327,200 page views, every day? That's how many site visits it takes to hit 1000 per second to the above pages.

-Bop

--
Brought to you from iBop the iMac, a MacOS, Win95, LinuxPPC machine,
which is currently in MacOS land.  Your bopping may vary.

attached mail follows:


Arthur,

We are using PHP3 with large web applications, but on Intranets not 1000000 hits per second web sites ;) But we plan on migrating to PHP4 once we've undergone full testing, but prelim testing shows huge performance gains of up to 80% on the PHP processing (doesnt improve the DB response of course). That is PHP3 as an Apache Module compared to an unoptimised PHP4 CGI.

Mark Nold marknalverstone.com.au Systems Consultant

Change is inevitable, except from vending machines.

On Saturday, 6 May 2000 5:20, Arthur [SMTP:xapx.org] wrote: > >Using this proceedure we have successfully built applications in MS Access > >running on PWS and scaled it up to Oracle on a huge Sun box.... the great > >thing is that you now have a cross platform application.. as long as PHP > >runs on it and you maintain separate .ora, .mysql or whatever you will be > >able to move as you technical needs and managerial whims take you. > > > Thanks for the tips about making an abstraction layer. > > Are you using Oracle with PHP3 or 4? Many providers and IT people still > don't want to use 4 because the "full version" isn't out. I'm not that > concerned about the beta or RC status of PHP4 as it's likely to be out in > full release soon enough. I'd like to know if anyone has used an optimized > PHP4 (Apache module with Zend optimizer?) on big boxes with massive DBs > getting massive hits. How does PHP4 + any DB perform compared with > combinations like Oracle + App Server? > > Regards, > > Arthur

attached mail follows:


AS ALWAYS, It's not what you do but how you do it.

There are very few technologies that cannot perform properly if they're used "properly".

If you have a large scale problem then your application architecture will be most likely to blame for everything that's not fast enough.

For example, you can cache database results, and you can cache page generation results.

This offloads tremendous amount of relational database work, and in the case of scripts or code, far less code has to run to go get a page that has been generated already.

THAT BEING SAID...

Where I'm at now we SOMETIMES let oracle generate the HTML and return that.

This is due to the fact that SSJS sucks, IS SLOW REGARDLESS, and has too many problems to enumerate. ( Yeah, we have SSJS apps, not my fault ! )

PHP blows SSJS out of the water even when running as CGI instead of as the even more cool mod_php.

Additionally, pay CLOSE attention to this little tidbit.

THERE'S A HUGE DIFFERENCE BETWEEN THE CONCEPT AND IMPLEMENTATION OF DATA WHEREHOUSING AND DATA MARTS.

In one case, the idea of NORMALIZED data is cool, like for maintenance of the data itself.

In another case, like for serving data to an application the SCHEMA can require numerous wierness, like joins and subselects, and your performance can die because the SCHEMA wasn't written to the application's requirements, but rather to a DBA's idea of what a database should be.

DENORMALIZATION is OFTEN a good thing for web applications. - that is, make a schema that suits your performance purpose, even if people in a university "would laugh at it".

$0.02

I can't imagine where PHP itself would be a bottleneck unless you don't know how to code. Honest.

...Or C, or Perl, or anything for that matter.

And as I've mentioned there's even ways to make SSJS work...

So the moral of the story is LOOK AT THE BIG PICTURE and you will be safe... er.

THX -AEF

On Sun, 07 May 2000, Mark Nold wrote: > Arthur, > > We are using PHP3 with large web applications, but on Intranets not > 1000000 hits per second web sites ;) But we plan on migrating to PHP4 once > we've undergone full testing, but prelim testing shows huge performance > gains of up to 80% on the PHP processing (doesnt improve the DB response of > course). That is PHP3 as an Apache Module compared to an unoptimised PHP4 > CGI. >

<snip>

> > > > Thanks for the tips about making an abstraction layer. > > > > Are you using Oracle with PHP3 or 4? Many providers and IT people still > > don't want to use 4 because the "full version" isn't out. I'm not that > > concerned about the beta or RC status of PHP4 as it's likely to be out in > > full release soon enough. I'd like to know if anyone has used an > optimized > > PHP4 (Apache module with Zend optimizer?) on big boxes with massive DBs > > getting massive hits. How does PHP4 + any DB perform compared with > > combinations like Oracle + App Server? > > > > Regards, > > > > Arthur

attached mail follows:


Yeah, but an admin interface is only for wimps anyway :)

Seriously though pgAdmin is a port from phpMyAdmin for mySQL and is far from finished, I don't think it's their setup thats broken. They have a cvs server up if you'd like to help them out though :)

Adam Robertson ============== Web Application Developer http://www.elitemedia.co.uk

>-----Original Message----- >From: mocha_php [mailto:mocha_phpyahoo.com] >Sent: 06 May 2000 18:24 >To: A Robertson; porterda; php3lists.php.net >Subject: f2s.com WAS RE: [PHP3] PHP Value Hosting > > >i tried f2s.com and things work fine. only problem is their setup of the >sql admin web interface (PostgresAdmin) isn't set up properly. out >of the 5

attached mail follows:


Hi, Dear Mrs. or Mr. I have some problems on php3 installation. I am using IE and PWS on windows 98, I followed all the steps, but when I ran a simple php script, nothing showed up on the web page, I looked at the source, it's exactly the same as the source code, the php module wasn't gotten invoked for some reason. Please help me out. I appreciate. My script phptest.php3: ( I also tried .php) <html> <?php echo ("Page generated by php."); ?> </html> Best regards!

Jin, Jue

attached mail follows:


Hello, Recently I had posted an article about phpstocks.. a program that fetches stock quotes from yahoo.. I had made the source and everything available online, and a few of you had responded with comments/suggestions/questions...anyway.. to make a long story short..

my computer/server crashed.. it was a very ugly crash.. I lost everything.. including the 60+ hours of work I had put into phpstocks.. if anyone had downloaded the source to this program.. any version of it.. could you please email me the tar.gz file .. I will be eternally greatful to you.. for best results/safety.. if you can email it to me here and cc it to vlutherlinux.com and vlutherlinuxpowered.com I would really appreciate it.

PS: Note to Yahav: As you can tell.. I've been side tracked with this fiasco now.. hopefully we can work something out once I get everything back online on my end. :)

On Sat, 6 May 2000, Mark Selby wrote:

> Hi all, > > Anyone have libphp3.so module for MIPS (Cobalt Cube) > platform, or perhaps add wisdom to rebuilding the rpm > or src on Intel (obviously with MIPS target for the > build) without screwing up the current install? > > Any help appreciated, > > Mark. > > > __________________________________________________ > Do You Yahoo!? > Send instant messages & get email alerts with Yahoo! Messenger. > http://im.yahoo.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 > >

attached mail follows:


Looking to design a site simular to http://profiles.yahoo.com where users can create/login to an account and put in specific information and have a page be dynamically created. Very useful for clubs/IRC/friends/family.

I was wondering if there is any prewritten PHP code for this sort of project. I lack PHP experience to do it on my own, but it is not a priority in my book enough to warrant hiring someone to code it.

Matthew You may emial me in private. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

attached mail follows:


Tonu Samuel wrote: > > Ann Cantelow wrote: > > > /* > > * Mysql > > */ > > After a long search we found out that mysql was > > running as user root and was reachable locally. Because apache.org was > > running bugzilla which requires a mysql account and has it > > username/password plaintext in the bugzilla source it was easy to > > get a username/passwd for the mysql database. > > Thank you for interesting post! > > We are in MySQL accepting every security problem as own even if we are > not directly guilty in it. Like this case: these were configration which > ones gave you root account. In such case we are always discussing, what > we can do better in next release of MySQL, how we can avoid user from > making these typical mistakes. At moment we prorably will disable > running MySQL daemon as root until user don't specify some type of flag > "--yes-I-really-want-to-run-it-as-root" or similar. > > Also we are working on anoher topics where users making common mistakes > or need additional security. Reason in delaying of SSL connections patch > is also just verifying everything carefully and making this all really > secure.

Note that allowing ssh root logins from any host with no password will make your system very insecure. This does in no way imply that SSH is not secure, just that you do not know what you are doing if you choose to configure it this way :-)

The point is, MySQL installation can only be as secure as the sysadmin/dba running the system will configure it.

-- 
Sasha Pachev

+------------------------------------------------------------------+ | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sashamysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +------------------------------------------------------------------+

attached mail follows:


Hi,

I would like to know which virus detector would work with during file uploading for php??

Thank You

Mark Lo

attached mail follows:


I am required to PARSE uploaded HTML FORMS.

I need to EXTRACT <FORM <INPUT etc., relating to forms.

I've just tried using the XML parser, and OF COURSE, it complains about "well-formedness" of things like '<br>' having no </br>.

Since the parser appears to be completing the task I need it for, is it possible to DISABLE the ERROR(s) that the XML parser throws so that I can easily get all the form elements using it ?

It is so close to being useful that I thought I should ask for some guru advice before resulting to alternative means to my ends...

If this is unclear:

I want to upload a form, Content-Type: text/html to my web server.

I want to PARSE IT.

I want output that looks like:

FOUND: <FORM METHOD="POST"

FOUND: <INPUT TYPE="TEXT" NAME="USERNAME" VALUE="HMN..."

I currently get this output ;)

But I am getting "XML error: mismatched tag at line 11"

I KNOW WHY, but I don't care. I want the error to be ignored.

??? THX -AEF

-- 
"If you think the Universe is big, you should see the source code..."
-Frank & Ernest

attached mail follows:


Check out our course at http://useractive.com it is online...but is very hands on and instructor factilitated. You will learn more and better than in a classroom.

AND you can get University of Illinois certification.

Scott Mills Gray scottycm.math.uiuc.edu

attached mail follows:


> Hey,

I have a question that I am hoping will really get to the bread and butter. <statement> I bought the perl dbi book today.. guy at the cash register says "Hey, I heard Perl is dying".-->I was just working with it today!..now, at my work, they praise java blah blah blah....besides the biasedness...whats really going on?? </statement> ANYWAYS,,, IS PERL HEADING FOR A DOWNFALL, OR WILL IT RISE TO THE OCCASION/KEEP PROGRESSING (in this instance, I am thinking more of a web solution etc...)????

So, besides the usual,,,"yeah, its worth it to learn as much as possible" etc.."do what you want" etc....

Is Perl gonna be a program language of the future (and past), or is its days numbered??

Apply off list if you want.

thanks, dean

attached mail follows:


Hi all,

I'm using PHP (3.0.12) and MySQL (3.22.30) to build a db for my books. The search statement isn't working as intended. What I'm after is to be able to enter one or more criteria into the form and have any data in other columns be ignored. It will now return the correct row only if I include the info from ALL columns having data. As I lifted--sorry, adapted--this from the Professional PHP Programming (from the address book example) and theirs works, I must be missing something here. Add/modify/delete all work OK. I get no error messages; the row just isn't returned (I have only a few sample entries, so I know what should be returned. In the interest of brevity I've given only the table layout and the search statement. Some direction, anyone?

TIA,

curt

The table:

mysql> CREATE TABLE books( bookid SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, title CHAR(30), publisher CHAR(30), category ENUM(' ', 'literature', 'history', 'hist_fiction','science', 'humor', 'fiction', 'nonfiction', 'reference'), isbn INT UNSIGNED NOT NULL, yearpub YEAR, binding ENUM(' ', 'paperback', 'tradepaper', 'hardcover'), yearpurch YEAR, pricepaid SMALLINT UNSIGNED NOT NULL, first_ed ENUM(' ', 'y', 'n', 'p'), signed ENUM(' ', 'n', 'y'), bookcondition ENUM(' ', 'near_fine', 'fine', 'as_new', 'very_good', 'good', 'fair'), dj_condition ENUM(' ','near_fine', 'fine', 'as_new', 'very_good', 'good', 'fair', 'none'), comments CHAR(30));

The search statement:

$searchstmt = "SELECT * FROM $tablename WHERE " ;

if ($bookid) $searchstmt .= "bookid like '%$bookid%' and " ; if ($title) $searchstmt .= "title like '%$title%' and " ; if ($publisher) $searchstmt .= "publisher like '%$publisher%' and " ; if ($yearpub) $searchstmt .= "yearpub like '%$yearpub%' and " ; if ($isbn) $searchstmt .= "isbn like '%$isbn%' and " ; if ($yearpurch) $searchstmt .= "yearpurch like '%$yearpurch%' and " ; if ($pricepaid) $searchstmt .= "pricepaid like '%$pricepaid%' and " ; if ($comments) $searchstmt .= "comments like '%$comments%' and " ; if ($category) $searchstmt .= "category like '%$category%' and " ; if ($binding) $searchstmt .= "binding like '%$binding%' and " ; if (first_ed) $searchstmt .= "first_ed like '%$first_ed%' and " ; if ($signed) $searchstmt .= "signed like '%$signed%' and " ; if ($bookcondition) $searchstmt .= "bookcondition like '%$bookcondition%' and " ; if ($dj_condition) $searchstmt .= "dj_condition like '%$dj_condition%' and " ;

$stmt= substr($searchstmt, 0, strlen($searchstmt)-4) ;

attached mail follows:


Dude,

This looks like an easy one.

The trailing "and" statements appear to be your problem.

This is shoddy code for generic puposes.

Your select statement should be something like this when all is said and done:

select * from sometable where customerid like 'something'

The problem appears to be that the code you showed will ALWAYS result in something that is INVALID SQL like this:

select * from sometable where customerid like 'something' and

And what ?

Loose the and.

If you want all these neato possibilities to work you'll have to write something a little more elaborate.

TRY SOMETHING LIKE THIS INSTEAD, - this isn't the greatest logic but it gets the point accross...

$searchstmt = "SELECT * FROM $tablename WHERE " ; $gotone = 0;

if ($bookid) { $searchstmt .= "bookid like '%$bookid%' " ; $gotone = 1; } if ($title) { if ($gotone == 1) { $searchstmt .= " and "; } $searchstmt .= "title like '%$title%' and " ; $gotone = 1; }

if ($publisher) { if ($gotone == 1) { $searchstmt .= " and "; } $searchstmt .= "publisher like '%$publisher%'" ; $gotone = 1; }

Get it ? No TRAILING AND this way...

Hope this is actually your problem, if not it soon will be ;)

THX -AEF

On Sat, 06 May 2000, you wrote: > Hi all, > > > I'm using PHP (3.0.12) and MySQL (3.22.30) to build a db for my books. > The search statement isn't working as intended.

> $searchstmt = "SELECT * FROM $tablename WHERE " ; > > if ($bookid) > $searchstmt .= "bookid like '%$bookid%' and " ; > if ($title) > $searchstmt .= "title like '%$title%' and " ; > if ($publisher) > $searchstmt .= "publisher like '%$publisher%' and " ; > if ($yearpub) > $searchstmt .= "yearpub like '%$yearpub%' and " ; > if ($isbn) > $searchstmt .= "isbn like '%$isbn%' and " ; > if ($yearpurch) > $searchstmt .= "yearpurch like '%$yearpurch%' and " ; > if ($pricepaid) > $searchstmt .= "pricepaid like '%$pricepaid%' and " ; > if ($comments) > $searchstmt .= "comments like '%$comments%' and " ; > if ($category) > $searchstmt .= "category like '%$category%' and " ; > if ($binding) > $searchstmt .= "binding like '%$binding%' and " ; > if (first_ed) > $searchstmt .= "first_ed like '%$first_ed%' and " ; > if ($signed) > $searchstmt .= "signed like '%$signed%' and " ; > if ($bookcondition) > $searchstmt .= "bookcondition like '%$bookcondition%' and " ; > if ($dj_condition) > $searchstmt .= "dj_condition like '%$dj_condition%' and " ; > > $stmt= substr($searchstmt, 0, strlen($searchstmt)-4) ; > > > -- > 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

-- 
"If you think the Universe is big, you should see the source code..."
-Frank & Ernest