Online gallery database

In previous post, message sent by visitor does not get stored in database. To use database we need PHP to get the data, connect to database and save the data there in database. Database that we are going to use is MySQL. Easiest and quickest way too use PHP and MySQL is to install XAMPP.

After install your XAMPP copy the gallery folder, into server htdoc folder. Now type localhost/gallery/home.html URL in your browser. The browser should be able to open the gallery home page. Make sure you have started Apache and MySQL from XAMPP control panel.

Before saving the message from visitor into database, we have to create a database first. To do that, go to phpMyAdmin page and create a database called gallery.

 After the database is created, create a table called messageTable. Below is the entity diagram that represent the table.

Next, create a PHP file in the gallery folder. Open notepad and type the following code. Save the file as saveMessaageToDatabase.php and select All Files as file type.
<?php

$conn = mysqli_connect("localhost","root","");

if($conn){
echo "connected";
}else{
echo "Error" . $conn->connect_error;
die();
}

mysqli_select_db($conn, 'gallery');

$subject = $_POST['subject'];
$message =  $_POST['messaage'];

$sql = "INSERT  INTO messageTable (subject, message)". 
"VALUES ('$subject', '$message')";

$retVal = mysqli_query($conn, $sql);

if($retVal){
echo "message is stored succesfully";
}else{
echo "Error : ".$conn->error;
}
mysqli_close();
?>

We need to pass the data from contact form to this PHP file. To do that, open contact.html, add following code in in existing form tag.

 <form name = "contactForm" action = "saveMessageToDatabase.php">


Now, every time visitor enter information and submit the form, the data will go to this PHP and messages will be saved in your database. To check if the messages are saved, go to phpMyAdmin page and refresh the table. New messages should be entered to you database.

As exercise, include field for visitor name and email address. We should also include date and time the message was sent to you through your website.

Comments

Post a Comment

Popular posts from this blog

Drawing Simple Pie Chart

Image
To draw pie chart with 5 sectors. The program calculates the total of all the input given by user and find the angle in degrees to draw each sectors. When the program first loads, chart based on default values is painted by the program. User can edit the values in the text field and presses draw button to redraw the chart. Each time the draw button is pressed, new set of angle is calculated and repainted. I have attached the the sources for this program. It is simple and needs upgrades. Pie.java This class executed the program and initializes the components JTextField and JPanel to draw the chart. package coolApp.graphics; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class Pie { JTextField a,b,c,d,e; JButton btnDraw; double total; JPanel contentPane; Pie(){ JFrame frame = new JFrame("Pie - CoolApps"); frame.setSize(500,500); contentPane = new JPanel(); contentPane.setLayout(new BorderLayout()); frame
Read more

VB.net connecting to SQL Server

Connecting to SQL server 2014 from VB.Net 2017, read values from the database and display the data in windows form. Before begin to write this program, first we need to import SqlClient class. Imports System.Data.SqlClient Step 1 Create a sql connection object. This is to make connection to object. Dim conn As New SqlConnection() Step 2 Set the connection string to the sqlconnection object: conn.ConnectionString = connStr Road block The variable connStr is a connection string. Connection object need connection string to make connection to database. It has information like who providing the database, the name of the database and some security information. Dim connStr As String = "Data Source = ServerInstanceName;Initial Catalog=testDB;Integrated Security=True" Let's break down the connection string into the three main components. Dim provider As String = "ServerInstanceName;" Dim database As String = "Initial Catalog=testDB;" Dim
Read more

VB.net

a quick and convenient way to build a window based application. basically there is two main components in VB, the design view where we place the controls on a window form. then we have the code view where we write implementation for each controls on the form. Typically the control implementation or procedures are executed when certain events happens to the controls. Events like mouse click, or value change on text box, form load, form close and so on. After working with programming language like C, C++ and Java, getting use to VB is a bit challenging. its because first of all, VB don't use curly bracket to specify code blocks, and the statements don't end with semicolon. variable declaration for example is written as dim age As Integer in C, C++ and Java it written int age; in VB, variable declaration start with dim keyword, it means dimension and the functions are written as Function addNumber(ByVal num1 As Integer, ByVal num2 As Integer) As Integer addNumber
Read more