Insert and Load Data In PHP without Refreshing the Page

Insert and Load Data In PHP

Insert and load data in php 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 () {

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 a programmer for their thesis system, or anyone who needs source code in any programming language, just contact us.

Technology stack and requirements

To run this PHP project, you need these tools on your development machine:

• XAMPP or WAMP server. Bundles Apache, MySQL, and PHP so you can run PHP on Windows without individual installs. Free from apachefriends.org.
• PHP 8.0 or higher. Included with XAMPP. Older versions (5.x, 7.x) may work but modern PHP features improve security and performance.
• MySQL or MariaDB. Comes with XAMPP. phpMyAdmin manages the database through a browser UI.
• VS Code or PhpStorm. Free code editor with PHP syntax highlighting, IntelliSense, and debugging support.
• Web browser. Chrome, Firefox, or Edge for testing the running app.

Installing the source code

1. Download the archive. Get the ZIP file from the download link on this page and extract it.
2. Move to htdocs. Place the extracted folder inside C:\xampp\htdocs\ so Apache can serve it.
3. Import the database. Open http://localhost/phpmyadmin, click Import, and select the .sql file included in the archive.
4. Update database credentials. Open the config.php or connection.php file and set the correct database name, username, and password (default XAMPP: root / empty password).
5. Run the project. Start Apache + MySQL in XAMPP, then visit http://localhost/your-project-folder/ in a browser.

Using this project for your BSIT capstone

This PHP project maps cleanly to standard BSIT capstone documentation. Suggested chapter alignment:

• Chapter 1 (Introduction). Discuss the problem the system solves in real-world context. Cite Philippine business or academic use cases where a manual process could be replaced.
• Chapter 2 (Review of Related Literature). Compare this system’s features against 5-10 similar published projects. Cite journals like IJERT or IEEE Access for academic-standard sources.
• Chapter 3 (Methodology). Include Use Case Diagram, Data Flow Diagram, Entity Relationship Diagram, and Activity Diagram covering all major workflows.
• Chapter 4 (Results and Discussion). Screenshot each module of the running system with a caption explaining what data it processes and which user role interacts with it.
• Chapter 5 (Conclusion and Recommendations). Identify features that could be added in a Version 2, such as mobile app, REST API export, or AI-powered analytics.

Modules typical of Insert and Load Data

• Master data. CRUD forms for the primary entities with search and filter.
• Transaction processing. Data entry forms for day-to-day operations the system automates.
• Reports. Formatted printable output summarizing activity per day, user, or category.
• User management. Login with role-based permissions (Admin, Encoder, Viewer).
• Backup and restore. Export database to a .sql file and restore when needed.

Common enhancements for capstone review

• Modernize the UI. Add Bootstrap 5 or Tailwind CSS for a polished appearance.
• Add printable receipts. Use TCPDF or FPDF to generate PDF reports.
• Multi-user concurrency. Ensure database handles simultaneous writes without lost-update errors.
• Rewrite in Laravel. Migrate to Laravel for maintainability and modern development patterns.

Related PHP Projects

• Insert And Display Data In PHP MySQL Without Refreshing Page
• Delete Data In PHP MySQL Without Refreshing Page
• CRUD In CodeIgniter Using AJAX With Source Code
• Load Data Scrolling Page jQuery AJAX PHP
• PHP Insert Multiple Records Into MySQL
• Insert Multiple Image PHP MySQL