RE: [PHP] [newbie] Can PHP be a security risk if it's just connecting to MySQL?

en at least that much precaution that a user could still enter malicious script held in a TEXT column? I'm not totally sure I have the concepts right, but in any case, would anyone be willing to explain a little further what one would do to ensure "proper" validation and escaping o

[PHP] [newbie] Can PHP be a security risk if it's just connecting to MySQL?

ounter risks, or there is some other route to access PHP functions that I'm not aware of. Can someone please shed a little light on this matter? Naturally I want to try and be as secure as possible. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.p

RE: [PHP] SMTP and changing the character set

pe that helps. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] why doesn't this work ?

ning your own server, then you'll need to consult someone more advanced than I. Also, I can't ensure there aren't any errors or drawbacks to my advice, I'm just relaying how my web hosting service seems to handle the issue. Hope that helps. -- Yoroshiku! Da

RE: [PHP] Fill strings with  

> I was searching for a php function which fills empty spaces in string > varibales with " ", but could not find one. Wouldn't str_replace do it? http://jp2.php.net/str_replace -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/)

RE: [PHP] Slight cleaning of code needed in str_replace command.

use a query is simple that it means that the person asking is not willing to work or that they haven't already attempted to work at it. Sometimes it just means that the person asking doesn't know all the angles possible. Thanks for your help. -- Yoroshiku! Dave G [EMAIL P

RE: [PHP] Slight cleaning of code needed in str_replace command.

t there is something I don't understand about how the string input going into the command is parsed (it comes from a MySQL query), or about how the command interprets line breaks. Perhaps someone could offer something a little more concrete than essentially recommending I just 'try differen

[PHP] Slight cleaning of code needed in str_replace command.

syntax that I have place the new line *after* the tag? I'm trying to get it to look like this: blah blah blah blah blah blah blah blah blah blah blah blah Any advice would be most welcome. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] str_replace to replace /n with not having desiredeffect. [SOLVED]

mistakes that one overlooks. Thanks guys! That's done the trick. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] str_replace to replace /n with not having desired effect.

ah blah. The output I desire is this: Blah blah blah blah. Another line of blah blah blah. A third line of blah blah blah. How do I correct my code to accomplish this? Thank you. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) T

RE: [PHP] eregi filter stopping valid email address, part two

ill look into using them. Thank you for the link. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] eregi filter stopping valid email address, part two

er the @ mark. Is it that there are two many periods? -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Is a while loop the most efficient way to send out multiple emails?

ized information? Is it the mail() command that takes time, or the mysql_fetch_array(), or both? Any suggestions would be greatly appreciated. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] How do I make these two MySQL queries into one line? [SOLVED]

Chris, Thank you! I will look on the net for "left joins", which is a bit new to me, and I'll join a MySQL list, since I can see I'm going to have more MySQL questions in the future. Your reply is much appreciated, especially since it came so fast! -- Yoro

[PHP] How do I make these two MySQL queries into one line?

uery2 = "SELECT email FROM members WHERE active = yes AND member_id =" . $query1Results But surely there's a way to collapse this into one MySQL line. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Why won't this form post session variables? [SOLVED]

t variables. And so quickly, too! Much appreciated! -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Why won't this form post session variables?

uot;; $insertPPResult = mysql_query($insertPPQuery); unset ($HTTP_SESSION_VARS['$episodeTitle']); unset ($HTTP_SESSION_VARS['$episodePP']); echo 'Your episode, "' . $episodeTitle . '", has been saved. Would you like to add another episode?'; } else { ech

[PHP] PHP and Palm Pilot interaction

know. -- Yoroshiku! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] ereg is failing on this simple test

> Why is this test failing? > If (ereg("^[a-zA-Z0-9\s.\-_']+$", $data)) { I'm very new to PHP, so I may be barking up the wrong tree, but what is that "s" doing after the slash? I don't know if it's the cause of the problem, but as far as I know i

[PHP] [OT MySQL] Syntax for selecting within a range of time from database

AL is the command I want to use. Is what I'm after something like the following (I put in question marks where I'm not sure how that variable would be formed)? SELECT date(?) FROM table WHERE DATE_ADD(now(?), INTERVAL 72 HOURS) -- Yoroshiku! Dave G [EMAIL PROTECTED] --

