NEOHAPSIS - Peace of Mind Through Integrity and Insight

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com

Neohapsis > Archives > PHP Discussion Digest> 2001-08

From: php-general-digest-helplists.php.net
Date: Tue Aug 14 2001 - 19:23:57 CDT

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

php-general Digest 15 Aug 2001 00:23:57 -0000 Issue 816

Topics (messages 62623 through 62719):

Re: Classes and performance bottlenecks
62623 by: Christian Reiniger

Re: call to unsupported or undefined function mysql_connect()
62624 by: Luis Brito (AYUDANTE)

Re: mysql_query()
        62625 by: _lallous
        62627 by: _lallous
        62639 by: Alnisa Allgood
        62642 by: _lallous
        62659 by: Alnisa Allgood

Re: qwestion about %E6%E2%E0%F7%EA%E0
62626 by: BRACK
62708 by: BRACK

Re: session security issue
        62628 by: Sean C. McCarthy
        62666 by: Steve Brett
        62707 by: David Price

session_questions("end")
62629 by: Aniceto Lopez

bizarre problems with php_gd.dll and IIS
62630 by: Michael Hall
62636 by: Phil Driscoll

Re: SQL script ------ .any help
62631 by: MindHunter

Instalation
        62632 by: Roman
        62637 by: Jean-Arthur Silve
        62643 by: Luis Brito (AYUDANTE)
        62663 by: Steve Brett

Re: The secrecy of PHP code
62633 by: ~~~i LeoNid ~~

Session preserve
62634 by: Alex Sofronie

Regular Expression Problem and PHP 4 (urgent)
62635 by: Ross Nielsen

Re: Need people's advice on a web registration system.
62638 by: Jean-Arthur Silve

Re: problems sorting an associative array...
62640 by: Tim Ward

Anyone using Interbase/Linux?
62641 by: Todd Cary

unlink() and safe mode....
62644 by: Jan De Luyck

Select
        62645 by: Jeremy Morano
        62646 by: Jon Farmer
        62647 by: Pavel Jartsev
        62648 by: Jon Farmer
        62649 by: Alfredeen, Johan

Re: "location bar"
62650 by: Kevin L
62658 by: Kurth Bemis

Re: to include php file into html page
62651 by: Hugh Bothwell

could i get a clue?
        62652 by: marilyn manson
        62656 by: Renze Munnik
        62657 by: Hugh Bothwell

Looking for link system
62653 by: Thomas Deliduka
62655 by: Alfredeen, Johan

PHP or SSI -- What's faster?
62654 by: Christopher Raymond

Re: Put value directly into form?
62660 by: Phil Latio

SNMP and PHP
62661 by: Heiko Maiwald
62664 by: Robert Covell

nav buttons not working correctly
62662 by: chip.wiegand.simrad.com

How dynamically create objects
62665 by: Bret R. Zaun

smart table construction from array
62667 by: Peter Torraca
62684 by: Sheridan Saint-Michel

Re: variable $PATH_INFO
62668 by: Hidulf

Re: installation on windows
62669 by: Andrew Stopford

Win32 Compilation
62670 by: Jerry Evans

[PHP-WIN] Re: installation on windows
        62671 by: Angie Tollerson
        62674 by: Phil Driscoll
        62675 by: Phil Driscoll

Win32 mail()
62672 by: Jerry Evans

Using Sockets to connect to an SSL site?
62673 by: Brandon Orther
62718 by: Gyozo Papp

Re: printing
62676 by: Fernando Avila

insertion question
62677 by: Pétur Björn Thorsteinsson

Code works fine on Apache, but not on PWS.
62678 by: John Meyer

Q: array intersection problem
62679 by: Joe Rice
62719 by: Gyozo Papp

popen returns true whether script exists or not?
62680 by: Tom Hodder

PHP to embed font
        62681 by: admin
        62683 by: Tyler Longren
        62686 by: Inércia Sensorial

Web page authentications
62682 by: admin

Re: inserting a remote html file
62685 by: Boaz Amit

mail function
62687 by: Boaz Amit

saving the client's file upload location
62688 by: Bob
62690 by: Inércia Sensorial

Re: Help me please.(Running stand-alone php)
62689 by: miguel valero

PHP Shopping Carts ??
        62691 by: Christopher Raymond
        62693 by: DrWebPat.aol.com
        62699 by: Miles Thompson
        62700 by: Evan Nemerson

Re: PHP_SELF
62692 by: Chris Worth

Arrays/forms/Loops/Persist (was Re: [PHP] UPDATE syntax)
62694 by: Gerard Samuel

php upload on MAC
        62695 by: Jason Radley
        62696 by: Erik H. Mathy
        62706 by: Jason Radley

cURL tutorials ?
62697 by: Brandon Orther
62698 by: Erik H. Mathy

POST from the script
62701 by: Marc Hanlon
62713 by: Meir Kriheli

Loop though email list
        62702 by: Erich Kolb
        62703 by: Tyler Longren
        62704 by: Daniel Adams

Virtual Servers (apache) and php
62705 by: Jay Paulson
62712 by: CGI GUY

Session problems...
62709 by: Dana Holt

php and java
62710 by: Gaylen Fraley

Foreach loop syntax
62711 by: Keith Devens

Loop error?
        62714 by: PHP List
        62715 by: Gyozo Papp
        62716 by: Andrew Braund
        62717 by: PHP List

Administrivia:

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

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

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

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

attached mail follows:

On Tuesday 14 August 2001 08:37, Maxim Maletsky wrote:
> See, there's also a time needed for the server to read the included
> file - an extra effort for your hard disk.
> If you'd put everything in one file it would work for you faster, but,
> of course, less portable.

I disagree. Aftre the first access the data will be in the filesystem
cache, so the reading is only a series of memcpy() (or perhaps even less).

Parsing time should be the problem. Look into Zend Cache and APC cache
(apc.communityconnect.com|org)

