<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">It is possible to do this with Perl. I don't think Alan was saying otherwise. Catalyst is just one way to try to ease development and maintenance of web application.
Mojolicious is another (and the one I use, because it seems to be simpler to write small things with). Dancer is another, and in my opinion, more comparable to Mojolicious.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">To connect to MySQL in all of these cases, or any other case you might try, you'll use the DBI module, which interfaces with most SQL databases. Any Perl you
write can use DBI.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Chicago-talk [mailto:chicago-talk-bounces+doug.bell=baml.com@pm.org]
<b>On Behalf Of </b>Richard Reina<br>
<b>Sent:</b> Wednesday, July 29, 2015 3:15 PM<br>
<b>To:</b> Chicago.pm chatter<br>
<b>Subject:</b> Re: [Chicago-talk] Dreamweaver perl and mysql<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Wow just took a look at catalyst. Seems easier to just stick with Dreamweaver and access my MySQL tables with php -- if you are saying I can't do so with perl.<br>
<br>
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">2015-07-29 12:52 GMT-05:00 Alan Mead <<a href="mailto:amead2@alanmead.org" target="_blank">amead2@alanmead.org</a>>:<o:p></o:p></p>
<div>
<p class="MsoNormal">Richard,<br>
<br>
You'll need to learn enough HTML to transform your Dreamweaver output files into templates. There are many ways to do this but you probably want a framework like Mojolicious or Catalyst. I see that the Catalyst tutorial includes the kind of website you want
to build (as "CRUD"):<br>
<br>
<a href="https://metacpan.org/pod/Catalyst::Manual::Tutorial" target="_blank">https://metacpan.org/pod/Catalyst::Manual::Tutorial</a><br>
<a href="https://metacpan.org/pod/Catalyst::Manual::Tutorial::04_BasicCRUD" target="_blank">https://metacpan.org/pod/Catalyst::Manual::Tutorial::04_BasicCRUD</a><br>
<br>
I'm also sure you could do this using Mojolicious. But, again, you're SOL unless you're willing to learn how to work with these technologies.<br>
<br>
-Alan<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">On 7/29/2015 11:55 AM, Richard Reina wrote:<o:p></o:p></p>
</div>
</div>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I do not know HTML. I have created a website with dreamweaver that mostly just looks pretty and and jumps to different pages on a site. I have also written a database app with perl->MySQL that users on a small
LAN can use to enter and query data. However, it is displayed on linux consoles using rudimentary menu apps based on curses. I would like to create a website that would allow users to enter and query data from MySQL databases and carry out functions such as
updating users via email when changes are made. Since I don't know HTML or Apache can I just use dreamweaver and somehow enter perl code to talk to MySQL? Or is there a better and easier way for me to go about this?<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Thanks for any ideas.<o:p></o:p></p>
</div>
<p class="MsoNormal">Richard <o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
</div>
</div>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Chicago-talk mailing list<o:p></o:p></pre>
<pre><a href="mailto:Chicago-talk@pm.org" target="_blank">Chicago-talk@pm.org</a><o:p></o:p></pre>
<pre><a href="http://mail.pm.org/mailman/listinfo/chicago-talk" target="_blank">http://mail.pm.org/mailman/listinfo/chicago-talk</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Alan D. Mead, Ph.D.<o:p></o:p></pre>
<pre>President, Talent Algorithms Inc.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>science + technology = better workers<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>+815.588.3846 (Office)<o:p></o:p></pre>
<pre>+267.334.4143 (Mobile)<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><a href="http://www.alanmead.org" target="_blank">http://www.alanmead.org</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Announcing the Journal of Computerized Adaptive Testing (JCAT), a<o:p></o:p></pre>
<pre>peer-reviewed electronic journal designed to advance the science and<o:p></o:p></pre>
<pre>practice of computerized adaptive testing: <a href="http://www.iacat.org/jcat" target="_blank">http://www.iacat.org/jcat</a><o:p></o:p></pre>
</div>
<p class="MsoNormal"><br>
_______________________________________________<br>
Chicago-talk mailing list<br>
<a href="mailto:Chicago-talk@pm.org">Chicago-talk@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/chicago-talk" target="_blank">http://mail.pm.org/mailman/listinfo/chicago-talk</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<HR>This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.<BR>
</body>
</html>