Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Has nothing to do with my computer. Our server security blocked it.Mmmm... maybe switch to a real computer... MacBook for instance
Yup, works fine now.Ok I removed the php stuff in the name, it should work now for a PC to understand it
Please Log in to join the conversation.
$sql = 'INSERT INTO #__enmasse_sales_person(name,user_name,address,phone,email,zip_code,city,country,published,created_at,updated_at)
VALUE(
"' . $this->_cmsUser->name . '",
"' . $this->_cmsUser->username . '",
"' . $this->_comprofilerUser->address . '",
"' . $this->_comprofilerUser->phone . '",
"' . $this->_cmsUser->email . '",
"' . $this->_comprofilerUser->zipcode . '",
"' . $this->_comprofilerUser->city . '",
"' . $this->_comprofilerUser->country . '",
"1",
"' . date("Y-m-d H:i:s") . '",
"' . date("Y-m-d H:i:s") . '"
)
';
//echo $sql; die;
$oDB->setQuery($sql);
$oDB->query();
$salesId = $oDB->insertid();
'" . date("Y-m-d H:i:s") . "',
'" . date("Y-m-d H:i:s") . "'
)
//Setup Branch for Merchant
$arrBranches = array();
$arrBranches['branch1']['branchname'] = 'branch1';
$arrBranches['branch1']['name'] = $this->_cmsUser->name;
$arrBranches['branch1']['description'] = '';
$arrBranches['branch1']['google_map_width'] = '200';
$arrBranches['branch1']['google_map_height'] = '200';
$arrBranches['branch1']['address'] = $this->_comprofilerUser->address;
$arrBranches['branch1']['telephone'] = $this->_comprofilerUser->phone;
$arrBranches['branch1']['fax'] = $this->_comprofilerUser->fax;
$arrBranches['branch1']['google_map_lat'] = '';
$arrBranches['branch1']['google_map_long'] = '';
$arrBranches['branch1']['google_map_zoom'] = '';
$jsonBranches = json_encode($arrBranches);
//echo '<pre>'; print_r($jsonBranches); echo '</pre>';
$sqlMerchant = "INSERT INTO #__enmasse_merchant_branch(name,user_name,sales_person_id,branches,zip_code,city,country,published,created_at,updated_at)
VALUE(
'" . $this->_cmsUser->name . "',
'" . $this->_cmsUser->username . "',
'" . $salesId . "',
'" . $jsonBranches . "',
'" . $this->_comprofilerUser->zipcode . "',
'" . $this->_comprofilerUser->city . "',
'" . $this->_comprofilerUser->country . "',
'1',
";
//echo $sqlMerchant; die;
$oDB->setQuery($sqlMerchant);
$oDB->query();
Please Log in to join the conversation.
$oDB = mysql_connect( 'mysql_server', 'mysql_user', 'mysql_password' );
mysql_select_db( 'mysql_database', $oDB );
$sql = 'INSERT INTO #__enmasse_sales_person(name,user_name,address,phone,email,zip_code,city,country,published,created_at,updated_at)
VALUE(
"' . $_POST['name'] . '",
"' . $_POST['username'] . '",
"' . $_POST['cb_address'] . '",
"' . $_POST['cb_phone'] . '",
"' . $_POST['email'] . '",
"' . $_POST['cb_zipcode'] . '",
"' . $_POST['cb_city'] . '",
"' . $_POST['cb_country'] . '",
"1",
"' . date("Y-m-d H:i:s") . '",
"' . date("Y-m-d H:i:s") . '"
)
';
//echo $sql; die;
mysql_query($sql,$oDB);
$salesId = mysql_insert_id();
'" . date("Y-m-d H:i:s") . "',
'" . date("Y-m-d H:i:s") . "'
)
//Setup Branch for Merchant
$arrBranches = array();
$arrBranches['branch1']['branchname'] = 'branch1';
$arrBranches['branch1']['name'] = $_POST['name'];
$arrBranches['branch1']['description'] = '';
$arrBranches['branch1']['google_map_width'] = '200';
$arrBranches['branch1']['google_map_height'] = '200';
$arrBranches['branch1']['address'] = $_POST['cb_address'];
$arrBranches['branch1']['telephone'] = $_POST['cb_phone'];
$arrBranches['branch1']['fax'] = $_POST['cb_fax'];
$arrBranches['branch1']['google_map_lat'] = '';
$arrBranches['branch1']['google_map_long'] = '';
$arrBranches['branch1']['google_map_zoom'] = '';
$jsonBranches = json_encode($arrBranches);
//echo '<pre>'; print_r($jsonBranches); echo '</pre>';
$sqlMerchant = "INSERT INTO #__enmasse_merchant_branch(name,user_name,sales_person_id,branches,zip_code,city,country,published,created_at,updated_at)
VALUE(
'" . $_POST['name'] . "',
'" . $_POST['username'] . "',
'" . $salesId . "',
'" . $jsonBranches . "',
'" . $_POST['cb_zipcode'] . "',
'" . $_POST['cb_city'] . "',
'" . $_POST['cb_country'] . "',
'1',
";
//echo $sqlMerchant; die;
mysql_query($sqlMerchant,$oDB);
mysql_close($oDB);
Please Log in to join the conversation.