RE: [PHP] Finding array in MySQL (I'm not asking the right question)

x27; "; > } ... is faster than this: > "SELECT email FROM table WHERE id IN ('" . > implode("','",$array) . "')"; ... ? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Finding array in MySQL (I'm not asking the right question)

s to the database as possible. Is that a correct assumption, or am I wrong there? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Finding array in MySQL (I'm not asking the right question)

r phrasing which will allow a search engine to help me find it. Can someone please point me in the right direction? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Add Reply-To to this list(s) [SOLVED, for me, anyway]

I'm on XP. I would change over to Linux in a heartbeat if Adobe products were available on that OS, but alas, they are not, and the GIMP is, by their own description, not a Photoshop killer. I'm considering the Opera M2 mailer, but it looks kind of immature. -- Cheers! Dav

RE: [PHP] Add Reply-To to this list(s) [SOLVED, for me, anyway]

this way, please let me know. You've convinced me that this mailing list system offers the most control, so which software allows me to best take advantage of it? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Add Reply-To to this list(s)

s in it, seems to run contrary to the reasons I joined. That is where I am starting from, it's got nothing to do with anyone's choice of software on either the client or server side. -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Add Reply-To to this list(s)

ver what is the default behaviour. I maintain that the point of a list is to have open discussion, that people join precisely for the advantage of participating in a group, and so the postings should default to going to the group, with secondary options for posting off list. -- Cheers! Dave G [EM

RE: [PHP] Add Reply-To to this list(s)

ne of the debate. The idea of an authority on a matter that is incapable of considering alternate viewpoints seems oxymoronic to me. -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Add Reply-To to this list(s)

This is, I suppose, a completely off topic thread. However, I just read the web page http://www.unicom.com/pw/reply-to-harmful.html and I was completely unconvinced. In all the years that I have belonged to and run mailing lists, I have never experienced any difficulties. Period. Never. It has be

[PHP] Compensating for time zones in PHP

pt, but, according to my web hosting service, that is impossible to set for just my site without affecting all the other sites on the same server. So I need to compensate for different time zones between my script and my MySQL server. But I can't figure out how to do that since I do

[PHP] MySQL Time Zones, correct codes, and global variable setting (was: Set time zone)

various time zone codes, but I haven't come across any reference on the web which tells me what that list looks like. So, question two is, how can I tell which is the right code to set "TZ" to? "JST"? "Japan"? Your help is much appreciated. -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Set time zone

time zones. Lots of information about how to format times, but not very clear about how to make the database take on a time zone. If anyone has pointers on that as well, that would be greatly appreciated. -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Why would this eregi() function not work?

That's a pretty hefty read, but it looks useful to have around for a reference. Thanks! -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Why would this eregi() function not work?

(!eregi('[EMAIL PROTECTED]', $email) -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Why would this eregi() function not work?

PROTECTED]', $email) Correct? > 3. I don't think a hyphen is even legal in an email address... If it wasn't, the user couldn't have emailed me to tell me that he wasn't having success in registering on my form. Or could he? -- Cheers! Dave G [EMAIL PROTECTED] --

[PHP] Why would this eregi() function not work?

ROTECTED] If I remove the hyphen, like so: [EMAIL PROTECTED] Then it passes. Looking at my eregi() function, I've included hyphens as a valid character, and escaped them out with slashes in order that they work within the square brackets. Why would this

RE: [PHP] Why is this code not working? [SOLVED]

array()? Just thought I should mention this to Jay. Yes, I had been alternating my experiments with mysql_fetch_array() and mysql_fetch_row(), but the results, were exactly the same (or close enough that I don't remember otherwise). So I suspected that the problem lay elsewhere and didn

RE: [PHP] Calendar

http://www.devshed.com/Server_Side/PHP/MilesToGo/page1.html -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Why is this code not working?

posed to work. I can't see what's wrong. Am I not declaring the array correctly? Is there some simple error that I'm over looking? What's going on? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] multiple table rows into an array, and creating a calendar

onstruct a for() loop in order to get the results of multiple rows into an array. But that seems unnecessarily complicated. Is there no command to take multiple rows and place them into an array? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, v

[PHP] multiple table rows into an array, and creating a calendar

that means searching the whole database table roughly 30 times each time the page is accessed, and that can't be right. I'm sure this is better handled with arrays, but I can't quite figure out the logic and the commands. Can anyone help me out with this? -- Cheers! Dave

RE: [PHP] Japanese character validation

panese language. Optimistically looking forward to seeing more technical discussion on how to accomplish this. -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Japanese entry into MySQL and into emails

L database. -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Endless 'while' loops?

misleading! In any case, I very appreciative of the many valuable tips offered, and I believe tightening up the code as suggested by people on this list helped me see my script better and isolate the problem. Many thanks to David, Jay, Hanuska, Leif, and Teren for their comments! -- Chee

RE: [PHP] Endless 'while' loops?

quot;.$message ."\nThis message was sent to [2]" .$member; mail($member[2], $subject, $mailcontent, $fromaddress); } Why is this not parsing? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Japanese entry into MySQL and into emails

dditional comments on the use of mb-send-mail(), but the technical vocabulary is beyond me. Can someone help me tweak this code to successfully send a kanji email? -- Cheers! Dave G [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Endless 'while' loops?

le" loop would ever stop running. Nothing seems to change $subscriber within the "while" loop's control structure. It doesn't ever say anything like "$subscriber ++1". Nor does $result have anything act upon it which would change it. So to me they both look static, a

[PHP] Japanese entry into MySQL and into emails

need to set "internal encoding", and/or also setting the "character set". My web site is on a virtual host, and I don't know if I have access to make such adjustments. Can someone please explain in beginners terms how do I set up my PHP scripts to enter Japanese kanj