Techno Blaze | Ajax, Android, Asp.net C#, Codeigniter, jQuery, mySQL

Multi process download

2018-11-14T13:27:00.000-08:00

To fast up the process split up two different threads

   private static void Writer()
   {            
   try
      {               
         WebClient client = new WebClient();
         string status = client.DownloadString
  ("https://speckyboy.com/25-modern-content-heavy-websites/");
 
                 using (FileStream fs = File.Open("D:\\import\\111.txt", FileMode.Create,
   FileAccess.Write, FileShare.ReadWrite))
                 {
                     byte[] bytes = Encoding.ASCII.GetBytes(status);
                     int bytelen = bytes.Length / 2;
 
                    Thread t = new Thread(()=> NewMethod2(status, fs,0, bytelen));
                     t.Start();
 
                     Thread t1 = new Thread(()=> NewMethod2(status, fs, bytelen, bytes.Length));
                     t1.Start();
                    
                     while (true)
                     {
 
                         if (!t.IsAlive && !t1.IsAlive)
                         {
                             fs.Close();
                             break;
                         }
                     }
                     Console.Write("Write:" + status + Environment.NewLine);
                 }
                 System.Threading.Thread.Sleep(10);
               
             }
             catch (Exception ex)
             {
                 Console.Write("write" + ex.ToString());
                 Console.Read();
             }
         }

   private static void NewMethod2(string status, FileStream fs,int start, int bytelen)
          {
              for (int i = start; i < bytelen; i++)
              {
                  fs.Write(Encoding.ASCII.GetBytes(status[i].ToString()), 0,
   Encoding.ASCII.GetBytes(status[i].ToString()).Length);
  
              }
          }

Download files

2015-08-11T11:19:00.001-07:00

Create interface for downloads method and path property. Interface : An interface contains only the signatures of methods, properties, events or indexers. A class or struct that implements the interface must implement the members of the interface that are specified in the interface definition.
```
 public interface downloads 
 {
     string path { get; set; }
     void download();
 }
```

create class name general and inherit the interface class in it Inheritance : Inheritance allows us to define a class in terms of another class, which makes it easier to create and maintain an application. set the property and method for download by using httpresponse download the file from server to local system.

 public class general  : downloads
 {

     public string path
     {
         get;
         set;
     }

     public void download()
     {
         using (FileStream fs = File.OpenRead(this.path))
         {
             int length = (int)fs.Length;
             byte[] buffer;

             using (BinaryReader br = new BinaryReader(fs))
             {
                 buffer = br.ReadBytes(length);
             }

             HttpContext.Current.Response.Clear();
             HttpContext.Current.Response.Buffer = true;
             HttpContext.Current.Response.AddHeader("content-disposition", 
             String.Format("attachment;filename={0}",  Path.GetFileName(path)));
             HttpContext.Current.Response.ContentType = 
                  "application/" + Path.GetExtension(path).Substring(1);
             HttpContext.Current.Response.BinaryWrite(buffer);
             HttpContext.Current.Response.End();
         }   //
     }
 }

create the object for class general and set the path to property call the download method to make a download the file.

  public void sDownload()
     {
         downloads obj = new general();
         obj.path = @"C:\GoogleBackup\googleService.txt";
         obj.download();
     }

Download

Search tables and procedures by given text in it

2015-08-02T11:11:00.000-07:00

Find all tables and procedures by giving string in it using like operator in SQL

FOR TABLES

 SELECT COLUMN_NAME, TABLE_NAME 
 FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE COLUMN_NAME LIKE '%searchstring%'

FOR PROCEDURES

 SELECT OBJECT_NAME(object_id), 
        OBJECT_DEFINITION(object_id)
 FROM sys.procedures
 WHERE OBJECT_DEFINITION(object_id) LIKE '%SearchString%'

Get RAM and CPU usage in C#

2015-07-31T23:14:00.000-07:00

Get Cpu and Ram Usage by kernel132.dll in c# How to get CPU percentage ?

Step 1: include namespace in class file

 using System;
 using System.Diagnostics;
 using System.Runtime.InteropServices;
 using System.IO;

