php3-digest-helplists.php.net

• Next message: php3-digest-helplists.php.net: "php3 Digest 7 May 2000 04:55:02 -0000 Issue 1655"
• Previous message: php3-digest-helplists.php.net: "php3 Digest 6 May 2000 04:55:05 -0000 Issue 1653"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php3 Digest 6 May 2000 16:55:03 -0000 Issue 1654

Topics (messages 89284 through 89330):

Multi-dimensional array
        89284 by: Mark Nold <marknalverstone.com.au>

oracle and PHP
        89285 by: Mark Nold <marknalverstone.com.au>
        89296 by: Arthur <xapx.org>
        89297 by: Arthur <xapx.org>

preg_replace expressions (formated to rich text)
        89286 by: "Bjorn Sodergren" <sweedegallatinriver.net>

neat URLs using ForceType directive
        89287 by: php3developersdesk.com
        89294 by: Saurabh Gupta <errorzxmail.com>

Useing PHP
        89288 by: "Mircea Circiumarescu" <mirceadialog-gsm.com>
        89303 by: Saurabh Gupta <errorzxmail.com>
        89309 by: "Mircea Circiumarescu" <mirceadialog-gsm.com>
        89311 by: Saurabh Gupta <errorzxmail.com>

php editing tool of choice?
        89289 by: "M.Stolte" <m.stoltenetventure.nl>
        89308 by: "A Robertson" <elite2000btinternet.com>

Fw: Unable to process request
        89290 by: "TV Karthick Kumar" <tvkarthickmailops.com>

Fw: [PHP3] Retreiving data
        89291 by: "TV Karthick Kumar" <tvkarthickmailops.com>

PHP Value Hosting
        89292 by: "porterda" <porterdaseattleu.edu>
        89307 by: "A Robertson" <elite2000btinternet.com>

Elements in an Array
        89293 by: "TV Karthick Kumar" <tvkarthickmailops.com>

PHP3 or PHP4RC1 + RH 6.1 + unixODBC + Apache Problem
        89295 by: LIARD DENIS <d-liardcopiden.com>

On-line web mail
        89298 by: Mark Lo <marklokynetvigator.com>

Big Challenge
        89299 by: "SANIsoft" <tariquenagpur.dot.net.in>
        89301 by: Boaz Yahav <berbernetvision.net.il>

passing scores from a flash game
        89300 by: "SANIsoft" <tariquenagpur.dot.net.in>
        89304 by: "Arjen Tempel" <arjentempel.demon.nl>
        89305 by: "Arjen Tempel" <arjentempel.demon.nl>

How to make PHP talk to MYSQL?
        89302 by: Boaz Yahav <berbernetvision.net.il>

Clearing buffer
        89306 by: "Srimanth R.C." <srimanthyahoo.com>

R: [PHP3] Useing PHP
        89310 by: delbonodsc.it (Delbono)

imap wont compile in
        89312 by: a Special guy <urgruetumsan.fi>

Record textarea field on MySQL
        89313 by: paulo henrique castro <phlcloreno.net>

MySQL in Functions
        89314 by: Tonu Samuel <tonumysql.com>

Premature end of script headers:
        89315 by: "Friembichler Johann jun." <friemigmx.at>
        89318 by: "Paul Gardiner" <paulgbarleychalu.co.uk>
        89324 by: "Friembichler Johann jun." <friemigmx.at>

OpenServer 5 users
        89316 by: Sascha Schumann <saschaschumann.cx>

Informix Functions Problem
        89317 by: "Danny Heijl" <danny.heijlpandora.be>

How we defaced www.apache.org (fwd from BugTraq)
        89319 by: Tonu Samuel <tonumysql.com>

Memory trouble - PHP4-Apache-Linux-Oracle 8i - need quick help !!
        89320 by: ludovic roussin <ludoelma.fr>

include() not working properly
        89321 by: "Mike Sears" <neutrinoneutrinostudios.com>
        89322 by: delbonodsc.it (Delbono)
        89323 by: Cliff Rowley <dozpromptonsea.com>
        89325 by: Jim Jagielski <jimjaguNET.com>

mail()
        89326 by: "Thomas Lachmann" <thlachmanngmx.de>

How we defaced www.apache.org (fwd) - credit note
        89327 by: Ann Cantelow <cantelowathena.csdco.com>

f2s.com WAS RE: [PHP3] PHP Value Hosting
        89328 by: mocha_php <mocha_phpyahoo.com>

Importing and Striping lines in html page (PHP3)
        89329 by: "Martin Pitt" <martinguest.vispa.co.uk>

steps needed to compile/bind mysql to PHP3
        89330 by: "Hector M Banda" <hectorneed-info.com>

Administrivia:

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

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

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

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

attached mail follows:

Try the following, (i havent tested it but should be OK) and you should have the function you want.

function size0fMatrix($ary){
  $dim1 = count($ary);
  reset($ary);
  while (list($key,$data) = each($ary)) {
     $cnt = count($data);
     if($cnt > $dim2){ // This could be slightly faster with $dim2 = $cnt > $dim2 ? $cnt : $dim2;
       $dim2 = $cnt;
     }
  }
  return array($dim1,$dim2);
}

list($x,$y) = sizeOfMatrix($room);
echo "The matrix is $x by $y";

Mark Nold
marknalverstone.com.au
Systems Consultant

Change is inevitable, except from vending machines.

On Friday, 5 May 2000 10:26, Sterling Hughes [SMTP:sterlingphp.net] wrote:
> >Hi,
> > i'm tring to use array as matrixs, so i created a multi-dimensional
> >array.
> >
> >$room = array(
> > "bed" => array("bed","lamp","window"),
> > "bath" => array("shower","soap","water"),
> > "dinning" => array("dish","seats","bottle","food")
> >);
> >
>
> How bout:
>
> while ($i < count($room)) {
> $num[$i] = count($room[$i]);
> $i++;
> }
>
> Therefore, if you want to see how many elements, the third item of the top array contains just go:
>
> echo $num[2]; // Arrays are indexed from 0
>
> FYI, count and sizeof are the same function, I just find count clearer.
>
> Sterling
>
>
>
> -------------------
> Email sent using AnyEmail (http://netbula.com/anyemail/)
>
>

attached mail follows:

Arthur,

Most of my clients use Oracle as their main database for their ERP systems.
At some clients we use PHP on Linux to connect to a Sun box with Oracle, on
others we have the Web server + PHP on the same box as the DB. We've not
had any major problems with installation or performance. I also have a NT
box with IIS connecting to Oracle for testing and cross platform issues.
Whilst these run Intranet's they take heavy poundings as we create all
sorts of complex reports from Phone list to complex resource analysis. So
PHP + Oracle is not a problem. I cant tell you about the Oracle web server
as we do prefer to remain vendor independent (as some clients dont use
Oracle) and you will not be if you go down that path.

If you have $250000 i would be thinking about prototyping your app and
doing some serious testing first. Why not start with MySQL unless you
really need transactions etc (see Richards comments) then plan to scale up
to Oracle. The key to this is creating a DB abstraction layer (see PHPLib)
so you can easily convert your app / site to Oracle later. But be careful
of the SQL you use as not every MySQL function will be same in Oracle and
vis-a-versa, but keep your SQL simple and you shouldn't have a problem,
plus you will not be tied to one vendor just because you made excessive use
DECODE's or some such.

It is very easy to separate your SQL though and conditionally include a
file with the correct SQL. If you had a page called mypage.php ;

$file = "mypage"; // This could be set from environment vars see phpinfo()
and a eregi expression
$dir = "/full/path/to/here"; // You may be able to use "./" but i not at a
system to test this at the moment
// $db would be your database object (PHPlib uses a nice object orientated
approach.)

if($db->rdbms == "oracle"){
  include("$dir/$file.ora");
}elseif($db->rdbms == "mysql"){
  include("$dir/$file.mysql");
}else{
  echo "Unable to find SQL file $dir/$file or unknown RDBMS.\n";
  exit(0);
}

// Next run your query and through it into a 2D array
$ary = $db->query($sql);

// now do whatever as your 2D will contain the correct data and not be
touched if you need to need to change DBMS's
myfunction($ary);

This is really just pseudo code and should be tidied up into some functions
you maybe call at the start of each page (with a prepend.php) so each time
a page has some sql rquirements you could just include($sql_file) and viola
it would pick the right one.

By running your queires then throwing them into a 2D array is extrememly
handy as you will be able to separate the data access from the manipulation
+ presentation. it will also make your code easy to maintain and allow you
to create reusable functions readily. Some simple examples are making a
table from your 2D array, making a crosstab function, sorting, grouping,
statistical analysis etc etc.

Using this proceedure we have successfully built applications in MS Access
running on PWS and scaled it up to Oracle on a huge Sun box.... the great
thing is that you now have a cross platform application.. as long as PHP
runs on it and you maintain separate .ora, .mysql or whatever you will be
able to move as you technical needs and managerial whims take you.

Good luck,

mn

Mark Nold
marknalverstone.com.au
Systems Consultant

