Guriddo » Topic: jqForm connected to SQL Database

jqForm connected to SQL Database

Guriddo
jqForm SQL
jqForm connected to SQL Database

Tagged: jqForm SQL

This topic has 6 replies, 3 voices, and was last updated 11 years, 2 months ago by tony.

Creator

Topic
January 15, 2015 at 4:47 pm #115317

trevrobwhite
Participant

Hi Guriddo,
I’m a subscriber of the Studio software and recently started using the jqForm plugin.

All is going well apart from two issues for which I’m hoping you can help.
1. I’m connect to a MySQL database, which I’ve verified with the form builder is working and I can see the database record as been selected because the data is is in hidden DIV, but I can’t get the existing data to display in the form fields, why would this be?

2. I would like the end user to be able to choose an existing record from a select box, then the correct records load into the form, where they can update then, do you have a demo where I could check the code out how to do this?

Many thanks.
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies

January 16, 2015 at 10:15 am #115339

tony

Keymaster

Hello,

Can you please post (or send us) the code you have a problem with loading the record.
We do not have a particular demo, for your second case, but you can bind a change event in the select – then load the record with your own ajax function populating it on the form and then let the form to do the job.

If you send us a simple test case we will try to help you.

Kind Regards,

This reply was modified 11 years, 2 months ago by tony.
This reply was modified 11 years, 2 months ago by tony.

January 16, 2015 at 11:35 am #115347

trevrobwhite

Participant

Below is the PHP code I used, I can see that the query is being made because Firebug picks it up as POST command as soon as the page is loaded:

Here is the post (sorry can’t attached as a screen capture), sorry had to block the data:

Interestingly if I use the visual form builder I get the same issue.

<script src="includes/JQuery/jquery-1.10.2.min.js" type="text/javascript"></script><script src="includes/JQuery/jquery-ui-1.10.3.custom.min.js" type="text/javascript"></script><script src="includes/JQuery/jquery.validate.min.js" type="text/javascript"></script><script src="includes/JQuery/jquery.additional-methods.js" type="text/javascript"></script>{"id_satellite":"7","friendly_name":"XXXX","country":"XXXX","region":"XX","type":"XXXX","package":"XXXX","install_date":"2013-12-19","SPID":"XXXX","active":"1","beta":"1","current_version":"XXX","last_update":null,"comments":null}

// jQuery
echo "<script type='text/javascript' src='includes/JQuery/jquery-1.10.2.min.js'></script>" . PHP_EOL;
echo "<script type='text/javascript' src='includes/JQuery/jquery-ui-1.10.3.custom.min.js'></script>" . PHP_EOL;
echo "<script type='text/javascript' src='includes/JQuery/jquery.validate.min.js'></script>" . PHP_EOL;
echo "<script type='text/javascript' src='includes/JQuery/jquery.additional-methods.js'></script>" . PHP_EOL;
echo "<link type='text/css' href='includes/JQuery/jquery-ui-1.10.3.custom.min.css' rel='stylesheet' />" . PHP_EOL;

include_once 'includes/jqSuite/jqUtils.php';
include_once 'includes/jqSuite/jqForm.php';
include_once 'includes/jqSuite/jqGridPdo.php';

// Create Form
$form = new jqForm('satsetup', array ('method'=>'post', id => 'satsatup'));

$dbpdo = new PDO('mysql:host=localhost;dbname=servers;charset=utf8', $arrMYSQL['USER'], $arrMYSQL['PASSWORD']);
$form->setConnection($dbpdo);
$form->setUrl($_SERVER['PHP_SELF']);

$form->setFormHeader("Extended Server Details", "ui-icon-pencil");

$item = jqGridUtils::GetParam('id_satellite', '7');
$jqformparams = array ($item);

