[jQuery] How do I hook up the "Editable" plug-in to a MySQL DB?

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>

<style>

</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
Hey Rick:<o:p></o:p>
<o:p> </o:p>
See if this makes sense to you… I just made a CF page from Mika’s
Editable example.<o:p></o:p>
<o:p> </o:p>
Hth…<o:p></o:p>
<o:p> </o:p>
Michael<o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
---------<o:p></o:p>
On your Form Page:<o:p></o:p>
<o:p> </o:p>
The jQuery:<o:p></o:p>
$(document).ready(function() {<o:p></o:p>
 $(".theclass").editable("http://www.example.com/save.cfm",
{<o:p></o:p>
 type
: 'textarea',<o:p></o:p>
 submit : 'OK'<o:p></o:p>
 });<o:p></o:p>
});<o:p></o:p>
<o:p> </o:p>
The html:<o:p></o:p>
#get_houses.address# <o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
---------<o:p></o:p>
On your save.cfm:<o:p></o:p>
<o:p> </o:p>
<cfset type = left(FORM.id,2)> <o:p></o:p>
<cfset unique_id = removeChars(FORM.id,1,2)><o:p></o:p>
<cfset value = trim(FORM.value)><o:p></o:p>
<o:p> </o:p>
<cfquery datasource="my_database"><o:p></o:p>
 UPDATE homes_table<o:p></o:p>
 SET homes_table.address
= <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#value#"><o:p></o:p>
 WHERE homes_table.unique_id
= <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#unique_id#"><o:p></o:p>
 </cfquery><o:p></o:p>
</cfif><o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
> -----Original Message-----
> From: discuss-bounces@jquery.com
[mailto:discuss-bounces@jquery.com] On
> Behalf Of Mika Tuupola
> Sent: Friday, March 09, 2007 12:55 AM
> To: <st1:PersonName w:st="on">jQuery Discussion.</st1:PersonName>
> Subject: Re: [jQuery] How do I hook up the "Editable"
plug-in to a MySQL
> DB?
> 
> 
> On 9 Mar 2007, at 02:44, Rick Faircloth wrote:
> 
> > I don’t see how to hook the “Editable”
plug-in to *any* datasource
> > right now.
> >
> You mean you want to save the text you edit to the database? For
> jEditable first and only mandatory parameter is the URL where
edited
> content is POST:ed to. For example:
> 
> $(document).ready(function() {
> $(".editable").editable("http://www.example.com/save.php",
{
> type
: 'textarea',
> submit : 'OK'
> });
> });
> 
> With whis example when you edit stuff and click ok stuff gets
POST:ed
> to http://www.example.com/save.php. This script should then save
> content to database. You can check examples at:
> 
> http://www.appelsiini.net/~tuupola/javascript/jEditable/
> 
> or browse example source code at:
> 
> http://svn.appelsiini.net/viewvc/jQuery_jEditable/trunk/examples/
> 
> JavaScript itself does not connect to database. You need to use
some
> serverside language such as PHP, Ruby or Perl for that.
> 
> 
> --
> Mika
Tuupola
http://www.appelsiini.net/~tuupola/
> 
> 
> 
> 
> _______________________________________________
> jQuery mailing list
> discuss@jquery.com
> http://jquery.com/discuss/
</div>
</body>
</html>
_______________________________________________
jQuery mailing list
discuss@jquery.com
http://jquery.com/discuss/

Topic Participants
cf_mecarluen

[jQuery] How do I hook up the "Editable" plug-in to a MySQL DB?

[jQuery] How do I hook up the "Editable" plug-in to a MySQL DB?

Topic Participants

cf_mecarluen