Posts

Showing posts with the label php

Online gallery database

Image
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 a...
Post a Comment
Read more

Popular posts from this blog

Setting up data set and display it

Before we display some data in DataGridView control in Visual Basic window we must create a data set. Data Set is an object that can hold data tables where all the data is stored in rows and columns. the first step is to create a table. Dim  dataTableObjectName as DataTable = New DataTable(tableName) this will create a table which is reference using the dataTableObjectName Example Dim userTable As DataTable = New DataTable("Users") Next step is adding columns to the table Dim column as DataColumn dataTableObjectName.Columns.Add (columnName, columnType) Example userTable.Columns.Add("userID", Type.GetType("System.Int.32")) ' adding second and third column userTable.Columns.Add("userName", Type.GetType("System.String")) userTable.Columns.Add("userContact", Type.GetType("System.String")) once we we columns in the table we can add row The rows contains records or the data for each user. dat...
Read more

Bootstrap 4

Image
Bootstrap provides CSS classes to style your webpages on the go. This saves a lot of time building web page. Before start  we need to  either download the bootstrap and include them in project or refer to bootstrap CDN. Copy and paste following, that links to bootstrap.min.css beta version 4.2 (latest version as of 5 Jan 2019) <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css"> Also copy and paste following javaScript <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js" ></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js"></script> Template The template showing where to place the link to bootstrap CSS and javascripts. <!doctype html> <html lang="en"...
Read more

Object and Class

Image
When creating a class imagine the objects that will be created from that class. To design your class consider this: what are the things that object has this is known as the instance variable   What are the actions that object can do . this is methods Following is a UML diagram depicting a class design This Movie class has two instance variables: title and producer. Value of this variable is unique for an object. We also can say that any two movies have different state because there are no two movies have same title and producer. The methods contain operation to work on the data of the object. A pair of method like setTitle() and getTitle() are also known setter and getter method. The purpose of this pair of method is to give or assign the value for an instance variable and to take or retrieve current value of the instance variable. Class and object A class is not an object. It is used for building and object. A class is a blueprint for an obj...
Read more