$form->SelectCommand = "SELECT id_satellite, friendly_name, country, region, type, package, install_date, SPID, active, beta, current_version, last_update, comments FROM extended_setup where id_satellite = ?";
$form->table = "ExtendedSetup";
$form->setPrimaryKeys("id_satellite, type, SPID");
//$form->setPrimaryKeys("id_satellite");
$form->setColumnLayout('twocolumn');
$form->setTableStyles('width:50%;','','');
$form->addElement("id_satellite", 'text', array('label' => 'Satellite ID', 'id' => 'form_id_satellite'));
$form->addElement("friendly_name", 'text', array('label' => 'Name', 'id'=>'form_friendly_name'));
// TODO Add other items
$elem_8[]=$form->createElement('newSubmit','submit', array('value' => 'Submit'));
$form->addGroup("newGroup",$elem_8, array('style' => 'text-align:right;', 'id' => 'newForm_newGroup'));

$form->setAjaxOptions( array('dataType'=>null,
'resetForm' =>null,
'clearForm' => null,
'iframe' => false,
'forceSync' =>false) );
//$form->demo = true;
echo $form->renderForm($jqformparams);

// jQuery

echo "<script type='text/javascript' src='includes/JQuery/jquery-1.10.2.min.js'></script>" . PHP_EOL;

echo "<script type='text/javascript' src='includes/JQuery/jquery-ui-1.10.3.custom.min.js'></script>" . PHP_EOL;

echo "<script type='text/javascript' src='includes/JQuery/jquery.validate.min.js'></script>" . PHP_EOL;

echo "<script type='text/javascript' src='includes/JQuery/jquery.additional-methods.js'></script>" . PHP_EOL;

echo "<link type='text/css' href='includes/JQuery/jquery-ui-1.10.3.custom.min.css' rel='stylesheet' />" . PHP_EOL;

include_once 'includes/jqSuite/jqUtils.php';

include_once 'includes/jqSuite/jqForm.php';

include_once 'includes/jqSuite/jqGridPdo.php';

// Create Form

$form = new jqForm('satsetup', array ('method'=>'post', id => 'satsatup'));

$dbpdo = new PDO('mysql:host=localhost;dbname=servers;charset=utf8', $arrMYSQL['USER'], $arrMYSQL['PASSWORD']);

$form->setConnection($dbpdo);

$form->setUrl($_SERVER['PHP_SELF']);

$form->setFormHeader("Extended Server Details", "ui-icon-pencil");

$item = jqGridUtils::GetParam('id_satellite', '7');

$jqformparams = array ($item);

$form->SelectCommand = "SELECT id_satellite, friendly_name, country, region, type, package, install_date, SPID, active, beta, current_version, last_update, comments FROM extended_setup where id_satellite = ?";

$form->table = "ExtendedSetup";

$form->setPrimaryKeys("id_satellite, type, SPID");

//$form->setPrimaryKeys("id_satellite");

$form->setColumnLayout('twocolumn');

$form->setTableStyles('width:50%;','','');

$form->addElement("id_satellite", 'text', array('label' => 'Satellite ID', 'id' => 'form_id_satellite'));

$form->addElement("friendly_name", 'text', array('label' => 'Name', 'id'=>'form_friendly_name'));

// TODO Add other items

$elem_8[]=$form->createElement('newSubmit','submit', array('value' => 'Submit'));

$form->addGroup("newGroup",$elem_8, array('style' => 'text-align:right;', 'id' => 'newForm_newGroup'));

$form->setAjaxOptions( array('dataType'=>null,

'resetForm' =>null,

'clearForm' => null,

'iframe' => false,

'forceSync' =>false) );

//$form->demo = true;

echo $form->renderForm($jqformparams);

For the binding part are you able to give me a bit of an example or point me to some documentation so I know what function to call

This reply was modified 11 years, 2 months ago by trevrobwhite. Reason: Bad system formatting
This reply was modified 11 years, 2 months ago by trevrobwhite.
This reply was modified 11 years, 2 months ago by trevrobwhite.
This reply was modified 11 years, 2 months ago by admin.
This reply was modified 11 years, 2 months ago by tony. Reason: fixing code publishing
This reply was modified 11 years, 2 months ago by tony.
This reply was modified 11 years, 2 months ago by tony.
This reply was modified 11 years, 2 months ago by tony.
This reply was modified 11 years, 2 months ago by tony.
This reply was modified 11 years, 2 months ago by tony.