Step 2: Declare performance counter and other variables and we just get average of cpu 5 times with difference of 5 seconds

 Public string GetCpuPercentage()
  {
   PerformanceCounter cpuCounter;
   double cpuUsage = 0;
   int totalCpuUsage = 0;
   double returnLoopCount = 0;

   cpuCounter = new PerformanceCounter();
   cpuCounter.CategoryName = "Processor";
   cpuCounter.CounterName = "% Processor Time";
   cpuCounter.InstanceName = "_Total";
   for (int i = 0; i < 5; i++)
   {
   cpuUsage += cpuCounter.NextValue();
   System.Threading.Thread.Sleep(1000);
   }
   totalCpuUsage = Convert.ToInt32(Math.Ceiling(cpuUsage / 5));
   return totalCpuUsage;
  }

Step 3:Declare performance counter and other variables and we just get average of RAM memory usage by using 'Kernel32.dll'

 public string GetRamPercentage()
  {
      PerformanceCounter ramCounter;
           double ramUsage = 0;
           int TotalRamMemory = 0;
           int AvailableRamMemory = 0;
           int UsedRamMemory = 0;
           int RamUsagePercentage = 0;
           double returnLoopCount = 0;
           MEMORYSTATUSEX statEX = new MEMORYSTATUSEX();
           statEX.dwLength = (uint)Marshal.SizeOf(typeof(MEMORYSTATUSEX));
           GlobalMemoryStatusEx(ref statEX);

           double ram = (double)statEX.ullTotalPhys;
           //float ram = (float)stat.TotalPhysical;
           ram /= 1024;
           ram /= 1024;

           TotalRamMemory = Convert.ToInt32(Math.Round(ram, 0));
           ramCounter = new PerformanceCounter("Memory", "Available MBytes");
           for (int i = 0; i < 5; i++)
           {
               ramUsage += ramCounter.NextValue();
               System.Threading.Thread.Sleep(1000);
           }
           AvailableRamMemory = Convert.ToInt32(Math.Round((ramUsage / 5), 0));
           UsedRamMemory = TotalRamMemory - AvailableRamMemory;
           RamUsagePercentage = ((UsedRamMemory * 100) / TotalRamMemory);

   return RamUsagePercentage;
        
  }

     [return: MarshalAs(UnmanagedType.Bool)]
     [DllImport("Kernel32.dll", CharSet = CharSet.Auto, SetLastError = true)]
     internal static extern bool GlobalMemoryStatusEx(ref MEMORYSTATUSEX lpBuffer);

 [StructLayout(LayoutKind.Sequential)]
 internal struct MEMORYSTATUSEX
  {
       internal uint dwLength;
       internal uint dwMemoryLoad;
       internal ulong ullTotalPhys;
       internal ulong ullAvailPhys;
       internal ulong ullTotalPageFile;
       internal ulong ullAvailPageFile;
       internal ulong ullTotalVirtual;
       internal ulong ullAvailVirtual;
       internal ulong ullAvailExtendedVirtual;
  }

Download

How to create stored procedure in SQL?

2015-07-16T11:30:00.001-07:00

SQL STORED PROCEDURE :

SQL Procedure are nothing but set of sql statement grouped and perform a specific task. it will give high performance for database
stored procedure compiled at once it created in database Then after it does not require recompilation before executing unless it is modified and reutilizes the same execution plan
it is usability of SQL code and re-usability purpose of same kind of operation using twice in our source code

How to create stored procedure ?

 SYNTAX:

 CREATE PROCEDURE <PROC NAME>
 AS
 @param1 <datatype>
 BEGIN
  //Code of T-SQL
 END


EXPLAINATION : 

 CREATE PROC <PROC NAME>
 AS
 @param1 BIGINT  //input param
 BEGIN

 CREATE TABLE #TEMP (name VARCHAR(50)) // CREATiNG TEMP TABLE
 INSERT INTO #TEMP    // bulk insert
 SELECT * FROM table1 WHERE salary > @param // get users from table 1 
  UNION 
 SELECT * FROM table2 WHERE salary < @param  // get users from table 2

 SELECT * FROM #TEMP
 DROP TABLE #TEMP

 END

How to alter stored procedure ?

 SYNTAX:

 ALTER PROCEDURE <PROC NAME>
 AS
 @param1 <datatype>
 BEGIN
  //code of T-SQL
 END

EXPLAIN : 
//instead of create we can give alter and we can save changes in sp(STORED PROC)

