Free Computer Stuffs

गणपती बाप्पा मोरया

noreply@blogger.com (Kashid) — Thu, 28 Aug 2014 01:26:00 -0700

Lord Ganesh Utsav is greatly celebrated All over India, especially in the Maharashtra state .

Nature Drawing Greeting Cards

noreply@blogger.com (Kashid) — Mon, 2 May 2011 08:21:00 -0700

May all your Dreams Come true, with every Ocean Wave Coming in ..

Happy Birthday To You !

noreply@blogger.com (Kashid) — Wed, 27 Apr 2011 05:29:00 -0700

Happy Birthday Special Gift

Special Birthday Gift to Someone Special...

Download Valentines day Messages & Greetings Ebook Free!

noreply@blogger.com (Kashid) — Fri, 21 Jan 2011 19:03:00 -0800

♥ The most beautiful Thing in the World is "Friendship & Love Lasts Forever"

♥ Celebrate Valentines day to express love and affection.

Birthday Greeting cards Diwali Greetings Christmas Greetings New Year Greetings

Click Here to Download

PHP: Getting List of Database & Tables in MySQL

noreply@blogger.com (Kashid) — Sun, 9 Jan 2011 22:47:00 -0800

PHP supports Object oriented Concepts hence one Class is created named dbconnect which has reusable database functions like selecting database, firing query and getting result etc

Query1: Show Databases returns List of Databses in MySQl
Query2: Show Tables returns List of Tables in selected Database.

dbconnect.php
<?php
Class dbconnect
{
  function __Construct()
   {
   $this->cn=mysql_connect("localhost","root");

   }
function firequery($q)
   {
   $res=mysql_query($q);
   return $res;
   }

function __Destruct()
   {
   mysql_close( $this->cn);

   }
function selectdb($name)
   {
   mysql_select_db($name);

   }

  }

?>

ListDatabase.php

<?php
try
{
require_once('dbconnect.php');//to make available database functions from dbconnect.php
$obj=new dbconnect();

$res=$obj->firequery('Show Databases');
echo '<h3>List of Databases in MySQL</h3>';
echo '<form name="frm" method="post"><select name="s1" multiple onchange=submit();>';
while($row=mysql_fetch_row($res))
{
  echo "<option>$row[0]</option>";
  }
echo '</select></form>';

if(isset($_POST['s1']))
{
  $obj->selectdb($_POST['s1']);
  $res=$obj->firequery('show tables');
echo "<h3>Tables in <i>".$_POST['s1']. "</i></h3>";
while($row=mysql_fetch_row($res))
{
  echo "$row[0]<br/>";
  }
}

}

catch(Exception $e)
  {
   echo 'OOPS!'.$e->getMessage();
  }

?>

How to save image to database in PHP

noreply@blogger.com (Kashid) — Mon, 3 Jan 2011 02:42:00 -0800

How to upload files(Images / Documents/) to Web pages in PHP ?

This tutorial will show you how to save image to a MySQL database using PHP.

To save an image into database, you need to define a table column as BLOB data type in MySQL

MySQL Query:

Create Database Mydb;

use Mydb;

create table images(sno integer auto_increment primary key,

imgname varchar(20) not null,

thumnail BLOB);

imageform.html

<html><head><title>Storing Uploaded image to Database</title></head>

<p>Select Image file<input type=file name="f1" />

</form>

</body>

</html>

uploadimage.php

<?php

try

{

$loc='./images/'.$_FILES['f1']['name'];

$res=move_uploaded_file($_FILES['f1']['tmp_name'],$loc);

if($res)

echo $_FILES['f1']['name'].' File Uploaded successfuly';

else

{

echo $_FILES['f1']['name'].' File Not Uploaded. Try again';

exit(1);

}

$name=$_FILES['f1']['name'];

$fdata=addslashes(file_get_contents($loc));

$cn=mysql_connect("localhost","root");

mysql_select_db("Internet",$cn);

$query="Insert into images(imgname,thumnail) values('".$name."','".$fdata."')";

$res=mysql_query($query);

if($res)

{

echo "<h3>Thanks! Image saved to Database</h3>";

}

else

{

echo "<h3>Error! Try again</h3>";

include_once("imageform.html");

}

catch(Exception $e)

{

echo 'OOPS!'.$e->getMessage();

}

Coming Soon:
How to read an image from a database using PHP and display it in a Web page?

File Uploading in PHP

noreply@blogger.com (Kashid) — Sun, 2 Jan 2011 03:01:00 -0800

File uploading is easy and well supported by PHP.

There are certain built in functions used to upload files.

$_FILES is an Associative array created by PHP that stores file name, type, size etc

Settings to be done in php.ini configuration file.

Open php.ini file in notepad editor.

1) search for post_max_size and make it as follows

