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

Subject: php3 Digest 16 Feb 2000 06:00:02 -0000 Issue 1481
From: php3-digest-helplists.php.net
Date: Wed Feb 16 2000 - 00:00:02 CST

Next message: php3-digest-helplists.php.net: "php3 Digest 16 Feb 2000 18:00:07 -0000 Issue 1482"
Previous message: php3-digest-helplists.php.net: "php3 Digest 15 Feb 2000 18:00:01 -0000 Issue 1480"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php3 Digest 16 Feb 2000 06:00:02 -0000 Issue 1481

Topics (messages 76221 through 76315):

load data infile
        76221 by: Lawrence Blades <lrbladesclarksdale.com>
        76310 by: Lawrence Blades <lrbladesclarksdale.com>
        76313 by: Thomas Deliduka <thomasneweve.com>

html between it?
        76222 by: "Ramiro Radjman" <radji600chello.nl>
        76223 by: elliot d schlegelmilch <elliotrightnowtech.com>
        76232 by: "Tim Zickus" <infozchesco.com>
        76234 by: garybfxt.com

executing a program
76224 by: "victor" <archiverdb.geocrawler.com>
76233 by: "Lester A. Mesa" <netadminprimex.prontel.net>

inserting text into a template
76225 by: "victor" <archiverdb.geocrawler.com>

Database Server Recommendation
        76226 by: "Jonathan Younger" <archiverdb.geocrawler.com>
        76229 by: Damien Mc Kenna <mckennawso.net>
        76255 by: "Peter Kocks" <peter.kocksbaygate.com>
        76261 by: <php3commandprompt.com>
        76284 by: "Chris Fankhauser" <chrisfswdata.com>

PHP3 and PDF and TIFF Success
76227 by: "Michael Miller" <archiverdb.geocrawler.com>

Array Problem
76228 by: "Lennart Pedersen" <archiverdb.geocrawler.com>
76263 by: "Maria Savela (BCS)" <Maria.Savelaedt.ericsson.se>

Fwd: [PHP3] Displaying last 20, next 20...
76230 by: TQ White II <tqjustkidding.com>

Fwd: [PHP3] AUTO_INCREMENT
76231 by: TQ White II <tqjustkidding.com>

hello
76235 by: "hemant bhanushali" <spyhemanhotmail.com>

MySQL Lock Tables is it needed
76236 by: "Donny Simonton" <archiverdb.geocrawler.com>

handling php and mod_perl
76237 by: "Alex Burmester" <archiverdb.geocrawler.com>

When to upgrade to a newer server?
        76238 by: Christopher Ditty <CDittyemail.usps.gov>
        76246 by: Damien Mc Kenna <mckennawso.net>
        76248 by: "Mark Maggelet" <maggeletmminternet.com>

passing multiple values using URLencode?
76239 by: "Steven T Sigourney" <stevetophat.com>

ASP+ New Microsoft web tools announced
76240 by: Eric Dahnke <edahnkespark.com.ar>

.htaccess: AddType not allowed here
76241 by: Boaz Yahav <berbernetvision.net.il>
76242 by: Boaz Yahav <berbernetvision.net.il>

mail() for Winnt4
76243 by: Ryan Gilfether <gilfetherrpxi.com>

Kind of a gateway
76244 by: Richard Lynch <rlynchignitionstate.com>

Kind of like frames...but not?
76245 by: Richard Lynch <rlynchignitionstate.com>

Apache/Php and Oracle8i Client on Linux
76247 by: ludovic roussin <ludoelma.fr>
76260 by: "Maria Savela (BCS)" <Maria.Savelaedt.ericsson.se>

PHP & Interbase
76249 by: Antares Informatica <jilaniktin.it>

mSQL and php
76250 by: Lindsay Adams <lindsaydingos.net>

PHP calculatons and formula
76251 by: John Parker <jparkersnorkelusa.com>
76253 by: elliot d schlegelmilch <elliotrightnowtech.com>

PHP Editor
76252 by: "Michael L Smith" <Michael.L.Smithalltel.com>

Populate a form menu based on previous form menu selection?
        76254 by: David bradshaw <agentdjdyahoo.com>
        76274 by: "Andrew Sheh" <andrewdmetechnologies.com>
        76304 by: "Fates" <fateswarninghome.com>

PHP on NT, MySQL on Linux
76256 by: Thomas Deliduka <thomasneweve.com>
76293 by: John Burge <JBurgegoinvest.com>

Multi-Dimen and checkboxes
76257 by: Richard Lynch <rlynchignitionstate.com>

data into one email?
76258 by: "Ramiro Radjman" <radji600chello.nl>
76270 by: Gregor Welters <gregorwelters.de>

[PHP4BETA] PHP Template Engine Request For Participation
76259 by: "Simon Roberts" <simonairdmhor.gen.nz>

Books
76262 by: "Manuel Lemos" <mlemosacm.org>
76266 by: eschmid <eschmid+sics.netic.de>

regex
76264 by: "NickM" <teradohotmail.com>

How can I use text files to store and retrieve information ?
76265 by: "Ted Knudson" <tedkcyberlink.com>

AUTO_INCREMENT
76267 by: Tom <tomhenrydirect-connection.com>

Contract Developer?
76268 by: Boaz Yahav <berbernetvision.net.il>

PHP and MS SQL
76269 by: "Maurice Barnes" <mauricedigtechinc.com>

Type question
76271 by: Martin Tiscornia <mtiscorniamuseoabasto.org.ar>

gd / png / php3.
76272 by: tc lewis <timhostme.com>

Checking getenv("HTTP_USER_AGENT")
76273 by: Brian Smith <smittybgpwm.com>
76303 by: "Matthew Clark" <mattgenicomsystems.co.uk>

Corba
76275 by: "Shaun Thomas" <shaun_thomasinlet.com>
76276 by: garybfxt.com

Getting random results from database
76277 by: christophermoewes.com
76280 by: "Bryan Fritchie" <bryanlatent.com>

Multiple Files
76278 by: Richard Lynch <rlynchignitionstate.com>

MySQL Files - In Use
76279 by: Richard Lynch <rlynchignitionstate.com>

Installing PHP3
76281 by: "Gregory P. Sherwood" <Greg.Sherwoodtalarian.com>

MD5 and DES
76282 by: "Brian Budnick" <dreamboyaros.net>

Problem with mysql join select
76283 by: "Chris Kovalcik" <technobcadventure.com>

Images attached to email with php
76285 by: "Absm" <abbstelinco.co.uk>
76286 by: "Absm" <abbstelinco.co.uk>

Formating a money value when printing...
76287 by: "Lic. Rodolfo Gonzalez Gonzalez" <rodolfoequinoxe.g-networks.net>
76295 by: Francisco Hernandez <xy0xy0earthlink.net>

freeware dinamic tree menu with php+javascript
76288 by: "Steve Veltcamp" <bizshopbizshop.com>

Validating a link
76289 by: "Scott Genevish" <SCOTTGEkinkos.com>

Running Java Applets with libphp3
76290 by: Ramzi Abdallah <rsaacl.edu.au>

how use remote sybase
76291 by: "Larry" <shdcms13.url.com.tw>

Question: how to get information from URL into PHP3
76292 by: "The Hun" <thehunnospamthehun.net>

Nested classes
76294 by: "The Hun" <thehunnospamthehun.net>

Going NUTS OVER TRUE TYPE FONTS.
76296 by: David Pollack <davidda3.net>

Query problem...
        76297 by: "Gustavo Marsico" <gustavo.marsicoktld.net.ar>
        76299 by: "Gustavo Marsico" <gustavo.marsicoktld.net.ar>
        76300 by: Cynic <cynicmail.cz>
        76301 by: "Gustavo Marsico" <gustavo.marsicoktld.net.ar>

Fw: [PHP3] Query problem...
76298 by: "Gustavo Marsico" <gustavo.marsicoktld.net.ar>

Header() -> Word,Excel
76302 by: "Mark Nold" <MarkNawi.com.au>

DATE vs TIMESTAMP and UNIX_TIMESTAMP() formatting with PHP's date()
76305 by: "Daevid Vincent" <DayWalkerTheMatrix.com>

currency format
76306 by: "Cicy Chen" <cicypeerwork.com>
76311 by: "Rossi Designs" <webmasterrossidesigns.net>

"while" statement
76307 by: "Zack Beatty" <archiverdb.geocrawler.com>
76314 by: "Noah Couture" <noahcoutureconsulting.com>

Mem_limit not working in .ini
76308 by: "laetus" <archiverdb.geocrawler.com>

Running PHP3 On HTTPD And SHTTPD
76309 by: "rds" <rdsneo.rr.com>

Freaky Friday
76312 by: "Dave VanHorn" <dvanhorncedar.net>

php for dummies
76315 by: AGC <acadaccefyn.org.co>

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 a customer to be able to upload a flat text table via a web form.