-- 
Christian Reiniger
LGDC Webmaster (http://lgdc.sunsite.dk/)
REALITY.SYS corrupted ... reboot Universe [Y,n]?

attached mail follows:

On Tue, 14 Aug 2001, Luis Brito wrote:

Hi at all. > > I get this problem, I use a sparcstation 20 and my system is debian > potato, I installed php3,php-mysql and mysql I did with the command > apt-get install. > Then I do not understand why that happen?, because I think > that I did well, and I apreciated if somebody can help me to fix this. > > Thanks > Luis Brito > >

attached mail follows:

I have made this a small script called SQL2PHP,

---
<html>
<head><title>SQL2PHP</title></head>
<body>
<pre>
<?
  /*
    SQL2PHP v0.1 by elias_bachaalanyyahoo.com
    You may use this script as long as you credit the original author
  */
  function parse_sql_stream($all)
  {
    $len = strlen($all);
    $lines = array();
    $inquotes = false;
    $lastquote = '';
    $lastch = "\xa";
    $start = 0;
    $incomment1 = false;
    $incomment2 = false;
    $brokestr = "";
    for ($i=0;$i<$len;$i++)
    {
      $ch = $all[$i];
      // single line comment - ON
      if ( $ch == '#' && !$inquotes)
      {
        $incomment1 = true;
        continue;
      }
      // single line comment - OFF
      if ($incomment1 && ($ch == "\r" || $ch == "\n"))
      {
        $incomment1 = false;
        $start = $i;
        continue;
      }
      // multiline comment - ON
      if (!$inquotes && $lastch == '/' && $ch == '*')
      {
        $incomment2 = true;
        $brokestr = substr($all, $start, $i - $start - 1);
        continue;
      }
      // multiline comment - OFF
      if ($incomment2 && $ch == '/' && $lastch=='*')
      {
        $incomment2 = false;
        $start = $i+1;
        continue;
      }
      // inquote desicions
      if (($ch == '\'' || $ch=='"'))
      {
        if (!$inquotes)
        {
          $lastquote = $ch;
          $inquotes = true;
        }
        else
          $inquotes = ( ($lastch == "\\" && $ch == $lastquote) || ($ch !=
$lastquote) );
      }
      // new statment decision
      if ($ch == ';' && !$inquotes && !$incomment1 && !$incomment2)
      {
        $lines[] = trim($brokestr . trim(substr($all, $start, $i -
$start)));
        $brokestr = "";
        $i++; // skip the ';'
        $start = $i;
      }
      // update last read character
      $lastch = $ch;
    } // for i
    return $lines;
  }
  function parse_sql_file($filename)
  {
    $fp = fopen($filename, 'rb');
    $all = fread($fp, filesize($filename));
    fclose($fp);
    return parse_sql_stream($all);
  }
  set_time_limit(0);
  mysql_connect('localhost', 'test', 'test');
  $test = parse_sql_file('file3.sql');
  for ($i=0; $i<count($test);$i++)
  {
    $result = mysql_query($test[$i]);
    if (!$result)
    {
      echo "Failed at line $i with query:\n{$test[$i]}\nMySql error:" .
mysql_error() . "\n";
      break;
    }
  }
  echo "done!\n";
?>
</pre>
</body>
</html>
---
file3.sql can contain:
---
DROP DATABASE t;
CREATE DATABASE t;
USE t;
#
# Table structure for table 'brands'
#
DROP TABLE /*!32200 IF EXISTS*/ brands;
CREATE TABLE /*!32300 IF NOT EXISTS*/ brands (
  id int(10) unsigned NOT NULL auto_increment,
  language tinyint(2) DEFAULT '1' ,
  company varchar(50) ,
  countryid int(10) unsigned ,
  name varchar(50) NOT NULL DEFAULT '' ,
  logo varchar(200) NOT NULL DEFAULT '' ,
  description mediumtext NOT NULL DEFAULT '' ,
  PRIMARY KEY (id)
);
#
# Dumping data for table 'brands'
#
INSERT INTO brands VALUES("122","1",NULL,"12","Hummer","","");
INSERT INTO brands VALUES("2","1",NULL,"12","Buick","","");
INSERT INTO brands VALUES("3","1",NULL,"12","GMC","","");
INSERT INTO brands VALUES("4","1",NULL,"12","Jeep","","");
INSERT INTO brands VALUES("5","1",NULL,"12","Ford Motor Company","","");
INSERT INTO brands VALUES("6","1",NULL,"12","Opel","","");
INSERT INTO brands VALUES("7","1",NULL,"12","Audi","","");
INSERT INTO brands VALUES("8","1",NULL,"12","BMW","","");
INSERT INTO brands VALUES("9","1",NULL,"12","Porche","","");
INSERT INTO brands VALUES("10","1",NULL,"12","Mercedes","","");
INSERT INTO brands VALUES("11","1",NULL,"12"," Infinity*","","");
INSERT INTO brands VALUES("12","1",NULL,"12","Isuzu","","");
INSERT INTO brands VALUES("13","1",NULL,"12","Subaru","","");
INSERT INTO brands VALUES("14","1",NULL,"12","Suzuki","","");
INSERT INTO brands VALUES("15","1",NULL,"12","Mazda","","");
INSERT INTO brands VALUES("16","1",NULL,"12","Mitsubishi Motors","","");
INSERT INTO brands VALUES("17","1",NULL,"12","Honda","","");
INSERT INTO brands VALUES("18","1",NULL,"12","Alfa Romeo","","");
# as much as you want!!!
#
---
Hope someone make use of it!
I tried it with a SQL file with 32554 lines long!
//elias
"Lallous" <elias_bachaalanyyahoo.com> wrote in message
news:20010814090205.32064.qmailpb1.pair.com...
> Actually the mysql_query() seems to accept only one statement at a time.
>
> Any work around so i can do query suchs:
>
> mysql_query("
> SELECT 1+1;
> SHOW DATABASES;
> USE database1;
> SELECT * FROM table1;
> ");
>
> Just multiple commands seperated with ';' ? (as if using the Mysql command
> prompt)
>
>

attached mail follows:

Basically I have PHPMyAdmin... If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more than 30secs to execute it which will make everything fail! Anyway, I solved it. Check the recent post in the same thread about SQL2PHP script.

"Alnisa Allgood" <allgood2slip.net> wrote in message news:p05100305b79ec2415b87[63.202.15.82]... > At 2:21 PM +0200 8/14/01, lallous wrote: > >I can't execute MySql via system() I have no rights! > > > > Generally ISPs either give you shell rights or access to PHPMyAdmin, > if they give access to a MySQL database. Otherwise, you'd never be > able to add tables, or modify data. If PHPMyAdmin is installed, you > can general locate it in the following manner: your_url/phpmyadmin > > So http://www.my_crazy_domain.com/phpmyadmin > > You'll need to enter your database username and password, but this > will allow you to upload INSERT statements, perform routine MySQL > tasks, as well as run SQL queries. > > Otherwise you need to request shell access from your ISP. Some ISPs > only provide it when asked. > > Alnisa > -- > ......................................... > Alnisa Allgood > Executive Director > Nonprofit Tech > (ph) 415.337.7412 (fx) 415.337.7927 > (url) http://www.nonprofit-techworld.org > (url) http://www.nonprofit-tech.org > (url) http://www.tech-library.org > ......................................... > Nonprofit Tech E-Update > mailto:nonprofit-tech-subscribeegroups.com > ......................................... > applying technology to transform > .........................................

attached mail follows:

At 4:05 PM +0200 8/14/01, _lallous wrote: >Basically I have PHPMyAdmin... >If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more >than 30secs to execute it which will make everything fail! >Anyway, I solved it. Check the recent post in the same thread about SQL2PHP >script. >

You don't have to past, you just upload the file, as a SQL query, and select go. If the file still fails, just break it in two. fileinsert1.sql, fileinsert2.sql, I've seen people insert over 60,000 records this way no errors. I've personally never worked with more than 10,000 records at a time, but if time outs are the issue, then just break the file into smaller files.

Alnisa

-- ......................................... Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org ......................................... Nonprofit Tech E-Update mailto:nonprofit-tech-subscribe

egroups.com ......................................... applying technology to transform .........................................

attached mail follows:

I have PHPMyAdmin 2.21 I only see "GO" button, where can I upload my SQL file?

"Alnisa Allgood" <allgood2slip.net> wrote in message news:p05100309b79edae8263f[63.202.15.82]... > At 4:05 PM +0200 8/14/01, _lallous wrote: > >Basically I have PHPMyAdmin... > >If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more > >than 30secs to execute it which will make everything fail! > >Anyway, I solved it. Check the recent post in the same thread about SQL2PHP > >script. > > > > You don't have to past, you just upload the file, as a SQL query, and > select go. If the file still fails, just break it in two. > fileinsert1.sql, fileinsert2.sql, I've seen people insert over > 60,000 records this way no errors. I've personally never worked with > more than 10,000 records at a time, but if time outs are the issue, > then just break the file into smaller files. > > Alnisa > -- > ......................................... > Alnisa Allgood > Executive Director > Nonprofit Tech > (ph) 415.337.7412 (fx) 415.337.7927 > (url) http://www.nonprofit-techworld.org > (url) http://www.nonprofit-tech.org > (url) http://www.tech-library.org > ......................................... > Nonprofit Tech E-Update > mailto:nonprofit-tech-subscribeegroups.com > ......................................... > applying technology to transform > .........................................

attached mail follows:

At 5:25 PM +0200 8/14/01, _lallous wrote: >I have PHPMyAdmin 2.21 >I only see "GO" button, where can I upload my SQL file? >

Well my ISP uses PHPMyAdmin 2.10, which I can't imagine would be that different from 2.21. Basically, if I load, and click on the database name in the left top corner:

Home + databasename

To the right, the window display will list all my databases, action options and number of records. Under that area is a text box where I can enter SELECT statements, or upload queries as text files. The screen generally looks like:

PHPMyAdmin Window (Right Pane Only)

table Action Records ......................................................................................................... tb1 Browse Select Insert Properties Drop Empty 150 tb2 Browse Select Insert Properties Drop Empty 2456

......................................................................................................... Run SQL query/queries on database"databasename" [Documentation]:

................................................. : : : : : text box : : : ................................................. or Location of the textfile: ..................................... : file upload : Browse ..................................... Go .......................................................................................................

The Go button will perform either information from the text box, or an indicated file.

I believe it's a typical install of PHPMyAdmin, but I could be wrong.

Alnisa

egroups.com ......................................... applying technology to transform .........................................

attached mail follows:

I can do this on my local server but I can't do it on provider's server, can I do anything else?

Youri On 14 Aug 2001, at 12:03, Ben-Nes Michael wrote:

> As I recall MySQL is not case sensitive > > did you use --with-charset=koi8_ru ( or what ever) when you did ./configure > ? > > snip form INSTALL-SOURCE file of mysql-3.23.40 > > * By default, *MySQL* uses the ISO-8859-1 (Latin1) character set. To > change the default set, use the `--with-charset' option: > shell> ./configure --with-charset=CHARSET > `CHARSET' may be one of `big5', `cp1251', `cp1257', `czech', > `danish', `dec8', `dos', `euc_kr', `gb2312', `gbk', `german1', > `hebrew', `hp8', `hungarian', `koi8_ru', `koi8_ukr', `latin1', > `latin2', `sjis', `swe7', `tis620', `ujis', `usa7', or > `win1251ukr'. *Note Character sets::. > > -------------------------- > Canaan Surfing Ltd. > Internet Service Providers > Ben-Nes Michael - Manager > Tel: 972-4-6991122 > http://sites.canaan.co.il > -------------------------- > > ----- Original Message ----- > From: "BRACK" <braknettaxi.com> > To: <php-generallists.php.net> > Sent: Tuesday, August 14, 2001 11:28 AM > Subject: [PHP] qwestion about %E6%E2%E0%F7%EA%E0 > > > > Hi > > > > I'm doing the script for searching the mySQL db in Russian > > language. but output of textform > > http://localhost/indexr.php3?search_idea=%E6%E2%E0%F7%EA > > %E0 is not the same as > > http://localhost/indexr.php3?search_idea=%C6%C2%C0%D7%CA > > %C0 (this is the same word but first is lower case and second is > > upper case) so search becomes case sencitive, I don't want to > > have case sencitive search so, how can I tell to program that both > > of above are the same word? > > > > Thank you for help, > > > > Youri > > > >

attached mail follows:

thanx to everyone I solved the problem by updating my php and inserting upper() in queries. Now I can insert whatever case in search field and get case insensitive result.

Youri

attached mail follows:

Hi,

For security use SSL and get the SSLSession ID instead. This cannot be fooled since it is based in PK handshake and with simetric encryption.

Sean C. McCarthy SCI, S.L. (www.sci-spain.com)

Christian Dechery wrote: > > I have pages that uses session for security that looks something like this: > > <?php > session_start(); > > if( !isset($uid) ) > { > include("include/auth.inc.php"); > auth_user(); > } > > more code... > ?> > > so $uid tells me if the user is logged on or not... > > but what if somebody calls the script directly from the address bar like > this: http://server/script.php?uid=10 > > wouldn't this be a security problem? > ____________________________ > . Christian Dechery (lemming) > . http://www.tanamesa.com.br > . Gaita-L Owner / Web Developer > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

what about registering a var called loggedin with the session and then testing on each script to see if it's set to 1 or something ?

then base the access on that ? that's what i use and then register uid with the session as well so you can use it througout your site ...

ok you've got me worried now, are there any problems with security doing it that way ????

Steve

"Christian Dechery" <cdecherybrfree.com.br> wrote in message news:5.0.0.25.2.20010814084143.027c69e0pop.brfree.com.br... > I have pages that uses session for security that looks something like this: > > <?php > session_start(); > > if( !isset($uid) ) > { > include("include/auth.inc.php"); > auth_user(); > } > > more code... > ?> > > so $uid tells me if the user is logged on or not... > > but what if somebody calls the script directly from the address bar like > this: http://server/script.php?uid=10 > > wouldn't this be a security problem? > ____________________________ > Christian Dechery (lemming) > http://www.tanamesa.com.br > Gaita-L Owner / Web Developer >

attached mail follows:

Sean,

That is a very interesting suggestion. How would you call that using PHP?

Thanks,

David Price

-----Original Message----- From: smccarthymercurio.ulpgc.es [mailto:smccarthymercurio.ulpgc.es]On Behalf Of Sean C. McCarthy Sent: Tuesday, August 14, 2001 6:12 AM To: Christian Dechery Cc: php-generallists.php.net Subject: Re: [PHP] session security issue

Hi,

For security use SSL and get the SSLSession ID instead. This cannot be fooled since it is based in PK handshake and with simetric encryption.

Sean C. McCarthy SCI, S.L. (www.sci-spain.com)

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

thanks everybody helping to clear my mind with "sessions" affair.

many people asking about this so two possible problems: coders don't read manuals carefully or the info there is not so clear.

[ trying to help a little bit newbies like me, as soon as I finish this "navigation access for logged users" work I'll post the php files ]

aniceto lopez http://www.lamundial.net visit us, download and spread our music

attached mail follows:

I am running sites that use both PHP4 and ASP.

Both types of sites are running on IIS4.

I've just recently started using the php_gd.dll to resize images in PHP. It appears to run fine, until the gd library generates any sort of error.

As soon as that happens, all ASP pages on the entire server become inaccessible. HTML and PHP pages are still fine, as is everything else, but ASP just hangs. The only fix I've found is a complete reboot of the system.

Needless to say, I am finding this incredibly frustrating. Has anyone seen similar behavior to this before, and does anyone have a solution.

Thanks.

Michael Hall Lead Web Developer / Database Engineer Prairie Fire Internet Technologies mikepfbiz.com

attached mail follows:

Usually when PHP brings other IIS services down it is because you are running the ISAPI module version of PHP rather than the CGI. If this is the case, you need to switch to using php.exe.

Cheers

-- Phil Driscoll

attached mail follows:

Try and find MYSQLFront - (Sorry I forgot where i downloaded it). I find it the best way to load sql files and data.

<legalHEROCYCLES.COM> wrote in message news:OF0DBB50F2.83686F02-ON65256AA8.0043300Adomain...

Hi,

In MS SQL server, table data can be uploaded on webserver by using the Enterprise Manager by using the export option.

Is there any feature in Mysql to upload the data on webserver? I understand that it can be done with the help of SQL script file. This is the only way or some another way also is there? Also, Pl. let me know: 1. How to create SQL script file, with what extension it is to be saved? The format? 2. How to call/execute/run that file using php?

Can anyone send me sample SQL script file?

Thanks in advance??..

Ajay K. Ratra Ludhiana (INDIA) ajayLudhianaInfoline.com

attached mail follows:

Help me. I have RED HAT Linux 7.0 and I want install Apache web server with php and mysql support. How ?

I have : apache_1.3.20.tar.gz php-4.0.6.tar.gz mysql-3.23.38.tar.gz

thanx

roman

attached mail follows:

check de readme or install files provided in each one !

At 15:39 14/08/01 +0200, Roman wrote: >Help me. I have RED HAT Linux 7.0 and I want install Apache web server with >php and mysql support. How ? > >I have : apache_1.3.20.tar.gz > php-4.0.6.tar.gz > mysql-3.23.38.tar.gz > >thanx > > > roman > > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

---------------------------------------------------------------- EuroVox 4, place Félix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax : 01 44 67 05 19 Web : http://www.eurovox.fr ----------------------------------------------------------------

attached mail follows:

Hi Roman, I think that the follow page can help you: http:// jips.kipelhouse.com/linux/apache/ssl/

Try .

On Tue, 14 Aug 2001, Roman wrote:

> Help me. I have RED HAT Linux 7.0 and I want install Apache web server with > php and mysql support. How ? > > I have : apache_1.3.20.tar.gz > php-4.0.6.tar.gz > mysql-3.23.38.tar.gz > > thanx > > > roman > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

i think pgp has a quick install text file that is superb. sorta step-by-step simple and complicated.

Steve "Jean-Arthur Silve" <jeanarthureurovox.fr> wrote in message news:5.1.0.14.0.20010814154930.03e84210mail.eurovox.fr... check de readme or install files provided in each one !

attached mail follows:

On Tue, 14 Aug 2001 12:06:01 +0200 impersonator of newsn-crypt.dk (Soeren Nielsen) planted &I saw in php.general: > >"Ben-Nes Michael" <admincanaan.co.il> wrote in message >news:022201c12498$79178ce0$aa5796d4canaan.co.il... >> The problem still stays if you open php to system commands like `echo >> /etc/passwd` or using system() .... > >A problem is also that other web-programers can read your source code >through PHP. >An example from my page is this: >My homepage is here: /hotel/<my domain>/WWW > >I can make a php-script that opens /hotels/<some other domain>/WWW , >list the files, view them, steal code from others etc etc. > >Hope what I wrote gave some sort of meaning :-) > Well. Skliar's example do confirm once again, that programmers _can_ do illegal things, like breaking copyrihgt, stealing the code etc. But is is responsibilities of the servers administrators to configure the system in such a way - even if it has multiply users (which is the case for most) - so to not allow such (and alike) sample opening occur outside of web-server structure. And only owner/user of the site has a passworded FTP and other access to his data outside of web-server.

Of course passwords could be compromised, but this is an another matter. All in all - I strongly believe - that server stuff is carriing full responsibility for the above matter. And only the should have root access.

PS: There are servers, to my surprise, (i rent one:() that set write group attribute for files on download by default, and then refuse executing them on this basis, so you have to re-set attribute manually. But this alone still doesn't allow others to read .php as source (these files can only be overwritten)

>/Søren > > Just my legal 2c i leonid.

attached mail follows:

Hello!

I am VERY new to php and i have a question (maybe it's pretty simple, but i couldn't get it work):

I have a form page where i start a session. I cannot use php auth because the server does not run php as a module. Supposing the client has cookies disabled, please tell me how to propagate my session variables from the form page to another (i found that &SID can be used in url to preserve session id) but when i get to the other page (with header("Location: http://theserver/result.php?SID=$SID"), nothing is there but the SID variable. As you could probably figured out, i cannot allow to see the information entered in the form listed in url.

So, please help me!

thanks, Maxx maxxmail.dntis.ro

attached mail follows:

Here is the problem:

I'm retrieving a page of data from another process using PHP4 on Solaris 2.51 This data is placed in an array by line and simply returned to the browser after formatting.

A sample line may look something like this: blah blah blah blah blah <Link> blah blah blah blah <Link>

I think I need to use eregi_replace to make the line look like this: blah blah blah blah blah <a href='#'><Link></a> blah blah blah blah <a href='#'><Link></a>

when it is returned to the browser.

Thanks in advance Ross

attached mail follows:

I think, when they register or log in the first time, ask to the user if they want you to remember them by placing a cookie..

Don't do it automaticaly ! Most people doesn't like that, and if they are not on their computer (web bar, or at the office...), they could not like this...

At 11:43 14/08/01 +0100, sunny AT wde wrote: >Hi all! > >I'm trying to build a registration system for a community site that >I'm building, and was wondering if people could give me advice or >tell me about problems they've been having?? > >I'm planning to let people register with a username and password >(encrypted), and then make them login with that, and thus putting a >cookie on their machine. > >If the cookie is detected the next time, they don't have to login, >but if it is, then they do. > >Sounds pretty simple?? > >Any advice? > >TIA! > >sunny > >____________________________________________________________ >Do You Yahoo!? >Get your free yahoo.co.uk address at http://mail.yahoo.co.uk >or your free yahoo.ie address at http://mail.yahoo.ie > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Use arsort(), and while you're in the manual ( http://www.php.net/manual/en/ref.array.php <http://www.php.net/manual/en/ref.array.php> ) familiarise yourself with all the other sort functions (and array functions in general). There's some useful stuff there that you might not expect, and therefore not look for.

Tim Ward Senior Systems Engineer

Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html

---------- From: Ben Rigby [SMTP:benakimbodesign.com] Sent: 13 August 2001 20:21 To: php-generallists.php.net Subject: problems sorting an associative array...

hi. any help would be mych appreciated! i'm trying to sort an associative array, but when i do, the key is converted into a number (it should be a string). ie:

$email_array["testemail.com"]=1; $email_array["test2email.com"]=4; $email_array["test3email.com"]=10; rsort ($email_array);

i'm trying to sort by the value and then echo out the key and value together, but when i do, the key is always a number, rather than the email address that i wanted. any ideas??

thanks, ben

attached mail follows:

I am having a problem starting Interbase 6.0 on RH 7.1. Anyone using Interbase on Red hat 7.1?

Todd

-- Todd Cary Ariste Software todd

aristesoftware.com

attached mail follows:

Hello

I'm trying to do the following: allow a user to upload a file to a directory, and also allow them to delete that very file again. The uploading part works using http post, the file is saved with as UID the UID of www/www (on this particular ISP). Now, when I try to delete the filem I get a warning like this:

Warning: SAFE MODE Restriction in effect. The script whose uid is 97613 is not allowed to access ../images/2/file.jpg owned by uid 1001 in <script> on line 5

What am I to do to make this work? I've considered using chown, but that's restricted to the SU...

Anyone got a clue?

Thanks,

Jan

attached mail follows:

Hi,

I'm having a problem with my Select statement. This is what i'm doing:

$connection = mysql_connect("l", "c", "c") or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql =" SELECT * FROM table_1 ";

$result = mysql_query($sql,$connection) or die("Couldn't execute query.");

$data=mysql_fetch_row($result); $count=$data[0];

echo $count;

Yet the only result I get is the first value of the first column.............

attached mail follows:

thats because mysql_fetch_row only returns one row.

to get all the rows do

while ($row = mysql_fetch_array($result) {

//processing code here

}

This will run through all the rows putting the colums into the array $row[]

Regards

Jon

--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07968 524175 
PGP Key available, send blank email to pgpkeybctech.co.uk
-----Original Message-----
From: Jeremy Morano [mailto:jeremyprepresshelp.com]
Sent: 14 August 2001 15:53
To: php-generallists.php.net
Subject: [PHP] Select
Hi,
I'm having a problem with my Select statement. This is what i'm doing:
$connection = mysql_connect("l", "c", "c") or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection) or die("Couldn't select
database.");
$sql =" SELECT *
	FROM table_1
	";
$result = mysql_query($sql,$connection) or die("Couldn't execute query.");
$data=mysql_fetch_row($result);
$count=$data[0];
echo   $count;
Yet the only result I get is the first value of the first
column.............
-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribelists.php.net
For additional commands, e-mail: php-general-helplists.php.net
To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Jeremy Morano wrote: > > ... > > $data=mysql_fetch_row($result); > $count=$data[0]; > > echo $count; > > Yet the only result I get is the first value of the first > column............. >

Of course, and $data[1] is the first value of second column, etc. If you want to get all result, use while-loop like this:

<? while ($data=mysql_fetch_row($result)) { ... // do here something with $data array ... } ?>

-- Pavel a.k.a. Papi

attached mail follows:

oops slight mistake i noticed there..

should be

thats because mysql_fetch_row only returns one row.

to get all the rows do

while ($row = mysql_fetch_array($result)) {

$firstcloumn = $row[0];

}

This will run through all the rows putting the colunms into the array $row[]

Regards

Jon

--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07968 524175
PGP Key available, send blank email to pgpkeybctech.co.uk
-----Original Message-----
From: Jeremy Morano [mailto:jeremyprepresshelp.com]
Sent: 14 August 2001 15:53
To: php-generallists.php.net
Subject: [PHP] Select
Hi,
I'm having a problem with my Select statement. This is what i'm doing:
$connection = mysql_connect("l", "c", "c") or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection) or die("Couldn't select
database.");
$sql =" SELECT *
	FROM table_1
	";
$result = mysql_query($sql,$connection) or die("Couldn't execute query.");
$data=mysql_fetch_row($result);
$count=$data[0];
echo   $count;
Yet the only result I get is the first value of the first
column.............
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribelists.php.net
For additional commands, e-mail: php-general-helplists.php.net
To contact the list administrators, e-mail: php-list-adminlists.php.net
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribelists.php.net
For additional commands, e-mail: php-general-helplists.php.net
To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Jeremy, The reason you are only getting the first value is because you are only retrieving the first value and assigning it to $data. You need to step through the result and do something with it. For example,

if ($row = mysql_fetch_array($result)) { do { $data1 = $row["mycolumn1"]; $data2 = $row["mycolumn2"]; } while ($row = mysql_fetch_array($result)); // more code }

Alternatively, you could insert the values into a multidimensional array inside the loop, so you don't have to hardcode the columns. It's up to you.

Johan Alfredeen pongworld.com

-----Original Message----- From: Jeremy Morano [mailto:jeremyprepresshelp.com] Sent: Tuesday, August 14, 2001 8:53 AM To: php-generallists.php.net Subject: [PHP] Select

Hi,

I'm having a problem with my Select statement. This is what i'm doing:

$connection = mysql_connect("l", "c", "c") or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql =" SELECT * FROM table_1 ";

$result = mysql_query($sql,$connection) or die("Couldn't execute query.");

$data=mysql_fetch_row($result); $count=$data[0];

echo $count;

Yet the only result I get is the first value of the first column.............

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

The navigation system you are refering to is called breadcrumb navigation. You can find implementations of this all over the place. Try hotscripts.com or google.com.

Kevin

-----Original Message----- From: Wolfgang Schneider [mailto:schneiderbibelcenter.de] Sent: Tuesday, August 14, 2001 12:35 AM To: php-general Subject: [PHP] "location bar"

Hi everyone,

I am somewhat new at the use of php and would appreciate if someone could help me with a question re "location bar"

How can a location bar such as the sample below be generated in php to be displayed in web pages ...

Location : home:/category:sub_1:/page title

Is there a specific setup needed in terms of the directory structure on the server? Or will this only function with database type website?

Thanks in advance for any input and helpful ideas ... God bless you with His grace and peace Wolfgang

Looking for Biblical information? COME AND SEE! -- ONLINE Courses: http://classes.bibelcenter.de ... NEW! -- BibelCenter: http://www.bibelcenter.de -- Bookstore: http://www.worthy.net/BibelCenter/

attached mail follows:

At 11:02 AM 8/14/2001, Kevin L wrote:

I had a similar problem.....jason murray gave me some ideas ;-)

just stick this in a function as I did and you'll be sailing.....its easy to update, and Extremely flexible.

look at my code..

<font face="Verdana, Arial, Helvetica, sans-serif" size="-2">Location : <a href="http://www.usaexpress.net">Home</a> / <?php

$patharray = explode ("/",$SCRIPT_NAME);

$scriptname = basename($SCRIPT_NAME);

for ($dirsi = 1; $dirsi < count($patharray); $dirsi++){

$dirs = array( 'company' => 'Company', 'services' => 'Services', 'support' => 'Support', 'mac' => 'Mac', 'winnt' => 'Windows NT', 'win9x' => 'Windows 9X', 'unix' => 'Linux And Unix', 'customers' => 'Customers', 'noc' => 'NOC', 'help' => 'USAexpress.net Help' );

$linkdes = $dirs[$patharray[$dirsi]];

$link = $link . "/$patharray[$dirsi]";

if ($patharray[$dirsi] == $scriptname){ $linkdes = $title; $slash = ""; $linkhtml = "<a href=\"$link\">$linkdes</a>$slash"; if ($patharray[$dirsi] == "index.php"){ $link = ""; $linkdes = ""; $slash = ""; $linkhtml = ""; } }else{ $slash = " / "; $linkhtml = "<a href=\"$link\">$linkdes</a>$slash"; } echo $linkhtml; }

?></font>

you can see it in action at www.usaexpress.net. look at the "location" below our logo.

~kurth

>The navigation system you are refering to is called breadcrumb navigation. >You can find implementations of this all over the place. Try hotscripts.com >or google.com. > >Kevin > >-----Original Message----- >From: Wolfgang Schneider [mailto:schneiderbibelcenter.de] >Sent: Tuesday, August 14, 2001 12:35 AM >To: php-general >Subject: [PHP] "location bar" > > >Hi everyone, > >I am somewhat new at the use of php and would appreciate if someone >could help me with a question re "location bar" > >How can a location bar such as the sample below be generated in php to >be displayed in web pages ... > > Location : home:/category:sub_1:/page title > >Is there a specific setup needed in terms of the directory structure on >the server? Or will this only function with database type website? > >Thanks in advance for any input and helpful ideas ... >God bless you with His grace and peace >Wolfgang > >Looking for Biblical information? COME AND SEE! >-- ONLINE Courses: http://classes.bibelcenter.de ... NEW! >-- BibelCenter: http://www.bibelcenter.de >-- Bookstore: http://www.worthy.net/BibelCenter/ > > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

"Jack" <jackyactivelifestyle.com> wrote in message news:021501c12508$abb1b200$6400a8c0activelifestyle.com... > Hi people > I have tried to include php file into html page > using the syntax below and it said syntax error > at this part when the page is loaded. What is > wrong with calling php file this way? Or is there > any other way to call php file from html page? > > ******************* > <html> > <body> > <script language='JavaScript' src='/include/adjs.php></script> > </body> > </html> > *******************

This will run the php script, then try to interpret the result as JavaScript... which is exciting, but probably not what you had in mind.

Why not try the plain old boring method,

attached mail follows:

ok a basic question. perhaps I dont know enough about javascript but anyway..

I want to call a php script from javascript. Anybody have any hints for me? A link to a useful website would work as well. thanks mates

-student of computer science

attached mail follows:

On Tue, Aug 14, 2001 at 10:18:18AM -0500, marilyn manson wrote: > ok a basic question. perhaps I dont know enough about javascript but > anyway.. > > I want to call a php script from javascript. Anybody have any hints for me? > A link to a useful website would work as well. thanks mates > > -student of computer science

FAIK the only possibility is to redirect to the PHP script. Then you'll get something like:

window.location.href="myscript.php";

* R&zE:

-- »»»»»»»»»»»»»»»»»»»»»»»» -- Renze Munnik -- DataLink BV -- -- E: renzedatalink.nl -- W: +31 23 5326162 -- F: +31 23 5322144 -- M: +31 6 21811143 -- H: +31 23 5516190 -- -- Stationsplein 82 -- 2011 LM HAARLEM -- -- http://www.datalink.nl -- ««««««««««««««««««««««««

attached mail follows:

"Marilyn Manson" <mattwireswt.edu> wrote in message news:20010814151502.31560.qmailpb1.pair.com... > ok a basic question. perhaps I dont know enough about javascript but > anyway.. > > I want to call a php script from javascript. > Anybody have any hints for me?

Well, to call a php script, you basically have to request a new file.

If you just need to submit information, you can preload a new 'image' with parameters.

If you need to get information back, you pretty much have to devote a frame to it somewhere - either a visible frame, where the script actually returns an updated page, or an invisible frame (ie one pixel high with a 10-pixel top margin) in the same window, or a new minimized window.

attached mail follows:

I'm looking for a yahoo-style link system done in PHP.

Anyone know if a good one exists out there and where I can find it?

Thomas Deliduka IT Manager ------------------------- New Eve Media The Solution To Your Internet Angst http://www.neweve.com/

attached mail follows:

Search http://sourceforge.net/ and

http://freshmeat.net/

Good luck,

Johan Alfredeen PongWorld.com

-----Original Message----- From: Thomas Deliduka [mailto:thomasneweve.com] Sent: Tuesday, August 14, 2001 9:20 AM To: PHP List Subject: [PHP] Looking for link system

I'm looking for a yahoo-style link system done in PHP.

Anyone know if a good one exists out there and where I can find it?

Thomas Deliduka IT Manager ------------------------- New Eve Media The Solution To Your Internet Angst http://www.neweve.com/

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribelists.php.net For additional commands, e-mail: php-general-helplists.php.net To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

PHPers:

So if I was just going to need includes on a few pages, what's faster PHP or SSI on Linux/Apache?

Christopher Raymond

attached mail follows:

> http://www.yorkshire-search.co.uk/links/add.php3

Right, I seem to have not made myself too clear so I'll try again.

Originally, the page "add.php3" was using a plain HTML template called "add_form.html" which consisted of a simple form. If you click on the link above and have a look at the page, everything below Add Link was how it started off. In the code below, it's everything after the </php> tag. Users would just complete the form and press submit.

However, I decided instead of typing in certain fields, I wanted to autofill the boxes so I found a PHP4 script which would grab meta-tags and embedded it into the template. All PHP scripts have to be within <php></php> tags as defined in a different part of the search engine script.

My problem is that whatever method I have tried, I have not managed autofil the forms text boxes with values from the script in a one step process.

I first tried putting the HTML form in the script but this brought parsing errors. Next I tried keeping the form in the HTML but trying to use value=<?....?> statement. This again brought parsing errors or the code simply appeared in the box.

Hope that makes a bit more sense.

<php> // Include the function so you can use it later in the page require('metaengine.php');

// Call the MetaEngine function and assign the return value to an array $metaInfo = MetaEngine($url);

// Array index is not numbers but names, such as: // $metaInfo[title] is the title of the page // $metaInfo[description] is the description of the page // $metaInfo[keywords] is the keywords of the page

echo "

<html> <head> <title>Sample</title> </head> <body> <form method=\"POST\" action=\"$PHP_SELF\"> <CENTER><font face=\"Arial\" size=\"2\"><b>Enter URL:</b></font> <input type=\"text\" name=\"url\" size=\"25\">  <input type=\"submit\" value=\"Submit\" name=\"B1\"></CENTER><br><font face=\"Arial\" size=\"2\"><b>1. Press the submit button and it will grab meta tags of website.</b></font><br><hr>

</form>

<table border=\"0\" cellspacing=\"0\" cellpadding=\"4\" width=\"100%\"> <tr> <td><center><input type=submit name=submit value=\"Now press this button\" class=\"button\"></center><br><font face=\"Arial\" size=\"2\"><b>2. If complete URL displays in box below, press the above button.</b></font><br><hr></td> </tr> </table>

</FORM>

</body> </html>

</php>

<table border="0" cellspacing="0" cellpadding="4" width="100%"> <tr> <td><font face="Arial" size="2">Url</font></td> <td><input type="text" name="title" size=20 value="<?=$title?>"> </td> </tr> <tr> <td><font face="Arial" size="2">Title</font></td> <td><input type=text name=title size=40 value="<%title%>"></td> </tr> <tr> <td valign="top"><font face="Arial" size="2">Description</font></td> <td><textarea name="description" cols="40" rows="10" maxlength="255" wrap="virtual"><%description%></textarea></td> </tr> <tr> <td><font face="Arial" size="2">Category</font></td> <td><font face="Arial" size="2"><%category%></font></td> </tr> <tr> <td><font face="Arial" size="2">Contact Name</font></td> <td><input type=text name=contact_name size=30 value="<%contact_name%>"></td> </tr> <tr> <td><font face="Arial" size="2">Email</font></td> <td><input type=text name=email size=30 value="<%email%>"></td> </tr> <tr> <td><font face="Arial" size="2">Bid</font></td> <td><input type=text name=bid size=10 value="<%bid%>"> <font face="Arial" size="2" color="green">(optional)</font> </td> </tr>

<tr> <td> </td> <td><input type=submit name=submit value="Add" class="button"><br>Once you are happy with your entries, press this button.</td> </tr> </table> </form>

</td> </tr> </table>

attached mail follows:

Hi, I need some help in compiling SNMP functions with PHP 4.06 on Solaris 2.6. What I did so far I downloaded UCD SNMP package and installed it. I compiled php with '--with-snmp=shared' + '--enable-ucd-snmp-hack' and installed everything without any errors. When I do a phpconfig on that installation I can see this configure option. Everything textbook. BUT when I try to use any of the snmp function calls I get an error message saying this is an undefined function. Any ideas, please!! Thanks Heiko

attached mail follows:

I had the same problem and never got it working on Linux. Posted a very similar question and got one response from someone that got it working on FreeBSD but that was it.

Sincerely,

Robert T. Covell President / Owner Rolet Internet Services, LLC Web: www.rolet.com Email: rcovellrolet.com Phone: 816.210.7145 Fax: 816.753.1952

-----Original Message----- From: hmaiwaldhns.com [mailto:hmaiwaldhns.com] Sent: Tuesday, August 14, 2001 10:45 AM To: php-generallists.php.net Subject: [PHP] SNMP and PHP

Hi,

I need some help in compiling SNMP functions with PHP 4.06 on Solaris 2.6. What I did so far I downloaded UCD SNMP package and installed it. I compiled php with '--with-snmp=shared' + '--enable-ucd-snmp-hack' and installed everything without any errors. When I do a phpconfig on that installation I can see this configure option. Everything textbook. BUT when I try to use any of the snmp function calls I get an error message saying this is an undefined function.

Any ideas, please!!

Thanks Heiko

attached mail follows:

I have some existing code that I want to modify to limit the display results to 5 rows and add nav buttons to display the next set of 5, etc. You all know what I am looking for. I have a book- MySQL/PHP Database Applications by Greenspan & Bulger - which has an example that should work, but isn't. I have inserted the function from the book and can get 5 rows on the first page, and the next button, but the second page doesn't display any rows. Pasted below is the code for my page, the function in question is down aways. I am just learning this stuff, so don't be too hard on me about the existin code, it works fine with- out the nav function. I am sure there are probably more efficient ways to write this, but for now I just want to get the nav function to work properly. (some lines will undoubtedly wrap and make it all look real ugly) ----------------------------------------------------------------- <? $conn = mysql_connect("localhost","root") or die ("could not connect to the server"); mysql_select_db("bulletins", $conn) or die ("could not get the database");

function authenticate ($realm="Secure Area",$errmsg="Please enter a usename and password") { header("WWW-Authenticate: Basic realm=\"$realm\""); header("HTTP/1.0 401 Unauthorized"); die($errmsg); }

if (empty($PHP_AUTH_USER)) { authenticate($realm,$errmsg,"header"); } else { $query = "select name from users where password = ('$PHP_AUTH_PW') and name = ('$PHP_AUTH_USER')"; $result = mysql_query($query); if ($result) { list($valid_user) = mysql_fetch_row($result); } if (!$result || empty($valid_user)) { authenticate($realm,$errmsg,"query"); } }

?> <html> <head> <meta name="generator" content="HTML Tidy, see www.w3.org" /> <title>Dealer Bulletins, Simrad, Inc</title> <style type="text/css"> body { background-color: #b5e4f9; } </style> </head>

<body> <center><h1>Simrad Dealer Bulletins</h1></center> <br />

<p>You can sort the bulletins in the following order:<br /> <font size="-1">(This will display all bulletins in one long page.)<br /> OR click on the bulletin subject line below (much quicker)</font> </p>

<ul> <li> <a href="bulletin_sorter.php?orderby=date">Bulletin Date</a> (oldest to newest) </li>

<li> <a href="bulletin_sorter.php?orderby=date2">Bulletin Date</a> (newest to oldest) </li>

<li> Select bulletins from <a href="bulletin_sorter.php?orderby=vlad">Brian Vlad</a> - Plotter and Radar Products </li>

<li> Select bulletins from <a href="bulletin_sorter.php?orderby=burke">Tom Burke</a> - Autopilots and Instrumentation </li>

<li> Select bulletins from <a href="bulletin_sorter.php?orderby=hillers">Mike Hillers</a> - Fisheries </li> </ul> <br /> OR <br /> <form name="form1" action="bulletin_sorter.php" method="post"> Enter a word to search for: <input type="text" size="30" name="search"><br /> <input type="submit" name="submit" value="Search"> <font size="-1">(You must press the search button to complete the search)</font> </form> <br /> <? $result1 = mysql_query("select count(*) from dbulletins") or die(mysql_error()); echo "There are " .mysql_result($result1,0,0). " Bulletins listed in the database"; ?> <br /><br /> <hr width="75%" noshade="noshade" />

<table summary="" border="0" cellpadding="5" align="center" width="90%"> <? $db = mysql_connect("localhost", "root"); mysql_select_db("bulletins", $db);

if ($orderby == 'date'): $sql = "select * from dbulletins order by 'bulletin_date'"; elseif ($orderby == 'date2'): $sql = "select * from dbulletins order by 'bulletin_date' desc"; elseif ($orderby == 'vlad'): $sql = "select * from dbulletins where bulletin_from1 like '%Vlad%' order by 'bulletin_number' desc"; elseif ($orderby == 'burke'): $sql = "select * from dbulletins where bulletin_from1 like '%Burke%' order by 'bulletin_number' desc"; elseif ($orderby == 'hillers'): $sql = "select * from dbulletins where bulletin_from1 like '%Hillers%' order by 'bulletin_number' desc"; elseif (isset($submit)): $sql = "select * from dbulletins where match (body) against ('%$search%')"; else: $sql = "select * from dbulletins order by 'bulletin_date' desc"; endif;

$result2 = mysql_query($sql);

while ( $row = mysql_fetch_array($result2)) { if ($orderby == 'vlad' || $orderby == 'burke' || $orderby == 'hillers' || $orderby =='date' || $orderby == 'date2' || $search == 'orderby'): { print("<tr>\n<td colspan=\"2\">\n<img src=\"1pixb5e4f9.gif\" alt=\"\" height=\"20\" width=\"1\">\n</td>\n</tr>"); print("<tr>\n<td bgcolor=\"white\" colspan=\"2\">\n<strong>\n"); printf("<font color=\"blue\">%s</font>\n</strong>\n</td>\n</tr>\n", $row["bulletin_number"]); print("<tr>\n<td valign=\"top\">\n<h2 class=\"c1\">\n<br />Dealer Bulletin</h2>"); printf("<strong>Date:</strong> %s\n", $row["bulletin_date"]); printf("<br />\n<strong>Number:</strong> %s\n", $row["bulletin_number"]); printf("<br />\n<strong>Subject:</strong> %s\n", $row["bulletin_subject"]); printf("<br />\n<strong>From:</strong> %s<br />%s\n", $row["bulletin_from1"], $row["bulletin_from2"]); print("</td>\n<td valign=\"top\" align=\"left\">\n"); print("<font face=\"Arial Black\" size=\"+6\">SIMRAD</font>\n"); print("<br />\n<font size=\"3\">   A <strong>KONGSBERG</strong> Company</font>\n</center>\n"); print("<br />Simrad Inc.\n"); print("<br />19210-33<sup>rd</sup> Avenue West, Suite A\n"); print("<br />Lynnwood, WA 98036\n"); print("<br />U.S.A.\n"); print("<br />Telephone: 1-425-778-8821\n"); print("<br />Telefax: 1-425-771-7211\n"); print("<br />\n<br />\n</td>\n</tr>"); printf("<tr>\n<td colspan=2>%s\n", $row["body"]); print("<br />\n<hr width=\"75%\" />\n"); } else: printf("<tr><td>* <a href='bulletin_out.php?news_id=$row[news_id]'>%s</a>   %s<br />   %s</td></tr>", $row ["bulletin_subject"], $row["bulletin_date"], $row["bulletin_from1"]); endif; } function nav($offset=0,$this_script="bulletin_sorter.php") { global $php_self; $page_limit = 5; if (empty($this_script)) { $this_script = $php_self; } if (empty($offset)) { $offset = 0; } $result3 = mysql_query("select count(*) from dbulletins"); list($total_rows) = mysql_fetch_array($result3); print "<p>\n"; if ($offset > 0 ) { print "<a href=\"$this_script?offset=".($offset-page_limit)."\"><<Previous</a>   "; } if ($offset+page_limit < $total_rows) { print "<a href=\"$this_script?offset=".($offset+page_limit)."\">Next>></a>   "; } print "</p>\n"; }

?> </table> <? nav(); ?> </body> </html> ---------------------------------------------------------------------- Thanks for any help you all can provide,

Chip Wiegand Computer Services www.simradusa.com chip.wiegandsimrad.com Simrad, Inc Lynnwood, WA 425-712-1138

"There is no reason anyone would want a computer in their home." --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!)

attached mail follows:

Hello, I would like to create an object from a db result like MySQL does in mysql_fetch_object How can I create an object with members which names are set at runtime ?

Regards Bret

attached mail follows:

Hello All --

I have a csv file that I need to parse into a table. Getting the file open and into stuffed into an array is not really a problem, but I want PHP to adapt the table structure to the data on the fly. For example, some data (from the hgitner.com stamp buying list):

26,used,3¢ Washington Dull Red type II,$1.00 ,-,- "Fine + OG Hinged 232-40, 285-90, 294-99, 323-7 wanted. Call or ship!",,,,, 534A,single,"2¢ Washington, type VI (imperf, offset)",$20.00 ,$12.00 ,$6.00 534B,single,"2¢ Washington, type Va (imperf, offset)",Needed Urgently!,,

I can easily get line 1 and 3 can easily into:

<td>26</td><td>3¢ Washington Dull Red type II</td><td>$1.00</td><td>-</td><td>-</td>

but line 2 and 4 are my problem. I want PHP to take line 2 and see that there is only one cell of data in the and four blanks in the array and thus create:

<td colspan=5>Fine + OG Hinged 232-40, 285-90, 294-99, 323-7 wanted. Call or ship!</td>

PHP should see that line 4 ends in two blanks and thus should output:

<td>34B</td><td>single </td><td>2¢ Washington, type Va (imperf, offset) </td><td colspan=3>Needed Urgently!"

but I'm having some real trouble figuring out the logic/control structures to do this. If there is a class out there that does this, I'd be happy to hear of it. But I suspect my inexperience is the real problem: I'm really hoping that someone can explain the logic of how this might be done.

thanks in advance.

peter

-- Peter Torraca peter

torraca.net

attached mail follows:

This is the way I would do it: split your CSV into an array. Then traverse the array, saving any data and incrementing a counter for any empty element. Finally set up some conditional statements with the counter to output the table the way you want. Still with me? Here is some sample code I threw together. You may have to play with it to get it working the way you want... but it should at least give you a starting point.

<HTML><BODY><Table Border=1> <?php $fp = fopen("file.csv",r); while (!feof ($fp)) { $buffer = fgets($fp, 4096); $linearr = explode(",",$buffer); $outarr = ""; echo "<TR>\n"; $colspan=0; for($j=0; $j < count($linearr); $j++) { if ($linearr[$j] == "") { $colspan++; } else { $outarr[] = chop($linearr[$j]); } }

if ($colspan == 0) { echo "<TD>$outarr[0]</TD>\n"; } else { if(count($outarr) == 0) echo "<TD Colspan=$colspan></TD>\n"; else echo "<TD Colspan=$colspan>$outarr[0]</TD>\n"; } for($j=1; $j < count($outarr); $j++) { echo "<TD>$outarr[$j]</TD>\n"; } echo "</TR>\n"; } ?> </Table></Body></HTML>

Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com

----- Original Message ----- From: Peter Torraca <petertorraca.net> To: <php-generallists.php.net> Sent: Tuesday, August 14, 2001 11:02 AM Subject: [PHP] smart table construction from array

> Hello All -- > > I have a csv file that I need to parse into a table. Getting the > file open and into stuffed into an array is not really a problem, but > I want PHP to adapt the table structure to the data on the fly. For > example, some data (from the hgitner.com stamp buying list): > > 26,used,3¢ Washington Dull Red type II,$1.00 ,-,- > "Fine + OG Hinged 232-40, 285-90, 294-99, 323-7 wanted. Call or ship!",,,,, > 534A,single,"2¢ Washington, type VI (imperf, offset)",$20.00 ,$12.00 ,$6.00 > 534B,single,"2¢ Washington, type Va (imperf, offset)",Needed Urgently!,, > > > I can easily get line 1 and 3 can easily into: > > <td>26</td><td>3¢ Washington Dull Red type > II</td><td>$1.00</td><td>-</td><td>-</td> > > but line 2 and 4 are my problem. I want PHP to take line 2 and see > that there is only one cell of data in the and four blanks in the > array and thus create: > > <td colspan=5>Fine + OG Hinged 232-40, 285-90, 294-99, 323-7 wanted. > Call or ship!</td> > > PHP should see that line 4 ends in two blanks and thus should output: > > <td>34B</td><td>single </td><td>2¢ Washington, type Va (imperf, > offset) </td><td colspan=3>Needed Urgently!" > > but I'm having some real trouble figuring out the logic/control > structures to do this. If there is a class out there that does this, > I'd be happy to hear of it. But I suspect my inexperience is the > real problem: I'm really hoping that someone can explain the logic of > how this might be done. > > thanks in advance. > > peter > > -- > Peter Torraca > petertorraca.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

$PATH_INFO is server variable, that appear on IIS but not apache. maybe you can try $REQUEST_URI, that return URL with query string there. or you can check all the server variable with phpinfo(). you can put this into the web server and run it on your browser.

<?php phpinfo(); ?>

--
Hidulf
http://www.hidulf.com
"Lolodev News Php" <laurent.hermannlorasi.fr> wrote in message
news:20010813071210.27428.qmailpb1.pair.com...
> why can i read PATH_INFO server variable with apache under windows server
?
>
> with IIS 5 it's OK
>
> how can i ?
>
> <? print $PATH_INFO ?> -> Warning: Undefined variable: PATH_INFO in
> e:\sitephp\php_edit\htdocs\var.php on line 3
>
>
>
>

attached mail follows:

Hi,

Just to add to Arjen and Phils advice you need to the following.

From your C:\PHP directory you need to copy the files from the dlls directory to the C:\windows\system directory .

Also from your C:\PHP directory you will need to copy the php4ts.dll to your C:\windows\system directory

I hope that helps

Andrew Stopford

<legalHEROCYCLES.COM> wrote in message news:OF5D6BE043.08223383-ON65256AA2.003974DDdomain... > Dear Friends, > > I am new to PHP (but familiar with ASP,JSP) and would like to have some > guidance notes from you. > I am using windows 98 OS on my PC with PWS installed on it. > I want to install PHP that runs on windows using PWS. > For this I have done the following: > 1. Downloaded php for windows from www.php.net , its is of about 738 > bytes. > 2. I extracted the same in c:\php folder. > 3. shifted the php.ini in c:\windows folder. > > My queries are: > 1. In which folder I have to place my php files? whether in c: > \inetpub\wwwroot folder where other asp files I put. > Because, when I put test.php file in c:\inetpub\wwwroot folder and > called by using http://localhost/test.php , It showed a blank white > sheet that is without interpreting php. > 2. Whether I have omitted any step for installation? > > Pl. clarify. > > > Ajay K. Ratra > Ludhiana (INDIA) > ajayLudhianaInfoline.com > >

attached mail follows:

I have the current 4.0.6 tarball. Has anyone built this out of the box using VC++ 6 ?

Jerry.

attached mail follows:

Acutally, I spoke with the main developer of the windows binary at the PHP conference in San Diego.he suggested that it is a better practice to put those dll's in the same folder that php.exe is sitting in. He explained that php should still be able to find them there and it's not good practice to be adding things to your system folder on windows. I haven't tested it yet to make sure it still finds those dll's. I informed him that his documentation for installation explained to put them in the system folder and he said that was a legacy problem and he would make an effort to have those installation directions removed on the next release of php win binary.

Angie Tollerson Alliance Technologies Web Programmer (515)245-7628 tollersonalliancetechnologies.net

>>> "Andrew Stopford" <andrew.stopfordbtinternet.com> 08/14/01 11:36AM >>> Hi,

Just to add to Arjen and Phils advice you need to the following.

From your C:\PHP directory you need to copy the files from the dlls directory to the C:\windows\system directory .

Also from your C:\PHP directory you will need to copy the php4ts.dll to your C:\windows\system directory

I hope that helps

Andrew Stopford

-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe

lists.php.net For additional commands, e-mail: php-windows-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

I agree with Angie's sentiments. There is no need at all to put the dlls in your system directory (although php will still work if you do) as long as phpts.dll is in the same directory as the main php executable or dll. This means php.exe for cgi, php4apache.dll for Apache module etc.

I think that working this way vastly reduces the chances of 'old' php files messing up an installation.

Cheers

-- Phil Driscoll

attached mail follows:

On Tuesday 14 August 2001 19:23, Phil Driscoll wrote: >as long as phpts.dll is in the same directory as the main php executable or but should have written as long as php4ts.dll is in the same directory as the main php executable or

Sorry!

-- Phil Driscoll

attached mail follows:

Has anyone got this to work correctly with 4.0.6 ? If so I'd really appreciate knowing the configuration etc.

Thanks

Jerry.

attached mail follows:

Hello, Does anyone know how I would go about connecting to an SSL site using sockets? Or could I need to go in another direction? Thank you,

Brandon

attached mail follows:

Hello,

I think you need cURL extension for PHP. visit this page to know more about cURL: http://curl.haxx.se

----- Original Message ----- From: "Brandon Orther" <ortherwebintellects.com> To: "PHP User Group" <php-generallists.php.net> Sent: 2001. augusztus 14. 19:17 Subject: [PHP] Using Sockets to connect to an SSL site?

> Hello, > > Does anyone know how I would go about connecting to an SSL site using > sockets? Or could I need to go in another direction? > Thank you, > > Brandon > > >

attached mail follows:

Hello Matthew,

Friday, August 10, 2001, 8:55:24 PM, you wrote:

ML> If you run windows, then see:

ML> http://www.php.net/manual/en/ref.printer.php

ML> -----Original Message----- ML> From: Fernando Avila [mailto:fanointer-k.com.ar] ML> Sent: Friday, August 10, 2001 10:18 AM ML> To: php-generallists.php.net ML> Subject: [PHP] printing

ML> Hello php-general,

ML> I was thinking about my problem about printing reports ML> CAn i do something like connecting a printer to the server where php ML> and mysql runs.. And when someone send the comand to print the quote ML> get printed in the server's printer? ML> if it's posible maybe i will be albe to print a good quote

And if i run linux? because I have a redhat 6.2 server

Thanks

-- Best regards, Fernando mailto:fano

inter-k.com.ar

attached mail follows:

I have to store a whole lot of text files into a database, each one containing 3 columns containing numbers and about 2500 lines. I was wondering if anyone knew which would be the best way to store these files, having one big table with each row containing the contents of the files, or making one table for each file and inserting each line of the file into its respective row in the database. The database will probably become pretty big and I'm looking for the option that won't slow it down too much.

-petur

attached mail follows:

Instead of posting the code, I'll give you the link:

http://www.phpbuilder.com/columns/bealers20000904.php3?page=1

Short and long of it is the subject line.

attached mail follows:

hi,

i have two arrays that i would like to find the intersection and at this intersection alter the value.

$invalid = array("1","3","9"); $questions = array("1","2","3","4","5","6","7","8","9");

and i would like the result to be an new array that looks like this:

$new_questions = array("<font color=red>1</font>", "2", "<font color=red>3</font>", "4","5","6","7","8", "<font color=red>4</font>");

thank you in advance, joe

attached mail follows:

Hi,

play with array_intersect or array_diff and some other array functions.

http://www.php.net/manual/en/function.array-intersect.php (PHP 4 >= 4.0.1) http://www.php.net/manual/en/function.array-diff.php (PHP 4 >= 4.0.1)

----- Original Message ----- From: "Joe Rice" <jricebigidea.com> To: <php-generallists.php.net> Sent: 2001. augusztus 14. 19:57 Subject: [PHP] Q: array intersection problem

> hi, > > i have two arrays that i would like > to find the intersection and at > this intersection alter the value. > > $invalid = array("1","3","9"); > $questions = array("1","2","3","4","5","6","7","8","9"); > > and i would like the result to be an new array that looks > like this: > > $new_questions = array("<font color=red>1</font>", > "2", > "<font color=red>3</font>", > "4","5","6","7","8", > "<font color=red>4</font>"); > > thank you in advance, > joe > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Hi,

I'm trying to popen a cgi script that was designed to be open via a SSI include, but cannot because of passing variable restrictions.

I'm popening a cgi script and it is returning a process pointer regardless of whether the string passed to it points to anything. Is this the expected response?

<? $p = popen( "/web/guide/myfiles/bannerzzzzz.cgi","r" ); ?>

this returns a process pointer even though bannerzzzzz.cgi doesn't exist

I then need to read the results of the cgi script and dump them to the screen like so;

<? while (!feof ($p)) { $buffer = fgets($p, 4096); echo $buffer; } pclose ($p); ?>

but this is not functioning, does anyone have any ideas?

Regards

Tom Hodder

attached mail follows:

Is there anyway to use PHP to embed font types into web pages to the person visiting the page sees what you want them to even if they dont have the same fonts on their computer. Pat

attached mail follows:

I don't believe so. I think you'd just have to let them dl the font.

Tyler Longren Captain Jack Communications tylercaptainjack.com www.captainjack.com

On Tue, 14 Aug 2001 14:22:06 -0400 admin <adminmy-pcdoctor4u.com> wrote:

> Is there anyway to use PHP to embed font types into web pages to the > person > visiting the page sees what you want them to even if they dont have the > same fonts on their computer. > Pat > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Here's how, but it does not use PHP:

http://cnet.com/webbuilding/pages/Authoring/Typography/ss01.html

--
  Julio Nobrega.
2B||!BB - That's the question.
"Admin" <adminmy-pcdoctor4u.com> wrote in message
news:200108141809.f7EI9kZ11214pop.mrtc.com...
> Is there anyway to use PHP to embed font types into web pages to the
person
> visiting the page sees what you want them to even if they dont have the
> same fonts on their computer.
> Pat
>
>

attached mail follows:

I am new to PHP and am confused on HTTP authentications. I have read that section in the manual and still have questions. Where does PHP look to see if the user is valid or if the passward matches the user. How do you use PHP to set up user registration so users can input their information for authentication. Can anyone point me in the right direction to read more on this and help clear my confusion. Pat

attached mail follows:

<cannelltravishotmail.com> wrote: >hi all,

>I cant seem to get my mail function to work. OK so i am a noob, that might >have something to do with it. I am using a script I found called the HTML >Mime Mail Class, which does everything i need except actually send the mail. >I am guessing that there is some config problems, but i am not sure. Even >when i try and use the mail() function i get a server error. So i guess >that my problem is that my return address is messed up. Does it have to be >my own domain, or the domain that the server is running on? Can i set the >return address as a hotmail account, or do i need my own server mail >program? And is there anything that i need to config in the php.ini file? > >Thanks for helping, > >T P K Cannell

This article by the most helpful Julie Meloni answers your question: http://www.zdnet.com/devhead/stories/articles/0,4413,2802264,00.html

--- Regards, Boaz Amit

attached mail follows:

<cannelltravishotmail.com> wrote: >hi all,

This article by the most helpful Julie Meloni answers your question: http://www.zdnet.com/devhead/stories/articles/0,4413,2802264,00.html

--- Regards, Boaz Amit

attached mail follows:

i have people upload a file from their computer but if my form comes back with an error then they have to go select their file location again. is there any way of saving that location so they don't have to pick it again??? ====> upload file [ c:/temp/picture.jpg ]

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

attached mail follows:

On the form processing page, register the variable on a session. And put session_start(); on the form's page, so the value is remembered and echo()ed on the field.

--
  Julio Nobrega.
2B||!BB - That's the question.
"Bob" <whyisityou2yahoo.com> wrote in message
news:3B79713B.517F11B9yahoo.com...
> i have people upload a file from their computer but if my form comes
> back with an error then they have to go select their file location
> again.  is there any way of saving that location so they don't have to
> pick it again??? ====>   upload file [ c:/temp/picture.jpg ]
>
> <input type=File name=picture size=25 value="<? echo $file_location ?>">
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free yahoo.com address at http://mail.yahoo.com
>

attached mail follows:

Tina, Thank you for the help Tina :-)) I getting a good experience working with PHP and HTML (forms). Because of my full time job and personal commitments, I haven't been able to spend as much of my free time as I could in my project (Free Gallery Management System). After October I hope to dedicate more of my free time on this project.

The project will be open source and public domain. It will be developed with the help of PHP, a and PostgreSQL. More information about the project can be seen at the following web site: http://www.columbia.edu/~mv169/private/gallery_f.html Login Name: guest Password: guest If you have any comments, suggestions or if you want to participate, e-mail me at mrv169yahoo.com Your input is very valuable to me. Adios, miguel --- Tina <tinaefil4rekcah.com> wrote: > The solution: > > You have to configure php with --enable-discard-path > as in: > ./configure --without-apache --enable-discard-path > before you compile it. > > This is documented here: > http://www.php.net/manual/en/security.php > in the section: > Case 4: PHP parser outside of web tree > > Now when you do  > the #!/path/to/php will not show at the top of the > page. > > (The problem was indeed not local to windows). > > Tina. >

__________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

attached mail follows:

Could anyone point me in the direction of some PHP shopping cart scripts?

Thanks,

Christopher Raymond

attached mail follows:

In a message dated 8/14/01 3:23:54 PM Eastern Daylight Time, christopheroasisnetworks.com writes:

> Could anyone point me in the direction of some PHP shopping cart scripts? > > > Thanks, > > Christopher Raymond >

I'm sure they have one: http://hotscripts.com/PHP/Scripts_and_Programs/

Pat

attached mail follows:

www.fishcart.org

At 02:22 PM 8/14/01 -0500, Christopher Raymond wrote:

>Could anyone point me in the direction of some PHP shopping cart scripts? > > >Thanks, > >Christopher Raymond > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

http://www.hotscripts.com/PHP/Scripts_and_Programs/E-Commerce/Shopping_Carts/

On Tuesday 14 August 2001 12:39, you wrote: > In a message dated 8/14/01 3:23:54 PM Eastern Daylight Time, > > christopheroasisnetworks.com writes: > > Could anyone point me in the direction of some PHP shopping cart scripts? > > > > > > Thanks, > > > > Christopher Raymond > > I'm sure they have one: > http://hotscripts.com/PHP/Scripts_and_Programs/ > > Pat

attached mail follows:

Michael,

I've got a program set up like you describe.

the problem is I've noticed that my variables are NOT stable

this is it in a nutshell

1) show 3 options with radio buttons for each

2) based on above query a database and show a list of the records (now it just dawned on my that I've been doing this with URL's and that might be the problem)

3) show all of the fields in the record to edit as necessary. 4) update the table

1,2,3 work fine. I save the id number of the record. however, it isn't persistent. IOW, suddenly the variable is set to null.

am I just not understanding how php scripts work?

or is my usage of URL's in appropriate. I'm new to the world of php.

thanks

chris

On Mon, 30 Jul 2001 17:14:53 -0700, Michael J. Seely wrote:

>I do this sort of thing all the time. The format I use typically >follows this logic. > >The PHP file has four IF-ELSEIF-ELSE sections. > pg=1 or blank is the initial form > pg=2 is the error check looking at input values. > If it passes, pg is set to 3. > If not, set to 1. The advantage of this is the original input >values can be saved and displayed with Value=<? ECHO..?> sequences so >the use doesn't have to input everything if they make a mistake. The >error can be highlighted with a color or text!!!. > pg=3 shows a visual verification page. The user can scan the input >and use the back button to make changes or click OK to proceed. > pg=4 is the action step - send an e-mail including the input, post >input to a database or ??? > >The sections are written in this order - 2, 4, 3, 1. > >IF($pg="2") > { do the error checking > e.g., if fields A, B, and C are not blank = OK > e.g., if a value is > 100 = not OK > IF OK, $pg=3; IF not OK, $pg=1; > } >ELSEIF($pg="4") > { do the action stuff. > } >ELSEIF($pg="3") > { show an html page in a nice format showing the input values > IF they like it, the form submit button sets pg=4, and >uses hidden fields to copy all of the input values to pg 4. > } >ELSE > { Show the initial input form. > use <INPUT TYPE="HIDDEN" NAME="pg" VALUE="2"> > } > > >The form can include error check and input tags like this: > ><? IF(($pg="1") and ($val3=="")) > { ECHO"<FONT COLOR=RED>Required.</FONT><BR>"; } ?> ><TEXTAREA WRAP="SOFT" NAME="val3" COLS="50" ROWS="5"><? ECHO "$val3"; >?></TEXTAREA> > ><INPUT TYPE="RADIO" NAME="v2" VALUE="6" <?IF($v2=="6") { ECHO >"CHECKED"; } ?> >6 ><INPUT TYPE="RADIO" NAME="v2" VALUE="7" <?IF($v2=="7") { ECHO >"CHECKED"; } ?> >7 > >and so on. Hope this is useful... > > > >>Im trying to introduce some logic into a form.I am unsing $PHP_SELF >>as the target. >><form action=\"$PHP_SELF\" method=\"POST\" type=\"multipart/form-data\"> >> >>I have a text area that the user inputs their age. What I want is >>that if the field is blank, to stop the script and send the user >>back to fill in their age. My problem now is that if I go to the >>blank application form, The script interprets the form as being >>blank and spits out the error. Ideal scenario, a blank form is >>presented to the user, and when the form is submitted, do the logic >>check and act accordingly. Is it possible using $PHP_SELF as the >>target, or do I have to use 2 files: a form 'front end' with the php >>logic in the 'backend'?? >> >> >>if ($Age = " ") { >> echo "Please go back and enter your age."; } exit(); >> >>Thanks >>Gerard >> >> >>-- >>PHP General Mailing List (http://www.php.net/) >>To unsubscribe, e-mail: php-general-unsubscribelists.php.net >>For additional commands, e-mail: php-general-helplists.php.net >>To contact the list administrators, e-mail: php-list-adminlists.php.net > >-- > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > Michael Seely 408-777-9949 > > > > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribelists.php.net >For additional commands, e-mail: php-general-helplists.php.net >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

Ok, I found out why the UPDATE on the table wasn't working. I wasn't giving the command a 'fake' value for the ID column. Ok here is the senario. I have a form which dumps data to cols 1,2,3,5 in a table (thats good). I have another script which runs a loop on the data into another form where I have a textarea, and a checkbox which fills in col 4 and modifies col 5. What I need to do is when the new form submits, to pass the textarea, checkbox & ID so I could issue a proper UPDATE. Im able to get it to echo the textarea & the checkbox, but no luck with the ID. When the new form is displayed I have the loop echo the ID, but I cant figure out how to submit the ID array.

// Snip of problem area (Hope it doesn't look sloppy in the message)// echo "<form action=\"$PHP_SELF?op=reply\" method=\"POST\" enctype=\"multipart/form-data\">\n"; $c = 0; while($query_data = mysql_fetch_row($result)) { echo "<table width=\"100%\" cellspacing=\"2\" border=\"1\" cellpadding=\"2\" BGCOLOR=\"CCCCCC\"><tr><td width=\"50%\" valign=\"top\">\n"; echo "Database ID: $query_data[0]<br>\n"; echo "Name: $query_data[1]<br><br>\n"; echo "Question:<br> $query_data[2]\n"; echo "<hr>\n"; echo "Post Reply => Yes <input name=\"post[$c]\" type=\"radio\" value=\"yes\">\n"; echo "No <input name=\"post[$c]\" type=\"radio\" value=\"no\" checked>\n"; echo "</td><td width=\"50%\" align=\"\">\n"; echo "Reply:<br><textarea rows=\"4\" cols=\"50\" wrap=\"hard\" name =\"Reply[]\"></textarea>\n"; echo "</td></tr></table>\n"; echo "<br><hr><br>\n"; $c = $c + 1; } echo "<input type=\"submit\" value=\"Submit\">\n"; echo "</form>\n"; // End Snip //

I tried creating a new array at the bottom of the loop like so ==> $id[]="$query_data[0]"; and using a hidden field, but that failed. My problem is basically, how does one one make an array 'persist'. I looked through the archive, and didnt find anything substantial. If you need more info please email me. Thanks for listening....

Gerard Samuel wrote: > Thanks for telling me that I was talking jibberish :) > > OK it worked, but now I have to figure out why its only updating the > first row..... > Ill be back if I cant figure it out. > > Thanks all > > Tyler Longren wrote: > >> yeah...jibberish. Should be this: >> UPDATE mpn_asklee SET reply='$Reply[$i]', Post='$post[$i]' WHERE >> ID='$counts'" >> >> >> >> On Mon, 13 Aug 2001 15:20:17 -0400 >> Gerard Samuel <trini0optonline.net> wrote: >> >> >>> I have a database with 5 columns and cols 1,2,3 & 5 are filled. I >>> want to insert into 4 and change 5. Could I use an UPDATE command to >>> do this.. Here is what I have ==> >>> >>> $query = "UPDATE mpn_asklee (Reply, Post) VALUES >>> ('$Reply[$i]', '$post[$i]') WHERE ID = '$counts'"; >>> $result = mysql_query($query); >>> >>> If Im talking jibberish, let me know..

