Digital Electronics

Digital Electronics, The digital mantra is the reason of our existence in this world. The digital-mania made it possible that today, everyone carries computers, mobiles, tablets, notebooks and other electronic gadgets in our pocket. Further technological development in the digital world will provide a homo-gadgeted interface that will let the gadgets to understand what we perceive with our senses and to react accordingly. This branch of Science has now entered in our houses even. The logic is implemented in every electronic device. It is not limited o the users having science/IT background but it also helps women’s who doesn’t even know the ABC of IT in kitchens and washrooms like ovens and washing machines and they are operating it like experts.

                      The digital mania has proved as the biggest marvel so far. The branch enables the world to get packed into a bag of 1X1 cm. As it has made it possible to store big things into small sized packets. Open these and the things retain their original shape. Wonder of Wonders, Isn’t it?.  This intensity has put everyone in dilemma when we think of the memory cards, pen drives etc.And connection to the world to share the data in seconds, just a click away. The whole world of information is in your pocket. Kudos to the IT world.

Er. Nipun Sharma

STEP Consultancy

Revolution in Javascript to AngularJS

      Javascript is used in web development . Initially Javascript was used as a helper in form validations and basic mouse events handling. But the framework development took a longer time than in other languages. In 2006 jQuery changed the way we  used  Javascript. Now it was easier to do basic tasks in just a few lines, in contrast to core Javascript. It was also slower to perform. But as soon as the web browsers started to develop and made the web better with improvements in the  newer versions.  jQuery got most popular framework and made it possible to make games, sliders, ui-effects, and animations.

      In 2009 Google took another step in field of  web development  and completely changed the meaning of Javascript. It is MV* (Model View Whatever)  framework. It works like a fake server on user frontend and handles user requests to make a single page fully functional app. This type of framework is very useful and has major advantages such as it reduces server requests for each page, thus saving server bandwidth and another major advantage is fast page views because there is no need to get complete page from server each time. We only need JSON formatted data as response, which usually results in saving huge bandwidth. (eg. A typical JSON response is 0 to 5kB only)

As the technology advances we can expect more life changing experiences in web technology. AngularJS, Node.JS are one of them.

Er. Davinder Singh
STEP Consultancy

Insert & Delete my SQL Queries

SQL commands are instructions used to communicate with the database to perform specific task that work with data. Some categories of commands used in SQL to perform various functions.  SQL commands can be used not only for searching the database, tables but also to perform various other functions like, create the tables, add the data to tables, or modify the data, drop the table and set permissions for users. Two query commands of SQL are following there:

 INSERT and DELETE queries in PHP which are commonly used ?

INSERT QUERY 

<?php

if(isset($_POST['sub']))

{

      $title = mysql_escape_string($_POST['title']);

                $sql="insert into news (`title`) values('$title')";

                $result=mysql_query($sql);

                if($result)

                {

            echo"sucessfully added";

                }

                else

                {

                                echo" error adding news";

                }

}

DELETE QUERY

if(isset($_GET['delete'])){

                // get row id to be deleted and query delete

                $id = (int)$_GET['delete'];

                if(mysql_query("delete from `news` where `id`='$id'"))

      {

                                echo 'News deleted successfully.';

                }

else

      {

                                echo 'Unable to delete row';

      }

}

Advantages of Core PHP & Comparison with Frameworks

PHP is widely known language for web development.Most people say that PHP is not a standard language for development, and blame anything  bad on programs. But in truth PHP is not a bad language, it is in the hands of  developers and coders how they use it. As it is easy to learn, everybody tries to be a programmer in hurry and as a result the output is  bad programmers in large numbers. PHP is much secure if programs/scripts are made better.  Core PHP is much powerful, and you can create anything you  imagine. All it requires is a  better Code. When we compare it with  core and frameworks, Core is more stable because functions are not depreciated  or changed fast. But in case of Frameworks, You rely a lot on the framework developers. They can change the functionality anytime, they can add or remove existing functionality in new versions without any notice.

             If you compare Core with  Frameworks, you may see large difference in functionality and the way it works. The frameworks make you save time by not coding extra lines of code. There are many developers who have built features in popular known frameworks, that are not directly available in core PHP or user/developer had to make themselves ( eg. Captcha helpers ).