I have a php form use and a custom openerp module for storing student details of name and number..
How to communicate this php to openerp for exporting and importing student details from openerp to php form
Here I attached my php code and openerp module ..Pls help...
==================PHP================
index.php
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form action="insert.php" method="post">
Firstname: <input type="text" name="fname" /><br><br>
Phone: <input type="text" name="phone" /><br><br>
<input type="submit" />
</form>
</body>
</html>
insert.php
<?php
$con = mysql_connect("localhost","root","siroco");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("project", $con);
$sql="INSERT INTO info (name, phone)
VALUES
('$_POST[fname]','$_POST[lname]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
$res= mysql_query("SELECT * FROM info");
if(mysql_query($sql,$con))
{
echo "<table border='1'><tr><th>Name</th><th>Phone</th></tr>";
while($row = mysql_fetch_array($res))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['phone'] . "</td>";
echo "</tr>";
}
}
mysql_close($con)
?>
==============OPENERP===================
__init__.py
import web_service_info
__openerp__.py
{
"name" : "Web service module",
"version" : "1.0",
"author" : "ME ",
"category" : "Generic Modules for Web service connector",
"description": """
Module For Managing Student Name and roll number export and import:
""",
"depends" : ['base'],
"init_xml" : [],
'images': [],
"update_xml" : [
'web_service_view.xml'
],
'images': [],
"installable": True,
"auto_install":False
}
webservice.py
from osv import osv,fields
class student_info(osv.osv):
_name='student.info'
_columns={
'name':fields.char('name',size=15),
'phone_number':fields.char('Phonenumber',size=10),
}
def import_student(self,cr,uid,ids,context=None):
print "######################context#######",context
return "Hi"
def export_student(self,cr,uid,ids,context=None):
print "#########3uid#######",ids
return "Hi"
student_info()
.xml======
<?xml version="1.0" encoding="UTF-8"?>
<openerp>
<data>
<record id="user_info_tree_view" model="ir.ui.view">
<field name="name">user.info.tree.view</field>
<field name="model">student.info</field>
<field name="type">tree</field>
<field name="arch" type="xml">
<tree string="user information">
<field name="name"/>
<field name="phone_number"/>
</tree>
</field>
</record>
<record id="project_info_form_view" model="ir.ui.view">
<field name="name">project.info.form.view</field>
<field name="model">student.info</field>
<field name="type">form</field>
<field name="arch" type="xml">
<form string="Project information" version="7.0" >
<header>
<button name="import_student" string="Import Student"
class="oe_highlight" type="object"/>
<button name="export_student" string="Export Student"
class="oe_highlight" type="object"/>
</header>
<sheet>
<group>
<field name="name"/>
<field name="phone_number"/></group>
</sheet>
</form>
</field>
</record>
<record id="hr_info_action" model="ir.actions.act_window">
<field name="name">HR Details</field>
<field name="res_model">student.info</field>
<field name="view_type">form</field>
<field name="view_mode">tree,form</field>
</record>
<menuitem id="user_module_menu" name="Student Info"/>
<menuitem id="user_module_menu1" parent="user_module_menu" name="Student Information"/>
<menuitem id="user_module_menu123" action="hr_info_action" parent="user_module_menu1" name="Student Details"/>
</data>
</openerp>
How to export and import data from openerp to php form ,php ->openerp
@@ HOw to import data from openerp to php with xmlrpc(php->openerp,openerp->PHP)