attached mail follows:

I wrote a script that clients can upload files to our server and download files but there is one small problem. Mac users can't upload all of their files. I am guess there is no file extensions. Anyone have any ideas? Jason

attached mail follows:

Hi!

> Mac users can't upload all of their files.

"all" of their files? Out of curiousity, how many files do they seem to be able to send up before the script falters? What error messages or behavior does PHP show when it does falter?

Just looking for alittle additional info, - Erik

attached mail follows:

Hey Erik, well I checked the userfile_type and if it was a word document I added the .doc extension to it. The other mac programs that add the extension to the filename work fine. If you were to make a photo shop file and upload it it fail. Warning: Unable to open "none" for reading. No such file blah blah. What do you think? Thanks, Jason

-----Original Message----- From: Erik H. Mathy [mailto:erikbutlerandco.com] Sent: Tuesday, August 14, 2001 2:01 PM To: php-generallists.php.net Subject: RE: [PHP] php upload on MAC

Hi!

> Mac users can't upload all of their files.

"all" of their files? Out of curiousity, how many files do they seem to be able to send up before the script falters? What error messages or behavior does PHP show when it does falter?

Just looking for alittle additional info, - Erik

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe

lists.php.net For additional commands, e-mail: php-general-help

lists.php.net To contact the list administrators, e-mail: php-list-admin