Change is inevitable, except from vending machines.

On Saturday, 6 May 2000 12:56, Richard Lynch [SMTP:richardzend.com] wrote:
> In article <3.0.5.32.20000505110945.019e38c0mail.glink.net.hk>,
xapx.org
> (Arthur) wrote:
>
> > >Who here has used Oracle on Linux with PHP?
>
> Not me.
>
> > How does Oracle + PHP4 compare speed wise with Oracle + Oracle
Applications
> > server?
> >
> > Hardware/OS: Sun/Solaris or anything that can be bought for $250,000
> >
> > If subselects and transactions were not required, how would the
following
> > rank in speed?
> >
> > Oracle + PHP4
> > Oracle + Oracle Applications Server
> > MySQL + PHP4
> > Postgres + PHP4
> >
> > Is there any truth to the notion that Oracle is more stable and secure
than
> > MySQL and Postgres?
>
> Oracle is as stable and as fast as the person administering it: Oracle
> has no magic bullet on speed/stability. It's a fine (if expensive)
> database package for enterprise-class systems requiring high-end features
> (such as transactions and a whole host of function too esoteric for my
> poor brain). But if you're an inexperienced database administrator,
> you're unlikley to have Oracle up and running in tip-top condition
> overnight. Properly administered, however, Oracle will allow you to
> recover data in the event of anything short of nuclear disaster (and
maybe
> they have a plan for that too, for all I know) and allow you to ensure
> that people aren't billed for services not rendered (and vice versa).
>
> Oracle's stability and security advantage to MySQL are more about what
> happens when a hard drive fails or the power goes out rather than normal
> day-to-day usage. (Of course, there's always a hard drive failing
> somewhere, eh?)
>
> MySQL, on the other hand, is rock-solid, easy to set up, and easy to
> administer. A newbie can have it up and running in a matter of minutes,
> or days if "things go wrong" somewhere. MySQL has traded functionality
> (transactions and subselects) for sheer speed and simplicity.
>
> If you can live with a daily backup and lose the data input today, and
the
> occasional inconsistency of data introduced by no transactions, MySQL is
> perfectly safe to use.
>
> PostgreSQL might require a little tweaking to get the performance up to
> MySQL (and beyond in some queries) but is not anywhere near the
complexity
> of an Oracle administration. PostgreSQL comes with transactions and
> subselects, which you don't need now, but might someday, as well as the
> basic functionality needed to recover from disaster, if you're willing to
> write some code to make it happen. (Except maybe replication -- having
> the same database running on multiple machines, in sync, in case one just
> plain dies).
>
> If you're not doing eCommerce, nor have mission-critical info that losing
> a record or two in a power outage would be disaster, save your $250,000
> (or donate it to PHP) and get the best Pentium/AMD box you can buy,
> install Linux, PHP, and MySQL for a few grand. Better yet, use the
> $250,000 to hire somebody who *really* knows what they are doing to help
> you out. [Zend would be happy to provide such a person :-)]
>
> More seriously, you still need to describe what it is that you *DO* need
> (no transactions nor subselects is a start, but not much of one) to get
> much more than the general info here: How many page hits per day? How
> many in bursts? What sort of data are you storing, where, why, and who
> needs it how badly to not lose a record or two when the power fails?
>
> I'm a little flabberfasted that you have $250,000 to spend but don't need
> transactions and subselects, but hey, what do I know?
>
>

attached mail follows:

>Using this proceedure we have successfully built applications in MS Access
>running on PWS and scaled it up to Oracle on a huge Sun box.... the great
>thing is that you now have a cross platform application.. as long as PHP
>runs on it and you maintain separate .ora, .mysql or whatever you will be
>able to move as you technical needs and managerial whims take you.

Thanks for the tips about making an abstraction layer.

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

Regards,

Arthur

attached mail follows:

>If you're not doing eCommerce, nor have mission-critical info that losing
>a record or two in a power outage would be disaster, save your $250,000
>(or donate it to PHP) and get the best Pentium/AMD box you can buy,
>install Linux, PHP, and MySQL for a few grand. Better yet, use the
>$250,000 to hire somebody who *really* knows what they are doing to help
>you out. [Zend would be happy to provide such a person :-)]
>
>More seriously, you still need to describe what it is that you *DO* need
>(no transactions nor subselects is a start, but not much of one) to get
>much more than the general info here: How many page hits per day? How
>many in bursts? What sort of data are you storing, where, why, and who
>needs it how badly to not lose a record or two when the power fails?
>
>I'm a little flabberfasted that you have $250,000 to spend but don't need
>transactions and subselects, but hey, what do I know?

Thanks for the info. Sorry for not being more clear. I was wondering if
anyone had experience with Oracle + Oracle App Server versus Oracle + PHP4.

I'm not the one who has 250K to donate to Oracle, and I'm just as
flabbergasted at the intended use of such a budget. It's a company which
has a DB with about 1 million rows in one table and a few thousand in say 3
others, and they need to do multiple table joins to generate search
results. Hit-rate is not known at this stage as they're still in dev. They
*may* get into e-commerce later, but I see no need to use Oracle/Oracle App
Server until they get to that stage. By the time they do it, 250K will buy
a bigger box even from Sun.

In the meantime, a read only, search only DB as described can be handled
very well by PHP4 + MySQL on any box provided subselects aren't required.
MySQL in particular is superfast with joins. My question is: cost aside,
does PHP4 + MySQL actually perform as well or better than Oracle + Oracle
App Server when the task is simple and does not require transactions and
subselects. When a DB like this does get massive hits, will PHP4 + MySQL
scale well when a more powerful box is used?

Regards,

Arthur

attached mail follows:

here's some code to emulate UBB style transitions, if you don't know what I
mean.
read the comments :)

if anyone doesnt feel like looking at it in their email client, please goto
http://apache.underthemain.net/source.php3?page_url=/config.inc.php3 and
look about half way down.

If anyone knows how to make the contents of the [url] tags case insensitive,
please let me know. right now it only works if in the form [URL][/URL],
[url][/url] doesnt work.

i know there is eregi_replace, but these perl style regex seem easier for me
to use. any help on how to move from preg_replace to eregi_replace would be
most appreciative.

thanks,
bjorn.

and now for the code

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

