Blogs

ByArti Chaudhary

How much does it cost to make a game like PUBG/Call of Duty in 2020

According to a survey PUBG has officially made nearly half a billion dollars in the first six months of the release, mobile game development is a growing market & a new trend to earn massive money.  In 2015, global mobile app revenue amounted to 69.7 billion USD. Looking at the way this industry is booming, it is expected that by 2020 revenue will amount to 188.9 billion USD!

In today scenario people are extremely busy & spend lots of time on their smart phone. Now every thing is connected to the Internet. You can pay your bills, shopping, social media games & what not.  

Mobile games are a man’s “new” friend Smartphone games are the perfect cure for your dizziness. Mobile games, especially PUBG and Call of Duty, are nowadays most popular due to its addictive nature and class-apart features.

Nowadays, gamers are always on the lookout for something exciting and interesting. PUBG has come off as one of the top-rated games that are ruling the gaming world with amazing graphics, multilevel challenges, and some fun-exciting features.

It has developed such a buzz over the web that in the coming future, it does not seem to be shutting down quickly.

Platform : This is the first step before making any game. who is your target audience which platform is the best & for what kind of customers you are looking for like Android, Apple or IOS .

Developing an app for Apple users are more costly than android. 

Concept & Storylines : The concept of the game is the basic & essential requirement to develop a game. What type of game is it? what are the features, and what will be the unique strategy that can make your game engaging? All these things can hold gamer attention. Gamers always seeks something new & challenging if they don’t feel engage then they can switch any time. So the game must have interesting multilevel challenges, in-app rewards, exciting challenges, and high-quality audio-video visuals. It will boost the player’s interest in the game and also the goodwill of the game.  

Graphic Design : A game developer knows about the importance of the graphics to making an exceptional game. Developing a game with realistic graphics and additional features in the design will make your game a treat for gamers. For this you need a excellent team who can help to convert your graphical imagination into reality. They must include 3D graphics, impressive designs that can easily attract the targeted customers.  

Cost to Develop the Mobile App

All the features that have been described above impact the cost of developing an app like PUBG. Developing games like PUBG requires intensive efforts in designing and planning. It took more than 1 years to develop PUBG game. You need to be patience & work intensive to get the best result. Everything should be according to the planning. The development of games depends on gameplay, designs, weapons, and other unique strategies. The games are generally developed by highly-skilled, experienced professionals that also include the development cost according to the graphics and features. 

Developing and creating games required intensive efforts in designing, planning that time ranges between 1 to 2 years or even more. While developing the app, make sure you sanction the budget for every aspect according to the needs and trends of the game. Estimating the exact cost of mobile application development is hard. It fluctuates depending on the many factors like features and functionality you choose.

How do we estimate the cost of app development  ?

Technology to build an app like PUBG/COD Mobile

Programming languages for backend – 

Node.js, Python, Java, PHP, Ruby on Rails. Unity and Unreal Engine have developed special tools to develop games!

Contact Us Now to get a fair idea about your dream app.

ByArti Chaudhary

How does it cost to make an app like Uber in 2020

Few years back who would have think that one day you will just tap your smartphone & your driver will pick you up. But now it is reality & making our daily life much easier. Uber is the taxi ordering app used by millions due its outstanding service for people, as well as job opportunities. For riders, The nearest car will pick you up in minutes. Giving drivers & car owners a fair chance to earn money. 

Uber is a Smartphone application which was created or developed to connect the passengers and the drivers, driving a vehicle for hire. With this application, the passengers choose the kind of car they are comfortable to ride, they also decide the exact place where they can be picked up and also gives the exact address where they want to be dropped.

The Uber’s driver app also requires the driver to register and create his profile before he starts driving. A location has been sent to the owner so that he can keep an eye on the driver for more transparency. Uber driver also have app access if they can’t go with the passenger for whatsoever reasons. 

So everything above you can get in your app if you are planning to launch your own app like Uber. You must be wondering what would be the cost of an App like Uber. 

Uber currently operates in 84 countries and over 800 cities providing a 24-hour-per-day on-demand connection between riders and drivers through the Android and iOS app. Both parties are aware of each other’s location and concerns over the car arrival time are no longer topical.

How does Uber work – 

Step 1 # Request : The customers requests according to his schedule. Those requests are received by drivers nearby.

Step 2 # Matching : The driver may either accept or reject the ride. If they reject it, the request is sent to another driver.