lists.php.net

attached mail follows:

Hello, I am looking for tutorials for using PHP with cURL. If you know of a site please e-mail me. Thank you,

-------------------------------------------- Brandon Orther WebIntellects Design/Development Manager brandonwebintellects.com 800-994-6364 www.webintellects.com --------------------------------------------

attached mail follows:

http://curl.haxx.se/libcurl/php/

Enjoy! - Erik

> -----Original Message----- > From: Brandon Orther [mailto:ortherwebintellects.com] > Sent: Tuesday, August 14, 2001 3:19 PM > To: PHP User Group > Subject: [PHP] cURL tutorials ? > > > Hello, > > I am looking for tutorials for using PHP with cURL. If you know of a > site please e-mail me. > Thank you, > > -------------------------------------------- > Brandon Orther > WebIntellects Design/Development Manager > brandonwebintellects.com > 800-994-6364 > www.webintellects.com > -------------------------------------------- > >

attached mail follows:

I was wondering if anyone knows how to make a script that is capable of doing it's own POST to a page without needing a form to be filled in. Basically it needs to perform the same sort of action as:

www.anyplace.com/script.php?action=say&text=hello

Unfortunately I cant change the script at the other end to take GET variables instead of POST values so I need a way for the PHP script to send POST values.

Thanks,

