Re: [PHP] Automatically send email on special day
Hey guys, you're all making this too dificult. Windows NT, Windows 2000, Windows XP, and even Window 98 all have a built in schedule utility. On NT, it's accessed via the AT command. In order to use it, the Scheduler system service must be installed. Once it's installed, tell it to call the PHP executable with the script which sends the emails as the first paramter. For example, on widnow NT you could schedule the following: AT 06:00 /every:M,T,W,Th,F,Sa,Su c:\myscripts\gobirthday.bat The contents of gobirthday.bat would be only one line, c:\php\php.exe c:\myscripts\gobirthday.php then every day at 6:00am the batch file gobirthday.bat would be ran which executes the gobirthday.php script. now it doesn't matter whehter you have visitors at all to your site. Every morning the birthday emails will get sent. David - Original Message - From: Liam MacKenzie [EMAIL PROTECTED] To: NoWhErEMan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 10:11 PM Subject: Re: [PHP] Automatically send email on special day when the function excecutes, it checks the current date, then looks in a little textfile, if it's a match, it stops the script, but if the text file says a different date, it processes the scripts then updates the text file. Follow me? You could also use a MySQL database. - Original Message - From: NoWhErEMan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 3:08 PM Subject: Re: [PHP] Automatically send email on special day I can ensure ar least one visitor per day, that;s me!! Since my server in on my local windows mechine, i can load the page at start up. But i have a question, how can i ensure the script only runs once though, per day? I think it is related to coding Say, my index.php have a script to check current day and send the email if birthday. However, when more than one visitor on index.php, it will send duplicated email Nowhereman César aracena [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó·s»D :001e01c24414$789a5490$[EMAIL PROTECTED] Not ignored Lian. That idea is great but only if you are 100% sure that your site is going to have at least one visitor per day. If you want to setup a script like that in your pet's dedicated page, which maybe will not have that many visitors at first, you will probably miss a lot of appointments. In the other hand, if Hotmail or Yahoo want to do that... fine... I think they WILL have at least ONE visitor per day for sure. C. -Original Message- From: Liam MacKenzie [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:22 AM To: 'NoWhErEMan'; [EMAIL PROTECTED] Subject: Re: [PHP] Automatically send email on special day Hey, if you don't have access to CRON, you could try and include the page in your index.php. Set it so it only runs once though, per day. That means that as soon as someone visits your site they activate it for that day. It'd only work if you had the traffic though. Just an idea. Then again, I'm having one of those days Ignore me... - Original Message - From: César Aracena [EMAIL PROTECTED] To: 'NoWhErEMan' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 2:17 PM Subject: RE: [PHP] Automatically send email on special day This have been very much discussed in this list, and the only logical way of doing this through PHP would be to have a script that reads the actual date of the server's system once a day, but that would be just impossible without having that script (page) reloaded at least once a day. I think there are two way of doing this. First, would be to setup a cron job under unix (which I don't know so I'm guessing here) and second, which is the easiest, would be to have that script in a page with refreshing META tags, so it would refresh itself every 24 or 12 hours. Does this make any sense? C. -Original Message- From: NoWhErEMan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:03 AM To: [EMAIL PROTECTED] Subject: [PHP] Automatically send email on special day Hi all, My site maintain a list of members, which i knew their birthday, and i want to send a email greeting to them on their birthday, of course, automatically. How can i do that? Thanks in advance Nowhereman -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General
[PHP] Re: PHP native session
Hi! There are several ways. You could use a database or a text file. If your server comes with dba support, I'd try that. Manual reference http://www.php.net/manual/en/ref.dba.php /lasso ([EMAIL PROTECTED]) Mattia wrote: I'm looking for a way to have a list of the users logged in my site (with a session_start() ). Is it possible to do it with the php4 api? thanks Mattia -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MySQL vs Session?
Which is generally faster/better, doing a SELECT or doing session_start()? Rephrased, are sessions significantly faster/lighter than using MySQL? I'd imagine they are, since they won't need to do a connection or anything, but I am not familiar with how sessions scale. -- Tino Didriksen / Project JJ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL vs Session?
I'd have to say that I haven't done any controlled tests, but mysql can be very slow when you are doing a lot of connections (correct me if I'm wrong, but I think it executes requests in order?). To be untechnical about it and only speak from experience (if I was a typical internet user, I'd think that because it does it for me, it must do it for everyone! :) ), I personally have never found sessions to be slow getting a lot of data, where as I have found it slow with mysql... probably also depends greatly on your server load. I'd imagine that you would see a massive difference on a server that is under load. Bob Which is generally faster/better, doing a SELECT or doing session_start()? Rephrased, are sessions significantly faster/lighter than using MySQL? I'd imagine they are, since they won't need to do a connection or anything, but I am not familiar with how sessions scale. Best Regards Bob Irwin Server Admin Web Programmer Planet Netcom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help please
Hello; I have a Mandrake 8.2 machine that I'm trying to get a php webmail application running on. Apache is running, php is installed, and when I attempt to view/use index.php my browser offers to download index.php for me. I have tried 4 different browsers on three different machines. I have absolutely no idea what I did wrong. Can someone point me in the right direction? Thanks so much in advance. Paul Kelly -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL vs Session?
I'm interested in finding out the answer to this since it seems that I will need to implement my own session handler. I need to pass session information from SSL connections to non-SSL connections (albeit on the same server) and PHP doesn't seem to be able to do this ... Jc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL vs Session?
Sure it can. If the machine name is different make sure you set your session.cookie_domain to something like .domain.com but other than that there shouldn't be anything to it. As long as you propogate the session id somehow to the script, when session_start() is called in that script it will pick up the session data. Do watch out for all the security issues involved in sending session ids over a non-encrypted link though. -Rasmus On Thu, 15 Aug 2002, Jean-Christian Imbeault wrote: I'm interested in finding out the answer to this since it seems that I will need to implement my own session handler. I need to pass session information from SSL connections to non-SSL connections (albeit on the same server) and PHP doesn't seem to be able to do this ... Jc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Batch E-Mail Problem
Actually, the browser outputs every email sent, and runs the following commands every 3,000 mailings: print pausing...brbr; flush(); sleep(15); print resumingbrbr; flush(); // continue so it's not the browser timing out --- Bogdan Stancescu [EMAIL PROTECTED] wrote: Ok, I'm not positive I'm right here, but have you thought about the browser timing out - and not PHP? You may try doing an echo( ); and a flush(); every 100 e-mails or so - and reset max exec time to a reasonable duration while you're at it - that *might* fix it. Please note that executing set_time_limit() also resets the timer, so set_time_limit(20) every 100 e-mails should be more than enough. HTH Bogdan Daren Cotter wrote: I have a PHP script that queries a MySQL database, retrieves email addresses, and sends an email to all members of a website. The problem is this: the PHP script times out after sending about 5,000 mailings, and I have to restart it 10 times in order to mail the entire list! This is an ongoing problem I have had for almost a year now. I have tried MANY things to make this work better, which I have outlined below: 1) Upped the Max Excecution Time in PHP from 30 to a ridiculously high 300 (is this a security issue?) 2) Upped the Max amount of memory a PHP script can have from 8mb to 16mb 3) Running sendmail in deferred mode instead of background mode, and processing the mail queue ever 5 minutes instead of the default 1 hour. Results: 1) The script runs much longer, but still times out. (One thing I want to make clear, even when max execution time is 30 seconds, the script does not stop after 30 seconds, maybe it just means 30 seconds of inactivity?) 2) I have no idea if this is making a difference or not, does anyone know? 3) Since this means mailings get sent right into the queue, and not sent right away, the HTTP interface runs 10 times faster. This would be a GREAT solution for me, but it has one drawback: when a user signs up for the site, their confirmation email must be sent immediately...it cannot sit in the queue until the next time the queue is processed (at most 5 minutes). So, I figure I have two options. Leave sendmail as set to deferred, process the queue every so often, but find a way to have the confirmation emails sent immediately. This is really the option I want to do. The sendmail version I have (latest version), has 4 separate mail queues. Does anyone know how to use PHP to stipulate that some mailings get sent immediately, while others are just queued until the next queue run? Otherwise, I have to set the delivery method of sendmail back to background, have mailings take 10 times as long from the HTTP interface, and try and find some way from keeping the script from timing out and having to restart the mailing. ANY HELP is greatly appreciated! BTW, the server is loaded, dual proc, gig of ram, etc...more hardware has not helped the problem. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Batch E-Mail Problem
I understand this solution, but are you telling me that companies that send millions of emails per day simply use the BCC line in the email? I can't imagine this is the proper way of doing things...I do, after all, need to send 50,000 emails at a time. Can anyone else verify this? --- Manuel Lemos [EMAIL PROTECTED] wrote: Hello, On 08/14/2002 08:54 PM, Daren Cotter wrote: I have a PHP script that queries a MySQL database, retrieves email addresses, and sends an email to all members of a website. The problem is this: the PHP script times out after sending about 5,000 mailings, and I have to restart it 10 times in order to mail the entire list! This is an ongoing problem I have had for almost a year now. I have tried MANY things to make this work better, which I have outlined below: 1) Upped the Max Excecution Time in PHP from 30 to a ridiculously high 300 (is this a security issue?) 2) Upped the Max amount of memory a PHP script can have from 8mb to 16mb 3) Running sendmail in deferred mode instead of background mode, and processing the mail queue ever 5 minutes instead of the default 1 hour. Your problem is that your solution does not scale well. A much more scalable solution is to put all recipients in BCC: and just send one message. It just takes a few seconds to run that. -- Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Stumped: vars not passed!!!
I'm going mad. I've been trying to implement sessions so it will work backward on my older 4.0.3 server ( I'm working on a 4.1.2), with no success as of yet, but I think it's my 4.1.2 that's causing this, as the app in the following example works perfectly on the older one. Note, I have explicitly used the manual URl method to pass variables and NOT the $HTTP_POST_VARS['x'] method as I am suspecting that my register_globals is not working. PS, register_globals, track vars etc IS on on both systems. Look at this: index.php form action=page1.php method=POST enctype=multipart/form-data input type=text name=usernamebr input type=text name=passwordbr input type=submit name=submit /form page1.php a href=page2.php?username=?=$username?password=?=$password?Next/a page2.php form action=page3.php method=POST enctype=multipart/form-data input type=text name=test input type=hidden name=username value=?=$username? input type=hidden name=password value=?=$password? input type=submit name=submit /form page3.php Username: ?=$username? br Password: ?=$password? br Test: ?=$test? br This DOES NOT work on my 4.1.2 system. Why? I know page2 is not needed, but it is still supposed to work right? I deliberatly put it there to extend the path the variable needs to piggy back to see where I lose them, but on my system it loses the vars right at the second page already -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Got another ripper for you all ;-)
trim($ulist[1]); You mean: $ulist[1] = trim($ulist[1]); Trim() returns a modifies copy of the string. It does not alter the original. A lot of the string functions work like that. Luke Welling -- PHP and MySQL Web Development by Luke Welling and Laura Thomson http://www.amazon.com/exec/obidos/ASIN/0672317842/tangledwebdesign -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Got another ripper for you all ;-)
Well, I found out a way to do it... A litte bit more coding than should have been required, but still... $ulist=command(user list name=$username domain=$domain); $ulist[1] = str_replace('Dir: ', '', $ulist[1]); $dir = $ulist[1]; $strlen = strlen($dir); $strlen = $strlen - 1; $dir = substr($dir, 0, $strlen); $dir = $dir./data; if ($handle = opendir($dir)) { $i = 0; while (false !== ($file = readdir($handle))) { if ($file != . $file != ..) { $i++; } } echo $i; closedir($handle); } } - Original Message - From: Liam MacKenzie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 3:38 PM Subject: Re: [PHP] Got another ripper for you all ;-) Nup, still doesn't work. I can't get rid of that newline! Here... Eat your heart out: function get_num_emails($username, $domain) { $ulist=command(user list name=$username domain=$domain); $ulist[1] = str_replace('Dir: ', '', $ulist[1]); trim($ulist[1]); echo |.$ulist[1].|; if ($handle = opendir($ulist[1]/data)) { $i = 0; while (false !== ($file = readdir($handle))) { if ($file != . $file != ..) { $i++; } } echo $i; closedir($handle); } } It's meant to check how many emails that particular user has got, but it can't get the dir listing because of that damned new line! Any more ideas? Cheers, Liam - Original Message - From: Liam MacKenzie [EMAIL PROTECTED] To: Tom Rogers [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 3:32 PM Subject: Re: [PHP] Got another ripper for you all ;-) Oh Whoops Thanks Tom - Original Message - From: Tom Rogers [EMAIL PROTECTED] To: Liam MacKenzie [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 3:34 PM Subject: Re: [PHP] Got another ripper for you all ;-) Hi, Thursday, August 15, 2002, 3:20:47 PM, you wrote: snip LM Is there a way to get rid of any new lines in a string? LM Because this is making my directory listing go whacko. LM Cheers, LM Liam trim($dir) -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Got another ripper for you all ;-)
Damnit! I think I need to go home, or even better, take a holiday for a fortnight. Thanks dude. - Original Message - From: Luke Welling [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:30 PM Subject: Re: [PHP] Got another ripper for you all ;-) trim($ulist[1]); You mean: $ulist[1] = trim($ulist[1]); Trim() returns a modifies copy of the string. It does not alter the original. A lot of the string functions work like that. Luke Welling -- PHP and MySQL Web Development by Luke Welling and Laura Thomson http://www.amazon.com/exec/obidos/ASIN/0672317842/tangledwebdesign -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Batch E-Mail Problem
on 15/08/02 5:17 PM, Daren Cotter ([EMAIL PROTECTED]) wrote: I understand this solution, but are you telling me that companies that send millions of emails per day simply use the BCC line in the email? I can't imagine this is the proper way of doing things...I do, after all, need to send 50,000 emails at a time. Can anyone else verify this? There are two schools of thought. One is the Bcc approach where nothing is personalised. The second is the sending of personalised emails one at a time. This approach has given me heaps of grief, and I'm thinking about returning to the Bcc approach, but some ideas include: a) running the script as a command line script, hence ruling out the browser problems b) running the script via a browser in batches of 100 or 'n', with a 5sec-5min interval between, set-up with meta refresh tags... this is ultimately slower, but has more guarantees. c) running the script using a dedicated mailing list application like ezmlm, taking php out of the equation completely. d) talking to a dedicated mailing-list company, like sparklist.com -- it's not effective for small lists, but for 50,000 people once a month, you get charged the base price of US$50/month. For once a week, it's around $200. Cheers, Justin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Is voice Over Ip posible in PHP
hi, We have a web based text chat application using php, apache and mysql. ( It works on the principle that each client inserts the chat content in the db and the common updated contents are retrieved by contanlty requesting a php page using browser's auto refresh and displaying the chat contents) Now my question is that, is possible to add voice chat in this application using php (or other languages), so that clients need not install any software. Please give some ideas or suggestions to implement the voice chat in our application. Regards
[PHP] Re: Help please
PHP is installed, but are you sure that is loaded by apache?? look the httpf.conf (i have slack but usually is in /etc/apache or /etc/apache2 depends of the version) for a line like this: Include /etc/apache2/mod_php.conf be sure than that line is uncommented. if not, uncomment it and restart apache (apachectl restart) if this don´t work, tellme more about yor system (i guess than you are using apache but i really dont know what server you are using..) let me know, ok? sebastian. Paul wrote: Hello; I have a Mandrake 8.2 machine that I'm trying to get a php webmail application running on. Apache is running, php is installed, and when I attempt to view/use index.php my browser offers to download index.php for me. I have tried 4 different browsers on three different machines. I have absolutely no idea what I did wrong. Can someone point me in the right direction? Thanks so much in advance. Paul Kelly -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] RE: Destroy session variable when IE close
yes but the variables are still held and would be available if you knew the session id. until the garbage collection clears it out the session variables are still there. the session doesn't die when the browser closes, just the browser's reference to it. Tim Ward Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html -Original Message- From: lallous [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 14:44 To: [EMAIL PROTECTED] Subject: Re: Destroy session variable when IE close Afaik, the session will die automatically when IE gets closed. Or at least the cookie that links to that session. Elias Christian Ista [EMAIL PROTECTED] wrote in message 000101c24384$442ab9b0$c000a8c0@p3portable">news:000101c24384$442ab9b0$c000a8c0@p3portable... Hello, Is it possible to set to null (or destroy) the session variables when I close IE ? Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] trans-sid not working
I have compiled PHP with the following: './configure' '--with-pgsql' '--without-mysql' '--enable-track-vars' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--enable-trans-sid' '--with-apache=../apache_1.3.26/' Unfortunately it seems that the --enable-trans-sid option is not working like I expected it. I try and register a session on a browser that does not allow cookies the session does not get registered and no SID is automatically appending to the URL. What did I miss? Jc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] trans-sid not working
On Thursday 15 August 2002 17:06, Jean-Christian Imbeault wrote: I have compiled PHP with the following: './configure' '--with-pgsql' '--without-mysql' '--enable-track-vars' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--enable-trans-sid' '--with-apache=../apache_1.3.26/' Unfortunately it seems that the --enable-trans-sid option is not working like I expected it. I try and register a session on a browser that does not allow cookies the session does not get registered and no SID is automatically appending to the URL. What did I miss? There's also a setting in php.ini (probably under the sessions section) that you have to enable. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* When the only tool you have is a hammer, you tend to treat everything as if it were a nail. -- Abraham Maslow */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Session, error occurs
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Per [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Daniel Canil wrote: I have jsut recently installed a php development kit on my windows platform. Im interested in using the session functions but I am recieving this error when I use session_start(): Warning: open(/tmp\sess_540ded508edf231c47fe85bd970f936a, O_RDWR) failed: m (2) in d:\phpdev\www\phpdev4\samples\samp13.htm on line 4 Run a phpinfo() to see what session.save_path you have registred. It seems like php tries to open from the default directory /tmp. Maybe you have not restarted the web server after altering the php.ini. /Per Hi, Yeh I did restart apache every time i changed the php.ini file, and it still has session_save_path = /tmp. I check through both php.ini and httpd.cong file for the string tmp but there where no matches. I also checked there error log and there wasn't any help in that. ??? It's possible you have more than one php.ini and the one you are editing is not the one php is reading? Again, look in phpinfo() for where php expects to find php.ini. -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Got another ripper for you all ;-)
In article 00c101c2441b$83a612a0$0e00a8c0@luke, [EMAIL PROTECTED] says... Hey guys, yep, another one... I do this: echo -.$dir.-; I get this: -/home/eXtremail/mbox/i-redlands.net/9/1/liam - Note the new line at the end. Is there a way to get rid of any new lines in a string? Because this is making my directory listing go whacko. Cheers, Liam trim() Liam is an Irish name, is it not :-) -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Help please
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hello; I have a Mandrake 8.2 machine that I'm trying to get a php webmail application running on. Apache is running, php is installed, and when I attempt to view/use index.php my browser offers to download index.php for me. I have tried 4 different browsers on three different machines. I have absolutely no idea what I did wrong. Can someone point me in the right direction? Thanks so much in advance Paul Kelly There need to be some AddType entries in your httpd.conf to let apache know what type of files need to be parsed by php. Something like (from one of mine): # AddType allows you to tweak mime.types without actually editing it, or to # make certain files to be certain types. # For PHP 4.x, use: AddType application/x-httpd-php .php .php3 .html AddType application/x-httpd-php-source .phps This will cause .php .php3 and .html files to be parsed by php and will cause .phps files to be shown as highlighted source code. Modify to suit your needs and remember to restart apache after making changed to either httpd.conf or php.ini. Cheers -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] trans-sid not working
The problem what that I was using header(Location: http://mysite.com;) and it seems that PHP will not automatically insert the SID in this case. Now I need to find a quick and simple way to see if cookies are disabled or not. If they are I need to manually add the SID to the header() call . . . Jc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How do I customize the User-Agent when opening a remote file?
How do I customize the User-Agent when using fopen() or file() to open a remote file? PHP use PHP/4.2.3-dev on my system as the User-Agent when I using file() function to retrive a remote file. Howerver, some servers will refuse to serve browsers other than Mozilla compatible and return a 403 code. Is there any method to let me define User-Agent for my own? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Header and Target
Hello, I have some frame on the website, and I'd like specify a target name in the header function, is it possible ? Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] create header and redirecting
I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] select distinct mysql
hy, I have a tabel (history) with fields: id (uniq), date, time, name, etc. I want to select after next rules: - date and time been sort descendent - only 10 recording - value of the field name to be unique syntax must be something this: SELECT *, DISTINCT name FROM history ORDER date DESC, time DESC LIMIT 10 but this not work. how can I do this? this is structure of tabel: id namedate time ...etc -- 1. kale 2002-03-15 14:12_14 2. smith 2002-04-17 15:14:13 3. kale 2002-05-15 16:14:13 . I want that result contains only recordings 2 and 3 not 1 because it's same name and it is older then 3. I use a mysql server. thanks for help kale
RE: [PHP] create header and redirecting
That's my randSession Function function randSession() { $pass_len=8 ; $allchars = 'abcdefghijklmnopqrstuvwxyz0123456789'; $string = ''; mt_srand((double)microtime()*100); for ($i=0;$i$pass_len;$i++) { $string .= $allchars{mt_rand(0,strlen($allchars))}; } return $string; } -Original Message- From: John Wards [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:00 PM To: Reymond Subject: Re: [PHP] create header and redirecting $session_id = randSession(); Think this must be sending out a header John - Original Message - From: Reymond [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:00 AM Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] create header and redirecting
Or maybe not whats line 16? John - Original Message - From: Reymond [EMAIL PROTECTED] To: 'John Wards' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:29 AM Subject: RE: [PHP] create header and redirecting That's my randSession Function function randSession() { $pass_len=8 ; $allchars = 'abcdefghijklmnopqrstuvwxyz0123456789'; $string = ''; mt_srand((double)microtime()*100); for ($i=0;$i$pass_len;$i++) { $string .= $allchars{mt_rand(0,strlen($allchars))}; } return $string; } -Original Message- From: John Wards [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:00 PM To: Reymond Subject: Re: [PHP] create header and redirecting $session_id = randSession(); Think this must be sending out a header John - Original Message - From: Reymond [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:00 AM Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] create header and redirecting
$formy = select id, login, level, is_active from User where login = '$login' AND password=md5('$passwordacting'); $data = mysql_query($formy,$cnx); $result_data = mysql_fetch_array($data); echo $result_data['id']; -- this line 16 , I wanna try to print to browser.., and work good.. echo $row['hasil']; if ($row[result]==0) { .. -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:14 PM To: 'Reymond ' Subject: RE: [PHP] create header and redirecting Reymond, What is Line 16? Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:00 To: [EMAIL PROTECTED] Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] create header and redirecting
AFAIK - you can't echo or print before sending a header. If you want to do this - maybe use meta tags rather than the location redirect. Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:40 To: 'Michael Hazelden' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting $formy = select id, login, level, is_active from User where login = '$login' AND password=md5('$passwordacting'); $data = mysql_query($formy,$cnx); $result_data = mysql_fetch_array($data); echo $result_data['id']; -- this line 16 , I wanna try to print to browser.., and work good.. echo $row['hasil']; if ($row[result]==0) { .. -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:14 PM To: 'Reymond ' Subject: RE: [PHP] create header and redirecting Reymond, What is Line 16? Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:00 To: [EMAIL PROTECTED] Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] create header and redirecting
That's u mean this meta.. meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 I have used it.. I am newbie in php scripting on asp I do Buffer on top of page to redirecting like this below. Response.Buffer = True 'Buffers the content so our Response.Redirect will work .. is it available on php scripting..?? -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:28 PM To: 'Reymond ' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting AFAIK - you can't echo or print before sending a header. If you want to do this - maybe use meta tags rather than the location redirect. Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:40 To: 'Michael Hazelden' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting $formy = select id, login, level, is_active from User where login = '$login' AND password=md5('$passwordacting'); $data = mysql_query($formy,$cnx); $result_data = mysql_fetch_array($data); echo $result_data['id']; -- this line 16 , I wanna try to print to browser.., and work good.. echo $row['hasil']; if ($row[result]==0) { .. -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:14 PM To: 'Reymond ' Subject: RE: [PHP] create header and redirecting Reymond, What is Line 16? Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:00 To: [EMAIL PROTECTED] Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg.
RE: [PHP] create header and redirecting
Actually - I meant: META HTTP-EQUIV=Refresh CONTENT=1; URL=http://your.website.com; This will perform the same thing as the location redirect ... only it does it in the body of the HTML. M. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:55 To: 'Michael Hazelden' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting That's u mean this meta.. meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 I have used it.. I am newbie in php scripting on asp I do Buffer on top of page to redirecting like this below. Response.Buffer = True 'Buffers the content so our Response.Redirect will work .. is it available on php scripting..?? -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:28 PM To: 'Reymond ' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting AFAIK - you can't echo or print before sending a header. If you want to do this - maybe use meta tags rather than the location redirect. Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:40 To: 'Michael Hazelden' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting $formy = select id, login, level, is_active from User where login = '$login' AND password=md5('$passwordacting'); $data = mysql_query($formy,$cnx); $result_data = mysql_fetch_array($data); echo $result_data['id']; -- this line 16 , I wanna try to print to browser.., and work good.. echo $row['hasil']; if ($row[result]==0) { .. -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:14 PM To: 'Reymond ' Subject: RE: [PHP] create header and redirecting Reymond, What is Line 16? Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:00 To: [EMAIL PROTECTED] Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is
RE: [PHP] Re: Got another ripper for you all ;-)
Oi!!! Don't knock the Irish! I got it working eventually :-) -Original Message- From: David Robley [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:27 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: Got another ripper for you all ;-) In article 00c101c2441b$83a612a0$0e00a8c0@luke, [EMAIL PROTECTED] says... Hey guys, yep, another one... I do this: echo -.$dir.-; I get this: -/home/eXtremail/mbox/i-redlands.net/9/1/liam - Note the new line at the end. Is there a way to get rid of any new lines in a string? Because this is making my directory listing go whacko. Cheers, Liam trim() Liam is an Irish name, is it not :-) -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] create header and redirecting
I have print it This print out third.php?id=1session_id=wub8nwrq -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:28 PM To: 'Reymond ' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting AFAIK - you can't echo or print before sending a header. If you want to do this - maybe use meta tags rather than the location redirect. Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:40 To: 'Michael Hazelden' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] create header and redirecting $formy = select id, login, level, is_active from User where login = '$login' AND password=md5('$passwordacting'); $data = mysql_query($formy,$cnx); $result_data = mysql_fetch_array($data); echo $result_data['id']; -- this line 16 , I wanna try to print to browser.., and work good.. echo $row['hasil']; if ($row[result]==0) { .. -Original Message- From: Michael Hazelden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:14 PM To: 'Reymond ' Subject: RE: [PHP] create header and redirecting Reymond, What is Line 16? Michael. -Original Message- From: Reymond [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 11:00 To: [EMAIL PROTECTED] Subject: [PHP] create header and redirecting I have tree pages, we call it first.php, second.php, third.php On My first.php page, I have form (LOGIN FORM) and I'd action it to second page. Like this Below form method=post action=second.php.. In my second page I'd tried to use header, for redirecting to third.php after check the session, in my Session table in my Database, (and I've got the session on my database. second.php .. if ($row[result]==0) { header(location: http://www.blabla/blablba/second.php?message=font color=redIncorrect Password/font); } elseif ($row[result]!= 0) { $id = $result_data['id']; mysql_query(Delete from Session where user = '$id', $cnx); $session_id = randSession(); mysql_query(Insert into Session values('$id','$session_id')); if ($result_data[level]==1) { header(location: third.php?id=$idsession_id=$session_id);--LINE 33 } else { header(location: third.php?id=$idsession_id=$session_id); } } .. --- doesn't got redirecting to the third.php but I got error message on my second.php..., like this below. Warning: Cannot add header information - headers already sent by (output started at /home/unri/ketahanan-pangan/second.php:16) in /home/unri/ketahanan-pangan/second.php on line 32 1. so how to use buffer for redirecting 2. is it right if I give the action(I mean Action Form) in my first.php page to the second.php page..???, note : I have check my Session table On My database (MYSQL), and I got it... Help... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Header and Target
A target name? That's a HTML thing. I think you're confusing header() with HEAD/HEAD I believe. I think it's something like: HEAD BASE TARGET=framename /HEAD But I gave up on frames YEARS ago, so I could be wrong :) Justin French on 15/08/02 7:40 PM, Christian Ista ([EMAIL PROTECTED]) wrote: Hello, I have some frame on the website, and I'd like specify a target name in the header function, is it possible ? Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Header and Target
That's a HTML thing. I think you're confusing header() with HEAD/HEAD I believe. No no I explaine, I do that : FRAMESET FRAMESET rows=80,*,80 FRAME src=top.html noresize scrolling=No border=0 frameborder=No FRAMESET cols=150,* FRAME src=left.html noresize scrolling=No border=0 frameborder=No FRAME src=mainpage.html border=0 frameborder=No name=content /FRAMESET FRAME src=menu.html noresize scrolling=No border=0 frameborder=No /FRAMESET /FRAMESET I'd like to display all my pages in the frame content. Some times, from the menu for example, I do a a href=. target=content that it's ok but sometimes, I call a php page by header( header(Location: mypage.php); ) but I'd like to display the content in content section frame. To do something like that : www.padeg.be Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Header and Target
Which frame calls the header()? When you're in a frameset, each page is an individual HTML file (or PHP file). If you call a header() in top or left, it will redirect the fram you call... it can't possibly call the content frame. PHP happens on the server, Frames happen on the browser. The only possible option would be to redirect the current frame (eg left), and set some values in the URL, which javascript responds to, getting the content frame to refresh as well. header(Location: page.php?frameToChange=contentnewUrl=something.php); Then a javascript (Java'sCrap) on the redirected script would act upon those variables. The result would be that two frames refresh, not just one, but only if JS is enabled on the browser. YUK! Rethink your logic, there has to be another way. Justin French on 15/08/02 9:32 PM, Christian Ista ([EMAIL PROTECTED]) wrote: That's a HTML thing. I think you're confusing header() with HEAD/HEAD I believe. No no I explaine, I do that : FRAMESET FRAMESET rows=80,*,80 FRAME src=top.html noresize scrolling=No border=0 frameborder=No FRAMESET cols=150,* FRAME src=left.html noresize scrolling=No border=0 frameborder=No FRAME src=mainpage.html border=0 frameborder=No name=content /FRAMESET FRAME src=menu.html noresize scrolling=No border=0 frameborder=No /FRAMESET /FRAMESET I'd like to display all my pages in the frame content. Some times, from the menu for example, I do a a href=. target=content that it's ok but sometimes, I call a php page by header( header(Location: mypage.php); ) but I'd like to display the content in content section frame. To do something like that : www.padeg.be Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] new CHM sample [7] is out
Hi! A new CHM sample is out now at http://weblabor.hu/php-doc-chm and it will be announced later this day at php.net. It has many cool new features, including: support for custom skins [two sample custom ones included, and some documentation on how to create your own CSS or graphical skin] more interactive functions [copy an example to clipboard with one click, more context friendly context menus] more online functions [search for selection on google/ alltheweb feature, search engine boxes in context menu] exclusive edition documentation [tips on using full text search or intergating this manual into IDEs, handy keyboard shortcuts] Because of all these, the download size is a bit larger, but it worth it. Everybody is welcome to test and post error reports / opinions to [EMAIL PROTECTED] Now it's time to start planning your own skins ;)) Goba -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Automatically send email on special day
Whay not just set up a page that lists today's birthdays and a button that sends e-mail greetings. You can place this page in a secure directory so everyone who visits can get to it and click the button. a. create page and script b. place in secure directory c. log in each day d. click button HTH! Jay I need somebody really bad are you really bad? *** * Texas PHP Developers Conf Spring 2003 * * T Bar M Resort Conference Center * * New Braunfels, Texas* * San Antonio Area PHP Developers Group * * Interested? Contact [EMAIL PROTECTED] * *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Shared Hosting and Security Qualms ...
This is somewhat off-topic, but has to do with shared hosting. All of my experience with Linux has been on boxes where I've pretty well had the only account. I'm now working on a shared system which provides SSH access. The idea is to host a client's site on this system, but after a few hours of exploring here's why I'm having second thoughts. I can move up the directory tree and see all the other users directories, the contents thereof, and individual files, such as /use/home/other_user/today.html. Permissions are such that I was not able to edit or copy them. (I tried.) The contents of etc/passwd could be listed. mysqlshow listed all the databases on the system; with the mysql console I was able to examine the structure and contents of any of them, with a couple I went further and added a table, inserted records, and dropped the table. I could also insert records (which I subsequently deleted) into existing tables. Call me naive, but is this normal, or should I bail on this arrangement before going any further? It's a BSD system. Comments and opinions are solicited. Regards - Miles Thompson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP news sites
Hi! For one of my projects, I am searching for a list of PHP news sites. I would really love to receive links to these kind of sites, as I only know a few ones. A PHP news site in my mind provides news about PHP, projects using PHP, and may also host articles. I am not interested in forums, mailing lists and other interactive content, just news and maybe articles. Please send links to my personal address [EMAIL PROTECTED] and not to this list. Thanks, Goba -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] stupid question
Liam MacKenzie wrote: Ok, I'm having a blonde day... If $idx == 1, 4 or 9 I don't want it to echo $results. I have this, what's the syntax to put multiple values in there? if ($idx != 1) { echo$results; } Another way to do it is by using in_array(), like so: if (!in_array($idx,array(1,4,9))) { echo $results; } I don't know if that is more or less efficient to the parser, but it looks cleaner IMHO... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Batch E-Mail Problem
Hello, On 08/15/2002 04:17 AM, Daren Cotter wrote: I understand this solution, but are you telling me that companies that send millions of emails per day simply use the BCC line in the email? I can't imagine this is the proper way of doing things...I do, after all, need to send 50,000 emails at a time. Can anyone else verify this? Daren, try to understand things better before you decide what is more viable for you. Many of those companies that send personalized message are in the business of fooling the recipients into believing that they recieve messages from real humans that were meant just for them. Such companies are also known as spammers and they really do not fool most people that they send such personalized messages. Personalized bulk mailing may take hours or days to finish a single bulk delivery and so they are done by specialized programs that do things in a more efficient way for that purpose. Usually they do not even queue messages in the local mailer queue. They compose messages on demand and connect directly to the recipients SMTP servers, establishing hundreds or thousands simultaneous connections, often choking their Internet link. If you are sending solicited messages, you have no need for this. You may simply queue a single message in your local mailer queue and have it do the hard work of delivering the messages. Otherwise it will not be viable for you to do it in PHP as it will consume much more time and much more server resources. If you still wonder that this is the proper way of doing things, I just like to remind you that this is the way that this very same mailing list message is being delivered to you. Otherwise it would not be viable. -- Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Two version of php in the same system
On Wed, Aug 14, 2002 at 07:43:40PM -0300, Breno Cardoso Perucchi wrote: Action application/x-httpd-php403 /ver403/php ScriptAlias /ver403/ /usr/local/php/ver403/bin AddType application/x-httpd-php403 .php3 Not Found The requested URL /ver403/php/index.php3 was not found on this server. That's the Apache error message saying that it could not access the PHP binary in the location you said it was in. You said it was in /usr/local/php/ver403/bin Is it really there? Does that directory, AND all of the directories above it, have the needed execute permissions so the user Apache is running as can get to it? Do the various PHP files in the directory have the read or read/execute permissions necessary for Apache to run them? --Dan -- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Automatically send email on special day
David. This is for you to note, as well as most of the people of this list who think that ALL OF US use own our computers as Internet Servers, being able to make CRON jobs or scheduling... well, WE DON'T. Some of us don't even has cable modem or steady connection and need to build up web sites trough a Dial Up connection and using a remote server... that's way there are some of us who are trying to solve these kind of problems through the scripts themselves and skip the server-side part... I'm tired of watching replies like just make a CRON job or set up a scheduled task so from now on, I will be including no server reach or something like that into all my messages and suggest that all the people who's also in my situation to do the same, so others don't forget it... please don't take me wrong, I just want to avoid large amounts of unusable messages. Hope you understand, C. -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 3:26 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Automatically send email on special day Hey guys, you're all making this too dificult. Windows NT, Windows 2000, Windows XP, and even Window 98 all have a built in schedule utility. On NT, it's accessed via the AT command. In order to use it, the Scheduler system service must be installed. Once it's installed, tell it to call the PHP executable with the script which sends the emails as the first paramter. For example, on widnow NT you could schedule the following: AT 06:00 /every:M,T,W,Th,F,Sa,Su c:\myscripts\gobirthday.bat The contents of gobirthday.bat would be only one line, c:\php\php.exe c:\myscripts\gobirthday.php then every day at 6:00am the batch file gobirthday.bat would be ran which executes the gobirthday.php script. now it doesn't matter whehter you have visitors at all to your site. Every morning the birthday emails will get sent. David - Original Message - From: Liam MacKenzie [EMAIL PROTECTED] To: NoWhErEMan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 10:11 PM Subject: Re: [PHP] Automatically send email on special day when the function excecutes, it checks the current date, then looks in a little textfile, if it's a match, it stops the script, but if the text file says a different date, it processes the scripts then updates the text file. Follow me? You could also use a MySQL database. - Original Message - From: NoWhErEMan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 3:08 PM Subject: Re: [PHP] Automatically send email on special day I can ensure ar least one visitor per day, that;s me!! Since my server in on my local windows mechine, i can load the page at start up. But i have a question, how can i ensure the script only runs once though, per day? I think it is related to coding Say, my index.php have a script to check current day and send the email if birthday. However, when more than one visitor on index.php, it will send duplicated email Nowhereman César aracena [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó·s»D :001e01c24414$789a5490$[EMAIL PROTECTED] Not ignored Lian. That idea is great but only if you are 100% sure that your site is going to have at least one visitor per day. If you want to setup a script like that in your pet's dedicated page, which maybe will not have that many visitors at first, you will probably miss a lot of appointments. In the other hand, if Hotmail or Yahoo want to do that... fine... I think they WILL have at least ONE visitor per day for sure. C. -Original Message- From: Liam MacKenzie [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:22 AM To: 'NoWhErEMan'; [EMAIL PROTECTED] Subject: Re: [PHP] Automatically send email on special day Hey, if you don't have access to CRON, you could try and include the page in your index.php. Set it so it only runs once though, per day. That means that as soon as someone visits your site they activate it for that day. It'd only work if you had the traffic though. Just an idea. Then again, I'm having one of those days Ignore me... - Original Message - From: César Aracena [EMAIL PROTECTED] To: 'NoWhErEMan' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 2:17 PM Subject: RE: [PHP] Automatically send email on special day This have been very much discussed in this list, and the only logical way of doing this through PHP would be to have a script that reads the actual date of the server's system once a day, but that would be just impossible without having that script (page) reloaded at least once a day. I think there are two way of doing this. First, would be to setup a cron job under unix (which I don't know so I'm guessing here) and second, which
[PHP] xml and php
iwill rephrase my question, where can i find good xml-php links? how would you extract all information about the Guinevere server in this xmlpage, http://www.camelotherald.com/xml/servers.xml its aprox in the middle of the list, and i want all information there so i could display it on a page. regards patrick -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How to show data in one row from two rows from the database
Hi everybody What I wrote in the subject may look complicated so I added a html file. It explains what I have and what I want to show. Thanks in advance begin 666 test.html M/%$3T-465!%($A434P@4%53$E#((M+R]7,T,O+T141!(5$U,(#0N,#$ M5')A;G-I=EO;F%L+R]%3B(^#0H\:'1M;#X-CQH96%D/T*/'1I=QE/E5N M=ET;5D($1O8W5M96YT/]T:71L93X-CQM971A(AT=' M97%U:78](D-O M;G1E;G0M5'EP92(8V]N=5N=#TB=5X=]H=UL.R!C:%RV5T/6ES;RTX M.#4Y+3$B/T*/]H96%D/T*#0H\8F]D3X-CQH,SY4:ES($D:%V92!I M;B!T:4@1%T84)AV4Z/]H,SX-CQT86)L92!W:61T:#TB-S4E(B!B;W)D M97(](C$B/T*( \='(^#0H( /'1H/D-/54Y44ED\+W1H/T*( (#QT M:#Y'4D]54#PO=^#0H( /'1H/E1)344\+W1H/T*( (#QT:#Y405)) M1D8\+W1H/T*( \+W1R/T*( \='(^#0H( /'1D/DE.1$E!/]T9#X- MB ( \=0^3$]#04P\+W1D/T*( (#QT9#Y014%+/]T9#X-B ( \ M=0^,3 \+W1D/T*( \+W1R/T*( \='(^#0H( /'1D/DE.1$E!/]T M9#X-B ( \=0^3$]#04P\+W1D/T*( (#QT9#Y/1D9014%+/]T9#X- MB ( \=0^-3PO=0^#0H(#PO='(^#0H(#QTCX-B ( \=0^24Y$ M24$\+W1D/T*( (#QT9#XX,# \+W1D/T*( (#QT9#Y014%+/]T9#X- MB ( \=0^,C \+W1D/T*( \+W1R/T*( \='(^#0H( /'1D/DE. M1$E!/]T9#X-B ( \=0^.# P/]T9#X-B ( \=0^3T94$5!2SPO M=0^#0H( /'1D/C$U/]T9#X-B /]TCX-B /'1R/T*( (#QT M9#Y#2$E.03PO=0^#0H( /'1D/DQ/0T%,/]T9#X-B ( \=0^4$5! M2SPO=0^#0H( /'1D/C$P/]T9#X-B /]TCX-B /'1R/T*( M(#QT9#XN+BX\+W1D/T*( (#QT9#XN+BX\+W1D/T*( (#QT9#XN+BX\ M+W1D/T*( (#QT9#XN+BX\+W1D/T*( \+W1R/T*/]T86)L93X-CQH M,SY4:ES($D@5V%N=!T;R!S:]W(]N('1H92!W96(.CPO:#,^#0H\=%B M;4@=VED=](CU)2(8F]R95R/2(Q(CX-B /'1R/T*( (#QT9#Y2 M871E(9OB Z($E.1$E!/]T9#X-B ( \=0^4$5!2SPO=0^#0H( M/'1D/D]1E!%04L\+W1D/T*( \+W1R/T*( \='(^#0H( /'1D/DQ/ M0T%,/]T9#X-B ( \=0^,3 \+W1D/T*( (#QT9#XU/]T9#X-B M/]TCX-B /'1R/T*( (#QT9#XX,# \+W1D/T*( (#QT9#XR,#PO M=0^#0H( /'1D/C$U/]T9#X-B /]TCX-CPO=%B;4^#0H-CPO 08F]D3X-CPO:'1M;#X-`` ` end -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Shared Hosting and Security Qualms ...
I'd be running away :) Justin French on 15/08/02 10:36 PM, Miles Thompson ([EMAIL PROTECTED]) wrote: This is somewhat off-topic, but has to do with shared hosting. All of my experience with Linux has been on boxes where I've pretty well had the only account. I'm now working on a shared system which provides SSH access. The idea is to host a client's site on this system, but after a few hours of exploring here's why I'm having second thoughts. I can move up the directory tree and see all the other users directories, the contents thereof, and individual files, such as /use/home/other_user/today.html. Permissions are such that I was not able to edit or copy them. (I tried.) The contents of etc/passwd could be listed. mysqlshow listed all the databases on the system; with the mysql console I was able to examine the structure and contents of any of them, with a couple I went further and added a table, inserted records, and dropped the table. I could also insert records (which I subsequently deleted) into existing tables. Call me naive, but is this normal, or should I bail on this arrangement before going any further? It's a BSD system. Comments and opinions are solicited. Regards - Miles Thompson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Header and Target
No, but instead you could do something like: header (Location: frame.php?url=content.php); Then in frame.php: ?php if ($url) { ? FRAME NAME=content SRC=?= $url ? MARGINWIDTH=1 MARGINHEIGHT=1 SCROLLING=Auto FRAMEBORDER=0 NORESIZE ?php } ? Make sense? -Brian * -Original Message- From: Christian Ista [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Header and Target That's a HTML thing. I think you're confusing header() with HEAD/HEAD I believe. No no I explaine, I do that : FRAMESET FRAMESET rows=80,*,80 FRAME src=top.html noresize scrolling=No border=0 frameborder=No FRAMESET cols=150,* FRAME src=left.html noresize scrolling=No border=0 frameborder=No FRAME src=mainpage.html border=0 frameborder=No name=content /FRAMESET FRAME src=menu.html noresize scrolling=No border=0 frameborder=No /FRAMESET /FRAMESET I'd like to display all my pages in the frame content. Some times, from the menu for example, I do a a href=. target=content that it's ok but sometimes, I call a php page by header( header(Location: mypage.php); ) but I'd like to display the content in content section frame. To do something like that : www.padeg.be Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Forms and sessions
Hi, How can I keep values in a from when using session_start() and later, the Back Button on my Browser after posting via POST? Thanks, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to show data in one row from two rows from the database
From: Ing. Rajesh Kumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:36 AM To: [EMAIL PROTECTED] Subject: [PHP] How to show data in one row from two rows from the database Hi everybody What I wrote in the subject may look complicated so I added a html file. It explains what I have and what I want to show. Thanks in advance Something like: $sql = Select DISTINCT COUNTRY from tariffs; $result=mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { echo Rates for {$row['COUNTRY']}br\n; $sql = select DISTINCT GROUP from tariffs where COUNTRY='{$row['COUNTRY']}' order by GROUP; $result2=mysql_query($sql) or die(mysql_error(); while ($row2 = mysql_fetch_array($result)) { $sql = select TIME,TARIFF from tariffs where COUNTRY='{$row['COUNTRY']}' and GROUP='{$row2['GROUP']}' order by TIME DESC; $result3=mysql_query($sql) or die(mysql_error(); $peak ='nbsp'; $offpeak = 'nbsp;'; while ($row3 = mysql_fetch_array($result3)) { switch (strtoupper($row3['TIME'])) { 'PEAK': $peak = $row3['TARIFF']; break; 'OFFPEAK': $offpeak = $row3['TARIFF']; break; } } echo {$row2['GROUP']} {$row3['TIME']} {$row3['TARIFF']}br\n; } } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How to show data in one row from two rows from the database
[snip] Something like: $sql = Select DISTINCT COUNTRY from tariffs; $result=mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { echo Rates for {$row['COUNTRY']}br\n; $sql = select DISTINCT GROUP from tariffs where COUNTRY='{$row['COUNTRY']}' order by GROUP; $result2=mysql_query($sql) or die(mysql_error(); while ($row2 = mysql_fetch_array($result)) { $sql = select TIME,TARIFF from tariffs where COUNTRY='{$row['COUNTRY']}' and GROUP='{$row2['GROUP']}' order by TIME DESC; $result3=mysql_query($sql) or die(mysql_error(); $peak ='nbsp'; $offpeak = 'nbsp;'; while ($row3 = mysql_fetch_array($result3)) { switch (strtoupper($row3['TIME'])) { 'PEAK': $peak = $row3['TARIFF']; break; 'OFFPEAK': $offpeak = $row3['TARIFF']; break; } } echo {$row2['GROUP']} {$row3['TIME']} {$row3['TARIFF']}br\n; } } [/snip] Actually it can be handled as a CROSSTAB query in SQL without any PHP code(save for forming your tables). Have a look at this article, http://www.mysql.com/articles/wizard/index.html . HTH! Jay Im the man of this house and I have my wifes permission to say so *** * Texas PHP Developers Conf Spring 2003 * * T Bar M Resort Conference Center * * New Braunfels, Texas* * San Antonio Area PHP Developers Group * * Interested? Contact [EMAIL PROTECTED] * *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Conditional Popup Menus with PHP/mySQL and Java?
I am looking for an example of conditional menus using PHP / mySQL to populate the options and values of the menus and java to change these properties with out needing to submit the form to update it. Here is the best, closest example I could find using a static page: http://www.webreference.com/js/tips/020112.html I am looking to create a set of popup menus via PHP and mySQL such as: FORM NAME=menu SELECT NAME=menu1 onChange=somejavascript() OPTION VALUE=1 SELECTEDAnimal OPTION VALUE=2Vegetable OPTION VALUE=3Mineral /SELECT SELECT NAME=menu2 OPTION VALUE=1.1 SELECTEDCat OPTION VALUE=1.2Dog OPTION VALUE=1.3Horse /SELECT /FORM The idea being that when I change menu1 the choices on menu2 change accordingly. Menu1 is easy. The java script to make menu2 is where I am lost. The link above is great but it does not address setting the values of menu2. Also the java uses the text of menu1 not the values (1,2,3 etc). These values are the id values from my mySQL DB and make the queries easier. Any ideas / examples out there? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Conditional Popup Menus with PHP/mySQL and Java?
This is a javascript thing. Try comp.lang.javascript... the only thing u really need to know is that you have to send ALL the data to the page with javascript, then effectively, it's a static HTML page. Justin French on 16/08/02 12:19 AM, Dan Tappin ([EMAIL PROTECTED]) wrote: I am looking for an example of conditional menus using PHP / mySQL to populate the options and values of the menus and java to change these properties with out needing to submit the form to update it. Here is the best, closest example I could find using a static page: http://www.webreference.com/js/tips/020112.html I am looking to create a set of popup menus via PHP and mySQL such as: FORM NAME=menu SELECT NAME=menu1 onChange=somejavascript() OPTION VALUE=1 SELECTEDAnimal OPTION VALUE=2Vegetable OPTION VALUE=3Mineral /SELECT SELECT NAME=menu2 OPTION VALUE=1.1 SELECTEDCat OPTION VALUE=1.2Dog OPTION VALUE=1.3Horse /SELECT /FORM The idea being that when I change menu1 the choices on menu2 change accordingly. Menu1 is easy. The java script to make menu2 is where I am lost. The link above is great but it does not address setting the values of menu2. Also the java uses the text of menu1 not the values (1,2,3 etc). These values are the id values from my mySQL DB and make the queries easier. Any ideas / examples out there? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Conditional Popup Menus with PHP/mySQL and Java?
Yes a javascript list is my next stop. After doing some digging I thought I would give the PHP list a shot first. I find it kind of gross loading ALL the data onto the page but I like the look the conditional menus give. Thanks, Dan This is a javascript thing. Try comp.lang.javascript... the only thing u really need to know is that you have to send ALL the data to the page with javascript, then effectively, it's a static HTML page. Justin French on 16/08/02 12:19 AM, Dan Tappin ([EMAIL PROTECTED]) wrote: I am looking for an example of conditional menus using PHP / mySQL to populate the options and values of the menus and java to change these properties with out needing to submit the form to update it. Here is the best, closest example I could find using a static page: http://www.webreference.com/js/tips/020112.html I am looking to create a set of popup menus via PHP and mySQL such as: FORM NAME=menu SELECT NAME=menu1 onChange=somejavascript() OPTION VALUE=1 SELECTEDAnimal OPTION VALUE=2Vegetable OPTION VALUE=3Mineral /SELECT SELECT NAME=menu2 OPTION VALUE=1.1 SELECTEDCat OPTION VALUE=1.2Dog OPTION VALUE=1.3Horse /SELECT /FORM The idea being that when I change menu1 the choices on menu2 change accordingly. Menu1 is easy. The java script to make menu2 is where I am lost. The link above is great but it does not address setting the values of menu2. Also the java uses the text of menu1 not the values (1,2,3 etc). These values are the id values from my mySQL DB and make the queries easier. Any ideas / examples out there? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Shared Hosting and Security Qualms ...
I am, the provider has been instructed to close the account. I am still wondering if this is typical for a shared environment. I'm now looking at a virtual server solution. Cheers - Miles At 11:48 PM 8/15/2002 +1000, Justin French wrote: I'd be running away :) Justin French on 15/08/02 10:36 PM, Miles Thompson ([EMAIL PROTECTED]) wrote: This is somewhat off-topic, but has to do with shared hosting. All of my experience with Linux has been on boxes where I've pretty well had the only account. I'm now working on a shared system which provides SSH access. The idea is to host a client's site on this system, but after a few hours of exploring here's why I'm having second thoughts. I can move up the directory tree and see all the other users directories, the contents thereof, and individual files, such as /use/home/other_user/today.html. Permissions are such that I was not able to edit or copy them. (I tried.) The contents of etc/passwd could be listed. mysqlshow listed all the databases on the system; with the mysql console I was able to examine the structure and contents of any of them, with a couple I went further and added a table, inserted records, and dropped the table. I could also insert records (which I subsequently deleted) into existing tables. Call me naive, but is this normal, or should I bail on this arrangement before going any further? It's a BSD system. Comments and opinions are solicited. Regards - Miles Thompson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] File Handler Error
I am getting include errors in php and when I check the apache logs i get out of file handler errors. Has anyone ran into this problem? I am wondering if there is a problem with the image functions. I am doing a lot of image creating and manipulation. Can anyone confirm this? .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Forms and sessions
Donpro [EMAIL PROTECTED] wrote in message 007601c24462$fec36fe0$[EMAIL PROTECTED]">news:007601c24462$fec36fe0$[EMAIL PROTECTED]... Hi, How can I keep values in a from when using session_start() and later, the I always keep variables as hidden HTML variables Note: you'd have to include backslashes if you are using PHP echo input type = hidden \name=var1\ value = \$var1\; Back Button on my Browser after posting via POST? I may be wrong but in my experience with Sessions you may use the back Button as long as your Script has reached the destroy session statement... If the Script is executing after a point at which the Session has been destroyed you'll get a *Page Expired* Notice... Hope this helps... Thanks, Don Spike... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] date() doesn't return system date?
when I type date in a console on my server, it returns a different time than that returned by date() or gmdate() - any idea why? -- Kae Verens http://www.contactjuggling.org/users/kverens/ http://www.contactjuggling.org/ (webmaster) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] help with making appropriate indexes.
General rule of thumb - create indexes on any fields which will be used in the conditional part of a select statement, whether where or join. Since you are working with tables, you can save yourself a lot of typing by dropping the table_ from the table names. After all, that's what they are. (You can do this unless you've gone too far with your system.) Miles Thompson At 02:15 PM 8/14/2002 +0200, lallous wrote: give this query: SELECT table_routing.id AS routeid, table_pricing.units AS price, table_routing.providerAS providerid, table_country.nameAS countryname, table_country.id AS countrycode FROM table_pricing, table_routing, table_country WHERE table_country.id = table_routing.country AND table_routing.country = table_pricing.country AND table_routing.provider = table_pricing.provider AND table_country.enabled = 1 ORDER BY routeid what keys / indexes should I create on whatever tables to make this query efficient? I don't know if this query can be re-written even with JOINs and stuff. Please advise, If you've got an online doc. about that it will help too. Elias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Shared Hosting and Security Qualms ...
It's not typical of my shared server. I have no SSH, and haven't been able to find a way (yet) of browsing or accessing anything that isn't mine... yet! Justin on 16/08/02 12:28 AM, Miles Thompson ([EMAIL PROTECTED]) wrote: I am, the provider has been instructed to close the account. I am still wondering if this is typical for a shared environment. I'm now looking at a virtual server solution. Cheers - Miles At 11:48 PM 8/15/2002 +1000, Justin French wrote: I'd be running away :) Justin French on 15/08/02 10:36 PM, Miles Thompson ([EMAIL PROTECTED]) wrote: This is somewhat off-topic, but has to do with shared hosting. All of my experience with Linux has been on boxes where I've pretty well had the only account. I'm now working on a shared system which provides SSH access. The idea is to host a client's site on this system, but after a few hours of exploring here's why I'm having second thoughts. I can move up the directory tree and see all the other users directories, the contents thereof, and individual files, such as /use/home/other_user/today.html. Permissions are such that I was not able to edit or copy them. (I tried.) The contents of etc/passwd could be listed. mysqlshow listed all the databases on the system; with the mysql console I was able to examine the structure and contents of any of them, with a couple I went further and added a table, inserted records, and dropped the table. I could also insert records (which I subsequently deleted) into existing tables. Call me naive, but is this normal, or should I bail on this arrangement before going any further? It's a BSD system. Comments and opinions are solicited. Regards - Miles Thompson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP news sites
Hello Gabor, I hope you don't mind that I am replying also to the list because I would like to tell about something that may be of the interest of other users. On 08/15/2002 09:42 AM, Gabor Hojtsy wrote: For one of my projects, I am searching for a list of PHP news sites. I would really love to receive links to these kind of sites, as I only know a few ones. A PHP news site in my mind provides news about PHP, projects using PHP, and may also host articles. I am not interested in forums, mailing lists and other interactive content, just news and maybe articles. I am not sure if this matches what you are looking for, but like many other sites of specific contents, the PHP Classes site provides a list of the latest classes of objects that were published in the site and also the latest reviews of books interest for PHP developers. The respective pages can be found here with links for the XML-RSS versions of the listings in a format that is suitable for syndication as you probably need: http://www.phpclasses.org/browse.html/latest/latest.html http://www.phpclasses.org/products.html/latest/latest.html This is something like you will also find in other sites. What you may not find in other sites is an initiative meant to provide public recognition to all users that contribute to let others know about the site content. The initiative is called Friends of the PHP Classes. It works in such way that any new subscribers that are brought to the site by users that participate in this initiative are credited in such way that they may appear in a special ranking of the Top friends of PHP Classes that you may see here that has already several users participating: http://www.phpclasses.org/browse.html/top/top.html#friends Any user can participate, whether you are a contributing author or not. If you or anybody is interested, you may find the details here: http://www.phpclasses.org/friends.html Feel free to ask if you have any doubts. -- Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] date() doesn't return system date?
incorect sintax see: Example 4. date() Formatting /* Today is March 10th, 2001, 5:16:18 pm */ $today = date(F j, Y, g:i a); // March 10, 2001, 5:16 pm $today = date(m.d.y); // 03.10.01 $today = date(j, m, Y); // 10, 3, 2001 $today = date(Ymd); // 20010310 $today = date('h-i-s, j-m-y, it is w Day z '); // 05-16-17, 10-03-01, 1631 1618 6 Fripm01 $today = date('\i\t \i\s \t\h\e jS \d\a\y.'); // It is the 10th day. $today = date(D M j G:i:s T Y); // Sat Mar 10 15:16:08 MST 2001 $today = date('H:m:s \m \i\s\ \m\o\n\t\h'); // 17:03:17 m is month $today = date(H:i:s); // 17:16:17 - Original Message - From: Kae Verens [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:31 PM Subject: [PHP] date() doesn't return system date? when I type date in a console on my server, it returns a different time than that returned by date() or gmdate() - any idea why? -- Kae Verens http://www.contactjuggling.org/users/kverens/ http://www.contactjuggling.org/ (webmaster) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: xml and php
Hello, On 08/15/2002 10:30 AM, Pafo wrote: iwill rephrase my question, where can i find good xml-php links? how would you extract all information about the Guinevere server in this xmlpage, http://www.camelotherald.com/xml/servers.xml its aprox in the middle of the list, and i want all information there so i could display it on a page. They have PHP support for that already: http://www.camelotherald.com/xml.php#unix -- Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Header and Target
To make that work with register_globals = off wouldn't you use ? php if ($_REQUEST[url]) { ? Adam On Thu, 15 Aug 2002, Brian V Bonini wrote: No, but instead you could do something like: header (Location: frame.php?url=content.php); Then in frame.php: ?php if ($url) { ? FRAME NAME=content SRC=?= $url ? MARGINWIDTH=1 MARGINHEIGHT=1 SCROLLING=Auto FRAMEBORDER=0 NORESIZE ?php } ? Make sense? -Brian * -Original Message- From: Christian Ista [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Header and Target That's a HTML thing. I think you're confusing header() with HEAD/HEAD I believe. No no I explaine, I do that : FRAMESET FRAMESET rows=80,*,80 FRAME src=top.html noresize scrolling=No border=0 frameborder=No FRAMESET cols=150,* FRAME src=left.html noresize scrolling=No border=0 frameborder=No FRAME src=mainpage.html border=0 frameborder=No name=content /FRAMESET FRAME src=menu.html noresize scrolling=No border=0 frameborder=No /FRAMESET /FRAMESET I'd like to display all my pages in the frame content. Some times, from the menu for example, I do a a href=. target=content that it's ok but sometimes, I call a php page by header( header(Location: mypage.php); ) but I'd like to display the content in content section frame. To do something like that : www.padeg.be Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] date() doesn't return system date?
adi wrote: incorect sintax maybe I wasn't precise enough: when I place date(h:i a) in a page on my server, and view it in a browser, I am returned: 02:51 pm. According to the server itself, though (logged in through ssh), using date, it is 3:51. gmdate(h:i a) returns the same 2:51 time. They are both one hour off from the server time. when I type date in a console on my server, it returns a different time than that returned by date() or gmdate() - any idea why? -- Kae Verens http://www.contactjuggling.org/users/kverens/ http://www.contactjuggling.org/ (webmaster) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: frames and variables
Yes, Javascript is the most common way of doing this. The alternative is to submit the variable back to the main PHP document (whatever created the Frames in the first place) and regenerate the entire screen (frameset and all). The script can then pass the variables on in the FRAME tags. It ain't pretty, but no Javascript is required. As you may be starting to guess, this is why many people have quit using Frames. At first, they seem like a great idea. But the more you use them, the more difficult you find them to be. In the end, many people would rather give up the advantages of Frames in return for the increased simplicity of generating the pages. --- Seairth Jacobs [EMAIL PROTECTED] [EMAIL PROTECTED] wrote in message 01c24415$8155a1b0$86a96518@jumpy">news:01c24415$8155a1b0$86a96518@jumpy... Has anyone here designed php sites that use a combination of php pages and html pages? What I want to know is how to pass a variable from nav_frame.php (at the top) to itself, AND to the data.php frame (lower frame, main body) I can pass variables to itself, (with the ?page_name=content.htm thingie attached to links, but I don't know how to make this accessible to both frames at the same time. Help appreciated, yes, I'm asking a lot of questions since this is a project for college and my due data is in 2 ... ooops 1 DAY! WhooHOO! - Vic __ Post your ad for free now! http://personals.yahoo.ca -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Automatically send email on special day
Sorry if my reply set you off. It was late. I might have said something stupid. I was tired. I should have gone to bed and ignored it. You're right though, it's pretty important to say I don't have full access to my web server in your message when you don't. I guess I was keying off of NoWhErMan's statment Since my server in on my local windows machine which I interpreted to mean that he had control of the the machine. Maybe I was wrong. DAvid -Original Message- From: César Aracena [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:29 AM To: 'David Buerer'; [EMAIL PROTECTED] Subject: RE: [PHP] Automatically send email on special day David. This is for you to note, as well as most of the people of this list who think that ALL OF US use own our computers as Internet Servers, being able to make CRON jobs or scheduling... well, WE DON'T. Some of us don't even has cable modem or steady connection and need to build up web sites trough a Dial Up connection and using a remote server... that's way there are some of us who are trying to solve these kind of problems through the scripts themselves and skip the server-side part... I'm tired of watching replies like just make a CRON job or set up a scheduled task so from now on, I will be including no server reach or something like that into all my messages and suggest that all the people who's also in my situation to do the same, so others don't forget it... please don't take me wrong, I just want to avoid large amounts of unusable messages. Hope you understand, C. -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 3:26 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Automatically send email on special day Hey guys, you're all making this too dificult. Windows NT, Windows 2000, Windows XP, and even Window 98 all have a built in schedule utility. On NT, it's accessed via the AT command. In order to use it, the Scheduler system service must be installed. Once it's installed, tell it to call the PHP executable with the script which sends the emails as the first paramter. For example, on widnow NT you could schedule the following: AT 06:00 /every:M,T,W,Th,F,Sa,Su c:\myscripts\gobirthday.bat The contents of gobirthday.bat would be only one line, c:\php\php.exe c:\myscripts\gobirthday.php then every day at 6:00am the batch file gobirthday.bat would be ran which executes the gobirthday.php script. now it doesn't matter whehter you have visitors at all to your site. Every morning the birthday emails will get sent. David - Original Message - From: Liam MacKenzie [EMAIL PROTECTED] To: NoWhErEMan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 10:11 PM Subject: Re: [PHP] Automatically send email on special day when the function excecutes, it checks the current date, then looks in a little textfile, if it's a match, it stops the script, but if the text file says a different date, it processes the scripts then updates the text file. Follow me? You could also use a MySQL database. - Original Message - From: NoWhErEMan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 3:08 PM Subject: Re: [PHP] Automatically send email on special day I can ensure ar least one visitor per day, that;s me!! Since my server in on my local windows mechine, i can load the page at start up. But i have a question, how can i ensure the script only runs once though, per day? I think it is related to coding Say, my index.php have a script to check current day and send the email if birthday. However, when more than one visitor on index.php, it will send duplicated email Nowhereman César aracena [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó·s»D :001e01c24414$789a5490$[EMAIL PROTECTED] Not ignored Lian. That idea is great but only if you are 100% sure that your site is going to have at least one visitor per day. If you want to setup a script like that in your pet's dedicated page, which maybe will not have that many visitors at first, you will probably miss a lot of appointments. In the other hand, if Hotmail or Yahoo want to do that... fine... I think they WILL have at least ONE visitor per day for sure. C. -Original Message- From: Liam MacKenzie [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:22 AM To: 'NoWhErEMan'; [EMAIL PROTECTED] Subject: Re: [PHP] Automatically send email on special day Hey, if you don't have access to CRON, you could try and include the page in your index.php. Set it so it only runs once though, per day. That means that as soon as someone visits your site they activate it for that day. It'd only work if you had the traffic though. Just an idea. Then again, I'm having one of those days Ignore me... - Original Message -
Re: [PHP] Automatically send email on special day
On Thursday 15 August 2002 21:28, César Aracena wrote: [snip] I'm tired of watching replies like just make a CRON job or set up a scheduled task so from now on, I will be including no server reach or something like that into all my messages and suggest that all the people who's also in my situation to do the same, so others don't forget it... please don't take me wrong, I just want to avoid large amounts of unusable messages. That's a step in the right direction. The responsibility is on the person asking a question to provide as much info as possible about the server and the environment that they're using. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Collapsed Backbone */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Group and count at the same time?
I am using PHP to maintain a catalog of music and have been just fine with it but have run into one thing i want to do and need some advice. The format of the data is like so: upc|genre|distributor|details What I want to do is grab a summary. So it would end up printing out: rock (43) country (41) and so on. Is this possible to do with one query or will I need to do it with more? So I want to count the number of each genre and provide a count for each. Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Possible to prevent a virtualhost or etc.. to use exec() or...?
I'm running a linux apache server 1.3.26 with php 4.2.2 I have some virtualhosts on my server my mainserver is: www.!!.com and they are hl.!!.com ... for ex: i don't want any php code to be able to run exec() or system() command which is being ran on hl.!!.com http://hl.!!.com/testing.php - if he has something like system(...) or etc.. i want to php script to exit or deny BUT! Only for hl subdomain. And i don't want him to be able to include read fopen etc... files which are not in his home tree... for ex: he shouldn't be able to fopen /usr/local/apache/logs/error_log -- This is just an example, please don't tell me to do chown root error_log This is just an example i just want to make seperate access files... permissions for php for specified accounts.. Is this possible? or? I'm looking for your response. Kind Regards. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Keyword exact phrase search
Has anyone bumped into or written a set of good searching routines? I need to search across one,two, or three fields in an MySQL database in either exact phrase (easy) or keyword with relavence (difficult.) I'm thinking something like a google/yahoo style search. I've tried MySQL full text searches, but the results it returns seem to be just a little to broad and you end up with a bunch of irrelevant results. With respect to the database size that I'm searching in, right now it's about 20MB but I'm guessing that within the next 24 months it will be up around 2GB. The first field I'm searching in is a CHAR(255) field. The second field is a small blob and usually is only about 1 paragraph of text. The thrid field is an entire HTML document and can be many many pages long. Any help is appreciated, David
Re: [PHP] Group and count at the same time?
You could do it if you had a table with each genre of music. // get each genre while ($genre = mysql_fetch_array(mysql_query(select * from genre_table)); { // sql query to fetch the # of albums of a specific genre $sql = mysql_query(select count($genre) as count from album_table where genre =.$genre; $query = mysql_fetch_row($sql); // echo the results echo You have $query ablums that are $genreBR; } Thats just off top top of my head so it may or may not work. Adam On Thu, 15 Aug 2002, Jeff Lewis wrote: I am using PHP to maintain a catalog of music and have been just fine with it but have run into one thing i want to do and need some advice. The format of the data is like so: upc|genre|distributor|details What I want to do is grab a summary. So it would end up printing out: rock (43) country (41) and so on. Is this possible to do with one query or will I need to do it with more? So I want to count the number of each genre and provide a count for each. Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Group and count at the same time?
On Thursday 15 August 2002 23:19, Jeff Lewis wrote: I am using PHP to maintain a catalog of music and have been just fine with it but have run into one thing i want to do and need some advice. The format of the data is like so: upc|genre|distributor|details Where is this info coming from? What I want to do is grab a summary. So it would end up printing out: rock (43) country (41) and so on. Is this possible to do with one query or will I need to do it with more? So I want to count the number of each genre and provide a count for each. If it's from a database then you really should be asking on the php-db list. Something like: select genre, count('genre') from catalog group by genre should work. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Keyword exact phrase search
I only just started getting into this, but it seems that a LOT of the work is done for you with MySQL's FULLTEXT stuff Check it out in the MySQL manual. Justin French on 16/08/02 12:59 AM, David Buerer ([EMAIL PROTECTED]) wrote: Has anyone bumped into or written a set of good searching routines? I need to search across one,two, or three fields in an MySQL database in either exact phrase (easy) or keyword with relavence (difficult.) I'm thinking something like a google/yahoo style search. I've tried MySQL full text searches, but the results it returns seem to be just a little to broad and you end up with a bunch of irrelevant results. With respect to the database size that I'm searching in, right now it's about 20MB but I'm guessing that within the next 24 months it will be up around 2GB. The first field I'm searching in is a CHAR(255) field. The second field is a small blob and usually is only about 1 paragraph of text. The thrid field is an entire HTML document and can be many many pages long. Any help is appreciated, David -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Group and count at the same time?
I think you want something like this: SELECT genre, COUNT(*) as count FROM music GROUP BY genre; Dan I am using PHP to maintain a catalog of music and have been just fine with it but have run into one thing i want to do and need some advice. The format of the data is like so: upc|genre|distributor|details What I want to do is grab a summary. So it would end up printing out: rock (43) country (41) and so on. Is this possible to do with one query or will I need to do it with more? So I want to count the number of each genre and provide a count for each. Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Group and count at the same time?
Jason, Much appreciated, this worked :) select genre, count('genre') from catalog group by genre - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:26 AM Subject: Re: [PHP] Group and count at the same time? On Thursday 15 August 2002 23:19, Jeff Lewis wrote: I am using PHP to maintain a catalog of music and have been just fine with it but have run into one thing i want to do and need some advice. The format of the data is like so: upc|genre|distributor|details Where is this info coming from? What I want to do is grab a summary. So it would end up printing out: rock (43) country (41) and so on. Is this possible to do with one query or will I need to do it with more? So I want to count the number of each genre and provide a count for each. If it's from a database then you really should be asking on the php-db list. Something like: select genre, count('genre') from catalog group by genre should work. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MySQL to csv
Hi Can someone show me how to export MySQL table to a csv file? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Questions
Thanks a lot. The other day I have talked with one of my classmates and say that there is nearly no essential differences between session and url variables, after I read your answer I know that it does have. I have tried your way of using session, it does make sense in differentiate between session and url variables. I still can't find whether there is a life-time for session. Could you help me? Best Wishes! - Original Message - From: SHEETS,JASON (Non-HP-Boise,ex1) [EMAIL PROTECTED] To: 'mintbaggio' [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 3:27 AM Subject: RE: [PHP] Some questions. Turn off register globals and use the superglobals, if this doesn't make sense refer to the PHP manual available at http://www.php.net/manual. Basically as of PHP 4.1 all session variables are accessible by using $_SESSION['name'] for example. Example1.php ?php session_start(); // start session using session start $_SESSION['name'] = 'Jason Sheets'; // create and register a variable ? Example2.php (this file accesses the variable from example1) ?php session_start(); // start session using session start print 'Your name is: ' . $_SESSION['name'] . 'br'; // print line containing variable When you have register globals off or you use superglobals post and get information will not be propagated to the session array, meaning that even if the user sets loggedin=1 in their url when you check if $_SESSION['loggedin'] == 1 it will be false unless they logged in. Jason -Original Message- From: mintbaggio [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:43 AM To: [EMAIL PROTECTED] Subject: [PHP] Some questions. Hello I'm a Chinese university student,I want to ask some questions about session. These days I'm build a website for my university with PHP, But I meet a question when I develop the part of User Management: After I have log out from a user page(I use session_unset() and session_destroy()),I can return to the page again by click the button Backto that pagea and refresh it, the user page can be shown again. This is unsafe. So I want to ask that the function session_unset and session_destroy() will destroy session immediately or there is a life-time for session. In my memory, I think that there is a life-time for session and the life-time can be configured. Another question: If the user log page is main.php,the page for authenticate the user is login.php I use session to store the infomation of user such as : session_register($userid); But if the variables in the session are unfortunately be known by somebody else. and he can visit others' information bye the url:login.php?userid=***,how can solve these problem? use a ugly but difficult session varable? Just two questions. Thanks a lot. Wish back soon! Best wishes
[PHP] Another Questions
Thanks for Email to me so soon! 1. Before I sent you Emails I read the function session_destroy() and function session_unset() again I use session in this sequence: session_start(); //after user has been authenticated (using database authentication) $userid = $txtUser; //txtUser is the text input in the log page; session_register(userid); //after user log out session_unset; session_destroy(); I wonder whether this is a right sequence in using session. Could you give me some advice? 2. I know the session is stored on the SERVER. But I am develop a Homepage Administration System for my university. This system is used to manage the users and store all the users' own homepage. User need to register before he/she can store his/her own homepage on the SERVER. All the users id are listed out for others' visit. So all the users id are known. I mean the url:login.php is known. But if one person know my session variable and he use login.php?userid=mintbaggio(mintbaggio is a user in this system). Now I use 3 variables in session to store the use's information. Before somebody enter the user's own page(Not the user's homepage,but the user's information like name,age,etc) , these 3 variables are examined whether they are all valid. Is this safer? - Original Message - From: Justin French [EMAIL PROTECTED] To: mintbaggio [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 10:21 AM Subject: Re: [PHP] Some questions. on 13/08/02 3:42 AM, mintbaggio ([EMAIL PROTECTED]) wrote: I'm a Chinese university student,I want to ask some questions about session. These days I'm build a website for my university with PHP, But I meet a question when I develop the part of User Management: After I have log out from a user page(I use session_unset() and session_destroy()),I can return to the page again by click the button Backto that pagea and refresh it, the user page can be shown again. This is unsafe. So I want to ask that the function session_unset and session_destroy() will destroy session immediately or there is a life-time for session. In my memory, I think that there is a life-time for session and the life-time can be configured. Firstly, make sure you've read the page at php.net/session_destroy and php.net/session_unset, because it supplies perfect code for destroying a session. Make sure your code matches either example 1 or 2, depending on your code. If you're unsure, test with both. If you've named your session somewhere, you need to unset and destroy it WITH that name, I think (never had to do it). Another question: If the user log page is main.php,the page for authenticate the user is login.php I use session to store the infomation of user such as : session_register($userid); But if the variables in the session are unfortunately be known by somebody else. and he can visit others' information bye the url:login.php?userid=***,how can solve these problem? use a ugly but difficult session varable? When you store the the username as a session variable, it's stored on the SERVER, not on the client. Hence, there is less chance of the session variables being disclosed. Better still, if you NEVER store both the password and username in the session, then the hacker will not be able to do anything without the password. The only thing stored on the browser or transmitted in clear view when running a session is the session id (a long number), NOT the variables assigned to the session... that's the whole point. FWIW, if you really want to make things more secure, you should turn off register globals, learn about the new super global arrays like $_POST, $_SESSION, $_GET, etc etc. In short, you'd register a new session variable as $_SESSION['var'] = value; rather than $var=value; session_register($var); Justin French
[PHP] Re: Keyword exact phrase search
David Buerer [EMAIL PROTECTED] wrote in message 91FBD0B430EFD5118B930060672D982C081148@CAIRO">news:91FBD0B430EFD5118B930060672D982C081148@CAIRO... Has anyone bumped into or written a set of good searching routines? I need to search across one,two, or three fields in an MySQL database in either exact phrase (easy) or keyword with relavence (difficult.) I'm thinking something like a google/yahoo style search. I've tried MySQL full text searches, but the results it returns seem to be just a little to broad and you end up with a bunch of irrelevant results. With respect to the database size that I'm searching in, right now it's about 20MB but I'm guessing that within the next 24 months it will be up around 2GB. The first field I'm searching in is a CHAR(255) field. The second field is a small blob and usually is only about 1 paragraph of text. The thrid field is an entire HTML document and can be many many pages long. Ouch that sounds nasty... I've only had to search a 4MB database and tried to cut time spent searching as much as I could... I tried every thing from storing values in an array to various SQL commands... The elements at the bottom of the table still took annoyingly long... Maybe there'd be a decent, more efficient algorithm for a sorted DB... If you can keep it sorted at all times I am quite sure you would be able to find a decent search algorithm (Binary search - I have never applied the concept of a binary search algorithm to a DB before)... Then again the slowness could have been due to the type of DB I was searching or due to the location of the DB... (I was using Paradox tables, It had to search a different drive and the webserver was IIS - the good news is that it was pretty efficient when tested against a copy of the same 4MB db, located on my machine though (localhost)... Any help is appreciated, David -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL to csv
[snip] Can someone show me how to export MySQL table to a csv file? [/snip] From http://www.mysql.com/doc/en/SELECT.html The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host and cannot already exist (among other things, this prevents database tables and files such as `/etc/passwd' from being destroyed). You must have the FILE privilege on the server host to use this form of SELECT. SELECT ... INTO OUTFILE is mainly intended to let you very quickly dump a table on the server machine. If you want to create the resulting file on some other host than the server host you can't use SELECT ... INTO OUTFILE. In this case you should instead use some client program like mysqldump --tab or mysql -e SELECT ... outfile to generate the file. SELECT ... INTO OUTFILE is the complement of LOAD DATA INFILE; the syntax for the export_options part of the statement consists of the same FIELDS and LINES clauses that are used with the LOAD DATA INFILE statement. See section 6.4.9 LOAD DATA INFILE Syntax. In the resulting text file, only the following characters are escaped by the ESCAPED BY character: The ESCAPED BY character The first character in FIELDS TERMINATED BY The first character in LINES TERMINATED BY Additionally, ASCII 0 is converted to ESCAPED BY followed by 0 (ASCII 48). The reason for the above is that you must escape any FIELDS TERMINATED BY, ESCAPED BY, or LINES TERMINATED BY characters to reliably be able to read the file back. ASCII 0 is escaped to make it easier to view with some pagers. As the resulting file doesn't have to conform to the SQL syntax, nothing else need be escaped. Here follows an example of getting a file in the format used by many old programs. SELECT a,b,a+b INTO OUTFILE /tmp/result.text FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM test_table; HTH! Jay Im talking to myself please dont eavesdrop! *** * Texas PHP Developers Conf Spring 2003 * * T Bar M Resort Conference Center * * New Braunfels, Texas* * San Antonio Area PHP Developers Group * * Interested? Contact [EMAIL PROTECTED] * *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] A Question about PHP upload file
Is there is a volume limitted for PHP upload file using HTTP? I heard of there is a 8-9Mb limitted,is it true? Is there a method to solve it?
RE: [PHP] Php.ini on Solaris?
is usually in /usr/local/lib Ok, just reinstalled 4.2.2 to make sure I didn't miss anything -- it didn't install any php.ini file (although phpinfo() says it's location is /usr/local/lib). Should I just create one from scratch? -- Randy Perry sysTame Mac Consulting/Sales phn 772.589.6449 mobile email[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Php.ini on Solaris?
rename php.ini-dist thats with the php source code to php.ini and copy it to /usr/local/lib Adam On Thu, 15 Aug 2002, Randall Perry wrote: is usually in /usr/local/lib Ok, just reinstalled 4.2.2 to make sure I didn't miss anything -- it didn't install any php.ini file (although phpinfo() says it's location is /usr/local/lib). Should I just create one from scratch? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Destroying Sessions... (Page Expired....)
I have my Sessions Started in a different function... I have a different function displaying a form dependent on input... At the end of the body of the Script (The Script that is not part of any function //based on an online example by: URS Gehrig... I try to destroy the session.. This isn't working i.e when I click on the Back Button on the Browser it returns to the initial page (it should read Page Expired)... Any ideas... Here is how its going... SessionRegistration...//returns 1 on successful Session Registration session_start()... ShowForm Function... if Session Successfully Registered.. Do something and then kill the Session else Show Form again... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL to csv
Assuming that you KNOW the structure of the table, this should do it... if you needed something more open-ended to cope with ANY table, I'd have to think about it a little more: ? // untested // get each row of the table into a a var, // separated by commas, ended with \n $csv_contents = ''; $sql = SELECT id,name,pass FROM tablename; $result = mysql_query($sql); while($myrow = mysql_fetch_array($result)) { // you have a row $csv_contents .= {$myrow['id']},{$myrow['name']},{$myrow['pass']}\n; } function write_to_file($filename, $stringtowrite, $writetype) { // lifted from the manual $filesession = fopen($filename,$writetype); fwrite($filesession,$stringtowrite); fclose($filesession); } write_to_file('nameofmyfile.csv',$csv_contents, 'w'); ? This is all off the top of my head, untested, with snippets lifted from the manual, but it should give u the theory, for which to build your own. If your target OS's are likely to include Macs, you'll have to do some tests on the line ending... \n or \r or perhaps \n\r will work best, with some testing. Justin French Justin French on 16/08/02 1:41 AM, Djurovski Dejan ([EMAIL PROTECTED]) wrote: Hi Can someone show me how to export MySQL table to a csv file? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] quick question
hey people, I have been seeing something in a few php scripts i've been playing with and i really dont know what it means or does. I'm only new to php so maybe someone could explain. i have been seeing -...e.g. while($file = $dir - read()) what does the - mean and do. thanks heaps -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Php.ini on Solaris?
Thanks. I put it in /usr/local/lib and turned register_globals On (I plan on setting it off after I rewrite all my scripts and give my hosting clients notice and time to rewrite theirs). But, it's still not passing vars (though $HTTP_POST_VARS[] works ok). Is their something else I need to do to get it to read the php.ini? Php.ini is owned by root -- tried both 644 and 755 permissions. rename php.ini-dist thats with the php source code to php.ini and copy it to /usr/local/lib Adam On Thu, 15 Aug 2002, Randall Perry wrote: is usually in /usr/local/lib Ok, just reinstalled 4.2.2 to make sure I didn't miss anything -- it didn't install any php.ini file (although phpinfo() says it's location is /usr/local/lib). Should I just create one from scratch? -- Randy Perry sysTame Mac Consulting/Sales phn 772.589.6449 mobile email[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Intermentant problems with getting information out of a string.
Hello there, I have a class (didn't want to paste in the whole class, so I just put in the relevant part) it works fine except for one problem. The function that I have here has a minor problem, it doesn't parse out all the data correctly, the Current file doesn't come up all the time. It is becoming a problem now that it is manifesting itself. I had this script running a lot but I had to remove it from the production server because of the problems that it caused. Could someone please shed some light on this for me? ?php Class parseme(){ Parseme($file,$debug){ $this-debug = debug; $this-fp = Fopen($file,r); } function getinformation($string){ if($this-debug){ print entering while loop!\n; } while (trim($string) != +OK){ if($string == +OK){ if($this-debug){ print trim(String is '$string'); } break; } $string = fgets($this-fp,200); if($this-debug){ print String is *. trim($string).*\n; print substr(\$string,0,1) = *. substr($string,0,1) .*\n; } if($i == 4){ }else{ if(substr($string,0,1) == M){ $this-status = trim(substr($string,10)); if($this-debug){ print trim(Got Status of *{$this-status}*) .\n; } } if(trim(substr($string,0,1)) == C){ // -- This line is where I have problems if($this-debug){ print Trackname detected\n; } $this-TrackName = trim(substr($string,strpos($string,.)+1)); } if(substr($string,0,1) == S){ // test of explode and such// list($this-samplerate,$this-bitrate,$this-channels) =explode(,,$string); list($junk, $this-samplerate) = explode(: ,$this-samplerate); list($junk, $this-bitrate) = explode(: ,$this-bitrate); list($junk, $this-channels) = explode(: ,$this-channels); if($this-debug){ print Samplerate : $this-samplerate\n; print Bitrate : $this-bitrate\n; print Channels : $this-channels\n; } } } $i++; } } $some = new parseme(status.txt,true); $some-getinformation(); ? // status.txt contents System status: === Shuffle: Disabled Repeat: Enabled Music is: PLAYING Current song: 01. DJ Encore - I See Right Through To You Samplerate: 44kHz, Bitrate: 160kbps, Channels: 2 +OK // end file contents // output of the script running entering while loop! String is *Shuffle: Disabled* substr($string,0,1) = *S* Samplerate : Disabled Bitrate : Channels : String is *Repeat: Enabled* substr($string,0,1) = *R* String is *Music is: PAUSED* substr($string,0,1) = *M* Got Status of *PAUSED* String is ** substr($string,0,1) = * * String is *Current song: 01. DJ Encore - I See Right Through To You* substr($string,0,1) = *C* String is *Samplerate: 44kHz, Bitrate: 160kbps, Channels: 2* substr($string,0,1) = *S* Samplerate : 44kHz Bitrate : 160kbps Channels : 2 String is ** substr($string,0,1) = * * String is *+OK* substr($string,0,1) = *+* If I wasn't good at explaining myself please tell me. Thank You, Mike [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Questions
The php.ini directive session.gc_maxlifetime?? php.net/session is worth a read Justin French on 16/08/02 1:51 AM, mintbaggio ([EMAIL PROTECTED]) wrote: Thanks a lot. The other day I have talked with one of my classmates and say that there is nearly no essential differences between session and url variables, after I read your answer I know that it does have. I have tried your way of using session, it does make sense in differentiate between session and url variables. I still can't find whether there is a life-time for session. Could you help me? Best Wishes! - Original Message - From: SHEETS,JASON (Non-HP-Boise,ex1) [EMAIL PROTECTED] To: 'mintbaggio' [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 3:27 AM Subject: RE: [PHP] Some questions. Turn off register globals and use the superglobals, if this doesn't make sense refer to the PHP manual available at http://www.php.net/manual. Basically as of PHP 4.1 all session variables are accessible by using $_SESSION['name'] for example. Example1.php ?php session_start(); // start session using session start $_SESSION['name'] = 'Jason Sheets'; // create and register a variable ? Example2.php (this file accesses the variable from example1) ?php session_start(); // start session using session start print 'Your name is: ' . $_SESSION['name'] . 'br'; // print line containing variable When you have register globals off or you use superglobals post and get information will not be propagated to the session array, meaning that even if the user sets loggedin=1 in their url when you check if $_SESSION['loggedin'] == 1 it will be false unless they logged in. Jason -Original Message- From: mintbaggio [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:43 AM To: [EMAIL PROTECTED] Subject: [PHP] Some questions. Hello I'm a Chinese university student,I want to ask some questions about session. These days I'm build a website for my university with PHP, But I meet a question when I develop the part of User Management: After I have log out from a user page(I use session_unset() and session_destroy()),I can return to the page again by click the button Backto that pagea and refresh it, the user page can be shown again. This is unsafe. So I want to ask that the function session_unset and session_destroy() will destroy session immediately or there is a life-time for session. In my memory, I think that there is a life-time for session and the life-time can be configured. Another question: If the user log page is main.php,the page for authenticate the user is login.php I use session to store the infomation of user such as : session_register($userid); But if the variables in the session are unfortunately be known by somebody else. and he can visit others' information bye the url:login.php?userid=***,how can solve these problem? use a ugly but difficult session varable? Just two questions. Thanks a lot. Wish back soon! Best wishes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Keyword exact phrase search
I'd like to agree. But i've speant a lot of time investigating, learning, and expirimenting with Full Text search and what I've found is that first, full text does not always return the right results and second and perhaps more important in my situation is that full text search doesn't work on BLOB fields. -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:37 AM To: David Buerer; '[EMAIL PROTECTED]' Subject: Re: [PHP] Keyword exact phrase search I only just started getting into this, but it seems that a LOT of the work is done for you with MySQL's FULLTEXT stuff Check it out in the MySQL manual. Justin French on 16/08/02 12:59 AM, David Buerer ([EMAIL PROTECTED]) wrote: Has anyone bumped into or written a set of good searching routines? I need to search across one,two, or three fields in an MySQL database in either exact phrase (easy) or keyword with relavence (difficult.) I'm thinking something like a google/yahoo style search. I've tried MySQL full text searches, but the results it returns seem to be just a little to broad and you end up with a bunch of irrelevant results. With respect to the database size that I'm searching in, right now it's about 20MB but I'm guessing that within the next 24 months it will be up around 2GB. The first field I'm searching in is a CHAR(255) field. The second field is a small blob and usually is only about 1 paragraph of text. The thrid field is an entire HTML document and can be many many pages long. Any help is appreciated, David
RE: [PHP] Keyword exact phrase search
Because to my knowledge the limitation of a TEXT field is 64K. I need to store entire documents in the database which far exceed the 64K limitation. Given that criteria, the only option is to use blob fields which have an upper limit of roughly 4GB. -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:08 AM To: David Buerer Subject: Re: [PHP] Keyword exact phrase search Why would you have text in blob fields? Justin French on 16/08/02 1:25 AM, David Buerer ([EMAIL PROTECTED]) wrote: I'd like to agree. But i've speant a lot of time investigating, learning, and expirimenting with Full Text search and what I've found is that first, full text does not always return the right results and second and perhaps more important in my situation is that full text search doesn't work on BLOB fields. -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:37 AM To: David Buerer; '[EMAIL PROTECTED]' Subject: Re: [PHP] Keyword exact phrase search I only just started getting into this, but it seems that a LOT of the work is done for you with MySQL's FULLTEXT stuff Check it out in the MySQL manual. Justin French on 16/08/02 12:59 AM, David Buerer ([EMAIL PROTECTED]) wrote: Has anyone bumped into or written a set of good searching routines? I need to search across one,two, or three fields in an MySQL database in either exact phrase (easy) or keyword with relavence (difficult.) I'm thinking something like a google/yahoo style search. I've tried MySQL full text searches, but the results it returns seem to be just a little to broad and you end up with a bunch of irrelevant results. With respect to the database size that I'm searching in, right now it's about 20MB but I'm guessing that within the next 24 months it will be up around 2GB. The first field I'm searching in is a CHAR(255) field. The second field is a small blob and usually is only about 1 paragraph of text. The thrid field is an entire HTML document and can be many many pages long. Any help is appreciated, David
RE: [PHP] MySQL to csv
Using SQL or PHP? -Original Message- From: Djurovski Dejan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 11:42 AM To: [EMAIL PROTECTED] Subject: [PHP] MySQL to csv Hi Can someone show me how to export MySQL table to a csv file? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] include opens source, but it shouldn't
why does include always opens my included file although it is defined as a variable Example: $file=include(/myfile/myfile.txt/); shouldn't it only be opend by typing echo $file; ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: quick question
http://www.php.net/manual/en/ref.classobj.php Chris Barnes wrote: hey people, I have been seeing something in a few php scripts i've been playing with and i really dont know what it means or does. I'm only new to php so maybe someone could explain. i have been seeing -...e.g. while($file = $dir - read()) what does the - mean and do. thanks heaps -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Php.ini on Solaris?
644 should be fine. I don't know about you, but for some reason on my linux box, I can't get $HTTP_POST_VARS or $_POST to work at all. it sends the value wrong. If I were you'd change the form method=post to method=get and then use $HTTP_GET_VARS or $_GET and see if it works. I think there is a bug with method=POST in php 4.2.2. Adam On Thu, 15 Aug 2002, Randall Perry wrote: Thanks. I put it in /usr/local/lib and turned register_globals On (I plan on setting it off after I rewrite all my scripts and give my hosting clients notice and time to rewrite theirs). But, it's still not passing vars (though $HTTP_POST_VARS[] works ok). Is their something else I need to do to get it to read the php.ini? Php.ini is owned by root -- tried both 644 and 755 permissions. rename php.ini-dist thats with the php source code to php.ini and copy it to /usr/local/lib Adam On Thu, 15 Aug 2002, Randall Perry wrote: is usually in /usr/local/lib Ok, just reinstalled 4.2.2 to make sure I didn't miss anything -- it didn't install any php.ini file (although phpinfo() says it's location is /usr/local/lib). Should I just create one from scratch? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: A Question about PHP upload file
http://www.php.net/manual/en/configuration.php#ini.memory-limit http://www.php.net/manual/en/configuration.php#ini.post-max-size http://www.php.net/manual/en/configuration.php#ini.upload-max-filesize Mintbaggio wrote: Is there is a volume limitted for PHP upload file using HTTP? I heard of there is a 8-9Mb limitted,is it true? Is there a method to solve it? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] include opens source, but it shouldn't
[snip] why does include always opens my included file although it is defined as a variable Example: $file=include(/myfile/myfile.txt/); shouldn't it only be opend by typing echo $file; [/snip] The include() opens the file to place it in the variable, in other words include means READ INTO. Therfore $file=READ INTO THIS FILE(/myfile/myfile.txt/); HTH! Jay Im really easy to get along with, once you people learn to worship me *** * Texas PHP Developers Conf Spring 2003 * * T Bar M Resort Conference Center * * New Braunfels, Texas* * San Antonio Area PHP Developers Group * * Interested? Contact [EMAIL PROTECTED] * *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php