post_max_size = 10M

Maximum size of POST data that PHP will accept.

i.e At the max 10Mb data can be sent from Client to Server via post method.

2) search for file_uploads and make it as follows

file_uploads = On

It determines if HTTP file uploads allowed or not.

3)search for upload_tmp_dir and make it as follows

upload_tmp_dir = "c:/wamp/tmp"

Its Temporary storage for uploaded files.

/* $loc is the location to move uploaded file " ./images/ " means images folder is present in current directory where upload.php file is kept*/

//$loc='./images/'.basename($_FILES['f1']['name']);

selectFile.html

<html>
<body><form action="upload.php" method="post" enctype="multipart/form-data">
Select File to Upload <input type=file name="f1" /><input type=submit value="Upload" />
</form>
</body>
</html>

upload.php
<?php

try
  {
   $loc='./images/'.$_FILES['f1']['name'];
   $res=move_uploaded_file($_FILES['f1']['tmp_name'],$loc);
   if($res)
   echo $_FILES['f1']['name'].' File Uploaded successfuly';
   else
   echo $_FILES['f1']['name'].' File Not Uploaded. Try again';
  }
catch(Exception $e)
{
  echo 'OOPS!'.$e->getMessage();
}

?>

Happy New Year 2011 Greetings

noreply@blogger.com (Kashid) — Wed, 29 Dec 2010 05:57:00 -0800

Wish your near and dear ones a

Happy New Year 2011.

May this new year bring in your Life Happiness,

to explore every joy of life and may all your wishes come true.

More Greeetings Here..>>>.

Slide Menu Design in JavaScript

noreply@blogger.com (Kashid) — Thu, 16 Dec 2010 21:56:00 -0800

Just take mouse on My favorite Blogs and see slider menu

C - Programs
Freehand Designs
My Drawings
Adsense Earnings

JavaScript Code for Menu Design:

Delicious Bookmark

<script>
function showtip()

{
  tip.style.top=navb.style.left;
  tip.style.left=navb.style.left;
  tip.style.visibility = "visible";
}
function hidetip()
{
tm=window.setTimeout("hide();",2000)

}
function hide()
{

tip.style.visibility = "hidden";
}
</script>

<div id="navb" onmouseout="hidetip();" onmouseover="showtip();" style="background: #0b5394; color:

white; font-weight: bold; width: 150px;">
My favorite Blogs</div>

<div id="tip"style="background: #cfe2f3; width: 150px;">
<a href="http://c-programming-free.blogspot.com/">C - Programs</a><br/>
<a href="http://freehanddesigns.blogspot.com/">Free Hand Designs</a><br/>
<a href="http://mymarathi-stuffs.blogspot.com/">My Thoughts/Drawings</a><br/>
<a href="http://increase-adsense-earnings.blogspot.com/">Adsense Earnings</a></div>

Error Handling in PHP

noreply@blogger.com (Kashid) — Thu, 16 Dec 2010 21:08:00 -0800

Delicious

How to Display a Custom Error Page in PHP ?

It is better to store error messages in log files instead of displaying to users.

Settings to be done in php.ini configuration file.

1) Set display_errors to off.

display_errors = Off

Logging errors into a log file in PHP

You can create a log file in which all the errors occured can be stored for further reference.

Insert following code in each PHP page where you want to display custom error page.

<?php
function myhandler($eno,$edesc)
{
include_once('error.html');
echo "Detail: $edesc <br/>";
}
set_error_handler('myhandler');
?>

error.html

<html>
<head>
<style>
body
{
font: 8pt/11pt verdana;
}
</style>
<title>Ohh! Error Ocurred. </title>
</head>
<body>
<div style="border:solid #999;background:#ccefff;width:400px;height:100px">
<h3><span style="COLOR: red; FONT: 18pt/21pt verdana">! Opps </span> The page cannot be

displayed</h3>
<a href="http://kbkashid.blogspot.com">Home Page--> </a>
</div>
</body>
</html>

PHP Simple feedback application

noreply@blogger.com (Kashid) — Sun, 28 Nov 2010 09:24:00 -0800

feedback.html

<html>

