PHP Wizards - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=38393.0&return_msg=38393.44"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=38393.1">1–10</a>…<a href="lmessages.php?webtag=DEFAULT&msg=38393.21">21–30</a><a href="lmessages.php?webtag=DEFAULT&msg=38393.31">31–40</a><a href="lmessages.php?webtag=DEFAULT&msg=38393.41">41–50</a><a href="lmessages.php?webtag=DEFAULT&msg=38393.51">51–60</a>…<a href="lmessages.php?webtag=DEFAULT&msg=38393.101">101</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=38393.44">PHP Wizards</a> </h3> <div id="messages" data-navigation="38393_44_101_10"> <a name="a38393_44"></a><div class="message" id="message_38393_44"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time">20 Apr 2011 11:10</span> <div class="clearer"></div> </div><div class="message_to">To: Ken (SHIELDSIT) <span><span class="image post_read" title="Read: 20 Apr 2011 11:14"></span></span> <span class="message_count">44 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.44">38393.44</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.42">38393.42</a></div> <div class="message_body"> It does make things a lot easier, as you don't have to use SQL - you interact with the database in terms of the language you're using to write the applications. For example, Rails lets you do stuff like:<br /> <div class="quotetext" id="code-ruby"><b>ruby code:</b></div><pre class="code">Post.<span style="color:#9900CC;">destroy_all</span> <span style="color:#ff3333; font-weight:bold;">:user</span> <span style="color:#006600; font-weight:bold;">=></span> User.<span style="color:#9900CC;">find_by_email</span><span style="color:#006600; font-weight:bold;">(</span><span style="color:#996600;">"andy@caerphoto.com"</span><span style="color:#006600; font-weight:bold;">)</span></pre></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.44&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.44"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_45"></a><div class="message" id="message_38393_45"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 11:10</span> <div class="clearer"></div> </div><div class="message_to">To: Ken (SHIELDSIT) <span><span class="image post_read" title="Read: 20 Apr 2011 11:14"></span></span> <span class="message_count">45 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.45">38393.45</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.42">38393.42</a></div> <div class="message_body"> When you strip away all the crap, OO itself isn't that bad. (Though it's also <em>not</em> the One True Path.)<br /> <br /> It's all the unnecessary over-complicated crap, like ORM and silly design patterns and so on, that makes it seem scary.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.45&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.45"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_46"></a><div class="message" id="message_38393_46"> <div class="message_header"> <div class="message_from"> From: steve<span class="message_time">20 Apr 2011 11:15</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 12:20"></span></span> <span class="message_count">46 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.46">38393.46</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_44" target="_self">38393.44</a></div> <div class="message_body"> That looks even more complicated <span class="emoticon e_embarrassed" title=":$"><span class="e__">:$</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.46&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.46"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_47"></a><div class="message" id="message_38393_47"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 11:16</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 12:20"></span></span> <span class="message_count">47 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.47">38393.47</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_44" target="_self">38393.44</a></div> <div class="message_body"> If you don't want to use SQL, don't use a database that runs on SQL! ( <span class="emoticon e_shock" title=":O"><span class="e__">:O</span></span> )</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.47&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.47"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_48"></a><div class="message" id="message_38393_48"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time">20 Apr 2011 12:21</span> <div class="clearer"></div> </div><div class="message_to">To: steve <span><span class="image post_read" title="Read: 20 Apr 2011 12:29"></span></span> <span class="message_count">48 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.48">38393.48</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_46" target="_self">38393.46</a></div> <div class="message_body"> Than what? I'm not sure what the corresponding SQL would look like but I'm pretty sure it'd be more complicated than that.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.48&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.48"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_49"></a><div class="message" id="message_38393_49"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 12:57</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 13:12"></span></span> <span class="message_count">49 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.49">38393.49</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_48" target="_self">38393.48</a></div> <div class="message_body"> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">I'm pretty sure it'd be more complicated</div><br /> I'm not...<br /> <br /> <div class="quotetext" id="code-sql"><b>sql code:</b></div><pre class="code"><a target="_blank" href="http://search.mysql.com/search?site=refman-%35%31&q=DELETE"><span style="color: #990099; font-weight: bold;">DELETE</span></a> Post <a target="_blank" href="http://search.mysql.com/search?site=refman-%35%31&q=WHERE"><span style="color: #990099; font-weight: bold;">WHERE</span></a> Creator <span style="color: #CC0099;">=</span> findUserByEmail<span style="color: #FF00FF;">(</span><span style="color: #008000;">'andy@caerphoto.com'</span><span style="color: #FF00FF;">)</span></pre></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.49&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.49"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_50"></a><div class="message" id="message_38393_50"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time">20 Apr 2011 13:17</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 13:26"></span></span> <span class="message_count">50 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.50">38393.50</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_49" target="_self">38393.49</a></div> <div class="message_body"> Will that also trigger any callbacks set up in the Post model, for example if it's the last Post being deleted, also delete the associated Thread?<br /> <br /> And what is this 'findUserByEmail' function?</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.50&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.50"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_51"></a><div class="message" id="message_38393_51"> <div class="message_header"> <div class="message_from"> From: Ken (SHIELDSIT)<span class="message_time">20 Apr 2011 13:27</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 20 Apr 2011 13:29"></span></span> <span class="message_count">51 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.51">38393.51</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_49" target="_self">38393.49</a></div> <div class="message_body"> Pete are you up for a complicated question?</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.51&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.51"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_52"></a><div class="message" id="message_38393_52"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 13:36</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 20 Apr 2011 13:39"></span></span> <span class="message_count">52 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.52">38393.52</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_50" target="_self">38393.50</a></div> <div class="message_body"> Yes, of course, (because that's how my imaginary SQL database has been configured to react).<br /> <br /> (It's been possible to do triggers with databases for <em>years</em>, long before Rails came along. Probably even before Ruby too.)<br /> <br /> <br /> It's a function (stored procedure), just like your User.findByEmail one. It's automatically generated by another one of those triggers - every time a table is created or altered - so it's faster than doing dynamic lookups with Method Missing.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.52&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.52"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a38393_53"></a><div class="message" id="message_38393_53"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time">20 Apr 2011 13:39</span> <div class="clearer"></div> </div><div class="message_to">To: Ken (SHIELDSIT) <span><span class="image post_read" title="Read: 20 Apr 2011 14:00"></span></span> <span class="message_count">53 of 101</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=38393.53">38393.53</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=38393.44#a38393_51" target="_self">38393.51</a></div> <div class="message_body"> If it's a quick complicated one... I'm supposed to be finishing something off at the moment, but keep getting distracted by that dastardly Rails fan. <span class="emoticon e_angry" title=":@"><span class="e__">:@</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=38393.53&return_msg=38393.44" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="38393.53"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> <div class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="38393.54" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>