Re: [PHP] Open Source CMS
Hendry wrote: Hi, Anyone can share your favorite PHP open source CMS to work with and what's the reason? I'm looking for something that easily extensible. I've googled and found severals but I'm still confused, some from the Bitweaver is nice and modular, load what you want to use, wiki, articles, forum, blog, galleries etc. OR take a package and tailor it for your own needs bitweaver.org If you must - it will work with MySQL, but it handles all the good databases as well :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http://www.firebirdsql.org/index.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Open Source CMS
Hendry wrote: Hi, Anyone can share your favorite PHP open source CMS to work with and what's the reason? I'm looking for something that easily extensible. I have just installed websitebaker for a client. I've also got redaxo installed for another client. /Per -- Per Jessen, Zürich (4.3°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Close MySQL Result
Ashley Sheridan wrote:
On Wed, 2010-01-20 at 13:24 -0800, Daevid Vincent wrote:
http://www.php.net/manual/en/function.mysql-free-result.php
mysql_free_result($myresult);
NOTE: mysql_free_result() only needs to be called if you are concerned
about how much memory is being used for queries that return large result
sets. All associated result memory is automatically freed at the end of the
script's execution.
http://us2.php.net/manual/en/function.unset.php
unset($Row);
-Original Message-
From: Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
Sent: Wednesday, January 20, 2010 1:21 PM
To: php-general@lists.php.net
Subject: [PHP] Close MySQL Result
I think I am a dork.
How do I close a MySQL result set to free memory?
Given something like this:
$gsql = Select * from resources where queryName = 'Production';;
$myresult = mysql_query($gsql) or die('Cannot execute Query:
' . mysql_error());
$Row = mysql_fetch_assoc($myresult);
if ($Row == true) { $_SESSION['PRODUCTION'] = $Row['queryValue']; }
else { $_SESSION['PRODUCTION'] = TRUE; }
How do I free up $myresult and $Row?
-ML
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
And you can unset() $row if you want to free memory used by that
variable, although it should be noted that once unset, it's up to PHP's
garbage collection to free the memory, but using unset() on the variable
tells PHP that it can free it if necessary.
If you're that worried about memory as well, try to optimise your
queries a little bit. For example, instead of retrieving all the results
in a table and using PHP to output only what you need, use the WHERE and
LIMIT clauses in MySQL to narrow down the results to only those that you
actually need.
you'll also find a performance upgrade if you load all sql results in to
an array and close up the query / free the results before working on them.
query
for() {
$results[] = $row;
}
close stuff
work on results
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Open Source CMS
Hendry wrote: Hi, Anyone can share your favorite PHP open source CMS to work with and what's the reason? I'm looking for something that easily extensible. I've googled and found severals but I'm still confused, some from the lists: - Drupal - Tomato CMS - modx - xoops - Symphony Thanks # Hendry most are good in different ways; many are carbon copies with different coding styles; pick any of them and work with it till you start fighting it, then review your choice. there's no way anybody can really help you pick, you know what you want to do and what you don't; if you just want to install something load a plugin and skin it then pick drupal or something like it a cms. If you want to code custom things quicker, then pick a framework like zend, kohana, codeigniter and fuse different classes / modules to develop your apps quickly. just to make up a phrase cos I'm in that kind of mood.. only a foolish workman carries one tool in his toolbox - you need different tools for different jobs, just like we need more than php we need more than one framework/class/cms. also worth considering what you want to do, if you don't wanna roll out carbon copy sites with different templates every day of life then don't take on that kinda work forget about picking a cms; or if you just want to work agency style with clients in and out the door as quick as possible with little maintenance use what everybody knows, drupal them all safe in the knowledge that anybody with drupal skills can do the ongoing maintenance and developers / designers with the needed skills are plentiful. ps: 1 - have a quick scan of the source code of each see if it looks easy for you to work with and is coded in a similar style to your own code. 2 - look for the most modular, lightest and mature which fits the results of 1. regards! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] linked data
just a quick scoping mail - Anybody else doing anything linked data oriented, working with a lot of RDF, or using variants of the EAV/CR datamodel in PHP? regards! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Create Days for a specified YEAR...
Hello, I have a table called tDates in which I stored dates. The field that holds the date is called Day_Date (date result) I need to create a STORED PROCEDURE in mySQL that I can specify the YEAR and it will: Check if any dates in that year are already existing - if so generate a ERROR. If they are not existing, create ONE RECORD for each day in that year. If you can, please include the mySQL procedure code and the PHP that would call it. Appreciate any help that be offered. Don Wieland D W D a t a C o n c e p t s ~ d...@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit your business needs. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Open Source CMS
At 11:29 AM +0800 1/21/10, Hendry wrote: Hi, Anyone can share your favorite PHP open source CMS to work with and what's the reason? I'm looking for something that easily extensible. I've googled and found severals but I'm still confused, some from the lists: - Drupal - Tomato CMS - modx - xoops - Symphony Thanks # Hendry The best that I've seen is SilverStripe, try this: http://www.silverstripe.com/ Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Open Source CMS
tedd wrote: At 11:29 AM +0800 1/21/10, Hendry wrote: Hi, Anyone can share your favorite PHP open source CMS to work with and what's the reason? I'm looking for something that easily extensible. I've googled and found severals but I'm still confused, some from the lists: - Drupal - Tomato CMS - modx - xoops - Symphony Thanks # Hendry The best that I've seen is SilverStripe, try this: http://www.silverstripe.com/ Me no likey... it's seems caught between traditional page style and ajax style. Some navigational elements do an ajax update, some do a normal request. The problem is, a normal request causes you to lose your left navigation context. Also, the multilingual / translation stuff seems obtuse. The interface makes me think of some Typo3/Joomla hybrid. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] 大客户营销策略与区域 市场开发
潜在客户留下美好的第一印象 3、赢得潜在客户的三大法宝 4、揣摩潜在客户的心理 5、正确处理好第一次面谈的技巧 6、吸引客户注意的技巧 四、大客户采购流程 1、发先需求、内部酝酿 2、确定采购标准 3、进行系统设计 4、分析需求 5、制定采购预算 6、招标 7、评估各类客户方案 8、签定采购合同、采购安装 9、后续合作 五、有效控制大客户销售进程 1、专业地控制销售进程 2、清楚你在销售什么 3、如何建立信任 4、有效沟通 5、处理异议 6、大客户失控信号 六、签署大客户 1、大客户销售心理曲线 2、什么是谈判？ 3、衡量谈判的三个标准 4、大客户谈判的五个阶段 5、攻克最后一分钟犹豫 七、大客户销售的七种补充手段 --- 【讲师资历】： 汪昭辉 实战营销教练； 从业经历：曾任一汽集团全资子公司财务主管，销售经理，香港嘉陵集团投 资项目营销运营总监，贝发集团战略委员会成员、江西移动创新变革专家组组 长，南油集团战略变革专家组组长，万科集团特邀客户服务专家。从业时间16 年，其中3年国家级大型集团企业职业经理人，2年投资公司项目经理，3年创 业经历，8年咨询实践，咨询过109家企业，涉及产业20个，12种销售模式，考 察过的市场涵盖24个省、18个综合批发市场、2000个以上的终端门店；做过50 0个以上的经销商访谈、5000名以上的消费者访谈，培训过1名以上的营销 人员。 研究主题： 1、营销领导力：本土企业如何以低成本方式，根据基的商业规律，利用定位 的强大潜力，制订领先的品牌策略和竞争策略，超越式快速成长， 2、营销协同力：企业的“腰”如何才能硬起来？营销经理人团队的专业素养 如何才能多快好省地建设起来？ 3、营销执行力：领导如何营造执行条件？经理如何组织执行实施？员工如何 执行出绩效？本土企业如何在以老板为核心的人治企业文化中，建立强有力、 可持续的执行队伍，实现经营的战略目标与高效执行的有机结合？ 研究对象：商务通、急先达、研祥工控、格兰仕、比亚迪，在细分市场的拓 展过程中，在营销整合方面，采取了哪些卓有成效的营销措施？ 擅长领域： 营销战略制订、赢利模式设计、营销组织设计、销售流程优化、销售人员技 能提升、传播与媒体策略、客户服务规划。提出了“手指经济”传播理论。在 营销实战中，形成了“汽泡法”客户管理、SMILE服务模式等独特的运作方法。 ——发表《新经济环境中的企业增长模型》、《现代营销六脉神剑》等论文。 --- ◆主-办-单-位：中--培--信--息--网 ◆标-准-费-用: 3800元/人(买一送一，不再折扣,包括资料午餐费用) ◆报-名-咨-询：T E L: (０７５５) ６１２８ ０１５２（深 圳） ◆报-名-咨-询：T E L: (０ ２ １) ５１０８ ３２９０（上 海） -- [报 名 回 执 表] F A X:(07 55) 6128 0153 或 (0 2 1) 5108 3296 我单位共___人报名参加2009年12月18-20日深圳举办的:《大客 户营销策略、区域市场开发与金牌销售团队管控特训班》； 单位名称：___ 参会人数:_人 联系人：___ 电 话:__ 传 真： 参会费用:￥：__元邮 件：_ 参 会 人：___ 付款方式： □1、现金 □2、转帐 □3、电汇 预订项目：□是、□否 住宿（请选择打“√”） 备注:请您把报名回执回传我司，爲确保您报名无误,请您再次电话确认! __ Information from ESET Smart Security, version of virus signature database 4793 (20100121) __ The message was checked by ESET Smart Security. http://www.eset.com
RE: [PHP] 大客户营销策 略与区域市场 开发
On Thu, 2010-01-21 at 11:15 -0500, Marc Hall wrote: Anyone speak Chinese? [snip/] From the looks of it, it appears to be one of those amazing job offer spam emails, but I can't read Chinese myself. Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] 大客户营销策略与区域市场开发
间16 年，其中3年国家级大型集团企业职业经理人，2年投资公司项目经理，3年创 业经历，8年咨询实践，咨询过109家企业，涉及产业20个，12种销售模式，考 察过的市场涵盖24个省、18个综合批发市场、2000个以上的终端门店；做过50 0个以上的经销商访谈、5000名以上的消费者访谈，培训过1名以上的营销 人员。 研究主题： 1、营销领导力：本土企业如何以低成本方式，根据基的商业规律，利用定位 的强大潜力，制订领先的品牌策略和竞争策略，超越式快速成长， 2、营销协同力：企业的腰如何才能硬起来？营销经理人团队的专业素养 如何才能多快好省地建设起来？ 3、营销执行力：领导如何营造执行条件？经理如何组织执行实施？员工如何 执行出绩效？本土企业如何在以老板为核心的人治企业文化中，建立强有力、 可持续的执行队伍，实现经营的战略目标与高效执行的有机结合？ 研究对象：商务通、急先达、研祥工控、格兰仕、比亚迪，在细分市场的拓 展过程中，在营销整合方面，采取了哪些卓有成效的营销措施？ 擅长领域： 营销战略制订、赢利模式设计、营销组织设计、销售流程优化、销售人员技 能提升、传播与媒体策略、客户服务规划。提出了手指经济传播理论。在 营销实战中，形成了汽泡法客户管理、SMILE服务模式等独特的运作方法。 发表《新经济环境中的企业增长模型》、《现代营销六脉神剑》等论文。 --- ◆主-办-单-位：中--培--信--息--网 ◆标-准-费-用: 3800元/人(买一送一，不再折扣,包括资料午餐费用) ◆报-名-咨-询：T E L: (０７５５) ６１２８ ０１５２（深 圳） ◆报-名-咨-询：T E L: (０ ２ １) ５１０８ ３２９０（上 海） -- [报 名 回 执 表] F A X:(07 55) 6128 0153 或 (0 2 1) 5108 3296 我单位共___人报名参加2009年12月18-20日深圳举办的:《大客 户营销策略、区域市场开发与金牌销售团队管控特训班》； 单位名称：___ 参会人数:_人 联系人：___ 电 话:__ 传 真： 参会费用:￥：__元邮 件：_ 参 会 人：___ 付款方式： □1、现金 □2、转帐 □3、电汇 预订项目：□是、□否 住宿（请选择打√） 备注:请您把报名回执回传我司，��确保您报名无误,请您再次电话确认! __ Information from ESET Smart Security, version of virus signature database 4793 (20100121) __ The message was checked by ESET Smart Security. http://www.eset.com
Re: [PHP] 大客户营销策 略与区域市场 开发
好第一次面谈的技巧 6、吸引客户注意的技巧 四、大客户采购流程 1、发先需求、内部酝酿 2、确定采购标准 3、进行系统设计 4、分析需求 5、制定采购预算 6、招标 7、评估各类客户方案 8、签定采购合同、采购安装 9、后续合作 五、有效控制大客户销售进程 1、专业地控制销售进程 2、清楚你在销售什么 3、如何建立信任 4、有效沟通 5、处理异议 6、大客户失控信号 六、签署大客户 1、大客户销售心理曲线 2、什么是谈判？ 3、衡量谈判的三个标准 4、大客户谈判的五个阶段 5、攻克最后一分钟犹豫 七、大客户销售的七种补充手段 --- 【讲师资历】： 汪昭辉 实战营销教练； 从业经历：曾任一汽集团全资子公司财务主管，销售经理，香港嘉陵集团投 资项目营销运营总监，贝发集团战略委员会成员、江西移动创新变革专家组组 长，南油集团战略变革专家组组长，万科集团特邀客户服务专家。从业时间16 年，其中3年国家级大型集团企业职业经理人，2年投资公司项目经理，3年创 业经历，8年咨询实践，咨询过109家企业，涉及产业20个，12种销售模式，考 察过的市场涵盖24个省、18个综合批发市场、2000个以上的终端门店；做过50 0个以上的经销商访谈、5000名以上的消费者访谈，培训过1名以上的营销 人员。 研究主题： 1、营销领导力：本土企业如何以低成本方式，根据基的商业规律，利用定位 的强大潜力，制订领先的品牌策略和竞争策略，超越式快速成长， 2、营销协同力：企业的腰如何才能硬起来？营销经理人团队的专业素养 如何才能多快好省地建设起来？ 3、营销执行力：领导如何营造执行条件？经理如何组织执行实施？员工如何 执行出绩效？本土企业如何在以老板为核心的人治企业文化中，建立强有力、 可持续的执行队伍，实现经营的战略目标与高效执行的有机结合？ 研究对象：商务通、急先达、研祥工控、格兰仕、比亚迪，在细分市场的拓 展过程中，在营销整合方面，采取了哪些卓有成效的营销措施？ 擅长领域： 营销战略制订、赢利模式设计、营销组织设计、销售流程优化、销售人员技 能提升、传播与媒体策略、客户服务规划。提出了手指经济传播理论。在 营销实战中，形成了汽泡法客户管理、SMILE服务模式等独特的运作方法。 发表《新经济环境中的企业增长模型》、《现代营销六脉神剑》等论文。 --- ◆主-办-单-位：中--培--信--息--网 ◆标-准-费-用: 3800元/人(买一送一，不再折扣,包括资料午餐费用) ◆报-名-咨-询：T E L: (０７５５) ６１２８ ０１５２（深 圳） ◆报-名-咨-询：T E L: (０ ２ １) ５１０８ ３２９０（上 海） -- [报 名 回 执 表] F A X:(07 55) 6128 0153 或 (0 2 1) 5108 3296 我单位共___人报名参加2009年12月18-20日深圳举办的:《大客 户营销策略、区域市场开发与金牌销售团队管控特训班》； 单位名称：___ 参会人数:_人 联系人：___ 电 话:__ 传 真： 参会费用:￥：__元邮 件：_ 参 会 人：___ 付款方式： □1、现金 □2、转帐 □3、电汇 预订项目：□是、□否 住宿（请选择打√） 备注:请您把报名回执回传我司，确保您报名无误,请您再次电话确认! __ Information from ESET Smart Security, version of virus signature database 4793 (20100121) __ The message was checked by ESET Smart Security. http://www.eset.com
RE: [PHP] 大客户营销策略与区域市 场开发
From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: Thursday, January 21, 2010 11:18 AM To: Marc Hall Cc: 'sssumjeg'; php-general@lists.php.net Subject: RE: [PHP] 大客户营销策略与区域市场开发 On Thu, 2010-01-21 at 11:15 -0500, Marc Hall wrote: Anyone speak Chinese? [snip/] From the looks of it, it appears to be one of those amazing job offer spam emails, but I can't read Chinese myself. Thanks, Ash http://www.ashleysheridan.co.uk Ash, that was my impression too. The requested info at the bottom makes me think of the phishing scam they use to pretend to be your Bank or CC company when they call you. The other mystery meat is the Nordstrom email address in the from field. Lastly, in the header you find this Authentication-Results: pb1.pair.com header.from=contactcustomers...@nordstrom.com; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=contactcustomers...@nordstrom.com; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain nordstrom.com from 219.137.7.72 cause and error) X-PHP-List-Original-Sender: contactcustomers...@nordstrom.com X-Host-Fingerprint: 219.137.7.72 unknown X-Originating-IP: [185.63.131.37] Since, I don’t speak Chinese myself I can’t be 1005 sure. __ Information from ESET Smart Security, version of virus signature database 4793 (20100121) __ The message was checked by ESET Smart Security. http://www.eset.com
Re: [PHP] 大客户营销策略与区域市 场开发
Marc Hall wrote: From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: Thursday, January 21, 2010 11:18 AM To: Marc Hall Cc: 'sssumjeg'; php-general@lists.php.net Subject: RE: [PHP] 大客户营销策略与区域市场开发 On Thu, 2010-01-21 at 11:15 -0500, Marc Hall wrote: Anyone speak Chinese? [snip/] From the looks of it, it appears to be one of those amazing job offer spam emails, but I can't read Chinese myself. If it's an 'Amazing' job offer perhaps I should inquire as China is a lot better then Turkey for IT jobs (where I am now)! Perhaps they might take me in as a Cisco and UNIX engineer and once I get over there after being picked up by a dark panel van or minibus perhaps wake up somewhere in downtown Shanghai with scars in the locations of my vital organs :-P I'm betting it's 100% mostly a scam as normally only people who wish to ask questions or collaborate use these lists 99.9% of the time. The rest are either clueless, time wasters, or spam emails! Of course many of you guys already know this and am just stating the obvious here :-) ok time for me to get spamming the other mailling lists: (ha oops did I just say that out loud?? hahahah ;-P ) Regards, Kaya -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 大客户营销策略与区域市场开发
OP: Watch your mouth. 2010/1/21 Kaya Saman samank...@netscape.net Marc Hall wrote: From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: Thursday, January 21, 2010 11:18 AM To: Marc Hall Cc: 'sssumjeg'; php-general@lists.php.net Subject: RE: [PHP] 大客户营销策略与区域市场开发 On Thu, 2010-01-21 at 11:15 -0500, Marc Hall wrote: Anyone speak Chinese? [snip/] From the looks of it, it appears to be one of those amazing job offer spam emails, but I can't read Chinese myself. If it's an 'Amazing' job offer perhaps I should inquire as China is a lot better then Turkey for IT jobs (where I am now)! Perhaps they might take me in as a Cisco and UNIX engineer and once I get over there after being picked up by a dark panel van or minibus perhaps wake up somewhere in downtown Shanghai with scars in the locations of my vital organs :-P I'm betting it's 100% mostly a scam as normally only people who wish to ask questions or collaborate use these lists 99.9% of the time. The rest are either clueless, time wasters, or spam emails! Of course many of you guys already know this and am just stating the obvious here :-) ok time for me to get spamming the other mailling lists: (ha oops did I just say that out loud?? hahahah ;-P ) Regards, Kaya -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cookies sessions
On Thu, 21 Jan 2010 08:54:44 -0500, tedd.sperl...@gmail.com (tedd) wrote: At 12:15 PM +1100 1/21/10, clanc...@cybec.com.au wrote: On Wed, 20 Jan 2010 20:05:42 -0200, bsfaja...@gmail.com (Bruno Fajardo) wrote: Well, I hope this information is helpful. Yes, thanks to everyone who contributed. I now have a better understanding of what cookies are, and have turned on output buffering, enabling me to put the handler where I want, and still be able to debug it. Clancy One last thing. I use sessions for the storage of variables I need between pages, but I use cookies to leave data on the user's computer in case they come back to my site and want to pick up where they left off. Both operations store variables, but are for different purposes. Yes; I'm doing that too. I am setting up a private website, and using cookies to control access to it. Clancy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cookies sessions
On Fri, 2010-01-22 at 08:58 +1100, clanc...@cybec.com.au wrote: On Thu, 21 Jan 2010 08:54:44 -0500, tedd.sperl...@gmail.com (tedd) wrote: At 12:15 PM +1100 1/21/10, clanc...@cybec.com.au wrote: On Wed, 20 Jan 2010 20:05:42 -0200, bsfaja...@gmail.com (Bruno Fajardo) wrote: Well, I hope this information is helpful. Yes, thanks to everyone who contributed. I now have a better understanding of what cookies are, and have turned on output buffering, enabling me to put the handler where I want, and still be able to debug it. Clancy One last thing. I use sessions for the storage of variables I need between pages, but I use cookies to leave data on the user's computer in case they come back to my site and want to pick up where they left off. Both operations store variables, but are for different purposes. Yes; I'm doing that too. I am setting up a private website, and using cookies to control access to it. Clancy Don't use cookies, use sessions for this. Information stored in cookies is susceptible to being read by pretty much anyone, hence the scare of using cookies that people get. Cookies in themselves are not the problem, but using them for anything you want to keep safe, like login details, etc, is a bad idea. Generally, a session ID is stored in the cookie, which gives nothing away to anyone trying to read it. Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] Cookies sessions
clanc...@cybec.com.au wrote: Yes; I'm doing that too. I am setting up a private website, and using cookies to control access to it. Clancy The only variable I store in a cookie is the session id. Everything else is stored in the session database. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Close MySQL Result
-Original Message-
From: Nathan Rixham [mailto:nrix...@gmail.com]
you'll also find a performance upgrade if you load all sql
results in to
an array and close up the query / free the results before
working on them.
query
for() {
$results[] = $row;
}
close stuff
work on results
Do you have any proof of this?
What would be the logic here?
Got some example benchmarks?
Got a URL of a whitepaper or something that discusses this?
I would think the only things that the mysql calls are doing is holding
pointers to the next record and DB handle. I can't imagine they are using
that much resources, nor would they be just spinning and waiting tying up
CPU cycles either.
I've never heard this to be the case.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Open Source CMS
On 1/21/2010 7:58 AM, Paul M Foster wrote: On Thu, Jan 21, 2010 at 11:29:54AM +0800, Hendry wrote: Hi, Anyone can share your favorite PHP open source CMS to work with and what's the reason? I'm looking for something that easily extensible. I've googled and found severals but I'm still confused, some from the lists: - Drupal - Tomato CMS - modx - xoops - Symphony Add CodeIgniter to your list. Relatively easy to understand and extend. Though I'm not sure I'd classify it as a content management system. (Same for Symfony.) Paul I think is talking about Symphony CMS (XSLT-powered open source content management system) and not Symfony framework. /i -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Close MySQL Result
Daevid Vincent wrote:
-Original Message-
From: Nathan Rixham [mailto:nrix...@gmail.com]
you'll also find a performance upgrade if you load all sql
results in to
an array and close up the query / free the results before
working on them.
query
for() {
$results[] = $row;
}
close stuff
work on results
Do you have any proof of this?
What would be the logic here?
Got some example benchmarks?
Got a URL of a whitepaper or something that discusses this?
I would think the only things that the mysql calls are doing is holding
pointers to the next record and DB handle. I can't imagine they are using
that much resources, nor would they be just spinning and waiting tying up
CPU cycles either.
I've never heard this to be the case.
I have proof to the contrary :-)
?php
echo number_format(memory_get_usage()) . Bytes used before query\n;
$conn = mysql_connect('localhost', 'x', 'x');
$result = mysql_query(SELECT * FROM table_name);
$count = mysql_num_rows($result);
echo $count . rows returned\n;
echo number_format(memory_get_usage()) . Bytes used after query\n;
while($rows[] = mysql_fetch_assoc($result)) { }
echo number_format(memory_get_usage()) . Bytes used after array
creation\n;
mysql_free_result($result);
echo number_format(memory_get_usage()) . Bytes used after
mysql_free_result\n;
?
65,588 Bytes used before query
6940 rows returned
67,264 Bytes used after query
6,376,612 Bytes used after array creation
6,376,756 Bytes used after mysql_free_result
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Close MySQL Result
Shawn McKenzie wrote:
Daevid Vincent wrote:
-Original Message-
From: Nathan Rixham [mailto:nrix...@gmail.com]
you'll also find a performance upgrade if you load all sql
results in to
an array and close up the query / free the results before
working on them.
query
for() {
$results[] = $row;
}
close stuff
work on results
Do you have any proof of this?
What would be the logic here?
Got some example benchmarks?
Got a URL of a whitepaper or something that discusses this?
I would think the only things that the mysql calls are doing is holding
pointers to the next record and DB handle. I can't imagine they are using
that much resources, nor would they be just spinning and waiting tying up
CPU cycles either.
I've never heard this to be the case.
I have proof to the contrary :-)
?php
echo number_format(memory_get_usage()) . Bytes used before query\n;
$conn = mysql_connect('localhost', 'x', 'x');
$result = mysql_query(SELECT * FROM table_name);
$count = mysql_num_rows($result);
echo $count . rows returned\n;
echo number_format(memory_get_usage()) . Bytes used after query\n;
while($rows[] = mysql_fetch_assoc($result)) { }
echo number_format(memory_get_usage()) . Bytes used after array
creation\n;
mysql_free_result($result);
echo number_format(memory_get_usage()) . Bytes used after
mysql_free_result\n;
?
65,588 Bytes used before query
6940 rows returned
67,264 Bytes used after query
6,376,612 Bytes used after array creation
6,376,756 Bytes used after mysql_free_result
yup appears i was talking bollocks :D lolol - confusion came on my part
from optimisation of a high traffic site over the past few years!
correction:
on simple scripts it is slower, marginally, (due to two for loops and
more data in memory)
however - in real world applications where such nasty practises as
escaping in and out of html to render results and secondary per row
queries or api calls are taken in to account this method of getting
everything out of the db in a single swift action gives the performance
boost - and more over on high traffic sites freeing up the connection /
query resources as quickly as possible makes a rather noticeable impact,
too many open connections and queries can be very nasty when your
getting a few hundred / thousand requests per second.
sorry 'bout that!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Foreign Characters Break in MySQL
Hello I'm currently trying to use PHP to insert foreign characters into one of the mysql database tables.mysql_query() worked seamlessly, but when I check the inserted data on phpMyAdmin it shows the foreign characters in broken letters, like this ì‹œíŒ - jibberish...The foreign characters show fine when I'm typing it out on my editor to code PHP, but it gets broken into unrecognizable symbols when put into mysql database columns. I tried to create the same thing this time through phpMyAdmin console and it worked great, the foreign characters showed correctly as they should.The column that I'm trying to put the foreign characters into is set as utf8_general_ci.I wish to use PHP to insert the data into the database because I'll be inserting massive amounts of them at once, so I just can't continue with this problem at hand. I'll greatly appreciate any help, thank you. _ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. http://clk.atdmt.com/GBL/go/196390709/direct/01/
Re: [PHP] Foreign Characters Break in MySQL
Ryan Park wrote: Hello I'm currently trying to use PHP to insert foreign characters into one of the mysql database tables.mysql_query() worked seamlessly, but when I check the inserted data on phpMyAdmin it shows the foreign characters in broken letters, like this ì‹œíŒ - jibberish...The foreign characters show fine when I'm typing it out on my editor to code PHP, but it gets broken into unrecognizable symbols when put into mysql database columns. I tried to create the same thing this time through phpMyAdmin console and it worked great, the foreign characters showed correctly as they should.The column that I'm trying to put the foreign characters into is set as utf8_general_ci.I wish to use PHP to insert the data into the database because I'll be inserting massive amounts of them at once, so I just can't continue with this problem at hand. I'll greatly appreciate any help, thank you. _ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. http://clk.atdmt.com/GBL/go/196390709/direct/01/ How about showing a little of the insert code. ie: how you are gathering the data, how you are preping the data, and the actual insert statement. -- Jim Lucas NOC Manager 541-323-9113 BendTel, Inc. http://www.bendtel.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Foreign Characters Break in MySQL
Forgot to reply all.
You can see that it's in the middle of the sql statement.
It looks fine here but some how it breaks during the query.
?php
mysql_connect(localhost, adminID, password) or die(mysql_error());
echo Connected to MySQLbr /;
mysql_select_db(databasename) or die(mysql_error());
echo Connected to Databasebr /;
$sql = INSERT INTO xe_modules (module_srl, module, module_category_srl,
layout_srl, menu_srl, site_srl, mid, skin, browser_title, description,
is_default, content, open_rss, header_text, footer_text, regdate) VALUES
('135', 'bodex', '0', '53', '0', '0', 'free', 'xe_default', '자유게시판
', '', 'N', '', 'Y', '', '', UNIX_TIMESTAMP());;
mysql_query($sql) or die(mysql_error());
mysql_close();
?
On 1/21/2010 5:19 PM, Jim Lucas wrote:
Ryan Park wrote:
Hello I'm currently trying to use PHP to insert foreign characters into one of the
mysql database tables.mysql_query() worked seamlessly, but when I check the
inserted data on phpMyAdmin it shows the foreign characters in broken letters,
like this ì‹œíŒ- jibberish...The foreign characters show fine when I'm typing
it out on my editor to code PHP, but it gets broken into unrecognizable symbols
when put into mysql database columns.
I tried to create the same thing this time through phpMyAdmin console and it
worked great, the foreign characters showed correctly as they should.The column
that I'm trying to put the foreign characters into is set as utf8_general_ci.I
wish to use PHP to insert the data into the database because I'll be inserting
massive amounts of them at once, so I just can't continue with this problem at
hand.
I'll greatly appreciate any help, thank you.
_
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/196390709/direct/01/
How about showing a little of the insert code. ie: how you are gathering the
data, how you are preping the data, and the actual insert statement.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Open Source CMS
On Wednesday 20 January 2010 10:29:38 pm Hendry wrote: Hi, Thanks for both Robert and Allen for sharing, I agree, Drupal is very easy to start with, and it is also very powerful, but somehow, I find it very hard to extend which is might be due to my lack of experience. # Hendry The way you extend Drupal is rather different than most other systems due to its architecture. However, once you wrap your head around doing so it is extremely extensible. The online docs on drupal.org are a pretty good place to start, but I can also recommend this book: http://www.packtpub.com/drupal-6-module-development/book Disclaimer: The author used to work with me, and I'm a Drupal core developer so I am admittedly biased. :-) --Larry Garfield -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Foreign Characters Break in MySQL
Hi, all,
I'am not able test it out now.
Did you tried to change the collation to utf8_bin from utf8_general_ci ?
Eric,
Regards,
On 1/22/10, Ryan Park ryanhp...@live.com wrote:
Forgot to reply all.
You can see that it's in the middle of the sql statement.
It looks fine here but some how it breaks during the query.
?php
mysql_connect(localhost, adminID, password) or die(mysql_error());
echo Connected to MySQLbr /;
mysql_select_db(databasename) or die(mysql_error());
echo Connected to Databasebr /;
$sql = INSERT INTO xe_modules (module_srl, module, module_category_srl,
layout_srl, menu_srl, site_srl, mid, skin, browser_title, description,
is_default, content, open_rss, header_text, footer_text, regdate) VALUES
('135', 'bodex', '0', '53', '0', '0', 'free', 'xe_default', '자유게시판 ', '',
'N', '', 'Y', '', '', UNIX_TIMESTAMP());;
mysql_query($sql) or die(mysql_error());
mysql_close();
?
On 1/21/2010 5:19 PM, Jim Lucas wrote:
Ryan Park wrote:
Hello I'm currently trying to use PHP to insert foreign characters into
one of the mysql database tables.mysql_query() worked seamlessly, but when I
check the inserted data on phpMyAdmin it shows the foreign characters in
broken letters, like this ì‹œíŒ- jibberish...The foreign characters show
fine when I'm typing it out on my editor to code PHP, but it gets broken
into unrecognizable symbols when put into mysql database columns.
I tried to create the same thing this time through phpMyAdmin console and
it worked great, the foreign characters showed correctly as they should.The
column that I'm trying to put the foreign characters into is set as
utf8_general_ci.I wish to use PHP to insert the data into the database
because I'll be inserting massive amounts of them at once, so I just can't
continue with this problem at hand.
I'll greatly appreciate any help, thank you.
_
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/196390709/direct/01/
How about showing a little of the insert code. ie: how you are gathering
the
data, how you are preping the data, and the actual insert statement.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Foreign Characters Break in MySQL
Op 1/22/10 2:28 AM, Ryan Park schreef:
Forgot to reply all.
You can see that it's in the middle of the sql statement.
It looks fine here but some how it breaks during the query.
?php
mysql_connect(localhost, adminID, password) or die(mysql_error());
echo Connected to MySQLbr /;
mysql_select_db(databasename) or die(mysql_error());
echo Connected to Databasebr /;
$sql = INSERT INTO xe_modules (module_srl, module, module_category_srl,
layout_srl, menu_srl, site_srl, mid, skin, browser_title, description,
is_default, content, open_rss, header_text, footer_text, regdate) VALUES
('135', 'bodex', '0', '53', '0', '0', 'free', 'xe_default', '자유게시판
', '', 'N', '', 'Y', '', '', UNIX_TIMESTAMP());;
you need to:
1. have some understanding of char encoding and character sets.
2. define you DB[tables] to use a collation that supports the stuff you want to
enter.
3. you need to connect to the DB with a suitable charset (google 'SET NAMES')
4. you need to make sure the data you are putting into your queries is in that
same charset.
basically you need UTF8 - be prepared for some pain and a lot of reading in
order
to get to grips with these concepts, I've personally found that encoding,
charsets et al
are not the easiest things to one's head round.
mysql_query($sql) or die(mysql_error());
mysql_close();
?
On 1/21/2010 5:19 PM, Jim Lucas wrote:
Ryan Park wrote:
Hello I'm currently trying to use PHP to insert foreign characters
into one of the mysql database tables.mysql_query() worked
seamlessly, but when I check the inserted data on phpMyAdmin it shows
the foreign characters in broken letters, like this ì‹œíŒ-
jibberish...The foreign characters show fine when I'm typing it out
on my editor to code PHP, but it gets broken into unrecognizable
symbols when put into mysql database columns.
I tried to create the same thing this time through phpMyAdmin console
and it worked great, the foreign characters showed correctly as they
should.The column that I'm trying to put the foreign characters into
is set as utf8_general_ci.I wish to use PHP to insert the data into
the database because I'll be inserting massive amounts of them at
once, so I just can't continue with this problem at hand.
I'll greatly appreciate any help, thank you.
_
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/196390709/direct/01/
How about showing a little of the insert code. ie: how you are
gathering the
data, how you are preping the data, and the actual insert statement.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
