details from "database join" to "text fields"

Here is the complete response:

PHP: 
<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: CS">
<?xml version="1.0" encoding="windows-1250"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
               <script language="JavaScript" src="http://succzsintranet01.mgt.etn.com/intranet/includes/js/joomla.javascript.js" type="text/javascript"></script>
               <title>Eaton Elektrotechnika s.r.o.</title>
<meta name="description" content="Intranet spolecnosti Eaton Elektrotechnika s.r.o." />
<meta name="keywords" content="Eaton Elektrotechnika s.r.o. Intranet CZ" />
<meta name="Generator" content="Joomla! - Copyright (C) 2005 - 2006 Open Source Matters. All rights reserved." />
<meta name="robots" content="index, follow" />
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/mambots/system/jceembed/embed.js"></script>
<link rel="stylesheet" type="text/css" media="all" href="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/jscalendar/calendar-system.css" title="green" />
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/jscalendar/calendar.js"></script>
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/jscalendar/lang/calendar-en.js"></script>
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/jscalendar/fabrik_calendar.js"></script>
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/mootools111.js"></script>
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/mootools-ext.js"></script>
<script type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/libs/slimbox.js"></script>
<link rel="stylesheet" type="text/css" href="http://succzsintranet01.mgt.etn.com/intranet/components/com_fabrik/css/slimbox.css" media="screen" />
        <link rel="shortcut icon" href="http://succzsintranet01.mgt.etn.com/intranet/images/favicon.ico" />
        <meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
<link href="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/css/template_css.css" rel="stylesheet" type="text/css"/>
<link rel="stylesheet" href="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/css/blue.css" type="text/css" />
<link href="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/css/alarge.css" rel="alternate stylesheet" type="text/css" media="screen" title="alarge"/>
<link href="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/css/amedium.css" rel="alternate stylesheet" type="text/css" media="screen" title="amedium"/>
<link href="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/css/asmall.css" rel="alternate stylesheet" type="text/css" media="screen" title="asmall"/>
<script src="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/js/styleswitcher.js" type="text/javascript"></script>
<!--[if lte IE 6]>
<style type="text/css"> 
a#sitename1, a.btnicon{
        behavior: url("templates/eaton/js/iepngfix.htc");
}
</style> 
<![endif]-->
</head>
 
<body>
<div id="wrapper" class="width_fluid">
        <div id="heading">
           <h1><a href="index.php" title="back to Homepage" id="sitename1">http://succzsintranet01.mgt.etn.com/intranet</a></h1>
           <div id="buttons"><a href="#" id="alarge" class="btnicon" title="XLarge" onclick="setActiveStyleSheet('alarge'); return false;">XLarge</a><a href="#" id="amedium" class="btnicon" title="Large" onclick="setActiveStyleSheet('amedium'); return false;">Large</a><a href="#" id="asmall" class="btnicon" title="Normal" onclick="setActiveStyleSheet('asmall'); return false;">Normal</a></div>
        </div>
        <div id="header"><div class="bgleft"><div class="bgright"><div class="bgbl">
 
               <div id="user3"><ul id="mainlevel-nav"><li><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_frontpage&amp;Itemid=1" class="mainlevel-nav" >Home</a></li><li><a href="http://succzsintranet01.mgt.etn.com/pers/Aktualni_verze.xls" target="_blank" class="mainlevel-nav" >Telefonn? seznam</a></li><li><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_xmap&amp;Itemid=79" class="mainlevel-nav" >Mapa str?nek</a></li><li><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_weblinks&amp;Itemid=89" class="mainlevel-nav" >Odkazy</a></li><li><a href="http://connect.eaton.com" target="_blank" class="mainlevel-nav" >Eaton JOE</a></li></ul></div><!--user3-->
 
        </div></div></div></div><!--header-->
 
        <div id="container"><div class="bgright"><div class="bg">
 
          <div id="user4"><div class="bgright4"><div class="bg4">
 
<form action="index.php?option=com_search" method="get">
        <div class="search">
               <input name="searchword" id="mod_search_searchword" maxlength="20" alt="search" class="inputbox" type="text" size="20" value="hledat..."  onblur="if(this.value=='') this.value='hledat...';" onfocus="if(this.value=='hledat...') this.value='';" />     </div>
 
        <input type="hidden" name="option" value="com_search" />
        <input type="hidden" name="Itemid" value="" />        