Step 3 # Ride : The customer tracks the taxi approach and knows the estimated time of arrival.

Step 4 # Payment : Customers can make cash or digital payment. 

Step 5 # Ratings : After getting the service a message sent to the customers to share his experience. It helps to enhance the services. 

3 Must have components like Uber app –

The customer App

The Driver App

The Admin Web Panel

Key Features of the Customer App – 

Registration : Firstly customer have to register himself on the app It can be done via email, phone number & Facebook for the confirmation. 

Taxi Booking : Customers can book taxi according to his preferences by entering location, car type & pickup location.

Driver Tracking : It is the feature for users to keep an eye on the driver’s location to see how far he has reached.

Payment : In an app like Uber, multiple payment methods can be done via cash or digital method. 

Push Notifications : It is one of the fundamental features of the app which keeps users informed even when they are not using the app. The features also keep users updated about the driver’s arrival time, car details and other important information.

Messaging : If needed customers can directly message to the driver through the application. 

Key features of the Driver App –

Status : This features allows admin to check the availability of the drivers on time. 

Trip Alert : It provides drivers the ability to see a request by user for accepting or denying the same. It also let them know about the user’s location.

Pop-up messages : This feature is used for getting alerts from the admin side regarding taxi booking information, trip changes, and completion.

Route Optimization and Navigation : It suggests the best route to drivers using Google Maps to avoid traffic so that customer can be dropped on time.

Driver Delivery Reports : The feature provides information regarding trips and earnings on a daily or monthly basis.

Messaging : For calling or texting a user from the application.

Key features of the Admin app – 

Locations & fare management

Review driver’s & user’s activities

check ratings & reviews

Promotions & discount management

Integration with Google analytics 

Driver & user support

When you make an application like Uber, you create three apps. While every application development company has their own pricing models for making these applications, there is an uncertainty in the cost of building up an ‘Uber-like’ mobile application.

Technology to build an app like Uber

Programming languages for backend – 

Node.js, Python, Java, PHP, Ruby on Rails. Another crucial element to any Uber-clone app is GPS. OpenStreetMap/Google Map API for both iOS/Android can be used. Platform-specific tools in this regard for Android could be Google Maps and Google Location Services API. For iOS devices – MapKit or CoreLocation framework.

As Uber supports in-app payments via credit cards, Paypal, we can use – StripeBrainTreePaytmPayPal mobile SDK.

Technology stack for push notifications is pretty straightforward: Google Firebase for Android, and Apple Push or Google Firebase for iOS phones. For SMS notifications, we can use Twilio or Msg91 for India.

Contact us now to get idea to make your dream app.


ByArti Chaudhary

How much does it cost to make an app in 2020

In today’s scenario when every person is using mobile & aware about the online platform uses, it became so easy to connect with your client directly according to their needs & demand. Gone are the days when social media was the only platform to build brand equity now building custom mobile apps is the latest & accurate method to generate sales. 

As the global number of mobile phone users growing steadily, the number of app downloads is also projected to increase. According to a survey over 2 million apps are available for download on the Google Play store, while 1.83 million apps are available on the Apple App Store in 2020.

So we can see the opportunity clearly here, now the question arise how much does it cost to make an app ?

Well it all depend on clients requirement because there are so many factors which affect the cost For instance, the app can be developed by a private organisation or by a resourceful team or it can also be put together by a freelancer. This will make a huge difference to the app development cost.

But before you speak to anyone let us clear some important points which is meaningful to develop an app. 

Free apps, Paid apps & e-commerce?

You can also make an app free. they make money through various ways such as: advertising, sponsorship, and email marketing etc.

The paid apps make money directly by the no. of downloads. Moreover, it’s important to set a right price for the paid app.

eCommerce apps make money mostly by selling their own products and by getting commissions from the sellers.

There are two version of an app – 

  1. IOS Application : You may choose to go with the latest versions only, which can keep your development time and costs low. iOS apps generally cost less than that of Android apps and are quicker to build. Paid apps are more likely to be successful on this platform as the audience is more affluent. Apple has a strict guideline which ensures the quality of apps on the app store.

2.  Android Application :  Android has lower cost per download as compared to that of iOS.

     It has low maintenance cost as they are not required to be updated regularly like that of iOS.

     Guidelines for Android are more lenient which reduces the cost of app development. 

The cost to development an app also depend on the what type or category the application falls under. Let’s have a look at the different types of application. 