EXPLAINATION : 

 ALTER PROC <PROC NAME>
 AS
 @param1 BIGINT   //input param
 BEGIN

 CREATE TABLE #TEMP (name VARCHAR(50)) // CREATiNG TEMP TABLE
 INSERT INTO #TEMP    // bulk insert
 SELECT * FROM table1 WHERE salary > @param // get users from table 1 
  UNION 
 SELECT * FROM table2 WHERE salary < @param  // get users from table 2

 SELECT * FROM #TEMP ORDER BY name DESC
 DROP TABLE #TEMP

 END

How to execute stored procedure ?

 SYNTAX:
 EXECUTE <sp_name> @param = 1000
  OR
 EXEC <sp_name> 1000
  OR 
 <sp_name> 1000

Summary : Stored procedure is reusing the code,performance of execution plan,reduce the traffic of the network sp(STORED PROC) is one of the best way to use in heavy transactions over the network

Bulk insert from one table to another table in SQL

2015-07-15T00:20:00.001-07:00

Bulk Insert

we can use two types of bulk insert in MSSQL
it is very useful to transfer whole data or particular data from one table to another
Type 1: we need to create schema or we can use existing schema for insertion
Type 2: we cannot insert data's in existing table schema.this type will copy the schema of selected table and create table in database or we can use temp table
Mostly this bulk insert are used in stored procedure or user-defined functions for calculations.

Type 1:

 CREATE TABLE TABLE1( name INT,EmpSalary BIGINT)
 INSERT INTO TABLE1
 SELECT name,salary FROM TABLE2
 WHERE salary > 1000

Type 2 :

 SELECT * INTO #TEMP FROM TABLE2 //this will create temp table with selected table schema
 WHERE salary > 1000
   OR
 SELECT * INTO TABLE FROM TABLE2   // this will create real table with selected table schema in DB
 WHERE salary > 1000

Bulk Update using join in SQL

2015-07-12T09:32:00.000-07:00

UPDATE WITH JOIN

 UPDATE t1
  SET t1.name = t2.empname  //copy content from one table to another
 FROM table1 t1
    INNER JOIN table2 t2 ON
        t1.id = t2.t1id

how to implement Tweet snd linkedin button for each and every post in Your blog ??

2013-07-14T09:15:00.002-07:00

how to implement Tweet snd linkedin share button for each and every post in Your blog ??

Some of the Steps we have to follow to complete the above task.

1.Go to Dashboard->Template
2.Click Edit HTML
3.Search <data:post.body/>
4.Paste the below code

<b:if cond='data:blog.pageType != "static_page"'> <div style='text-align:left;padding:5px 5px 5px 0;'> <a class='twitter-share-button' data-count='horizontal' data-related='' data-via='technoblaze1' expr:data-text='data:post.title' expr:data-url='data:post.url' href='http://twitter.com/share'>Tweet</a> <script src='http://platform.twitter.com/widgets.js' type='text/javascript'/> </div> </b:if>
<p>

<script src='http://platform.linkedin.com/in.js' type='text/javascript'/>

<script data-counter='right' type='IN/Share'/></p>

SCREEN SHOTS:

STEP:1

STEP:2 & 3

STEP:4

STEP:5&6

Facebook like button for each post in blogger

2013-07-12T10:24:00.001-07:00

how to implement Facebook like button for each and every post in Your blog ??

Some of the Steps we have to follow to complete the above task.

1.Go to Dashboard->Template
2.Click Edit HTML
3.Search <data:post.body/>
4.Paste the below code

<p><iframe allowTransparency='true' expr:src='"http://www.facebook.com/plugins/like.php?href=" + data:post.url + "&layout=button_count&show_faces=false&width=100& action=like&font=arial&colorscheme=light"' frameborder='0' scrolling='no' style='border:none; overflow:hidden; width:100px; height:20px;'/></p>

5.Click Save template
6.View your blog.

Screen shots:

Step:1

Step:2 & 3

Step:4

Step: 5 & 6

Facebook like and unlike system using [php-mysql-ajax] and facebook wall post system with time calculation system for each post and display it in users wall

2013-07-10T06:18:00.000-07:00

We have to make Facebook wall system,Face book like system and Facebook time management system for each and every post
-In my previous post Facebook wall system will be implemented
-In this Post contains facebook like system and facebook time management system along with wall post system will be implemented
-in this section i have created separate login system for every users
-users can login and post their words in their wall
-others users will like or unlike the post using their user-id
-face book time management means, users posts display the time when they posted and how many hours,minutes or seconds ago they posted their words or quotes and all
- this are the task we have to done
-there are several steps to complete our task
-Create database and following tables
-there are 3 Table contains in database

