<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Zendcasts Forum / ZC18: Zend_Db Update and Delete]]></title>
		<link>http://www.zendcasts.com/forum/viewtopic.php?id=62</link>
		<description><![CDATA[The most recent posts in ZC18: Zend_Db Update and Delete.]]></description>
		<lastBuildDate>Mon, 15 Feb 2010 09:09:15 +0000</lastBuildDate>
		<generator>FluxBB</generator>
		<item>
			<title><![CDATA[Re: ZC18: Zend_Db Update and Delete]]></title>
			<link>http://www.zendcasts.com/forum/viewtopic.php?pid=629#p629</link>
			<description><![CDATA[<p>Hi jon, </p><p>I mean the code example delete is below :</p><p>$where = $table-&gt;getAdapter()-&gt;quoteInto(&#039;bug_id = ?&#039;, 1234);<br />$table-&gt;update($data, $where);</p><p>How to do same if I have 2 condition to delete something.<br />Are the parameter $where provide something array()? <br />like example below :</p><p>$where[] = $table-&gt;getAdapter()-&gt;quoteInto(&#039;name = ?&#039;, $name);<br />$where[] = $table-&gt;getAdapter()-&gt;quoteInto(&#039;description= ?&#039;, $description);<br />$table-&gt;update($data, $where);</p><br /><p>And I already googling and I don&#039;t find any article about what different of methods quote(), quoteInto(), and quoteIdentifier(). Can u explain different the methods?</p><p>Thanks before</p>]]></description>
			<author><![CDATA[dummy@example.com (akongz)]]></author>
			<pubDate>Mon, 15 Feb 2010 09:09:15 +0000</pubDate>
			<guid>http://www.zendcasts.com/forum/viewtopic.php?pid=629#p629</guid>
		</item>
		<item>
			<title><![CDATA[Re: ZC18: Zend_Db Update and Delete]]></title>
			<link>http://www.zendcasts.com/forum/viewtopic.php?pid=627#p627</link>
			<description><![CDATA[<p>hi Akongz, </p><p>Example 18 on the documentation works in a similar way:</p><p><a href="http://framework.zend.com/manual/en/zend.db.select.html">http://framework.zend.com/manual/en/zend.db.select.html</a></p><p>$minimumPrice = 100;<br />$maximumPrice = 500;</p><p>$select = $db-&gt;select()<br />&#160; &#160; &#160; &#160; &#160; &#160; &#160;-&gt;from(&#039;products&#039;,<br />&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; array(&#039;product_id&#039;, &#039;product_name&#039;, &#039;price&#039;))<br />&#160; &#160; &#160; &#160; &#160; &#160; &#160;-&gt;where(&#039;price &gt; ?&#039;, $minimumPrice)<br />&#160; &#160; &#160; &#160; &#160; &#160; &#160;-&gt;where(&#039;price &lt; ?&#039;, $maximumPrice);</p><p>I think you&#039;ll want to create a where clause and then pass it into the proper Zend_Db_* class instance.</p>]]></description>
			<author><![CDATA[dummy@example.com (Jon Lebensold)]]></author>
			<pubDate>Sun, 14 Feb 2010 21:26:31 +0000</pubDate>
			<guid>http://www.zendcasts.com/forum/viewtopic.php?pid=627#p627</guid>
		</item>
		<item>
			<title><![CDATA[Re: ZC18: Zend_Db Update and Delete]]></title>
			<link>http://www.zendcasts.com/forum/viewtopic.php?pid=623#p623</link>
			<description><![CDATA[<p>Hi I want ask something about delete Action.</p><p>If we want to delete some row but I don;t know the id of PK but I have another 2 condition in where.</p><p>Like example I have name &amp; email, in query sql must be :</p><p>DELETE FROM users<br />WHERE name = &#039;Eric&#039; AND email = &#039;eric@email.com&#039;</p><p>So how to do it in Zend?</p><p>Thanks.</p>]]></description>
			<author><![CDATA[dummy@example.com (akongz)]]></author>
			<pubDate>Sat, 13 Feb 2010 02:55:31 +0000</pubDate>
			<guid>http://www.zendcasts.com/forum/viewtopic.php?pid=623#p623</guid>
		</item>
		<item>
			<title><![CDATA[Re: ZC18: Zend_Db Update and Delete]]></title>
			<link>http://www.zendcasts.com/forum/viewtopic.php?pid=224#p224</link>
			<description><![CDATA[<p>Hi martin,</p><p>this is the default functionality of the framework, and while its good as a starting point, such a route isn&#039;t search-engine optimized. Obviously, any conventions you choose to apply in you application will need to be documented and kept for your own sanity!</p>]]></description>
			<author><![CDATA[dummy@example.com (Jon Lebensold)]]></author>
			<pubDate>Mon, 21 Sep 2009 19:07:32 +0000</pubDate>
			<guid>http://www.zendcasts.com/forum/viewtopic.php?pid=224#p224</guid>
		</item>
		<item>
			<title><![CDATA[ZC18: Zend_Db Update and Delete]]></title>
			<link>http://www.zendcasts.com/forum/viewtopic.php?pid=222#p222</link>
			<description><![CDATA[<p>I&#039;m fairly new to the Zend Frame work and I love your casts :-D <br />I&#039;m trying to understand some of the decisions you have made during them like:-</p><p>In this episode of ZendCasts you used a router to inform the framework that the final item in the URI was the id of the record to be edited or deleted.</p><p>Why did you not use a URI like</p><p>/index/update/id/7</p><p>surely this would lower the risk of failure in the future because you would not have to remember the change to the router.</p><p>Thanks in advance<br />Martin</p>]]></description>
			<author><![CDATA[dummy@example.com (marche1990)]]></author>
			<pubDate>Mon, 21 Sep 2009 16:57:54 +0000</pubDate>
			<guid>http://www.zendcasts.com/forum/viewtopic.php?pid=222#p222</guid>
		</item>
	</channel>
</rss>