Marc.

attached mail follows:

On Tuesday 14 August 2001 23:52, Marc Hanlon wrote: > I was wondering if anyone knows how to make a script that is capable of > doing it's own POST to a page without needing a form to be filled in. > Basically it needs to perform the same sort of action as: > > www.anyplace.com/script.php?action=say&text=hello > > Unfortunately I cant change the script at the other end to take GET > variables instead of POST values so I need a way for the PHP script to send > POST values. > > Thanks, > > Marc.

Use the curl extension, or if you don't want to compile it (or can't) you can always use Manuel Lemos's HTTP class at:

http://phpclasses.upperdesign.com/browse.html/package/3

-- Kriheli Meir

attached mail follows:

I am a total newbie, so please forgive the simplicity!

I have a huge list of email addresses in a text file and also in a MySQL DB that I would like to use PHP to loop through and send an email to each one of them. How do I loop through a text file using each email in the txt file as a seperate email address and send a message to that address? Or would it be easier to just do it from a MySQL DB? If so, How??

attached mail follows:

With mysql: $connection = mysql_connect("host","user","pass"); $db = mysql_select_db("db_to_use", $connection); $sql = mysql_query("SELECT * FROM table ORDER BY email ASC"); while ($row = mysql_fetch_array($sql)) { $email = $row["email"]; $name = $row["name"]; email(EMAIL_FUNCTION_STUFF); }

