Question on a mysql insert query:
while(list($key, $val) = each($HTTP_POST_VARS)) {
$string .= "'". $val ."'" .",";
}
$insert_query = "insert into data_16 values ('$string')";
Do I need the single quotes for data being pu
I'm not sure if there is a Window version. I checked the MCAL website
(http://mcal.chek.com), but they don't seem to have anything for Windows.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Joshua E Minnie" <[EMAIL PROTECTED
Hello,
>1. PHP automatically sticks in the backslash in front
>of apostrophes and quotation marks. This seems
>weird Don't trust it. What's up here?
It is a setting of php.ini.
magic_quotes_gpc is it.
Default setting is magic_quotes_gpc=On, it means add slashes in front of
\ and ' of the da
>From what I've experienced, you're correct.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "chris allen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 2:00 PM
Subject: [PHP] Query from POST_VARS
At 03.04.2002 12:08, you wrote:
>I'm getting a bit interested in this; here's how I
>suggest we proceed.
>+ introduction to php.net
> charter - the purpose of this newsgroup
> posting guidelines and etiquette
> be specific
> be terse
> descriptive subject
> include exact er
HI,
I compiled the php.4.1.2 with --enable-ftp to try
to make ftp works but it always complainting the
function ftp_connection() not define.
I'm running Sun's Solaris 8.
Any hints?
Thanks!
--Wo
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
ty tyler :)
saves a bunch of time.
w00t!!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, 3 Apr 2002 20:12:46 +0100, Georgie Casey wrote:
>The sites documentation is crap compared to PHP.
I love to hear people critizing constructively.
>what is it and how do i install it on my windows system?
Add the directory, where your PEAR code is located (e.g. c:\php4\pear),
to includ
There is no ftp_connection() function.
You're meaning to use ftp_connect();
Read more about it here:
http://www.php.net/manual/en/function.ftp-connect.php
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Wo Chang" <[EMAIL PROT
Ok, this one is breaking my back all day.
First some sudo-code ->
fuction email_to_user() {
$sql = 'select distinct(email) from user';
$emailfetch = mysql_query($sql);
$sql = 'select news, date from news order by sid desc limit 10';
$newsfetch = mysql_query($sql);
while
Dear Tyler,
Thanks for your quick reply!!
Yes, I meant ftp_connect().
When I did the phpinfo() I can't see any ftp
setting. I re-started my apache and still
don't work.
Any hints?
Thanks!
--Wo
- Original Message -
From: "Tyler Longren" <[EMAIL PROTECTED]>
To: "Wo Chang" <[EMAIL PR
Why not "SELECT WHERE date_field<$max_date and
date_field>$min_date" ?
A very god advice for everyone of you who tries to implement PHP for the
where selects:
You can VERY OFTEN leave this job to the DB itself. SQL don't only have
SELECT, UPDATE etc... they all have lots of functions for th
That's the way!
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
> -Original Message-
> From: Demitrious S. Kelly [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 8:26 PM
> To: 'Scott Fletcher';
Would be very nice.
There are dozens of very good sites related to PHP learning on the web.
It's been a while that we at PHPBeginner.com were thinking to merge with
some other sites full of useful information in order to create a
noticeably large knowledge base for anyone interested in PHP.
Thou
Yes,
An idea I'd love to throw up here would be not letting the user know
you're spying him:
Make a Java Script function (yes, you will need JavaScript for that)
that has timeout every 10 seconds. Use JS unction escape() and read the
field values of your form assigning them to the JS variables af
Are you talking abut HTML or PHP itself?
Anyway... to have an "" in your page you will need
to
echo '';
Now, PHP Nuke is another thing - it's a software and you should read
through it manual in order to find a way to do this. If there's none -
modify the code yourself.
Sincerely,
Maxim M
(made a correction in sudo code)
Ok, this one is breaking my back all day.
First some sudo-code ->
fuction email_to_user() {
$sql = 'select distinct(email) from user';
$emailfetch = mysql_query($sql);
$sql = 'select news, date from news order by sid desc limit 10';
$news
I guess I'm not really sure then. Just make sure that you used --enable-ftp
if you're using php4, and
--with-ftp if you're using php3. I don't know of any config settings that
need to be set in php.ini to enable ftp support.
If you don't end up getting the ftp functions to work, you could try u
You only want to retrieve the news from your table once.
So, pull pull this code:
> $container[] = $message;
> while (list($news, $date) = mysql_fetch_row($newsfetch)) {
> $container[] = '' . $news . '';
> $container[] = '';
> }
> $container[] = '';
outside of (before) this loop:
thanks all for the response. i tried various methods but still have no luck.
using virtual:
i got the following warning:
Warning: Unable to include 'myscript.cgi' - request execution failed in
/[dir-path]/index.php on line 71
any more clues?
thanks!
/bw
-Original Message-
From:
In my opinion, you should always single quote everything, including numerics. Why?
Say you have a:
$sql = "Delete from table where id=$id";
where id is expected to be numeric.
What if the variable id ends up containing:
7 or id>0
So the sql would end up as
$sql = "Delete from table where id=
On your first email you loop through all the news in the $newsfetch
resource. I think you need to then do a mysql_data_seek() call against
that to reset it for the next time through the loop. Otherwise you'll
just get a null result because you're already at the end of the data.
-Steve
On Wedn
You can also use this mySQL syntax:
INSERT INTO table SET
field1='$value1',
field2='$value2',
...etc
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
> -Original Message-
> From: chris allen [mailto:[EMAIL
Have you considered simply using require_once?
Also, you can find out if a class was defined by calling
'class_exists()'. In this way you might save something.
The best way thought is what Miguel was saying: load the files
conditionally with a logic.
Sincerely,
Maxim Maletsky
Founder, Chief
Hello,
I am running the module version of php(4.0.5) AND have a cgi
version compiled. The cgi version is php 4.1.1(compiled with
--enable-discard-path) and this is on a sunOS 5.8 box. I am trying to run
a setuid wrapper that calls a .php4 script. Whenever I enter
the url to the .cgi wrap
Just for reference, there is www.alt-php-faq.org
as well as www.devnetwork.net the home of the PHP Developer's Network
We might be able to work something out in providing assistance to this
effort.
Jason Lotito
www.devnetwork.net - The PHP Developer's Network
www.newbienetwork.net
- Origina
Its always the simplest things...
I moved the sql stuff for the news into the first while loop, and it
seems good.
Thanks for waking me up...
Steve Cayford wrote:
> On your first email you loop through all the news in the $newsfetch
> resource. I think you need to then do a mysql_data_seek() c
Dear Tyler,
Not sure if this is the right procedure, but works!
Since PHP ftp works under Apache, I need to re-compile,
re-install, and re-start the Apache, then I do see
the ftp info on phpinfo(), and things working ok.
Thanks for your quick reply!
--Wo
- Original Message -
From: "T
On Wed, 3 Apr 2002, Rick Emery wrote:
> Convert to date/time variable and perform arithmetic.
> Otherwise, if these dates are from mysql, let mysql do it
Even if you don't happen to be getting the date out of MySQL, it can
occasionally be easier to let MySQL do your date math since it has some
ni
On Wed, 3 Apr 2002, Jason Lotito wrote:
> Just for reference, there is www.alt-php-faq.org as well as
> www.devnetwork.net the home of the PHP Developer's Network
>
> We might be able to work something out in providing assistance to this
> effort.
Definitely. But a mailing list FAQ is a differen
I wrote a small piece of code to take a text file with
a list of email addresses in it one per line and send out
an email to each of them like so...
$headers = "From: [EMAIL PROTECTED]\r\n";
$headers .= "Reply-To: [EMAIL PROTECTED]\r\n";
$message = "Blah Blah Bla
On Wednesday, April 3, 2002, at 03:58 PM, Miguel Cruz wrote:
> On Wed, 3 Apr 2002, Rick Emery wrote:
>> Convert to date/time variable and perform arithmetic.
>> Otherwise, if these dates are from mysql, let mysql do it
>
> Even if you don't happen to be getting the date out of MySQL, it can
> o
> I'd actually like to use MySQL's builtin date formats, but I like the
> timestamp that PHP uses (and I like what I can do with a timestamp in
> the date() function) so I have been using VARCHAR(20) to hold the date
> as a string. MySQL's TIMESTAMP is not the same thing as PHP's.
But you can si
$arrText[$i] still contains the new-line character at the end. Is that
harmful here?
-Original Message-
From: Jack Davis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:16 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mail() problem...
I wrote a small piece of code to take a tex
On Wed, 3 Apr 2002, Jack Davis wrote:
> mail("$arrText[$i]", $subject, $message, $headers);
mail (trim($arrText[$i]), $subject, $message, $headers);
miguel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, 3 Apr 2002, Erik Price wrote:
> On Wednesday, April 3, 2002, at 03:58 PM, Miguel Cruz wrote:
>> Even if you don't happen to be getting the date out of MySQL,
>> it can occasionally be easier to let MySQL do your date math since
>> it has some nice functions for it (DATE_ADD, DATE_SUB, etc
I have just install a program called Web Calendar. It suppose to be able to
send reminders via e-mail but I am not sure if PHP is set up to send e-mail
or what is happening. I have turned on debugging and it is showing that
there are remembers but it not sending anything.
Is there a simple test I
On Wednesday, April 3, 2002, at 04:14 PM, Rasmus Lerdorf wrote:
> But you can simply call MySQL's UNIX_TIMESTAMP() function on the mysql
> field when you select it if you want it into unix timestamp format.
For SELECTs, this is fine, but what happens when I want to insert a new
date? I trans
date()
On Wed, 3 Apr 2002, Erik Price wrote:
>
> On Wednesday, April 3, 2002, at 04:14 PM, Rasmus Lerdorf wrote:
>
> > But you can simply call MySQL's UNIX_TIMESTAMP() function on the mysql
> > field when you select it if you want it into unix timestamp format.
>
> For SELECTs, this is fine, bu
> as a string. MySQL's TIMESTAMP is not the same thing as PHP's.
Let me be the devil's layer here, Erik.
In order to achieve the best portability and to gain the best
performance you'd better use mySQL date field types to store the dates.
If you need the PHP timestamps you can simply use anoth
send an email to yourself:
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:26 PM
To: PHP General
Subject: [PHP] Help with e-mail...
I have just install a program called Web Calendar. It suppose to be able to
send reminders via e
Just insert the date: like NOW(), or whatever formatted string into the
field
PS: YAY! In Attack!
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
> -Original Message-
> From: Erik Price [mailto:[EMAIL PROTE
Have you got access to your host machine?
You can send messages to your local user a then see if they reach
destination.
Chuck "Pup" Payne wrote:
> I have just install a program called Web Calendar. It suppose to be able to
> send reminders via e-mail but I am not sure if PHP is set up to send e
In two words - here's your bible, Erik:
http://www.mysql.org/documentation/mysql/bychapter/manual_Reference.html
#Date_and_time_functions
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
www.phpbeginner.com
[EMAIL PROTECTED]
> -Original Message---
Is there any free app. for php coding? I tried komodo but I can't get it
to work in debug mode. Also tried Zend's Studio but it expires. :(
Is there any free choice?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
>Have you considered simply using require_once?
Yes, actually I'm using it now, but it's not enough.
>Also, you can find out if a class was defined by calling
>'class_exists()'. In this way you might save something.
>The best way thought is what Miguel was saying: load the files
>conditionally wi
I've installed Apache 1.3.23 on Windows 2000 and PHP 4.1.2 on it. I
can't seem to get any session variables set using any of
$_SESSION/$HTTP_SESSION_VARS/session_register() methods to work. My temp
file is valid and track_vars is turned on. I can see that in the temp
folder my session vars are sto
Thanks! I was able to send an e-mail so now I have to figure out why this
guy script isn't sending reminders
Chuck
On 4/3/02 4:30 PM, "Rick Emery" <[EMAIL PROTECTED]> wrote:
> send an email to yourself:
>
> mail("[EMAIL PROTECTED]","test subject","This is my test message","From:
> [EMAIL
On Wed, 3 Apr 2002, Tamás Árpád wrote:
> >Also, you can find out if a class was defined by calling
> >'class_exists()'. In this way you might save something.
> >The best way thought is what Miguel was saying: load the files
> >conditionally with a logic.
> That's what I'm trying to do, but still s
I wanted what Rick Emery sent to me...
This little example on how to make php talk to sendmail...
He little script help show me that php is working with sendmail. Our e-mail
been working now for 4 years...just this send_reminder.php that is a part of
Web Calendar isn't sending any maul. So bec
On Wed, 3 Apr 2002, Chuck "PUP" Payne wrote:
> Thanks! I was able to send an e-mail so now I have to figure out why this
> guy script isn't sending reminders
If it's going to send mail at arbitrary times in the future, something
needs to make it run at those times. Does it come with a compone
I find php.faqts.com very useful. Anyone can edit/add
questions/answers anytime, don't hesitate to do so. Also,
searching the various mailing lists is very good too.
Regarding how to post and ask a question, try:
What are some ways to get PHP support?
http://www.faqts.com/knowledge_base/v
Ivan Voras wrote:
> Can anyone tell me how to get java support for php working? I compiled
> apache with -pthread option, I properly configured php.ini
> (phpinfo() agrees), but I cannot overcome this:
>
> (the message appears as a PHP error when trying to create any java objects)
>
> Fatal erro
Hello All!
I think this is a pretty simple question. I have a file that I am writing
information to and when the process is complete, I am needing to send the
file to the user. In Javascript all I would need to do is window.open() and
the file would be sent to the user (it's a .csv file). How wou
Use header to start file download:
http://www.php.net/manual/en/function.header.php
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
> -Original Message-
> From: Joe Keilholz [mailto:[EMAIL PROTECTED]]
> Sen
oh, i thought there was supposed to be some software or stuff in the pear
directory (which doesnt exist)
so i just create one and put the package i downloaded into it, then add the
line to php.ini and use it in my scripts. dats it?
and i need no permissions to use the stuff on the server? i dont
You can say something like:
window.open("",
"target",
"resizable,status,width=500,height=200");
On Wed, 3 Apr 2002, Joe Keilholz wrote:
> Hello All!
>
> I think this is a pretty simple question. I have a file that I am writing
> inf
If you plan to touch the php.ini file then you will need the root access
to the machine (you will at least have to restart the server).
Pear can also work without touching php.ini, just add into .htaccess
what you wanted to add into php.ini:
php_value ...
Furthermore, since PEAR itself is j
i have to interact with a php script on a distance server through one of my
scripts. i need to pretend i posted a form from my script... i understand
there's 2 options. sockets and a PEAR thingy for HTTP POST n stuff. i was
reading bout sockets in d php dev cookbook and its just really confusing.
CURL?
http://curl.haxx.se
And I quote:
"Curl is a tool for transferring files with URL syntax, supporting FTP, FTPS, HTTP,
HTTPS, GOPHER,
TELNET, DICT, FILE and LDAP. Curl supports HTTPS certificates, HTTP POST, HTTP PUT,
FTP uploading,
kerberos, HTTP form based upload, proxies, cookies, user+
Try PHP Coder (not Maguma's Version, becuase PHP Coder kicks it's ass)
I can email you the installed, as there site seems to be down now..
Eric
- Original Message -
From: "javier" <[EMAIL PROTECTED]>
To: <>
Sent: Wednesday, April 03, 2002 4:40 PM
Subject: [PHP] php+myslq+IDE
> Is the
Hello,
Is there any way inside an included file to figure out what its actual
UNIX filename is ?
For example:
file1.php --
file2.php --
That is, file2.php needs to know whether it's executed in the context of
file1.php or autonomously. I guess I could change $PHP_SELF before
including file2
Check the constants section of the manual...
__FILE__ (case-insensitive)
The name of the script file presently being parsed. If used within a file
which has been included or required, then the name of the included file is
given, and not the name of the parent file.
On Wed, 3 Apr 2002, Mikhail
Try this:
function whatFile($f) {
$LOCALS['fname'] = $f;
}
$then in the file of yor interest do this:
whatFile(__FILE__);
and wherever next you will want to have that value the file name will be
within $fname;
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (W
Among other user preferences, I need to record their time zone, so that
timestamps retrieved from a database can be displayed in their local time.
There are all sorts of schemes for this, providing varying levels of
detail (for a lot of detail, have a look in /usr/share/zoneinfo!). I would
proba
I use php4.0.5, OS : WIN2000, Webserver : Apache
I want to use session to make global variable
in file php.ini.
I have set item below become enabled
- register_globals
- auto_start
- use_trans_sid (to compiled with --enable-trans-sid)
in my first file myfirst.php, I register session
probably your browscap.ini is outdated or missing.
On Wed, 3 Apr 2002 13:53:15 -0500, Joshua E Minnie wrote:
>Can anybody tell me why, when running on the same browser, I get 2
>different
>outputs.
>
>This is the output when I echo $HTTP_USER_AGENT:Mozilla/4.0
>(compatible; MSIE 6.0; Wind
On Thu, 4 Apr 2002, N.D. Andini wrote:
> and on second file mysecond.php, I get value of those session to check
> session value like below:
Here add:
session_start();
> print $ses_useid;
> print $ses_usename;
miguel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, vis
"Mikhail Avrekh" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You can say something like:
>
>
>
> window.open("",
> "target",
> "resizable,status,width=500,height=200");
>
>
>
>
> On Wed, 3 Apr 2002, Joe Keilholz wrote:
>
> > H
Ok, here's my question:
I have a set of pdf files that I am selling. I want the users of my site,
when they buy the files to be able to only view them if they are acquired,
so I need to restrict access to them. Could I set the permissions on them so
they are not publicly viewable, and then make a
On Wed, 3 Apr 2002, Keith Posehn wrote:
> Ok, here's my question:
>
> I have a set of pdf files that I am selling. I want the users of my site,
> when they buy the files to be able to only view them if they are acquired,
> so I need to restrict access to them. Could I set the permissions on them
I run a site where users can, among other things, adopt virtual pets. I
have several admisistrators on the site, and I am trying to create a thing
that adds a new pet species through the administrator control panel without
me having to ftp it. It takes four files: red happy, red sad, blue happy,
the dynamic portion of the recently launched
www.affero.com has been implemented with php /
smarty / postgreSQL.
the source can be downloaded here:
http://www.affero.org/source/latest.tar.gz
i would not call this a 'distribution' by any
stretch of the imagination. for one thing, it will
Exactly!
The CSV file I attached to the original post is a pretty good example of a
list FAQ.
I'll have a go at it soon, and offer it up for modification, since I know
that i'm not "guru" enough to get it all right :)
Justin French
on 04/04/02 8:01 AM, Miguel Cruz ([EMAIL PROTECTED]) wrote:
Please send it to me. Since php coder became maguma I think they shut
down the former site.
Eric Coleman wrote:
> Try PHP Coder (not Maguma's Version, becuase PHP Coder kicks it's ass)
>
> I can email you the installed, as there site seems to be down now..
>
> Eric
>
> - Original Message
First thing I noticed:
Website looks VERY similar to www.php.net.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Lee Doolan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 7:11 PM
Subject: [PHP] re
Hi all,
This has been an interesting thread to read this morning.
I think we are clouding a few issues here, so if I may, I'd like to do a bit
of a summary.
Whilst I think that a general, searchable, web based FAQ (list of frequently
asked questions, with code snippet answers) contributed to
In the following statement, can someone tell me what I would need to escape
out if I were to put it all into a variable (I know the quotes, but that's
all) :
if (!$name){
$error_msg.="Your Name \n";
}
Thanks,
Rob
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: ht
Yes.. I found that there.
My site doesn't allow .htaccess - now I'm off to find out why.
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> On Wednesday 03 April 2002 12:06, lmlweb wrote:
> > How can I do that - controlling via .htaccess? Pointing me to references
> > w
I don't like it, it looks like you copied php.net
- Original Message -
From: "Tyler Longren" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lee Doolan" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 8:21 PM
Subject: Re: [PHP] request for comments
> First thing I noticed:
> Website l
Here is a little something that makes my life easier. I hope it can help
some of you.. It's for Windows (Active Desktop).. Just paste the code below
into a text file and rename it to somefile.html.. Put it in My Docs or
somewhere then add it as on item on your desktop.. Resize it to your liking
an
Hi
One method is to use javascript to get the clients date/time then create a
diff between that and your time and use it to change the display times.
Here is a demo of getting the remote date and time
Untitled