wintekweb infoplus

Wednesday, October 31, 2012

Dairy products

Dairy products

Drinking Products

flavored milk
Drinking Yogurt
Milk Wine
Lassie
Ghee

Semi Solid products

Yogurt(Set Yogurt,Stared Yogurt,Fruit Yogurt etc)
Ice Cream
Quark
Butter
Quark
Chakka
Spread cheese
Curd
Milk Tofu

Solid products

Milk Toffee
Burfi
Kova
Chena
cheese
Ackawi

Friday, October 19, 2012

Create PDF PHP

Create PDF PHP

You can create PDF File using PHP Scripts.First you have to download library file for PDF creation from here.
then create following PHP file and see the result

<?php
require('fpdf.php');
$PDF = new FPDF();

$PDF->AddPage();
$PDF->SetFont('Arial', 'B', 16);
$PDF->Cell(40, 10, 'welcome to wentekweb

infoplus');

$PDF->Output();
?>

PDF file will be generated and downloaded to your browser download folder

Thursday, October 18, 2012

When you are running a large MYSQL applications, you have handle lots of unwanted data rows. it will be created problem in database overload. So that I want to explain how to delete such data in regular intervals using MySQL event scheduler.It also can be used to update data base table auto backup etc.

I have used table customer used in previous lessens in my_database create it using following MYSQL dump

CREATE TABLE IF NOT EXISTS `customer` (
`customer_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_name` varchar(100) NOT NULL,
`product_id` int(11) NOT NULL,
PRIMARY KEY (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`customer_id`, `customer_name`, `product_id`) VALUES
(1, 'Harfer', 2),
(2, 'Taylor', 3),
(3, 'Jones', 1),
(4, 'Lopez', 4),
(5, 'Bayker', 5),
(6, 'wonne', 8),
(7, 'hare', 9),
(8, 'Martin', 3);

Then move the my_database and open SQL tab and write following query to delete the 2nd record in table customer in 2 minutes.

SET GLOBAL event_scheduler = ON; CREATE EVENT myEvent ON SCHEDULE EVERY 24 HOUR STARTS CURRENT_TIMESTAMP + INTERVAL 2 MINUTE DO DELETE FROM cart WHERE id=2;

miscellaneous

Miscellaneous

In Addition to the PHP, Java Scripts and MySQL, I found some FAQs which are useful in gaining your knowledge on different subjects.

Importance of Twitter Followers

Make Forex Trading Easy

Dairy Products

Mobile phones sharing bacteria and mites

Popular Mobile Phones

Herbal Remedy for Cancer

Important free softwares

Popular PC Games

Saturday, October 13, 2012

Convert numbers to words php

Convert numbers to words php

PHP Function convert a numbers to string of English words

You can submit a number by using following form

<tbody><tr bgcolor="#ffffff"><td><form method="post" action="pw.php">
         <input name="num" type="text"></form></td><td></td></tr>
         <tr bgcolor="#ffffff">

 <td><input value="number in words" type="submit"></td><td></td></tr></tbody>

------------------------------------------------------------------------------------------------------------------------------
Returns value as follows
1000000 = one million
Back to try

<?php

$nwords = array( "", "one", "two", "three", "four", "five", "six",
                "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen",
                "fourteen", "fifteen", "sixteen", "seventeen", "eightteen",
               "nineteen", "twenty", 30 => "thirty", 40 => "fourty",
                     50 => "fifty", 60 => "sixty", 70 => "seventy", 80 => "eigthy",
                     90 => "ninety" );

function number_to_words ($x)
{
     global $nwords;
     if(!is_numeric($x))
     {
         $w = '#';
     }else if(fmod($x, 1) != 0)
     {
         $w = '#';
     }else{
         if($x < 0)
         {
             $w = 'minus ';
             $x = -$x;
         }else{
             $w = '';
         }
         if($x < 21)
         {
             $w .= $nwords[$x];
         }else if($x < 100)
         {
             $w .= $nwords[10 * floor($x/10)];
             $r = fmod($x, 10);
             if($r > 0)
             {
                 $w .= ' '. $nwords[$r];
             }
         } else if($x < 1000)
         {

                $w .= $nwords[floor($x/100)] .' hundred';
             $r = fmod($x, 100);
             if($r > 0)
             {
                 $w .= ' '. number_to_words($r);
             }
         } else if($x < 1000000)
         {
            $w .= number_to_words(floor($x/1000)) .' thousand';
             $r = fmod($x, 1000);
             if($r > 0)
             {
                 $w .= ' ';
                 if($r < 100)
                 {
                     $w .= ' ';
                 }
                 $w .= number_to_words($r);
             }
         } else {
             $w .= number_to_words(floor($x/1000000)) .' million';
             $r = fmod($x, 1000000);
             if($r > 0)
             {
                 $w .= ' ';
                 if($r < 100)
                 {
                     $word .= ' ';
                 }
                 $w .= number_to_words($r);
             }
         }
     }
     return $w;
}

// demonstration

if(isset($_POST['num']))
{
    echo '<center>';
     echo '
     '.htmlspecialchars($_POST['num']).' = '.number_to_words($_POST['num']).'<p>
     <a href="'.$_SERVER['PHP_SELF'].'">Back to try</a></center>';
}else{
     echo '
     <table bgcolor=#8087bc align=center><tr bgcolor=#ffffff><td><form method="post" action="'.$_SERVER['PHP_SELF'].'">
         <input type="text" name="num"><td></tr>
         <tr bgcolor=#ffffff><td><input type="submit" value="number in words"><td></tr></table>
     </form>';
}

?>

Web page background color change js

Web page background color change js

By using following java script file your page background color change with the time

<html>
    <head>
    <script type="text/javascript">
    var c=-1;
    var tmr;
    ntimer=1000;
    var ArrColor=new Array();
    ArrColor[0]="#d4f0ba";
    ArrColor[1]="#badbf0";
    ArrColor[2]="#f1bb87";
    ArrColor[3]="#de87f1";
    ArrColor[3]="#172bbe";
    function showpos()
    {
    if(c==3) c=0;
    else c++;
    if(ntimer<=5) ntimer=1000;
    else ntimerntimer = ntimer-5;
    document.body.style.backgroundColor=ArrColor[c];
    clearTimeout(tmr);
    tmr=setTimeout("showpos()", ntimer);
    }

    tmr=setTimeout("showpos()", ntimer);
    </script>
    </head>

    <body>
    <center>Background color change</center>
    </body>
    </html>

By using following java scripts you can also change web page background images also.make folder called"images" and download 3 suitable images for background and rename images as image1.jpg,image2.jpg & image3.jpg

<html>
<head>
<style>
body {
    margin: 0;
    padding: 0;
    background-color: #000;
    background-image: url('images/image1.jpg');
                     background-attachment: fixed;
    background-repeat: no-repeat;
    background-position: center 0;
}
.img1 {background-image: url('images/image1.jpg');}
.img2 {background-image: url('images/image2.jpg');}
.img3 {background-image: url('images/image3.jpg');}
</style>
<script language="JavaScript1.2">
var inc=1
var numImages=3
function bgSlide() {
if(inc > numImages) inc=1
document.body.className="img"+inc
inc++
}
</script>
</head>
<body onload="setInterval('bgSlide()',6000)">
</body>
</html>

Thursday, October 11, 2012

Dropdown - On change redirect to another page

Drop down - On change redirect to another page

visitors to go to a particular page when they select any option from the dropdown list or from select box which will redirect users to the particular url when the select any option from it.

<html>
</body>
<select name="test" onchange="gotourl(this.value)">
<option value="#">Select the Site </option>
<option value="http://www.google.com/">Google</option>
<option value="http://www.yahoo.com/">Yahoo</option>
<option value="http://wintekweb.blogspot.com/2012/05/simple-counter-php.html/">Wintekweb</option>
</select>
<script language="JavaScript" type="text/javascript">
function gotourl(url){
window.location= url;
}
</script>
</body>
</html>