[PHP] This makes NO SENSE!!!!!
hey-
ok. I have the following code.
?php
if($submit) {
$arradate = explode(/,$date);
$uxdate = mktime(0,0,0,$arradate[0],$arradate[1],$arradate[2]);
print $uxdate;
}
else {
?
form action=strtotime.php method=POST //name of file is
strtotime.php
input type=text name=date size=30
input type=submit name=submit value=submit
?
}
?
the problem: it's printing out -1 when i submit. I know it means something
is wrong, however I can't find an error with this when i have the following
code below working perfectly: [sidenote]: i enter the date into the form
field like this: 1/11/2002
$date1 = 1/11/2002;
$ardate = explode(/,$date1);
$unixdate = mktime(0,0,0,$ardate[0],$ardate[1],$ardate[2]);
print $unixdate . br;
can somebody explain to me why this isn't working??
thanks
chris
p.s. it should return this unix timestamp: 1010725200
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Mailling Lists
snip Look into qmail/ezmlm for a good combination, along with the tied true majordomo list manager. I've been running some large mailing lists using the ezmlm/qmail combo - which easily saturates a T1 connection running just a 350 MHz PII. I'd say mailman. I know sourceforge.net is running mailman on a few lists I'm subscribed to. mailman is fairly easy to setup. Majordomo has had quite a few security issues and isn't really easy. A few large lists I know are running qmail/ezmlm.. lists like BUGTRAQ (securityfocus.com) and the MySQL mailinglist (mysql.com) are running ezmlm. If you plan to use a database, I know ezmlm can be used with one.. I think I remember it's still considered experimental. Bye, B. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Re: Generate Alphabet
Sorry for the late reply but maybe you should take a look at the function
range.
from the manual:
foreach(range('a', 'z') as $letter) {
echo $letter;
}
Jerry
-Original Message-
From: Daniel Harik [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 24, 2001 7:01 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: Generate Alphabet
Hello Fred,
Tuesday, December 25, 2001, 7:55:16 PM, you wrote:
F for ($Character = 65; $Character 91; $Character++)
F {
F echo chr($Character);
F }
F Fred
F Daniel Harik [EMAIL PROTECTED] wrote in message
F [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello Guys,
Just a stupid question how can i make php show from a-z with a for
loop, don't want to make 26 hard coded links
Thank You very much
--
Best regards,
Daniel mailto:[EMAIL PROTECTED]
Thank you
--
Best regards,
Danielmailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
The information contained in this email is confidential and
may be legally privileged. It is intended solely for the
addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any
form of disclosure, production, distribution or any action
taken or refrained from in reliance on it, is prohibited and
may be unlawful. Please notify the sender immediately.
The content of the email is not legally binding unless
confirmed by letter bearing two authorized signatures.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] This makes NO SENSE!!!!!
* Chris Cocuzzo ([EMAIL PROTECTED]) [Dec 27. 2001 03:16]:
hey-
Howdy. With your previous posts on the subject, why do I get the feeling
you're building a time machine? :-)
ok. I have the following code.
?php
if($submit) {
$arradate = explode(/,$date);
$uxdate = mktime(0,0,0,$arradate[0],$arradate[1],$arradate[2]);
print $uxdate;
}
else {
?
form action=strtotime.php method=POST //name of file is
strtotime.php
input type=text name=date size=30
input type=submit name=submit value=submit
?
}
?
the problem: it's printing out -1 when i submit. I know it means something
is wrong, however I can't find an error with this when i have the following
code below working perfectly: [sidenote]: i enter the date into the form
field like this: 1/11/2002
OK this is strange. This works fine on my machine and I get he expected
result: 1010725200
It *appears* to be a specific OS/distribution issue, but this is where
my experience ends. I've seen weird issues like this on systems
where I also see processes suddenly appear to have spawned in the winter
of 1969.
Check out the user notes here:
http://www.php.net/manual/en/function.mktime.php
--
Brian Clark | Avoiding the general public since 1805!
Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8
Perl: The Swiss Army Chainsaw
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: Generate Alphabet
This will only work with PHP 4.1.0 or later.
Consider this example:
$letter = 'a';
$i = 0;
while ($i++ 26) {
print Letter: . $letter++ .\n;
}
regards,
Philip Olson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] MsSQL from FreeBSD
Hello php-world! I'm working on Apache 22, php 4.1.0 and try to work with MsSQL 2000. PHP is configured './configure' '--with-apache=../apache_1.3.22' '--with-mysql' '--with-sybase=/usr/local/freetds' '--enable-track-vars' Everything works fine when using mssq-Functions, except extracting images from db. There is limit on 4096 bytes when i extract data from image field. I've changed php.ini - turned mssql_limits to 100 (instead of 4096), restarted a[pache but problem doesn't seem to disappear. On IIS i t works fine, but what do i miss??? Merry Christmas and Happy New Year, Zliy Pes, http://zliypes.com.ua -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
php-general Digest 27 Dec 2001 10:54:42 -0000 Issue 1076
php-general Digest 27 Dec 2001 10:54:42 - Issue 1076
Topics (messages 78796 through 78829):
FreeType 2 on windows?
78796 by: Brandon Orther
Re: question regarding cookies
78797 by: Erik Price
78802 by: Erik Price
PHP 4.1.1 released (minor update)
78798 by: Derick Rethans
Re: mysql_escape_string
78799 by: Jim Lucas [php]
78800 by: Richard Heyes
linux help
78801 by: Melih Onvural
78807 by: Fred
Warning: Cannot send session cookie
78803 by: David Jackson
78804 by: Michael Sims
78814 by: Jim Lucas [php]
problems with urlencoding
78805 by: nachricht.acre.de
78808 by: Fred
Question
78806 by: Gerard Onorato
fsockopen nntp stalls
78809 by: Fred
78810 by: Rasmus Lerdorf
78811 by: Fred
78813 by: David
Re: Supplied argument is not a valid PostgreSQL result resource
78812 by: Jimmy
Mailling Lists
78815 by: Ben Clumeck
78816 by: Miles Thompson
78817 by: Gerard Onorato
78818 by: Bogdan Stancescu
78822 by: Mark Charette
78824 by: B. van Ouwerkerk
installing php with apache rpm???
78819 by: Duane Douglas
78820 by: Fred
Login and select Query in Mysql
78821 by: Jack
This makes NO SENSE!
78823 by: Chris Cocuzzo
78827 by: Brian Clark
Re: Generate Alphabet
78825 by: Jerry Verhoef (UGBI)
78826 by: Fred
78828 by: Philip Olson
MsSQL from FreeBSD
78829 by: Valentin V. Petruchek
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]
--
---BeginMessage---
How do I get FreeType 2 installed on my WIndowsXP box? Anyone know of
web site with a tutorial?
Thanks
Brandon Orther
WebIntellects Design/Development Manager
[EMAIL PROTECTED]
800-994-6364
www.webintellects.com
---End Message---
---BeginMessage---
Good advice -- I hadn't thought of that (echoing right beneath the
setcookie() function). But then i thought of something else... how can
I echo text before the html tag? So I put a third setcookie()
function above the html tag
setcookie(foo, echobar)
hoping that this would be very simple -- set a cookie with the value of
echobar, then later (in the body of the page) add
echo p$foo/p ;
Well, it didn't work either, unfortunately. echobar didn't appear on
my page. And I'm not getting any errors, either
So the answer to no. 1 is now yes, but the cookie didn't get sent.
No. 2, I tried a sort of test (but the one you suggest gave me an error
message b/c it's trying to echo text in the headers or something).
No. 3, no errors.
I'm still reading the www.php.net page on setcookie()... hoping for
something that says that perhaps my browser is the source of the problem.
Erik
On Wednesday, December 26, 2001, at 04:40 PM, Miles Thompson wrote:
1. Did you just try setting a cookie, plain, with no conditions.
2. Have you tested your conditions, or added a test, equivalent to what
you
do when you set the cookie? In other words, change setcookie to
this
if ($type_sel)
{
setcookie(font[type], $type_sel, time()+3600) ;
echo type_sel: $type_sel;
}
3. Are you getting any errors when you try to set the cookie?
---End Message---
---BeginMessage---
Miles, et al:
I realized my problem today, with the cookies.
While reading the voluminous setcookie() function description (meaning
the user notes at the bottom), I came across a sample script that
[EMAIL PROTECTED] had written to test to see if a browser is working with
cookies correctly. I ran the script and it too proved that cookies were
not being received by my browser (for whatever reason). So, in
semi-frustration, I decided to do something else for a while and come
back to the problem later. I do that a lot.
So later I tried accessing the script that [EMAIL PROTECTED] had written
again, this time from a different computer. Because I was trying the
page out on a non-local computer (previously I had been testing the page
on the localhost -- the webserver itself), I had to enter the official
IP address of the web server, rather than the default 127.0.0.1 for
local hosts.
Sure enough, the script gave me the signal that cookies were working
again. I couldn't believe it. Why was it working on this other
computer but not mine?
Yep, for whatever reason it's because I used the official IP address
this time. I went back to the localhost (the web server computer) and
tried the pages again, both my original script and the one I got from
the setcookie() comments. This time, I was properly prompted as to
whether or not I wanted to
[PHP] passing by reference
I coulnd't figure out the difference between the two:
function foo(){
$x = hello;
return $x;
}
and
function foo(){
$x = hello;
return $x;
}
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] This makes NO SENSE!!!!!
Most probably you have some kind of slashing in there. Check it out by also
echoing $date from php and if nothing looks wrong, take a look at the source
code.
HTH
Bogdan
Chris Cocuzzo wrote:
hey-
ok. I have the following code.
?php
if($submit) {
echo(Input date: $datebr\n);
$arradate = explode(/,$date);
$uxdate = mktime(0,0,0,$arradate[0],$arradate[1],$arradate[2]);
print $uxdate;
}
else {
?
form action=strtotime.php method=POST //name of file is
strtotime.php
input type=text name=date size=30
input type=submit name=submit value=submit
?
}
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] This makes NO SENSE!!!!!
What PHP version do you use(4.1.0?)
Regards,
Andrey Hristov
- Original Message -
From: Bogdan Stancescu [EMAIL PROTECTED]
To: Chris Cocuzzo [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 2:18 PM
Subject: Re: [PHP] This makes NO SENSE!
Most probably you have some kind of slashing in there. Check it out by also
echoing $date from php and if nothing looks wrong, take a look at the source
code.
HTH
Bogdan
Chris Cocuzzo wrote:
hey-
ok. I have the following code.
?php
if($submit) {
echo(Input date: $datebr\n);
$arradate = explode(/,$date);
$uxdate = mktime(0,0,0,$arradate[0],$arradate[1],$arradate[2]);
print $uxdate;
}
else {
?
form action=strtotime.php method=POST file://name of file is
strtotime.php
input type=text name=date size=30
input type=submit name=submit value=submit
?
}
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: Generate Alphabet
I seriously doubt your code works -- have you tested it? I think the code
you submitted will most probably output 1 2 3 4...24 25 26 (spaces are
actually \n's). I never tested it though, so I may be mistaken.
However, with just a few changes we get
$letter='a';
$i=0;
while ($letter'z') {
$letter=Chr(ord($letter)+$i);
$i++;
print($letterbr\n);
}
which should work.
Bogdan
Philip Olson wrote:
Consider this example:
$letter = 'a';
$i = 0;
while ($i++ 26) {
print Letter: . $letter++ .\n;
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] This makes NO SENSE!!!!!
To whom is your question directed? From the looks of it, it seems you're asking me... If that's the case, why? Bogdan Andrey Hristov wrote: What PHP version do you use(4.1.0?) Regards, Andrey Hristov - Original Message - From: Bogdan Stancescu [EMAIL PROTECTED] To: Chris Cocuzzo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 2:18 PM Subject: Re: [PHP] This makes NO SENSE! Most probably you have some kind of slashing in there. Check it out by also echoing $date from php and if nothing looks wrong, take a look at the source code. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] This makes NO SENSE!!!!!
It is for the author of This makes NO SENSE! Regards, Andrey Hristov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Browsers...
Hello, World :-) I've been using the PHP_AUTH_USER and PHP_AUTH_PW, in some scripts, I've had some problems with it in somes Browsers. I tested with a phpinfo() function and the browsers with the problems doesn't appear PHP_AUTH_USER and PHP_AUTH_PW with the respective values. It's like PHP_AUTH_USER and PHP_AUTH_PW doesn't exist. The Script is in a Server (RedHat Box 6.2) with PHP 4.0.4. The script work fine on Macintosh (IE 5.0) and in a NT 4 (IE 5.5) and in Macintosh (Netscape Communicator 4). The script doesn't WORK fine on Win Me (IE 5.5), Mac (Netscape Navigator 4.76). It's very rare because sometimes in the Windows ME (IE 5.5) works fine, and sometimes is not. I've checked the script and play around with it, I think that there's an important problem with the PHP_AUTH_USER is somes browsers that can't see the PHP_AUTH_USER and his value. I've tested the REMOTE_USER and it have the value of PHP_AUTH_USER, but I don't know for how many time will be support the REMOTE_USER, it doesn't appear in the phpinfo() display. Thanks a lot for your time. -- __ Jesus Maria Bianco Troconis (yisu) E-MAIL mailto:[EMAIL PROTECTED] ICQ4792036 / nickname yisu WEBhttp://yisu.net Telefono/Phone +58 (414) 3042346 (Ciudad/City) Caracas, Venezuela Mac, PHP MySQL Rulez. They Kick some ass! __ _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] setlocale on OS X not working
Hi
I'm using following code:
setlocale(LC_ALL, 'german');
$timestamp = time();
$string = strftime('Heute ist %A, der %d. %B %Y. Sie haben diese Seite
um %H Uhr %M aufgerufen.', $timestamp); # in english: today it's %A,
the %d. %B. %Y. You opened this page at %H:%M.
echo $string;
Which works nice on my ISP's Server. On my locale OS X Server it seems
like it wouldn't be able to translate it. I get the correct output but
in english instead of german. AFAIR I need to have some files to be
installed on my system for that function to work correct. Does someone
know where to get those files and where to put them in my system?
best regards
Stefan Rusterholz
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Create a table with more than 1 column
Hi list,
I am in a big trouble. My deadline is coming and I couldn't solve my problem
yet! I have this script that outputs a table that can be seen at
http://www.celebnet.com.br/abc.php
$ultletra = '';
$row = '';
while($resultado = $query-dados()) {
$curletra = $resultado['letra'];
if($curletra != $ultletra) {
if (!empty($row)) {
$row .= /tr\n;
}
$row .= tr\ntd\nimg src=\img/letras/$curletra.gif\
width=\24\ height=\24\\n/td\n/tr\n;
}
$row .= tda
href=\interna.php?cat=$resultado[Nome_Categoria]celebID=$resultado[CelebID
]\.$resultado['Nome_Artistico']./a/td\n;
$ultletra = $curletra;
}
if (!empty($row)) {
$row .= tr\n;
}
SQL is:
SELECT
categorias.Nome_Categoria,celebridades.CelebID,celebridades.Nome_Artistico,
lcase(left(Nome_Artistico,1)) as letra FROM categorias LEFT JOIN
celebridades ON categorias.CategoriaID=celebridades.Categoria WHERE
CategoriaID='1' ORDER BY Nome_Artistico
My problem is that I need to modify the script to output a 3 column table. I
have tried everything but nothing works, and I've tried also all url about
PHP that i could found. Please I'll appreciate any help.
Thank's in advance and happy new year to all!!!
Rodrigo Peres (Brazil)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Hiding URL address
Hiow can i do 2 hide the real Filename / Url of a file? Ive seen it donde in lots of places... i need this 2 show some images and hide the real Location of them Anyone can help me? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MsSQL from FreeBSD
* Valentin V. Petruchek ([EMAIL PROTECTED]) [Dec 27. 2001 05:55]: Hello php-world! Hello. PHP is configured './configure' '--with-apache=../apache_1.3.22' '--with-mysql' '--with-sybase=/usr/local/freetds' '--enable-track-vars' Everything works fine when using mssq-Functions, except extracting images from db. There is limit on 4096 bytes when i extract data from image field. I've changed php.ini - turned mssql_limits to 100 (instead of 4096), restarted a[pache but problem doesn't seem to disappear. In the output of phpinfo(), where it mentions your php.ini file, do you have it in that place? On IIS i t works fine, but what do i miss??? -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 Why is abbreviation such a long word? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] setlocale on OS X not working
* Stefan Rusterholz ([EMAIL PROTECTED]) [Dec 27. 2001 09:13]:
Hi
Hiya
I'm using following code:
setlocale(LC_ALL, 'german');
$timestamp = time();
$string = strftime('Heute ist %A, der %d. %B %Y. Sie haben diese Seite
um %H Uhr %M aufgerufen.', $timestamp); # in english: today it's %A,
the %d. %B. %Y. You opened this page at %H:%M.
echo $string;
Which works nice on my ISP's Server. On my locale OS X Server it seems
like it wouldn't be able to translate it. I get the correct output but
in english instead of german.
The OSX machine doesn't have a definition for `german' but it probably
has one for en_US, for example. Try de or de_DE or de_DE.ISO8859-1
instead of `german' and see if you get what you'd expect. FYI, I've
never used OSX, so I'm flying blind.
AFAIR I need to have some files to be
installed on my system for that function to work correct. Does someone
know where to get those files and where to put them in my system?
On my system, charmaps in /usr/share/i18n/locales and definitions in
/usr/lib/locale, and I would use localedef to build definitions from the
charmaps (I think. I might have those directories reversed.).
I've never used (or seen) OSX, but does it use man? (I'm absolutely not
being a smarta$$ here). If it has man, look at the man pages for
`localedef' and `locale' and that may get you headed in the right
direction.
--
Brian Clark | Avoiding the general public since 1805!
Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8
The gene pool could use a little chlorine.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Create a table with more than 1 column
Rodrigo,
Nice looking page. I'm not going to try and fix your logic, because you've approached
it somewhat
differently than I would. Here's my logic or pseudocode ...
Set max_columns to 3
Set a letter variable
While I have results
While column_count is less than max_columns or letter is the same as old_letter
Create a cell, fill it with data, echo it to screen
Increment the column counter
Set old_letter to this letter
Otherwise
Close the row, echo it
Start a new row, echo it
Reset column counter
Set a letter variable
That's roughly it. I've skipped putting in the cell for the letter graphic, you may
want to do that in the Otherwise block. I've also skipped creation of the initial row,
which
would be done outside the while loop.
I know this can be improved upon to make it more robust, but let's hope it gets you
to your goal.
Merry Christmas - Miles Thompson
On Thursday 27 December 2001 10:22 am, Rodrigo Peres wrote:
Hi list,
I am in a big trouble. My deadline is coming and I couldn't solve my
problem yet! I have this script that outputs a table that can be seen at
http://www.celebnet.com.br/abc.php
$ultletra = '';
$row = '';
while($resultado = $query-dados()) {
$curletra = $resultado['letra'];
if($curletra != $ultletra) {
if (!empty($row)) {
$row .= /tr\n;
}
$row .= tr\ntd\nimg src=\img/letras/$curletra.gif\ width=\24\
height=\24\\n/td\n/tr\n;
}
$row .= tda
href=\interna.php?cat=$resultado[Nome_Categoria]celebID=$resultado[CelebI
D ]\.$resultado['Nome_Artistico']./a/td\n;
$ultletra = $curletra;
}
if (!empty($row)) {
$row .= tr\n;
}
SQL is:
SELECT
categorias.Nome_Categoria,celebridades.CelebID,celebridades.Nome_Artistico,
lcase(left(Nome_Artistico,1)) as letra FROM categorias LEFT JOIN
celebridades ON categorias.CategoriaID=celebridades.Categoria WHERE
CategoriaID='1' ORDER BY Nome_Artistico
My problem is that I need to modify the script to output a 3 column table.
I have tried everything but nothing works, and I've tried also all url
about PHP that i could found. Please I'll appreciate any help.
Thank's in advance and happy new year to all!!!
Rodrigo Peres (Brazil)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MsSQL from FreeBSD
Yes, php.ini is there. You see, there is no mssql section when phpinfo(), but mssql works! As i understood php works with mssql when sybase installed, but sybase has no parameters need to change: Sybase Support enabled Allow Persistent Links Yes Persistent Links 0/unlimited Total Links 0/unlimited Application Name PHP 4.0 Client API Version - Original Message - From: Brian Clark [EMAIL PROTECTED] To: PHP is not a drug. [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 4:59 PM Subject: Re: [PHP] MsSQL from FreeBSD * Valentin V. Petruchek ([EMAIL PROTECTED]) [Dec 27. 2001 05:55]: Hello php-world! Hello. PHP is configured './configure' '--with-apache=../apache_1.3.22' '--with-mysql' '--with-sybase=/usr/local/freetds' '--enable-track-vars' Everything works fine when using mssq-Functions, except extracting images from db. There is limit on 4096 bytes when i extract data from image field. I've changed php.ini - turned mssql_limits to 100 (instead of 4096), restarted a[pache but problem doesn't seem to disappear. In the output of phpinfo(), where it mentions your php.ini file, do you have it in that place? On IIS i t works fine, but what do i miss??? -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 Why is abbreviation such a long word? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] passing by reference
On Thu, 27 Dec 2001, Kancha . wrote:
I coulnd't figure out the difference between the two:
function foo(){
$x = hello;
return $x;
}
and
function foo(){
$x = hello;
return $x;
}
return $x will give you a parser error.
Andi
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Hiding URL address
On Thu, 27 Dec 2001, Matias Banzas wrote: Hiow can i do 2 hide the real Filename / Url of a file? Ive seen it donde in lots of places... i need this 2 show some images and hide the real Location of them Anyone can help me? Create a php script that reads the file and feeds it to the user. In that script you can have some intelligence like referrer-checking, and you should also give the user a correct mime-type for that file in the http-header. -- patrik_wallstrom-foodfight-[EMAIL PROTECTED]+46-709580442 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] php coders in bombay?
hey, just wondering if there are any other hardcore php fanatics in the city of bombay, india? :) if there are, give me a shout :) Regards, Kunal Jhunjhunwala -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Create a table with more than 1 column
I would have done it a different way, but it would look something like that
this code has not been tested and is guaranteed to have bugs :) but it just
to get you started on a different approach.
$ultletra = '';
$row = 'tr';
while($resultado = $query-dados()) {
$curletra = $resultado['letra'];
if($counter++%3==0) {
$row .= /trtr\n;
}
$row .= sprintf(\ntd\nimg src=\img/letras/%s.gif\ width=\24\
height=\24\\n/td,$curletra);
$row .= sprintf(tda
href=\interna.php?cat=%scelebID=%s\%s/a/td\n,urlencode($resultado[N
ome_Categoria]),urlecode($resultado[CelebI
D ]),$resultado['Nome_Artistico']) ;
}
while($counter++%30)
$row .= sprintf(tdnbsp;/tdtdnbsp;/td);
$row.=/tr;
==
Jerry Verhoef
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 27, 2001 4:20 PM
To: Rodrigo Peres; PHP
Subject: Re: [PHP] Create a table with more than 1 column
Rodrigo,
Nice looking page. I'm not going to try and fix your logic, because you've
approached it somewhat
differently than I would. Here's my logic or pseudocode ...
Set max_columns to 3
Set a letter variable
While I have results
While column_count is less than max_columns or letter is the same as
old_letter
Create a cell, fill it with data, echo it to screen
Increment the column counter
Set old_letter to this letter
Otherwise
Close the row, echo it
Start a new row, echo it
Reset column counter
Set a letter variable
That's roughly it. I've skipped putting in the cell for the letter graphic,
you may
want to do that in the Otherwise block. I've also skipped creation of the
initial row, which
would be done outside the while loop.
I know this can be improved upon to make it more robust, but let's hope it
gets you
to your goal.
Merry Christmas - Miles Thompson
On Thursday 27 December 2001 10:22 am, Rodrigo Peres wrote:
Hi list,
I am in a big trouble. My deadline is coming and I couldn't solve my
problem yet! I have this script that outputs a table that can be seen at
http://www.celebnet.com.br/abc.php
$ultletra = '';
$row = '';
while($resultado = $query-dados()) {
$curletra = $resultado['letra'];
if($curletra != $ultletra) {
if (!empty($row)) {
$row .= /tr\n;
}
$row .= tr\ntd\nimg src=\img/letras/$curletra.gif\
width=\24\ height=\24\\n/td\n/tr\n;
}
$row .= tda
href=\interna.php?cat=$resultado[Nome_Categoria]celebID=$resultado[CelebI
D ]\.$resultado['Nome_Artistico']./a/td\n;
$ultletra = $curletra;
}
if (!empty($row)) {
$row .= tr\n;
}
SQL is:
SELECT
categorias.Nome_Categoria,celebridades.CelebID,celebridades.Nome_Artistico,
lcase(left(Nome_Artistico,1)) as letra FROM categorias LEFT JOIN
celebridades ON categorias.CategoriaID=celebridades.Categoria WHERE
CategoriaID='1' ORDER BY Nome_Artistico
My problem is that I need to modify the script to output a 3 column table.
I have tried everything but nothing works, and I've tried also all url
about PHP that i could found. Please I'll appreciate any help.
Thank's in advance and happy new year to all!!!
Rodrigo Peres (Brazil)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
The information contained in this email is confidential and
may be legally privileged. It is intended solely for the
addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any
form of disclosure, production, distribution or any action
taken or refrained from in reliance on it, is prohibited and
may be unlawful. Please notify the sender immediately.
The content of the email is not legally binding unless
confirmed by letter bearing two authorized signatures.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MsSQL from FreeBSD
* Valentin V. Petruchek ([EMAIL PROTECTED]) [Dec 27. 2001 10:28]: Yes, php.ini is there. [...] I've changed php.ini - turned mssql_limits to 100 (instead of 4096), restarted a[pache but problem doesn't seem to disappear. OK, we're talking about Linux, right? I'll bet `cat /proc/sys/fs/file-max` gives you 4096 Try upping the file descriptor limit in /proc/sys/fs/file-max. That may or may not solve the problem; worth a try. How much memory does the client machine (the one you `configure'd) have? -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 The beatings will continue until morale improves. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] This makes NO SENSE!!!!!
Other Vital Info that probably would be helpful?
the code below is on:
Apache 1.3 on Win2K
PHP 4.0.6
the machine this is intended for I believe runs on Linux(not sure what
version), apache 1.3, php 4.0.1pl1
- Original Message -
From: Andrey Hristov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 7:29 AM
Subject: Re: [PHP] This makes NO SENSE!
What PHP version do you use(4.1.0?)
Regards,
Andrey Hristov
- Original Message -
From: Bogdan Stancescu [EMAIL PROTECTED]
To: Chris Cocuzzo [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 2:18 PM
Subject: Re: [PHP] This makes NO SENSE!
Most probably you have some kind of slashing in there. Check it out by
also
echoing $date from php and if nothing looks wrong, take a look at the
source
code.
HTH
Bogdan
Chris Cocuzzo wrote:
hey-
ok. I have the following code.
?php
if($submit) {
echo(Input date: $datebr\n);
$arradate = explode(/,$date);
$uxdate = mktime(0,0,0,$arradate[0],$arradate[1],$arradate[2]);
print $uxdate;
}
else {
?
form action=strtotime.php method=POST file://name of file
is
strtotime.php
input type=text name=date size=30
input type=submit name=submit value=submit
?
}
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Store Image in Access Database
Hi, I'm trying to store a binary file in an access database, I'm using an ole type, and I think that it's getting inserted OK. My problem is that I don't know how to pull it out... How do you select the stuff that's in an ole object out of the database and display it, a jpg, for example. I can't even get the raw data. I've tried converting it to base 16 and inserting it, but I still can't pull it out. I know how to do this in mysql, so posting that won't help. I need to know how to do this with access. Thanks Mike. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Metabse and ODBC Blobs, was [Re: Store Image in Access Database]
Sorry about the previous one, that was a mistake.
I have the following code to insert a blob into an access OLE object field:
if(($prepared_query=MetabasePrepareQuery($database,UPDATE incident_blob SET
data_blob=?, description='new')))
{
$binary_lob=array(
Type=inputfile,
Database=$database,
Error=,
FileName=test.php
);
if(($success=MetabaseCreateLOB($binary_lob,$blob)))
{
MetabaseQuerySetBLOB($database,$prepared_query,1,$blob,data_blob);
if(!MetabaseExecuteQuery($database,$prepared_query))
$error=MetabaseError($database);
MetabaseDestroyLOB($blob);
}
else
{
$error=$binary_lob[Error];
echo Error 1 (CreateLOB): $error\n;
}
MetabaseFreePreparedQuery($database,$prepared_query);
}
else
{
$error=MetabaseError($database);
echo Error 2 (Prepare): $error\n;
}
I can connect and query the database otherwise, and it works fine. The
problem is with the Blobs, that update statement is not getting run. There's
only 1 row in the table, but the description and ole object do not get
updated. If I switch the driver to use mysql as opposed to odbc, it works
fine on an identical table (on linux, not windows). Any ideas?
Mike B.
On Wednesday 26 December 2001 02:49 pm, Manuel Lemos wrote:
Hello,
Mike Baranski wrote:
Hi, I'm trying to store a binary file in an access database, I'm using an
ole type, and I think that it's getting inserted OK. My problem is that
I don't know how to pull it out... How do you select the stuff that's in
an ole object out of the database and display it, a jpg, for example. I
can't even get the raw data. I've tried converting it to base 16 and
inserting it, but I still can't pull it out. I know how to do this in
mysql, so posting that won't help. I need to know how to do this with
access.
If you are using ODBC, you may want to try Metabase because it supports
BLOB fields with any ODBC driver. Metabase is Open Source and is freely
available here.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] setlocale on OS X not working
Thanks for your help, but it doesn't work either :-(
Am Donnerstag den, 27. Dezember 2001, um 16:12, schrieb Brian Clark:
* Stefan Rusterholz ([EMAIL PROTECTED]) [Dec 27. 2001 09:13]:
Hi
Hiya
I'm using following code:
setlocale(LC_ALL, 'german');
$timestamp = time();
$string = strftime('Heute ist %A, der %d. %B %Y. Sie haben diese Seite
um %H Uhr %M aufgerufen.', $timestamp); # in english: today it's %A,
the %d. %B. %Y. You opened this page at %H:%M.
echo $string;
Which works nice on my ISP's Server. On my locale OS X Server it seems
like it wouldn't be able to translate it. I get the correct output but
in english instead of german.
The OSX machine doesn't have a definition for `german' but it probably
has one for en_US, for example. Try de or de_DE or de_DE.ISO8859-1
instead of `german' and see if you get what you'd expect. FYI, I've
never used OSX, so I'm flying blind.
AFAIR I need to have some files to be
installed on my system for that function to work correct. Does someone
know where to get those files and where to put them in my system?
On my system, charmaps in /usr/share/i18n/locales and definitions in
/usr/lib/locale, and I would use localedef to build definitions from the
charmaps (I think. I might have those directories reversed.).
I've never used (or seen) OSX, but does it use man? (I'm absolutely not
being a smarta$$ here). If it has man, look at the man pages for
`localedef' and `locale' and that may get you headed in the right
direction.
I did that. For localedef it hasn't an entry. But for locale it has one.
I don't think that's what you expectet (it seems to belong to perl)
locale(3)Perl Programmers Reference Guide locale(3)
NAME
locale - Perl pragma to use and avoid POSIX locales for
built-in operations
SYNOPSIS
@x = sort @y; # ASCII sorting order
{
use locale;
@x = sort @y; # Locale-defined sorting order
}
@x = sort @y; # ASCII sorting order again
DESCRIPTION
This pragma tells the compiler to enable (or disable) the
use of POSIX locales for built-in operations (LC_CTYPE for
regular expressions, and LC_COLLATE for string compari-
son). Each use locale or no locale affects statements
to the end of the enclosing BLOCK.
See the perllocale manpage for more detailed information
on how Perl supports locales.
2000-03-30 perl v5.6.0
Perhaps this information helps you to help me further:
Mac OS X is based on FreeBSD 3.0 (AFAIR).
Re: [PHP] setlocale on OS X not working
* Stefan Rusterholz ([EMAIL PROTECTED]) [Dec 27. 2001 11:30]: I did that. For localedef it hasn't an entry. But for locale it has one. I don't think that's what you expectet (it seems to belong to perl) Then you need to find out how to `compile' locale definitions for your system. locale(3)Perl Programmers Reference Guide locale(3) Oh no no. g man 1 locale Does that give you anything? (I'm guessing it would have picked that up first if it existed). (~)% man locale | head Reformatting locale(1), please wait... LOCALE(1)Debian GNU/Linux LOCALE(1) NAME locale - Get locale-specific information. SYNOPSIS locale [ -a | -m] That's the one I was talking about.. Is there a `locale' package you can install for OSX? (There is for my system.) -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 Every morning is the dawn of a new error. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Store Image in Access Database
Hi, You would pull it out using a normal SELECT SQL statement.. But I'm just writing this mail to warn agaisnt using a Access Database to store images. I used to do this for a ASP site, allowing users to upload their own images, and for everyone to view them. Anyway the database started running into troubles, every other day I had to replace the database with a backup due to it getting corrupted, and once the access database reached 5mb I spent more time replacing it then it was actually being used. So I changed my solution to one where the images are uploaded and stored on the webserver and infomation about the images still stored in the access database. This method worked FAR better, and since then I haven't had to replace the access database. Just my opinion Andrew - Original Message - From: Mike Baranski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 4:16 PM Subject: [PHP] Store Image in Access Database Hi, I'm trying to store a binary file in an access database, I'm using an ole type, and I think that it's getting inserted OK. My problem is that I don't know how to pull it out... How do you select the stuff that's in an ole object out of the database and display it, a jpg, for example. I can't even get the raw data. I've tried converting it to base 16 and inserting it, but I still can't pull it out. I know how to do this in mysql, so posting that won't help. I need to know how to do this with access. Thanks Mike. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: Login and select Query in Mysql
It is usually wise to search through old posts before posting a question
that's been answered before all over again. Here is a previous answer given
by myself to someone who asked the same question as you:
The easiest way is to use cookies.
=CODE
?php
require 'auth_functions.php';
if (authenticateUser($form_username, $form_password)){
setcookie(cookie_passwd,$form_password);
setcookie(cookie_user,$form_username);
header(Location:http://$SERVER/index2.php;);
exit();
} else {
header(Location:http://$SERVER/error.html;);
}
?
This code takes in input from a form as simple as this:
form name=form1 method=post action=index.php
Login: input type=text name=form_usernamebr
Password:
input type=password name=form_password br
input type=submit name=Submit value=Login
/form
Checks it against the database values using the function 'authenticateUser',
returns TRUE or FALSE.
If true, sends the user onto the correct page, if false, sends them to some
error page.
Now, in each other file, you'll need to check the cookies. The values for
the cookies are sent automatically by the user's browser. In this
particular examples, the cookie variables are named '$cookie_user' and
'$cookie_passwd'. You can see in the example how those are set.
You will check the cookies using the exact same 'authenticateUser' function.
Except in these files, you will use the cookie values as the parameters to
the function instead of the form values. I.e.
authenticateUser($cookie_user,$cookie_passwd);
Hope this helps.
Best regards,
Jeremy Reed
Jack [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Dear all
I want to provide a login page to the user when they want to visit my
website, i got no idea what should i used.
First i have a login.php page which got two input box, one for username
and
one for password.
Then i have a login table with mysql database which contain the valid user
and password.
And i have a index.htm which let the user browse my website.This index.htm
is consist of three frame, top, left and main. Each frame contain
different
page(.php).
Task :
User will login first through login.php, then the username and password
provided by user will need to match the table called login.
Once the username and password is correct, the username will be hold in a
place for the further use inside the website(eg: when user want to see the
leave history records, it will only show it's own record by select the
query
using the username section).
then user will direct into index.htm.
Could someone pls give me a idea how i should make this system work??
Thx
Jack
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] setlocale on OS X not working
I forgot to mail that to the mailinglist too... * Stefan Rusterholz ([EMAIL PROTECTED]) [Dec 27. 2001 11:30]: I did that. For localedef it hasn't an entry. But for locale it has one. I don't think that's what you expectet (it seems to belong to perl) Then you need to find out how to `compile' locale definitions for your system. locale(3)Perl Programmers Reference Guide locale(3) Oh no no. g man 1 locale Does that give you anything? (I'm guessing it would have picked that up first if it existed). No, it doesn't :-( and locale produces locale: Command not found That's the one I was talking about.. Is there a `locale' package you can install for OSX? (There is for my system.) There is one, but not for PHP, only for the system (which is actually multilingual and able to change language during runtime) Thank you for your help although... best regards Stefan Rusterholz -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: File Upload Question...
Your first question. To see that the file uploaded successfully using the
web browser, one would have to have access to your computer's file system.
In her book, she used this merely as an example to show that the file had,
indeed, been uploaded. This should not be used as something that you allow
your web users to do to confirm the receipt of the file. Instead, send them
an email, show them a directory listing, etc.
Your second question, the name given to the image should be whatever the
*value* of the variable used to copy() it. You should, however, come up
with a naming scheme that allows you to ensure that you do not overwrite any
uploaded files--especially if you expect a lot of traffic and/or users using
this feature.
Your third question, the mime-type pjpg is functionally the same as the
mime-type jpeg. There's nothing you need to worry about there.
Anthony Ritter [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Merry Christmas everybody.
I am using MS Windows 98 with Apache and following an example in Julie
Meloni's PHP - Fast and Easy (Chapter 10) in which she describes file
uploading using PHP on page 168-174.
She has two files:
1) an html form to receive the input from the user for the file to be
uploaded
2) a .php script to accept the variable and use the copy() function.
.
The scripts are as follows:
(html form)
HTML
HEAD
TITLEUpload a File/TITLE
/HEAD
BODY
H1Upload a File/H1
FORM METHOD=post ACTION=do_upload.php ENCTYPE=multipart/form-data
pstrongFile to Upload:/strongbr
INPUT TYPE=file NAME=img1 SIZE=30/p
PINPUT TYPE=submit NAME=submit VALUE=Upload File/p
/FORM
/BODY
/HTML
(.php script)
?
if ($img1_name != ) {
@copy($img1, c:/Program Files/Apache Group/Apache/htdocs/$img1_name)
or die(Couldn't copy the file.);
} else {
die(No input file specified);
}
?
HTML
HEAD
TITLESuccessful File Upload/TITLE
/HEAD
BODY
H1Success!/H1
PYou sent: ? echo $img1_name; ?, a ? echo $img1_size; ?
byte file with a mime type of ? echo $img1_type; ?./P
/BODY
/HTML
..
My questions:
I am able to upload a file from My Documents to the Apache server however
in her book, she describes that the user can verify that the file was
uploaded to the server by going to:
File/ Open Page / in ones web browser to navigate through their filesystem
to
find the file that was uploaded. There is a screenshot in the book that
shows the .jpeg file on the screen with the browser at:
file:///C/Apache/htdocs/blahblah.jpg
I can't seem to verify that the file exists using this method.
The only way I can verify that the file was indeed uploaded is to go into
the folder within Apache that was specified in the path and check there.
*How can I check by going through the browser window?*
Next question:
When I check that the file was uploaded, the file is saved in:
C:/Program Files/Apache Group/Apache/htdocs/$img1_name
as the *regular *.jpeg name I originally gave it - not the variable -
$img1.
Is this correct? Or, should the file be saved as:
img1?
And the last question:
This is the line I received upon sending the file:
You sent: KewpieSmall.jpeg, a 3127 byte file with a mime type of
image/pjpeg.
In her book, it says:
image/jpeg.
What is:
image/pjpeg.?
Many thanks and best wishes to all for a happy and healthy new year.
Tony Ritter
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: installing php with apache rpm???
At 10:04 PM 12/26/2001 -0800, Fred wrote: This guy has some great modular php rpms that will do the trick: http://rpms.arvin.dk/php/ Fred Duane Douglas [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... hello, i have an apache rpm installed. stuff will break if i uninstall it. how do i install php to work with it? thanks for the link. unfortunately, the rpm packages there don't work with rh linux 7.2. does anyone have another suggestion? tia Duane Douglas ASP / SQL Server Tutoring and Training -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Sending out mass mail without having timeout problems ..
Subject: [PHP] Sending out mass mail without having timeout problems .. Hi, Too much trouble to write who wrote what when. Someone suggested using an alias but that's not always doable. I had an app that read from a live rdbms and sent out emails. I sent each email to sendmail and waited fo it to send the email before going on to the next one. My cohort determined that this was way, way too slow. He did some research and added some new parameters to sendmail so that the email was put in a queue and so the script ran MUCH faster. I believe these were the parameters. You should look them up on the sendmail site: sendmail -oi -t -odq Hope this helps. Peter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: Metabse and ODBC Blobs, was [Re: Store Image in Access Database]
Hello,
Mike Baranski wrote:
Sorry about the previous one, that was a mistake.
I have the following code to insert a blob into an access OLE object field:
I am not sure if using SQL is the appropriate way to update such object
field.
Anyway, to make this work, such object must be of ODBC type
ODBC_LONGVARBINARY .
Metabase can create tables with BLOB fields properly declared. You may
want to try the driver test script to see what it does and how it shows
in access. Look in lob_test.schema to see how you can define a schema
with LOB fields so Metabase manager class can create one for your needs.
if(($prepared_query=MetabasePrepareQuery($database,UPDATE incident_blob SET
data_blob=?, description='new')))
{
$binary_lob=array(
Type=inputfile,
Database=$database,
Error=,
FileName=test.php
);
if(($success=MetabaseCreateLOB($binary_lob,$blob)))
{
MetabaseQuerySetBLOB($database,$prepared_query,1,$blob,data_blob);
if(!MetabaseExecuteQuery($database,$prepared_query))
$error=MetabaseError($database);
MetabaseDestroyLOB($blob);
}
else
{
$error=$binary_lob[Error];
echo Error 1 (CreateLOB): $error\n;
}
MetabaseFreePreparedQuery($database,$prepared_query);
}
else
{
$error=MetabaseError($database);
echo Error 2 (Prepare): $error\n;
}
I can connect and query the database otherwise, and it works fine. The
problem is with the Blobs, that update statement is not getting run. There's
only 1 row in the table, but the description and ole object do not get
updated. If I switch the driver to use mysql as opposed to odbc, it works
fine on an identical table (on linux, not windows). Any ideas?
Did you verify that MetabaseExecuteQuery call above succeeds? If it does
not succeed, what is the error message that is returned?
Regards,
Manuel Lemos
Mike B.
On Wednesday 26 December 2001 02:49 pm, Manuel Lemos wrote:
Hello,
Mike Baranski wrote:
Hi, I'm trying to store a binary file in an access database, I'm using an
ole type, and I think that it's getting inserted OK. My problem is that
I don't know how to pull it out... How do you select the stuff that's in
an ole object out of the database and display it, a jpg, for example. I
can't even get the raw data. I've tried converting it to base 16 and
inserting it, but I still can't pull it out. I know how to do this in
mysql, so posting that won't help. I need to know how to do this with
access.
If you are using ODBC, you may want to try Metabase because it supports
BLOB fields with any ODBC driver. Metabase is Open Source and is freely
available here.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: Metabse and ODBC Blobs, was [Re: Store Image in Access Database]
Hello,
Mike Baranski wrote:
Sorry about the previous one, that was a mistake.
I have the following code to insert a blob into an access OLE object field:
I am not sure if using SQL is the appropriate way to update such object
field.
Anyway, to make this work, such object must be of ODBC type
ODBC_LONGVARBINARY .
Metabase can create tables with BLOB fields properly declared. You may
want to try the driver test script to see what it does and how it shows
in access. Look in lob_test.schema to see how you can define a schema
with LOB fields so Metabase manager class can create one for your needs.
if(($prepared_query=MetabasePrepareQuery($database,UPDATE incident_blob SET
data_blob=?, description='new')))
{
$binary_lob=array(
Type=inputfile,
Database=$database,
Error=,
FileName=test.php
);
if(($success=MetabaseCreateLOB($binary_lob,$blob)))
{
MetabaseQuerySetBLOB($database,$prepared_query,1,$blob,data_blob);
if(!MetabaseExecuteQuery($database,$prepared_query))
$error=MetabaseError($database);
MetabaseDestroyLOB($blob);
}
else
{
$error=$binary_lob[Error];
echo Error 1 (CreateLOB): $error\n;
}
MetabaseFreePreparedQuery($database,$prepared_query);
}
else
{
$error=MetabaseError($database);
echo Error 2 (Prepare): $error\n;
}
I can connect and query the database otherwise, and it works fine. The
problem is with the Blobs, that update statement is not getting run. There's
only 1 row in the table, but the description and ole object do not get
updated. If I switch the driver to use mysql as opposed to odbc, it works
fine on an identical table (on linux, not windows). Any ideas?
Did you verify that MetabaseExecuteQuery call above succeeds? If it does
not succeed, what is the error message that is returned?
Regards,
Manuel Lemos
Mike B.
On Wednesday 26 December 2001 02:49 pm, Manuel Lemos wrote:
Hello,
Mike Baranski wrote:
Hi, I'm trying to store a binary file in an access database, I'm using an
ole type, and I think that it's getting inserted OK. My problem is that
I don't know how to pull it out... How do you select the stuff that's in
an ole object out of the database and display it, a jpg, for example. I
can't even get the raw data. I've tried converting it to base 16 and
inserting it, but I still can't pull it out. I know how to do this in
mysql, so posting that won't help. I need to know how to do this with
access.
If you are using ODBC, you may want to try Metabase because it supports
BLOB fields with any ODBC driver. Metabase is Open Source and is freely
available here.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] setlocale on OS X not working
Hm, as far as I see that package is for Aqua (the GUI of OS X) and not for the core (FreeBSD, *nix), so it won't help - and it is actually installed (I use OS X in a german enviroment because I'm swiss). Do you know where to get language packets for FreeBSD? That might work... Am Donnerstag den, 27. Dezember 2001, um 18:36, schrieb Brian Clark: * Stefan Rusterholz ([EMAIL PROTECTED]) [Dec 27. 2001 12:12]: Is there a `locale' package you can install for OSX? (There is for my system.) There is one, but not for PHP, only for the system (which is actually multilingual and able to change language during runtime) That's what I'm talking about -- for the system. -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 HTML email needs a rant tag. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Sending out mass mail without having timeout problems ..
Hi, If you will send a lot of e-mails, I recomend you, that use under the Console: $rush nohup php -q file_send_email.php The nohup, tell to maquine that don't hang up until finished. php -q (quiet mode) and the last character () for let the process in background. It's only works on *nix Boxes, I don't think that will work under M$ windows. Bye, At 12:02 PM -0600 27/12/01, Peter wrote: Subject: [PHP] Sending out mass mail without having timeout problems .. Hi, Too much trouble to write who wrote what when. Someone suggested using an alias but that's not always doable. I had an app that read from a live rdbms and sent out emails. I sent each email to sendmail and waited fo it to send the email before going on to the next one. My cohort determined that this was way, way too slow. He did some research and added some new parameters to sendmail so that the email was put in a queue and so the script ran MUCH faster. I believe these were the parameters. You should look them up on the sendmail site: sendmail -oi -t -odq Hope this helps. Peter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- __ Jesus Maria Bianco Troconis (yisu) E-MAIL mailto:[EMAIL PROTECTED] ICQ4792036 / nickname yisu WEBhttp://yisu.net Telefono/Phone +58 (414) 3042346 (Ciudad/City) Caracas, Venezuela Mac, PHP MySQL Rulez. They Kick some ass! __ _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: File Upload Question...
Hi,
Remember 2nd Q: The file is Upload to a temporaly direcory, later you copy from
temporaly (temporaly name) to a final (rename the file) destination.
Under *NIX, I don't if Windows's PHP when upload tthe file, the file is copied to a
temporaly directory.
Bye,
I've still My Question about PHP_AUTH_USER and Browsers :-)
Marry Chistmas...
At 12:33 PM -0500 27/12/01, Jeremy Reed wrote:
Your first question. To see that the file uploaded successfully using the
web browser, one would have to have access to your computer's file system.
In her book, she used this merely as an example to show that the file had,
indeed, been uploaded. This should not be used as something that you allow
your web users to do to confirm the receipt of the file. Instead, send them
an email, show them a directory listing, etc.
Your second question, the name given to the image should be whatever the
*value* of the variable used to copy() it. You should, however, come up
with a naming scheme that allows you to ensure that you do not overwrite any
uploaded files--especially if you expect a lot of traffic and/or users using
this feature.
Your third question, the mime-type pjpg is functionally the same as the
mime-type jpeg. There's nothing you need to worry about there.
Anthony Ritter [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Merry Christmas everybody.
I am using MS Windows 98 with Apache and following an example in Julie
Meloni's PHP - Fast and Easy (Chapter 10) in which she describes file
uploading using PHP on page 168-174.
She has two files:
1) an html form to receive the input from the user for the file to be
uploaded
2) a .php script to accept the variable and use the copy() function.
.
The scripts are as follows:
(html form)
HTML
HEAD
TITLEUpload a File/TITLE
/HEAD
BODY
H1Upload a File/H1
FORM METHOD=post ACTION=do_upload.php ENCTYPE=multipart/form-data
pstrongFile to Upload:/strongbr
INPUT TYPE=file NAME=img1 SIZE=30/p
PINPUT TYPE=submit NAME=submit VALUE=Upload File/p
/FORM
/BODY
/HTML
(.php script)
?
if ($img1_name != ) {
@copy($img1, c:/Program Files/Apache Group/Apache/htdocs/$img1_name)
or die(Couldn't copy the file.);
} else {
die(No input file specified);
}
?
HTML
HEAD
TITLESuccessful File Upload/TITLE
/HEAD
BODY
H1Success!/H1
PYou sent: ? echo $img1_name; ?, a ? echo $img1_size; ?
byte file with a mime type of ? echo $img1_type; ?./P
/BODY
/HTML
..
My questions:
I am able to upload a file from My Documents to the Apache server however
in her book, she describes that the user can verify that the file was
uploaded to the server by going to:
File/ Open Page / in ones web browser to navigate through their filesystem
to
find the file that was uploaded. There is a screenshot in the book that
shows the .jpeg file on the screen with the browser at:
file:///C/Apache/htdocs/blahblah.jpg
I can't seem to verify that the file exists using this method.
The only way I can verify that the file was indeed uploaded is to go into
the folder within Apache that was specified in the path and check there.
*How can I check by going through the browser window?*
Next question:
When I check that the file was uploaded, the file is saved in:
C:/Program Files/Apache Group/Apache/htdocs/$img1_name
as the *regular *.jpeg name I originally gave it - not the variable -
$img1.
Is this correct? Or, should the file be saved as:
img1?
And the last question:
This is the line I received upon sending the file:
You sent: KewpieSmall.jpeg, a 3127 byte file with a mime type of
image/pjpeg.
In her book, it says:
image/jpeg.
What is:
image/pjpeg.?
Many thanks and best wishes to all for a happy and healthy new year.
Tony Ritter
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
__
Jesus Maria Bianco Troconis (yisu)
E-MAIL mailto:[EMAIL PROTECTED]
ICQ4792036 / nickname yisu
WEBhttp://yisu.net
Telefono/Phone +58 (414) 3042346
(Ciudad/City) Caracas, Venezuela
Mac, PHP MySQL Rulez.
They Kick some ass!
__
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] installing php with apache rpm (rh linux 7.2)???
hi gang! i have an apache rpm installed. stuff will break if i uninstall it. how do i install php to work with it? tia Duane Douglas ASP / SQL Server Tutoring and Training -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] setlocale on OS X not working
* Stefan Rusterholz ([EMAIL PROTECTED]) [Dec 27. 2001 13:11]: Hm, as far as I see that package is for Aqua (the GUI of OS X) and not for the core (FreeBSD, *nix), so it won't help - and it is actually installed (I use OS X in a german enviroment because I'm swiss). I can't help you there. Although FreeBSD may use another method, or they may already be in the system, I'd just have no idea where you should look. -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 English is my second language, gibberish is my first. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] installing php with apache rpm (rh linux 7.2)???
* Duane Douglas ([EMAIL PROTECTED]) [Dec 27. 2001 13:24]: i have an apache rpm installed. stuff will break if i uninstall it. how do i install php to work with it? You can download the source tarball from php.net. Then configure it --with-apxs to have it build an Apache DSO module. http://www.php.net/do_download.php?download_file=php-4.1.1.tar.gz Download it, unpack it (tar -xzf php-4.1.1.tar.gz), and make your way through the INSTALL and README files. tar -xzf php-4.1.1.tar.gz cd php-4.1.1 less README less INSTALL Just remember, you want a DSO install because you don't want to fool with Apache source, since you already have Apache installed via RPM. IN the INSTALL file, start where it states: QUICK INSTALL (DSO) -- Brian Clark | Avoiding the general public since 1805! Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8 We are all fugitives of our own fate. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Exec as user
I have been looking through the docs and found no help on either finding which user the EXEC'ed commands run as, or how to specify which user they should run as. I tried exec, system, and passthru running a batch file that would write %USERNAME% to a file. And all three functions wrote nothing. They would however write hello world. Has anybody else run into this. I tried exec(test.bat); test.bat: echo %USERNAME% test.txt when run from a command line it resulting in Charles when run from a webpage it resulted in ECHO is on. if I added a line echo off above the echo username it resulted in ECHO is off. again only from the webpage. In essense I need to update a DNS server through a web page. It works if the script is local but not if it has to update a different server. Charles Killmer Windows 2000 Server, IIS 5.0, PHP 4.1.0 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Translating email to (real) plain text...
Hi there, I would like to ask some suggestions on my following problem: I am making a small tool which allows you to store incomming mail in a database table. This mail is then scanned on keywords etc etc and with the help of some status bits the priority is given. Via a webpage interface, people can then answer these emails... I started out by creating a extra Mailbox to which I route all the incoming mail. With the help of a Cron-Job which runs a PHP class made by Manual Lemos to retrieve POP mail I retrieve the mail and insert it into a database table (MySQL) So far so good! Only problem which I have is that some (=most) people create email with clients that output email with HTML codes (Internet Explorer for example).. I am not really interested in any attachment, pictures etc which are sent with the email, only the plain email body is important. For emails that contain HTML tags, I think that stripping the HTML tags will do enough for me.. I do though have a problem when dealing with emails in which text is Mime-encoded. The Mime_Class from Manual encodes everything for example.. Before I spend a great deal of time making some code which can decode and strip all the diferent email-client formats, isn't there a class out there which can get me the plain text email body out of a raw retrieved email..?? The Mailling-list archives of this PHP maillinglist at http://marc.theaimsgroup.com/?l=php-general for example contains very nicely stripped emails of all the members.. Does anyone khow this is done..? Thanks in advance for any help.. With kind regards.. David Bouw PS: To give some examples of problems I see in the retrieved mail I have quoted some pieces: -- -- //A stripslashes will do a lot for me.. --=_NextPart_001_0071_01C18105.33ABC800 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable This is a mail send to myself --=_NextPart_001_0071_01C18105.33ABC800 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3DMSHTML 5.00.3314.2100 name=3DGENERATOR STYLE/STYLE -- -- //I can probably us mime_decode, but I think that this will take quite some hours to code.. This is a MIME encoded message. Created by html_mime_mail.class. See http://www.heyes-computing.net/scripts/ for a copy. --=_7c76c35e24d83834b9c31a94ad6407ca Content-Type: multipart/alternative;boundary==_c15b829df5ff4f43680605bb761b564f --=_c15b829df5ff4f43680605bb761b564f Content-Type: text/plain Content-Transfer-Encoding: base64 PFBSRT5CZXN0ZSBQYXRyaWMgVmVyaG9ldmVuLAoKV2lqIHdpbGxlbiB1IGdyYWFnIGRlIHN0YXR1^M cyB2YW4gdXcgYmVzdGVsbGluZyBkb29yZ2V2ZW4uClV -- -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Translating email to (real) plain text...
I was just reading the other day the php has imap function that give you the ability to get only the body of the message. have your cron job get that and then strip HTML tags on that. Don't see why that wouldn't work. http://www.php.net/manual/en/function.imap-body.php Jim - Original Message - From: David Bouw [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 11:44 AM Subject: [PHP] Translating email to (real) plain text... Hi there, I would like to ask some suggestions on my following problem: I am making a small tool which allows you to store incomming mail in a database table. This mail is then scanned on keywords etc etc and with the help of some status bits the priority is given. Via a webpage interface, people can then answer these emails... I started out by creating a extra Mailbox to which I route all the incoming mail. With the help of a Cron-Job which runs a PHP class made by Manual Lemos to retrieve POP mail I retrieve the mail and insert it into a database table (MySQL) So far so good! Only problem which I have is that some (=most) people create email with clients that output email with HTML codes (Internet Explorer for example).. I am not really interested in any attachment, pictures etc which are sent with the email, only the plain email body is important. For emails that contain HTML tags, I think that stripping the HTML tags will do enough for me.. I do though have a problem when dealing with emails in which text is Mime-encoded. The Mime_Class from Manual encodes everything for example.. Before I spend a great deal of time making some code which can decode and strip all the diferent email-client formats, isn't there a class out there which can get me the plain text email body out of a raw retrieved email..?? The Mailling-list archives of this PHP maillinglist at http://marc.theaimsgroup.com/?l=php-general for example contains very nicely stripped emails of all the members.. Does anyone khow this is done..? Thanks in advance for any help.. With kind regards.. David Bouw PS: To give some examples of problems I see in the retrieved mail I have quoted some pieces: -- -- //A stripslashes will do a lot for me.. --=_NextPart_001_0071_01C18105.33ABC800 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable This is a mail send to myself --=_NextPart_001_0071_01C18105.33ABC800 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3DMSHTML 5.00.3314.2100 name=3DGENERATOR STYLE/STYLE -- -- //I can probably us mime_decode, but I think that this will take quite some hours to code.. This is a MIME encoded message. Created by html_mime_mail.class. See http://www.heyes-computing.net/scripts/ for a copy. --=_7c76c35e24d83834b9c31a94ad6407ca Content-Type: multipart/alternative;boundary==_c15b829df5ff4f43680605bb761b564f --=_c15b829df5ff4f43680605bb761b564f Content-Type: text/plain Content-Transfer-Encoding: base64 PFBSRT5CZXN0ZSBQYXRyaWMgVmVyaG9ldmVuLAoKV2lqIHdpbGxlbiB1IGdyYWFnIGRlIHN0YXR1 ^M cyB2YW4gdXcgYmVzdGVsbGluZyBkb29yZ2V2ZW4uClV -- -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Translating email to (real) plain text...
and this http://www.php.net/manual/en/function.imap-fetchstructure.php - Original Message - From: David Bouw [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 11:44 AM Subject: [PHP] Translating email to (real) plain text... Hi there, I would like to ask some suggestions on my following problem: I am making a small tool which allows you to store incomming mail in a database table. This mail is then scanned on keywords etc etc and with the help of some status bits the priority is given. Via a webpage interface, people can then answer these emails... I started out by creating a extra Mailbox to which I route all the incoming mail. With the help of a Cron-Job which runs a PHP class made by Manual Lemos to retrieve POP mail I retrieve the mail and insert it into a database table (MySQL) So far so good! Only problem which I have is that some (=most) people create email with clients that output email with HTML codes (Internet Explorer for example).. I am not really interested in any attachment, pictures etc which are sent with the email, only the plain email body is important. For emails that contain HTML tags, I think that stripping the HTML tags will do enough for me.. I do though have a problem when dealing with emails in which text is Mime-encoded. The Mime_Class from Manual encodes everything for example.. Before I spend a great deal of time making some code which can decode and strip all the diferent email-client formats, isn't there a class out there which can get me the plain text email body out of a raw retrieved email..?? The Mailling-list archives of this PHP maillinglist at http://marc.theaimsgroup.com/?l=php-general for example contains very nicely stripped emails of all the members.. Does anyone khow this is done..? Thanks in advance for any help.. With kind regards.. David Bouw PS: To give some examples of problems I see in the retrieved mail I have quoted some pieces: -- -- //A stripslashes will do a lot for me.. --=_NextPart_001_0071_01C18105.33ABC800 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable This is a mail send to myself --=_NextPart_001_0071_01C18105.33ABC800 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3DMSHTML 5.00.3314.2100 name=3DGENERATOR STYLE/STYLE -- -- //I can probably us mime_decode, but I think that this will take quite some hours to code.. This is a MIME encoded message. Created by html_mime_mail.class. See http://www.heyes-computing.net/scripts/ for a copy. --=_7c76c35e24d83834b9c31a94ad6407ca Content-Type: multipart/alternative;boundary==_c15b829df5ff4f43680605bb761b564f --=_c15b829df5ff4f43680605bb761b564f Content-Type: text/plain Content-Transfer-Encoding: base64 PFBSRT5CZXN0ZSBQYXRyaWMgVmVyaG9ldmVuLAoKV2lqIHdpbGxlbiB1IGdyYWFnIGRlIHN0YXR1 ^M cyB2YW4gdXcgYmVzdGVsbGluZyBkb29yZ2V2ZW4uClV -- -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: Metabse and ODBC Blobs, was [Re: Store Image in Access Database]
OK, first, that's right out of the metabase manual, with names changed to
protect the innocent. Second, the example won't work, it gives syntax errors
with the MS driver on creating the test db and tables, but I fixed the DB
part, but the tables still won't create themselves, it still gives errors.
I've hacked it up a little bit, but it doesen't look like the test stuff will
work for access. Has anyone successfully done this, and how? I cannot
believe that I'm the only person who's ever stored binary data in Access,
regardless of how bad of an idea it is...
Hello,
Mike Baranski wrote:
Sorry about the previous one, that was a mistake.
I have the following code to insert a blob into an access OLE object
field:
I am not sure if using SQL is the appropriate way to update such object
field.
Anyway, to make this work, such object must be of ODBC type
ODBC_LONGVARBINARY .
Metabase can create tables with BLOB fields properly declared. You may
want to try the driver test script to see what it does and how it shows
in access. Look in lob_test.schema to see how you can define a schema
with LOB fields so Metabase manager class can create one for your needs.
if(($prepared_query=MetabasePrepareQuery($database,UPDATE incident_blob
SET data_blob=?, description='new')))
{
$binary_lob=array(
Type=inputfile,
Database=$database,
Error=,
FileName=test.php
);
if(($success=MetabaseCreateLOB($binary_lob,$blob)))
{
MetabaseQuerySetBLOB($database,$prepared_query,1,$blob,data_blob);
if(!MetabaseExecuteQuery($database,$prepared_query))
$error=MetabaseError($database);
MetabaseDestroyLOB($blob);
}
else
{
$error=$binary_lob[Error];
echo Error 1 (CreateLOB): $error\n;
}
MetabaseFreePreparedQuery($database,$prepared_query);
}
else
{
$error=MetabaseError($database);
echo Error 2 (Prepare): $error\n;
}
I can connect and query the database otherwise, and it works fine. The
problem is with the Blobs, that update statement is not getting run.
There's only 1 row in the table, but the description and ole object do
not get updated. If I switch the driver to use mysql as opposed to odbc,
it works fine on an identical table (on linux, not windows). Any ideas?
Did you verify that MetabaseExecuteQuery call above succeeds? If it does
not succeed, what is the error message that is returned?
Regards,
Manuel Lemos
Mike B.
On Wednesday 26 December 2001 02:49 pm, Manuel Lemos wrote:
Hello,
Mike Baranski wrote:
Hi, I'm trying to store a binary file in an access database, I'm
using an ole type, and I think that it's getting inserted OK. My
problem is that I don't know how to pull it out... How do you select
the stuff that's in an ole object out of the database and display it,
a jpg, for example. I can't even get the raw data. I've tried
converting it to base 16 and inserting it, but I still can't pull it
out. I know how to do this in mysql, so posting that won't help. I
need to know how to do this with access.
If you are using ODBC, you may want to try Metabase because it supports
BLOB fields with any ODBC driver. Metabase is Open Source and is freely
available here.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
--
*
* Mike Baranski *
* Security Managment Consulting *
* 919-788-9200 Phone*
* 919-510-0037 Fax *
* [EMAIL PROTECTED] *
*
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Exec as user
Charles --- As a general run on an Unix server httpd is run as user and group nobody. I have been looking through the docs and found no help on either finding which user the EXEC'ed commands run as, or how to specify which user they should run as. I tried exec, system, and passthru running a batch file that would write %USERNAME% to a file. And all three functions wrote nothing. They would however write hello world. Has anybody else run into this. I tried exec(test.bat); test.bat: echo %USERNAME% test.txt when run from a command line it resulting in Charles when run from a webpage it resulted in ECHO is on. if I added a line echo off above the echo username it resulted in ECHO is off. again only from the webpage. In essense I need to update a DNS server through a web page. It works if the script is local but not if it has to update a different server. Charles Killmer Windows 2000 Server, IIS 5.0, PHP 4.1.0 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: Exec as user
There's no way that I have found to actually execute a script as a
specified user, however:
?php
passthru('whoami');
?
Should tell you what user the web server is running as.
Mike
Charlesk wrote:
I have been looking through the docs and found no help on either finding which user
the EXEC'ed commands run as, or how to specify which user they should run as. I
tried exec, system, and passthru running a batch file that would write %USERNAME% to
a file. And all three functions wrote nothing. They would however write hello
world. Has anybody else run into this.
I tried exec(test.bat);
test.bat:
echo %USERNAME% test.txt
when run from a command line it resulting in Charles
when run from a webpage it resulted in ECHO is on.
if I added a line echo off above the echo username it resulted in ECHO is off.
again only from the webpage.
In essense I need to update a DNS server through a web page. It works if the script
is local but not if it has to update a different server.
Charles Killmer
Windows 2000 Server, IIS 5.0, PHP 4.1.0
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Exec as user
I don't believe that the system variables are available to php. I work on *nix mostly, but I have a windows machine at home running php and I can't access any of my system var's. - Original Message - From: charlesk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 11:33 AM Subject: [PHP] Exec as user I have been looking through the docs and found no help on either finding which user the EXEC'ed commands run as, or how to specify which user they should run as. I tried exec, system, and passthru running a batch file that would write %USERNAME% to a file. And all three functions wrote nothing. They would however write hello world. Has anybody else run into this. I tried exec(test.bat); test.bat: echo %USERNAME% test.txt when run from a command line it resulting in Charles when run from a webpage it resulted in ECHO is on. if I added a line echo off above the echo username it resulted in ECHO is off. again only from the webpage. In essense I need to update a DNS server through a web page. It works if the script is local but not if it has to update a different server. Charles Killmer Windows 2000 Server, IIS 5.0, PHP 4.1.0 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Create a table with more than 1 column
Rodrigo ---
This is really an SQL question, not an PHP one?
What database are you using? On what OS?
For MySQL check this link:
http://www.mysql.com/doc/A/N/ANSI_diff_SELECT_INTO_TABLE.html
If your running on a Unix server, and is something that runs on a regular
basis (say hourly or daily), you could use a simple shell script and
run it as a cron job.
Hope this helps,
David Jackson
Hi list,
I am in a big trouble. My deadline is coming and I couldn't solve my
problem yet! I have this script that outputs a table that can be seen
at
http://www.celebnet.com.br/abc.php
$ultletra = '';
$row = '';
while($resultado = $query-dados()) {
$curletra = $resultado['letra'];
if($curletra != $ultletra) {
if (!empty($row)) {
$row .= /tr\n;
}
$row .= tr\ntd\nimg src=\img/letras/$curletra.gif\
width=\24\ height=\24\\n/td\n/tr\n;
}
$row .= tda
href=\interna.php?cat=$resultado[Nome_Categoria]celebID=$resultado[CelebID
]\.$resultado['Nome_Artistico']./a/td\n;
$ultletra = $curletra;
}
if (!empty($row)) {
$row .= tr\n;
}
SQL is:
SELECT
categorias.Nome_Categoria,celebridades.CelebID,celebridades.Nome_Artistico,
lcase(left(Nome_Artistico,1)) as letra FROM categorias LEFT JOIN
celebridades ON categorias.CategoriaID=celebridades.Categoria WHERE
CategoriaID='1' ORDER BY Nome_Artistico
My problem is that I need to modify the script to output a 3 column
table. I have tried everything but nothing works, and I've tried also
all url about PHP that i could found. Please I'll appreciate any help.
Thank's in advance and happy new year to all!!!
Rodrigo Peres (Brazil)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] oracle 8i stored procedures + php access
Hi, I have a delphi application that uses oracle as db
server with stored procedures (running ok).
I've been trying to make a php version of such
application with no luck so far.
I've created a user to access such thing and I keep
getting the following error
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object
SYSTEM.CAD013_PSQ_RSV is invalid ORA-06550: line 3,
column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in
/somewhere/test.php on line 31
If I try with user system the messages are diferent
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object SYSTEM.CAD013_PSQ_RSV is invalid
ORA-06550: line 3, column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in /somewhere/test.php on line 31
The script follows
putenv(ORACLE_BASE=/u01/app/oracle) ;
putenv(ORACLE_HOME=/u01/app/oracle/product/8.1.7);
putenv(ORACLE_SID=oracle) ;
$usernameOracle=dbuser;
$passwordOracle=dbpassword;
$hostOracle=dbhost;
$tsA = time() ;
$con =
OCIPLogon($usernameOracle,$passwordOracle,$hostOracle);
$tsD = time() ;
$res = OCINewCursor($con);
$stm = OCIParse ( $con,
BEGIN
CAD013_PSQ_RSV(:pkey, :Option, :RES);
END;
);
$name = foo;
$option = 0;
OCIBindByName ( $stm, :pkey, $nome, -1);
OCIBindByName ( $stm, :Option, $option, -1);
OCIBindByName ( $stm, :RES, amp;$res, -1,
OCI_B_CURSOR
);
@OCIExecute ( $stm );
OCIExecute ($res);
$arrError = OCIError($res);
if ($arrError['code'])
{
echo
$arrError['code'].-.$arrError['message'].lt;brgt;;
exit;
}
while (OCIFetchInto($res,amp;$data))
var_dump($data);
}
OCIFreeCursor($stm);
OCIFreeStatement($res);
The stored procedure has one code bellow
IF (vmINT_QtdLines lt;= 0) THEN
-- PHP
raise_application_error(
-20005,
'NAME NOT FOUND'
);
-- DELPHI
-- DBMS_OUTPUT.PUT_LINE('NOTHING
FOUND:'||pkey);
-- RAISE Erro;
END IF;
I am not quite sure where the problem is located. Any
help (if directly related to oracle emails directly)
wl be appreciated.
Thanks.
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Translating email to (real) plain text...
So far so good! Only problem which I have is that some (=most) people create email with clients that output email with HTML codes (Internet Explorer for example).. Internet Explorer is a browser, it doesn't create email. Does anyone khow this is done..? Use either the imap extension, or the mimeDecode class available in PEAR, or here: http://www.phpguru.org -- Richard Heyes If you have any trouble sounding condescending, find a Unix user to show you how it's done. - Scott Adams -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Time function question/
Hi, Can anybody suggest a function that will generate a random date between 01-Jan-1967 31-Dec-1985 thanks. = Mehmet Erisen http://www.erisen.com __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: Time function question/
try date(d-M-Y,rand (mktime(0,0,0,1,1,1970),mktime(0,0,0,12,31,1985))) mktime works only from January 1 1970 -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com Mehmet Kamil Erisen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, Can anybody suggest a function that will generate a random date between 01-Jan-1967 31-Dec-1985 thanks. = Mehmet Erisen http://www.erisen.com __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] generalized environment for pages
Would all you experts please advise me on additions to this list? It's a list of resources a page may need to do its job. -- Attributes: URL - implicit from server Referring page - implicit from server Target Template page(s) Page_Security_Level Security Object Authentication_Server/DataBase Name Password Secure_Submit (y/n) Secure_Required(y/n) User Name Secure_Submit (y/n) Secure_Required(y/n) Password Name Secure_Submit (y/n) Secure_Required(y/n) CreditCardServer User Name Secure_Submit (y/n) Secure_Required(y/n) Password Name Secure_Submit (y/n) Secure_Required(y/n) MainDataBase Authentication_Server/DataBase Name Password Secure_Submit (y/n) Secure_Required(y/n) User Name Secure_Submit (y/n) Secure_Required(y/n) Password Name Secure_Submit (y/n) Secure_Required(y/n) GraphicsDirectory ScriptIncludeDirectory - implict from server EmailServer Authentication_Server/DataBase Name Password Secure_Submit (y/n) Secure_Required(y/n) User Name Secure_Submit (y/n) Secure_Required(y/n) Password Name Secure_Submit (y/n) Secure_Required(y/n) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] oracle 8i stored procedures + php access
Hi, I have a delphi application that uses oracle as db
server with stored procedures (running ok).
I've been trying to make a php version of such
application with no luck so far.
I've created a user to access such thing and I keep
getting the following error
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object
SYSTEM.CAD013_PSQ_RSV is invalid ORA-06550: line 3,
column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in
/somewhere/test.php on line 31
If I try with user system the messages are diferent
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object SYSTEM.CAD013_PSQ_RSV is invalid
ORA-06550: line 3, column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in /somewhere/test.php on line 31
The script follows
putenv(ORACLE_BASE=/u01/app/oracle) ;
putenv(ORACLE_HOME=/u01/app/oracle/product/8.1.7);
putenv(ORACLE_SID=oracle) ;
$usernameOracle=dbuser;
$passwordOracle=dbpassword;
$hostOracle=dbhost;
$tsA = time() ;
$con =
OCIPLogon($usernameOracle,$passwordOracle,$hostOracle);
$tsD = time() ;
$res = OCINewCursor($con);
$stm = OCIParse ( $con,
BEGIN
CAD013_PSQ_RSV(:pkey, :Option, :RES);
END;
);
$name = foo;
$option = 0;
OCIBindByName ( $stm, :pkey, $nome, -1);
OCIBindByName ( $stm, :Option, $option, -1);
OCIBindByName ( $stm, :RES, $res, -1, OCI_B_CURSOR
);
@OCIExecute ( $stm );
OCIExecute ($res);
$arrError = OCIError($res);
if ($arrError['code'])
{
echo
$arrError['code'].-.$arrError['message'].br;
exit;
}
while (OCIFetchInto($res,$data))
var_dump($data);
}
OCIFreeCursor($stm);
OCIFreeStatement($res);
The stored procedure has one code bellow
IF (vmINT_QtdLines = 0) THEN
-- PHP
raise_application_error(
-20005,
'NAME NOT FOUND'
);
-- DELPHI
-- DBMS_OUTPUT.PUT_LINE('NOTHING
FOUND:'||pkey);
-- RAISE Erro;
END IF;
I am not quite sure where the problem is located. Any
help (if directly related to oracle emails directly)
wl be appreciated.
Thanks.
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] crack lib
If the crack lib functions are for cracking passwords or other non commerce/offensive/hacker efforts, I strongly object to their inclusion in the functions of PHP. The PHP/Apache community does not need to give the gates/microsoft/.net community any ammunition for bad publicity. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Exec as user
I can access the username system var when the script is run from a command prompt. The problem lies when iis tells php to run it. I have the directory security turned on so IIS authenticates me before any scripts are run. So it should be running as me. Charles Killmer -- Original Message -- From: Jim Lucas [php] [EMAIL PROTECTED] Date: Thu, 27 Dec 2001 13:50:17 -0800 I don't believe that the system variables are available to php. I work on *nix mostly, but I have a windows machine at home running php and I can't access any of my system var's. - Original Message - From: charlesk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 11:33 AM Subject: [PHP] Exec as user I have been looking through the docs and found no help on either finding which user the EXEC'ed commands run as, or how to specify which user they should run as. I tried exec, system, and passthru running a batch file that would write %USERNAME% to a file. And all three functions wrote nothing. They would however write hello world. Has anybody else run into this. I tried exec(test.bat); test.bat: echo %USERNAME% test.txt when run from a command line it resulting in Charles when run from a webpage it resulted in ECHO is on. if I added a line echo off above the echo username it resulted in ECHO is off. again only from the webpage. In essense I need to update a DNS server through a web page. It works if the script is local but not if it has to update a different server. Charles Killmer Windows 2000 Server, IIS 5.0, PHP 4.1.0 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Charles Killmer Netgain Technology 251-4700 -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] crack lib
On Thu, 2001-12-27 at 19:12, Dennis Gearon wrote: If the crack lib functions are for cracking passwords or other non commerce/offensive/hacker efforts, I strongly object to their inclusion in the functions of PHP. The PHP/Apache community does not need to give the gates/microsoft/.net community any ammunition for bad publicity. Object away. They exist because they exist and are useful. The concepts have been around for years and are easily implemntable in any programming language. That's the value and risk of freedom - it cuts both ways. Billy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] crack lib
This could easily and quickly lead to a philosophical argument about the merits of such software/libraries/etc. Is the best way to secure software and hardware to take away the resources to try to break them? This only leads to more and more poor programming. As long as these tools are out there, it should keep all of us on our toes, and programming with security constantly on our minds. Removing those functions give the gates/Microsoft/.net community an excuse to keep programming the way they have always been. -Original Message- From: Billy Harvey [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 4:29 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] crack lib On Thu, 2001-12-27 at 19:12, Dennis Gearon wrote: If the crack lib functions are for cracking passwords or other non commerce/offensive/hacker efforts, I strongly object to their inclusion in the functions of PHP. The PHP/Apache community does not need to give the gates/microsoft/.net community any ammunition for bad publicity. Object away. They exist because they exist and are useful. The concepts have been around for years and are easily implemntable in any programming language. That's the value and risk of freedom - it cuts both ways. Billy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] php code beautifier
do you know if exist a php code beautifier for win32? pls tell me the address. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: php code beautifier
I'm working php script that would perform such a feat. I'll post news on php.general when/if it's finished. Mike George Nicolae wrote: do you know if exist a php code beautifier for win32? pls tell me the address. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Exec as user
Try doing this ? echo 'pre'; print_r(array($HTTP_SERVER_VARS,$HTTP_ENV_VARS)); echo '/pre'; ? And see if the information you want is in there anywhere. Mike I don't believe that the system variables are available to php. I work on *nix mostly, but I have a windows machine at home running php and I can't access any of my system var's. - Original Message - From: charlesk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 11:33 AM Subject: [PHP] Exec as user I have been looking through the docs and found no help on either finding which user the EXEC'ed commands run as, or how to specify which user they should run as. I tried exec, system, and passthru running a batch file that would write %USERNAME% to a file. And all three functions wrote nothing. They would however write hello world. Has anybody else run into this. I tried exec(test.bat); test.bat: echo %USERNAME% test.txt when run from a command line it resulting in Charles when run from a webpage it resulted in ECHO is on. if I added a line echo off above the echo username it resulted in ECHO is off. again only from the webpage. In essense I need to update a DNS server through a web page. It works if the script is local but not if it has to update a different server. Charles Killmer Windows 2000 Server, IIS 5.0, PHP 4.1.0 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] MySql and /var/lib/mysql/mysql.sock Problem !!!
hy guys , Does anybody know what is my problem ? I try to access to my mysql database and I get the next errror : Can't connect trough /var/lib/mysql/mysql.sock I' ve seen that this is problem related to permissions in the directory I think ???!!! Could you suggest me some directions and advices about this problem ? thanks Ricardo _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] crack lib
I also subscribe to the opinions against your objection. David has a very good point I would've made hadn't he beat me to it: As long as these tools are out there, it should keep all of us on our toes, and programming with security constantly on our minds. Bogdan Dennis Gearon wrote: If the crack lib functions are for cracking passwords or other non commerce/offensive/hacker efforts, I strongly object to their inclusion in the functions of PHP. The PHP/Apache community does not need to give the gates/microsoft/.net community any ammunition for bad publicity. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] crack lib
On Thu, 27 Dec 2001 16:12:06 -0800 Dennis Gearon [EMAIL PROTECTED] mentioned: If the crack lib functions are for cracking passwords or other non commerce/offensive/hacker efforts, I strongly object to their inclusion in the functions of PHP. The PHP/Apache community does not need to give the gates/microsoft/.net community any ammunition for bad publicity. Crackers won't be using php to crack passwords. What cracklib can do in php is allow web applications to be developed for ensuring the security of your password files. When you have a system with over 500 passwords on it, I guarantee that many of them will be easily crackable. Good system administrators run their password files through crackers from time to time for the purpose of ensuring that if the root account is compromised, that it would extremely difficult for the cracker to get passwords that belong to users (passwords that the users will very likely use on other machines- and very likely use again on the compromised system). There is nothing wrong with php being used for this purpose. There is nothing wrong with a php wrapper to cracklib. That's what php is, btw. primarily- A wrapper language. They don't develop cracklib- php just can be used as a wrapper to it. I don't like politics and coding mixing. And I don't think something should be left out due to politics. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] hotmail settings POP and SMTP under Mozilla
hi guys , Does anybody know how to set up my mail reader (Mozilla ) to be able to read and send mail with my HOTMAIL account ? What should I put in POP ? and SMTP servers ? I wasn't be able to find this information .. Thanks in advance Ricardo _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Can you fake a onClick?
I have checked the archives and not really found an answer, so here goes. My form contains a function called CountIt which increments a counter file on the site. I mainly use it to count the hits on the page. I also have multiple a links to .zip .txt files which can be accessed or downloaded. Is it possible somehow to fake an onclick event so that when the user clicks on the link I can use the CountIt function to increment a counter for that link?
Re: [PHP] Can you fake a onClick?
Yes: a href=javascript:CountIt('actual link here')Text/a
And in ClickIt you'll have to append
if (goto) {
window.location=goto;
}
Obviously, you'll have to redefine ClickIt() to ClickIt(goto)
I don't know if all the code is 100% accurate, but that's definitely the direction to
go. You may have to change the JavaScript code to parent.window.location=goto if you
use frames.
HTH
Bogdan
Douglas Harter wrote:
My form contains a function called CountIt which increments a counter file on the
site. I mainly use it to count the hits on the page. I also have multiple a links
to .zip .txt files which can be accessed or downloaded. Is it possible somehow to
fake an onclick event so that when the user clicks on the link I can use the CountIt
function to increment a counter for that link?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] hotmail settings POP and SMTP under Mozilla
You most probably 1. Have to ask about this somewhere else; 2. Won't be able to set it up -- Hotmail is M$ and, as such, it implements its own protocols. Bogdan ger wrote: Does anybody know how to set up my mail reader (Mozilla ) to be able to read and send mail with my HOTMAIL account ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: Metabse and ODBC Blobs, was [Re: Store Image in Access Database]
Hello,
Mike Baranski wrote:
OK, first, that's right out of the metabase manual, with names changed to
protect the innocent. Second, the example won't work, it gives syntax errors
with the MS driver on creating the test db and tables, but I fixed the DB
part, but the tables still won't create themselves, it still gives errors.
I suppose that is because Access SQL engine does not support standard
SQL clauses like specifying default values for table fields. That is a
known limitation of Access that Metabase supports by setting the
database setup option UseDefaultValues to 0 .
I've hacked it up a little bit, but it doesen't look like the test stuff will
work for access. Has anyone successfully done this, and how? I cannot
believe that I'm the only person who's ever stored binary data in Access,
regardless of how bad of an idea it is...
If you set UseDefaultValues option to 0 as mentioned above it will work
fine. Usually I run the conformance tests for all types of supported
databases before each Metabase release to make sure that nothing is
broken. In fact, I use Access .mdb databases to test Metabase ODBC
driver. I can assure you that LOBs work fine with Access using Metabase.
Just mail me back if you still have difficulties.
Regards,
Manuel Lemos
Hello,
Mike Baranski wrote:
Sorry about the previous one, that was a mistake.
I have the following code to insert a blob into an access OLE object
field:
I am not sure if using SQL is the appropriate way to update such object
field.
Anyway, to make this work, such object must be of ODBC type
ODBC_LONGVARBINARY .
Metabase can create tables with BLOB fields properly declared. You may
want to try the driver test script to see what it does and how it shows
in access. Look in lob_test.schema to see how you can define a schema
with LOB fields so Metabase manager class can create one for your needs.
if(($prepared_query=MetabasePrepareQuery($database,UPDATE incident_blob
SET data_blob=?, description='new')))
{
$binary_lob=array(
Type=inputfile,
Database=$database,
Error=,
FileName=test.php
);
if(($success=MetabaseCreateLOB($binary_lob,$blob)))
{
MetabaseQuerySetBLOB($database,$prepared_query,1,$blob,data_blob);
if(!MetabaseExecuteQuery($database,$prepared_query))
$error=MetabaseError($database);
MetabaseDestroyLOB($blob);
}
else
{
$error=$binary_lob[Error];
echo Error 1 (CreateLOB): $error\n;
}
MetabaseFreePreparedQuery($database,$prepared_query);
}
else
{
$error=MetabaseError($database);
echo Error 2 (Prepare): $error\n;
}
I can connect and query the database otherwise, and it works fine. The
problem is with the Blobs, that update statement is not getting run.
There's only 1 row in the table, but the description and ole object do
not get updated. If I switch the driver to use mysql as opposed to odbc,
it works fine on an identical table (on linux, not windows). Any ideas?
Did you verify that MetabaseExecuteQuery call above succeeds? If it does
not succeed, what is the error message that is returned?
Regards,
Manuel Lemos
Mike B.
On Wednesday 26 December 2001 02:49 pm, Manuel Lemos wrote:
Hello,
Mike Baranski wrote:
Hi, I'm trying to store a binary file in an access database, I'm
using an ole type, and I think that it's getting inserted OK. My
problem is that I don't know how to pull it out... How do you select
the stuff that's in an ole object out of the database and display it,
a jpg, for example. I can't even get the raw data. I've tried
converting it to base 16 and inserting it, but I still can't pull it
out. I know how to do this in mysql, so posting that won't help. I
need to know how to do this with access.
If you are using ODBC, you may want to try Metabase because it supports
BLOB fields with any ODBC driver. Metabase is Open Source and is freely
available here.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
--
*
* Mike Baranski *
* Security Managment Consulting *
* 919-788-9200 Phone*
* 919-510-0037 Fax *
* [EMAIL PROTECTED] *
*
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] hotmail settings POP and SMTP under Mozilla
you cant use mozilla to read and send hotmail messages. Onli outlook ekspress - Original Message - From: ger [EMAIL PROTECTED] To: php-general [EMAIL PROTECTED] Sent: 03. prosinac 2001 19:44 Subject: [PHP] hotmail settings POP and SMTP under Mozilla hi guys , Does anybody know how to set up my mail reader (Mozilla ) to be able to read and send mail with my HOTMAIL account ? What should I put in POP ? and SMTP servers ? I wasn't be able to find this information .. Thanks in advance Ricardo _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Can you fake a onClick?
Maybe I should have mentioned that CountIt is a php function. Does that make
a difference? It is declared at function CountIt($filename) where $filename
is the file containing the count.
- Original Message -
From: Bogdan Stancescu [EMAIL PROTECTED]
To: Douglas Harter [EMAIL PROTECTED]
Cc: PHP Mailing List [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 9:09 PM
Subject: Re: [PHP] Can you fake a onClick?
Yes: a href=javascript:CountIt('actual link here')Text/a
And in ClickIt you'll have to append
if (goto) {
window.location=goto;
}
Obviously, you'll have to redefine ClickIt() to ClickIt(goto)
I don't know if all the code is 100% accurate, but that's definitely the
direction to go. You may have to change the JavaScript code to
parent.window.location=goto if you use frames.
HTH
Bogdan
Douglas Harter wrote:
My form contains a function called CountIt which increments a counter
file on the site. I mainly use it to count the hits on the page. I also have
multiple a links to .zip .txt files which can be accessed or
downloaded. Is it possible somehow to fake an onclick event so that when
the user clicks on the link I can use the CountIt function to increment a
counter for that link?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Modify someone else's session register
Hi. Let's suppose I have 3 users in my site, each of them generating their respective session variables. Assuming I have a session variable named $variable, I'll end up in the server with 3 values: $variable_1, $variable_2 and $variable_3. My question is: is there a way I can change let's say the variable of the second user when the third user is running the php script? Can I access (and change) the session registers generated by the users? Thanks for your help, Alex. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Can you fake a onClick?
Please turn off your read receipt request in your email client. It's
very annoying.
Create a redirect page using php.
Something like
?
// log your hits here. Then...
header(Location: $QUERY_STRING);
?
Using a url such as:
http://www.domain.com/redirect.php?/someurl/somefile.ext
You should be able to track each file requested on your site this way.
Well, that's one way to do it anyway. Perhaps it will give you an
idea...
Matt Friedman
-Original Message-
From: Douglas Harter [mailto:[EMAIL PROTECTED]]
Sent: Thursday December 27, 2001 8:14 PM
To: Bogdan Stancescu
Cc: PHP Mailing List
Subject: Re: [PHP] Can you fake a onClick?
Maybe I should have mentioned that CountIt is a php function. Does that
make
a difference? It is declared at function CountIt($filename) where
$filename
is the file containing the count.
- Original Message -
From: Bogdan Stancescu [EMAIL PROTECTED]
To: Douglas Harter [EMAIL PROTECTED]
Cc: PHP Mailing List [EMAIL PROTECTED]
Sent: Thursday, December 27, 2001 9:09 PM
Subject: Re: [PHP] Can you fake a onClick?
Yes: a href=javascript:CountIt('actual link here')Text/a
And in ClickIt you'll have to append
if (goto) {
window.location=goto;
}
Obviously, you'll have to redefine ClickIt() to ClickIt(goto)
I don't know if all the code is 100% accurate, but that's definitely
the
direction to go. You may have to change the JavaScript code to
parent.window.location=goto if you use frames.
HTH
Bogdan
Douglas Harter wrote:
My form contains a function called CountIt which increments a
counter
file on the site. I mainly use it to count the hits on the page. I also
have
multiple a links to .zip .txt files which can be accessed or
downloaded. Is it possible somehow to fake an onclick event so that
when
the user clicks on the link I can use the CountIt function to increment
a
counter for that link?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Can you fake a onClick?
Uh, ok. You said my form contains a function, so... Well, yes, you can do that too -- in the ugly way: http://www.clipart.com/ (take a look at the links -- using out.php?un=location, where out.php contains CountIt(). Bogdan Douglas Harter wrote: Maybe I should have mentioned that CountIt is a php function. Does that make a difference? It is declared at function CountIt($filename) where $filename is the file containing the count. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] FOLLOW UP:[PHP] Warning: Cannot send session cookie
Michael (and list) --
I've made the adjustment suggested the scripts are below.
What I'm trying todo is pass the uid and mid to the sales.php script.
It works the first time!! But if I reload sales.html the next record( w/
same uid) isn't added or if I login in as a different id the records aren't
added?
Scripts: login.php and sales.php.
Thanks for your time and knowledge,
David Jackson
- login.php ---
?php
// start session
session_start();
session_register(Uid);
session_register(Umid);
// Connect to db
include(/home/sites/www.pickledbeans.com/web/connect.php);
// insert new user
$result = mysql_query(SELECT id,mid,name,perms FROM staff
WHERE name = '$frm_name');
if (mysql_num_rows($result)!=1) {
echo Dis ain't good !!\n;
echo htmlbody;
echo meta http-equiv=\refresh\ content=\5;
url=http://backoffice.pickledbeans.com/index.html\;;
echo /body/html;
mysql_free_result ($result);
mysql_close($link);
} else {
echo We have winner:\n;
// parse out query output and resign to session vars
list($id,$mid,$name) = mysql_fetch_row($result);
echo p$id/p;
echo p$name/p;
$Uid = $id;
$Umid = $mid;
$Uname = $name;
// redirect to main menu page
mysql_free_result ($result);
mysql_close($link);
echo htmlbody;
echo meta http-equiv=\refresh\ content=\5;
url=http://backoffice.pickledbeans.com/sales.html\;;
echo /body/html;
}
?
-- sales.php ---
?php
// If sesssion vars don't exist, goto login form
// else display sales data entry form
session_start();
// if(!session_is_registered(Uid)) {
//echo pWe need to goto login screen!!/p;
// } else {
echo pSession uid set to:$Uid/p\n;
echo pSession uid set to:$Umid/p\n;
echo pSession date: $frm_date/p\n;
echo pSession amount set to: $frm_amount/p\n;
//
include(/home/sites/www.pickledbeans.com/web/connect.php);
// Insert Sales data into sales table
mysql_query(INSERT INTO sales(id,mid,date,amount)
VALUES('$Uid','$Umid','$frm_date','$frm_amount')) ;
mysql_close($link);
echo htmlbody;
echo meta http-equiv=\refresh\ content=\5;
url=http://backoffice.pickledbeans.com/sales.html\;;
echo /body/html;
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] hotmail settings POP and SMTP under Mozilla
I think your best bet is to add a bookmark to www.hotmail.com . James Cox -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 2:11 AM To: ger Cc: php-general Subject: Re: [PHP] hotmail settings POP and SMTP under Mozilla You most probably 1. Have to ask about this somewhere else; 2. Won't be able to set it up -- Hotmail is M$ and, as such, it implements its own protocols. Bogdan ger wrote: Does anybody know how to set up my mail reader (Mozilla ) to be able to read and send mail with my HOTMAIL account ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] RESOLVED(maybe):Warning: Cannot send session cookie
All -- It appears that the problem was a table design problems, my primary index wasn't set to auto-increment? So I was trying to insert records with duplicate keys !! This of course leads to another question, how do I return SQL error messages to the browser? Thanks, David -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] --enable-trans-sid
Hello to my php friends! I am trying to compile PHP with: ---enable-trans-sid But when i test out pages, the only time a real session is propagated between pages is when i included the ?=SID? in the URL's (AND THIS WORKS GREAT!!!). BUT, If I remove that PHP sniplet, the session restarts on every PHP page I load. The PHP manuel specifically says that transparent ID enabled eliminates the need to do that. Does anyone know what is going on by chance? Does anyone have some insight as to why my transparent ID is not being passed between pages? Thank you. my source files are: (1) php-4.1.1.tar.gz (2) mysql_3.23.46.tar.gz and (3) apache_1.3.22.tar.Z my whole compile command is: ./configure --with-mysql --with-apacher=../apache_1.3.24 --enable-track-vars --enable-trans-sid --with-imap --with-kerberos --with-imap-ssl in php.ini, i have: session.use_trans_sid = 1 when i check my config logs, it says: checking wether to enable transparent session id propagation . . . . yes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Question about using libraries without ./compile --with-library
I know you can use ./configure --with-gd to compile gd with php and same with ming, to make flash movies, for example However, I noticed on source code one tutorial showed the php script link straight to the ming .so file, which made me wonder *IF* that was because they didn't use ./configure...is it possible to do that with gd and others? To use php and that library *without* ./configure? I found that odd, unless I misunderstood what they were doing in that ming flash example by connecting to that .so file Is that something you can do with ming, gd library or any other without ./configure option? If that is the case, what are the performance differences in using such a method? Is it such a bad idea, that I should avoid such practices? If I need to elaborate and show a code example, I will. I just never really knew of such a way to use a library. Thanks for your time Joel
[PHP] Re: --enable-trans-sid
forgot to add, operating on Red Hat 7.1 Phantom wrote: Hello to my php friends! I am trying to compile PHP with: ---enable-trans-sid But when i test out pages, the only time a real session is propagated between pages is when i included the ?=SID? in the URL's (AND THIS WORKS GREAT!!!). BUT, If I remove that PHP sniplet, the session restarts on every PHP page I load. The PHP manuel specifically says that transparent ID enabled eliminates the need to do that. Does anyone know what is going on by chance? Does anyone have some insight as to why my transparent ID is not being passed between pages? Thank you. my source files are: (1) php-4.1.1.tar.gz (2) mysql_3.23.46.tar.gz and (3) apache_1.3.22.tar.Z my whole compile command is: ./configure --with-mysql --with-apacher=../apache_1.3.24 --enable-track-vars --enable-trans-sid --with-imap --with-kerberos --with-imap-ssl in php.ini, i have: session.use_trans_sid = 1 when i check my config logs, it says: checking wether to enable transparent session id propagation . . . . yes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] PHP-4.1.1 released
Due to a few bugs in PHP 4.1.0. The PHP Group decided to release PHP 4.1.1. The bugs that were fixed are not major ones but minor ones, which could be annoying if you get bitten by them. Their recommendation is that people who already upgraded to PHP 4.1.0 do not need to upgrade to PHP 4.1.1 unless they're experiencing one of the described bugs. More information please go to www.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Not PHP but MYSQL
Sorry for the OT, but im trying to figure out something with mysql and need some help. Does anyone know how set the auto_increment value to some other number than 0. I have an order_number coloumn and I want to start it at 1000. So the first record would 1001. Thank you, Steve Maroney -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Not PHP but MYSQL
create table table_name ( id int not null auto_increment, primary key (id) ) auto_increment = 1001 - Original Message - From: Steve Maroney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 28, 2001 6:59 AM Subject: [PHP] Not PHP but MYSQL Sorry for the OT, but im trying to figure out something with mysql and need some help. Does anyone know how set the auto_increment value to some other number than 0. I have an order_number coloumn and I want to start it at 1000. So the first record would 1001. Thank you, Steve Maroney -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Call another page after the menu had been selected
Dear all I'm using UltraDev which build a form containing a menu, there a two items inside this menu for user to choose. This form is using Post Action to $php_self which means it will pass back the variable to itself. Then here is the question: what should i do if i want to call a page prompt from a blank window when the item A is selected? and another page when Item B is selected! thx a lot jack [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: Generate Alphabet
I seriously doubt your code works -- have you tested it? I think the code
you submitted will most probably output 1 2 3 4...24 25 26 (spaces are
actually \n's). I never tested it though, so I may be mistaken.
Yes, it works. Test it before posting such doubts :)
Regards,
Philip Olson
However, with just a few changes we get
$letter='a';
$i=0;
while ($letter'z') {
$letter=Chr(ord($letter)+$i);
$i++;
print($letterbr\n);
}
which should work.
Bogdan
Philip Olson wrote:
Consider this example:
$letter = 'a';
$i = 0;
while ($i++ 26) {
print Letter: . $letter++ .\n;
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Sending out mass mail without having timeout problems ..
can this be set in the php file or htaccess with sendmail_path =pathtosendmail/sendmail -oi -t -odq; Paul Roberts [EMAIL PROTECTED] - Original Message - From: Peter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 6:02 PM Subject: Re: [PHP] Sending out mass mail without having timeout problems .. Subject: [PHP] Sending out mass mail without having timeout problems .. Hi, Too much trouble to write who wrote what when. Someone suggested using an alias but that's not always doable. I had an app that read from a live rdbms and sent out emails. I sent each email to sendmail and waited fo it to send the email before going on to the next one. My cohort determined that this was way, way too slow. He did some research and added some new parameters to sendmail so that the email was put in a queue and so the script ran MUCH faster. I believe these were the parameters. You should look them up on the sendmail site: sendmail -oi -t -odq Hope this helps. Peter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: session class
session variables are accessible the same as when you set them : eg
session_register('temp');
$temp = 1;
on another page:
session_start(); /* so that you can access your session variables...
echo $temp; /* this will echo 1
and so you know you cannot define a variable for your class inside a
function (method)
Christian Haines [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
(sorry if this has been posted a thousand times..i am having problems
posting)
hi all,
how does one access and manipulate session variables from within a class?
i have hunted the net high and low but received no relief.
i have tried (where error is a session variable)
class test
{
var $global['error'];
}
class test
{
var $HTTP_SESSION_VARS['error'];
}
class test
{
session_register(error);
var $error;
}
all to no avail.
please help!
many thanks in advance,
christian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