Web Application – Any application which can be operated through mobile are called web application. Many surveys show that 80% of smartphone users prefer mobile apps over websites. 

Native applicationIt is a type of app which is developed for a specific OS whether Android or iOS. These apps are complex in nature and provide rich user experience.

Hybrid applicationThis app is simpler in nature as it functions on a single programming language. However, unlike native apps it can work on both the platforms.

How do we estimate the cost of app development  ?

well we do a lot of research & set meetings to identify the needs & actual requirement of our client then we give some roughly estimation of the project. No one will tell you the exact price of an app as it depend on the features but here are our process for making an app development process. 

We process the initial requirements we have collected & perform basic business analysis, considering all your product specifics, to offer a solution that meets your expectations. 

Then we estimate the price of the app. When we go through all the details then we set a brief meeting to present our feedback, get clarifications. We also try to specify the scope of work for your project so we can prepare an optimal project offer.  

Once you approve the rough estimate, we proceed with a detailed estimate, for which we identify the requirements for each scope of work planned, make wireframes to show you what exactly your web, iOS, or Android app will look like, and prepare project-related documentation.

Finally, we negotiate an offer to find the best possible solution for your business.

We provide full-cycle development services for mobile and web apps. This means that an app’s price covers every service related to product development, including project management. 

Contact Us Now to get a fair idea about your dream app.

ByShubham Jain

New Features Of Opencart 3.1.0.0 Alpha

Opencart released opencart 3.1.0.0 Alpha on 27 July 2019 with some major changes

We are mentioning a new feature of opencart 3.1.0.0 Alpha version.

In admin Side changes

1- Opencart 3.1.0.0 added the product option in the catalog menu.

2- Cron Job option added in Opencart that is used for scheduling task to be run at a certain time.

3-All the radio button design change.

 

4- Product Image Section design change and edit, clear and delete option added.

 

5-  Summernote  Editor replace with CKEditor in textarea.

 

6- Change the datepicker area.

7- jQuery library version updated v2.1.1 to v3.3.1.

8- Bootstrap library version updated v3.3.5 to v4.0.0

In-Store Side changes

1- Success And Error  design Change

2- shopping cart page link create while clicking on add to cart button.

 

3- In URL  language tag is already append

ByShubham Jain

How to read and write Excel file in CakePHP 3.X

How to read and write Excel file in CakePHP 3.X

PHPExcel library was the best library available in PHP to read and write Excel files. Now a new library PHPSpreadsheet is here with latest updates and support. PHP Spreadsheet is written in pure PHP and allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc.

PHPSpreadsheet is very simple to use in any PHP application. We are showing steps how to use PHP Spreadsheet in your CakePHP 3.X application.

  1. Install composer if not installed on your system. Follow this link to install composer
  2. Install PHPSpreadsheet in your project. Ex. for CakePHP 3.X , go to vendor folder and run composer require phpoffice/phpspreadsheet
  3. After installation import the library in your PHP file where you want to perform the action. See below to import in CakePHP 3.X
  4. Now you can use the various features of PHPSpreadsheet library. To use this library in CakePHP 3.X, examples are given below with source code.

 

Step 1:- Download the spreadsheet library.

The easy way to download library, first go to vendor folder and open. press shift+right click and click on(Open Powershell window here).go to the link and see the code which we marked .just copy and paste into the spreadsheet.And the link is

https://phpspreadsheet.readthedocs.io/en/develop/

go to the link and install PhpSpreadsheet.

Composer install php spreadsheet

Composer install php spreadsheet

Step 2:- Check library is installed on your project.

After running the above command, the PHPSpreadsheet library installed with name PHPOffice as shown in image below –

 

Step 3:- Create an XLSX file by below code in CakePHP-

controller :-EmployeesController.php

