Skip to main content

Transferring data from a web form to a database

STEP 1: HTML FORM

 <body>
<h2>Data Form</h2>
<form action="info.php" method="post">//Data entered is redirected to 'info.php' page
Name:<input type="text" name="name" size="60" />
<br /> <br />
E-mail:<input type="text" name="email" size="60" />
<br /> <br />
<input type="submit" name="submit" value="Submit" />
</form>

</body>

 STEP 2: PHP

 <body>
<?php 
//Connecting to a database
$servername="localhost";
$username="root";
$password="";
$dbname="info";

 $connect=mysqli_connect("$servername","$username","$password","$dbname");

 if (mysqli_connect_error())
{
die("Database connection failed: ". mysqli_connect_error());
}
else {
echo "Created connection successfully";
}

 $info = "INSERT INTO userinfo (name, email) 
VALUES ('$_POST[name]', '$_POST[email]')"; //to be inserted to the table called 'userinfo','name' and 'email' fields

 if ($connect->query($user_info)==TRUE){
echo "Record added successfully";
}
else{
echo "Error: ".$user_info.$connect->error;
}

 $connect-> close();

?>

Labels:

Comments

Post a Comment

Popular posts from this blog

Fixing 'java RMI - ConnectException: Operation timed out' in WSO2 Enterprise Integrator 6.4

If you ever come across the below exception when running WSO2 Enterprise Integrator 6.4, here is the fix. This error occurs when you have multiple IP addresses from different networks configured in your etc/hosts as below. 10.xxx.x.xxx localhost 192.xxx.x.xxx localhost So simply, removing the unnecessary one and leaving the one of the network that you are currently connected to should resolve this issue. 10.xxx.x.xxx localhost
Post a Comment
Read more

Student Information System - Java (SLIIT - ST2 PROJECT)

Student Information System (Github Project) This system is developed in Java and mySQL as a group project by me and 3 other members during a period of 1 month. The system allows the administrator to,  enroll students to the system  update enroll information  add/update course and degree program details  generate reports  create exams and edit relevant information  calculate gpa of the relevant exam  assign lecturers to courses  add lecturers/update details Lecturers to,  assign course grades  view their feedback  generate reports  view student / course / degree program details Students to,  view their profile  view their grading information  give feedback to lecturers   view lecturer / course / degree program details and other features. Below are some interfaces of the project. (Splash Screen) (Login) (Admin View) (Student Re...
Post a Comment
Read more

SIMPLE BLACKJACK GAME IN JAVA (CONSOLE)

import java.util.Scanner; class BlackJack{     public static void main(String[] args)      {         int player_random1 = 100;         int player_random2 = 100;         while(player_random1 >= 12 || player_random2 >= 12  || player_random1 < 3 || player_random2 <3)         {             player_random1 = (int)(Math.random()*100);             player_random2 = (int)(Math.random()*100);         }                  int player_total = player_random1 + player_random2;                  System.out.println("You get a "+player_random1+" and a "+player_random2);         System.out.println("Your total is "+player_total); if(player_total==21)  ...
Post a Comment
Read more