Insert and Load Records without Refreshing the Page.

0
510

loadInsertJqueryInsert and load records in the database are used when creating a system. In php, there are two pages (design and process) that are usually used in inserting and loading records in the database. This process may load long enough but with the use of jQuery and Ajax it will instantly insert and load the records in just a click.

 

In this project, we are going to use MySQL for the database.

 

Below are the step by step process in making this project:

 

  • Create a MySQL database and name it “dbuser”.
  • Do the following query for creating a table in the MySQL database that you have created.

[mysql]

CREATE TABLE IF NOT EXISTS tblusers (
user_id int(11) NOT NULL AUTO_INCREMENT,
user_name varchar(40) NOT NULL,
user_username varchar(40) NOT NULL,
user_pass varchar(90) NOT NULL,
PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

[/mysql]

  • These are the codes that we’re going to use in our configuration that bridge between MySQL database and PHP script.

[php]

<?php
$server = ‘localhost’;
$dbuser = ‘root’;
$dbpass = ”;
$dbname = ‘dbuser’;
$con = mysql_connect($server, $dbuser, $dbpass);
if (isset($con)) {
# code…
$dbSelect = mysql_select_db($dbname);
if (!$dbSelect) {
echo “Problem in selecting database! Please contact administraator”;
die(mysql_error());
}
} else {
echo “Problem in database connection! Please contact administraator”;
die(mysql_error());
}
?>

[/php]

  • Create a design to input and load records in the MySQL database. Name the file “index.php”.

[php]

<?php include ‘config.php’; ?>
<!– bootstrap extension –>
<link rel=”stylesheet” type=”text/css” href=”css/bootstrap.min.css”>
<!– container –>
<div class=”container” >
<!– for inputs –>
<div class=”row”>
<div class=”form-horizontal span6″>
<div class=”row”>
<div class=”col-lg-12″>
<h1 class=”page-header”>Add New User</h1>
</div>
</div>

<div class=”form-group”>
<div class=”col-md-8″>
<label class=”col-md-4 control-label” for=
“U_NAME”>Name:</label>

<div class=”col-md-8″>
<input name=”deptid” type=”hidden” value=””>
<input class=”form-control input-sm” id=”U_NAME” name=”U_NAME” placeholder=
“Account Name” type=”text” value=””>
</div>
</div>
</div>

<div class=”form-group”>
<div class=”col-md-8″>
<label class=”col-md-4 control-label” for=
“U_USERNAME”>Username:</label>

<div class=”col-md-8″>
<input name=”deptid” type=”hidden” value=””>
<input class=”form-control input-sm” id=”U_USERNAME” name=”U_USERNAME” placeholder=
“Email Address” type=”text” value=””>
</div>
</div>
</div>

<div class=”form-group”>
<div class=”col-md-8″>
<label class=”col-md-4 control-label” for=
“U_PASS”>Password:</label>

<div class=”col-md-8″>
<input name=”deptid” type=”hidden” value=””>
<input class=”form-control input-sm” id=”U_PASS” name=”U_PASS” placeholder=
“Account Password” type=”Password” value=”” required>
</div>
</div>
</div>

<div class=”form-group”>
<div class=”col-md-8″>
<label class=”col-md-4 control-label” for=
“idno”></label>

<div class=”col-md-8″>
<button class=”btn btn-primary btn-sm” id =”submit” type=”submit” >Save</button>
</div>
</div>
</div>
</div>

</div>
<!– end inputs –>

<!– for listing –>
<div class=”row” >
<h1 class=”page-header”>List of Users</h1>
<div class=”table-responsive ” >

<table class=”table table-striped table-bordered table-hover table-responsive” style=”font-size:12px” cellspacing=”0″>
<thead>
<tr>
<th>Account Name</th>
<th>Username</th>
<th>Encrypted Password</th>
</tr>
</thead>
<tbody class=”loaddata” >
<?php
$sqlQuery = “SELECT * FROM tblusers“;
$result = mysql_query($sqlQuery) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
echo ‘<tr>’;
echo ‘<td>’ .$row[‘user_name’].'</a></td>’;
echo ‘<td>’. $row[‘user_username’].'</td>’;
echo ‘<td>’. $row[‘user_pass’].'</td>’;
echo ‘</tr>’;
}

?>
</tbody>

</table>
</div>
</div>
</div>
<!– end listing –>
</div>

[/php]

[javascript]

<!– jquery extension –>
<script type=”text/javascript” src=”jquery/jquery.min.js”></script>

<!– method for saving and retrieving data without refreshing the page. –>
<script type=”text/javascript” >

$(document).on(“click”, “#submit”, function () {
/* load all variables */
var name = document.getElementById(‘U_NAME’).value
var username = document.getElementById(‘U_USERNAME’).value
var pass = document.getElementById(‘U_PASS’).value

$.ajax({ //create an ajax request to load_page.php
type:”POST”,
url: “process.php”,
dataType: “text”, //expect html to be returned
data:{u_name:name,user_name:username,password:pass},
success: function(data){
$(“.loaddata”).html(data);

}

});

});
</script>

[/javascript]

  • Finally, do this following code for inserting the data in the MySQL database. Name the file “process.php”.

[php]

<?php
include ‘config.php’;
/* set a query for inserting records */
$sqlQuery = “insert into tblusers (user_name, user_username, user_pass)
VALUES (‘”.$_POST[‘u_name’].”‘,'”.$_POST[‘user_name’].”‘,sha1(‘”.$_POST[‘password’].”‘))”;
/* execute the query */
$result = mysql_query($sqlQuery) or die(mysql_error());
/* checking if the query has successfully executed. */
if ($result==1) {
/* set a query for retrieving the data .*/
$sqlQuery = “SELECT * FROM tblusers“;
/* execute the query */
$result = mysql_query($sqlQuery) or die(mysql_error());
/* loop the executed query */
while ($row = mysql_fetch_array($result)) {

echo ‘<tr>’;
echo ‘<td>’ .$row[‘user_name’].'</a></td>’;
echo ‘<td>’. $row[‘user_username’].'</td>’;
echo ‘<td>’. $row[‘user_pass’].'</td>’;
echo ‘</tr>’;

}
}
?>

[/php]

 

For all students who need programmer for your thesis system or anyone who needs a sourcecode in any programming languages.  You can contact me @ :

 

Email – [email protected]

Mobile No. – 09305235027 – tnt

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.