Wanna be a Geek: July 2011

Sunday, July 10, 2011

Connect to database with XML HTTP Connection (POST)

Ok, last time I've show you how to use XML HTTP Connection with GET method. Now I'll show you the other method, using POST method. Ok, first, using the same HTML file, but we need to edit the Javascript.. Here is the HTML file for post method

<div id="test2" onClick="getIt('test2')">
2
</div>
<div id="test1" onClick="getIt('test1')">
1
</div>

Using the same database like before, and the same PHP file, but we need to change some code on it. This is for the PHP file.

<?php
$username="mysqlusername";
$password="mysqlpassword";
$database="xml";
$field1=$_POST['field1'];

$con= mysql_connect("localhost","root","");
mysql_select_db($database) or die("unable to select the database..");
if($con)
{
echo "Result of".$field1." \n";
$query="select * from dummydata where id=$field1";
$res=mysql_query($query);
$done=mysql_fetch_array($res);
  if($done['content']!=null)
    {
    echo $done['content'];
    }
  else
    {
    echo "error";
    }
}
else
{
echo "Invalid login information!";
}

mysql_close($con);
?>

Ok, that's all, test it and you'll get the same result like before ;)

Wednesday, July 6, 2011

Connect to database with XML HTTP Connection

This time, I want to share about XMLHttpConnection. I learn this thing because I need it to develop my (first) BlackBerry application. What is the purpose of XMLHttpConnection? With XMLHttpConnection, I can request a connection in background without reloading the page (something like that). Nah, I tried it and it was successful. Now, it's time to share. I'll show you step by step.

note: this XMLHttpConnection example using GET method. For POST method, I'll post it later.

First, let's create a simple HTML file. This is my HTML file with some JavaScript code:

<script type="text/javascript">
function getIt(xx){
var get= parent.document.getElementById(xx);
if (window.XMLHttpRequest)
 {// code for IE7+, Firefox, Chrome, Opera, Safari
 xmlhttp=new XMLHttpRequest();
 }
else
 {// code for IE6, IE5
 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
 }
xmlhttp.open("GET","http://localhost/xmlcon/connect.php?field1="+get.innerHTML,false);
xmlhttp.send();
alert(xmlhttp.responseText);
xmlhttp.close();
}
</script>
<html>
Simple XML HTTP Request
<body style="font-size: 3em">
<div id="test2" onClick="getIt('test2')">2</div>
<div id="test1" onClick="getIt('test1')">1</div>
</body>
</html>

Save as main.html and test it in my localhost and the result is like this:

Pages

Sunday, July 10, 2011

Connect to database with XML HTTP Connection (POST)

Wednesday, July 6, 2011

Connect to database with XML HTTP Connection