• Monthly Archives: June 2011

QR code

after almost 10 day absence i’m here again  with a new post .i bet that with seeing post  photo you guess today story , yes today i want to write about QR barcode .QR Code (Quick Response code)  is a barcode that Nowadays you can see it in many places such as products packs , newspaper ,etc … . in this article I will write about this Barcode . QR Code (Quick Response code) was created by Toyota subsidiary Denso-Wave in 1994,it is a matrix barcode and dedicates readers are able to read it  and it can be consist information such as text, URL, or other data.for example I want to explain one of common usages of QR code you can see this barcode in magazines, on signs, buses, business cards and you just need a camera phone for scan and decode it  may this barcode content be a URL and it will direct you to a website ,may it’s content be a wireless connection information or any text and information .below you can see QR code Structure

… Read More

DOS commands & some tips & trick

DOS (disk operation system ) is oldest Microsoft operation system a boring and dark environment that you must type commands for do anything .may you say with coming new OS  with nice graphic interfaces we don’t need to use DOS but you must know DOS commands power is still alive and in some case is very very usefull than new OS tools and software for example many commands of Network management such as ping ,ipconfig ,…

… Read More

Do you need suggestion for choose better domain ,or product Name ?

it’s very difficult  when you want choose a name for your website or your product , certainly this subject happened for you too and at this time you need to many suggestions and may ask your friends to give some suggestion about name today i want to intorduce a online tool that you give your favored title him and this tool will suggest you many name . this online tool name is ” Panabee ” it is a brainstorm engine for naming domains, mobile apps, and products . have a look and find your desired domain name today . click here for visit site

Easy to Understand Php Code for Connect MySql DB & Store Data in and Get Report

in this post we will learn how , with a short php code we can connect My sql Db and send Query to it . first of all you need to go your host control panel and make mysql Db or you can do it in phpmyadmin however to create a mysql db is in control panel is easier than to open it in php my admin .then you must assign a user that have permission to access to Db then you need to remember 3 thing Dbname – Db username – Db user password now let’s go to code  in below code . this code is written and  tested by myself but if you got trouble in below codes comment me under this post .

Source code of Html form that we will fill it’s fields

————————————————————–

<html >
<head>
</head>
<body>

<p><a href=”read.php”>Click Here for Get report from DB</a></p>

<form action=”insert.php” method=”post”>
<p><strong><font size=”2″ face=”Georgia”>Adiniz :&nbsp;    <input name=”firstname” type=”text” /></font></strong></p>
<p><strong><font size=”2″ face=”Georgia”>
Lastname :<input name=”lastname” type=”text” /></font></strong></p>
<p><strong><font size=”2″ face=”Georgia”>age :</font></strong>:<input name=”age” type=”text” /></p>
<p><input type=”submit” /></p></form>
</body>
</html>

—————————————————————–

after press in submit buttoon This code will get all filled data in html form and will send it to DB you must put this file name insert.php beauce in above code in form action it’s insert.php if you like you can rename file but you must changes it’s name in form action too

——————————————————————

<?php
$con = mysql_connect(“localhost”,”your database user name “,”your database password “);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

mysql_select_db(“Your database name“, $con);

$sql=”INSERT INTO info (name, family, age)
VALUES
(‘$_POST[firstname]’,’$_POST[lastname]’,’$_POST[age]’)”;

if (!mysql_query($sql,$con))
{
die(‘Error: ‘ . mysql_error());
}
echo “Your Information “;

mysql_close($con)
?>

above codes learn us how to get information from user and send it for save in Db but now may you ask how we can see stored information in our Db . in this part we will make a read.php file and put below code in it . if you attantion in html form code there is a highligted red line this is a link that when youclick on it read.php file will run and will send some queries to Mysql DB for get report

—————————————————————————–

<?php
$con = mysql_connect(“localhost”,”your database username”,”your database password “);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

mysql_select_db(“your database Name“, $con);

$result = mysql_query(“SELECT * FROM  your database Table Name “);

echo “<table border=’1′>
<tr>
<th>name</th>
<th>family</th>
<th>age</th>
</tr>”;

while($row = mysql_fetch_array($result))
{
echo “<tr>”;
echo “<td>” . $row[‘name’] . “</td>”;
echo “<td>” . $row[‘family’] . “</td>”;
echo “<td>” . $row[‘age’] . “</td>”;
echo “</tr>”;
}
echo “</table>”;

mysql_close($con);
?>