1.Login
2.Messages
3.message_like

1.Login table :

CREATE TABLE IF NOT EXISTS `login` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`password` varchar(250) NOT NULL,
PRIMARY KEY (`uid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

2.Message table:

CREATE TABLE IF NOT EXISTS `messages` (

`msg_id` int(11) NOT NULL AUTO_INCREMENT,

`message` varchar(200) NOT NULL,

`uid_fk` int(11) NOT NULL,

`like_count` int(11) DEFAULT NULL,

`created` varchar(250) DEFAULT NULL,

PRIMARY KEY (`msg_id`),

KEY `uid_fk` (`uid_fk`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

3.message_like table :

CREATE TABLE IF NOT EXISTS `message_like` (

`like_id` int(11) NOT NULL AUTO_INCREMENT,

`msg_id_fk` int(11) DEFAULT NULL,

`uid_fk` int(11) NOT NULL,

`created` varchar(250) NOT NULL,

PRIMARY KEY (`like_id`),

KEY `uid_fk` (`uid_fk`),

KEY `msg_id_fk` (`msg_id_fk`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;

-Download the file and configure your hostname,username and password

-Live demo is available,check it

- if any queries regarding, post your commands

Screen Shots:

A simple hotel booking software using [php-mysql-ajax]

2013-07-06T23:34:00.002-07:00

Description:

We have to create simple hotel booking software using php,mysql
-there are several process to done the above task .
-first of all create the database for hotel booking system
-database contains 4 tables
1.booking
2.Customer
3.invoice
4.room
-booking table contains (id,arraival,checkout,room,customerid,cotrequire,satelliterequire,gamrequire,service)
-customer table contains(id,firstname,lastname,email,address,city,state,pincode,phone)
-invoice table contains(id,cusmail,chkout,roomno,roomtype,price,total etc..)
-room table contains (id,roomnum,type,price ,etc..)
-download this software
-install wamp software
-import database from download file in phpmyadmin
-configure and run it ..

screen shots:

Download

Dynamic Chat Design for android and ios

2013-07-05T23:37:00.000-07:00

Description:

-Dynamic chat ui ll be created for android and ios mobiles.
-Dynamic chat ui created by using HTML5 and CSS3 technologies.
-It is very easy to integrate it.
-Systematic Explain will be done .
-Just download and use it.
-Download file contains[chat.html,chatcs.css,battery.png,signal.png,wifi.png]
-If any queries please post your commands !.

Output will be :

Download

Dynamic Theme or background change using Colour picker

2013-07-04T00:39:00.001-07:00

We can dynamically change the particular div background colour using javascript colour picker
we have to follow 4 steps to done above task
step 1 :include jscolor picker file in ur file
step 2 :create a text box and define a class color
step 3 :create javascript function for change the div background colour according to the selection by using js cookie
step 4 :call the Js-function in text box onblur event

picker.html

<html>
<head>
 <title>colour picker demo</title>
<script>
function pick()    //------------------------------------------>step 3
{
var elem = document.getElementById("para1").value;
var cook=document.cookie="#"+elem;
var colour=document.getElementById("change");
colour.style.background=cook;
}
</script>
</head>
<body>
<div style="height:100px; width:400px;" id="change"> 
<!--colour change-->
</div>
 <script type="text/javascript" src="jscolor.js"></script> //->step1
 Click here: <input class="color" value="" onblur="pick()" id="para1">//->step2
//---------------------------------------------------- >step 4
</body>
</html>

Video preview:

Download

cURL-tutorial startup

2013-07-02T23:32:00.001-07:00

cURL:
         1.cURL is a Command line tool for getting and sending datas through URL

Now we can display the Google webpage with search key word "technoblazze" in your server by using cURL
We have to Follow 4 steps to do the above task
1.initialize the curl session
2.set various option for the session
3.Execute the option, fetch and display the datas in your server
4.close the curl session

curl.php

<?php 
$curl = curl_init('http://www.google.com/search?q=technoblazze.blog'); //step1
curl_setopt($curl, CURLOPT_FAILONERROR, true);    //step2
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); 
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); 
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); 
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);   
$result = curl_exec($curl);                       //step3
curl_close($curl);                                //step4
echo $result;
?>

Download

Start with XML - fetch and display the xml datas using php

2013-07-01T04:20:00.001-07:00

books.xml :   
<?xml version="1.0"?>
<datas>
  <books>
    <book>

      <id>1</id>
      <title>PHP Undercover</title>  
      <author>Arun</author>
    </book>
    <book>
      <id>2</id>
      <title>PHP Enterprise</title>   
      <author>Vibin</author>
    </book>
  </books>
</datas>

xmlread.php :
<?php

$xml = simplexml_load_file("books.xml")
       or die("Error: Cannot create object");        //include the books.xml file
foreach($xml as $books)                                       // seperate variables, books array from xml file
{
 foreach($books as $book )                           // seperate variables, book array from books file
      {
   echo $book->id;                                        //display the id
   echo "<br />";
   echo $book->title;                                     //display the title
   echo "<br />";
   echo $book->author;                                //display the author
   echo "<br />";
 }

}
?>

Output:
1
PHP Undercover
Arun
2
PHP Enterprise
Vibin

Download

Cloud Computing

2013-07-01T01:02:00.001-07:00

Cloud computing is a colloquial expression used to describe a variety of different computing concepts that involve a large number of computers that are connected through a real-time communication network (typically the Internet). Cloud computing is a jargon term without a commonly accepted non-ambiguous scientific or technical definition. In science, cloud computing is a synonym for distributed computing over a network and means the ability to run a program on many connected computers at the same time. The popularity of the term can be attributed to its use in marketing to sell hosted services in the sense of application service provisioning that run client server software on a remote location.

Advantages:

We can use and access the cloud from any where through internet.

Reduce the Storage capacity in your harddrive.

Cloud Storage Services :
Cloud storage services offer paid monthly subscriptions either for unlimited storage or for hundreds of gigabytes of data. Most of us do not have that much critical data to backup and therefore it would be a total waste of money. And for those of us who have data which cannot be stored using the 1 or 2GB free space offered, we have a list of four of the best free online storage services that offer free space of more than 10GB.

Best Sites for Cloud Computing :

1.Google Drive:

Link : https://drive.google.com/‎

2.DROP BOX

Link:https://www.dropbox.com/

3:BOX

Link: https://www.box.com/

4:SKYDRIVE

Link: https://skydrive.live.com/‎

Kick Start for HTML,CSS

2013-06-25T00:51:00.000-07:00

http://www.99lime.com/

Tips for using html and css in easy way :
go to -------->http://www.99lime.com/
goto---------->HTML kick Start
download--->from github
And call the particular class files mentioned in tutorial..

Structure of xml

2013-06-20T04:49:00.000-07:00

Input XML FILE:
<?xml version="1.0"?>
<note>
    <to cat="head">
        <cc>Arun</cc>
        <cc>Vibin</cc>
    </to>
    <from>
        <bc>Jani</bc>
        <bc>ishya</bc>
    </from>    
</note>

EXPLAIN:
<note>------->parent Element
<to>,<from>-->Child Element
<cc>,<bc>----->siblings
cat----------->attribute

Strcture Tree Diagram:

Print the Report or Page using Javascript And PHP

2013-06-18T00:55:00.000-07:00

Javascript file:

<script>
function printDiv(id)
{
  var divToPrint=document.getElementById(id);
  newWin=window.open('', '', 'left=5,top=10,width=1024,height=768,toolbar=0,scrollbars=0,status=0');
  var str='<html><head><link href="css/css.css" rel="stylesheet" type="text/css"/></head><body><div align="center"><img src="image/logo.png" border="0"></div><br/><div align="center"><b>Outstanding Report</b></div><br></body></html>';
  newWin.document.write(str);
  newWin.document.write(divToPrint.outerHTML);
  newWin.print();
  newWin.close();
}
</script>

Passing the Div ID parameter:

<input type="image" onClick="return printDiv('sprint');"  value="print"  src="image/printj.png" class="flrt" title="print report"/>
<div id="sprint">
<?php
// Dynamic Code here
?>
</div>

Expected Output:

Script for Dynamic MORE or LESS and [all the DIV's become Less when One more option is clicked]

2013-06-15T03:21:00.000-07:00

<script>
 $(document).ready(function () {
var showChar = 100;
 var ellipsestext = "...";
 var moretext = "more";
 var lesstext = "less";
 var txtlen = 1;
 $('.more').each(function () {
 var content = $(this).html();
 if (content.length > showChar) {
 var c = content.substr(0, showChar);
 var h = content.substr(showChar - 1, content.length - showChar);
 var html = c + '<span class="moreelipses">' + ellipsestext + '</span>&nbsp;<span class="morecontent"><span>' + h + '</span>&nbsp;&nbsp;<a href="" class="morelink" id=testimonial' + txtlen + '>' + moretext + '</a></span>';
$(this).html(html);
 }
 txtlen++;
 });
 $(".morelink").click(function () {
 if ($(this).hasClass("less")) {
 $(this).removeClass("less");
$(this).html(moretext);
 } else {

 for (var i = 1; i < txtlen; i++) {
if ($("a#testimonial" + i).attr('class') == "morelink less")
 {
 $("a#testimonial" + i).trigger("click");
 }
 }
 $(this).addClass("less");
 $(this).html(lesstext);
}
 $(this).parent().prev().toggle();
 $(this).prev().toggle();
 return false;
 });
 });
</script>

<div class="comment more">
 <?php 
              //give dynamic code
        ?>
</div>
<div class="comment more">
 <?php 
              //give dynamic code
        ?>
</div>

Face book Wall Post

2013-06-09T01:00:00.000-07:00

Index.php:

<?php
include 'class.php';
$db=new database();
$db->connect();
?>
<link rel="stylesheet" href="wall.css" type="text/css" />
<script type="text/javascript" src="jquery-latest.js"></script>
<script>
$(document).ready(function() {
$('#textpost').click(function() {
      var b=$("#fbpost").val();
      var dataString = 'fbwall='+b;
      $.ajax( {
              type:"POST",
      		async: false,
              url:"ajax.php",
              data: dataString,
              success: function(data) {		

			  	  $("#fbpost").val("");		 
                  $("#viewpost").html(data);				  				             
              }
          });
});
});

</script>
<div id="container">
	<div>
    <img src="facebook-logo.jpg" width="200" height="75"/>
    </div>
	<div id="post">
    	<form action="" method="post">
        	<p class="example-twitter">
        	<textarea name="fbwall" id="fbpost" class="" placeholder="whatzz upp?" >
            </textarea>               
            <br/>  <br/> 
            <a href="#" class="button postfb" id="textpost">Post</a>
            </p>
        </form>                      
    </div>
    <br><br><br><br>
    <div id="viewpost">
    <?
	$queyr=$db->query("select * from fb ORDER BY `id` DESC");
	while($query=$db->fetch($queyr))
	{
	?>
    <div id="display">
    	<div id="leftdisplay">
        <img src="http://lh3.googleusercontent.com/-Iw_xOyvn0z0/AAAAAAAAAAI/AAAAAAAAAFw/r_0QqjeH2vQ/s512-c/photo.jpg"  width="120" height="120"/>
        </div><br/><br/>
        <div id="rightdisplay">
        	<p class="triangle-border left">
            	<? echo $query["wallpost"];?>
            </p>
        </div>
    </div>
    <div style="height:200px;"></div> 
    <? } ?>   
    </div>
</div>

Ajax.php:

<?
include 'class.php';
$db=new database();
$db->connect();
if(isset($_REQUEST["fbwall"]))
{
	$wall=$_REQUEST["fbwall"];
	$insert=$db->query("INSERT INTO fb (wallpost) VALUES ('$wall')");
	if($insert)
	{
		$select=$db->query("select * from fb ORDER BY `id` DESC");
		while($view=$db->fetch($select))
		{?>
             <div id="display">
                <div id="leftdisplay"><img src="http://lh3.googleusercontent.com/-Iw_xOyvn0z0/AAAAAAAAAAI/AAAAAAAAAFw/r_0QqjeH2vQ/s512-c/photo.jpg"  width="120" height="120"/></div><br/><br/><br/><br/>
                <div id="rightdisplay">
                    <p class="triangle-border left">
                        <? echo $view["wallpost"];?>
                    </p>
                </div>
            </div>
            <div style="height:200px;"></div>
		<? }
	}
}
?>

Database:
id---------->int(11)
wallpost--->longtext()

class.php

<?

class database

{
	 public function connect()
     {

        $con=mysql_connect("localhost","root","") or die("unable to connect");
        mysql_select_db("test",$con) or die("unable to select");
     }
     public function query($sql)
     {
         $sc=mysql_query($sql) or die("query not working".  mysql_error());
         return $sc;
        
     }
     public function  fetch($qu)
     {
         $ft=mysql_fetch_array($qu);
         return $ft;
     }
     public function num($rows)
     {
         $rw=mysql_num_rows($rows);
         return $rw;
       
     }
}
?>

Output:

Download

Dynamic Autocomplete using php

2013-06-06T00:19:00.000-07:00

index.php:<

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Auto Complete Input box</title>
<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="jquery.autocomplete.js"></script>
<script>
$(document).ready(function(){
 $("#tag").autocomplete("autocomplete.php", {
  selectFirst: true
 });
});
</script>
</head>
<body>
<label>Tag:</label>
<form action="" method="post">
<input name="tag" type="text" id="tag" size="20"/> 
 <input type="submit" value="submit" name="gt"/>
<form>
</body>
<?php
if(isset($_POST["gt"]))
{
$mysql=mysql_connect("localhost","root","123");
mysql_select_db("hi",$mysql);
mysql_query("insert into tag (name) values ('".$_POST["tag"]."')");
echo $_POST["tag"];
}
?>
</html>

autocomplete.php:

<?php
 $q=$_GET['q'];
 $my_data=mysql_real_escape_string($q);
 $mysqli=mysqli_connect('localhost','root','123','hi') or die("Database Error");
 $sql="SELECT name FROM tag WHERE name LIKE '%$my_data%' ORDER BY name";
 $result = mysqli_query($mysqli,$sql) or die(mysqli_error());
 
 if($result)
 {
  while($row=mysqli_fetch_array($result))
  {
   echo $row['name']."\n";
  }
 }
?>

Database :

id--->int(4)--->Autocomplete
Name--->varchar(50)

Download

what is the Best programming Language to learn in 2013

2013-05-20T21:57:00.000-07:00

An interesting article caught my eye at jobstractor.com — the programming language trends review. The company analyzed more than 60,000 job vacancies during 2012 to produce a chart of the most sought-after technologies:

Language Jobs

PHP 12,664

Java 12,558

Objective C 8,925

SQL 5,165

Android(java) 4,981

Ruby 3,859

Javascript 3,742

c# 3,549

c++ 1,908

Actionscript 1,821

Python 1,649

C 1,087

Asp.net 818

Despite developer complaints, demand for PHP and Java (server/Android) remains strong. You would also expect those jobs to require some SQL knowledge although that has a strong showing in its own right. ActionScript is a dying art so it’s rapidly falling off the chart.

WORLD TOP TEN PROGRAMMING LANGUAGES

2013-05-20T21:34:00.005-07:00

1.JAVA :
An object-oriented programming language developed in the late 1990s by James Gosling and colleagues at Sun Microsystems.

2.C:
  C, a general purpose programming language built by Dennis Ritchie when he was a part of Bell Telephone labs, is the bass of C++ and other programming languages. It was built to work with the Unix operating system.

3.C#:
This general-purpose programming language developed by Microsoft evolved from C and C++ as a part of the software company’s .NET initiative.

4.C++:
  C++ is a general purpose multi-paradigm spanning compiled language that has both high-level and low-level languages’ features. It was started as an enhancement to the C programming language,Bjarne Stroustrup in 1979.

5.Objective-c:
This object-oriented programming language created first by Brad Cox and Tom Love at their company Stepstone in the early 1980s, adds Smalltalk-like messaging to the C programming language.

6.PHP:
  This language is especially suited for Web development because of it easy embedding into HTML pages. It is an open-source, server-side, cross-platform, interpretive HTML scripting language

7.VB :
This is an event-driven programming language which is implemented on Microsoft’s .Net framework.

8.Python :
  This is an event-driven programming language which is extensively used by Google because of its simplicity. It is managed by the Python Software Foundation.

9.perl :
Being a high-level programming language, its emphasis lies in code readability and clear syntax. It combines Object-oriented and functional programming styles, and is often used as a scripting language. Perl is an open-source language used widely to process text through CGI programs.

10.Javascript :
  JavaScript is an object-oriented scripting language that is smaller than Java. Being a client-side language, it runs in the web browser on the client-side with a simplified set of commands, easier code and no need for compilation.

javascript conform box

2013-05-06T22:47:00.001-07:00

<script type="text/javascript">
function Validate(event) 
{
var thereturn = confirm("Are you sure want to delete the profile?");
if (event) 
{
        if (!thereturn)
{
event.preventDefault();
}
} 
else 
{
return thereturn;
}
}
window.onload = function()
{ 
document.getElementById('delete-form').onsubmit = Validate;
};
</script>
<input type="submit" class="submit redform" value="delete"  onclick="Validate(event)" />