</form>   </div></div></div><!--search-->
                  <div id="breadcrumbs">
               <img src="http://succzsintranet01.mgt.etn.com/intranet/templates/eaton/images/arrow.png" alt="arrow"/>   </div>
          <div id="content">
                <div class="middlewrap" id="middlewrapleftonly">
                   <div class="middle" id="middleleftonly"><div class="middlebg">
                        <div id="component">                 <script language="javascript" type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/includes/js/overlib_mini.js"></script>
                       <script language="javascript" type="text/javascript" src="http://succzsintranet01.mgt.etn.com/intranet/includes/js/overlib_hideform_mini.js"></script>
                       <div id="overDiv" style="position:absolute; visibility:hidden; z-index:10000;"></div>
                       Sorry this form is unpublished</div>
                  </div></div>
               </div>
 
               <div class="leftcol" id="leftleftonly"><div class="bgtop">
                                      <div class="moduletable">
                                                     <h3>
                                      Hlavn? menu                           </h3>
 
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_frontpage&amp;Itemid=1" class="mainlevel" >Tituln? strana</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_content&amp;task=view&amp;id=27&amp;Itemid=81" class="mainlevel" >Administrativa</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_content&amp;task=section&amp;id=1&amp;Itemid=2" class="mainlevel" >Arch?v ?l?nk?</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_rsgallery2&amp;Itemid=27" class="mainlevel" >Fotogalerie</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_content&amp;task=view&amp;id=25&amp;Itemid=71" class="mainlevel" >Marketing (IVAN)</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_content&amp;task=view&amp;id=99&amp;Itemid=140" class="mainlevel" >Objedn?n? dopravy</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_events&amp;Itemid=99" class="mainlevel" >Pl?n aktivit a ?kolen?</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_jambook&amp;Itemid=145" class="mainlevel" >PM Portal</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_attend_events&amp;Itemid=132" class="mainlevel" >Vstupenky do divadla</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_wrapper&amp;Itemid=106" class="mainlevel" >Zaseda?ky</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_content&amp;task=section&amp;id=5&amp;Itemid=134" class="mainlevel" >Zv?hodn?n? nab?dky</a></td></tr>
</table>               </div>
                               <div class="moduletable">
                                                     <h3>
                                      P?ihl?en?                           </h3>
                                      <form action="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=logout" method="post" name="logout"> 
        P?ihl?en Havlik, Marcel      <br />
 
        <div align="center">
               <input type="submit" name="Submit" class="button" value="Odhl?en?" />
        </div>
 
        <input type="hidden" name="option" value="logout" />
        <input type="hidden" name="op2" value="logout" />
        <input type="hidden" name="lang" value="czech1250" />
        <input type="hidden" name="return" value="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_fabrik&amp;format=raw&amp;controller=plugin&amp;c=plugin&amp;task=userAjax" />
        <input type="hidden" name="message" value="0" />
        </form>
                       </div>
                               <div class="moduletable">
                                                      <h3>
                                      U?ivatelsk? menu                             </h3>
 
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_content&amp;task=new&amp;sectionid=1&amp;Itemid=0" class="mainlevel" >Napsat ?l?nek</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_user&amp;task=CheckIn&amp;Itemid=15" class="mainlevel" >Odemknout zamknut?</a></td></tr>
<tr align="left"><td><a href="http://succzsintranet01.mgt.etn.com/intranet/index.php?option=com_login&amp;Itemid=16" class="mainlevel" >Odhl?sit</a></td></tr>
</table>               </div>
                               </div></div>
 
                       <div class="clear"></div>
          </div><!--content-->
                 <div id="footer">
 
          </div>
          <div id="reflection-l"><div id="reflection-r"><div id="reflection"></div></div></div>
        </div></div></div><!--container-->
</div><!--wrapper-->
 
</body>
</html><!-- 1270187775 -->

