php-general Digest 15 Jan 2003 13:42:26 -0000 Issue 1824
Topics (messages 131642 through 131700):
Re: Next and Previous
131642 by: Matt
131645 by: Miguel Brás
Re: PHP & RTF
131643 by: [-^-!-%-
131647 by: Jason Reid
Re: emptying hte array??
131644 by: Jason k Larson
Re: attach image with the mail command?
131646 by: Rick Emery
131655 by: Manuel Lemos
Advanced Search
131648 by: rw.xend.net
131650 by: Andrew Brampton
131651 by: Jean-Christian Imbeault
Re: Trapping PHP errors
131649 by: Jean-Christian Imbeault
131656 by: Michael Sims
Gotchas with Php and Postgresql?
131652 by: John Wells
131657 by: Jason k Larson
Setcookie() and header()
131653 by: J. Alden Gillespy
131658 by: Jason k Larson
131660 by: Michael Sims
131661 by: J. Alden Gillespy
131663 by: Michael Sims
Re: Favorite Email validation routine?
131654 by: Daevid Vincent
Calendar problem
131659 by: menezesd
Save Dialog
131662 by: Richard Rojas
update more "same" fields at the same time
131664 by: Simon
131666 by: Chris Hayes
131667 by: Simon
131668 by: Giannis Vrentzos
131669 by: Simon
131678 by: Giannis Vrentzos
131680 by: Giannis Vrentzos
131682 by: Simon
131684 by: Giannis Vrentzos
131686 by: Simon
131698 by: Giannis Vrentzos
Re: Persistent global data ?
131665 by: Mathias Rockel
Question about $_GET
131670 by: Frank Keessen
131671 by: Danny Shepherd
131672 by: Marek Kilimajer
131673 by: Frank Keessen
131674 by: Jason k Larson
131675 by: Jason k Larson
131676 by: Chris Hayes
131677 by: Marek Kilimajer
131681 by: TomH
131683 by: Jason Wong
131685 by: Rick Emery
Re: MySQL problem with RedHat 8
131679 by: Daniel Elenius
dynamic variables in a while loop?
131687 by: Philipp Hartmann
131690 by: Rick Emery
131693 by: Ford, Mike [LSS]
131700 by: Philipp Hartmann
Can someone help me with this code please?
131688 by: Phil Powell
sending array
131689 by: Danielle van Gladbach
131691 by: Rick Emery
131692 by: Jason Wong
131694 by: Foong
131695 by: Danielle van Gladbach
131696 by: Mark Charette
php obj -> xml ?
131697 by: neko
PHP/Flash Dynamic Graphs?
131699 by: MH
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
>"Miguel Brás" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> That's not the case, I tested it on ID549 and the previous one should be
548 and he still assume -1
Works for me. Are you adding the ?ID=500 to the url? If you don't have
that, then the ID is 0, so you get the 1 and -1.
--- End Message ---
--- Begin Message ---
Let's see
i solved thhe problem...
I did <? echo $ID-1; ?> since I was making the select with WHERE ID = '$ID'
so I get the var $ID.,
Thx for the help of all
Miguel
"Matt" <[EMAIL PROTECTED]> escreveu na mensagem
034901c2bc37$41429160$[EMAIL PROTECTED]">news:034901c2bc37$41429160$[EMAIL PROTECTED]...
> >"Miguel Brás" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > That's not the case, I tested it on ID549 and the previous one should be
> 548 and he still assume -1
>
> Works for me. Are you adding the ?ID=500 to the url? If you don't have
> that, then the ID is 0, so you get the 1 and -1.
>
>
--- End Message ---
--- Begin Message ---
Thanks, Michael. I'll look into it.
-john
=P e p i e D e s i g n s
www.pepiedesigns.com
Providing Solutions That Increase Productivity
Web Developement. Database. Hosting. Multimedia.
On Wed, 15 Jan 2003, Michael Hall wrote:
> I don't know how much use this is for your needs, but I have found Openjade and
> DocBook to be excellent tools for creating RTF files from XML sources. PHP can
> be the scripting language used to tie things together, manipulate HTML/XML etc,
> but basically this solution is "outside" of PHP I suppose.
>
> Mick
>
> Quoting "[-^-!-%-" <[EMAIL PROTECTED]>:
>
> >
> > For those of you with experience in using php for RTF documents.
> >
> > I need help generating RTF Style tags from PHP. I can convert regular text
> > to an RTF document, but the document will
> > display RTF Style tags as regular text (in the RTF document).
> >
> > How do I make the RTF document recognize the RTF Style tags.
> >
> > Any help with code samples, tutorials and/or references, will be greatly
> > appreciated.
> >
> > -john
> >
> > =P e p i e D e s i g n s
> > www.pepiedesigns.com
> > Providing Solutions That Increase Productivity
> >
> > Web Developement. Database. Hosting. Multimedia.
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> ----------------------------------------------------
> MICHAEL HALL Web Development Officer
> Batchelor Institute of Indigenous Tertiary Education
> W: [EMAIL PROTECTED] (08) 8951 8352
> H: [EMAIL PROTECTED] (08) 8953 1442
> ----------------------------------------------------
>
--- End Message ---
--- Begin Message ---
http://www.phpbuilder.com/columns/nair20020523.php3
Looked fairly good when I read thru it a while back. Hope that it might be
able to help.
Jason Reid
[EMAIL PROTECTED]
--
AC Host Canada
www.achost.ca
----- Original Message -----
From: "[-^-!-%-" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 5:53 PM
Subject: [PHP] PHP & RTF
>
> For those of you with experience in using php for RTF documents.
>
> I need help generating RTF Style tags from PHP. I can convert regular text
> to an RTF document, but the document will
> display RTF Style tags as regular text (in the RTF document).
>
> How do I make the RTF document recognize the RTF Style tags.
>
> Any help with code samples, tutorials and/or references, will be greatly
> appreciated.
>
> -john
>
> =P e p i e D e s i g n s
> www.pepiedesigns.com
> Providing Solutions That Increase Productivity
>
> Web Developement. Database. Hosting. Multimedia.
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
That's not going to 'empty' the array it's going to undefine it.
Just overwrite the array with a new empty array like:
$a = array();
That keeps the variable an array variable type and is of course empty.
HTH,
Jason k Larson
Justin French wrote:
on 15/01/03 7:52 AM, Scott Fletcher ([EMAIL PROTECTED]) wrote:
>How to do the proper way of emptying hte array??
>
>Example...
>
>$a[0] = "test1";
>$a[1] = "test2";
>$a[2] = "test3";
>$a[3] = "test4";
>
>$a = ""; <-- Is this hte proper way to do it????
unset($a);
http://php.net/unset
Justin
--- End Message ---
--- Begin Message ---
this class will do all the work you need:
instantiate with CMIMEMail()
then attach with attachfile()
add body with makebody()
send with send()
=============================
/*
* Notes from [EMAIL PROTECTED] 25 Mar 2000:
* This library based idea of Dan Potter
* Improvements: Multi attachmends in one e-mail, ability to post html & plain trext,
up to 3x spe
ed improved.
* USSAGE - mimetype example for attacment
* $m = new CMIMEMail($to,$from,$subject);
* $m->mailbody("This is simply text","<html><body><h1>This is HTML text</h1>");
* $m->attach("example.html","text/html",$filebody);
* $m->attachFile("resume.gif","image/gif");
* $m->send();
* NOTE: if your system have chunk_split function use it.
*******
* To Do:
* 1. Make quoted-printable encoder and use them in makebody;
* 2. Generate right boundaries
* 3. Fix bugs in SMTP send direct futction SMTPsend()
*/
function my_chunk_split($str)
{
$stmp = base64_encode($str);
$len = strlen($stmp);
$out = "";
$done=0;
while( $done<$len ) {
$out.=( $len-$done>76)?substr($strp,$done, 76). "\r\n":substr($strp,$done,
$len-$done). "\r
\n";
$done+=76;
}
return $out;
}
class CMIMEMail {
var $to;
var $from;
var $cc;
var $bcc;
var $subject;
var $boundary = "----=_NextPart_000_0009_01BF95E9.CDFD2060";
var $smtp_headers;
var $filename_real;
var $body_plain;
var $body_html;
var $atcmnt;
var $atcmnt_type;
function CMIMEMail($to,$from,$subject,$cc="",$bcc="",$priority=3) {
$this->to=$to; $this->from=$from; $this->subject=$subject;
$this->priority=$priority; $this->cc=$cc; $this->bcc=$bcc;
}
function mailbody( $plain, $html= "" ) {
$this->body_plain=$plain;
$this->body_html=$html;
}
function attach( $name, $content_type, $data ) {
$this->atcmnt[$name]=$data;
$this->atcmnt_type[$name]=$content_type;
}
function attachfile( $fname, $content_type ) {
$name=ereg_replace( "(.+/)", "",$fname);
$f=fopen($name, "r");
$fsz = filesize($name);
$ftext = fread($f,$fsz);
$this->attach($name,$content_type,$ftext);
fclose($f);
}
function clear() {
unset( $this->atcmnt );
unset( $this->atcmnt_type );
}
function makeheader() {
$out = "From: ".$this->from."\nReply-To: ".$this->from. "\n";
if( $this->cc !="") $out .="Cc: ".$this->cc."\n";
if( $this->bcc !="") $out .="Bcc: ".$this->bcc."\n";
$out.= "MIME-Version: 1.0\nContent-Type: multipart/mixed;\n
boundary=\"".$this->boundary. "\"\
nX-Priority: ".$this->priority. "\n";
return $out;
}
function makebody() {
$boundary2= "----=_NextPart_001_0009_01BF95E9.CDFD2060";
$out= "";
$out= "\n\n".$this->body_plain. "\n\n";
if( $this->body_html!= "" ) {
$out.= "--".$this->boundary. "\nContent-Type: multipart/alternative;\n
boundary=$boundary2\n
\n";
$out.= "$body_plain\n--$boundary2\nContent-Type:
text/plain\nContent-Transfer-Encoding: quot
ed-printable\n\n".$this->body_plain. "\n\n--$boundary2\nContent-Type: text/html\n".
"Content-Transfer-Encoding:
quoted-printable\n\n$this->body_html\n\n--$boundary2--\n"
;
} else {
# $out.= "--".$this->boundary. "\nContent-Type:
text/plain\nContent-Transfer-Encoding: quoted
-printable\n\n".$this->body_plain. "\n\n--".$this->boundary. "\n";
$out.= "--".$this->boundary. "\nContent-Type:
text/plain\nContent-Transfer-Encoding: quoted-
printable\n\n".$this->body_plain. "\n\n";
}
if( ISSET($this->atcmnt_type) )
{
reset( $this->atcmnt_type);
while( list($name, $content_type) = each($this->atcmnt_type) ) {
$out.= "\n--".$this->boundary. "\nContent-Type:
$content_type\nContent-Transfer-Encoding: ba
se64\nContent-Disposition: attachment; filename=\"$name\"\n\n".
chunk_split(base64_encode($this->atcmnt[$name])). "\n";
} }
$out.= "--".$this->boundary. "--\n";
return $out;
}
function send(){
mail( $this->to, $this->subject, $this->makebody(),$this->makeheader() );
}
function sendto($email,$subj="#"){
if( $subj=="#") $subj= $this->subject;
mail( $email, $subj, $this->makebody(),$this->makeheader() );
}
function SMTPsend($host){
$errno=0;$errstr= "";
// $f=fsockopen("127.0.0.1",25,&$erno, &$errstr);
if(!$f) {
$this->send();
} else {
//SNMP commands Not finished yet
echo fgets($f,512);
fputs($f, "HELO host.com\n");
echo fgets($f,512);
fputs($f, "MAIL FROM: ".$this->from. "\n");
echo fgets($f,512);
fputs($f, "RCPT TO: ".$this->to). "\n";
echo fgets($f,512);
fputs($f, "data\n");
echo fgets($f,512);
fputs($f, "From: ".$this->from. "\nTo: ".$this->to.
"\n".$this->makeheader().$this->makebody
(). "\n\n.\n");
fputs($f, "quit\nexit");
fclose($f);
}
}
}
?>
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <>
Sent: Tuesday, January 14, 2003 7:09 PM
Subject: [PHP] attach image with the mail command?
how can i attach an image with the mail command
how do get the image in a variable when i have chosen it with the input type
file?
Harry
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hello,
On 01/14/2003 11:09 PM, Harald Mohring wrote:
how can i attach an image with the mail command
how do get the image in a variable when i have chosen it with the input type
file?
Do you mean attaching an image as a separate file or embed it in the
message so it displays in HTML message?
Either way, you may want to try this class:
http://www.phpclasses.org/mimemessage
--
Regards,
Manuel Lemos
--- End Message ---
--- Begin Message ---
Hello!
Any quick solutions to this:
if (!$city && !$sub_name && !$address && !$pool && !$waterfront && !$waterview
&& !$golf && !$type && !$beds)
{$result = mysql_query("SELECT p.* FROM properties p ORDER by price asc;");}
elseif (!$city && !$sub_name && !$address && !$pool && !$waterfront &&
!$waterview && !$golf && !$type)
{$result = mysql_query("SELECT p.* FROM properties p WHERE beds >= $beds ORDER
by price asc;");}
I don't want to have to write 50 different ifelse statements unless I have to.
Please show me the way to make the search more efficient.
TIA
RW
--- End Message ---
--- Begin Message ---
$sql = 'SELECT p.* FROM properties p WHERE ';
if(isSet($city))
$sql .= 'city = "' . $city . '" AND ';
if(isSet($sub_name ))
$sql .= 'sub_name = "' . $sub_name . '" AND ';
....
//Remove last AND and append 'ORDER by price asc'
mysql_query($sql );
Hope this helps
Andrew
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 4:16 AM
Subject: [PHP] Advanced Search
>
> Hello!
>
> Any quick solutions to this:
>
> if (!$city && !$sub_name && !$address && !$pool && !$waterfront &&
!$waterview
> && !$golf && !$type && !$beds)
> {$result = mysql_query("SELECT p.* FROM properties p ORDER by price
asc;");}
> elseif (!$city && !$sub_name && !$address && !$pool && !$waterfront &&
> !$waterview && !$golf && !$type)
> {$result = mysql_query("SELECT p.* FROM properties p WHERE beds >= $beds
ORDER
> by price asc;");}
>
> I don't want to have to write 50 different ifelse statements unless I have
to.
>
> Please show me the way to make the search more efficient.
>
> TIA
>
> RW
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
[EMAIL PROTECTED] wrote:
I don't want to have to write 50 different ifelse statements unless I have to.
You can add all the boolean fileds in the query and not worry about
doing if's to check them, the DB will automatically find the fields that
match for boolean fields (just make sure to initialize all your booleans
variables first). So
SELECT p.* FROM properties p WHERE beds >= $beds AND pool='$pool' AND
waterfront='$waterfront' AND [other booleans ...] ORDER
by price asc;
Jc
--- End Message ---
--- Begin Message ---
Michael Sims wrote:
My site has a custom error handler (implemented via set_error_handler)
which sends a nicely formatted email including all of the error
details, a variable dump, the contents of the output buffer before the
error occured, and the contents of a call to debug_backtrace, in
addition to logging the error to a file.
If it's not asking too much would you be willing to share that custome
error handler you wrote?
I'm in the process of writing one but wouldn't want to re-invent the
wheel if I didn't have too :)
Jc
--- End Message ---
--- Begin Message ---
On Wed, 15 Jan 2003 13:25:05 +0900, you wrote:
>If it's not asking too much would you be willing to share that custome
>error handler you wrote?
It's a big long so I'm sending it to you off-list. If anyone else is
interested just send me an email off list and I'll send you a copy...
--- End Message ---
--- Begin Message ---
I'm preparing for a large project in which I'm the sole
designer/developer. I've just about made the decision to go with
Postgresql, as part of the project is converting a MS Sql Server db to a
open source db and I think Postgresql provides some features that will
make this port easier.
However, just wondering if there're any "gotchas" I need to consider here.
I'm definitely using PHP to write the app, and I can attest to PHP's
great support for mysql (used it many, many times), but I have no
experience using it with Postgresql.
While I suspect that it's just as easy to work with via PHP as is MySql,
I'm looking for any hardened, trenches-earned wisdom anyone would like to
bestow.
Thanks very much.
John
--- End Message ---
--- Begin Message ---
I'd have to say no regarding any "gotchas". I've been using mySQL,
PostgreSQL, and Oracle via PHP interfaces and only mySQL and PostgreSQL
have proved to work flawlessly. The Oracle stuff does work, but I find
it lacking in some of the simple functionality that mySQL and Postgres
offer.
PHP uses Postgres' pglib for it's interface which puts the stability and
compatability in Postgres' hands, which of course is the best possible
thing to do. So you can rest assured that PHP knows how to talk to
Postgres.
HTH,
Jason k Larson
John Wells wrote:
I'm preparing for a large project in which I'm the sole
designer/developer. I've just about made the decision to go with
Postgresql, as part of the project is converting a MS Sql Server db to a
open source db and I think Postgresql provides some features that will
make this port easier.
However, just wondering if there're any "gotchas" I need to consider here.
I'm definitely using PHP to write the app, and I can attest to PHP's
great support for mysql (used it many, many times), but I have no
experience using it with Postgresql.
While I suspect that it's just as easy to work with via PHP as is MySql,
I'm looking for any hardened, trenches-earned wisdom anyone would like to
bestow.
Thanks very much.
John
--- End Message ---
--- Begin Message ---
After I set a cookie and then send a redirect header, the cookie doesn't
show up, but the browser successfully redirects.
setcookie("test", "blahblah", time() + 1440);
header("Location: http://www.mywebsite.com/login.php";);
However, if I take out the header() statement, then the cookie is
successfully set. Anyone else having this problem?
J. Alden Gillespy (aka Dogga)
Microsoft Beta Tester:
- Office 11
- Content Management Server (CMS) 2002
- Systems Management Server (SMS) 2003
--- End Message ---
--- Begin Message ---
Unless I am mistaken, the typical behavior for most browsers is exactly
as you described. Which is due to the browser receiving a Location
header and acting on it, disregarding any other headers. (ex:
cache/no-cache, cookies, etc)
Anybody care to prove me wrong?
While not the best route, you could alternatively use a meta-refresh for
the redirect. This would give you the chance for the headers to be read
and the cookie created.
Hope that helps,
Jason k Larson
J. Alden Gillespy wrote:
After I set a cookie and then send a redirect header, the cookie doesn't
show up, but the browser successfully redirects.
setcookie("test", "blahblah", time() + 1440);
header("Location: http://www.mywebsite.com/login.php";);
However, if I take out the header() statement, then the cookie is
successfully set. Anyone else having this problem?
J. Alden Gillespy (aka Dogga)
Microsoft Beta Tester:
- Office 11
- Content Management Server (CMS) 2002
- Systems Management Server (SMS) 2003
--- End Message ---
--- Begin Message ---
On Tue, 14 Jan 2003 22:34:49 -0700, you wrote:
>Unless I am mistaken, the typical behavior for most browsers is exactly
>as you described. Which is due to the browser receiving a Location
>header and acting on it, disregarding any other headers. (ex:
>cache/no-cache, cookies, etc)
>
>Anybody care to prove me wrong?
Actually most browsers can handle receiving a cookie and being
redirected in the same response. I have several applications that do
this and I have no problems in later versions of IE, Mozilla,
Netscape, or Opera (all that I can test with).
I would wager that the original poster is using IIS, and I would also
wager that they are running PHP in CGI mode, not ISAPI mode. IIS has
a bug that occurs when a CGI program tries to set a cookie and
redirect in the same response (detailed in Microsoft Knowledge Base
article Q176113), but there is a workaround. I sent a post to this
list back in August of last year which details the workaround:
http://marc.theaimsgroup.com/?l=php-general&m=102929828515647&w=2
If the original post isn't using IIS, then I'm not sure what's
happening.
--- End Message ---
--- Begin Message ---
Accidentally replied to sender instead of list
--------------------------------------
Wow. You hit the nail on the head. :)
I installed PHP on IIS via the executable, so I gather I have one of two
choices:
-- Research your article and see how to work around the problem
OR
-- Use ISAPI. (how do I go about doing this? :)
Thanks again for your help so far.
J. Alden Gillespy (aka Dogga)
Microsoft Beta Tester:
- Office 11
- Content Management Server (CMS) 2002
- Systems Management Server (SMS) 2003
>
>
> -----Original Message-----
> From: Michael Sims [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 15, 2003 1:08 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>
> On Tue, 14 Jan 2003 22:34:49 -0700, you wrote:
>
> >Unless I am mistaken, the typical behavior for most browsers
> is exactly
> >as you described. Which is due to the browser receiving a Location
> >header and acting on it, disregarding any other headers. (ex:
> >cache/no-cache, cookies, etc)
> >
> >Anybody care to prove me wrong?
>
> Actually most browsers can handle receiving a cookie and being
> redirected in the same response. I have several applications that do
> this and I have no problems in later versions of IE, Mozilla,
> Netscape, or Opera (all that I can test with).
>
> I would wager that the original poster is using IIS, and I would also
> wager that they are running PHP in CGI mode, not ISAPI mode. IIS has
> a bug that occurs when a CGI program tries to set a cookie and
> redirect in the same response (detailed in Microsoft Knowledge Base
> article Q176113), but there is a workaround. I sent a post to this
> list back in August of last year which details the workaround:
>
> http://marc.theaimsgroup.com/?l=php-general&m=102929828515647&w=2
>
> If the original post isn't using IIS, then I'm not sure what's
> happening.
--- End Message ---
--- Begin Message ---
On Wed, 15 Jan 2003 01:36:26 -0500, you wrote:
>Wow. You hit the nail on the head. :)
Well, I spent a good day or two hunting the problem down the first
time I ran across it. Spending that much time on something tends to
make it stick in your head. :)
>I installed PHP on IIS via the executable, so I gather I have one of two
>choices:
>
>-- Research your article and see how to work around the problem
>OR
>-- Use ISAPI. (how do I go about doing this? :)
It's been several months since I've tried to use PHP with IIS, but
when I did it was the general consensus that the ISAPI module wasn't
stable enough for production sites. If that's still the case I'd
probably stick with the CGI version. Of course things may have
improved, I haven't been keeping up with the Windows side of things.
Perhaps someone on the php-windows list would have some ISAPI
experiences to share.
If you decide to try and implement the workaround and run into
problems, drop me a line. I have working code examples which deal
with this problem that I'd be happy to share.
--- End Message ---
--- Begin Message ---
I just use a simple Javascript function. I figure if it's remotely
close, then good, if not then it's going to be an invalid email address
most likely anyways:
function emailCheck(str) {
var at="@"
var dot="."
var lat=str.indexOf(at)
var lstr=str.length
var ldot=str.indexOf(dot)
if (str.indexOf(at)==-1){
return false
}
if (str.indexOf(at)==-1 || str.indexOf(at)==0 ||
str.indexOf(at)==lstr){
return false
}
if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 ||
str.indexOf(dot)==lstr){
return false
}
if (str.indexOf(at,(lat+1))!=-1){
return false
}
if (str.substring(lat-1,lat)==dot ||
str.substring(lat+1,lat+2)==dot){
return false
}
if (str.indexOf(dot,(lat+2))==-1){
return false
}
if (str.indexOf(" ")!=-1){
return false
}
return true
}
DÆVID.
"A good friend will come and bail you out of jail...but a true friend
will be sitting next to you in the holding cell, laughing and saying
-'That was fucking awesome!'"
> -----Original Message-----
> From: Manuel Lemos [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 12, 2003 9:30 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: Favorite Email validation routine?
>
>
> Hello,
>
> On 01/13/2003 03:21 AM, Peter Janett wrote:
> > I'm looking for everyone's favorite email syntax validation
> routine. Code
> > that takes an email address and does regex on it to
> determine if it's
> > formatted correctly.
> >
> > I know there are some on phpclasses.org that actually check
> the mx record
> > and server of the domain, but I'm just looking for a good,
> clean and fast
> > email address syntax check.
> >
> > So, what is your favorite bit of code to do that?
>
> This class that I don't know if you seen also comes with
> complex regex
> for simple e-mail address validation:
>
http://www.phpclasses.org/emailvalidation
--
Regards,
Manuel Lemos
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hello friends.
I have two fields in my form. When two dates are entered in these two boxes, I need to
find the diiference in calendar months and remaining days between these two dates.
This "Calendar months and remaining days" is important. The functions that I know do
not work for calendar months.
Can anyone help me and tell me how this could be achieved and are there any PHP
functions to do this?
best regards
Denis
--- End Message ---
--- Begin Message ---
Hi guys,
Is there a way for PHP to invoke the Save Dialog on the client's PC?
And after choosing a filename, save the contents of a TextArea into their
hard drives?
--- Richard ---
--- End Message ---
--- Begin Message ---
Hi,
I have table with six records in it. I can use "while" to display them all,
but in form. Is there any way I can edit all six records, and update them
all with one submit.
TNX
--- End Message ---
--- Begin Message ---
At 10:07 15-1-03, you wrote:
I have table with six records in it. I can use "while" to display them all,
but in form. Is there any way I can edit all six records, and update them
all with one submit.
One of the many ways to do it:
When writing the form, number the fieldnames with the ID's of the items.
Separate name and ID with a clear character like '__'
<input type="text" name="field__531">
<input type="text" name="field__532">
<input type="text" name="field__533">
In the receiving page, split the name again.
Then build a query for every record. I'm not sure whether you can string
multiple queries, separated by a semicolon (;), have a try.
this is a principle code (not working but it shows the idea) for checking
every incoming variable
for [each $key, $value in $_POST]
{if (! strpos('field',$key)==false)
{ $key=explode('__',$key);
$ID=$key[1];
mysql_query(UPDATE mytable SET WHERE ID=$ID)
}
}
--- End Message ---
--- Begin Message ---
"Chris Hayes" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> for [each $key, $value in $_POST]
> {if (! strpos('field',$key)==false)
> { $key=explode('__',$key);
> $ID=$key[1];
> mysql_query(UPDATE mytable SET WHERE ID=$ID)
> }
> }
i cant get this code to work. does anybody have the working code..
tnx
--- End Message ---
--- Begin Message ---
Simon wrote:
Hi,
I have table with six records in it. I can use "while" to display them all,
but in form. Is there any way I can edit all six records, and update them
all with one submit.
TNX
What do you mean with "update more "same" fields at the same time"?Can
you give us an example?
Gvre
--- End Message ---
--- Begin Message ---
> What do you mean with "update more "same" fields at the same time"?Can
> you give us an example?
>
> Gvre
>
<form name="form1" method="post" action="">
<?
$query1 = "SELECT * FROM table where subcat = $_GET[a]";
$result1 = mysql_query($query1);
while($row = mysql_fetch_object($result1))
{
?>
<p>
<input name="textfield" type="text" value="<? echo $row->oid; ?>">
<input name="textfield1" type="text" value="<? echo $row->url; ?>">
</p>
<?
}
?>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
now i want to change values of texfields and update them back to mysql.
--- End Message ---
--- Begin Message ---
Simon wrote:
>>What do you mean with "update more "same" fields at the same time"?Can
>>you give us an example?
>>
>>Gvre
>>
>
>
> <form name="form1" method="post" action="">
>
> <?
>
> $query1 = "SELECT * FROM table where subcat = $_GET[a]";
>
> $result1 = mysql_query($query1);
>
> while($row = mysql_fetch_object($result1))
>
> {
>
> ?>
>
> <p>
>
> <input name="textfield" type="text" value="<? echo $row->oid; ?>">
>
> <input name="textfield1" type="text" value="<? echo $row->url; ?>">
>
> </p>
>
> <?
>
> }
>
> ?>
>
> <p>
>
> <input type="submit" name="Submit" value="Submit">
>
> </p>
>
> </form>
>
> now i want to change values of texfields and update them back to mysql.
>
If you want to update all the records that have subcat = $_GET[a] with
the same values then you can do somethink like this:
$subcat = $_POST['a'];
$qsubcat = $_POST['subcat'];
"update tables set
field1=$_POST['textfield'],field2='$_POST['textfield1']' where
subcat='$qsubcat'"
I don 't know if this query will execute correctly because i don 't know
the datatypes of your table fields.
I prefer writing update and insert php scripts independed from select
pages.It 's easier to read.
--- End Message ---
--- Begin Message ---
Simon wrote:
>>What do you mean with "update more "same" fields at the same time"?Can
>>you give us an example?
>>
>>Gvre
>>
>
>
> <form name="form1" method="post" action="">
>
> <?
>
> $query1 = "SELECT * FROM table where subcat = $_GET[a]";
>
> $result1 = mysql_query($query1);
>
> while($row = mysql_fetch_object($result1))
>
> {
>
> ?>
>
> <p>
>
> <input name="textfield" type="text" value="<? echo $row->oid; ?>">
>
> <input name="textfield1" type="text" value="<? echo $row->url; ?>">
>
> </p>
>
> <?
>
> }
>
> ?>
>
> <p>
>
> <input type="submit" name="Submit" value="Submit">
>
> </p>
>
> </form>
>
> now i want to change values of texfields and update them back to mysql.
>
If you want to update all the records that have subcat = $_GET[a] with
the same values then you can do somethink like this:
$subcat = $_POST['a'];
$qsubcat = $_POST['subcat'];
"update tables set
field1=$_POST['textfield'],field2='$_POST['textfield1']' where
subcat='$qsubcat'"
I don 't know if this query will execute correctly because i don 't know
the datatypes of your table fields.
I prefer writing update and insert php scripts independed from select
pages.It 's easier to read.
--- End Message ---
--- Begin Message ---
> If you want to update all the records that have subcat = $_GET[a] with
> the same values then you can do somethink like this:
>
> $subcat = $_POST['a'];
> $qsubcat = $_POST['subcat'];
>
> "update tables set
> field1=$_POST['textfield'],field2='$_POST['textfield1']' where
> subcat='$qsubcat'"
>
> I don 't know if this query will execute correctly because i don 't know
> the datatypes of your table fields.
> I prefer writing update and insert php scripts independed from select
> pages.It 's easier to read.
>
thing is that i want to update same field 6 times with one mysql query. lets
say i have 6 names in one mysql table. now I wand to update all six of them
with one query.
--- End Message ---
--- Begin Message ---
Simon wrote:
If you want to update all the records that have subcat = $_GET[a] with
the same values then you can do somethink like this:
$subcat = $_POST['a'];
$qsubcat = $_POST['subcat'];
"update tables set
field1=$_POST['textfield'],field2='$_POST['textfield1']' where
subcat='$qsubcat'"
I don 't know if this query will execute correctly because i don 't know
the datatypes of your table fields.
I prefer writing update and insert php scripts independed from select
pages.It 's easier to read.
thing is that i want to update same field 6 times with one mysql query. lets
say i have 6 names in one mysql table. now I wand to update all six of them
with one query.
with the same data or not?
--- End Message ---
--- Begin Message ---
> with the same data or not?
>
not with the same data
--- End Message ---
--- Begin Message ---
Simon wrote:
>>with the same data or not?
>>
>
> not with the same data
>
You can put your data and the primary keys in arrays and exec a loop
but the data[0] must be the data for the id[0],
data[1] must be the data for id[1] etc.
The loop should be something like this:
for (int $i=0; $i<=total_records_select_returned -1; $i++)
update table set field1='$data[$i]' where id=$id[$i];
I 'm not sure for the syntax but the idea is correct.
--- End Message ---
--- Begin Message ---
Hi!
This looks VERY interesting, it seems to be exactly what the Application
Object does for ASP, and thats exactly what I need ... now I just have to
hope that this version is stable enough ...
many thanks !
mathias rockel
----- Original Message -----
From: "Tamas Arpad" <[EMAIL PROTECTED]>
To: "Mathias Rockel" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 6:11 PM
Subject: Re: [PHP] Re: Persistent global data ?
> > So this is the only way I guess ...
> >
> > Do you propose to serialize() the objects in the tree and write that
data
> > into a shared memory block, and then deserialize them at the beginning
of
> > each script that needs the data back into objects ? I would think that
that
> > would impose the same performance penaltys from creating the objects
again
> > (this seems to be what slows php down), only the reading process ist
sped
> > up ... not exactly what I would like, but seems PHP provides no other
> > functionality ...
> >
> > mathias rockel
> There's another way with srm:
> http://www.vl-srm.net/doc/features.application-vars.php
> But I don't know if it's still maintaned.
>
> Arpi
>
--- End Message ---
--- Begin Message ---
Hi All,
Can you please help me with the following problem? I've had code wich was running fine
with php till i've upgraded to PHP version 4.2.3.
The original code line was:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = '$id'";
but it's not working when you have register_globals=Off
So i've read everywhere to use the $_Get:
So the code looks like this:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = $_GET['id']";
But all i'm getting in my browser is:
parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
Can someone please help?
Thanks and regards,
Frank
--- End Message ---
--- Begin Message ---
Try
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
{$_GET['id']}";
HTH
Danny.
----- Original Message -----
From: "Frank Keessen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 10:50 AM
Subject: [PHP] Question about $_GET
Hi All,
Can you please help me with the following problem? I've had code wich was
running fine with php till i've upgraded to PHP version 4.2.3.
The original code line was:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
'$id'";
but it's not working when you have register_globals=Off
So i've read everywhere to use the $_Get:
So the code looks like this:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
$_GET['id']";
But all i'm getting in my browser is:
parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
Can someone please help?
Thanks and regards,
Frank
--- End Message ---
--- Begin Message ---
"SELECT Newsheadline, News, Contact FROM news WHERE Newsid = $_GET[id]";
- removed single quotes
Frank Keessen wrote:
Hi All,
Can you please help me with the following problem? I've had code wich was running fine with php till i've upgraded to PHP version 4.2.3.
The original code line was:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = '$id'";
but it's not working when you have register_globals=Off
So i've read everywhere to use the $_Get:
So the code looks like this:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = $_GET['id']";
But all i'm getting in my browser is:
parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
Can someone please help?
Thanks and regards,
Frank
--- End Message ---
--- Begin Message ---
Thanks, but not working:
The error message:
Error in query: SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
. You have an error in your SQL syntax near '' at line 1
Here are both lines:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
{$_GET['id']}";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
Regards,
Frank
----- Original Message -----
From: "Danny Shepherd" <[EMAIL PROTECTED]>
To: "Frank Keessen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:54 AM
Subject: Re: [PHP] Question about $_GET
> Try
>
> $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
> {$_GET['id']}";
>
> HTH
>
> Danny.
> ----- Original Message -----
> From: "Frank Keessen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 15, 2003 10:50 AM
> Subject: [PHP] Question about $_GET
>
>
> Hi All,
>
> Can you please help me with the following problem? I've had code wich was
> running fine with php till i've upgraded to PHP version 4.2.3.
>
> The original code line was:
>
> $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
> '$id'";
>
> but it's not working when you have register_globals=Off
> So i've read everywhere to use the $_Get:
>
> So the code looks like this:
>
> $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
> $_GET['id']";
>
> But all i'm getting in my browser is:
>
> parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
>
>
> Can someone please help?
>
> Thanks and regards,
>
> Frank
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
'$_GET['id']'";
It looks like here that again $_GET['id'] has an empty value;
Jason k Larson
Frank Keessen wrote:
Thanks, but not working:
The error message:
Error in query: SELECT Newsheadline, News, Contact FROM news WHERE
Newsid =
. You have an error in your SQL syntax near '' at line 1
Here are both lines:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
{$_GET['id']}";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
Regards,
Frank
----- Original Message -----
From: "Danny Shepherd"
To: "Frank Keessen" ;
Sent: Wednesday, January 15, 2003 11:54 AM
Subject: Re: [PHP] Question about $_GET
--- End Message ---
--- Begin Message ---
Forms have two distinct methods. GET and POST. if the form has a
method of POST vars are stored in $_POST, ditto for GET.
Use $_POST['id'] not $_GET['id'] if your form uses the POST method.
HTH,
Jason k Larson
Jason k Larson wrote:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
'$_GET['id']'";
It looks like here that again $_GET['id'] has an empty value;
Jason k Larson
Frank Keessen wrote:
> Thanks, but not working:
>
> The error message:
> Error in query: SELECT Newsheadline, News, Contact FROM news WHERE
> Newsid =
> . You have an error in your SQL syntax near '' at line 1
>
> Here are both lines:
>
> $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
> {$_GET['id']}";
>
>
> $result = mysql_query($query) or die ("Error in query: $query. " .
> mysql_error());
>
> Regards,
>
> Frank
> ----- Original Message -----
> From: "Danny Shepherd"
> To: "Frank Keessen" ;
> Sent: Wednesday, January 15, 2003 11:54 AM
> Subject: Re: [PHP] Question about $_GET
>
--- End Message ---
--- Begin Message ---
At 11:57 15-1-03, Marek Kilimajer wrote:
"SELECT Newsheadline, News, Contact FROM news WHERE Newsid = $_GET[id]";
- removed single quotes
I think that that is a really bad advice.
Let me explain.
For one, the single quotes are not in the way here because the query is
written between double quotes.
Then, leaving out the single quotes like Marek suggests will only work
because PHP is too programmer-friendly.
But the indexes of such arrays should always be quoted, because they are
strings, and not the name of 'constant' values. If you do not quote them
PHP will first try to look up whether you defined id somewhere, as a
constant (with define ('id','value');). Which you did not, so PHP will fail
to find it. Only then PHP will gently assume that since there is no
constant defined with the name id, that you meant 'id'. Valuable processing
time wasted for no reason.
Set error_reporting to ~E_ALL if you do not believe me.
I would support the $_POST suggestion by Jason.
Suggested reading: the 'PHP Bible'.
--- End Message ---
--- Begin Message ---
Chris Hayes wrote:
Let me explain.
For one, the single quotes are not in the way here because the query
is written between double quotes.
Then, leaving out the single quotes like Marek suggests will only work
because PHP is too programmer-friendly.
But the indexes of such arrays should always be quoted, because they
are strings, and not the name of 'constant' values.
But it is within string (double quotes), so the index evaluates as a
string, not as a constant.
If you do not quote them PHP will first try to look up whether you
defined id somewhere, as a constant (with define ('id','value');).
Which you did not, so PHP will fail to find it. Only then PHP will
gently assume that since there is no constant defined with the name
id, that you meant 'id'. Valuable processing time wasted for no reason.
Set error_reporting to ~E_ALL if you do not believe me.
I believe you, but try it first:
<?php
$a=array('id'=> 'Hello world');
echo "$a[id]";
?>
<?php
$a=array('id'=> 'Hello world');
echo "$a['id']";
?>
this is *different*:
<?php
$a=array('id'=> 'Hello world');
echo $a[id];
?>
<?php
$a=array('id'=> 'Hello world');
echo $a['id'];
?>
I would support the $_POST suggestion by Jason.
He got error from php and not mysql,
Suggested reading: the 'PHP Bible'.
--- End Message ---
--- Begin Message ---
Frank,
This is frustrating because there are several things at work here...
-- firstly --
Page data (POST or GET) is ALWAYS 'character' type when received into your
script -- whether or not that's how you use it in your application/database
So most times you need to "settype($id, "integer") in order to use the values
in the particular case of database queries where the data=type is some numeric type
-- secondly --
MySQL query syntax generally _requires_ character data to be 'single quoted',
whereas integers should be unquoted
So if your Newsid field in the MySQLK table structure is character type then use
the single quotes if integer the _unquotes in the $query
((Your error messages imply that this is
likely one of the probs with the code.))
-- lastly --
For some reason (beyond my grasp) the variable substitution in PHP behaves
differently for _simple_ vars ($var) as opposed to _complex_ vars like
$_POST["somevarname"] and $arrayname["$othervar"]
So the conmbined solution to at least give a try
===================================================================
settype($id, "integer"); // assuming that the MySQL field-type is an integer
$id = $_GET['id']; // change to what I called a _simple_ var ;-)
// then place $id in the query as unquoted
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = $id";
Hope that helps,
Tom Henry
Frank Keessen wrote:
Thanks, but not working:
The error message:
Error in query: SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
. You have an error in your SQL syntax near '' at line 1
Here are both lines:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
{$_GET['id']}";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
Regards,
Frank
----- Original Message -----
From: "Danny Shepherd" <[EMAIL PROTECTED]>
To: "Frank Keessen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 11:54 AM
Subject: Re: [PHP] Question about $_GET
Try
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
{$_GET['id']}";
HTH
Danny.
----- Original Message -----
From: "Frank Keessen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 10:50 AM
Subject: [PHP] Question about $_GET
Hi All,
Can you please help me with the following problem? I've had code wich was
running fine with php till i've upgraded to PHP version 4.2.3.
The original code line was:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
'$id'";
but it's not working when you have register_globals=Off
So i've read everywhere to use the $_Get:
So the code looks like this:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
$_GET['id']";
But all i'm getting in my browser is:
parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
Can someone please help?
Thanks and regards,
Frank
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
On Wednesday 15 January 2003 18:57, Frank Keessen wrote:
> Thanks, but not working:
>
> The error message:
> Error in query: SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
> . You have an error in your SQL syntax near '' at line 1
>
> Here are both lines:
>
> $query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
> {$_GET['id']}";
>
>
> $result = mysql_query($query) or die ("Error in query: $query. " .
> mysql_error());
Let's put this straight when referring to items in an array inside a
double-quoted string that is the correct syntax to use. IE:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid =
{$_GET['id']}";
Your problem now is clearly one of SQL syntax as the error states so
explicitly.
If Newsid is not numerical type then you need single quotes around the
expression that it is being compared to. IOW your query should look like:
$query = "SELECT Newsheadline,
News,
Contact
FROM news
WHERE Newsid = '{$_GET['id']}'";
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
If we see the light at the end of the tunnel, it's the light of an
oncoming train.
-- Robert Lowell
*/
--- End Message ---
--- Begin Message ---
Make life easy for yourself:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = ".$_GET['id'];
----- Original Message -----
From: "Frank Keessen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 4:50 AM
Subject: [PHP] Question about $_GET
Hi All,
Can you please help me with the following problem? I've had code wich was running fine
with php till
i've upgraded to PHP version 4.2.3.
The original code line was:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = '$id'";
but it's not working when you have register_globals=Off
So i've read everywhere to use the $_Get:
So the code looks like this:
$query = "SELECT Newsheadline, News, Contact FROM news WHERE Newsid = $_GET['id']";
But all i'm getting in my browser is:
parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
Can someone please help?
Thanks and regards,
Frank
--- End Message ---
--- Begin Message ---
Hi
Again, I already have it! (And it is the one from the distro)
[daniel@p85 daniel]$ rpm -q php-mysql
php-mysql-4.2.2-8.0.5
/daniel
On Wed, 2003-01-15 at 02:19, Larry Brown wrote:
> You need the php-mysql rpm do rpm -q php-mysql
> Get the one from the distro
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -----Original Message-----
> From: Daniel Elenius [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 14, 2003 5:22 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] MySQL problem with RedHat 8
>
> Yes, mysql.so is in /usr/lib/php4. The php.ini file has this in it:
>
> [daniel@p85 etc]$ grep mysql php.ini
> ;extension=php_mysql.dll
> extension=mysql.so
> mysql.allow_persistent = On
> mysql.max_persistent = -1
> mysql.max_links = -1
> ; Default port number for mysql_connect(). If unset, mysql_connect()
> will use
> ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
> mysql.default_port =
> mysql.default_socket =
> ; Default host for mysql_connect() (doesn't apply in safe mode).
> mysql.default_host =
> ; Default user for mysql_connect() (doesn't apply in safe mode).
> mysql.default_user =
> ; Default password for mysql_connect() (doesn't apply in safe mode).
> ; *Any* user with PHP access can run 'echo
> cfg_get_var("mysql.default_password")
> mysql.default_password =
>
>
> /daniel
>
> On Tue, 2003-01-14 at 23:17, Joseph W. Goff wrote:
> > Make sure that the shared module is in the correct directory.
> > Check your php.ini file to make sure but it is most likely at /usr/lib/php4
> > make sure that you have mysql.so
> > ----- Original Message -----
> > From: "Daniel Elenius" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, January 14, 2003 3:58 PM
> > Subject: [PHP] MySQL problem with RedHat 8
> >
> >
> > > Hi!
> > >
> > > I'm trying to connect to my mysql database using something like
> > >
> > > mysql_connect( 'localhost', 'root', 'thepassword' )
> > > or die ( 'Unable to connect to server.' );
> > >
> > > But I get the error message:
> > > Fatal error: Call to undefined function: mysql_connect() in
> > > /home/daniel/public_html/index.php on line 21
> > >
> > > I have:
> > >
> > > [root@p85 /]# rpm -qa |grep sql
> > > php-mysql-4.2.2-8.0.5
> > > mysql-3.23.52-3
> > > mysql-server-3.23.52-3
> > > mysql-devel-3.23.52-3
> > >
> > > and:
> > >
> > > [root@p85 /]# rpm -q php
> > > php-4.2.2-8.0.5
> > >
> > > Someone mentioned these two settings in php.ini, which I tried with no
> > > success:
> > >
> > > register_globals = On
> > > short_open_tag = On
> > >
> > > phpinfo() says that php was compiled with '--with-mysql=shared,/usr'
> > >
> > > Can someone help me please?
> > >
> > > regards,
> > > --
> > > Daniel Elenius <[EMAIL PROTECTED]>
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> --
> Daniel Elenius <[EMAIL PROTECTED]>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Daniel Elenius <[EMAIL PROTECTED]>
--- End Message ---
--- Begin Message ---
Hi everyone.
I am more of an ActionScript person, but I have to do this one in php.
Should
be easy for everyone familiar with php syntax...
Here is what I want to do:
I am getting several variables into a Php Script such as:
help1 = "yes" / "no"
help2 = "yes" / "no"
.
.
.
helpX = "yes" / "no"
I need to check whether the variable is true or false, and according to that
add
1 to a counter variable.
Something like this I'd do in ActionScript, but dont know about php
[CODE]
$i = 0;
While (++$i <= 8) {
if ([help]+$i=="yes"){ // this line produces an error...
$counterYes += counterYes;
}
}
[/CODE]
Do I have to initialize all variables before I can use them in php?
Thank you very, very much for your time and your help!!
Philipp
--- End Message ---
--- Begin Message ---
for($ii=1; $ii<20; $ii++)
{
$helpz = "help$ii";
if(${$helpz} == "yes)
{
}
else
{
}
}
----- Original Message -----
From: "Philipp Hartmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 6:50 AM
Subject: [PHP] dynamic variables in a while loop?
Hi everyone.
I am more of an ActionScript person, but I have to do this one in php.
Should
be easy for everyone familiar with php syntax...
Here is what I want to do:
I am getting several variables into a Php Script such as:
help1 = "yes" / "no"
help2 = "yes" / "no"
.
.
.
helpX = "yes" / "no"
I need to check whether the variable is true or false, and according to that
add
1 to a counter variable.
Something like this I'd do in ActionScript, but dont know about php
[CODE]
$i = 0;
While (++$i <= 8) {
if ([help]+$i=="yes"){ // this line produces an error...
$counterYes += counterYes;
}
}
[/CODE]
Do I have to initialize all variables before I can use them in php?
Thank you very, very much for your time and your help!!
Philipp
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
> -----Original Message-----
> From: Philipp Hartmann [mailto:[EMAIL PROTECTED]]
> Sent: 15 January 2003 12:50
>
> Here is what I want to do:
> I am getting several variables into a Php Script such as:
>
> help1 = "yes" / "no"
> help2 = "yes" / "no"
> .
> .
> .
> helpX = "yes" / "no"
>
> I need to check whether the variable is true or false, and
> according to that
> add
> 1 to a counter variable.
>
> Something like this I'd do in ActionScript, but dont know about php
> [CODE]
> $i = 0;
> While (++$i <= 8) {
> if ([help]+$i=="yes"){ // this line produces an error...
I think you need to read the PHP manual page on variable variables:
http://www.php.net/manual/en/language.variables.variable.php -- and the one
on string operators:
http://www.php.net/manual/en/language.operators.string.php
> $counterYes += counterYes;
I assume this is a typo for $counterYes += 1 ...!
> }
> }
> [/CODE]
>
> Do I have to initialize all variables before I can use them in php?
No -- but, presuming these values are coming from a form, or a query on the
URL, the other thing you need to take account of is the configuration
setting for register_globals. If it's on, then fine, the above will work
with appropriate amendments to suit PHP syntax; if it's off, then you have
to use the $_POST[] or $_GET[] array as appropriate, and in fact the
variable variables stuff is not relevant because the array index is just the
HelpX string.
Cheers!
Mike
---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--- End Message ---
--- Begin Message ---
Thanks everyone!
Works great!
Phil
----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "Philipp Hartmann" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 2:03 PM
Subject: Re: [PHP] dynamic variables in a while loop?
> for($ii=1; $ii<20; $ii++)
> {
> $helpz = "help$ii";
> if(${$helpz} == "yes)
> {
> }
> else
> {
> }
> }
> ----- Original Message -----
> From: "Philipp Hartmann" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 15, 2003 6:50 AM
> Subject: [PHP] dynamic variables in a while loop?
>
>
> Hi everyone.
> I am more of an ActionScript person, but I have to do this one in php.
> Should
> be easy for everyone familiar with php syntax...
>
> Here is what I want to do:
> I am getting several variables into a Php Script such as:
>
> help1 = "yes" / "no"
> help2 = "yes" / "no"
> .
> .
> .
> helpX = "yes" / "no"
>
> I need to check whether the variable is true or false, and according to
that
> add
> 1 to a counter variable.
>
> Something like this I'd do in ActionScript, but dont know about php
> [CODE]
> $i = 0;
> While (++$i <= 8) {
> if ([help]+$i=="yes"){ // this line produces an error...
> $counterYes += counterYes;
> }
> }
> [/CODE]
>
> Do I have to initialize all variables before I can use them in php?
>
> Thank you very, very much for your time and your help!!
> Philipp
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Following is the code that will do a remote scrape of
http://www3.brinkster.com/soa/val/profile/display.asp (which sometimes goes down),
however, it should time out and produce an error after 5 seconds; instead, sometimes,
the entire page (http://valsignalandet.com) which includes this script below, takes up
to 90 seconds to load because of the ASP script locking, in spite of my safeguards.
Can anyone please help; I'm out of ideas.
Thanx
Phil
<?
require_once('/users/ppowell/web/php_global_vars.php');
// OPEN SOCKET CONNECTION TO BRINKSTER SET TO TIMEOUT IN 2 SECONDS
$res = '';
$fp = fsockopen('www3.brinkster.com', 80, &$errno, &$errstr, 2) or die('Oops');
if (!$fp) {
echo "${font}Cannot profiles at this time. <a
href=http://www3.brinkster.com/soa/val/profile/view.asp>Click here</a> or try again
later</font><p>";
} else {
$httpStr = "POST /soa/val/profile/display.asp?showLeftNavBanner=1
HTTP/1.0\r\nAccept: text/*\r\nUser-agent: NC_GET_URL\r\nHost:
www3.brinkster.com:80\r\n\r\n";
fputs($fp, $httpStr);
$start = time();
// DOUBLE TIME SETTING: SET FOR BOTH STREAM TIMEOUT AND FOR DATA LOOPING TIMEOUT TO
// ENSURE THAT THE WHOLE PROCESS IS 5 SECONDS OR IT QUITS
// STREAM COMMANDS DON'T WORK ON VAL BECAUSE PHP VERSION IS TOO OLD - CRAP!
list($phpVersion1, $phpVersion2, $phpVersion3) = explode('.', phpversion());
if ($phpVersion1 >=4 && $phpVersion2 >= 3) {
if (!stream_set_timeout($fp, 5)) echo 'Could not set stream timeout<p>';
if (!stream_set_blocking($fp, 0)) echo 'Could not set stream blocking<p>';
}
$now = $start;
while (!feof($fp) && $now < $start + 5) {
$res .= fgets($fp, 4096);
$now = time();
}
fclose($fp);
}
if (strlen($res) > 0 && $now < $start + 5) {
echo trim(substr($res, strpos($res, '<'), strlen(trim($res))));
} else {
echo "${font}Could not display profiles at this time. <a
href=http://www3.brinkster.com/soa/val/profile/view.asp>Click here</a> or try again
later</font><p>";
}
?>
--- End Message ---
--- Begin Message ---
Hi,
I am trying to send an array from one php to another:
$org["index-A"]=17010000;
$org["index-B"]=12090000;
print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
But if I try to read te array in test2.php, I get "Warning: Variable
passed to each() is not an array ".
Can anyone help me????
Danielle
--- End Message ---
--- Begin Message ---
show us the test1.php code.
show us the test2.php code.
We can't read your mind.
----- Original Message -----
From: "Danielle van Gladbach" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 6:59 AM
Subject: [PHP] sending array
Hi,
I am trying to send an array from one php to another:
$org["index-A"]=17010000;
$org["index-B"]=12090000;
print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
But if I try to read te array in test2.php, I get "Warning: Variable
passed to each() is not an array ".
Can anyone help me????
Danielle
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
On Wednesday 15 January 2003 20:59, Danielle van Gladbach wrote:
> I am trying to send an array from one php to another:
>
> $org["index-A"]=17010000;
> $org["index-B"]=12090000;
>
> print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
>
> But if I try to read te array in test2.php, I get "Warning: Variable
> passed to each() is not an array ".
You can't pass an array thru the URL. What you need to do is serialize() it
then urlencode() it (or maybe rawurlencode()). Then you can put the resulting
string in the URL.
In test2.php you would unserialize() $org ($_GET['org']).
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
E Pluribus Unix
*/
--- End Message ---
--- Begin Message ---
I am not sure you can do it way, here is what i suggest
test2.php?org[index-A]=<?php $org['index-A'] ?>&org[index-B]=<?php
$org['index-B'] ?>......
you need to specify each var in you array in the query path.
Danielle Van Gladbach <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> I am trying to send an array from one php to another:
>
> $org["index-A"]=17010000;
> $org["index-B"]=12090000;
>
> print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
>
> But if I try to read te array in test2.php, I get "Warning: Variable
> passed to each() is not an array ".
>
> Can anyone help me????
> Danielle
>
>
--- End Message ---
--- Begin Message ---
There not much in there because I strip it for testing.
test1.php
<?
$org["index-A"]=17010000;
$org["index-B"]=12090000;
print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
?>
test2.php
<?
while (list ($key, $val) = each($org))
{
print "key=".$key."val".$val."<br>\n";
}
?>
Rick Emery wrote:
> show us the test1.php code.
> show us the test2.php code.
> We can't read your mind.
> ----- Original Message -----
> From: "Danielle van Gladbach" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 15, 2003 6:59 AM
> Subject: [PHP] sending array
>
> Hi,
>
> I am trying to send an array from one php to another:
>
> $org["index-A"]=17010000;
> $org["index-B"]=12090000;
>
> print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
>
> But if I try to read te array in test2.php, I get "Warning: Variable
> passed to each() is not an array ".
>
> Can anyone help me????
> Danielle
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
You know, if you actually looked at the link you've created you'd find your
answer ...
> -----Original Message-----
> From: D.M. van Gladbach [mailto:[EMAIL PROTECTED]]
>
> There not much in there because I strip it for testing.
>
> test1.php
> <?
> $org["index-A"]=17010000;
> $org["index-B"]=12090000;
>
> print "<a href=\"test2.php?org=".$org."\">test2</a><BR>\n";
> ?>
>
> test2.php
> <?
> while (list ($key, $val) = each($org))
> {
> print "key=".$key."val".$val."<br>\n";
> }
> ?>
>
>>
--- End Message ---
--- Begin Message ---
Just wanted some opinions on the best way to produce well-formed xml from a
php object. In my case, I was toying with the idea of a generic way to
product an xml file from a PEAR DataObject - the idea being that a 3rd
party requests data, I extract from mysql using Pear's DataObjects, then
tell that objects to produce xml (or pass it to a transformer or
something).
Links? Ideas? Recommendations from RL experience?
cheers,
neko
--- End Message ---
--- Begin Message ---
Hi,
I want to create dynamic graphs with PHP and Flash for data that changes
constantly (let's say every 2 seconds). The graphs must change visibly in
the browser window without refreshing the page. Is this possible? I have
read most that I could find on MING and searched the web as well, but didn't
have much luck. Is PHP/Flash approach the best?
Any info/scripts/url's would be appreciated.
TX
MH
--- End Message ---