I do this with the <input type=file> on a form and the copy() function.
Then I use a php script to load the data into the MySql table:
mysql_query ("load data local infile '/file_directory/$myfile_name' into
table samename")

PROBLEM:
The upload works, and the load data script runs, but only one line of
the file is read into the table.

If I manually ftp the file up to the web server, then load data, all the
lines are read into the table.

The only difference I see is the ownership of the UPLOADED file.
Uploaded via web form, the owner is NOBODY; if I upload it, ftp, the
owner is in my name.

I use PAIR networks, not my own servers.

Any solution?

-- Lawrence Blades Digital Technologies P.O. Box 673 Clarksdale, MS 38614

Church Office: 601.624.6586 COL Office: 601.627.5554 FAX: 601.627.6797 Home: 601-627-9539 Cell: 601.621.3092 http://www.clarksdale.com lrbladesclarksdale.com (If you can't find me, I can't be found.)

attached mail follows:

I pulled the file uploaded via the browser form up in vi editor. There is a foreign character at the beginning of each new line - ^M

Only the first line imports into the db with the load data infile command. I assume the ^M is ending it.

So why is the browser upload inserting the ^M (instead of newline?), and how can I prevent it with the browser upload?

Thomas Deliduka wrote:

> The only thing I can think of is line-feeds. Perhaps a translation between > the different types of line feeds when done via an http upload and an FTP > upload. > > The one line that's imported, is it the first one or the last one? > Thomas Deliduka > IT Manager > --------------------

-- Lawrence Blades Digital Technologies P.O. Box 673 Clarksdale, MS 38614

Church Office: 601.624.6586 COL Office: 601.627.5554 FAX: 601.627.6797 Home: 601-627-9539 Cell: 601.621.3092 http://www.clarksdale.com lrbladesclarksdale.com (If you can't find me, I can't be found.)

attached mail follows:

On 2/15/00 10:22 PM Lawrence Blades said:

> So why is the browser upload inserting the ^M (instead of newline?), and how > can I prevent it with the browser upload?

I'm not sure. But.

It's possible that you can run a quick routine to read the file and find that character, I'm guessing it's a chr(10) and strip it out and leave the unix new line.

I run into this problem with translation issues from pc to linux and mac.

I can't quite remember which characters are for which platform and someone can correct me if I'm wrong here but Linux uses chr(13) for linefeeds (CR), PC uses chr(10)chr(13) (CRLF), and Mac uses just chr(10) (LF).

So, when you butt up against each other they don't work all the time.

the ^M character is a new line, remember old Modem Strings which had to end in ^M? the problem is the server isn't recognizing it so it's just putting in that character.

I have looked through every php site I know and searched through the newsgroups and mailing lists. I have found nothing having to do with this problem. The ONLY thing I can think of is perhaps bringing in the file and looping through it chopping each line (chop()) which may get rid of that character.

I'm sorry to give you no actual information.

Thomas Deliduka IT Manager -------------------- New Eve Media 5629 Westlake Drive Galloway, OH 43119-8498 Phone: 614-870-3098 Fax: 614-870-7486 Mobile: 614-537-6445

attached mail follows:

hello there,

echo "Bedankt voor de interesse in RR Webdesign.<br>Uw gegevens zijn juist verstuurd!<br> Tot ziens.";

I want the parse in some Html but this code is in a if then else.

If i put in echo "?><font size=3>Bedankt voor de interesse in RR Webdesign.<br>Uw gegevens zijn juist verstuurd!<br> Tot ziens.</font><?";

it does not work then the rule always appears.

attached mail follows:

that looks like a really, really bad idea.

>If i put in > echo "?><font size=3>Bedankt voor de interesse in RR Webdesign.<br>Uw >gegevens zijn juist verstuurd!<br> Tot ziens.</font><?";

attached mail follows:

If I think I understand your question, it's possible to "escape out" to HTML again from within an if-then-else:

<?php if ($foo == 4) : ?> <p>Foo is four. <?php else : ?> <p>Foo is not four. <?php endif; ?>

- Tim

----- Original Message ----- From: Ramiro Radjman <radji600chello.nl> To: <php3lists.php.net> Sent: Tuesday, February 15, 2000 1:09 PM Subject: [PHP3] html between it?

> hello there, > > echo "Bedankt voor de interesse in RR Webdesign.<br>Uw gegevens zijn juist > verstuurd!<br> Tot ziens."; > > I want the parse in some Html but this code is in a if then else. > > If i put in > echo "?><font size=3>Bedankt voor de interesse in RR Webdesign.<br>Uw > gegevens zijn juist verstuurd!<br> Tot ziens.</font><?"; > > it does not work then the rule always appears. > > > > > -- > 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:

Ramiro said, > > echo "Bedankt voor de interesse in RR Webdesign.<br>Uw gegevens zijn juist > verstuurd!<br> Tot ziens."; > > I want the parse in some Html but this code is in a if then else. > > If i put in > echo "?><font size=3>Bedankt voor de interesse in RR Webdesign.<br>Uw > gegevens zijn juist verstuurd!<br> Tot ziens.</font><?"; > > it does not work then the rule always appears.

You are confusing the use of echo and the switch between PHP and HTML.

If I understand your question, then this does what you want:

<? if ($something_is_true) { echo "Bedankt ... ziens."; } else { echo "Something else."; } ?>

So does this:

<? if ($something_is_true) { ?>Bedankt ... ziens."<? } else { ?>Something else.<? } ?>

And this: <? if ($something_is_true) {?> Bedankt ... ziens <? } else { ?> Something else <? } ?>

There's another syntax using <? if(): ?> and <? endif ?>, but I never get that right so I won't show it.

attached mail follows:

This message was sent from Geocrawler.com by "victor" <victornanookusa.net> Be sure to reply to that address.

Hi! how do I execute a program from within a php script. On the command line , I type in " itrans -v -i filename.itx -o file.html" which asks the program itrans to convert a .itx file into a .html file.

Now, if I want the same thing to occur from inside a php script, what do i need to do.

thanks victor

Geocrawler.com - The Knowledge Archive

attached mail follows:

I believe this will do the job..

exec("/path/to/itrans -v -i filename.itx -o file.html") or die(" itrans did not worked ");

Lester A. Mesa System Operator lmesaprontel.com Prontel Corporation Internet Division http://www.prontel.com Free: 1-800-920-0290 Ext 206 Tel: (305) 406-9055 Ext 206 Fax: (305) 406-9056

" Prontel Complete Internet Solutions "

-----Original Message----- From: victor [mailto:archiverdb.geocrawler.com] Sent: Tuesday, February 15, 2000 12:26 PM To: php3lists.php.net Subject: [PHP3] executing a program

This message was sent from Geocrawler.com by "victor" <victornanookusa.net> Be sure to reply to that address.

Now, if I want the same thing to occur from inside a php script, what do i need to do.

thanks victor

Geocrawler.com - The Knowledge Archive

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

This message was sent from Geocrawler.com by "victor" <victornanookusa.net> Be sure to reply to that address.

hi, if I have a template file of say a format called .itx which is nothing but a text file in a certain format and I need to insert the data that a user has typed into the textarea box of a form. How do I go about it?

Geocrawler.com - The Knowledge Archive

attached mail follows:

This message was sent from Geocrawler.com by "Jonathan Younger" <jyoungerbemail.org> Be sure to reply to that address.

I'm looking for recommendations on which database servers work _WELL_ with PHP3. Cost not being an issue and can run on Linux or Windows NT. Does MySQL work as well on Windows as it does on *nix?

Not looking for religious wars just looking for comments on solutions people are running and have not had _ANY_ problems with.

Thanks, Jonathan

Geocrawler.com - The Knowledge Archive

attached mail follows:

At 01:26 PM 2/15/00, you wrote: > I'm looking for recommendations on which database servers work _WELL_ > with PHP3.

MySQL v3.22.32, released a few days ago, works great on UNIX and Windows. Just download it, forget anything else unless you're aiming for Oracle (you want to take over the world) territory, in which case go for Oracle. Seriously though, MySQL runs great, it's multi-platform, scales well for the most part, and is pretty darn secure with the latest fixes. As I said, just go download it.

attached mail follows:

This is a bit of an odd question. ALL databases have configuration issues when you get to a reasonably large size database (i.e. one that stores more data than can fit onto one disk). So, when you request to not have _ANY_ problems that's not realistic for a big database (regardless of vendor). If you just have a small database, then all of the databases you can think of have at least a reasonable solution. php supports most databases so almost anyone of them will do fine. Some however are easier to get running out of the box than others. My impression is that MySQL is the easiest to get running out of the box on a linux server simply because so many people on this list use that solution. They'll be lots of support and I believe MySQL has easy to install RPM packages for linux.

However, if your database is going to grow, then MySQL may not be the best solution. While I'm not trying to knock MySQL, I don't know of many instance of MySQL being used on terabyte size databases with multiple thousands of simultaneous connections. I do know that the commercial vendors (Informix, Sybase, Oracle) do have huge installs and ... yes ... installation and maintenance is non-trivial.

Some warnings about Linux. The file system does not yet (as far as I know) support raw partitions, this will impede performance of any database on Linux. Raw partition support is in the works, but I don't think it is there yet. Also, Linux uses an optimistic file caching mechanism that makes general usage appear very fast; however, in a database situation it may not be right choice. Solaris is my favorite when it comes to running database software.

--pk

> -----Original Message----- > From: Jonathan Younger [mailto:archiverdb.geocrawler.com] > Sent: Tuesday, February 15, 2000 10:27 AM > To: php3lists.php.net > Subject: [PHP3] Database Server Recommendation > > > This message was sent from Geocrawler.com by "Jonathan Younger" > <jyoungerbemail.org> > Be sure to reply to that address. > > I'm looking for recommendations on which database servers work > _WELL_ with PHP3. Cost not > being an issue and can run on Linux or Windows NT. Does MySQL > work as well on Windows > as it does on *nix? > > Not looking for religious wars just looking for comments on > solutions people are running and > have not had _ANY_ problems with. > > Thanks, > Jonathan > > Geocrawler.com - The Knowledge Archive > > -- > 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:

Postgres

On Tue, 15 Feb 2000, Jonathan Younger wrote:

> This message was sent from Geocrawler.com by "Jonathan Younger" <jyoungerbemail.org> > Be sure to reply to that address. > > I'm looking for recommendations on which database servers work _WELL_ with PHP3. Cost not > being an issue and can run on Linux or Windows NT. Does MySQL work as well on Windows > as it does on *nix? > > Not looking for religious wars just looking for comments on solutions people are running and > have not had _ANY_ problems with. > > Thanks, > Jonathan > > Geocrawler.com - The Knowledge Archive > > -- > 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 have yet to have a problem with MySQL & PHP on a linux box.

Chris Fankhauser Meridian Digital Media http://www.meridime.com

-----Original Message----- From: php3commandprompt.com [mailto:php3commandprompt.com] Sent: Tuesday, February 15, 2000 2:21 PM To: Jonathan Younger Cc: php3lists.php.net Subject: Re: [PHP3] Database Server Recommendation

Postgres

On Tue, 15 Feb 2000, Jonathan Younger wrote:

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

This message was sent from Geocrawler.com by "Michael Miller" <mcmilleriastate.edu> Be sure to reply to that address.

Several months ago I began the long and difficult process of getting PHP and PDF to work together. I did succeed with version 0.6 but only after some difficulty and frustration....so when the need to load this extension on my test server came up, I was a little concerned but I jumped in and thought...It can't get any worse! It is actually a lot better....I got through most of it on the first try and even got the php_open_tiff function to work. I thought maybe sharing this information would be a good idea so...... Platform: Red Hat Linux V 6.1 and 5.2 (tried it on both) WWW Server Apache 1.3.9 PHP Version 3.0.14 PDF Version 2.01 Tiff Library 3.4 Jpeg Library Version 6b Zlib Library 1.1.3 GD Library 1.3

1. I compiled the Tiff,Jpeg and Zlib libraries first, no problems with those 2. I compiled the PDF Library with ./configure --prefix=/usr --enable-shared=yes --with-pnglib=no 3. Then I made the symbolic link in the /usr/lib directory from libpdf2.01.so >> libpdf.so 4. Next I edited the pdf.c and php3_pdf.h files...all I did here was to find any reference to JPEG then copy it and change that section to TIFF....do it in both files 5. Next I compiled PHP with this configure ./configure --with-apache=/APACHE SRC --with-gd=/usr/gd1.3 --with-mysql --with-pdflib=/usr --with-jpeg-dir=/local/bin --with-tiff-dir=/local/lib --with-zlib-dir=/local/lib An everything compiled OK...no warnings even....You can then compile Apache and get started with the PDF functions.

I just wanted to share my success with those of you trying to make this work..Hope this helped Mike Miller

p.s. Thanks Anders and Uwe for steering me in the right directions...

Geocrawler.com - The Knowledge Archive

attached mail follows:

This message was sent from Geocrawler.com by "Lennart Pedersen" <lennartevolution2000.dk> Be sure to reply to that address.

Hi List

Prop a newbee quest, but... I have a Create Table situation and I get errors if its on multiple lines. Ex

$query = "CREATE TABLE holst_media ( ID int(11) DEFAULT '0' NOT NULL auto_increment, Field1 varchar(255), Field2 int(11), Field3 varchar(255), Field4 double(16,4), etc. etc );

Does anyone have any ideas on how to do this. I have 30 fields and don't want them on one line.

Please respond to this.....

Best regards

Lennart Denmark

Geocrawler.com - The Knowledge Archive

attached mail follows:

> This message was sent from Geocrawler.com by "Lennart > Pedersen" <lennartevolution2000.dk> > Be sure to reply to that address. > > Hi List > > Prop a newbee quest, but... I have a Create Table > situation and I get errors if its on multiple > lines. Ex > > $query = "CREATE TABLE holst_media ( > ID int(11) DEFAULT '0' NOT NULL auto_increment, > Field1 varchar(255), > Field2 int(11), > Field3 varchar(255), > Field4 double(16,4), > etc. etc ); > > Does anyone have any ideas on how to do this. I > have 30 fields and don't want them on one line.

First, I hope you did finish the $query properly by using a " (double quote), even though it doesn't show above.

Second, you could aways try:

$query = "create table holst_media ("; $query .= "id int(11) default '0' not null auto_increment, "; $query .= "field1 varchar(255), "; ... etc, etc $query .= ")";

That is, putting all the pieces together one by one until you have one very long string containing all of the SQL code. I do this a lot and it sure improves readability.

If this doesn't help perhaps you could describe the errors in detail. Messages, PHP code relevant to your problem etc.

/Mia*

attached mail follows:

If you are using mySQL, you can use the Limit keyworkd for the Select command. It allows you to specify a range of records (they call it 'offset' and 'rows'). Then include a 'next 20' link that knows the next row number and you're golden.

tqii

ps, no, I don't have some code this time. maybe next week ;>)

>Subject: [PHP3] Displaying last 20, next 20... > > >Dear PHP, > >I'm writing a little message board and I'm trying to figure out how to get >it so that it >will for instance list the last 20 topics, then they can click on next 20 >then it would >show them the next 20 topics, etc? > >anyone can give me any help on how to do this? > >Brian. >PS: Please respond directly back to me! > > >-- >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 >

============================================

T.Q. White II

Technology and Marketing Planning, Analysis and Implementation

Phone: 708/763-0100---Fax: 708/848-3040

tqjustkidding.com http://www.justkidding.co, http://www.dbToolbox.com

============================================

attached mail follows:

Specify the value of the field the first time you use it. I don't think there's another way (at least I can't see one in the book).

tqii

>Subject: [PHP3] AUTO_INCREMENT > > >How do I set the starting value at the creation time of an AUTO_INCREMENT >row? > > > >-- >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 >

============================================

T.Q. White II

Technology and Marketing Planning, Analysis and Implementation

Phone: 708/763-0100---Fax: 708/848-3040

tqjustkidding.com http://www.justkidding.co, http://www.dbToolbox.com

============================================

attached mail follows:

hello,

i have installed th apache webserver and followed the instructions for installing php and conf of apache under windows95........ but the scripts won't run............ where can i find the manual and what may be the problem.........

expecting a reply........ thanking you.... hemant ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

attached mail follows:

This message was sent from Geocrawler.com by "Donny Simonton" <donnyintercosmos.com> Be sure to reply to that address.

I have been programming in php for a few months, mainly using mysql as the backend. I have never used the Lock Tables option in MySQL in any of my php programs. Now our C programmer is telling me that we need to use it.

Why?

Geocrawler.com - The Knowledge Archive

attached mail follows:

This message was sent from Geocrawler.com by "Alex Burmester" <adbpobox.com> Be sure to reply to that address.

I'm trying to get php and mod_perl / mason to coexist and setting the handler back to the default-handler for a section of the site where php is needed does not seem to work.

<Location /> SetHandler perl-script PerlHandler HTML::Mason </Location>

<Location /horde> SetHandler default-handler </Location>

And yes I do have the php3 AddType line in the conf file.

php works fine if I turn off the <location /> directives.

Any ideas?

Thanks,

Alex.

Geocrawler.com - The Knowledge Archive

attached mail follows:

experience, but I have nothing to reference this by.

Does anyone out there have any hard and steady rules on when it is time to move your site to a new, faster server?

I have been working on my site (http://www.redhotsweeps.com) for 2 years now. Over time, we have seen a steady increase in traffic. As it is right now, we are seeing approx. 4,000 people/day. Over the last few months, I have started seeing more and more errors in my error_log file. 80%-90% of them are people just hitting the stop button or reloading a page before the original finished. But the rest are errors like,

'No more child spawning available.' 'Script terminated due to malformed headers' - The scripts that give this error are functional scripts. This just happens about 2-3 times/week. No known reason.

I have contacted my host about these errors and try and blame my banner script (WebAdverts). Only problem is that I have been using this for over 2 years and never noticed any problems like this before.

Can anyone point me to any relivant material or give me any usefull information?

Thanks in advance.

CDitty

attached mail follows:

At 02:57 PM 2/15/00, you wrote: > Does anyone out there have any hard and steady rules on when it is > time to move your site to a new, faster server?

If your hosting company throws you off their servers, it's a good time to move on. Aside from that, no idea, sorry.

> I have contacted my host about these errors and try and blame my > banner script (WebAdverts). Only problem is that I have been using > this for over 2 years and never noticed any problems like this before.

Questions... 1. What version of PHP are they using? 2. What database and version of that are they using? 3. How involved are your scripts, could they have started messing up the database somehow from people not entering correct info, stopping their web browsers loading pages or going back to previous pages? 4. What web server are they using? 5. Have they updated any server software in the last few months?

attached mail follows:

well, if you're getting errors like that, you should be using Php! or at the very least, mod_perl.

- Mark

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

On 2/15/00 at 1:57 PM Christopher Ditty wrote:

>I know this is an open question and is open to each user's own > experience, but I have nothing to reference this by. > > Does anyone out there have any hard and steady rules on when it is > time to move your site to a new, faster server? > > I have been working on my site (http://www.redhotsweeps.com) for 2 > years now. Over time, we have seen a steady increase in traffic. As > it is right now, we are seeing approx. 4,000 people/day. Over the > last few months, I have started seeing more and more errors in my > error_log file. 80%-90% of them are people just hitting the stop > button or reloading a page before the original finished. But the rest > are errors like, > > 'No more child spawning available.' > 'Script terminated due to malformed headers' - The scripts that give > this error are functional scripts. This just happens about 2-3 > times/week. No known reason. > > I have contacted my host about these errors and try and blame my > banner script (WebAdverts). Only problem is that I have been using > this for over 2 years and never noticed any problems like this before. > > > Can anyone point me to any relivant material or give me any usefull > information? > > Thanks in advance. > > CDitty >-- >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, Is there a way to pass more than one value with URLencode and if yes, how do I then decode it?

Thanks, Steve

attached mail follows:

Anyone see this

http://news.cnet.com/news/0-1003-200-1550029.html?tag=st.ne.1002.bgif.1003-200-1550029

Visual Basic for web development, called ASP+

fodder, nothing else.

attached mail follows:

I started to get this message : ".htaccess: AddType not allowed here"

I'm not sure what's wrong.

One minute the server is ok, and the next I get Internal Server Error and in the error log I get : ".htaccess: AddType not allowed here"

my .htaccess file looks like :

DirectoryIndex index.html AddType application/x-httpd-php php3 inc html order allow,deny allow from all . . .

If I remove the 2nd line it works well but it does not recognize .inc files and .html files as php files

any idea?

thanks

berber

attached mail follows:

Fixed (sorry)

thanks

berber

attached mail follows:

Hey

We are having problems using the mail() function on Winnt 4.0 using php3.0.11 and 4.0beta3. We have made sure that the php.ini file is setup correctly in the [mail function] section specifying the mail server name, then we also tried just it's ip address, we have also made sure to include a valid email address for "sendmail_from= ". The only thing that happens is that php returns an error saying there was a "Server Error", after watching the mail server logs, we can see that php connects to the server, but thats it, it only opens a connection. Any ideas why. Our mail server is Eudora running on a Mac.

Anyone else run into this problem? I have searched this site and wasnt able to find any other info to help.

I know that my php code is correct, the mail() function is pretty trivial, but below is where the mail function is called

if(mail("gilfetherrpxi.com","My Test Subject", "this is the message body. message goes here. this is a message.")) print "<BR><B> Mail Successfully Sent </B><BR>";

Any help would be greatly apprectiated

Ryan Gilfether Programmer Praxis Inc.

attached mail follows:

At 02:25 PM 2/12/00 +0100, you wrote: >On Fri, 11 Feb 2000, Richard Lynch wrote: > >> At 09:53 PM 2/11/00 +0100, you wrote: >> >I don't want to process all the data through a single connection...of >> >cause I need a connection for every file! >> > >> >My point is, that I want to connect to he server, get the data, determine >> >the content-type. If the content-type is image, java, sound etc (nothing >> >but html) it shall just be printed out with the correct Header. >> >If html, it shall process through my code, to change all the HREF's SRC's >> >etc in the HTML-tags and then print it out to the client. >> >If I could do that in one HTTP-request, it would be great? >> > >> >I have used the readfile() function which makes the HTTP-request, and >> >prints out the data, and that is great, cause this works with pictures >> >(but I cant do the HTML-processing) > >No this is not my problem, i know I need the regular expressions. >My problem is to mahe the HTTP-request, determine the content type and the >either print out the data (correct, even if binary) or send it to my >regex-filter. > >> >> So, like, "stealing" another web-site on the fly? >> >> You'll need a regex or 10 to find all the HREFs and SRCs and replace their >> links with links to where you store your files, or to some sort of script >> that will spit out their images through your site... >> >> Okay, if that's the question you are asking, look for ereg_xxx examples >> involving HREF= and SRC= throughout the code archives and mailing list >> archives.

You'll need to do something to get the headers and look for Content-Type.

fsockopen to 80 followed by a HEAD request should do it

-- "TANSTAAFL" http://CHaTMusic.com http://EmphasisEntertainment.com http://L-I-E.com http://JadeMaze.com http://CatCatalani.com http://MGMH.com http://VoodooKings.net http://UncommonGround.com Need Work? Graphic Design: http://L-I-E.com/jobs.htm#GraphicDesign Printer Driver: http://L-I-E.com/jobs.htm#PrinterDriver

attached mail follows:

At 05:58 AM 2/14/00 -0800, you wrote: >pulling in the whole thing via an include (both >miva's version and php's version) and then doing >several things to the code once it's in. The >problem is this: I also want all links on the >page to point back to the page I'm on and do >something like "http://test.whatever.com/page.php? >pagetoinclude" for every link. PHP then reads

main.php3 <?php $pagetoinclude = 'whatever.htm'; include 'navbar.inc'; ?>

navbar.inc <?php $url = $PHP_SELF; $parts = explode('?', $url); $base = $parts[0]; echo "<A HREF=$base?pagetoinclude=$pagetoinclude>Test</A>"; ?>

attached mail follows:

Hi,

As you can see on the subject line we are using : Apache 1.3.9 Php 3.0.14 Oracle 8.1.5.0 Installed in client mode (OCI8) on Linux RedHat 6.1

We are trying to make running PHP with OCI8 and have no result ... We have choose the --with-oci8=/HOME_ORACLE at the PHP compilation, the compiltation is good, but when we try a phpinfo() we do not see Oracle, we only see MySQL, and when we try a PHP script with for example OCILogon instruction, PHP always reply : Fatal error: Call to unsupported or undefined function ocilogon() in /home/www/htdocs/oracle.php3 on line 5

Do you have any idea to solve this problem ... We have no trouble with MySQL ... but nothing to get any result with Oracle ...

Thanks per advance for your answers,

Regards, Ludo

attached mail follows:

> As you can see on the subject line we are using : > Apache 1.3.9 > Php 3.0.14 > Oracle 8.1.5.0 Installed in client mode (OCI8) > on Linux RedHat 6.1 > > We are trying to make running PHP with OCI8 and have no result ... > We have choose the --with-oci8=/HOME_ORACLE at the PHP > compilation, the > compiltation is good, but when we try a phpinfo() we do not > see Oracle, > we only see MySQL, and when we try a PHP script with for example > OCILogon instruction, PHP always reply : > Fatal error: Call to unsupported or undefined function ocilogon() in > /home/www/htdocs/oracle.php3 on line 5 > > Do you have any idea to solve this problem ... > We have no trouble with MySQL ... but nothing to get any result with > Oracle ...

Are you sure you should be using --with-oci8? Try ./configure --help to see which switches are available and I think you will find that you should be using --with-oracle instead.

/Mia*

attached mail follows:

Hi all, I have compiled PHP-3.0.14 with Interbase support, could somebody, please, help me to see a list of "employees":

<? $spy = ibase_connect("Employee DB", "SYSDBA", "masterkey"); $query_id = ibase_prepare("select * from employee");

--- What code do I have to put here? // I have tried many solutions but no one were a real solution!

ibase_free_result($result); $result = ibase_query(); ?>

Thank you

ps. I am looking for every kind of documentation about Interbase e PHP. Does sombedy know where to find something?

jilani

attached mail follows:

>Hi, Lindsay! > > >> my PHP cgi binary works fine. all commands work, except the msql ones. >> phpinfo returns that msql support is in their. php is not complaining >> that it doesn't know about the commands, it is complaining it can not >> get a connection to the webserver. (...) > > >Try what I sugested yesterday: run php on the command line and call >phpinfo(). Things simply shouldn't happen the way you described. > > >[]s, Fernando Lozano

I should have said connection to database server, not webserver.

phpinfo() runs from the command line just fine. in fact it runs from the webserver just fine. (ie. calling a .php file with just phpinfo() in it through a browser)

both methods reveal that msql functions are compiled in. the tricky part is that somehow, the environment that is set up when the php binary is called from apache, is not allowing the msql functions to work.

Yes, php has been compiled with the support for the correct version of msql

if i create a file with msql_connect(); in it, (and that's the only thing in it.)

and pipe it through php from the command line,it works just fine.

If i add #!/usr/local/bin/php as the first line of the file, and chmod 755, and then execute the script from the command line as ./testphp.cgi it works just fine if i call it from a browser window (thus making it get called from apache) it doesn't work

Again, the only parts of my php binary that aren't working, are the msql calls. actually, i think the only problem is that msql_connect does not work. If i could get the connection to work, then the rest of the calls would probably work just fine. Lindsay Adams Dingos.net lindsaydingos.net

attached mail follows:

> Hi! > > First make a form that handles the input and put tha values in vars > like. > > > The inputs are > > 1. weight at left main gear = $lmg > > 2. weight at other main gear = $rmg > > 3. weight at nose or tail wheel = $nmg > > 4. distance between main gear and nose or tail gear. = $dist > > then use this php code: > > $bp = ($lmg * $dist) / ($lmg + $rmg + $lmg); Almost. However, If the main gear weights are taken at the same distance from the nose of the aircraft (as they are in any plane I have ever seen) and the nose or tail wheel is the other one then the equation should be

distance from main gear to balance point = ($nmg * $dist)/($lmg+$rmg+$nmg)

in the obvious direction (i.e the direction towards the other gear. If it's not the plane will not be stable sitting on the runway, much less in the air).

This is of course assuming that the $lmg = $rmg. (the plane is balanced along the propellor's axis of rotation) Otherwise you'd have a pretty funny flying airplane.

Thus endeth the Statics 201 lecture for the day. Use at your own risk. I only design things that take people 120 feet in the air and we try very hard to keep all 4 wheels firmly planted on the ground. My employer does not endorse this email.

Hope this helps.

Sincerely,

John Parker

Finally! A mailing list question I can answer with confidence!

-- John Parker, Design Engineer, Snorkel International Ph: 816/676-6419 Fax: 785/989-3556

attached mail follows:

This sounds like a job for.... JavaScript!

At 01:29 PM 2/15/2000 -0600, you wrote: >> Hi! >> >> First make a form that handles the input and put tha values in vars >> like. >> >> > The inputs are >> > 1. weight at left main gear = $lmg >> > 2. weight at other main gear = $rmg >> > 3. weight at nose or tail wheel = $nmg >> > 4. distance between main gear and nose or tail gear. = $dist >> >> then use this php code: >> >> $bp = ($lmg * $dist) / ($lmg + $rmg + $lmg); >Almost. However, If the main gear weights are taken at the same >distance from the nose of the aircraft (as they are in any plane I >have ever seen) and the nose or tail wheel is the other one then the >equation should be > >distance from main gear to balance point = ($nmg * >$dist)/($lmg+$rmg+$nmg) > >in the obvious direction (i.e the direction towards the other gear. If >it's not the plane will not be stable sitting on the runway, much less >in the air). > >This is of course assuming that the $lmg = $rmg. (the plane is >balanced along the propellor's axis of rotation) Otherwise you'd have >a pretty funny flying airplane. > >Thus endeth the Statics 201 lecture for the day. Use at your own >risk. I only design things that take people 120 feet in the air and >we try very hard to keep all 4 wheels firmly planted on the ground. >My employer does not endorse this email. > >Hope this helps. > >Sincerely, > >John Parker > >Finally! A mailing list question I can answer with confidence! >-- >John Parker, Design Engineer, Snorkel International >Ph: 816/676-6419 Fax: 785/989-3556 > >-- >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:

This is correct, but beware, they're Tech support is only reachable though a forum, and the Software has Bug's..

I like the Product, but the Company isn't focusing on it as they should...

Michael L Smith

ALLTEL Information Services Emerging Technology Solutions (501) 220-8551 Michael.L.Smithalltel.com

-----Original Message----- From: wgrantmaplesquare.com (Warren Grant) Sent: Tuesday, February 15, 2000 11:30 AM To: php3lists.php.net Subject: Re: [PHP3] PHP Editor

If you are working in PHP using any variety of MS Windows, I think you might find the best editor out there is Homesite from Allaire (http://www.allaire.com).

The Homesite editor does syntax highlighting (for PHP3 at least) and permits automatic FTP for the files you are working on.

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:

How do I display different contents in a select menu form based on the previous select menu form? I have two select menu form questions on one page and want to change the contents of the second form menu based on the first menu selection.

Example:

I have a menu form that asks: Which Operating system are you using: 1. Linux 2. Windows 3. Other

I want to display another menu form with choices based on which OS was chosen from the first menu form. Currently I have to put Windows and Linux choices together in one menu form which doesn't look right and someone could choose Windows in the first menu and choose Redhat in the second menu which is wrong.

Anyway, this may be just an HTML.forms question.

Here is the code I have <TR><TD align="right">Name: </TD><TD align="left"><input type=text name='name' size=75><br></TD></TR> <TR><TD align="right">Category </TD><TD><select name="cat" size="1"> <option value="linux">Linux</option> </option><option value="windows">Windows </option><option value="dos">Dos </option><option value="Mac">Mac </option><option value="misc">misc </option></select></TD></TR>

<TR><TD align="right">Subcategory: </TD><TD><select name="subcat" size="1"> <option value="programming">MySQL</option> </option><option value="php3">PHP3 </option><option value="html">HTML </option><option value="perl">Perl </option><option value="cgi-perl">cgi-perl </option><option value="c">C </option><option value="cpp">cpp </option><option value="bash">bash </option><option value="dos batch">batch </option><option value="Visualc">visualc </option></select></TD></TR> __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

attached mail follows:

> -----Original Message----- > From: David bradshaw [mailto:agentdjdyahoo.com] > Sent: Tuesday, February 15, 2000 10:45 AM > To: php3lists.php.net > Subject: [PHP3] Populate a form menu based on previous form menu > selection? > > > How do I display different contents in a select menu > form based on the previous select menu form? I have > two select menu form questions on one page and want to > change the contents of the second form menu based on > the first menu selection. > > Example: > > I have a menu form that asks: Which Operating > system are you using: > 1. Linux > 2. Windows > > 3. Other > > I want to display another menu form with choices based > on which OS was chosen from the first menu form. > Currently I have to put Windows and Linux choices > together in one menu form which doesn't look right and > someone could choose Windows in the first menu and > choose Redhat in the second menu which is wrong. > > Anyway, this may be just an HTML.forms question. > > Here is the code I have > <TR><TD align="right">Name: </TD><TD > align="left"><input type=text name='name' > size=75><br></TD></TR> > <TR><TD align="right">Category </TD><TD><select > name="cat" size="1"> > <option value="linux">Linux</option> > </option><option value="windows">Windows > </option><option value="dos">Dos > </option><option value="Mac">Mac > </option><option value="misc">misc > </option></select></TD></TR> > > <TR><TD align="right">Subcategory: </TD><TD><select > name="subcat" size="1"> > <option value="programming">MySQL</option> > </option><option value="php3">PHP3 > </option><option value="html">HTML > </option><option value="perl">Perl > </option><option value="cgi-perl">cgi-perl > </option><option value="c">C > </option><option value="cpp">cpp > </option><option value="bash">bash > </option><option value="dos batch">batch > </option><option value="Visualc">visualc > </option></select></TD></TR>

I saw an example of this in a book. Don't have exact code, but this will give you an idea.

I believe you will need to reload the page and if an option for the first form menu was set, then query your database and get the options available for that option. Then let PHP fill in the next menu.

To fill in the form you can use this. For example to list the all the tables of a DB on a menu form, do this (PHP Programming pg250)

<FORM ACTION="mysql_test.php3" METHOD=POST> Please select the table you want to query:<BR><BR> <SELECT NAME=database SIZE=1> <? // and connect to Db //... $db_table = mysql_list_dbs();

for ($1=0; $i < mysql_num_rows($db_table); $i++) { echo("<OPTION>" . mysql_tablename($db_table, $i)); } ?> </SELECT><BR><BR>

This should help you get started and I am pretty sure, some similar commands exist for your query.

Andrew Sheh DME Technologies -- Displays Made Easy http://www.dmetechnologies.com

attached mail follows:

Example:

I have a menu form that asks: Which Operating system are you using: 1. Linux 2. Windows 3. Other

Anyway, this may be just an HTML.forms question.

attached mail follows:

I got a site on a NT with PHP, I've got a MySQL database on linux.

What do I need to be able to look up the db information on the linux box from the NT box?

Thomas Deliduka IT Manager -------------------- New Eve Media 5629 Westlake Drive Galloway, OH 43119-8498 Phone: 614-870-3098 Fax: 614-870-7486 Mobile: 614-537-6445

attached mail follows:

Assuming:

1. the Linux box has an IP address 111.111.111.111 2. you already have granted some minimal privileges to a user called "http" 3. user "http" does not require a password

something like this ought to work:

$DB = mysql_connect("111.111.111.111","http",""); mysql_select_db("DBNAME");

This is how I use the Linux MySQL database from our IIS (Win2000) server.

Simple, huh? -- thanks to the folks who designed PHP! --John

-----Original Message----- From: Thomas Deliduka [mailto:thomasneweve.com] Sent: Tuesday, February 15, 2000 11:39 AM To: PHP List Subject: [PHP3] PHP on NT, MySQL on Linux

I got a site on a NT with PHP, I've got a MySQL database on linux.

What do I need to be able to look up the db information on the linux box from the NT box?

Thomas Deliduka IT Manager -------------------- New Eve Media 5629 Westlake Drive Galloway, OH 43119-8498 Phone: 614-870-3098 Fax: 614-870-7486 Mobile: 614-537-6445

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

At 04:29 PM 2/11/00 -0800, you wrote: >Hi all, > >Im really burning my brain on this one...if anyone has any insight that >might be helpful...I could sure use it. > >I have a multi-dimen array of default values. I need to display a page with >checkboxes and fill the checkboxes with the values (checked if key exists) >then based on what the user checks/unchecks I need to build the array back >up and redisplay the page with the current values, kind of like the >following:

I would use vals[parent1][feature1] as the name, and then in PHP you can do not unlike:

while (list($k, $v) = each($vals){ $keys = explode('][', $k); //Is it always 2-D? $vals[$keys[0]][$keys[1]] = $v; //Or, if the dimensions vary: $statement = '$vals'; while (list(,$key) = each($keys)){ $statement .= "[$key]"; } $statement .= ' = $v'; eval($statement); }

attached mail follows:

I have a slight problem, i dont know how to put dat out of a whole table into one email.

My code puts every row in a seperate email.

Here's the code:

if($myrow=mysql_fetch_array($result)) { do { $aantal=$myrow["aantal"]; $prijs=$myrow["prijs"]; $produkt=$myrow["produkt"]; $artikelnr=$myrow["artikelnr"];

mysql_select_db ("shop",$db); $sql="INSERT INTO bestelling (aantal,prijs,voornaam,achternaam,adres,plaats,artikelnr,produkt,datum,telnr ,email)

VALUES('$aantal','$prijs','$voornaam','$achternaam','$adres','$plaats','$art ikelnr','$produkt','$datum','$telnr','$email')"; mysql_query($sql);

mail ("radji600chello.nl", "bestelling", "\nNaam:$voornaam\n Achternaam:$achternaam\n Ades:$adres\r Plaats:$plaats\n Telefoonnr:$telnr\n Email:$email\n Produkt:$produkt\n Artikelnr:$artikelnr\n Aantal:$aantal\n Prijs:FL$prijs,-\n Datum:$datum\n","From:radji600chello.nl");

mail ("$email", " bevestiging bestelling", "\nGeachte heer/mevrouw $voornaam,\n bedankt voor het plaatsen van uw volgende bestelling\n\nNaam:$voornaam\n Achternaam:$achternaam\n Ades:$adres\n Plaats:$plaats\n Telefoonnr:$telnr\n Email:$email\n Produkt:$produkt\n Artikelnr:$artikelnr\n Aantal:$aantal\n Prijs:FL$prijs,-\n Datum:$datum\n","From:radji600chello.nl");

} while($myrow=mysql_fetch_array($result));

can anyone help me with this problem, a small hint is good.

attached mail follows:

At 20:50 15.02.2000 , Ramiro Radjman wrote: >I have a slight problem, i dont know how to put dat out of a whole table >into one email. > >My code puts every row in a seperate email. > >Here's the code: > >if($myrow=mysql_fetch_array($result)) > { > do > { > $aantal=$myrow["aantal"]; > $prijs=$myrow["prijs"]; > $produkt=$myrow["produkt"]; > $artikelnr=$myrow["artikelnr"]; > > mysql_select_db ("shop",$db); > $sql="INSERT INTO bestelling >(aantal,prijs,voornaam,achternaam,adres,plaats,artikelnr,produkt,datum,telnr >,email) > > >VALUES('$aantal','$prijs','$voornaam','$achternaam','$adres','$plaats','$art >ikelnr','$produkt','$datum','$telnr','$email')"; > mysql_query($sql); > > mail ("radji600chello.nl", "bestelling", "\nNaam:$voornaam\n >Achternaam:$achternaam\n Ades:$adres\r Plaats:$plaats\n Telefoonnr:$telnr\n >Email:$email\n Produkt:$produkt\n Artikelnr:$artikelnr\n Aantal:$aantal\n >Prijs:FL$prijs,-\n Datum:$datum\n","From:radji600chello.nl"); > > mail ("$email", " bevestiging bestelling", "\nGeachte heer/mevrouw >$voornaam,\n bedankt voor het plaatsen van uw volgende >bestelling\n\nNaam:$voornaam\n Achternaam:$achternaam\n Ades:$adres\n >Plaats:$plaats\n Telefoonnr:$telnr\n Email:$email\n Produkt:$produkt\n >Artikelnr:$artikelnr\n Aantal:$aantal\n Prijs:FL$prijs,-\n >Datum:$datum\n","From:radji600chello.nl"); > >} while($myrow=mysql_fetch_array($result));

hintlist:

1. use a while loop instead of combinations of "if" and do/while (it would be exactly the same result, but looks much better and is cleaner) 2. when you put a "mail()" into a loop, it sends one mail per loop (that should be clear in the moment you decide to use loops)

solution: simply use mail after the loop.

mit freundlichen Grüßen,

Gregor Welters

----------------------------- Welters PC-Service, Grafenberger Allee 81, 40237 Düsseldorf, Deutschland

Tel: 0211/9660096 Mobil: 0173/2776469 Fax: 0211/9660093 mailto: gwelterswelters.de look at: http://www.welters.de

attached mail follows:

There is early support for XML-DOM in the current CVS at the moment (from Uwe Steinmann). Have a look at ./php4/tests/testdom for sample code. There's no documentation yet, but I've been using it for some experimental stuff, no problems.

----- Original Message ----- From: "Didier Perhirin" <dperhirincosmosbay.com> To: "Anh (Ly) Vuong" <avuongcisco.com>; "Andrei Zmievski" <andreiispi.net> Cc: <php3lists.php.net>; <php4betalists.php.net>; <php-announcelists.php.net> Sent: Wednesday, February 16, 2000 5:27 AM Subject: Re: [PHP4BETA] PHP Template Engine Request For Participation

> > Hello, > > Indeed, It will be great when PHP will support XML/XSLT DOM api, like ASP > and the ActiveX XMLDOM. > Today, the only way I find to do it is to call a servlet by an HTTP > connection and the fsockopen function from a .php page. > Do you know another solution ? > > Cheers, > > Didier > > At 11:05 15/02/2000 -0500, Anh (Ly) Vuong wrote: > > > > Hello Andrei, > > > > Does not this effort similar to XSLT & XP? > > > > What I would like to see is PHP to support XML & XSLT, without resort > >to Java; which is currently the only choice if I want to do XSL. > > > > Cheers, > > Ly Vuong > >--- > >Andrei Zmievski wrote: > >> > >> Hello, > >> > >> I have set up a mailing list to discuss the design for the built-in PHP > >> template engine. To read the introduction to the proposed design, point > >> your browsers to http://va.php.net/~andrei/tpl-engine.txt. If you would > >> like to participate, join the list by sending email to > >> php-template-subscribelists.php.net. See you there! > >> > >> -Andrei > >> > >> "C combines all the power of assembly language with > >> all the ease of use of assembly language" -- trad > >> > >> -- > >> PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > >> To unsubscribe, e-mail: php4beta-unsubscribelists.php.net > >> For additional commands, e-mail: php4beta-helplists.php.net > >> To contact the list administrators, e-mail: php4beta-adminlists.php.net > > > >-- > >PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > >To unsubscribe, e-mail: php4beta-unsubscribelists.php.net > >For additional commands, e-mail: php4beta-helplists.php.net > >To contact the list administrators, e-mail: php4beta-adminlists.php.net > > > > > > > > -- > PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > To unsubscribe, e-mail: php4beta-unsubscribelists.php.net > For additional commands, e-mail: php4beta-helplists.php.net > To contact the list administrators, e-mail: php4beta-adminlists.php.net >

attached mail follows:

Hello Enrique,

On 15-Feb-00 10:03:10, you wrote:

>Can you recommend me books about php and mysql?

Look here for reviews of books of interest for PHP developers:

http://phpclasses.UpperDesign.com/products.html

More reviews will be posted soon. Just subscribe to the site to be notified whena new review is made available.

Regards, Manuel Lemos

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

-- E-mail: mlemos

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

attached mail follows:

On 15 Feb 2000, Manuel Lemos wrote:

> Hello Enrique, > On 15-Feb-00 10:03:10, you wrote: > >Can you recommend me books about php and mysql? > > Look here for reviews of books of interest for PHP developers: > > http://phpclasses.UpperDesign.com/products.html > > More reviews will be posted soon. Just subscribe to the site to be > notified whena new review is made available.

It would be fine if I can see the names of the authors. Links to "More detail" could be something more, than links to the reviews.

Have a look at http://www.php.net/books.php3.

-Egon

attached mail follows:

OK, well would this surfice: ereg("([[:digit:].]+)", $string, $result);

Nick

----- Original Message ----- From: "Noor Dawod" <noorcomrax.com> To: "'NickM'" <nickregiocom.net> Cc: "'PHP3 Mailing List'" <php3lists.php.net> Sent: Tuesday, February 15, 2000 4:05 PM Subject: RE: [PHP3] regex

> Sure, no problem: > > $string = "<html>\n<body>\nHere is a number: 34.25 <br>\n</body>\n</html>\n"; > > when applying the given regex, it doesn't return the required 34.25. > > Noor > > > On Tue 15 February 2000 16:08, NickM [SMTP:nickregiocom.net] wrote: > > Could you post an example of the string > > > > Nick > > > > > > ----- Original Message ----- > > From: "Noor Dawod" <noorcomrax.com> > > To: "'PHP3 Mailing List'" <php3lists.php.net> > > Sent: Tuesday, February 15, 2000 2:55 PM > > Subject: [PHP3] regex > > > > > > > Hello, > > > > > > I wrote a simple program to read a file, then search in it for a regex > > that searches for a string that contains numbers. This is it: > > > > > > "^(PRE-STRING)([\d\s\.]+)(POST-STRING)$" > > > > > > PRE-STRING and POST-STRING could be predefined strings that border the > > numbers. > > > > > > it is not working, what is wrong with it? > > > > > > TIA, > > > Noor > > > > > > > > > -- > > > 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'm unfortunately limited for the options > available to me and cannot use a MySql database > to store information. And instead need to use > text files to write information to and get > information from. > > Anyone know any good tutorials on this or offer > me any pointers to get me started ??

Read the manual at http://www.php.net search for files.

This is some code from one of my programs.

To read a delimited text file:

if(is_file("$DoorQuoteFile")) { $FSize = filesize("$DoorQuoteFile"); // clear out $data each time... unset($data); $num = 0; $row=1; $ReadFile = fopen($DoorQuoteFile,"r");//Opens the data file

while ($data = fgetcsv($ReadFile,$FSize)) { //Turns the file into an array by looping... $num = count($data);

//The array... $doors[$row] = array($data[0], $data[1], $data[2], $data[3], $data[4], $data[5], $data[6], $data[7], $data[8], $data[9], $data[10], $data[11], $data[12], $data[13], $data[14]); $row++; } }//if is_file end

To write a delimited text file.

$ReWriteFile = fopen("$DoorQuoteFile","w");

if(!($ReWriteFile)) { print("Error: "); print("'File' could not be created\n"); exit; } for($Z=1; $Z<= $row-1; $Z++)

if($Quantity[$Z] < "1" || $Quantity[$Z] == "0" || $Quantity[$Z] == "") { //Do Nothing } else {

$Var1=($Quantity[$Z].",".$Width[$Z].",".$Height[$Z].",".$doors[$Z][3].",".$d oors[$Z][4].",".$A[$Z].",".$B[$Z].",".$C[$Z].",".$D[$Z].",".$M[$Z].",".$door s[$Z][10].",".$doors[$Z][11].",".$doors[$Z][12].",".$doors[$Z][13].",".$door s[$Z][14]); fputs($ReWriteFile, "$Var1"."\n"); }// if($Quantity[$Z] End........

} //for($Z=1; $Z<= $row; $Z += 1) loop End.......

fclose($ReWriteFile); // close the file.......

Ted Knudson http://www.automatedcabinets.com

attached mail follows:

In MySQL

create table tablename (id int not null default 100000 auto_increment)

HTH TomHenry

At 04:28 PM 2/15/00 +0100, David Diaz i Torrico wrote:

>How do I set the starting value at the creation time of an AUTO_INCREMENT >row? > > > >-- >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:

WeberDev.com has a special section for this. check out the projects section on http://www.WeberDev.com

thanks

berber http://www.WeberDev.com

-----Original Message----- From: Jeff Holzfaster [mailto:archiverdb.geocrawler.com] Sent: Monday, February 14, 2000 3:59 PM To: php3lists.php.net Subject: [PHP3] Contract Developer?

This message was sent from Geocrawler.com by "Jeff Holzfaster" <jholzyforbin.com> Be sure to reply to that address.

Where do I go to find a developer that would be interested in a small job? I have tried phpbuilder without any luck.

Geocrawler.com - The Knowledge Archive

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

Where can I get the library I need to run PHP3 with MS SQL Server on Windows NT 4.0/IIS 4.0

Thanks, Maurice

attached mail follows:

How can I convert an integer to binary?

n Angel

attached mail follows:

i just got the current php3 snapshot (not php4), and the results are similar, but slightly different:

Fatal error: Call to unsupported or undefined function imagecreate() in /usr/webservers/https-web99/htdocs/pngtest.php on line 2

hmm, ok, check this out: php 3.0.14 distribution:

[rootweb99 php-3.0.14]# ./configure --with-apxs=/usr/webservers/https-web99/bin/apxs --with-config-file-path=/usr/webservers/https-web99/conf --with-gd --with-mysql --with-pgsql=/usr --with-ttf --with-x --with-ldap --with-snmp --with-xml --with-zlib --with-gdbm --with-db2 | grep -i gd checking for gdbm_open in -lgdbm... (cached) yes checking preferred dbm library... gdbm chosen checking for gdbm.h... (cached) yes checking whether to include GD support... yes checking for gdImageLzw in -lgd... (cached) no checking for gdImageCreateFromPng in -lgd... (cached) no checking for gdImageCreateFromGif in -lgd... (cached) no checking for gdImageColorResolve in -lgd... (cached) no checking for gdImageGif in -lgd... (cached) no checking for gdImageCopyMerge in -lgd... (cached) no checking for gdImageGifToSink in -lgd... (cached) no checking for gdImageString16 in -lgd... (cached) no checking whether to enable t1lib support with GD... no checking for gdbm_open in -lgdbm... yes checking for GDBM support... yes creating extra/gd/bdf2gdfont

php3 snapshot: [rootweb99 php3]# ./configure --with-apxs=/usr/webservers/https-web99/bin/apxs --with-config-file-path=/usr/webservers/https-web99/conf --with-gd --with-mysql --with-pgsql=/usr --with-ttf --with-x --with-ldap --with-snmp --with-xml --with-zlib --with-gdbm --with-db2 | grep -i gd checking for gdbm_open in -lgdbm... (cached) yes checking preferred dbm library... gdbm chosen checking for gdbm.h... (cached) yes checking for gdImageCreateFromPng in -lgd... (cached) no checking for gdImageCreateFromGif in -lgd... (cached) no checking for gdImageLzw in -lgd... (cached) no checking for gdImageColorResolve in -lgd... (cached) no checking for gdImageString16 in -lgd... (cached) no checking whether to include GD support... no configure: warning: No gd support found. Skipping FreeType Configuration checking for gdbm_open in -lgdbm... yes checking for GDBM support... yes creating extra/gd/bdf2gdfont

[rootweb99 /root]# rpm -q gd gd-devel gd-1.7.3-1 gd-devel-1.7.3-1

i think what's happening here is that my gd is linked against png, ttf, and Xpm, so if configure checks for gdImageCreateFromPng() against just -lgd or -lgd -lpng, it will fail. it needs -lgd -lpng -lttf -L/usr/X11R6/lib -lXpm -lX11 to successfully compile something to properly use gdImageCreateFromPng().

for example:

[rootweb99 /root]# cat testgd.c #include <gd.h> int main(int argc, char *argv[]) { gdImagePtr nog; nog = gdImageCreateFromPng(NULL); return 0; }

(yes the NULL is bad).

[rootweb99 /root]# gcc -o testgd testgd.c -lgd -lpng /usr/lib/libgd.so: undefined reference to `TT_New_Glyph' /usr/lib/libgd.so: undefined reference to `TT_Load_Glyph' /usr/lib/libgd.so: undefined reference to `TT_Get_Instance_Metrics' /usr/lib/libgd.so: undefined reference to `TT_New_Instance' /usr/lib/libgd.so: undefined reference to `TT_Get_CharMap_ID' /usr/lib/libgd.so: undefined reference to `TT_Get_Glyph_Metrics' /usr/lib/libgd.so: undefined reference to `TT_Set_Instance_Resolutions' /usr/lib/libgd.so: undefined reference to `TT_Get_Glyph_Pixmap' /usr/lib/libgd.so: undefined reference to `TT_Close_Face' /usr/lib/libgd.so: undefined reference to `TT_Get_Glyph_Outline' /usr/lib/libgd.so: undefined reference to `TT_Get_Face_Properties' /usr/lib/libgd.so: undefined reference to `TT_Transform_Outline' /usr/lib/libgd.so: undefined reference to `TT_Open_Face' /usr/lib/libgd.so: undefined reference to `TT_Init_FreeType' /usr/lib/libgd.so: undefined reference to `TT_Char_Index' /usr/lib/libgd.so: undefined reference to `TT_Done_Instance' /usr/lib/libgd.so: undefined reference to `TT_Get_CharMap_Count' /usr/lib/libgd.so: undefined reference to `TT_Set_Instance_CharSize' /usr/lib/libgd.so: undefined reference to `TT_Get_CharMap' /usr/lib/libgd.so: undefined reference to `TT_Get_Glyph_Bitmap' /usr/lib/libgd.so: undefined reference to `TT_Done_Glyph' /usr/lib/libgd.so: undefined reference to `XpmReadFileToXpmImage' collect2: ld returned 1 exit status

[rootweb99 /root]# gcc -o testgd testgd.c -lgd -lpng -lttf -L/usr/X11R6/lib -lXpm -lX11 [rootweb99 /root]#

am i on the right track here?

unfortunately i'm rather configure-script-illiterate. if anyone could suggest the proper way to "fix" this, i would appreciate it.

i mentioned before about how i manually add -lpng -L/usr/X11R6/lib -lXpm -lX11 to my APXS_LDFLAGS so my apache doesn't fail to start post-configure, but i didn't catch before that it wasn't including the proper gd support because of this at an earlier stage...frown.

here's what i did to hack it to work:

perl -pi -e 's/LIBS="-lgd/LIBS="-lgd -lpng -lttf -L\/usr\/X11R6\/lib -lXpm -lX11/g' configure

and then:

[rootweb99 php-3.0.14]# ./configure --with-apxs=/usr/webservers/https-web99/bin/apxs --with-config-file-path=/usr/webservers/https-web99/conf --with-gd --with-mysql --with-pgsql=/usr --with-ttf --with-x --with-ldap --with-snmp --with-xml --with-zlib --with-gdbm --with-db2 | grep -i gd checking for gdbm_open in -lgdbm... (cached) no checking whether to include GD support... yes checking for gdImageLzw in -lgd... (cached) no checking for gdImageCreateFromPng in -lgd... (cached) yes checking for gdImageCreateFromGif in -lgd... (cached) no checking for gdImageColorResolve in -lgd... (cached) yes checking for gdImageGif in -lgd... (cached) no checking for gdImageCopyMerge in -lgd... (cached) yes checking for gdImageGifToSink in -lgd... (cached) no checking for gdImageString16 in -lgd... (cached) yes checking whether to enable t1lib support with GD... no checking for gdbm_open in -lgdbm... no checking for GDBM support... yes creating extra/gd/bdf2gdfont

i still need to append "-L/usr/X11R6/lib -lXpm -lX11" to APXS_LDFLAGS in the Makefile then, but after that and a build and install...it works!

woo!

that can't be used for everyone tho, since not everyone uses a gd built against ttf and Xpm. there must be a way to check for that somehow and adjust the configure script accordingly, no?

-tcl.

On Tue, 15 Feb 2000 rasmusphp.net wrote:

> Try a snapshot from snaps.php.net and let us know if the problem is fixed. > > On Tue, 15 Feb 2000, tc lewis wrote: > > > > > i'm having a similar problem as found in bug id #3374 at bugs.php.net > > http://bugs.php.net/bugs.php3?id=3374&edit=1 > > > > i'm using apache 1.3.11, php 3.0.14, and gd 1.7.3 (1.7.3-1 contributed > > source rpm) on a redhat-6.1 based platform with a rebuilt 2.2.14 kernel > > and a rebuilt apache from scratch and blah blah. i am compiling php at a > > dso along with some other apache modules. > > > > anyway, this gd obviously doesn't support the gif type, so that's out. > > and that's fine. but imagepng() doesn't seem to function properly either. > > > > here's the php i'm using to test: > > [rootweb16 htdocs]# cat pngtest.php > > <? > > $img = ImageCreate(100, 100); > > $red = ImageColorAllocate($img, 255, 0, 0); > > ImageLine($img, 0, 0, 99, 99, $red); > > /* Show & destroy an image */ > > Header( "Content-type: image/png"); > > ImagePng($img); > > ImageDestroy($img); > > ?> > > > > on the web it creates html containing: > > "<br> > > <b>Fatal error</b>: Call to unsupported or undefined function imagepng() in <b>/usr/webservers/https-web16/htdocs/pngtest.php</b> on line <b>7</b><br>" > > > > i've configured php with: > > > > ./configure --with-apxs=/usr/webservers/https-web16/bin/apxs --with-config-file-path=/usr/webservers/https-web16/conf --with-gd --with-mysql --with-pgsql=/usr --with-ttf --with-x --with-ldap --with-snmp --with-xml --with-zlib --with-gdbm --with-db2 > > > > > > and then manually modified the Makefile to add "-lpng -L/usr/X11R6/lib -lXpm -lX11" > > to APXS_LDFLAGS, as apache won't start without that. > > > > what other info should i provide? > > > > any tips? > > sorry if this is a duplicate question, but i searched and couldn't really > > seem to find an authoritative resolvement. > > > > thanks for any help. > > > > -tcl. > > > > > > -- > > 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 want to distinguish between Man and Non Mac users to my site. And I know there has got to be a way to do it using:

getenv("HTTP_USER_AGENT")

But I guess I do not know how to compare the response so I can always tell the difference.

I tried searching the archive with no success, does anyone have a good if then type statement that will help me accomplish this.

Many thanks.

Brian

attached mail follows:

If it's just Mac/Not Mac you want to distinguish, just search for "Macintosh" in the user agent....

> -----Original Message----- > From: Brian Smith [mailto:smittybgpwm.com] > Sent: 15 February 2000 21:40 > To: php3lists.php.net > Subject: [PHP3] Checking getenv("HTTP_USER_AGENT") > > > I want to distinguish between Man and Non Mac users to my site. > And I know > there has got to be a way > to do it using: > > getenv("HTTP_USER_AGENT") > > But I guess I do not know how to compare the response so I can always tell > the difference. > > I tried searching the archive with no success, does anyone have a good if > then type statement > that will help me accomplish this. > > Many thanks. > > Brian > > -- > 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:

This is going to sound excessively stupid, but I'll ask anyway:

I've searched through the message archives and can't find anything, definitive. So would anyone know how php may/could access corba?

I've written a full ftp class that talks directly to port 21, and finding similar things for pop servers is also easy. Does corba run on a port that can be accessed similarly?

I'm lost here.

-- Shaun Thomas Programmer InternetWorks McLeodUSA 319.790.5037 / fax 319.369.3089

attached mail follows:

> I've searched through the message archives and can't find anything, > definitive. So would anyone know how php may/could access corba? > > I've written a full ftp class that talks directly to port 21, and > finding similar things for pop servers is also easy. Does corba > run on a port that can be accessed similarly?

I know GNOME uses the ORBit CORBA library (see http://www.gnome.org). I have idly thought that building a PHP front end to ORBit might be useful, but haven't done thing one about it. Such an interface would allow PHP to, among other things, control any GNOME application, such as the GIMP.

ORBit seems the best tool from my casual glance, for the following reasons: 1. Open Source (of course) 2. Small - 30K footprint according to the GNOME folk. 3. Used by a fairly large no. of CORBA applications (the GNOME things, among others, so likely to continue to be maintained and used. Also probably actually usable.

I, of course, am an object newbie so nothing I say has much validity :O)

attached mail follows:

I am working on a web site where we are collecting/creating simple tips for linux users and we want to set something up so that on the front pageof the site it displays 4-5 random tips from the database (simple text field), but I can't think of any way to pull 5 random lines from the database.

Any suggestions would be great.

BTW php3 and mysql and apache

-- Christopher R. Moewes-Bystrom christophermoewes.com http://www.moewes.com http://www.linuxnovice.org

attached mail follows:

If you know the ids, select several random numbers, then pull those queries. If you don't know the ids, pick a random number, and pull a query from the database until you get however many results. It obviously helps if you know a range, and can get your random number to select from a smaller field.

----- Original Message ----- From: <christophermoewes.com> To: "PHP3" <php3lists.php.net> Sent: Tuesday, February 15, 2000 4:26 PM Subject: [PHP3] Getting random results from database

> I am working on a web site where we are collecting/creating simple tips for > linux users and we want to set something up so that on the front pageof the > site it displays 4-5 random tips from the database (simple text field), but > I can't think of any way to pull 5 random lines from the database. > > Any suggestions would be great. > > BTW php3 and mysql and apache > >

attached mail follows:

At 06:04 PM 2/14/00 +0100, you wrote: >Hi, >I have a form on a site from which the user can chose zip files to >download. This gets fed to a script which then send the chosen zip file >to the browser. All works well until the the users selects more than one >file - I can't figure out how to make it work. >I tried putting 2 headers in the resultant output, but, unsurprisingly, it >didn't work. >Has anyone else any other suggestions?

Zip the files together into one big zip?

attached mail follows:

At 09:32 AM 2/13/00 -0000, you wrote: >If it's just a windows thing then I'm not worried, but with persistent >connections I thought the connection to the database was terminated after >the entire script/page had completed.

The whole point of persistent connections is that they hang around for the same user to use them again...

You only have persistent connections if you are using PHP4 and the ISAPI Module and you ask for them.

attached mail follows:

I'm attempting to install PHP-3.0.14 & mySQL on a SunOS 5.6 box running Stronghold 2.4.2 httpd server.

The php make is now ending with:

<unknown> 0xbf4 libmodphp3-so.a(study.o) <unknown> 0xbf0 libmodphp3-so.a(study.o) <unknown> 0xbec libmodphp3-so.a(study.o) <unknown> 0xbe8 libmodphp3-so.a(study.o) ld: fatal: relocations remain against allocatable but non-writable sections collect2: ld returned 1 exit status apxs:Break: Command failed with rc=65536 make: *** [libphp3.so] Error 1

Any suggestions?

attached mail follows:

I have several questions regarding passwords with FreeBSD.

If I got a password file from Caldera and want to convert it to FreeBSD v3.4 i'm not sure what kind of encryption is used with Caldera if it's MD5/DES or whatever. If i had the password file and want to convert it to FreeBSD is there a way?

Is there a way to go from MD5 to DES or DES to MD5?

Any help would be appreciated.

Brian PS: Please respond back to me!

attached mail follows:

Hi,

I have the following problem.

The query:

select * from table1 left join table2 on table1.Clientid = table2.Clientid where table1.Clientid = 2110

This works fine from the mysql client, return both tables.

But in php, it will only return the data on table1.

$strsql = "select * from table1 left join table2 on table1.Clientid = table2.Clientid where table1.Clientid = 2110";

$result = mysql_db_query($database,$strsql);

(For testing)

for ($z=0;$z<400;$z++)

{

echo mysql_field_name($result,$z);

}

exit;

Only returns the field names for the first table.

I know the mysql_field_name will not return the field name if it contains a NULL, but most of the fields contain 0 or other integers.

Even specifying with mysql_result($result,$i,$fieldname)

If I try to specify the fieldname on the second table I get the mysql error that that fieldname is not in the result index.

Windows Law 1: What boots up must come down... -------- All I ask of life is a constant and exaggerated sense of my own importance. -------- Chris Kovalcik Production Co-ordinator Interactive Broadcasting Corporation technobcadventure.com ------------------------------------------------- Creators of: BC Adventure Network www.bcadventure.com BC Books www.bcbooks.com Casting Shadows www.castingshadows.com Cowboylife www.cowboylife.com Fish BC www.fishbc.com

attached mail follows:

Could somene please help with the following:

Below is part of a submission form that deals with images.

Upto 3 Images May Be Sent.<br><p></p>

photo1<input type="file" name="picture" size="25"><br> photo2<input type="file" name="picture" size="25"><br> photo3<input type="file" name="picture" size="25"><br>

**************************************************************************** ****************** This bit of code deals with the email notification of text entered from the form that handles text input not shown above.

How can physical images like "jpg" be attached and sent together with the text notification ???

mail("$email_address", "Your Profile setup", "$first_name Thank you for your interest! Your Profile Has Been Successfully Entered Onto This Website We Hope You Enjoy Every Visit!!! sve.com") ; mail("enquirysve.com","New Customer Profile", "Ref No:$ref, First name:$first_name, Last name:$last_name, Post address:$post_address ,Phone No:$phone_no , Email:$email_address");

**************************************************************************** ******************** This bit of code i understand is able to attach and send images.

Alternatively,

Tryed using the above bit of the html code to select images and setting this script with appropriate variables However having trouble making it work. Any corrections that could be pointed ????

// ************************************ // E-mail functions (binary attachment) // ************************************ $dest_email="enquirysve.com"; $title="Mail Attach"; $message_to_send="Testing Mail Attachment" $from="$email_address"; $type="jpg";

$filename="$picture_name"; $path="$picture_path"; $type="$picture_type";

m_attach_bin($dest_email, $title, $message_to_send, $from, $type); m_attach_file_bin($filename, $path, $type); m_attach_send_bin($type);

function m_attach_bin( $to_fname, $subject_ftext, $message, $from, $type ) { static $hold_to=""; static $hold_subject=""; static $hold_from=""; static $hold_message="";

static $boundary="-----------------kjbsdf9873987348735"; static $MIME="MIME-Version: 1.0\nContent-Type: multipart/mixed;\n\tboundary=\"$boundary\"\n\nThis is a multi-part message in MIME format.\n\n"; static $startMsg="\n--$boundary\nContent-Type: text/plain;\n\tcharset=\"iso-8859-1\"\nContent-Transfer-Encoding: 8bit\n\n"; static $ending="\n--$boundary--";

if ( $to_fname="" ) /* send it! */

{ $hold_message=$hold_message . $ending;

return( mail( $hold_to, $hold_subject, $hold_message, $hold_from ) ); } elseif ( $message="" ) /* we must be attaching a file */

$hold_message=$hold_message . "\n--$boundary\nContent-Type: image/".$type.";\n\tname=\"$to_fname\"\nContent-Transfer-Encoding: base64\nContent-Disposition: inline;\n\tfilename=\"$to_fname\"\n\n$subject_ftext";

} else /* starting a new message */ { $hold_to=$to_fname; $hold_subject=$subject_ftext; $hold_message=$startMsg . $message."\n\n"; $hold_from="From: $from\n$MIME\n"; } };

function m_attach_file_bin( $shortname, $longname, $type ) { $fppen($longname,"r");

$in = fread( $fp, filesize( $longname ) ); fclose( $fp ); $out= chunk_split(base64_encode($in));

return( m_attach_bin( $shortname, $out, "", "", $type ) ); };

function m_attach_send_bin($type) { return( m_attach_bin( "","","","", $type ) ); }; */

// *************** End E-mail functions *****************

/* USAGE:

Set the following variables as appropriate:

$dest_email: the destination address $title: message subject $message_to-send: the message you want to send $from: your e-mail address $type: file type (i.e. &