<?php 
namespace App\Controller; 
use Cake\ORM\TableRegistry;
use App\Model\Table\User; // <—My model
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Helper;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
require ROOT.DS. ‘vendor’ .DS. ‘phpoffice/phpspreadsheet/src/Bootstrap.php’ ;
class EmployeesController extends AppController {
public function exportExcelfile(){
$spreadsheet = new Spreadsheet();
$helper = new Helper\Sample();
$helper ->log( ‘Create new Spreadsheet object’ );
$spreadsheet  = new Spreadsheet();
//Set document properties 
$helper ->log(‘Set document properties’);
$spreadsheet ->getProperties()
->setCreator(‘shubh ‘)
->setLastModifiedBy(‘Arjun’)
->setTitle(‘Example’)
->setSubject(‘Example’)
->setDescription(‘Example’)
->setKeywords(‘office PhpSpreadsheet php’)
->setCategory(‘Example’);
// Add some data 
$helper ->log(‘Add some data’);
$spreadsheet ->setActiveSheetIndex(0)
->setCellValue(‘A1’, ‘Hello’)
->setCellValue(‘B2’, ‘world!’)
->setCellValue(‘C1’, ‘Hello’)
->setCellValue(‘D2’, ‘world!’);
$helper ->log(‘Rename worksheet’);
$spreadsheet ->getActiveSheet()
->setTitle(‘Simple’);
$writer = new Xlsx($spreadsheet);
$writer ->save(WWW_ROOT . ‘/files/ example.xlsx’);
die;
}
}

Step 4:- Read an XLS file by below code in CakePHP-

controller :-EmployeesController.php

<?php 
namespace App\Controller;
use PhpOffice\PhpSpreadsheet\IOFactory;
use Cake\ORM\TableRegistry;
use App\Model\Table\User; // <—My model
use Cake\Datasource\ConnectionManager;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Helper;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
require ROOT.DS.’vendor‘ .DS. ‘phpoffice/phpspreadsheet/src/Bootstrap.php’;

class EmployeesController extends AppController {

public function importExcelfile (){
$helper = new Helper\Sample();
debug($helper);
$inputFileName = WWW_ROOT . ‘example1.xls‘;
$spreadsheet = IOFactory::load($inputFileName);
$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
var_dump($sheetData);
die(“here”);
}
}

 

Leave comments below if you face any difficulty in reading and writing Excel files in your PHP application.

 

ByShubham Jain

How to use AJAX using PHP and jQuery

Ajax

  • Ajax is an Asynchronous JavaScript and XML.
  • with the help of ajax is build the connection between the server and client.
  • This technology is used for quick and dynamic web pages.
  • Ajax is work without reloading the page.
  • Examples of applications using AJAX: Google Maps, Gmail, and Facebook tabs.

Step to ajax example:-

  • First, we download jquery jar file.
  • Create a client-side
  • Create a server-side page to process the request.

Ajax Example:-

To create ajax example, you need to use any server-side language e.g. Java, PHP etc. Here we are using PHP for generating the server-side code.

And client-side language is HTML, CSS and We are using ajax with jquery.

Example:-

  • First, we create an input

  <!DOCTYPE  html>

 <html lang=”en”>

<head> 
       <script> 
      function beforesubmit()
