Category Archives: MySQL

Socio-Academic Online Portal Review of Related Literature

Socio-Academic Online Portal Review of Related Literature

Socio-Academic Online Portal Review of Related Literature

Review of Related Literature and Studies

This chapter talks about the review of related literature of the developed Socio-academic Web Portal for administrators, students, teachers, faculty and staff and stakeholders of ACADEMIC INSTITUTION. Concepts that focused on the development and design issues of Social Networking was also discussed here.

Web Portal

A web portal is most often one specially-designed Web page at a website which brings information together from diverse sources in a uniform way. Usually, each information source gets its dedicated area on the page for displaying information (a portlet); often, the user can configure which ones to display. A portal may use a search engine API to permit users to search intranet content as opposed to extranet content by restricting which domains may be searched. Apart from this common search engines feature, web portals may offer other services such as e-mail, news, stock quotes, information from databases and even entertainment content. Portals provide a way for enterprises and organizations to provide a consistent look and feel with access control and procedures for multiple applications and databases, which otherwise would have been different web entities at various URLs. The features available may be restricted by whether access is by an authorized and authenticated user (employee,member) or an anonymous site visitor. (http://en.wikipedia.org/wiki/Web_portal)

Healthcare Home Information System for Senior Citizen Related Systems and Studies

Healthcare Home Information System for Senior Citizen Related Systems and Studies

Healthcare Home Information System for Senior Citizen Related Systems and Studies

REVIEW OF RELATED SYSTEM

          This article discussed the related systems, and the technical background of the study. The developers conducted through review of some related topics to make the study more reliable. In according this study, they made some researches from different related studies for them to come up with their own study.

Technical Background

The developers worked on C# considering that it is the most applicable and recommended language in developing a system. C# is used to create and develop running environment and program of the developed system .Visual Studio 2017 is a programming language and development environment created by Microsoft, which provides a graphical user interface (GUI) that allows the developer to drag and drop objects into the program as well as manually write program codes. C# is a powerful and flexible programming language. Like all programming languages, it can be used to create a variety of applications. Your potential with C# is limited only by your imagination. The language does not place constraints on what you can do. C# has already been used for projects as diverse as dynamic Web sites, development tools, and even compilers.

Census Monitoring Application in PHP and MySQL

Census Monitoring Application in PHP and MySQL

Census Monitoring Application in PHP and MySQL

Introduction

Census by definition is the compilation of records such as demographic profile, poverty profile, economic profile, social services and facilities etc. in order to get the census data of the community they need to conduct a survey to get the information they need.

Census Monitoring Application is an advance and automated process of managing the census monitoring in a certain community, to let go the manual process such as, hand written documents, keeping records inside the drawer that tends to lose some records. It is automated in such a way that all records of census monitoring can be keep and search via browsers. This system will facilitate management by enabling the clients/residents to just search the web site and enjoy all the information about the census monitoring.

City Social Welfare and Development Office Data Archiving Information System

City Social Welfare and Development Office Data Archiving Information System User Interface

City Social Welfare and Development Office Data Archiving Information System

Introduction

The existing technology of City Social welfare and Development Office Data archiving Information System is adequate enough for implementation of the new software. City Social welfare and Development Office Data archiving Information System can only be accessed by an authorize user. Authorize users are prompt by the system to enter the username and password. The system administrator is the one who is allowed to provide user access to other users of the system.

On the software development and implementation of City Social welfare and Development Office Data archiving Information System, the researchers e employed the modified waterfall model in which is seen as the flowing steadily downwards (like waterfall) through the phases of conception, initiation analysis, design, construction, testing, production, implementation and the maintenance.

MySQL Tutorial – Like clause

MySQL Tutorial – Like clause

Like clause in a CREATE TABLE command will create an exact copy of your existing table. The newly copied or created table will also acquire the column definition or attributes of the original one.

Syntax of like clause:

CREATE TABLE nameOfNewTable LIKE nameOfExistingTable;

Where:

nameOfNewTable – the name of the new table to be created.

nameOfExistingTable – the name of the existing table in your database.

Restore MySQL database using PHPMyAdmin

phpMyAdmin is a free software tool written in PHP, it is a browser-based platform used to manage and administer MySQL database.

On the previous tutorial we have learned how to create a backup of our databases using the mysqldump command. Now we are going to reestablish or restore our database to its previous state.

Backup MySQL database on WAMP

Backup MySQL database on WAMP

In this tutorial we are going to learn how to back up our MySQL database in WAMP using the mysqldump command.

mysqldump command is used to export a database or all databases that resides on your MySQL Server. The exported file has an extension of .sql which commonly consists of SQL commands to create a database, create tables and insert records into tables.

Here’s how to create a backup file using the mysqldump command

  1. Click Start > Run then type cmd and hit enter.
  2. Syntax: C:\wamp\bin\mysql\[mysql version]\bin\mysqldump -u root -p [database_name] > [path where you want to put the file and the filename]
  3. Type this command: C:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump -u root -p dk> c:\dk.sql

MySQL ALTER Command

In this lesson we are going to learn how to use the MySQL alter command.

There are lots of Graphical User Interface (GUI) Tools to manage our MySQL databases as discussed on this page (link), through that modifying the structure of a database as well as the structure of tables, the field data types and much more depending on the capability of that tool. All of that comes in a handy way because these tools has a drag and drop capability. The users can easily change the data types of a certain field, rename a table, and add new columns. In this lesson we are not going to tolerate those manners (drag, drop and click).

MySQL SHOW Command

MySQL SHOW Command

SHOW command is used to learn more about the databases found in the server, tables found in a database, and specific information about the columns or fields within a table.

Let’s take a look on the uses and examples of the SHOW Command.

We want to know the databases that reside on our MySQL server, to do that issue the command:

mysql>show databases;
+----------+
| Database |
+----------+
| mysql    |
| sample   |
| test     |
+----------+
3 rows in set (0.14 sec)

Note: the results may vary depending on the stored databases on your system.

Drop Database and Table in MySQL

Dropping the Database

To delete an entire database, use the DROP DATABASE command. This command will delete the database and the tables inside it. Let’s try some example:

Syntax of DROP DATABASE command:

DROP DATABASE database_name;

Where: database_name is the name of the database you want to drop or delete.