Tyler Longren Captain Jack Communications tylercaptainjack.com www.captainjack.com

On Tue, 14 Aug 2001 16:09:22 -0500 "Erich Kolb" <ekolbrandbreceivables.com> wrote:

> I am a total newbie, so please forgive the simplicity! > > I have a huge list of email addresses in a text file and also in a MySQL > DB > that I would like to use PHP to loop through and send an email to each > one > of them. How do I loop through a text file using each email in the txt > file > as a seperate email address and send a message to that address? Or > would it > be easier to just do it from a MySQL DB? If so, How?? > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribelists.php.net > For additional commands, e-mail: php-general-helplists.php.net > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

for a file i would do something like this:

<? $file = file ("addressfile.txt");

foreach ($file as $address) mail ($address, "subject", "message", "From: youyourhost.com"); ?>

for the mysql db it would be something like this (this is probably a little off):

<? $mysql = mysql_pconnect ($server, $username, $pw); $res = mysql_query ("select * from addresses", $mysql) or die ("something went bad");

while ($row = mysql_fetch_array ($res)) { mail ($row["address"], "subject", "message", "From: youyourhost.com"); } ?>

I hope this helps. I'm sure it probably has a syntax error or something but you get the point. :-) Welcome to the happy world of php! - Dan

On Tue, 14 Aug 2001, Erich Kolb wrote:

