PHP - USER INTERFACE
Hello All...
welcome every one. I'm going to start PHP lectures for Very Beginners, who
wants to learn PHP from very beginning. No matter if you do not have any basic
programming concept. If you follow my tutorials I hope you will surely get some
how good knowledge of PHP.
Today our
Topic is
USER INTERFACE (UI)
User
interface is like a link between a computer and user that let’s user know how
to use a system without getting confused about its usage. It allows user and
the system to communicate with each other. User Interface (UI) controls how the
instructions are entered as input into the system and how the system presents
the information on the screen as output.
There are
two types of User Interface.
i.
Command Driven Interface (CDI)
ii.
Graphical User Interface (GUI)
CDI is
text-based interface where user types commands through keyboard. All the
previous work of MySQL that is the clear example of CDI. Where we had to type
commands and find the results.
GUI is type
of interface that allows user to control computer’s inputs, storage and output
through graphical elements. In GUI we do not need to type any of the command
you can control your commands via user interface.
The main
purpose of adding this topic into the lectures is that whatever we have done
using MySQL console all that we can de using a GUI based tool, where we do not
need any type of commands to be written, just control our requirement using
graphical elements.
phpMyAdmin is the best GUI option for
organizing and managing our MySQL databases. It’s very easy to understand and
easy to use. This tool comes along with wamp/xampp server when you install any
of these. Here is how you can open phpMyAdmin.
For wamp
user: just click on the green icon of the wamp server, you will find
phpMyAdmin
and click on that. As shown in image.
Following
are the steps of how you will create tables and insert records in your tables
shown via images hope you will surely get the concept about how you can use
phpMyAdmin.
After you
created the database, you need to create the table and number of fields/columns
you want to have in it.
When you click on go
a table named students will be created with 3 number of columns. After that you
will be asked to enter name of columns with some other information as shown in
figure:
Here are the
three columns that we were asked previously while creating a table in image
there are the column names student_id with type integer, student_name and
student_address with type varchar. Length of fields is also required to give for
VARCHAR maximum length is 255 and usually this length is given but if you don’t
give length to any Integer value by default it will take 11. As student_id is
always taken as an Integer type of value and it is important to check the auto
increment option as circled in above image. After that when you filled these
important requirement click Save button at the bottom or if you want to add one
more column you can click on Go button.
When you
click on Save button, below given window will appear, that will ask you to
insert values in those columns.
As shown in
image if you leave empty to student_id that was done auto increment previously
MySQL will automatic insert values that will start from 1. As you can see there
are two buttons Go. If you click on first button only one value will be
inserted if you click on second button both of the values will be inserted.
After clicking the button if you click on browse option at the top of screen,
you will find both of records that were inserted. As shown below.
If you want
to insert more records you can insert by clicking on the insert option and it
will start with the same process of inserting record. And more you can edit and
also delete your record as mentioned in image. These were the main and
important tasks that are necessary for using phpMyAdmin. Further you can try by
yourself for more actions and if you got any questions of confusions feel free
to ask here.
Thanks Guys.
Any thing missing or any question from this topic you can comment below, I will
be trying to solve and answer your question.
Our next
topic will be `PHP-DATABASE`
Good Luck J
No comments:
Post a Comment