$.ajax({ 
     url: “table.php”,                                           // write url  here
type: “GET”,                                                  // url type is here like .(GET&POST)
data: “table= “+$(“#table”).val(),            // data type is here
success: function (response) {
 $(“#bb”). append(response);                    // output of ajax
                                                                          }
  });
 return false;                                                 // if error not submit the page
}
</script> 
 </head>
 <body>

<h1> Enter the number of which you want a table </h1>
 <form action=”” method=”Get”  id=”form”>
<input type=”text” placeholder=”number” id=”table” required=””>

<input type=”submit” value=”Submit” onclick=” return beforesubmit()”>
</form>
<div id=”bb”> </div>
<script src=”jquery.js”> </script>

</body></html>

 

  • on click=” beforesubmit()” executes the JavaScript function show Name every time a click is typed in the text box.
  • Create table.php page for server-side

 

 <?php $i = 1;
 $number = $_GET[‘table’];  // $number is a input value 
 for ($i ;$i<=10; $i++) {
 echo ($i*$number).” <br>”;  //print 10 times table value 
 }
 ?>

     Output

Final Page is 

ByShubham Jain

How do JOINs work in SQL? Three or more than three tables join In SQL

Join in SQL

A Join is used to combine row from two or more table .based on min one common column. there is various type of join.

      • Inner join
      • Left join
      • Right join
      • Full outer join
      • Self-join
  • Inner Join: – The most commonly used for the join is inner join .they also called Equijoin. Two tables combine with one condition (one row’s value match in both tables).

The syntax of an inner join:-

  [ Select tablename.columnname(s) from table1 Inner join table2 on table1.columnname =table2.columnname  ]

Ex: – we have two table first table names is a category and second is subcategory and the common row is category so let see how to use inner join in both tables.

(Category) 

 (subcategory)

                                                                                                                                                          

 

  [ select category.category id, category.category name ,subcategory.subcategory name FROM category INNER JOIN    subcategory ON category.category id =subcategory.category id  ]

 

(Output)

  • Left Join: – In the left join returns all record in the left table but only match record selected in the right table, unmatched record value null.

The syntax of a left join:-

  [ Select tablename.columnname(s) from table1 Left  join table2 on table1.columnname =table2.columnname  ]

 

Ex:- we have two table first table names is category and second is subcategory and the common row is category id so let see how to use Left join in both tables.

 

(category)

   (subcategory)

  [ select category.category id, category.category name ,subcategory.subcategory name FROM category Left JOIN    subcategory ON category.category id =subcategory.category id  ]

(Output)

 

 

 

 

 

  • Right, Join: – In the right join returns all record in right table but only match record selected in the left table, unmatched record value null.

The syntax of right join:-

  [ Select tablename.columnname(s) from table1 Right join table2 on table1.columnname =table2.columnname  ]

Ex: – we have two table first table names is a category and second is subcategory and the common row is category  so let see how to use Right join in both tables.

 

(category) 

  (subcategory)

                                                                                                            

  [ select category.category id, category.category name ,subcategory.subcategory name FROM category Right JOIN    subcategory ON category.category id =subcategory.category id  ]

(Output)

  • Full Outer Join: – this keyword returns all matching record in both tables .it put a null value on the place of the match not found. It can potentially return very large datasets.

The syntax of Full outer join:-

[  Select tablename.columnname(s) from table1 Full Outer join table2 on table1.columnname =table2.columnname  ]

 

  • Self Join: – Self Join is used for comparing itself.

The syntax of self-join:-

  [ Select tablename.columnname(s) from table1 Self join table2 on table1.columnname =table2.columnname  ]

Join in three tables

We have three table first table category second is subcategory and third is a product

The syntax of three table join:-

  [ Select tablename.columnname(s) from table1 Inner join table2 on table1.columnname =table2.columnname Inner join  table 3 on table2.columnname = table 3.column name  ]

 

Ex:-

(category)

(subcategory)

                                                                                                                 

(product)

   [select category.category id, category.category name,subcategory.subcategory id ,subcategory.subcategory name ,product.product name FROM category Inner JOIN    subcategory ON category.category id =subcategory.category id Inner join product on subcategory.subcategory id = product.subcategory id ]

 

(Output)

 

 

ByShubham Jain

How to export all of your website data to Excel/CSV using phpMyAdmin

Overview:-

Many times we might need to export our data from database to an Excel or CSV file. In e-commerce, we need many reports of our orders, products, categories in Excel or CSV file. Thanks to phpMyAdmin, you can simply get all of this data from phpMyAdmin. phpMyAdmin is a powerful tool to interact with MySQL or MariaDB database. We are listing how to import, export data from your MySQL or MariaDB database in simple steps. You can export your data in any format, major format are CSV, Excel, JSON, MS Word, PDF, Text, PHP Array, SQL, YAML etc.

Import Sql file in database

  1. Login into c panel.

Login into phpmyadmin

 

     2. Click on new button.

Add database in phpMyAdmin

  1. Enter the name of the database in the database box.

Enter database name in phpMyAdmin

(If you don’t know database name which u want to import, then right click on your file which u want to import, open into notepad)

SQL database file

You can see your database name in “use database name or Create Database ” as shown in the image above,

  1. Select the database you want to import.

Databases in phpMyAdmin
5. Click on “Import” tab at the top.

import data in phpMyAdmin

 

6. Click on choose file button, locate file in your computer which you want to import, open file.

7. Select file format in drop down list, and press go button

import sql file in phpMyAdmin

     8. Success. All the tables will show left side .

phpMyAdmin

How to export in database

  1. Click on database which you want to export, then click on export button

select database in phpMyAdmin

export database phpMyAdmin

      2. Select the desired format (You can choose MS Excel, SQL, and CSV etc.)

export database phpMyAdmin

      3. Press Go button.

 

How to export any custom query in database

1. Click on table.

2. Click on button as show in an image.

write custom query in phpMyAdmin

3. Write a query in a text field, press go button.

Run query in phpMyAdmin

4. Click in export button; Select the desired format (You can choose MS Excel, SQL, and CSV etc.).

Export data of query in phpMyAdmin

5. Click go button.

export data in phpMyAdmin

 

Done! You can now easily export all your products, categories, options, store details or can simply take backup of all of your database.