[PHP] Re: Mysql export
I've found the best way is to set up a MyODBC link. You can download MyODBC from http://mysql.com/downloads/api-myodbc.html It's a bit complicated, but you get excellent results! - Nikhil Roman wrote: Please help me, how to export mysql table to the xls table ? Thanks for all Roman -- 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] mailing list
nope, that's not it. sorry Nikhil Richard Lynch [EMAIL PROTECTED] wrote in message 051c01c0d2e1$2f9bfb40$7a24fea9@oemcomputer">news:051c01c0d2e1$2f9bfb40$7a24fea9@oemcomputer... start sending email (this process would take many minutes). However before this script finished, another copy of the same script started, and this new copy was sending emails to the same users again. The original script continued. Result: duplicate emails Wild Guess: You are using cron and have the settings in your crontab incorrect. For example: * * * * * 0 /full/path/to/your/spam/script This would attempt to execute the script on Sundays. EVERY MINUTE, during Sunday, however. Disclaimer: I probably got the *'s and 0 mixed up a bit. I'm not a crontab expert. -- WARNING [EMAIL PROTECTED] address is not working -- Use [EMAIL PROTECTED] Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm -- 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] Session Variables
When does a session variable become available? Immediately after the session_register command or after the script ends? And if the commands are as follows: session_start(); session_register(hello); $hello=3; will the session variable $hello be set to 3 or do I have to add another session_register() call after changing the value? Really appreciate any help, Nikhil -- 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] Session Problems....HELP!!!!
the session_start() should be placed at the top, before the HTML ?php session_start(); ? html head ... ?php session_register(test) ... Nikhil Bruno Freire [EMAIL PROTECTED] wrote in message 454D444FF5C0D211891800A0C98C7D90359A54@SERVIDOR">news:454D444FF5C0D211891800A0C98C7D90359A54@SERVIDOR... Hi! my name is bruno, from Brazil and i'm having some problems with sessions. Look my code: html head ... /head body ?php session_start(); session_register(test); ? /body /html The message returned in my browser is: Warning: Cannot send session cookie - headers already sent by (output started at /home/httpd/html/intranet/teste.php:11) in /home/httpd/html/intranet/teste.php on line 12 Warning: Cannot send session cache limiter - headers already sent (output started at /home/httpd/html/intranet/teste.php:11) in /home/httpd/html/intranet/teste.php on line 12 !-- A { text-decoration: none; } A:hover { text-decoration: underline; } H1 { font-family: arial,helvetica,sans-serif; font-size: 18pt; font-weight: bold;} H2 { font-family: arial,helvetica,sans-serif; font-size: 14pt; font-weight: bold;} BODY,TD { font-family: arial,helvetica,sans-serif; font-size: 10pt; } TH { font-family: arial,helvetica,sans-serif; font-size: 11pt; font-weight: bold; } //-- What's wrong??? Maybe the PHP's configuration file... Or some command is needed first Please, if somebody know the solution...help me. Thanks. Bruno -- 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] Session Variables
so the session variable is set only when the script ends? I thought you indicated that they were set immediately... Thanks for the quick reply, Nikhil Johnson, Kirk [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The session variable values get stored to the session file (or database, or wherever your configuration is set to store them) at the end of script 1. When session_start() is called in script 2, those values get restored from the session file. So, your results are expected: PHP needs to store the session values from script 1 before they can be retrieved by script 2. Kirk -Original Message- From: Nikhil Goyal [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 2:41 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Session Variables Funnily - doesn't work for me. Here's what I got: Script #1 #!/usr/local/bin/php ?php session_start(); if (!isset($count)) { echo Setting count; session_register(count); } else echo $count; $count++; sleep(60); ? Script #2 #!/usr/local/bin/php ?php session_start(); echo $count; ? If I start script#1 (and it sleep()s), wait 10 seconds, then launch script #2 in a separate browser window, script #2 returns empty. However once the sleep() is completed and I refresh the window with script #2, the output is okay (1). Why does this happen? Nikhil Johnson, Kirk [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... -Original Message- From: Nikhil Goyal [mailto:[EMAIL PROTECTED]] When does a session variable become available? Immediately after the session_register command or after the script ends? Immediately after it is assigned. And if the commands are as follows: session_start(); session_register(hello); $hello=3; will the session variable $hello be set to 3 or do I have to add another session_register() call after changing the value? No additional calls are needed. You will need to do session_start() on the next page if you want to access $hello there. Kirk -- 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] Is PHP code software?
I read about a PHP compiler for windows some time back - that qualifies PHP as software, or actually code analogous to C/++ right? Kath [EMAIL PROTECTED] wrote in message 002201c0cf58$c26d7980$[EMAIL PROTECTED]">news:002201c0cf58$c26d7980$[EMAIL PROTECTED]... Food for thought: Is PHP code software? - Kath -- 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] include whole directories?
you could create a common include file for each directory, for e.g. functions/auth.inc.php would contain: include (auth/auth1.php); include (auth/auth2.php); ... later you could just include() the auth.inc.php file, and all the rest qould get included as well andrew [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Is there any way to include whole directories? I have my function declarations in many small, easily maintainable files, but it's a pain to include/require them all individually...I would like to just split them into directories by common purpose, e.g functions/auth functions/content functions/modules and then include a directory at once - any ideas? cheers! andrew -- 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] mailing list
Hello people, I came with this problem to the group a while back, got some suggestions, and have been working on them since then. I know post the query again from a new perspective I have a mysql database, which contains a lot of email addresses and various other fields. My PHP code generates a list of email addresses based on certain criteria, and I have to send a fixed text body to each of these email addresses. This is my mailing list server. The idea was to be able to send out multiple mailing lists using the same database The mail is sent using fsockopen and SMTP commands, I loop over each email address: The problem was the users were getting multiple copies of the email. After much frustration, I found that what was happening was that the script would start sending email (this process would take many minutes). However before this script finished, another copy of the same script started, and this new copy was sending emails to the same users again. The original script continued. Result: duplicate emails I tried setting the script timeout to a large value, but no effect. I have managed to catch (and stop) the execution of the second copy, and hence prevent duplicate mails, but I have no idea _why_ this copy was being spawned... Can anybody help me out here? I would really appreaciate any help! 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] exclusive execution
I need to set up a script such that only one instance of it is running at a time i.e. in case the script is already executing, it will not be started again. My problem is on a script taking a long time to execute (like it should) - I find that for some reason the script stops somewhere in the middle and starts to re-execute. I wish to catch this re-execute and halt the script instead 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] exclusive execution
sounds like a good idea. how to I get the process id? John Donagher [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... One solution would be to have the script write it's process ID in some .pid file. Since a process ID is per instance of the script, this should provide you with the functionality you're looking for. John On Fri, 27 Apr 2001, Nikhil Goyal wrote: I need to set up a script such that only one instance of it is running at a time i.e. in case the script is already executing, it will not be started again. My problem is on a script taking a long time to execute (like it should) - I find that for some reason the script stops somewhere in the middle and starts to re-execute. I wish to catch this re-execute and halt the script instead N -- John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD -- 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] exclusive execution
ok i got getmypid() Extending the same concept, is it possible for ANOTHER script to check whether this script has completed execution or is still running? N John Donagher [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... One solution would be to have the script write it's process ID in some .pid file. Since a process ID is per instance of the script, this should provide you with the functionality you're looking for. John On Fri, 27 Apr 2001, Nikhil Goyal wrote: I need to set up a script such that only one instance of it is running at a time i.e. in case the script is already executing, it will not be started again. My problem is on a script taking a long time to execute (like it should) - I find that for some reason the script stops somewhere in the middle and starts to re-execute. I wish to catch this re-execute and halt the script instead N -- John Donagher Application Engineer Intacct Corp. - Powerful Accounting on the Web 408-395-0989 720 University Ave. Los Gatos CA 95032 www.intacct.com Public key available off http://www.keyserver.net Key fingerprint = 4024 DF50 56EE 19A3 258A D628 22DE AD56 EEBE 8DDD -- 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] checking if e-mail address and syntax are valid
I wrote a similar script of my own... Works fine for me function email_valid($email) { $pattern=^[0-9a-zA-Z_-]+(\.[0-9a-zA-Z_-]+)*@[0-9a-zA-Z_-]+(\.[0-9a-zA-Z_-]+ )+$; return ereg($pattern, $email); } (returns false if email is not valid, true if it is) N Martin Skjöldebrand [EMAIL PROTECTED] wrote in message 9c4npf$ojq$[EMAIL PROTECTED]">news:9c4npf$ojq$[EMAIL PROTECTED]... Carlos Fernando Scheidecker Antunes wrote: Hello all! I would like to know if anyone has or know any PHP code to verify if a form entered e-mail address is valid? I would like that things like 4$%^%$@@.com.br could not be sent. I only has to verify the syntax of it, the existance I believe should be harder to verify but if it is possible I would be glad if anyone could point me the way. This is taken from PHP Developers Cookbook. Don't ask me exactly what it does, because I don't know. I think I can grasp the basics of it though. It isn't fool proof tho. if (!eregi (^([a-z0-9_]|\\-|\\.)+@(([a-z0-9_]|\\-)+\\.)+[a-z]{2,4}$, $users)) die (Invalid email); M. -- 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] what is better? mysql_connect() or mysql_pconnect()?
I believe a good article is at http://www.php.net/manual/en/features.persistent-connections.php elias [EMAIL PROTECTED] wrote in message 9c3fi6$edm$[EMAIL PROTECTED]">news:9c3fi6$edm$[EMAIL PROTECTED]... hello... just asking...what is better in this case: i got lots of scripts and almost all of them needs to connect to the DB and some of thems are accessed lots of times what is better to use in such cases: mysql_connect() or mysql_pconnect()... i mean will speed factor play a role when lots and lots of user tries to connect to the DB? -elias http://eassoft.cjb.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 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]PHP script and new window.
Plutarck [EMAIL PROTECTED] wrote in message 9c2gdi$170$[EMAIL PROTECTED]">news:9c2gdi$170$[EMAIL PROTECTED]... First of all, I believe since you are using javascript on your button you shouldn't use type=submit. Change it to type=button, which means it will have no effect for browsers that don't have javascript enabled when clicked. That could be an error, for one. But then again, it might not. I had a similar requirement - to run a javascript when a form is submitted. the best way to do this was to remove the 'onClick' event from the submit button and instead make an 'onSubmit' event on the form but remember that onSubmit must return true is the form is to be submitted, false if the form is NOT to be submitted. It must return. It might cause it to be submitted to one page and opened on another, which very well may be what you want to happen. However it might be that the Another good way to do that is to add a TARGET=_blank option to the FORM tag. Or you can add a TARGET=windowname option, where windowname is a window which your onSubmit code opened. This will submit the code and display results in a new window 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] Using input type = 'button rather than input type = 'submit'
also, using Method = POST will not show the vars in the URL, though it will be passed. Make it METHOD=GET to show it in the URL. N Rene Maldonado [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi I think it woulf be better this way: print form action = '$PHP_SELF?action=1' method = 'post' name = 'hello'; print input type='text' name='var_hello'; print input type = submit value = 'Submit' ; and, the var name is $var_hello this way, the value of your var do not appear in the URL, This work for me... Martin Cameron wrote: Here is a simple form file that needs to pass a variable - $hello - from the form to a new function. Unfortunately, it doesn't. When you click the submit button, the URL looks like this: http://localhost/test5.php?action=1hello= It should have the variable there after the hello= I suspect it's something to do with parent.location. Looking for a solution. Here's the script: head /head body bgcolor=white ? define(INITIAL_PAGE,0); define(SELECT,1); function initial_page(){ global $PHP_SELF,$hello; print form action = '$PHP_SELF?action=1' method = 'post' name = 'hello'; print input type='text' name='hello'; print input name = 'hello' type='button' value='Submit' onClick=\parent.location='$PHP_SELF?action=1hello=$hello'\; print /form; } function select(){ global $hello; print Hellooo, $hello!; } initial_page(); switch($action){ case INITIAL_PAGE: initial_page; break; case SELECT: select(); break; default: die (Hello, can't find that function.); } ? /body /html The thing is that if you simply hit enter - rather than click the submit button, the first directive in the form tag is invoked, and the value of the $hello variable IS passed. regards Martin Cameron -- -- 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] newbie question: duplicate emails
Hello people, I am having a peculiar problem with my mailing list and hope you can help me out. I have a mySQL database with a table of email addresses for the mailing lists. I have many lists, and my (PHP) code runs various queries on this table to generate lists of email addresses to which the mail has to be sent. The email body is combined with this generated list, and then I use mail() to send this message out to each recipient. I also add on a few headers such as From:, Errors-To, Reply-To and Return-Path to the message. Now the problem is that every recipient of my mail is getting two copies of the message. I am positive that it's not my code which is causing the problem, the script runs once and terminates. I've also tried to send mail by opening a socket connection to port 25 on the mail machine and sending SMTP commands, but still the result is the same. And there is no SMTP error generated. Can anybody help me out here? or perhaps suggest a more efficient way of sending out mail to my users? I'm really in a spot here... - Nikhil -- 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] newbie question: duplicate emails
Yes, that is a sound approach. However I've checked it again, and again, and again, and nothing pops up. It would be easier if I had an error generated. I'll try to get my hands on the SMTP logs, will talk to the server admin about that. My code is sending data to the SMTP socket and monitoring responses for the SMTP server, and no error there. Here is how it goes HELO xxx MAIL FROM: (me) RCPT TO: (recipient 1) DATA (body) . RSET MAIL FROM: (me) RCPT TO: (recipient 2) DATA (body) . (and so on...) QUIT I've noticed that the error shows up when the server load is high: for e.g. when I am sending out emails to the lists, generally the first list goes through without a problem (i.e. one email per person). But when it moves on to the second list, it starts sending two copies. But sometimes the second list goes okay, and the third generates duplicates. What _is_ the best way to send one email body to a dynamically generated list of email addresses??? Phillip Bow [EMAIL PROTECTED] wrote in message 9c2570$56q$[EMAIL PROTECTED]">news:9c2570$56q$[EMAIL PROTECTED]... Whenever you are positive its nto your code then check it again. That being said are there any SMTP logs you can check? Have you monitored the exact data being sent to the SMTP server(maybe set up a dummy socket that repeats back the data sent to it then have your program try to connect to that)? -- phill Nikhil Goyal [EMAIL PROTECTED] wrote in message 9c1ujm$868$[EMAIL PROTECTED]">news:9c1ujm$868$[EMAIL PROTECTED]... Hello people, I am having a peculiar problem with my mailing list and hope you can help me out. I have a mySQL database with a table of email addresses for the mailing lists. I have many lists, and my (PHP) code runs various queries on this table to generate lists of email addresses to which the mail has to be sent. The email body is combined with this generated list, and then I use mail() to send this message out to each recipient. I also add on a few headers such as From:, Errors-To, Reply-To and Return-Path to the message. Now the problem is that every recipient of my mail is getting two copies of the message. I am positive that it's not my code which is causing the problem, the script runs once and terminates. I've also tried to send mail by opening a socket connection to port 25 on the mail machine and sending SMTP commands, but still the result is the same. And there is no SMTP error generated. Can anybody help me out here? or perhaps suggest a more efficient way of sending out mail to my users? I'm really in a spot here... - Nikhil -- 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]