> I am a total newbie, so please forgive the simplicity! > > I have a huge list of email addresses in a text file and also in a MySQL DB > that I would like to use PHP to loop through and send an email to each one > of them. How do I loop through a text file using each email in the txt file > as a seperate email address and send a message to that address? Or would it > be easier to just do it from a MySQL DB? If so, How?? > > >

attached mail follows:

Hello-

I'm using the virutal hosting in Apache 1.3.19 and I was wondering how to I load php as a module in apache for each virutal web site? anyone have a good link telling you how to do this.. ie a tutorial on the topic? i've read the docs on apache.org and it doesn't really say much at all about this.. because one of the problems i'm having is that i get a "Forbidden 403" error because it's says that i don't have permission to access /phpinfo.php on the virtual server i just set up..

any thoughts?

thanks, jay

attached mail follows:

Wouldn't it be just to add, say,

AddType application/x-httpd-php .php .php3 AddType application/x-httpd-php-source .phps

or approximation within the <Directory></Directory> tags?

I think (fingers crossed here) that should do it... --- Jay Paulson <jpaulsonlbjs.com> wrote: > Hello- > > I'm using the virutal hosting in Apache 1.3.19 and I > was wondering how to I > load php as a module in apache for each virutal web > site? anyone have a > good link telling you how to do this.. ie a tutorial > on the topic? i've > read the docs on apache.org and it doesn't really > say much at all about > this.. because one of the problems i'm having is > that i get a "Forbidden > 403" error because it's says that i don't have > permission to access > /phpinfo.php on the virtual server i just set up.. > > any thoughts? > > thanks, > jay > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-general-unsubscribelists.php.net > For additional commands, e-mail: > php-general-helplists.php.net > To contact the list administrators, e-mail: > php-list-adminlists.php.net >

