Good Day blogger,
Today I will teach you how to Insert data from mobile app to MySQL Server.
How this program work? look at this flow chart.
ok lets start.
Step1: Create your HTML File and name it index.html and inside of html file are these.
<html>a little explanation.
<head>
<title>Imperial Softwares</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="themes/imperialsoft.min.css" />
<link rel="stylesheet" href="themes/jquery.mobile.icons.min.css" />
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.css" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.js"></script> <script>
$(function(){
$('#btnSubmit').click(function(){
var Lname = $("#txtLastname").val();
var Fname = $("#txtFirstname").val();
var Add = $("#txtAddress").val();
$.ajax({
type: 'POST',
//change the url for your project
url: 'http://192.168.1.83/mobile/save.php', //Url of your php file
data: 'lastname='+Lname+'&firstname='+Fname+'&address='+Add, //parameters of you software
success: function(data){
alert('Your comment was successfully added');
}
});
return false;
});
});
</script>
</head>
<body>
<div data-role="page" id="LoginPage" data-theme="d">
<div data-role="header" >
<h1>ISS Tutorial</h1>
</div>
<div role="main" class="ui-content">
<div id="landmark-1" data-landmark-id="1">
<form>
<h2><u>Insert data in MySQL</u></h2>
<label for="txtLastname">
<b>Lastname</b>
<input type="text" id="txtLastname" name="txtLastname">
</label>
<label for="txtFirstname">
<b>Firstname</b>
<input id="txtFirstname" name="txtFirstname" />
</label>
<label for="txtAddress">
<b>Address</b>
<textarea id="txtAddress" name="txtAddress"></textarea>
</label> <br />
<input type="submit" value="Submit" id="btnSubmit">
</form>
</div>
</div>
</div>
</body>
</html>
$.ajax({
type: 'POST',
//change the url for your project
url: 'http://192.168.1.83/mobile/save.php', //Url of your php file
data: 'lastname='+Lname+'&firstname='+Fname+'&address='+Add, //parameters of you software
success: function(data){
alert('Your comment was successfully added');
}
});
this is the ajax script that you will use to be able to throw a request to your data server.
I put paramater so that my php script can get what data will be return.
Step 2: Create a PHP File and name it save.php, inside of PHP File are these. take note this file should be place on your webserver in WAMP (C:/wamp/www), in LAMP (var/www/html), in XAMPP (C:/xampp/htdocs).
<?phpStep 3: Create your Database and Data Table in data server.
$server = "locahost";
$username = "root";
$password = "lester";
$database = "test";
$con = mysql_connect($server, $username, $password) or die ("Could not connect: " . mysql_error());
mysql_select_db($database, $con);
$lname = $_POST["lastname"];
$fname = $_POST["firstname"];
$add = $_POST["address"];
$sql = "INSERT INTO tbluser (lastname, firstname, address) ";
$sql .= "VALUES ('$lname','$fname', '$add')";
if (!mysql_query($sql, $con)) {
die('Error: ' . mysql_error());
} else {
echo "Data added";
}
mysql_close($con);
?>
CREATE DATABASE IF NOT EXISTS test;
CREATE TABLE `tbluser` ( `id` int(10) unsigned NOT NULL auto_increment,
`lastname` varchar(255) default NULL,
`firstname` varchar(255) default NULL,
`address` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
Thank you blogger! Help me to share it. :)
Follow me for more topic I will share. and visit my facebook page.
www.facebook.com/AskCompTutor
