Cara Membuat CRUD Dengan PHP Dan MySQL

Pada kesempatan kali ini saya mau membagi ilmu yang merupakan masih dasar apakah itu CRUD?  merupakan singkatan dari Create, Read, Update dan Delete. CRUD merupakan salah satu inti dari sebuah pemrograman karena di dalam suatu program biasanya mencakup operasi Create atau menciptakan data, Read atau Menampilkan data, Update atau mengedit suatu data dan Delete atau menghapus data.

Pada kesempatan kali ini saya akan mencoba untuk membahas bagaimana cara membuat sebuah aplikasi sederhana dan cara menerapkan operasi CRUD.

     Langkah pertama yang harus dilakukan adalah membuat database. 

1. DATABASE

Dalam tutorial kali ini, kita buat database dengan nama "database" dengan tabel is_siswa, seperti contoh gambar dibawah ini

2. config.php atau koneksi

Setelah membuat atau sudah memiliki database MYSQL langkah selanjutnya ialah membuat koneksi php. Di sini koneksi ke database akan berjalan dengan nama "config" dan user database. Buatlah file dengan nama "config.php", seperti script dibawah ini :

3. index


digunakan untuk membuat sebuah direktori atau wadah dari aplikasi

Buatlah file dengan nama "index.php",

seperti script dibawah ini :

4. from-tambah.php
 from ini digunakan untuk mengimputkan tambah data baru. dengan cara menginputkan datanya. 

Buatlah file dengan nama "from-tambah.php", seperti script dibawah ini :

jika sudah membuat form-tambah.php maka tampilannya seperti ini:

5. form-ubah.php
File ubah.php digunakan untuk melakukan proses edit/uptade data, file ini menampilkan form yang sama dengan form tambah.php, form edit.php ini berfungsi mengambil data yang akan kita edit didalam database. 

Buatlah file dengan nama "from-ubah.php", seperti script dibawah ini :

maka akan memberikan tampilan

6. proses-hapus
proses hapus digunakan untuk menghapus data yang ingin dihapus. jika telah dihapus maka data tersebut akan hilang dari database

tampilan dari hapus data adalah sebagai berikut. terdapat notifikasi apakah data tersebut ingin dihapus

7.  proses-simpan
proses simpan digunakan untuk menyimpan semua data yang telah terisi dalam tambah data maupun update data. 

Buatlah file dengan nama "proses-simpan.php", seperti script dibawah ini :

tampilan dari proses simpan data adalah sebagai berikut:
data akan tersimpan secara otomatis

8. proses-ubah
untuk memproses ubah data yang ada di database

9. tampil-data
tampil data digunakan untuk menampilkan seluruh tampilan data diawal.

tampilan datanya adalah sebagai berikut

Section 6 Quiz

1. Which of the following statements best describes how Trees are implemented?

Using multiple queries that identify the rows to be used as the start of your query, and the relationships between parent rows and child rows of the hierarchy.


Using a single hierarchical query that identifies the row to be used as the start of your query, and the relationship between parent rows and child rows of the hierarchy. (*)


Using a single query that identifies the row to be used as the start of your query.


None of the above.


2. Which of the following calendar types Calendar is based on the FullCalendar jQuery library?

Calendar. (*)


Custom Calendar.


Legacy Calendar.


User Calendar.


All of the above.

3. A tree is a hierarchical navigation mechanism?

True (*)

False

4. Application Builder supports which of the following types of charts?

(Choose all correct answers)


Chart. (*)


AnyChart Chart. (*)


CustomChart Chart.


All of the above.


5. Application Builder includes a built-in wizard for generating a tree that displays a hierarchical view? Mark for Review
(1) Points


True (*)

False
6. A Dynamic Action can be specified to fire on which of the following events?

(Choose all correct answers)


User Event


Component Event (*)


Browser Event (*)


Framework Event (*)


Custom Event (*)


7. Change, Click, Double Click, Get Focus, and so on would best describe which type of Dynamic Action Event? Mark for Review
(1) Points


Component Event


Browser Event (*)


Framework Event


Custom Event


8. A plug-in is one of the built-in types of Application Express?


True

False (*)


9. Developers can only use a plug-in in the workspace it is created for?

True

False (*)




10. The use of a Dynamic Action will increase your overall page size?

True (*)

False
11. A plug-in is an extension to the built-in types of Application Express?

True (*)

False


12. The Table and Trigger Definitions required by an APEX application is saved as which of the following file types?
.xml


.sql (*)


None of the above.


13. Which of the following are the correct order of steps to migrate an application between environments?


