Form Connector & Dataprocessor for INSERT in MySQL

Suite and Optimus Suite 5
#1

I am trying to save a Form (Initiated from XML) with PHP Data Connector for an INSERT in MySQL.
Using Data Processor when form is saved fields are filled with variable name instead of actual form input value.

Can you help ?

<?php 
  require_once("../plugins/dhtmlx_connector_php/form_connector.php");
  $res = mysql_connect("localhost","root","root");
  mysql_select_db("mydb");
  $conn = new FormConnector($res,"MySQL");
  $conn->sql->query("INSERT INTO student_record (name_student) VALUES('name_student')");
  $id = $connector->sql->get_new_id();
?>
#2

Please check the next example, you need not write code manually, just define a list of fields which need to be saved

docs.dhtmlx.com/connector__php__ … usage.html

If you still want to define a full sql command, the syntax will be

 $conn->sql->query("INSERT INTO student_record (name_student) VALUES('{name_student}')");

docs.dhtmlx.com/connector__php__ … eries.html