__________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

attached mail follows:

I just added sessions to a web site that I am developing, and now the browser keeps saying "page expired" when I hit back on several pages.

For example, I have a search page that displays results, user clicks on a result to view, and when the user hits back to go back to the search list they get the page expired message and must refresh. How can I keep this from happening? I am displaying user information in a header file that gets loaded with each page, so I have to use sessions for each page. This didn't happen before I added the session code.

Thanks.

-- Dana Holt / danah

home.com -- http://www.theydidmewrong.com/ http://www.shedidmewrong.com/ http://www.hedidmewrong.com/ --

attached mail follows:

I'm trying to get java support working with php and the jvm loads the first time and then I have to start and stop the server to get it to load again. In other words it's erring out and saying it can't load the jvm. I have followed the instructions at www.phpbuilder.com exactly and can't seem to get it to work, other than one time inbetween starts. Suggestions? I am running php under windows.

attached mail follows:

Ok, I asked a similar question more than a year ago, so I apologize for being a little redundant :)

Why was PHP's foreach loop syntax chosen to be

foreach($dogs as $dog){}

instead of something more common (Python, Javascript, can't think what else right now) and, to me, more intuitive, like

foreach($dog in $dogs){}

Just wondering what the reasoning was. Thanks.

Keith

attached mail follows:

Hi, Can anyone tell me why this is a never ending loop?

$i=0; $count = 1; while ($count > $i); { echo "$i <br>"; $i++; } Chris

attached mail follows:

Hi,

clear that semicolon(;) after the while statement!

this makes the trick ----- Original Message ----- From: "PHP List" <php_listibcnetwork.net> To: "php" <php-generallists.php.net> Sent: 2001. augusztus 15. 01:49 Subject: [PHP] Loop error?

Hi, Can anyone tell me why this is a never ending loop?

$i=0; $count = 1; while ($count > $i); { echo "$i <br>"; $i++; } Chris

attached mail follows:

> -----Original Message----- > From: PHP List [mailto:php_listibcnetwork.net] > Sent: Wednesday, 15 August 2001 09:20 > To: php > Subject: [PHP] Loop error? > > > Hi, > Can anyone tell me why this is a never ending loop? > > $i=0; > $count = 1; > while ($count > $i); ^

> { > echo "$i <br>"; > $i++; > } > Chris

attached mail follows:

Oops, well, that is just mental. Must be getting tired or something, yes, that's it :)

Thanks.

----- Original Message ----- From: "Gyozo Papp" <pgerzsonfreestart.hu> To: "PHP List" <php_listibcnetwork.net>; "php" <php-generallists.php.net> Sent: Tuesday, August 14, 2001 4:58 PM Subject: Re: [PHP] Loop error?

> Hi, > > clear that semicolon(;) after the while statement! > > this makes the trick > ----- Original Message ----- > From: "PHP List" <php_listibcnetwork.net> > To: "php" <php-generallists.php.net> > Sent: 2001. augusztus 15. 01:49 > Subject: [PHP] Loop error? > > > Hi, > Can anyone tell me why this is a never ending loop? > > $i=0; > $count = 1; > while ($count > $i); > { > echo "$i <br>"; > $i++; > } > Chris >

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