Export, Populate Tables, Recreate Objects, Import, Test.


Export, Import, Recreate Objects, Populate Tables, Test. (*)


Export, Import, Populate Tables, Recreate Objects, Test.


Export, Recreate Objects, Populate Tables, Import, Test.


14. When exporting an APEX application which of the following are not captured?
(Choose all correct answers)


Application definition.


Underlying database objects. (*)


Data associated with the application. (*)


All of the above.


15. Which of the following are steps required when migrating an application between environments?

Export.


Import.


Recreate Objects.


Populate Tables.


Test.


All of the above. (*)

Section 5 Quiz

1. Which of the following statements best describe Navigation Menu as a Shared Component?

A list of links that enables users to navigate the pages in an application. Only supported in applications using the Universal Theme - 42. (*)


An effective way to navigate users between pages in an application. You can create two types : standard or parent.


Provide users with hierarchical navigation. A hierarchical list of links that display using templates. Can be displayed as a list of links or as a path.


A shared collection of links. You control the appearance through templates. Each element has a display condition that enables you to control when it displays.


Offer users a simple navigation path for moving between pages in an application. Entries can display as a link from an image or text.


2. Which of the following statements best describe Tabs as a Shared Component?


A shared collection of links. You control the appearance through templates. Each element has a display condition that enables you to control when it displays.


A list of links that enables users to navigate the pages in an application. Only supported in applications using the Universal Theme - 42.


Provide users with hierarchical navigation. A hierarchical list of links that display using templates. Can be displayed as a list of links or as a path.


Offer users a simple navigation path for moving between pages in an application. Entries can display as a link from an image or text.


An effective way to navigate users between pages in an application. You can create two types : standard or parent. (*)


3. Which of the following are examples of Navigation Aids in Shared Components?


Navigation Menu.


Breadcrumbs.


Navigation Bar Entries.


Tabs.


Lists.


All of the above. (*)


4. Which of the following statements best describe Lists as a Shared Component?


A shared collection of links. You control the appearance through templates. Each element has a display condition that enables you to control when it displays. (*)


Provide users with hierarchical navigation. A hierarchical list of links that display using templates. Can be displayed as a list of links or as a path.


Offer users a simple navigation path for moving between pages in an application. Entries can display as a link from an image or text.


A list of links that enables users to navigate the pages in an application. Only supported in applications using the Universal Theme - 42.


An effective way to navigate users between pages in an application. You can create two types : standard or parent.


5. Shared components are common elements that can display or be applied on any page within an application?

True (*)

False

6. Which of the following statements best describe Breadcrumbs as a Shared Component?

An effective way to navigate users between pages in an application. You can create two types : standard or parent.


A list of links that enables users to navigate the pages in an application. Only supported in applications using the Universal Theme - 42.


A shared collection of links. You control the appearance through templates. Each element has a display condition that enables you to control when it displays.


Provide users with hierarchical navigation. A hierarchical list of links that display using templates. Can be displayed as a list of links or as a path. (*)


Offer users a simple navigation path for moving between pages in an application. Entries can display as a link from an image or text.


7. Oracle Application Express supports which of the following preconfigured authentication schemes?

Application Express Accounts


Database Accounts


LDAP Directory


Custom


All of the above. (*)


8. You can apply an authorization scheme for?

An entire application


A page in an application


A specific control such as a region, item, or button


All of the above. (*)


9. Authentication may require a user to?


Enter a user name and password.


Provide a digital certificate.


Provide a secure key.


All of the above. (*)


10. Which of the following Access Control would be set to enable all users access to an application?

Full access to all (*)


Restricted access


Public read only


Administrative access only

11. Application Builder supports which of the following types of charts?

(Choose all correct answers)


Standard Themes. (*)


User Themes.


Custom Themes. (*)


All of the above.



12. Which of the following themes can a Workspace administrator create?

Standard Themes.


User Themes.


Custom Themes. (*)


All of the above.


13. The Theme Roller offers the workspace administrator the ability to?

(Choose all correct answers)


Share customizations with other administrators through a gallery.


Modify attributes and see changes applied to your in real time. (*)


Save customizations as a Theme Style. (*)


Use customizations designed by other administrators from a gallery.


Customize the look and feel of applications. (*)


14. Developers can use template options to?

(Choose all correct answers)


Upload custom background Images.


Apply different colors or accents. (*)


Render buttons in different styles. (*)


Apply different spacing and padding. (*)



[Incorrect] Incorrect. Refer to Section 5 Lesson 2.