function parse($string){
GLOBAL $dir_color,$com_color;

/*
 If you find any bugs in these expressions, please fix and email them to me
   sweedegallatinriver.net thank you.
*/
/* url mappings..

[url]www.domain.com[url]
[url]http://www.domain.com[/url]
[url=www.domain.com]description[url]
[url=http://www.domain.com]description[/url]
www.domain.com
http://www.domain.com

Supports https and ftp except when www.~ or [url=www.~] is entered.

*/

// plain, www.domain.com, http://www.domain.com
$string = preg_replace("/(^|\s)(www\.\S+)/" , "<A HREF=\"http://\\2\"
TARGET=2>\\2</A> " , $string);
$string = preg_replace("/(^|\s)(http:\/\/\S+)/" , "<A HREF=\"\\2\"
TARGET=1>\\2</A> " , $string);

// [url][/url]
$string = preg_replace("/(\[URL\])(http|https|ftp)(:\/\/\S+?)(\[\/URL])/"
,"<A HREF=\"\\2\\3\" TARGET=5>\\2\\3</A> " , $string);
$string = preg_replace("/(\[URL\])(\S+?)(\[\/URL])/" , "<A
HREF=\"http://\\2\" TARGET=3>\\2</A>" , $string);

// [url=][/url]
$string =
preg_replace("/(\[URL=)(http|https|ftp)(:\/\/\S+)(])(.+?)(\[\/URL\])/" , "<A
HREF=\"\\2\\3\" TARGET=6>\\5</A>" , $string);
$string = preg_replace("/(\[URL=)(\S+)(\])(.+?)(\[\/URL])/" , "<A
HREF=\"http://\\2\" TARGET=4>\\4</A>" , $string);

// creates an Email address
// [email=address]name[/email]
$string = preg_replace("/(\[EMAIL=)(\S+)(\])(.+?)(\[\/EMAIL])/" , "<A
HREF=\"mailto:\\2\">\\4</A> " , $string);
// [email]address[/email]
$string = preg_replace("/(\[EMAIL\])(\S+\\S+?)(\[\/EMAIL\])/" , "<A
HREF=\"mailto:\\2\">\\2</A> " , $string);

/*
        Could someone contribute a mapping to go from
        userdomain.com to <a
href="mailto:userdomain.com">userdomain.com</a>
        and mail to me please, sweedegallatinriver.net
*/

// Adds an image
$string = preg_replace("/(\[IMG\])(\S+?)(\[\/IMG\])/" , "<IMG SRC=\"\\2\"> "
, $string);

// writes in a format good for displaying code - Not tested to any extent,
comment out if desired.
// $string = preg_replace("/(\[code\])(.+?)(\[code\])/" , "<BLOCKQUOTE><font
size=\"1\">code:<\font><HR><pre>\\2</pre><HR></BLOCKQUOTE>" , $string);

//Italics
$string = preg_replace("/(\[i\])/" , "<I>" , $string);
$string = preg_replace("/(\[\/i\])/" , "</I>" , $string);

//Bold
$string = preg_replace("/(\[b\])/" , "<B>" , $string);
$string = preg_replace("/(\[\/b\])/" , "</B>" , $string);

$string = preg_replace("/(\[d\])/" , "<font color=\"$dir_color\">" ,
$string);
$string = preg_replace("/(\[\/d\])/" , "</FONT>" , $string);

// Creates an Unordered List.
$string = preg_replace("/(\[list\])/" , "<UL TYPE=SQUARE>" , $string);
$string = preg_replace("/(\[\/list\])/" , "</UL>" , $string);

// Creates an ordered List 1 = Numbered, Aa = Alabetized, Upper/Lower Ii =
Roman Upper/Lower
$string = preg_replace("/(\[list=)(1|A|I|i|a)(\])/" , "<OL TYPE=\\2>" ,
$string);
$string = preg_replace("/(\[\/list\])/" , "</OL>" , $string);
$string = preg_replace("/(\[\*\])/" , "<LI>" , $string);

// custom, used for my unix help site.
$string = preg_replace("/(\[c\])/" , "<font color=\"$com_color\">" ,
$string);
$string = preg_replace("/(\[\/c\])/" , "</FONT>" , $string);

return $string;
}

• application/ms-tnef attachment: winmail.dat

attached mail follows:

Addressed to: Nitin Narang <nitinNmahindrabt.com>
              php3lists.php.net

** Reply to note from Nitin Narang <nitinNmahindrabt.com> Fri, 05 May 2000 14:27:11 +0530
>
> Hi all,
>
> i'm facing a httpd.conf problem here .....
>
> I'm using virtual hosts and when a user punches www.mysite.com/Games,
> I don't want Apache to look for the directory /Games on the server but
> to invoke a php script in the server root ( /htdocs ).
>
> As shown in an article on phpbuider.com, (
> http://www.phpbuilder.com/columns/tim19990117.php3 )
>
> i added the foll. lines to httpd.conf
>
> <Location /Games> ForceType application/x-httpd-php3 </Location>
>
> but it didn't work. It just forces all /Games files to be treated as
> php but does NO redirection. Infact ideally it shouldn't even look for
> the /Games directory. I want it to redirect all /Games requests to my
> php script in the root.
>

What you need to do is move (or remove) the /Games directory, and
replace it with a file containing php code. Name it 'Games'. Then in
the program /Games you can look at $PATH_INFO to see what is typed in
the URL after /Games. Try phpinfo() to see what is available.

Because of the ForceType apache will execute the file. Without
ForceType if you had a link to :

   /Games.php3/here/are/some/params

Apache will notice that Games.php3 is a file and execute it. $PATH_INFO
will contain '/here/are/some/params';
 

Rick Widmer
Internet Marketing Specialists
www.developersdesk.com

attached mail follows:

Hey all,

I was just wondering it there is any way, this same thing can be done using the .htaccess
instead of the .conf file.

Thanx

Saurabh

php3developersdesk.com wrote:

> Addressed to: Nitin Narang <nitinNmahindrabt.com>
>
>
> ** Reply to note from Nitin Narang <nitinNmahindrabt.com> Fri, 05 May 2000 14:27:11 +0530
> >
> > Hi all,
> >
> > i'm facing a httpd.conf problem here .....
> >
> > I'm using virtual hosts and when a user punches www.mysite.com/Games,
> > I don't want Apache to look for the directory /Games on the server but
> > to invoke a php script in the server root ( /htdocs ).
> >
> > As shown in an article on phpbuider.com, (
> > http://www.phpbuilder.com/columns/tim19990117.php3 )
> >
> > i added the foll. lines to httpd.conf
> >
> > <Location /Games> ForceType application/x-httpd-php3 </Location>
> >
> > but it didn't work. It just forces all /Games files to be treated as
> > php but does NO redirection. Infact ideally it shouldn't even look for
> > the /Games directory. I want it to redirect all /Games requests to my
> > php script in the root.
> >
>
> What you need to do is move (or remove) the /Games directory, and
> replace it with a file containing php code. Name it 'Games'. Then in
> the program /Games you can look at $PATH_INFO to see what is typed in
> the URL after /Games. Try phpinfo() to see what is available.
>
> Because of the ForceType apache will execute the file. Without
> ForceType if you had a link to :
>
> /Games.php3/here/are/some/params
>
> Apache will notice that Games.php3 is a file and execute it. $PATH_INFO
> will contain '/here/are/some/params';
>
>
> Rick Widmer
> Internet Marketing Specialists
> www.developersdesk.com
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

I have the following html page :

<HTML>
<HEAD>
<TITLE> Formular </TITLE>
<BODY>
<DIV ALLIGN="CENTER">
Enter the information bellow
<br>
<BR>
<BR><BR>
<FORM ACTION ="introduce.php3" METHOD="POST">
Name:<BR>
<INPUT TYPE="TEXT" NAME="Name" SIZE="20" MAXLENGTH="20">
<BR><BR>
Phone:<BR>
<INPUT TYPE="TEXT" NAME="Phone" SIZE="9" MAXLENGTH="9">
<BR><BR>
E-MAIL:<BR>
<INPUT TYPE="TEXT" NAME="EMAIL" SIZE="20" MAXLENGTH="50">
<BR><BR>
<INPUT TYPE="SUBMIT" VALUE="Submit">
</FORM>
</DIV>
</BODY>
</HTML>

and the following PHP script :

<?
$server="localhost";
$User="root";
$Pass="";
$DB="example"
$NumeTabel="Persons";

MYSQL_CONNECT($server,$User,$Pass) OR DIE("Unable to select DataBase");
mysql_select_db($DB) or die ("Unable connect to database");

$NumeTabel="Persons";

$query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');

$result=MYSQL_QUERY($query);

PRINT "<CENTER> Your Data has been successfully updated </CENTER>";

MYSQL_CLOSE();
?>

I have MySQL instaled and a database "example " created and I also have a
Sambar Web server installed.
What else do I have to do to get the data from the html page in my database?

Thank you ,
Mircea Circiumarescu

attached mail follows:

Hi!

I think your script is just fine.

I wonder however if your first field is the primary key or somethin .. in which
case
$query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');
will become $query="INSER INTO $NumeTabel VALUES('','$Name','$Phone',$EMAIL');

Also you could use
if($query){
  PRINT "<CENTER> Your Data has been successfully updated </CENTER>";
}else PRINT "<CENTER> Error Executing query </CENTER>";

Mircea Circiumarescu wrote:

> I have the following html page :
>
> <HTML>
> <HEAD>
> <TITLE> Formular </TITLE>
> <BODY>
> <DIV ALLIGN="CENTER">
> Enter the information bellow
> <br>
> <BR>
> <BR><BR>
> <FORM ACTION ="introduce.php3" METHOD="POST">
> Name:<BR>
> <INPUT TYPE="TEXT" NAME="Name" SIZE="20" MAXLENGTH="20">
> <BR><BR>
> Phone:<BR>
> <INPUT TYPE="TEXT" NAME="Phone" SIZE="9" MAXLENGTH="9">
> <BR><BR>
> E-MAIL:<BR>
> <INPUT TYPE="TEXT" NAME="EMAIL" SIZE="20" MAXLENGTH="50">
> <BR><BR>
> <INPUT TYPE="SUBMIT" VALUE="Submit">
> </FORM>
> </DIV>
> </BODY>
> </HTML>
>
> and the following PHP script :
>
> <?
> $server="localhost";
> $User="root";
> $Pass="";
> $DB="example"
> $NumeTabel="Persons";
>
> MYSQL_CONNECT($server,$User,$Pass) OR DIE("Unable to select DataBase");
> mysql_select_db($DB) or die ("Unable connect to database");
>
> $NumeTabel="Persons";
>
> $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');
>
> $result=MYSQL_QUERY($query);
>
> PRINT "<CENTER> Your Data has been successfully updated </CENTER>";
>
> MYSQL_CLOSE();
> ?>
>
> I have MySQL instaled and a database "example " created and I also have a
> Sambar Web server installed.
> What else do I have to do to get the data from the html page in my database?
>
> Thank you ,
> Mircea Circiumarescu
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Thank you, for your answer but i dont know how to make those programs work
toghether.
What should happen if I press Apply on a remote computer that is connected
to internet(or even on my computer) ?
It's all about how the php3 connect to mysql server.Do I have to open a
progrm first?
or it automaticaly open mysql without any program previously opened .

Thank you again .

----- Original Message -----
From: "Saurabh Gupta" <errorzxmail.com>
To: "Mircea Circiumarescu" <mirceadialog-gsm.com>
Cc: "php list" <php3lists.php.net>
Sent: Wednesday, April 05, 2000 1:47 PM
Subject: Re: [PHP3] Useing PHP

> Hi!
>
> I think your script is just fine.
>
> I wonder however if your first field is the primary key or somethin .. in
which
> case
> $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');
> will become $query="INSER INTO $NumeTabel
VALUES('','$Name','$Phone',$EMAIL');
>
>
> Also you could use
> if($query){
> PRINT "<CENTER> Your Data has been successfully updated </CENTER>";
> }else PRINT "<CENTER> Error Executing query </CENTER>";
>
>
> Mircea Circiumarescu wrote:
>
> > I have the following html page :
> >
> > <HTML>
> > <HEAD>
> > <TITLE> Formular </TITLE>
> > <BODY>
> > <DIV ALLIGN="CENTER">
> > Enter the information bellow
> > <br>
> > <BR>
> > <BR><BR>
> > <FORM ACTION ="introduce.php3" METHOD="POST">
> > Name:<BR>
> > <INPUT TYPE="TEXT" NAME="Name" SIZE="20" MAXLENGTH="20">
> > <BR><BR>
> > Phone:<BR>
> > <INPUT TYPE="TEXT" NAME="Phone" SIZE="9" MAXLENGTH="9">
> > <BR><BR>
> > E-MAIL:<BR>
> > <INPUT TYPE="TEXT" NAME="EMAIL" SIZE="20" MAXLENGTH="50">
> > <BR><BR>
> > <INPUT TYPE="SUBMIT" VALUE="Submit">
> > </FORM>
> > </DIV>
> > </BODY>
> > </HTML>
> >
> > and the following PHP script :
> >
> > <?
> > $server="localhost";
> > $User="root";
> > $Pass="";
> > $DB="example"
> > $NumeTabel="Persons";
> >
> > MYSQL_CONNECT($server,$User,$Pass) OR DIE("Unable to select DataBase");
> > mysql_select_db($DB) or die ("Unable connect to database");
> >
> > $NumeTabel="Persons";
> >
> > $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');
> >
> > $result=MYSQL_QUERY($query);
> >
> > PRINT "<CENTER> Your Data has been successfully updated </CENTER>";
> >
> > MYSQL_CLOSE();
> > ?>
> >
> > I have MySQL instaled and a database "example " created and I also have
a
> > Sambar Web server installed.
> > What else do I have to do to get the data from the html page in my
database?
> >
> > Thank you ,
> > Mircea Circiumarescu
> >
> > --
> > PHP 3 Mailing List <http://www.php.net/>
> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> > To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
> > To contact the list administrators, e-mail: php-list-adminlists.php.net
>
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net
>

attached mail follows:

Well,

You can telnet to the host running the mySQL daemon and add, modify, delete
records. Of course, I presume you have the neccessary permissions to do so.

Or you can use the PHP script you wrote.

Hope that was clear ;-)

Saurabh

Mircea Circiumarescu wrote:

> Thank you, for your answer but i dont know how to make those programs work
> toghether.
> What should happen if I press Apply on a remote computer that is connected
> to internet(or even on my computer) ?
> It's all about how the php3 connect to mysql server.Do I have to open a
> progrm first?
> or it automaticaly open mysql without any program previously opened .
>
> Thank you again .
>
> ----- Original Message -----
> From: "Saurabh Gupta" <errorzxmail.com>
> To: "Mircea Circiumarescu" <mirceadialog-gsm.com>
> Cc: "php list" <php3lists.php.net>
> Sent: Wednesday, April 05, 2000 1:47 PM
> Subject: Re: [PHP3] Useing PHP
>
> > Hi!
> >
> > I think your script is just fine.
> >
> > I wonder however if your first field is the primary key or somethin .. in
> which
> > case
> > $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');
> > will become $query="INSER INTO $NumeTabel
> VALUES('','$Name','$Phone',$EMAIL');
> >
> >
> > Also you could use
> > if($query){
> > PRINT "<CENTER> Your Data has been successfully updated </CENTER>";
> > }else PRINT "<CENTER> Error Executing query </CENTER>";
> >
> >
> > Mircea Circiumarescu wrote:
> >
> > > I have the following html page :
> > >
> > > <HTML>
> > > <HEAD>
> > > <TITLE> Formular </TITLE>
> > > <BODY>
> > > <DIV ALLIGN="CENTER">
> > > Enter the information bellow
> > > <br>
> > > <BR>
> > > <BR><BR>
> > > <FORM ACTION ="introduce.php3" METHOD="POST">
> > > Name:<BR>
> > > <INPUT TYPE="TEXT" NAME="Name" SIZE="20" MAXLENGTH="20">
> > > <BR><BR>
> > > Phone:<BR>
> > > <INPUT TYPE="TEXT" NAME="Phone" SIZE="9" MAXLENGTH="9">
> > > <BR><BR>
> > > E-MAIL:<BR>
> > > <INPUT TYPE="TEXT" NAME="EMAIL" SIZE="20" MAXLENGTH="50">
> > > <BR><BR>
> > > <INPUT TYPE="SUBMIT" VALUE="Submit">
> > > </FORM>
> > > </DIV>
> > > </BODY>
> > > </HTML>
> > >
> > > and the following PHP script :
> > >
> > > <?
> > > $server="localhost";
> > > $User="root";
> > > $Pass="";
> > > $DB="example"
> > > $NumeTabel="Persons";
> > >
> > > MYSQL_CONNECT($server,$User,$Pass) OR DIE("Unable to select DataBase");
> > > mysql_select_db($DB) or die ("Unable connect to database");
> > >
> > > $NumeTabel="Persons";
> > >
> > > $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL');
> > >
> > > $result=MYSQL_QUERY($query);
> > >
> > > PRINT "<CENTER> Your Data has been successfully updated </CENTER>";
> > >
> > > MYSQL_CLOSE();
> > > ?>
> > >
> > > I have MySQL instaled and a database "example " created and I also have
> a
> > > Sambar Web server installed.
> > > What else do I have to do to get the data from the html page in my
> database?
> > >
> > > Thank you ,
> > > Mircea Circiumarescu
> > >
> > > --
> > > PHP 3 Mailing List <http://www.php.net/>
> > > To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> > > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> > > To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> > > To contact the list administrators, e-mail: php-list-adminlists.php.net
> >
> >
> > --
> > PHP 3 Mailing List <http://www.php.net/>
> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> > To search the mailing list archive, go to:
> http://www.php.net/mailsearch.php3
> > To contact the list administrators, e-mail: php-list-adminlists.php.net
> >
>
> --
> PHP 3 Mailing List <http://www.php.net/>
> To unsubscribe, send an empty message to php3-unsubscribelists.php.net
> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
> To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
> To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

RE: [PHP3] php editing tool of choice?Anyone used (or even developed?) kphpedit (or whatever it's called).
It looks nice , altough a bit imature

Maarten
  ----- Original Message -----
  From: Robert Collins
  To: php3lists.php.net
  Sent: Friday, May 05, 2000 8:48 PM
  Subject: RE: [PHP3] php editing tool of choice?

  On Windows Ultra Edit is the ultimate editor
  -Syntax Hilighting for just about every language
  -Conversion from Dos to Unix text files
  -Fast and Inexpensive

  and thats just the start

  Robert

  -----Original Message-----
  From: Devon Young [mailto:webmasterabreathoflife.com]
  Sent: Friday, May 05, 2000 11:50 AM
  To: Michael Collins
  Cc: php3lists.php.net
  Subject: Re: [PHP3] php editing tool of choice?

  I don't know what everyone else uses, but I tend to do all my coding in
  notepad when I'm on windows, and Vi or Pico when I'm telnetting to my
  server. I just downloaded an interesting program called HTML-Kit today
  tho, that's supposed to highlight PHP and ASP syntax. I haven';t gotten
  a moment to try it out yet tho.

        - Dev

  Michael Collins wrote:
>
> Are there certain text editing applications that are more commonly used by
> php programmers than others (I am talking about writing the code not
> serving it)? Which are they (the top 3-5)?
>
> Is a "typical" php developer likely to be doing code production on a Linux,
> Unix, Windows workstation or is it really split?
>
> Does anyone in the php community use Macs for production?
>
> Michael

  --
  PHP 3 Mailing List <http://www.php.net/>
  To unsubscribe, send an empty message to php3-unsubscribelists.php.net
  To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
  To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
  To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

>
>For editing code, hell yeah: BBEdit rocks. Global Multi-File Search and
>Replace for those things too small to put in an include file (or that I
>should but haven't yet) is indispensible.
>
>Ain't nothing like it in any of the other tools. (I suppose a Un*x guru
>could manage it with a shell-escape and whip up an inline shell script
>from their editor of choice, but that doesn't really count.)
>

Ultra-Edit in windoze does this no problem.

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

attached mail follows:

Hi

    May I know what's happening to the List ?. I am a regular subscriber and
I don't know why I am getting this mail ?. Can somebody please explain me
about this.

    Thanks.

Regards,
TV Karthick Kumar
Reply to: tvkarthickmailops.com

----- Original Message -----
From: New Mailslot <rheyesheyes.demon.co.uk>
To: <tvkarthickmailops.com>
Sent: Saturday, May 06, 2000 2:17 PM
Subject: Unable to process request

> Your request :-
> Re: [PHP3] Retreiving data
> could not be processed for the following reason :-
> The specified message(s) could not be found
>

attached mail follows:

Regards,
TV Karthick Kumar
Reply to: tvkarthickmailops.com
----- Original Message -----
From: TV Karthick Kumar <tvkarthickmailops.com>
To: Martin Edelius <martin.edeliusspirex.se>
Cc: PHP Mailing list <php3lists.php.net>; Kada Rajasekhar
<rajaspiresys.com>
Sent: Saturday, May 06, 2000 11:05 AM
Subject: Re: [PHP3] Retreiving data

> Hi Martin & List
>
> Now the data retrieval is fine. I am able to retreive all the data
> except the sub category which is selected through a Checkbox. I am getting
> all the results in an Array and after that I am also able to display those
> results on the specified fields (text boxes). But when coming to the
> Checkboxes case, it's the 'item' field that contains the selected values
of
> checkboxes that user has checked and when modifying his page I would like
to
> place / check the same checkboxes that he checked while adding his page /
> profile onto the Database.
>
> While doing this, I need to check the values of the 'item' field and
as
> I am now doing it here, I am getting all the values in a single command:
> echo $row['item'] - here the $row is the result (array).
>
> Now what I want is, I want each and every single result (one by one)
so
> that I can cross check with the values that user has selcted and then
check
> it in the script itself. I think this is the general logical flow which
> everbody would think.
>
> But I am NOT able to do that if I try also ?. How to do that / make it
> checked if the value is already checked by the user ?. I have tried this
in
> line number: 1018 (in the input statement).
>
> I think I have explained clearly here. I am also attaching my script
> (mprofile.php3) with this mail. Please go through it and reply / help me
on
> this.
>
> Also I would like hear suggestions !.
>
> Thanks in advance.
>
> Regards,
> TV Karthick Kumar
> Reply to: tvkarthickmailops.com
>
> Subject: Re: [PHP3] Retreiving data
>
>
> > Hi.
> >
> > > $result=mysql_query($q);
> > > while (mysql_fetch_row($result)) {
> > > echo mysql_result($result,Company); }
> >
> > I wouldn't do it like this. I think that you retrieve row nr 1 with
> > mysql_fetch_row($result) and then the next with
> > mysql_result($result,Company) meaning that you skip the first row. And
> > mysql_result() requires three parameters; the result set, the row, and
the
> > item you want to retrieve (from the manual,
> > http://www.zend.com/manual/function.mysql-result.php):
> >
> > int mysql_result(int result, int row, mixed [field] );
> >
> > Here's how I more or less always handle DB results:
> >
> > $result=mysql_query($q);
> > $Array_Result=mysql_fetch_array($result);
> > while ($Array_Result)
> > {
> > echo $Array_Result["Company"];
> >
> > $Array_Result=mysql_fetch_array($result);
> > }
> >
> > I prefer this way as I can apply the names of the DB fields as indices
to
> > the array. It might not be necessary in your case but it makes it easy
to
> > check if you actually get any results back from the DB query. If you
want
> to
> > supress a warning from the mysql_fetch_array() call (it gets annoyed if
> > there's no result set IIRC) you can add a check on the number of rows
> > returned:
> >
> > $result=mysql_query($q);
> > if(mysql_num_rows($result))
> > {
> > $Array_Result=mysql_fetch_array($result);
> > while ($Array_Result)
> > {
> > echo $Array_Result["Company"];
> >
> > $Array_Result=mysql_fetch_array($result);
> > }
> > }
> >
> > You can use to supress warnings but this check is always useful and
the
> > right way to do it. 8)
> >
> > You might be able to rewrite your query like this as well:
> >
> > $q="select * from profile where company = '$username' password =
> > '$password'";
> >
> > Looking through this query makes me wonder... You say you want to
retrieve
> > the Company but you're still using it in your selection criteria...?
> >
> > HTH.
> >
> >
> > Best regards,
> > Martin Edelius
> >
> > Spirex Digital Design
> > --------------------------------
> > www: http://www.spirex.se
> > Mail: martin.edeliusspirex.se
> > Phone: +46-31-514651, 0708-113711
> > Fax: +46-31-514331
> > Aröds Industriväg 3c
> > S-422 43 Hisings Backa
> > --------------------------------
> > If I haven't got back to you or done what I'm supposed to, let me know
> again
> > as I have too much to do for my own good...
> >
>

• application/octet-stream attachment: mprofile.php3

attached mail follows:

I'm looking for a value-priced PHP/mySQL host. I mostly want to experiment
so I'm not looking for much disk space or bandwidth, just a price of under
$10 a month.

Thanks!

attached mail follows:

If you can live with postgreSQL instead of mySQL try www.f2s.com , can't get
better value than free :)

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

>-----Original Message-----
>From: porterda [mailto:porterdaseattleu.edu]
>Sent: 06 May 2000 10:18
>To: php3lists.php.net
>Subject: [PHP3] PHP Value Hosting
>
>
>I'm looking for a value-priced PHP/mySQL host. I mostly want to experiment
>so I'm not looking for much disk space or bandwidth, just a price of under
>$10 a month.
>
>Thanks!
>
>
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribelists.php.net
>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
>To search the mailing list archive, go to:
>http://www.php.net/mailsearch.php3
>To contact the list
>administrators, e-mail: php-list-adminlists.php.net
>
>

attached mail follows:

Hi

    Here's my code which displays the values of the field - 'item' in the
table 'category'.

    But it displays all the values at a short. What I want is here:

    1. I want to check all the elements in the array with the sub-category
name which I want and then alert the user or make the checkbox checked
automatically through my script hence this program I am doing for Modifying
his profile onto my database.
    2. If I do so, it'll not only be easy for this Modifying profile, but
it'll also be useful for other same kind of application (web).

<?
$db=mysql_pconnect("localhost","root","") or die("Not Connected to the DB");
mysql_select_db("leather",$db);

$q="select * from category";

$result=mysql_query($q);
$m=mysql_fetch_array($result);

while ($m) {
 echo $m[item];
echo "<br>";
$m=mysql_fetch_array($result);
}
mysql_free_result($result);

        -- Please somebody help me on this.

Regards,
TV Karthick Kumar
Reply to: tvkarthickmailops.com

attached mail follows:

Hi,

I have got unixodbc. I configure it well. I have test with isql, and i
connect
to my db2 server.

I have build PHP4RC1. No problem with configure
(--with-unixODBC=/usr/local).
Make and make install OK.

But Apache do not work. When I do a request the the Webserver, Apache do
not
respond. No error anywhere are signaled.

So I have try with PHP 3. (--with-custom-odbc ) The same thing.

Am I stupide? May be...but I would like have help to understand.

Thank you.

• text/x-vcard attachment: Carte pour LIARD DENIS

attached mail follows:

Hi,

     I am having a very very serious problem. I would like to use PHP
mail function to send out a web page mail. Do I have to set up my mail
server first ?? And Does this mail server must be located at the same
location as my web server ???

Thank You

Mark Lo

attached mail follows:

$body =

eregi_replace("([[:alnum:]]+)://([^[:space:]]*)([[:alnum:]#?/&=])",
                     "<a href=\"\\1://\\2\\3\"
target=\"_blank\">\\1://\\2\\3</a>", $body);

    $body =
        eregi_replace("([[:alnum:]]+)([^[:space:]]*)([[:alnum:]])",
                     "<a href=mailto:\\1\\2\\3>\\1\\2\\3</a>", $body);

This had come up on the list - may help

Tarique

=====================================
       B2B Application Service Providers
              http://www.sanisoft.com

 The Vortal for Nagpur http://nagpurcity.net
=====================================

-----Original Message-----
From: Thomas Deliduka <thomasneweve.com>
To: PHP List <php3lists.php.net>
Date: Saturday, May 06, 2000 3:52 AM
Subject: [PHP3] Big Challenge

>Okay, check this out...
>
>I have looked everywhere for this and I don't know if it exists but I can't
>be the only one who has ever wanted this.
>
>let's say I have a guestbook of some sort or I have a a person who writes
in
>there "Hey, check out my website: http://www.geocities.com/blah_blah"
>
>Well, after they submit and it displays online, the website is not linked
so
>someone who wants to go to it must select it and copy it into their
location
>box.
>
>You know where I'm going with this right?
>
>I would LOVE some type of function or code that will do a search through
for
>strings such was http:// or just www. (in case they don't know how to put
>the http:// in there) and then link these items. Same thing with e-mails.
>
>So, anyone got sample code or know where I can find it? I went to
>phpbuilder.com and they don't show the px code anymore and I don't remember
>the website to go find it. Their current list of snippets is lacking.
>
>
>--
>
>Thomas Deliduka
>IT Manager
>--------------------
>New Eve Media
>5629 Westlake Drive
>Galloway, OH 43119-8498
>Phone: 614-870-3098
>Fax: 614-870-7486
>Mobile: 614-537-6445
>
>
>--
>PHP 3 Mailing List <http://www.php.net/>
>To unsubscribe, send an empty message to php3-unsubscribelists.php.net
>To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
>To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
>To contact the list administrators, e-mail: php-list-adminlists.php.net
>

attached mail follows:

What you need is :

http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1567

berber

-----Original Message-----
From: Thomas Deliduka [mailto:thomasneweve.com]
Sent: Saturday, May 06, 2000 5:48 AM
To: PHP List
Subject: [PHP3] Big Challenge

Okay, check this out...

I have looked everywhere for this and I don't know if it exists but I can't
be the only one who has ever wanted this.

let's say I have a guestbook of some sort or I have a a person who writes in
there "Hey, check out my website: http://www.geocities.com/blah_blah"

Well, after they submit and it displays online, the website is not linked so
someone who wants to go to it must select it and copy it into their location
box.

You know where I'm going with this right?

I would LOVE some type of function or code that will do a search through for
strings such was http:// or just www. (in case they don't know how to put
the http:// in there) and then link these items. Same thing with e-mails.

So, anyone got sample code or know where I can find it? I went to
phpbuilder.com and they don't show the px code anymore and I don't remember
the website to go find it. Their current list of snippets is lacking.

-- 
Thomas Deliduka
IT Manager
--------------------
New Eve Media
5629 Westlake Drive
Galloway, OH  43119-8498
Phone:  614-870-3098
Fax:    614-870-7486
Mobile: 614-537-6445
-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribelists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hello Adam,

What a coincidence - this is something I did for a client just yesterday!

>It sounds easy, but the only ways (as far as I know) that flash has of >communicating with the DB is either by opening up a new window (ie >http://www.oursite.com/addpoints.phtml?user=X&points=1393), or by talking to

You are wrong here - use Load variables into location option of action Load Movie use send using POST No new windows opening - you can beat the cheaters by making the filename of the file you use complex

This may sound complex because the option says Load Variables BUT it also sends variables to the script and you need not have any variables to be loaded.

Write in if you want a test fla and php3 file

Tarique

===================================== B2B Application Service Providers http://www.sanisoft.com

The Vortal for Nagpur http://nagpurcity.net =====================================

-----Original Message----- From: Adam Powell <adampowlex.com> To: php3lists.php.net <php3lists.php.net> Date: Friday, May 05, 2000 6:49 PM Subject: [PHP3] passing scores from a flash game

> >Hi there, we want to add some flash games to our web site (which is >primarily PHP run), and have a kind of hi-score table. So somehow we want >the flash game to store a value in our mySQL database (username, score, >time), and then we want to print out the top scores in a table on the web >site. > >It sounds easy, but the only ways (as far as I know) that flash has of >communicating with the DB is either by opening up a new window (ie >http://www.oursite.com/addpoints.phtml?user=X&points=1393), or by talking to >Javascript lurking on the page, and getting that to open up a new window, or >submit a form. > >Now this is fine, but how do we stop cheaters? How can we stop people from >a) typing in the URL directly to gain points b) using a program to edit >hidden variables on the page c) submitting forms from their own hard drives >to score points. Is there any sort of encryption that anybody could >suggest? We were thinking of using HTTP_REFERER to make sure the values >came from the correct page, but our site is beset with the biggest cheating >community this side of Diablo... they will use any methods at their dispoal >to try and score points! They use a client that edits the web page as it is >loaded, thus bypassing the HTTP_REFERER check. > >Any ideas would be welcomed! > >Thanks, >Adam > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

> Hi there, we want to add some flash games to our web site (which is > primarily PHP run), and have a kind of hi-score table. So somehow we want > the flash game to store a value in our mySQL database (username, score, > time), and then we want to print out the top scores in a table on the web > site. > > It sounds easy, but the only ways (as far as I know) that flash has of > communicating with the DB is either by opening up a new window (ie > http://www.oursite.com/addpoints.phtml?user=X&points=1393), or by > talking to > Javascript lurking on the page, and getting that to open up a new > window, or > submit a form.

As far as I know, you can send data directly from a Flash movie to a PHP script by using the 'Load variables' function. That way you can also get data back from the PHP script. (In Flash 4 there is an example of this in the Sample Pages folder, called Form. It uses ASP, but the idea is the same.)

> Now this is fine, but how do we stop cheaters? How can we stop > people from > a) typing in the URL directly to gain points b) using a program to edit > hidden variables on the page c) submitting forms from their own > hard drives > to score points. Is there any sort of encryption that anybody could > suggest? We were thinking of using HTTP_REFERER to make sure the values > came from the correct page, but our site is beset with the > biggest cheating > community this side of Diablo... they will use any methods at > their dispoal > to try and score points! They use a client that edits the web > page as it is > loaded, thus bypassing the HTTP_REFERER check.

To prevent people from adding fake high-scores, when someone plays your Flash game: - first get a unique game number from the server (using Load variables). - let the player play the game. - when the game is finished, send back the game number, score and name. - the php-script should check a database to see if this game number is genuine and hasn't been used before. - if all is OK, the script can add the score to the high-score database. - if not, log the IP so you can try and find out who is trying to cheat your system. Or even better, let them log in before they can play the game, so you know exactly who is trying to cheat.

To prevent people from communicating directly with the script, you can hide the data you need to send (game number and score) inside a large block of random numbers. The larger the block of data, the more time it will cost theme to find out where the real data is. If you combine this random data trick with some simple encription, it will be (almost) impossible to cheat.

I hope this helps,

Arjen Tempel

attached mail follows:

I just found out that the Macromedia site has an article describing the order form example in detail: http://www.macromedia.com/support/flash/interactivity/orderform/

There is also a technote about forms in Flash 4: http://www.macromedia.com/support/flash/ts/documents/f4_form.htm

Arjen Tempel

attached mail follows:

Check out this article :

http://www.weberdev.com/index.php3?GoTo=ViewArticle.php3?ArticleID=11

berber

-----Original Message----- From: Hector M Banda [mailto:hectorneed-info.com] Sent: Saturday, May 06, 2000 1:10 AM To: php3lists.php.net Subject: [PHP3] How to make PHP talk to MYSQL?

Hi all,

I just got the PHP3 and RH to work. Now, how do I make PHP talk to MYSQL?

I'm using MYSQL 3.22.32 and RH 6.0.

Thanks,

--
============================================ 
Hector M Banda
Senior Computer Programmer
Information Systems Department
Imperial Valley College
Imperial Ca, 92251
Phone: 760.355.6105
Fax  : 425.790.6379 
============================================
-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribelists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net
To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi,

I have a sample code:

echo "<html><head></head><body>"; ---processing statements which output some values--- echo "</body>";

now i want to clear the buffer and redirect the user to another location using header. is it possible? because in asp there is an equivalent "response.clear" which clears all the output written, here in this case echo (or print) statements.

srimanth.

-- 
Srimanth R C
Mahindra British Telecom
Mumbai
Phone : 91-22-8529000
Fax   : 91-22-8528959
EMail : srimanthMahindraBT.com

attached mail follows:

try adding the port:

$server="localhost:3306";

don't forget the sign : after ocalhost and 3306

Bye Nicola

-----Messaggio originale----- Da: Mircea Circiumarescu <mirceadialog-gsm.com> A: Saurabh Gupta <errorzxmail.com> Cc: php list <php3lists.php.net> Data: sabato 6 maggio 2000 14.19 Oggetto: Re: [PHP3] Useing PHP

>Thank you, for your answer but i dont know how to make those programs work >toghether. >What should happen if I press Apply on a remote computer that is connected >to internet(or even on my computer) ? >It's all about how the php3 connect to mysql server.Do I have to open a >progrm first? >or it automaticaly open mysql without any program previously opened . > >Thank you again . > > >----- Original Message ----- >From: "Saurabh Gupta" <errorzxmail.com> >To: "Mircea Circiumarescu" <mirceadialog-gsm.com> >Cc: "php list" <php3lists.php.net> >Sent: Wednesday, April 05, 2000 1:47 PM >Subject: Re: [PHP3] Useing PHP > > >> Hi! >> >> I think your script is just fine. >> >> I wonder however if your first field is the primary key or somethin .. in >which >> case >> $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL'); >> will become $query="INSER INTO $NumeTabel >VALUES('','$Name','$Phone',$EMAIL'); >> >> >> Also you could use >> if($query){ >> PRINT "<CENTER> Your Data has been successfully updated </CENTER>"; >> }else PRINT "<CENTER> Error Executing query </CENTER>"; >> >> >> Mircea Circiumarescu wrote: >> >> > I have the following html page : >> > >> > <HTML> >> > <HEAD> >> > <TITLE> Formular </TITLE> >> > <BODY> >> > <DIV ALLIGN="CENTER"> >> > Enter the information bellow >> > <br> >> > <BR> >> > <BR><BR> >> > <FORM ACTION ="introduce.php3" METHOD="POST"> >> > Name:<BR> >> > <INPUT TYPE="TEXT" NAME="Name" SIZE="20" MAXLENGTH="20"> >> > <BR><BR> >> > Phone:<BR> >> > <INPUT TYPE="TEXT" NAME="Phone" SIZE="9" MAXLENGTH="9"> >> > <BR><BR> >> > E-MAIL:<BR> >> > <INPUT TYPE="TEXT" NAME="EMAIL" SIZE="20" MAXLENGTH="50"> >> > <BR><BR> >> > <INPUT TYPE="SUBMIT" VALUE="Submit"> >> > </FORM> >> > </DIV> >> > </BODY> >> > </HTML> >> > >> > and the following PHP script : >> > >> > <? >> > $server="localhost"; >> > $User="root"; >> > $Pass=""; >> > $DB="example" >> > $NumeTabel="Persons"; >> > >> > MYSQL_CONNECT($server,$User,$Pass) OR DIE("Unable to select DataBase"); >> > mysql_select_db($DB) or die ("Unable connect to database"); >> > >> > $NumeTabel="Persons"; >> > >> > $query="INSER INTO $NumeTabel VALUES('NULL','$Name','$Phone',$EMAIL'); >> > >> > $result=MYSQL_QUERY($query); >> > >> > PRINT "<CENTER> Your Data has been successfully updated </CENTER>"; >> > >> > MYSQL_CLOSE(); >> > ?> >> > >> > I have MySQL instaled and a database "example " created and I also have >a >> > Sambar Web server installed. >> > What else do I have to do to get the data from the html page in my >database? >> > >> > Thank you , >> > Mircea Circiumarescu >> > >> > -- >> > PHP 3 Mailing List <http://www.php.net/> >> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net >> > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >> > To search the mailing list archive, go to: >http://www.php.net/mailsearch.php3 >> > To contact the list administrators, e-mail: php-list-adminlists.php.net >> >> >> -- >> PHP 3 Mailing List <http://www.php.net/> >> To unsubscribe, send an empty message to php3-unsubscribelists.php.net >> To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >> To search the mailing list archive, go to: >http://www.php.net/mailsearch.php3 >> To contact the list administrators, e-mail: php-list-adminlists.php.net >> > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net >

attached mail follows:

ive read the faqs, docs, etc, and i just cant get php to compile with imap. ive successfully installed imap 4.7c, and copied c-client.a to /usr/local/lib and linkage.h, mail.h, and rfc822.h to /usr/local/include. i then anally follow the install docs: apache: ./configure --prefix=/www php: ./configure --with-mysql=/usr/local/mysql --with-xml --with-ldap --with-apache=../apache_1.3.12 --enable-debug=no --enable-track-vars=yes --enable-bcmath=yes --with-imap=/usr/local --with-shared-apache (make, make install) apache: ./configure --prefix=/www --activate-module=src/modules/php3/libphp3.a --enable-module=auth --enable-shared=auth --enable-module=imap --enable-shared=imap --enable-module=info --enable-shared=info --enable-module=status --enable-shared=status --enable-module=rewrite --enable-shared=rewrite --enable-module=ssl --enable-shared=ssl (make etc)

everything works, php included, but looking at phpinfo shows no mention of imap whatsoever (except apache's image map module). not one error or warning shows up anywhere at all.

any help, tips, whatever would be greatly appreciated.

fred

attached mail follows:

Dear All,

I have a small form with one textare field. I would like record this field in one MySQL table. This field permits to user uses "ENTER" key to make a new line, and this generate errors when I'll record on MySQL. I try use quoted_printable_decode() and nl2br() functions to resolve this but don't have success!!!

On MySQL log file shows the queries in some lines (because "ENTER" key).

Does anybody have this same problem???????? Can help me??

Tnx!

Best Regards,

_____________________________________________________ Paulo Henrique L. de Castro phlcloreno.net Loreno.net Internet Provider http://www.loreno.net

<< chaodegizpontocompontobr >>

Natal ou sexo?? Sexo!!! Natal tem todo ano...

attached mail follows:

Chris Cameron wrote: > > Is there a way to use a connection from inside a function that was started > outside of the function? Or will I need to make a whole new connection for > that specific function?

You can use the same connection. Your question (or problem) is related to PHP variable scoping not MySQL. You can make connection somewhere in function and use anywhere in function. Check out the "global" keyword for PHP.

-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonumysql.com        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+

attached mail follows:

Hi!

I installed the apache web server 1.3.11 and php 3 on a Windows 98 System, and configured the httpd.conf file of apache:

DirectoryIndex index.html index.php index.php3 and AddType application/x-httpd-php3 .php3 AddType application/x-httpd-php3 .php Action application/x-httpd-php3 /cgi-bin/php.exe

and the php.ini file, but i doesn't work....why???????

When i try to open a "index.php" file the browser returns a Internal Server Error and the log file says: Premature end of script headers: d:/programme/apache group/apache/cgi-bin/php.exe

what havi i made wrong, would anybody help me?!

bye JoE friemigmx.at

attached mail follows:

Hi,

Try adding:

ScriptAlias /php3/ "c:/php3/"

and change:

Action application/x-httpd-php3 /cgi-bin/php.exe to Action application/x-httpd-php3 "/php3/php.exe"

This is assuming you installed into the default directory c:\php3

Regards, Paul

Hi! I installed the apache web server 1.3.11 and php 3 on a Windows 98 System, and configured the httpd.conf file of apache: DirectoryIndex index.html index.php index.php3 and AddType application/x-httpd-php3 .php3 AddType application/x-httpd-php3 .php Action application/x-httpd-php3 /cgi-bin/php.exe and the php.ini file, but i doesn't work....why??????? When i try to open a "index.php" file the browser returns a Internal Server Error and the log file says: Premature end of script headers: d:/programme/apache group/apache/cgi-bin/php.exe

what havi i made wrong, would anybody help me?! bye JoE friemigmx.at

attached mail follows:

hi!

thanks for your tip, but i made another mistake, i copied the php.ini file into \windows\system\ instead of \windows\

bye JoE friemigmx.at

Paul Gardiner schrieb:

> Hi, > > Try adding: > > ScriptAlias /php3/ "c:/php3/" > > and change: > > Action application/x-httpd-php3 /cgi-bin/php.exe to > Action application/x-httpd-php3 "/php3/php.exe" > > This is assuming you installed into the default directory c:\php3 > > Regards, > Paul > > Hi! > I installed the apache web server 1.3.11 and php 3 on a Windows 98 System, > and configured the httpd.conf file of apache: > DirectoryIndex index.html index.php index.php3 > and > AddType application/x-httpd-php3 .php3 > AddType application/x-httpd-php3 .php > Action application/x-httpd-php3 /cgi-bin/php.exe > and the php.ini file, but i doesn't work....why??????? > When i try to open a "index.php" file the browser returns a Internal Server > Error and the log file says: Premature end of script headers: > d:/programme/apache group/apache/cgi-bin/php.exe > > what havi i made wrong, would anybody help me?! > bye JoE > friemigmx.at > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Hi,

if you have access to SCO OpenServer 5 and are able to give me access to the system for debugging purposes, please reply to me in private.

Thanks.

- Sascha

attached mail follows:

> 0x2ad37c2f in php3_intifxus_new_slob (list=0x0) at functions/ifx.ec:4563 > 4563 if(Ifx_slob==NULL) {

It looks like you used a version 9.x ESQL/C as the ifx_*_slob functions are not compiled in on a version 7.x ESQL/C .

We use BLOBS in production sites with IDS 7.22, IDS 7.23 and IDS 7.31, but the modphp3/Informix driver was built with a 7.23 ESQL/C.

In theory you should be OK with ESQL/C 9.x applications against a 7.x database as long as you do not use the 9.x features, but I have not verified it extensively (I tested it on Linux with CSDK 2.40 against IDS 7.30 and it all seems to work identically as with CSDK 2.40 against IDS 2000).

Danny

---

attached mail follows:

Ann Cantelow wrote:

> /* > * Mysql > */ > After a long search we found out that mysql was > running as user root and was reachable locally. Because apache.org was > running bugzilla which requires a mysql account and has it > username/password plaintext in the bugzilla source it was easy to > get a username/passwd for the mysql database.

Thank you for interesting post!

We are in MySQL accepting every security problem as own even if we are not directly guilty in it. Like this case: these were configration which ones gave you root account. In such case we are always discussing, what we can do better in next release of MySQL, how we can avoid user from making these typical mistakes. At moment we prorably will disable running MySQL daemon as root until user don't specify some type of flag "--yes-I-really-want-to-run-it-as-root" or similar.

Also we are working on anoher topics where users making common mistakes or need additional security. Reason in delaying of SSL connections patch is also just verifying everything carefully and making this all really secure.

-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonumysql.com        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+

attached mail follows:

Hi,

I'm using at the moment : PHP4 beta3 Apache 1.3.9 and Oracle 8.1.5 in Client mode - The Oracle Server Datebase is on NT 4.

Linux standard RedHat 6.1

The Web site is quite simple, use PHP for all pages, with many ORACLE read/write functions, some mail outputs, and a small passthru(cat image.gif) but used about 70000/150000 times per day. Yes it's a quite simple explanation of the site ... but you may asked more presice questions if you need details to help with my trouble.

The trouble is that like in apache error_log :

zend_execute.c(1549) : Freeing 0x081D61B0 (12 bytes), script=/home/www/htdocs/send_p.php Last leak repeated 1 time zend_operators.c(824) : Freeing 0x081D6148 (56 bytes), script=/home/www/htdocs/send_p.php Last leak repeated 1 time zend_execute.c(1572) : Freeing 0x081A3270 (12 bytes), script=/home/www/htdocs/send_p.php reg.c(487) : Freeing 0x081E3E10 (1243 bytes), script=/home/www/htdocs/send_p.php zend_execute.c(392) : Freeing 0x081D7178 (12 bytes), script=/home/www/htdocs/send_p.php zend_execute.c(1576) : Freeing 0x081CB538 (17 bytes), script=/home/www/htdocs/send_p.php zend_variables.c(128) : Actual location (location was relayed)

What are the problems exactly there ???? the send_p.php file just send mails about 20 maximum each time... !? may be it's a problem with the rest of this message ...

Other trouble also in apache error_log : sh: Out of virtual memory! sh: Out of virtual memory! FATAL: erealloc(): Unable to allocate 32768 bytes [Tue May 2 18:52:19 2000] [notice] child pid 6122 exit signal Segmentation fault (11) sh: Out of virtual memory! sh: Out of virtual memory! sh: Out of virtual memory! FATAL: erealloc(): Unable to allocate 131072 bytes [Tue May 2 18:57:54 2000] [notice] child pid 6111 exit signal Segmentation fault (11) sh: Out of virtual memory! sh: Out of virtual memory! sh: Out of virtual memory! FATAL: erealloc(): Unable to allocate 65536 bytes [Tue May 2 19:03:30 2000] [notice] child pid 29354 exit signal Segmentation fault (11) FATAL: emalloc(): Unable to allocate 150553 bytes [Tue May 2 19:03:41 2000] [notice] child pid 6104 exit signal Segmentation fault (11)

the sh command might be used in the passthru for the 'cat' (to send a picture) In fact, after about 5 or 6 hours of use the Linux server do not have any free RAM memory (512 Mb) and after completly used the Swap memory, we have that troubles with apache as you can see in the log file ... the trouble seems to be normal if we do not have any more memory ... So if somebody have an idea or directions to look at to explain what append and why the server consume all is memory, we will be very pleased ??

Thanks per advance for you help !!

Regards, Ludo

attached mail follows:

I don't know if anyone else has had this problem but for some reason in any .html file if I do the following <? include("file.php3") ?> the file is not included, but if I do the same thing in a file that has an .php3 extention it works fine. Is there something I'm doing wrong?

Mike

attached mail follows:

You cannot use

<? include("file.php3") ?> directive in a raw HTML file (a file with htmpl extension...)

<? ... ?> are tags parsed only by php.exe

HTML parser does'nt parse them

IT only works in file with php3 extensions

----- Original Message ----- From: "Mike Sears" <neutrinoneutrinostudios.com> To: <php3lists.php.net> Sent: Saturday, May 06, 2000 8:36 PM Subject: [PHP3] include() not working properly

> I don't know if anyone else has had this problem > but for some reason in any .html file if I do the > following <? include("file.php3") ?> the file is not > included, but if I do the same thing in a file that > has an .php3 extention it works fine. Is there > something I'm doing wrong? > > Mike > > -- > PHP 3 Mailing List <http://www.php.net/> > To unsubscribe, send an empty message to php3-unsubscribelists.php.net > To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 > To contact the list administrators, e-mail: php-list-adminlists.php.net > >

attached mail follows:

> I don't know if anyone else has had this problem > but for some reason in any .html file if I do the > following <? include("file.php3") ?> the file is not > included, but if I do the same thing in a file that > has an .php3 extention it works fine. Is there > something I'm doing wrong?

It's not a problem, that's how it's meant to work ;)

html files aren't processed by php, unless specified to do so in the configuration of your server. The idea of php is that you include your HTML and script in the same page, and give it a .php/.php3 extension.

HTH

Cliff Rowley

- while (!asleep) { code(); }

attached mail follows:

Mike Sears wrote: > > I don't know if anyone else has had this problem > but for some reason in any .html file if I do the > following <? include("file.php3") ?> the file is not > included, but if I do the same thing in a file that > has an .php3 extention it works fine. Is there > something I'm doing wrong? >

By default, PHP will not parse .html or .htm files. Instead, files with the .php3 extension _are_ parsed. Basically, PHP is hands-off on non-PHP files. You can adjust PHP to parse .html and .htm files as well, if you like.

-- 
===========================================================================
   Jim Jagielski   [|]   jimjaguNET.com   [|]   http://www.jaguNET.com/
                "Are you suggesting coconuts migrate??"

attached mail follows:

Hidihoo there,

I want to send a mail using PHP3. First I installed the win200 mailserver.., Then i configured the php.ini [mail function] SMTP = localhost sendmail_from = localhost

I tried sending a mail with the following command: mail("email-adress", "test", "test"); but all I get in return is' the message the php died and that I should start it again.

I can send mails with outlook, so I guess the server can't be the problem...

I'd be happy for any clues on how to solve that problem

Thomas

attached mail follows:

Hi! I feel compelled to mention that I was not involved in that excellently skilled piece of work. I'm just a bloke who read it and passed it on thinking people might want to double-check their configurations.

Also I'll mention, no criticism of MySQL security intended! I think it's a neat idea of adding a specific flag for running mysql as root, though. Thanks.

Ann Cantelow

On Sat, 6 May 2000, Tonu Samuel wrote: > Ann Cantelow wrote: > > > /* > > * Mysql > > */ > > After a long search we found out... > >... > We are in MySQL accepting every security problem as own even if we are > not directly guilty in it. Like this case: these were configration > which ones gave you root account. In such case we are always > discussing, what we can do better in next release of MySQL, how we can > avoid user from making these typical mistakes. At moment we prorably > will disable running MySQL daemon as root until user don't specify > some type of flag "--yes-I-really-want-to-run-it-as-root" or similar. >...

attached mail follows:

i tried f2s.com and things work fine. only problem is their setup of the sql admin web interface (PostgresAdmin) isn't set up properly. out of the 5 times i tried that, it worked 1 time (when i first set up my account. always returned errors from postgres. i even emailed them telling them of the problem, but never heard back. another thing, your tables will mysteriously disappear. so back them up. that one time i was able to create a table, and there after kept getting errors dumped back at me when i access PostgresAdmin.. just now... i'm able to get back in with that interface, but no table. gone.

oops i spoke too soon. i just tried an insert and got:

"Warning: Unable to connect to PostgresSQL server: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. in lib.inc.php3 on line 93

Please login at: db.freedom2surf.net/login.php3"

At 12:22 PM 5/6/00 +0100, A Robertson wrote: >If you can live with postgreSQL instead of mySQL try www.f2s.com , can't get >better value than free :) > >Adam Robertson >============== >Web Application Developer >http://www.elitemedia.co.uk > > >-----Original Message----- > >From: porterda [mailto:porterdaseattleu.edu] > >Sent: 06 May 2000 10:18 > >To: php3lists.php.net > >Subject: [PHP3] PHP Value Hosting > > > > > >I'm looking for a value-priced PHP/mySQL host. I mostly want to experiment > >so I'm not looking for much disk space or bandwidth, just a price of under > >$10 a month. > > > >Thanks! > > > > > > > >-- > >PHP 3 Mailing List <http://www.php.net/> > >To unsubscribe, send an empty message to php3-unsubscribelists.php.net > >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net > >To search the mailing list archive, go to: > >http://www.php.net/mailsearch.php3 > >To contact the list > >administrators, e-mail: php-list-adminlists.php.net > > > > > > >-- >PHP 3 Mailing List <http://www.php.net/> >To unsubscribe, send an empty message to php3-unsubscribelists.php.net >To subscribe to the digest, e-mail: php3-digest-subscribelists.php.net >To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 >To contact the list administrators, e-mail: php-list-adminlists.php.net

attached mail follows:

Can anyone help me.

I am new to PHP, but trying to learn things the best i can.

Basically i want to pull in a html page and then strip a few lines from the top and from the bottom.

I am using readfile command, but as for stripping html lines i am not sure.

Am i going about this the right way, and can someone gives me some advice of what to look at?

Thanks

Martin martinvispa.net

attached mail follows:

Hi all,

I have search the php archives trying to find the steps to configure the php3.ini to recognize mysql commands and no luck.

I'm not sure and familiar in how to recompile or reconfigure php so I can query mysql database.

Can someone guide me in how to do this?

OS: LINUX RH 6.0 MYSQL:3.22.32 PHP: Version 3

Everything is working fine as far as my webserver, HP and MYSQL database but I can not query mysql database using PHP.

Please advice ;)

• Next message: php3-digest-helplists.php.net: "php3 Digest 7 May 2000 04:55:02 -0000 Issue 1655"
• Previous message: php3-digest-helplists.php.net: "php3 Digest 6 May 2000 04:55:05 -0000 Issue 1653"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]