<head>
<title>Feedback Page</title>
<style type='text/css'>
table {
background:#dedfff;
font-family:verdana;
}
.strip{background:#7b869c}
</style>
</head><body>
<form action='savefeed.php' method='post'>
<table align=center>
<tr><td >Name<td ><input name=txtname></td></tr>
<tr><td >Email <td ><input name=txtemail></td></tr>
<tr><td >Office address<td ><textarea name=tareaoffice rows=3 cols=30></textarea></td></tr>
<tr><td >Mobile no. <td ><input name=txtmobile></td></tr>
<tr><td >Designation <td ><input name=txtdesignation></td></tr>
<tr><td >Expert areas<td ><input name=txtexpertarea></td></tr>
<tr><td >Comment<td ><textarea name=tareacomment rows=3 cols=30></textarea></td></tr>
<tr class='strip' ><td colspan=2 align="center"><input type='submit' value=submit name='cmdsubmit'><input type='reset' value='clear' name='cmdclr'></td></tr>
</table></form></body></html>

savefeed.php

<?php

if(isset($_POST['txtname']))
{
$cn=mysql_connect('localhost','root');
   mysql_select_db("College",$cn);
   $query="insert into feedback(name,email,addr,phone,desg,expert,comment) values('";
   $query.=$_POST['txtname']."','".$_POST['txtemail']."','".$_POST['tareaoffice']."',".$_POST['txtmobile'].",'".$_POST['txtdesignation']."','".$_POST['txtexpertarea']."','".$_POST['tareacomment']."')";
   $res=mysql_query($query);

   if($res)
   {
   echo "<h3>Thanks! Feedback submitted.</h3>";
   include("http://kbkashid.blogspot.com/");
   }
   else
   {
   echo "<h3>Error! Try again</h3>";
   include("feedback.html");
   }

}
else
{

include("feedback.html");
}
?>

MySQl Queries:
create database college;

use college;

create table feedback(
fedid BIGINT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(20) not null,
email varchar(20) not null,
addr varchar(50) not null,
phone BIGINT(11),
desg varchar(12),
expert varchar(20),
comment varchar(100));

PHP forms Processing

noreply@blogger.com (Kashid) — Wed, 24 Nov 2010 08:50:00 -0800

This tutorial explains How to create forms in HTML and accept /process input from user in PHP.

Accept.html

<html>
   <body>
   <form action="display.php" method="POST">
   Name: <br>
   <input type="text" name="user">
   <br>
  Address: <br>
  <textarea name="address" rows="5" cols="40"></textarea>
  <br>
  Select languages: <br>
  <select name="languages[]" multiple >
  <option>C</option>
  <option>Java</option>
<option>ORACLE </option>
  <option>VB.NET</option>
  </select>

<input type="submit" value="Submit">
  </form>
  </body>
  </html>

Display.php

<?php

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

{

print "Welcome ".$_POST['user']."<br>";

print "Your address is:".nl2br($_POST['address'])."<br>";

print "Your language choices are:<br>";

foreach ($_POST['languages'] as $value) {

print "$value<br>";

}

print $str;

}

Toran (Garland) in C prog.

noreply@blogger.com (Kashid) — Tue, 23 Nov 2010 08:51:00 -0800

#include <stdio.h>
#include <conio.h>
void main()
{
int i=9,j=0,k=1,sp=1;
int ch=1;
clrscr();
for(;i>=1;i--)
   {
   for(j=0;j<=i-1;j++,ch++)
   printf("%d",ch);
if(i!=9)
{
for(k=1;k<=sp;k++)
printf(" ");
sp=sp+2;
}

if(i==9)
  {
   j--;
   ch--;
   }
  for(ch--;ch>=1;ch--)
   printf("%d",ch);
printf("\n");
ch=1;
}
getch();
}

Color Pallet in Swing

noreply@blogger.com (Kashid) — Sun, 21 Nov 2010 09:39:00 -0800

import javax.swing.*;
import java.awt.*;
import javax.swing.event.*;

public class MovingBannerColors extends JApplet implements Runnable,ChangeListener
  {

/*<Applet code="MovingBannerColors.class" height=400 width=400>
   </Applet>
*/
String s;
JLabel lbl;
JColorChooser palete;
public void init()
  {


   Container frame = getContentPane();
   lbl = new JLabel("Welcome to My Blog -*- ");
   frame.setLayout(new BorderLayout());
   palete=new JColorChooser();
   lbl.setFont(new Font("Helvetica", Font.BOLD, 30));
   lbl.setForeground(Color.blue);
   frame.add(lbl, BorderLayout.NORTH);
   frame.add(palete,BorderLayout.SOUTH);

   s= "Welcome to My Blog -*- ";
   palete.getSelectionModel().addChangeListener(this);
   }
   public void stateChanged(ChangeEvent e)
   {

   lbl.setForeground(palete.getColor());
   }




public void start()
  {
Thread t=new Thread(this);
t.start();
}

public void run()
  {
   for(;;)
   {

   try{
   char c=s.charAt(0);
   s=s.substring(1)+c;

   lbl.setText(s);


   Thread.sleep(200);
   }
   catch(InterruptedException e)
   {}

   }
}
}

What's the Time Now ?

noreply@blogger.com (Kashid) — Fri, 19 Nov 2010 10:20:00 -0800

--:--:--

Fibonacci series in JavaScript

noreply@blogger.com (Kashid) — Fri, 12 Nov 2010 23:19:00 -0800

Write a program to accept a no. and print Fibonacci series upto that terms.

<HTML>
<HEAD>

<TITLE>Fibonacci series by Kashid</TITLE>
<script>
function display()
{
  var n=parseInt(frm.t1.value)
  var a=0,b=1,c=0,s=" ";
// document.write("Fibonacci Series: ")
  while((a+b)<=n)
   {
   c=a+b;
   //document.write(c+" ");
   s=s+c+ " , ";
   b=a;
   a=c;

   }

alert("Fibonacci Series: "+s)
}
</script>
</HEAD>
<BODY>
<form name=frm>
  <input type=text name=t1>
  <input type=button name=b1 onclick="display();" value="fibonacci series">
  </form>

</BODY>
</HTML>

Prime no. In JavaScript

noreply@blogger.com (Kashid) — Fri, 12 Nov 2010 23:15:00 -0800

Write a program to accept a no. from user and print whether it is prime or not.

<HTML>

<HEAD><title>Prime no. In JavaScript</title>

function chkprime()

{ var div

var no=parseInt(frm.t1.value)

for(div=2;div<no;div++)

{

if(no%div==0)

break;

}

if(div==no)

alert(no + " is Prime number")

else

alert(no + " Not Prime number")

}

</script>

</HEAD> <BODY>

<form name=frm> Enter A Number:<input type=text name=t1 />

</form>

</BODY>

</HTML>

Largest Persistence among two digit nos.

noreply@blogger.com (Kashid) — Fri, 12 Nov 2010 22:39:00 -0800

Write a program to find a number that has the largest Persistence among two digit nos.
e.g.
n=36→18→8 the persistence of 36 is 2
n=39→ 27→14→4 the persistence of 39 is 3

Find 2 digit no with max persistance

<HTML>
<HEAD><title>Highest Persistance by kbkashid</title>
<script>
function find()
  {
var n,temp,p=1
var cnt=0
var max=0
n=36
   for(i=10;i<=99;i++)
   {
cnt=0
n=i
while(n>=10)
{
p=1
while(n>0)
   {
   p=p*(n%10)
   n=Math.floor(n/10)
   } //while1
   cnt=cnt+1
   n=p
   }//while2

   if(cnt>max)
   {
   max=cnt
   temp=i
   }
   }//for
        alert(" Two digit no: " +temp+" has Max Persistence "+max )
      }
</script>
</HEAD>
<BODY>Find 2 digit no with max persistance
<INPUT type=button value=Find onclick="find();">
</BODY>
</HTML>

Sum of Digits in JavaScript

noreply@blogger.com (Kashid) — Fri, 12 Nov 2010 22:23:00 -0800

Write a program to accept a no. from user and display Sum of Digits.
(example: 214= 2+1+4 = 7)

JavaScript Code:

<HTML><body>
<script>
function find()
  {
var sum=0;
   var no=parseInt(frm.txt1.value);
   while(no>0)
   {
   sum=sum+no%10;
   no=Math.floor(no/10);
   }
   alert("Sum of digits "+sum);

   }
</script>
<form name="frm">

Enter a Number:<input name="txt1" type="text" />
<input name="b1" onclick="find();" type="button" value="display" /></form>
</BODY>
</HTML>

Palindrome in JavaScript (example 212,3443 )

noreply@blogger.com (Kashid) — Fri, 12 Nov 2010 22:15:00 -0800

Write a program to accept a no. from user and check whether Palindrome or not.

<HTML>
<HEAD><title>Palindrome by kbkashid</title>
<script language='JavaScript'>
function chkpalindrome()
   {
   var temp,rev=0
   var no=parseInt(frm.t1.value)
   temp=no
   while(no>0)
   {
   rev=(rev*10)+(no%10)
   no=Math.floor(no/10)
   }
   if(rev==temp)
   alert(temp +" Is Palindrome")
   else
   alert(temp + " Is Not Palindrome")


   }
</script>
</HEAD>
<BODY><form name=frm>
Enter A Number:<input type=text name=t1 /><input type=button value='Is Palindrome' onclick="chkpalindrome();">
</form>
</BODY>
</HTML>

String Functions in PHP

noreply@blogger.com (Kashid) — Thu, 11 Nov 2010 22:40:00 -0800

<?php
if(isset($_POST['t1']))
{
  $st=$_POST['t1'];
echo "String in Proper Case:<b> ";
echo (ucwords(strtolower($st)));
echo "</b><br/>String $st has <b>". strlen( $st ) ."</b> characters<br/>";
echo "String in Lower case <b>" . strtolower($st)."</b><br/>";
echo "String in Upper case <b>" . strtoupper($st)."</b><br/>";
echo "String Reversed <b>" . strrev($st)."</b><br/>";
}

?>

<html>
<body bgcolor='#cccfaa'><form name='frm1' method='post'>
Enter any String:<input type='text' name='t1' />
<input type='submit' value='String functions' /></form>
</body>
</html>

**Note:
   1) strlen( $st ) : returns no. of characters in a String
    2) strtolower( $st ) : returns lowercase String
   3) strtoupper( $st ) : returns uppercase String
   4) strrev( $st ) : returns reverse of a String

