The Most Trusted and #1 Blog for Pinoy Online Resource that is posted interesting topic like, entertainment, viral, news, WordPress Web Development, Android Phones, Apple Phones, PC Games Reviews, Movie Topics, Job Hiring, and latest Weather Update.
Hello friends, happy New Year to you all. I am posting this project to this platform
To express my deep appreciation to the management of Sourcecodester, Raj Shama whose
Insightful programming ideas have as well been of great and invaluable help to me in my programming adventure and to all of the members of the forum who share there ideas. I thank you all.
The project is written in vb.net 2010 as front end with sql server 2008 as back end. You can use Admin as the user name and admin as password. Though there is a user account to log in which give less application right as that of the admin, check this out in the database table ITM_ACOCUNT. Remember to change the connection string to match yours.
The application manages the items returned to an establishment for after sales service/repair. It is my wish that others too, learn from this, though not very perfect, but you can improve it.
In this tutorial, we will create a simple registration form using MySQLi prepared statement. it is an advanced and secured kind of script to prevent MySQL injection threat. Due to depreciated of MySQL most of the website are required to use MySQL / PDO statement. Now be prepared, let's start coding
1. We open the database server, then type localhost/phpmyadmin
2. Then name the database "sample"
3. After creating the database, click SQL and paste the code below
After setting up the database, we will create the HTML form, The code below will display a simple registration form. To create a form, open any kind of text editor (notepad++, etc.). Then copy the code below, paste it inside the body tag, name it "index.php"
<div id ="content">
<form method ="POST" action ="submit_query.php">
<td><input type ="text" name ="username" required ="required"></td>
<td><input type ="password" name ="password" required ="required"></td>
<td colspan ="2"><br /></td>
<td colspan ="2"><button style ="width:100%;" name ="save">Save</button></td>
Then, we will add some design for the form, just copy and paste it inside the head tag
Next, we will create the database connection, just copy the code below, then name it "connect.php"
die("Fatal Error: Can't connect to database: ".$conn->connect_error);
Lastly, we will now create the script for saving the data from the HTML form. The code below holds the data that has been input in the HTML form, then it will directly send to database server. Just copy the code below, then name it "submit_query.php"