Posts

Web design, Mobile Application, Seo, Digital Marketing, Website development, Software Company in Thrissur, Kerala, India

By -
Digital Marketing Company in Thrissur, Kerala Software Company in Thrissur, Kerala Web Design Company in Thrissur, Kerala Web Development Company in Thrissur, Kerala Web Development in Thrissur, Kerala Web Designers in Thrissur, Kerala Website Development Company in Thrissur, Kerala Website Development in Thrissur, Kerala Website Designers in Thrissur, Kerala Website Developers in Thrissur, Kerala Software training in Thrissur, Kerala Academic project in Thrissur, Kerala Live Academic project in Thrissur, Kerala Live Academic project in Thrissur, Kerala Android project in Thrissur, Kerala .Net course in Thrissur, Kerala
15 comments
Read more

Rank Operation Using SQL

By -
Rank - Make ranking structure using SQL tool                If we have collection of data and we want to make it an well structure by reduce duplication and make view based on ranking; we have a simple and easy option to do this operation.It is called Rank. For example we have data such like,   Name        Sales John           10 Jennifer      15 Stella          20 Sophia       40 Greg          50 Jeff            20 The general idea to display rank in SQL is to do a  self-join , then list out the results in order, and finally do a count on the number of records that's listed ahead of (and including) the record of interest. So, we coming back to discussion. we have to make this data in ranking based order.so lets start with the query, SELECT a1.Name, a1.Sales, COUNT (a2.Sales) Sales_Rank  FROM Total_Sales a1, Total_Sales a2  WHERE a1.Sales <= a2.Sales OR (a1.Sales=a2.Sales AND a1.Name = a2.Name)  GROUP BY a1.Name, a1.Sales  ORDER BY a1.Sales DES
1 comment
Read more

PHP PAGINATION

By -
Image
Simple Pagination Using Jquery With PHP                    In PHP pagination helps to make a standard view of data. It divide collection of data in page wise view. It helps to make arrange unordered data into ordered bunch. Here we are going to discuss about , how we can make an pagination of data in PHP using Jquery. a Jquery file called jquery.min.js is needed to use jquery methods. Source     PHP code file named load_data.php   <?php if($_POST['page']) { $page = $_POST['page']; $cur_page = $page; $page -= 1; $per_page = 6; $previous_btn = true; $next_btn = true; $first_btn = true; $last_btn = true; $start = $page * $per_page; include"db.php"; $query_pag_data = "SELECT msg_id,message from messages LIMIT $start, $per_page"; $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error()); $msg = ""; while ($row = mysql_fetch_array($result_pag_data)) { $ht
Post a Comment
Read more
By -
Conditional statement in SQL           W e have an if condition in programming sector to handle the conditional operation. Like that in SQL conditional operation done by using CASE statement. A sample example of CASE statement in sql is given below,        syntax,       SELECT CASE ("column_name")      WHEN "value1" THEN "result1"     WHEN "value2" THEN "result2"         ...        [ELSE "resultN"]      END     FROM "table_name";     eg:           SELECT Store_Name, CASE Store_Name           WHEN 'Los Angeles' THEN Sales * 2           WHEN 'San Diego' THEN Sales * 1.5           ELSE Sales           END           "New Sales",           Txn_Date           FROM Store_Information; By Varun K.R Ociuz Technologies
Post a Comment
Read more
By -
Image upload in C#(windows application) In windows application file upload operation is not much easy just like web application.But we can implement this in windows application using other way.  Needed Controls : Openfiledialog,Button,TextBox Coding part : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.IO; namespace DemoWindowsApplication {     public partial class FileUpload : Form     {         public FileUpload()         {             InitializeComponent();         }         private void button1_Click(object sender, EventArgs e)         {             DialogResult result = openFileDialog1.ShowDialog();             if (result == DialogResult.OK) // Test result.             {                 textBox1.Text = openFileDialog1.FileName;             }         }    
Post a Comment
Read more
By -
Image
MVC - The architecture for modern web concept                                         Here we are introducing a new technology called MVC(Model View Controller) which is widely  using architecture in modern web world. Its bring us to new way or concept of web development . MVC project structure is entirely different from other project types. It mostly used for web development. It is very lightweight and well structure which user can easily handle it. But one thing is that, if we are new for this architecture there is little bit of tough to understand its flow of development. If we try to make familiar with it , we can easily handle MVC projects.                                           MVC is an pure html based page creating which makes it fast performance and lightweight process. We know many of sites take more time to load and tolerate us to waste our time , here MVC solve that situation  in modern world.  There is three layers which defines, The business la
Post a Comment
Read more
By -
Image
How to reduce an image size while upload to the server         M ost of users wants to fast uploading process when they are browsing. there are several method to file encryption and decryption , compress file technology is widely used. Here we are going to discuss how to reduce the file in upload process using PHP. Given below code will be help to solve this problem. Code: <?php $name = ''; $type = ''; $size = ''; $error = ''; function compress_image($source_url, $destination_url, $quality) { $info = getimagesize($source_url);     if ($info['mime'] == 'image/jpeg')         $image = imagecreatefromjpeg($source_url);     elseif ($info['mime'] == 'image/gif')         $image = imagecreatefromgif($source_url);     elseif ($info['mime'] == 'image/png')         $image = imagecreatefrompng($source_url);     imagejpeg($image, $destination_url, $quality); return $
Post a Comment
Read more