ASP refers to Active Server Pages.

noreply@blogger.com (Kashid) — Wed, 10 Nov 2010 22:56:00 -0800

ASP refers to Active Server Pages.

ASP is a server side scripting technology.
ASP file has .asp extension.

Database Connectivity in ASP:

ASP and SQL sever:

<%@ Language=VBScript %>
<%
Dim cn, str, rs
set cn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "driver={SQL Server};" & _
"server=SQLservername;" & _
"uid=admin;" & _
"pwd=nopass;" & _
"database=payroll;"
cn.Open
Response.Write "Got Connection"
set rs = Server.CreateObject("ADODB.Recordset")
str = "Select * from emp"
rs.open strsql,cn
do while not rs.eof
   Response.Write rs(1)
   Response.Write rs(2) & "<br/>"
loop
rs.close
%>

ASP and Ms-access:

<%@ Language=VBScript %>
<% dim cn , rs , str
   set cn = Server.createobject("adodb.connection")
   p= Server.mappath("payroll.mdb")
   cn.open "provider=microsoft.jet.oledb.4.0;data source=" & p
   set rs = Server.createobject("adodb.recordset")
   str = "select * from emp"
   rs.open strsql,cn

do while not rs.eof
   Response.Write rs(1)
   Response.Write rs(2) & "<br/>"