15. Which of the following are features of the Universal Theme?

(Choose all correct answers)


Easy Customization. (*)


Versatile UI. (*)


Responsive Design. (*)


Requires extensive Javascript Knowledge.


Requires extensive CSS Knowledge.

Section 4 Quiz

1. Forms are application components that are used for data input from end users?

True (*)

False

2. Application Builder provides which of the following form types?


Form on a Procedure.


Editable Interactive Grid.


Form on Web Service.


Two Page Master Detail.


Form on a Table.


All of the above. (*)


3. Which of the following statements best describes an Single Page Master Detail Application Builder form type?

presents users a set of data in a searchable, customizable report.


Creates two pages. One page displays a report.


Creates a form that enables users to update a single row in a database table.


Builds a single page report and form combination based on tables you select. (*)


4. Forms are made up of fields, called items?
True (*)


False


5. A master detail form reflects a one-to-many relationship between two tables?
True (*)


False
6. Which of the following statements best describes an Form on a Table Application Builder form type?

Builds a single page report and form combination based on tables you select.


Creates a form that enables users to update a single row in a database table. (*)


presents users a set of data in a searchable, customizable report.


Creates two pages. One page displays a report.


7. In Application Builder, you cannot use buttons to perform a Dynamic Action?

True


False (*)



[Incorrect] Incorrect. Refer to Section 4 Lesson 2.


8. Which of the following actions can be carried out in Application Builder using a button page item?

Do nothing. (*)


Redirect.


Submit a page.


All of the above.



[Incorrect] Incorrect. Refer to Section 4 Lesson 2.


9. Which of the following are types of Items in Application Builder?

Application items


Authentication Scheme


Page items


Shared Components


All of the above (*)


10. A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item?

True (*)


False

11. Validations that apply to an entire page in Application Builder are defined as which of the following?

Page Item Validation.


Page Validation. (*)


Application Control Validation.


Page Control Validation.


12. When you create a branch, you must specify a Branch Point and Branch Type?


True (*)


False




13. In Application Builder, a branch can be defined to go to which of the following?

A specific page


A procedure


A URL


All of the above (*)


14. In Application Builder, a branch is an instruction to go to a specific page, procedure, or URL?

True (*)


False


15. The process to insert, update, or delete records into a single database table or updateable view in Application Builder is defined as which of the following? Mark for Review
(1) Points


PL/SQL Row Processing.


SQL Row Fetch.


Automatic Row Processing. (*)

Section 3 Quiz

1. When viewing an interactive report, end users can customize how and what data displays?

True (*)

False

2. An interactive grid presents users a set of data in a searchable, customizable report?

True (*)

False


3. A classic report is the formatted result of a SQL query?

True (*)

False


4. End users have the ability to apply sorting and simple filtering to a classic report?

True (*)

False


5. Which of the following best describes the Messages tab within Page Designer in App Developer?


Displays a visual representation of the page regions, items, and buttons that define a page.


Displays user interface elements and application logic by component type.


Displays errors and warnings you need to address. (*)


Displays attribute specific help.


None of the above.
6. The Code Editor within Page Designer is used to edit attributes requiring a large amount of code?

True (*)

False


7. Which of the following best describes the Component View tab within Page Designer in App Developer?

Displays a visual representation of the page regions, items, and buttons that define a page.


Displays user interface elements and application logic by component type. (*)


Displays errors and warnings you need to address.


Displays attribute specific help.


None of the above.


8. Which of the following best describes a Non-Modal Dialog Page Mode within App Builder?

An overlay window positioned within the same browser window.


A separate popup browser window. (*)


None of the above.

[Incorrect] Incorrect. Refer to Section 3 Lesson 1.


9. By default, an Interactive Grid controls can be used to alter the layout of report data by which of the following methods?

Applying filters


Highlighting


Selecting columns


Sorting (*)


All of the above


10. Developers can determine whether an interactive grid is editable or read-only?

True (*)

False

11. Interactive reports enable end users to create highly customized reports?

True (*)

False



12. Which of the following can be defined by the developer for an Interactive Report?

Control if and how users save the report.


Configure the Search bar.


Create error messages.


Configure supported views.


All of the above. (*)



13. When using an interactive report, developers can change the way an interactive report is rendered to end users?

True (*)

False


14. When using an interactive report, end users can create both row and column filters?

True (*)

False


15. Which of the following are components of an interactive report?
Actions menu.


Column heading menu.


Link to custom target.


Saved reports.


Search bar.


All of the above. (*)

Section 1 Quiz

SECTION 1