missing ) in parenthetical
(<?xml version="1.0" encoding="windows.../xhtml1/DTD/xhtml1-transitional.dtd">\nmootools111.js (line 263)



In the HTML window is shown complete web page and fabrik form is replaced with "Sorry this form is unpublished"
 
I think the issue is that you are calling index.php where as in Joomla1.0.x you need to call index2.php and that the format variable was not used in Joomla 1.0.x - off the top of my head I think it was no_html=1

Code: 
var url = 'index2.php?option=com_fabrik&no_html=1&controller=plugin&c=plugin&task=userAjax';
 
Hi Rob, thanks for your reply. I have changed the javascript but the problem persist. Now I get in Firebug -> Response message "Sorry this form is unpublished" without web page - see attachment and sorry for the czech language :)

Any other ideas?

Best regards
Marcel
 

Attachments

  • doprava_error2.png
    doprava_error2.png
    29.2 KB · Views: 313
Marcel,

Not being rude, but did you actually read the comments in the user_ajax_example.php, where it shows you format of the URL you need?

PHP: 
 * This is an example file. To use userAjax, copy this file to user_ajax.php,
* and insert your function into the userAjax class, as per the example
* userExists() function. To call your AJAX method, use a URL of this format from
* your custom JS code:
*
* index2.php?option=com_fabrik&no_html=1&task=userPluginAjax&method=userExists&username=" + myUsername;

I don't see anything in there about controller=plugin&c=plugin&task=userAjax

-- hugh
 
Hugh,
I?m sorry but I have found this code (controller=plugin&c=plugin&task=userAjax) under this forum. I have changed both scripts and currently I get "syntax error" "()" on line 263 in mootools111.js. Response is empty.

Do you have any ideas what is wrong?

Javascript
PHP: 
var url = 'index2.php?option=com_fabrik&no_html=1&task=userPluginAjax&method=companyAddress';
var id = this.getValue();
var update1 = $('jos_fabrik_formdata_1___to_street');
var update2 = $('jos_fabrik_formdata_1___to_city');
new Ajax(url, {
  data:{
    method:'companyAddress',
    'id':id
  },
  onComplete:function(r){
  var arr = Json.evaluate(r);
  var street = arr[0];
  var city = arr[1];
  update1.set('value', street);
  update2.set('value', city);
  }
}).request();

ajax_user.php
PHP: 
class userAjax {
function companyAddress() {
$db =& JFactory::getDBO();
$myCompanyID = JRequest::getVar('id');
$query = "SELECT street, city from doprava_kontakty WHERE id = $myCompanyID";
$db->setQuery($query);
$results = $db->loadObjectList();
$arr = array();
foreach($results as $result) {
$arr[0]= $result->street;
$arr[1]= $result->city;
}
echo Json_toString($arr);
}

Thanks for support
Marcel
 
Firebug Response is blank

Im not sure what I did wrong, but my firebug response is blank, when I select a value. Note sure why.

user_ajax.php
defined( '_JEXEC' ) or die( 'Restricted access' );

class userAjax {
function getPrice() {
$db =& JFactory::getDBO();
$retStr = '';
$myPrice = JRequest::getVar('fabrik_internal_id');
$query = "SELECT stock_rider_price from stock_rider_selection WHERE fabrik_internal_id = $myPrice LIMIT 1";
$db->setQuery($query);
$results = $db->loadResult();
echo $results;
}
}
Click to expand...
js
var url = 'index.php?option=com_fabrik&format=raw&controller=plugin&c=plugin&task=userAjax';

var fabrik_internal_id = this.getValue();

var update =
$('customer_orders___listing_stock_rider_price4');
new Ajax(url, {
data:{method:'getPrice',
'fabrik_internal_id':fabrik_internal_id},
onComplete:function(r){
update.setHTML(r);
}}
).request();
Click to expand...
This is for the last drop down on the page
URL: http://southbay.postsetters.com/form/
 
Hi

I get a 404 error on that url
However, you are still using URLs that pertain to Fabrik 2 / Joomla 1.5 where as your site is using Joomla 1.0.x / Fabrik 1 - please read the instructions in components/com_fabrik/user_ajax_example.php

To call your AJAX method, use a URL of this format from
* your custom JS code:
*
* index2.php?option=com_fabrik&no_html=1&task=userPluginAjax&method=userExists&username=" + myUsername;
*
Click to expand...
 
You must log in or register to reply here.

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    Total: 162 (members: 2, guests: 160)
    Back
    Top