$coulmns_name = array('shop_name', 'website_url', 'address', 'city', 'pincode', 'email', 'phone_number'); $shop_data_attributes = array(); $columns = ''; $values = ''; // Query builder & attributes filter here. foreach ($shop_data as $key => $value) { if (in_array($key, $coulmns_name)) { $columns = $columns . $key . ','; $values = $values . "'" . mysql_real_escape_string($value) . "',"; } else { // To shop attributes fields $shop_data_attributes[$key] = $value; } } // To convert Local time to GMT. $date = convertLocalTimezoneToGMT(date('Y-m-d H:i:s'), ini_get('date.timezone')); $columns = $columns . 'created_at' . ','; $values = $values . "'" . $date . "',"; $query = "INSERT INTO pos_shop_entity (" . trim($columns, ',') . ") VALUES(" . trim($values, ',') . ")"; $result = mysql_query($query); if ($result) { $q = sprintf("SELECT entity_id FROM pos_shop_entity WHERE email='%s' AND is_active= 1 LIMIT 1", mysql_real_escape_string($shop_data->email)); $result = mysql_query($q); if (!$result) { die(mysql_error()); } else { $entity_id = 0; // Insert and get inserted shop record id. $num = mysql_num_rows($result); if ($num) { while ($row = mysql_fetch_assoc($result)) {
function _insert_user($data) { $sql = "SELECT * FROM pos_user_entity WHERE email = '{$data['email']}'"; $result = mysql_query($sql); if (!$result) { die('Invalid query: ' . mysql_error()); } else { if (!mysql_num_rows($result)) { $username = $data['username']; $email = $data['email']; $password = MD5($data['password']); $cpassword = MD5($data['cpassword']); $firstname = $data['firstname']; $lastname = $data['lastname']; $date = convertLocalTimezoneToGMT(date('Y-m-d H:i:s'), ini_get('date.timezone')); $role_id = 6; //Store Admin// (int)$data['role_id']; $sql = "INSERT INTO pos_user_entity (role_id,firstname,lastname,username,email,password,cpassword,is_adminpanel,created_at,logged_at) VALUES ({$role_id},'{$firstname}','{$lastname}','{$username}','{$email}','{$password}','{$cpassword}',1,'{$date}','{$date}')"; $result = mysql_query($sql); if ($result) { $sql = "SELECT entity_id FROM pos_user_entity WHERE email = '{$email}' LIMIT 1"; $result = mysql_query($sql); $entity_id = 0; if (mysql_num_rows($result)) { while ($row = mysql_fetch_assoc($result)) { $entity_id = $row['entity_id']; } } // To insert into pos_user_validate table , will use to validate user by SUPAER ADMIN. $sql = "INSERT INTO pos_user_validate (user_id,created_at) VALUES ({$entity_id},'{$date}')"; $result = mysql_query($sql); $status = array('user_id' => $entity_id, 'statusText' => 'Sucessfully Submitted', 'statusCode' => 200); echo json_encode($status); } else { // Error $status = array('statusText' => 'Invalid query: ' . mysql_error(), 'statusCode' => 417); echo json_encode($status); } } else { // all ready exist $status = array('statusText' => 'Conflict Found', 'statusCode' => 409); echo json_encode($status); } } }