1. Which of the following best describes Packaged Apps within Application Express?

Provides tools create the pages that make up an Oracle Application Express application.


Provides tools to view and manage database objects and data.


Provides the ability to manage the full lifecycle of your application development.


Provides a suite of business productivity applications, easily installed with only a few clicks. (*)


None of the above.


2. The User role of End user can perform which of the following in Application Express? Mark for Review
(1) Points


Create and Edit Applications.


Sign into Workspace.


Run existing Applications. (*)


Perform Administration Tasks.


Manage entire hosted instance.


All of the above.



[Incorrect] Incorrect. Refer to Section 1 Lesson 2.


3. Which of the following best describes Team Development within Application Express?

Provides tools create the pages that make up an Oracle Application Express application.


Provides tools to view and manage database objects and data.


Provides the ability to manage the full lifecycle of your application development. (*)


Provides a suite of business productivity applications, easily installed with only a few clicks.


None of the above.

4. Packaged Applications include a collection of sample applications which demonstrate some of the major features of Oracle Application Express? Mark for Review
(1) Points


True (*)


False


5. Oracle Application Express employs a 3 Tier Architecture? Mark for Review
(1) Points


True (*)


False
6. The User role of Developer can perform which of the following in Application Express? Mark for Review
(1) Points

(Choose all correct answers)


Create and Edit Applications. (*)


Sign into Workspace. (*)


Run existing Applications. (*)


Perform Administration Tasks.


Manage entire hosted instance.


All of the above.



[Correct] Correct



Section 2
(Answer all questions in this section)

7. Which of the following best describes SQL Commands within SQL Workshop? Mark for Review
(1) Points


Enables developers to use SQL Commands to create, edit, view, run, and delete database objects. (*)


Enables developers to browse, create, and edit objects in a database.


Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL.


Enables developers to use SQL Scripts to create, edit, view, run, and delete database objects.


Enables the declarative specification of RESTful services used to access the database.



[Correct] Correct


8. Oracle Application Express includes the SQL Workshop for application developers to maintain database objects? Mark for Review
(1) Points


True (*)


False



[Correct] Correct


9. Which of the following best describes Utilities within SQL Workshop? Mark for Review
(1) Points


Enables developers to browse, create, and edit objects in a database.


Enables the declarative specification of RESTful services used to access the database.


Enables developers to use SQL Commands to create, edit, view, run, and delete database objects.


Enables developers to build SQL queries, load and unload data from an Oracle database, generate DDL. (*)


Enables developers to use SQL Scripts to create, edit, view, run, and delete database objects.



[Correct] Correct


10. Which of the following best describes the Accept Page within App Builder? Mark for Review
(1) Points


Performs any computations, validations, processes, and branching. (*)


Is a logical construct that establishes persistence across page views.


Supports multiple user interfaces within a single application.


Is the basic building block of an application.


The URL that displays in your browser which indicates the location of your Oracle Application Express application.



[Correct] Correct
11. Which of the following best describes the From scratch option within App Builder? Mark for Review
(1) Points


Allows you to assemble an initial set of application pages including blank, reports, and forms. (*)


Creates a table based on the spreadsheet data and then application with a report and a form is created.


Creates a copy of an existing database application.


None of the above.



[Incorrect] Incorrect. Refer to Section 2 Lesson 2.


12. Which of the following best describes a Websheet Application within App Builder? Mark for Review
(1) Points


Is the basic building block of an application


Supports multiple user interfaces within a single application


Is a collection of pages linked together using navigation menus, tabs, buttons, or hypertext links


Are interactive web pages that combine text with data (*)



[Correct] Correct


13. Which of the following best describes Packaged Applications within App Builder? Mark for Review
(1) Points


The user interface is optimized for larger displays, such as desktop, laptop and tablet screens.


Enable users to build data centric applications without any SQL programming knowledge.


Include a set of business productivity and sample applications which can be installed with just a few clicks. (*)


None of the above.



[Correct] Correct


14. You use an HTML Editor to build the pages that and them import them using App Builder to make up an Oracle Application Express application? Mark for Review
(1) Points


True


False (*)



[Correct] Correct


15. Which of the following best describes an Accept Page within App Builder? Mark for Review
(1) Points


Is a logical construct that establishes persistence across page views.


Is the basic building block of an application.


Performs any computations, validations, processes, and branching.


Supports multiple user interfaces within a single application.


The URL that displays in your browser which indicates the location of your Oracle Application Express application.


None of the above. (*)

MATERI PAK YOKA

MATERI POWER POINT