loop
rs.close
%>

ASP and Oracle:

<%
   dim cn
   Set cn = Server.CreateObject("ADODB.Connection")
   cn.Open "dsn=dsnfororacle;"
   'We have to create a DSN (Data Source Name) for Oracle.
   'Rest is same as above
   %>

Reading XML file in PHP

noreply@blogger.com (Kashid) — Wed, 10 Nov 2010 22:10:00 -0800

XML is Extensible Markup Language used to Exchange Data.
Here is an example of reading XML file in PHP.

ReadXML.php

<?php
echo "Reading XML File<br/>";
$content=simplexml_load_file("msg.xml");

foreach($content as $key=>$value)
echo "<h4>$key : $value</h4>";

?>

msg.xml

<?xml version="1.0"?>
  <message>
   <To>Visitors</To>
   <From>http://kbkashid.blogspot.com</From>
   <Subject>Thanks for Visiting!</Subject>
   <Body>Hi! My Blog is entirely dedicated for guys interested in innovative programming and to have fun with it!</Body>
  </message>

Free Hand Designs

noreply@blogger.com (Kashid) — Mon, 8 Nov 2010 07:38:00 -0800

India has ancient Tradition of Rangoli, mostly popular among womens.

Generally Rangoli is created on the floor, but it is also

created on walls, papers etc.

Colored powders are used to draw Rangoli.

Charming and Beautiful Flower Wallpapers:

People send beautiful flowers to express their feeling,

emotions and Love.

Celebration of festivals is an integral part of our Life

Related Topics:

My entry in Windows And Me contest

noreply@blogger.com (Kashid) — Sat, 6 Nov 2010 22:09:00 -0700

Idea of 7:

Capture any thing that resembles 7 in your camera.

Upload photo on the wall and put caption / slogan.

Participate in Contest>>>

I participated in this contest with my entry as below.

An electric switch has put on My mind's bulb (dimag ki batti jal gaye) and I found 7 in It.

Related Post: