[PHP-DB] Re: Cut down threads please!
JeRRy wrote: Hi, This is a Discussion Board, previous threads/posts are logged, recorded, saved to the WWW. I see no point to continue threads over and over and over again. Why not cut the threads down to a few lines that are important to the reply your making? If people need to know more about it there is a free website they can visit and look at it. It's quite annoying to follow a thread and find each time the thread is continued over and over in 5 lots of emails from the same person. Makes going through the list alot slower. I am not going to mention the one recently but most would be aware, the thread was continued, and still is, over about 10 replies, in all none has been removed from any reply. We're talking about 300 lines.. That's just stupid, CUT THEM DOWN PLEASE! Save everyone the hassle, I know of a few others a bit concerned on this also. Just thought I'd express my opinions. There is enough SPAM on the web already without things being repeated over and over again, yes maybe I am here but I am making a valid point. With that said, let's continue. No corrospondence entered into. J Well, whilst we are having a bitch about things, perhaps everyone could turn on word wrap in their favourite mailer/newsreader. Starting with you, please? Cheers -- David Robley People say I'm apathetic, but I don't care. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Date question
select * from table where date_format(date_field, '%Y-%m') = '2006-02' bastien From: Gerry Danen [EMAIL PROTECTED] To: php-db@lists.php.net CC: [EMAIL PROTECTED] Subject: [PHP-DB] Date question Date: Sun, 12 Mar 2006 20:44:13 -0700 While I am rebuilding my crashed laptop (the machine that had all my intelligence), I started thinking about a select statement I need. I have log info in a table and want to extract it on a monthly basis. The date field is in -mm-dd format. What's a good way to select those dates that match 2006-02, for example. I apologize if the solution should be staring me in the face, but all my favorites and help files are toast, until I can restore some of them. TIA. Gerry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Database abuse help needed
No, I agree, for this matter you can never create a regular expression well written enough to match all or even most of the lingo we use. = Been off the list for a couple of days and just stumbled across this thread. Our company uses some kind of 'nicey-nice gotta have a non-threatening work environment' filter and I've had a couple of emails (somebody had a post with the 'S' word written out in it's ugly full self, shame - shame...) rejected because of the inclusion of 'FORBIDDEN WORDS'(tm). Interestingly, this thread full of F|_|CKs and D1CKH3EDs made it through totally unscathed. Spam containing ads for all known s3xual enhancement products are delivered to my doorstop every day. Kinda makes the point that you'll never trap even a fraction of the offensive content given the immense creativity of the human mind. Doug ___ This e-mail message has been sent by Kollsman, Inc. and is for the use of the intended recipients only. The message may contain privileged or confidential information. If you are not the intended recipient you are hereby notified that any use, distribution or copying of this communication is strictly prohibited, and you are requested to delete the e-mail and any attachments and notify the sender immediately. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database abuse help needed
Another fine thing about this is the fact that you can use unicode characters as an alternative which the regular expression engine probably wont match, unless it's somehow tweaked. This is the same theory as in when you are doing phising, for say ebay.com and replace the a with one of them non-ASCII letters, providing a link so that you won't have to type it. Only the other way around. It is a problem we have with information - it's hard to analyze the human communication essence (not the right word - duh I'm not a native) On 3/13/06, Finner, Doug [EMAIL PROTECTED] wrote: No, I agree, for this matter you can never create a regular expression well written enough to match all or even most of the lingo we use. = Been off the list for a couple of days and just stumbled across this thread. Our company uses some kind of 'nicey-nice gotta have a non-threatening work environment' filter and I've had a couple of emails (somebody had a post with the 'S' word written out in it's ugly full self, shame - shame...) rejected because of the inclusion of 'FORBIDDEN WORDS'(tm). Interestingly, this thread full of F|_|CKs and D1CKH3EDs made it through totally unscathed. Spam containing ads for all known s3xual enhancement products are delivered to my doorstop every day. Kinda makes the point that you'll never trap even a fraction of the offensive content given the immense creativity of the human mind. Doug ___ This e-mail message has been sent by Kollsman, Inc. and is for the use of the intended recipients only. The message may contain privileged or confidential information. If you are not the intended recipient you are hereby notified that any use, distribution or copying of this communication is strictly prohibited, and you are requested to delete the e-mail and any attachments and notify the sender immediately. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Plain-text or HTML?
I have created several successful HTML and text based emails.. Its a secret called multipart MIME.The essence of email really. Just as an attachment is embedded into the same file as the images, html part and textual part. All you have to do is using 2 seperate boundaries, write out a textual [no HTML formatting, etc, use correct newlines etc] version out and then using same content write it into a HTML template version that can include formatting etc..Ensure all images used are also encoded and added as multipart MIME segments.All this can be generally easily done via some email clients themselves. For example Microsoft's Outlook Express does multipart HTML/Text emails.If you just go and create a new email in Outlook and type out your content in HTML format [ensure you've selected Format-Rich Text HTML]Then save it and grab the message source, you will clearly see the boundaries it has defined for the alternative MIME part [the text/html] and the text/plain part. Simply reformat the text/plain part a bit if you want. Voila.. in most cases thats ready to rumble .. use it as an example of how to work it into your own email generation functions in php. Works a charm for me ;-) Good luck, let me know how you go! --- Hi, Thanks for that, now I understand how it works. Seen the code, now I will play with it a bit. Did a few tests and found on some cases the following: 1- Yahoo! Mail is tricky to have HTML emails for, some emails, unless carefully designed, come out dodgy in formation when you view the email in Yahoo! Mail Web Format. 2- Hotmail seems to like HTML and has a better understanding of how to manage the emails in their Mail Live! Program 3- Outlook loves HTML and uses it cutely 4- Another web based email at www.tasmail.com formats funny and opens the html email in an attachment, does not always display good. 5- www.rock.com webmail dislikes HTML even though they claim HTML emails are supported. So the end result is some like some don't, some like to a degree and some don't. There does not seem to be a good solution even with formatting in HTML format. I'm just wondering how companies like Yahoo! and Hotmail send theirs out, tried viewing their source but sometimes their tricky. And being an owner of the servers they have more power over how emails are sent and displayed. Sure they have a source email but they can shade out reply, add more code somewhere hidden etc away from the source area. But their emails seem to come out fine, even when you redirect the emails to a email that does not like HTML a real lot they seem to display as they should. I know of a few programs on the net for plain-text to html emails, but the free ones are not a good solution, not sure of the paid ones. J
Re: [PHP-DB] Plain-text or HTML?
try phpmailer from http://phpmailer.sourceforge.net From: JeRRy [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Plain-text or HTML? Date: Tue, 14 Mar 2006 10:25:18 +1100 (EST) I have created several successful HTML and text based emails.. Its a secret called multipart MIME.The essence of email really. Just as an attachment is embedded into the same file as the images, html part and textual part. All you have to do is using 2 seperate boundaries, write out a textual [no HTML formatting, etc, use correct newlines etc] version out and then using same content write it into a HTML template version that can include formatting etc..Ensure all images used are also encoded and added as multipart MIME segments.All this can be generally easily done via some email clients themselves. For example Microsoft's Outlook Express does multipart HTML/Text emails.If you just go and create a new email in Outlook and type out your content in HTML format [ensure you've selected Format-Rich Text HTML]Then save it and grab the message source, you will clearly see the boundaries it has defined for the alternative MIME part [the text/html] and the text/plain part. Simply reformat the text/plain part a bit if you want. Voila.. in most cases thats ready to rumble .. use it as an example of how to work it into your own email generation functions in php. Works a charm for me ;-) Good luck, let me know how you go! --- Hi, Thanks for that, now I understand how it works. Seen the code, now I will play with it a bit. Did a few tests and found on some cases the following: 1- Yahoo! Mail is tricky to have HTML emails for, some emails, unless carefully designed, come out dodgy in formation when you view the email in Yahoo! Mail Web Format. 2- Hotmail seems to like HTML and has a better understanding of how to manage the emails in their Mail Live! Program 3- Outlook loves HTML and uses it cutely 4- Another web based email at www.tasmail.com formats funny and opens the html email in an attachment, does not always display good. 5- www.rock.com webmail dislikes HTML even though they claim HTML emails are supported. So the end result is some like some don't, some like to a degree and some don't. There does not seem to be a good solution even with formatting in HTML format. I'm just wondering how companies like Yahoo! and Hotmail send theirs out, tried viewing their source but sometimes their tricky. And being an owner of the servers they have more power over how emails are sent and displayed. Sure they have a source email but they can shade out reply, add more code somewhere hidden etc away from the source area. But their emails seem to come out fine, even when you redirect the emails to a email that does not like HTML a real lot they seem to display as they should. I know of a few programs on the net for plain-text to html emails, but the free ones are not a good solution, not sure of the paid ones. J -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Date question
Thanks for all the help, guys. I'm back up, but a lot of my cool tricks are gone. Gotta get a better backup plan... Gerry On 3/12/06, Gerry Danen [EMAIL PROTECTED] wrote: While I am rebuilding my crashed laptop (the machine that had all my intelligence), I started thinking about a select statement I need. I have log info in a table and want to extract it on a monthly basis. The date field is in -mm-dd format. What's a good way to select those dates that match 2006-02, for example. I apologize if the solution should be staring me in the face, but all my favorites and help files are toast, until I can restore some of them. TIA. Gerry -- Gerry http://portal.danen.org/
Re: [PHP-DB] 年初劳动争议风险规避及劳动合同管理
Post in english or not at all. On 3/15/06, 热线报名中! [EMAIL PROTECTED] wrote: --- 退/[EMAIL PROTECTED]退订内容写明您想退订的邮箱） 如有打扰，请您原谅，谢谢！ �y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y�y --- 年初劳动争议风险规避及劳动合同管理实战训练 --- 【主-办-单-位】希锐企业管理咨询有限公司 【费---用】1600元/人（含培训、资料、午餐），住宿统一安排，费用自理 【上-课-时-间】2OO6年3月25-26日(周六/周日两天) 【上-课-地-点】深圳市广深宾馆四楼会议厅 【报 名 咨 询】 【电 话】0755-83524370、0755-22058634 联系人：曾小姐 【传 真】0755-83524349 【参加对象】 总经理、人力资源部总监、人事经理及主管、财务经理、办公室主任、员工关系主管 【培训方式】采用模拟演练、案例分析及多媒体教学（国语）； --- 【课 程 背 景】 欢迎您与您的团队参加：年初劳动争议风险规避及劳动合同管理实战训练专题研修班。劳动争议 一旦发生，无论输赢，企业和HR都将付出昂贵的人力、财力、精力，而且有时明明企业有理，但仲裁 时却往往败诉，到底如何预防劳动争议引发的法律风险。而企业劳动关系管理的重点是劳动合同管理。 劳动合同管理的关键是：如何技巧地与员工订立、变更、解除、续签、终止劳动合同，如何技巧地对 员工进行调岗、降职、降薪和处理违纪员工，如何技巧地预防和处理劳动合同争议。通过本次课程两 天的学习，全面掌握劳动合同管理和劳动合同争议处理的技巧，极大地提高企业管理人员的劳动合同 管理水平和处理劳动争议的能力，避免和减少与员工劳动纠纷的发生, 妥善处理已发生的劳动合同争 议, 建立和谐的员工关系，提高劳动效率, 为企业和社会创造更多的财富。 --- 【课 程 大 纲】 第一天、年初劳动争议风险规避及风险防范 1、年初劳动争议引发原因和特点 ◆履行劳动合同引发的争议、规章制度、员工手册起草不当引发的争议 ◆执行国家有关工资、保险、福利、培训及劳动保护规定引发的争议 ◆调薪、调岗、调级引发的争议 ◆奖金分配引发的争议 2、企业通常遇到劳动风险的困惑 ◆离职员工的处理技巧？ ◆违纪员工的处理技巧？ ◆企业辞工、裁员时的违约金、补偿金和赔偿金有效控制 ◆哪些违纪行为企业可以合法开除、辞退或解除劳动合同 ◆暗示员工辞职，应当支付经济补偿金吗？ ◆利用安抚与缓解冲突技巧化解被辞退员工抗拒心态 ◆开除、除名、违纪辞退三种惩处方式的联系与区别 ◆岗位调整、薪酬变动、绩效考核可能带来的法律风险？ ◆员工争执导致受伤,是否能按工伤处理? ◆员工工作中违反操作规程受伤是工伤吗？ ◆企业工伤预防、认定与善后处理措施 ◆签定保密协议与竞业限制应注意事项 ◆如何完善企业内部的规章制度，以便处理违纪员 ◆社保存在哪些风险？企业该如何选择 ◆如何通过规章制度和员工手册的合法约束来保障企业的权益？ ◆不按规定办理重复申请仲裁的案件，时效如何限制 二、劳动合同管理实战训练及案例分析 1、劳动合同管理在现代企业人力资源管理中扮演的角色 ◆劳动合同在企业人力资源管理的重要作用与常见风险 ◆劳动合同与规章制度的关系及与劳动争议的关系 2、劳动合同订立中的风险与有效控制 ◆全日制劳动合同与非全日制劳动合同的定义、区别与应用 ◆见习期、学徒期、实习期与试用期的区别与应用 ◆劳动合同期、服务期和试用期运用中的常见误区与控制技巧 ◆岗位、工资约定中的常见误区与运用技巧 ◆工作时间、社会保险约定中的常见误区与运用技巧 ◆培训协议、服务期与违约金的约定技巧及注意事项 ◆如何有效运用劳动合同设计降低企业加班费等用工成本 ◆违约责任的约定技巧及注意事项 ◆无固定期限劳动合同的订立问题 3、劳动合同履行与变更中的风险与有效控制 ◆劳动合同变更的基本方法 ◆员工工作岗位调整、降职、降薪的运用技巧 ◆企业改制、转制、合并、分立时的劳动合同变更问题 ◆员工不能胜任工作时的工作调整问题 ◆工伤员工的工作调整问题 ◆企业无岗位时的劳动合同变更问题 ◆劳动合同管理台账的建立与完善 ◆非全日制（小时工）劳动合同的理解与应用 ◆有固定期限合同变更无固定期限合同问题 4、劳动合同解除、终止中的风险与有效控制 - [导 师 简 介] 程先生： 广东知名劳动法律法规及仲裁专家，劳动仲裁委员会资深仲裁员，资深律师。从事法律实 务工作及劳动仲裁多年，积累了丰富的法律操作经验，成功策划过多起大型上市公司及国有企业的重 组、改制，对合同法、劳动法、知识产权法、公司法、证据规则等有深入研究，尤为擅长劳动争议、 经济合同纠纷的处理，至今处理过两千多起劳动争议案件。目前程律师担任了十多家企业法律顾问， 其中包括长城国际（IBM）、珀金埃尔默（深圳）有限公司、深圳华强集团、美国总统轮船（APL）、 深圳华丝企业股份有限公司、UT-starcom（深圳）有限公司、迈瑞股份有限公司等知名企业。 黄先生：广东知名劳动法律法规及仲裁专家、现任广东劳动仲裁管理官员。经常代表政府调停、处理 了多起棘手的劳动争议案件。其权威、专业的形象已深入人心。参加过他精彩培训课程的人力资源专 业人士均与他保持良好的互动咨询关系；他具有近二十年的劳动仲裁管理经验，一直对我国的劳动法 律法规有深入研究，加上他多年与企业的实战交往经验，使众多资深人力资源专业人士乐意参与他主 讲的：最新劳动法律法规培训和实用技巧讲座，并接受他的指导建议。 ⊙报名回执 我--司决--定派学--员参--加《年初劳动争议风险规避及劳动合同管理实战训练》， 请--给--予--留--位 请传真到0755-83524349 培--训--部收 单位名称：联 系 人：___ 联系电话：_传真：_学员人数：___ 学员姓名：__ 付款方式： 1.转帐 2.现金
[PHP-DB] Text file (rw) question...
I'm trying to figure out how to read specific data from a text file that is already written. Example MaxUser=3D32 PortBase=3D8000 I want to be able to have php read them specific pieces of info so I can put them in to forms and update them via php. Any help would be appreciated.
