|
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-help
lists.php.netDate: Sat May 06 2000 - 23:55:02 CDT
- Next message: php3-digest-help
lists.php.net: "php3 Digest 7 May 2000 16:54:57 -0000 Issue 1656"
- Previous message: php3-digest-help
lists.php.net: "php3 Digest 6 May 2000 16:55:03 -0000 Issue 1654"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <data
wap4.com>
php editing tool of choice?
89332 by: "Patrick Rea" <prea
csolve.net>
89333 by: Rob Hardowa <hardowa
sk.sympatico.ca>
89334 by: "Mark Maggelet" <maggelet
mminternet.com>
Date operation
89335 by: Massimiliano Belletti <mbelletti
galactica.it>
problems with second time validation
89336 by: "hakan gezgin" <webamigo
hotmail.com>
89338 by: Alfred Perlstein <bright
wintelcom.net>
Rasmus hailed as the coolest coporate suit in the known universe.
89337 by: "Phil Driscoll" <phil
dialsolutions.co.uk>
89349 by: Paul DuBois <paul
snake.net>
php 3.0.16 and htdig 3.1.5
89339 by: Joseph Cheek <joseph
cheek.com>
89340 by: "Manuel Lemos" <mlemos
acm.org>
89352 by: Rasmus Lerdorf <rasmus
php.net>
MIPS libphp3.so file needed
89341 by: Mark Selby <selby_mark
yahoo.com>
New Win32 PHP editor in the works.
89342 by: "Tony Kirk" <tkirk
cablespeed.com>
oracle and PHP
89343 by: Ron Chmara <ron
Opus1.COM>
89356 by: Mark Nold <markn
alverstone.com.au>
89358 by: Allen Francom <aef
prismnet.com>
f2s.com WAS RE: [PHP3] PHP Value Hosting
89344 by: "A Robertson" <elite2000
btinternet.com>
Installation
89345 by: Jue Jin <jinjue
coe.neu.edu>
A very odd request
89346 by: Vidyut Luther <vluther
gotslack.com>
Profile Page
89347 by: "Matt Fox" <coa_project
hotmail.com>
How we defaced www.apache.org (fwd from BugTraq)
89348 by: sasha
mysql.com
Virus detector for upload files!!!
89350 by: Mark Lo <markloky
netvigator.com>
XML Parser question - sooooo close to working for a needed HTML problem...
89351 by: Allen Francom <aef
prismnet.com>
PHP training
89353 by: Scott Gray <scotty
cm.math.uiuc.edu>
PERL QUESTION:alive or dead?
89354 by: Dean James <sacramone
mediaone.net>
search not working
89355 by: curt <curtpdx
inetarena.com>
89357 by: Allen Francom <aef
prismnet.com>
Administrivia:
To subscribe to the digest, e-mail:
php3-digest-subscribe
lists.php.net
To unsubscribe from the digest, e-mail:
php3-digest-unsubscribe
lists.php.net
To post to the list, e-mail:
php3
lists.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 wmphp
getlost.com.au wrote:
>On 5 May 2000 chris
wild.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 <webamigo
hotmail.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 - [bright
wintelcom.net|alfred
freebsd.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 joseph
cheek.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=mlemos
acm.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
> jcheek
linuxcare.com, http://www.linuxcare.com/
> Linuxcare. Sport for the Revolution. 8-)
>
> finger joseph
cheek.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
markn
alverstone.com.au
Systems Consultant
Change is inevitable, except from vending machines.
On Saturday, 6 May 2000 5:20, Arthur [SMTP:x
apx.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_php
yahoo.com]
>Sent: 06 May 2000 18:24
>To: A Robertson; porterda; php3
lists.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 vluther
linux.com and vluther
linuxpowered.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-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:
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:sasha
mysql.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
scotty
cm.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-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
-- "If you think the Universe is big, you should see the source code..." -Frank & Ernest
- Next message: php3-digest-help
lists.php.net: "php3 Digest 7 May 2000 16:54:57 -0000 Issue 1656"
- Previous message: php3-digest-help
lists.php.net: "php3 Digest 6 May 2000 16:55:03 -0000 Issue 1654"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]