Membuat CRUD dengan PHP part 1

Hallo bloger kalian pasti tau yang namanya PHP ,PHP adalah sebuah kode program yang digunakan untuk membuat web , salah satumya yaitu sebuah sistem informasi berbasis web adalah SIAKAD ( SISTEM INFORMASI AKADEMIK ) yang biasanya dipakai oleh sekolah atau kampus. Kode yang digunakan ada yang menggunakan PHP NATIVE (murni).

Disini saya akan membuat Aplikasi CRUD menggunakan PHP NATIVE. Saya menggunakan MYSQLI dan dengan database mysql. Yang kita butuhkan yaitu xampp kemudian saya menggunakan sublime sebagai editornya.

Ikuti langkah langkannya ya

1. Pertama kita aktifkan dulu,aktifkan Apache dan MySQL

2. Kemudian kita buat database nya dengan nama 17090002. Saya membuat 2 tabel yaitu user dan data.

user

data

3. Kemudian kita membuat koneksi menggunakan PHP dengan nama koneksi.php dan taruh pada folder aplikasi_pendaftaran(atau folder dengan nama sesuai keinginan)

4. lalu kita buat halaman desaign dengan menggunakan boostrap css dan js.anda bisa download.Buatlah folder dengan nama css dan js didalam folder aplikasi_pendaftaran. Taruhlah boosttrap.min.js , jquery.min.js , jquery-ui.min.js pada folder js dan bootstrap.css , bootstrap.min.css , jqueryui.css , jquery-ui.min.css pada folder css.

5. kemudian kita buat file dengan nama index.php

Read More

Section 1-2

Application Development Foundations 2019 Learner

1. Which of the following best describes the SQL Workshop within Application Express?   
  Provides tools to view and manage database objects and data. (*)
2.Oracle Application Express Architecture Tiers can be identified as which of the following?  
   Database Tier. (*)   
   Browser. (*)  
    Mid Tier. (*)
3. In Application Express, an Application is best described as which of the following?  
    An HTML interface that exists on top of database objects such as tables or procedures. (*)
4. The Mid Tier of the Oracle Application Express Architecture is which of the following services   
    Oracle REST Data Services (*)
5. Oracle Application Express employs a 3 Tier Architecture?   
    True (*)
6. Packaged Applications include a collection of sample applications which demonstrate some of the major features of Oracle Application Express?   
    True (*)
7. Which of the following are tools that enable you to view and manage database objects in the SQL Workshop?
    All of the above. (*)
8. racle Application Express includes the SQL Workshop for application developers to maintain database objects? 
  True (*)
9.Which of the following best describes Object Browser within SQL Workshop?
   Enables developers to browse, create, and edit objects in a database. (*)
10.The Create Application Wizard enables developers to design create whch of the following Oracle Application Express application types?
    Desktop and Mobile Database Applications (*)
    Packaged Applications (*)
    Websheet Applications (*)
11.Which of the following best describes the From a spreadsheet option within App Builder?
    Creates a table based on the spreadsheet data and then application with a report and a form is created. (*)
12.Which of the following best describes a Websheet Application within App Builder?
     Are interactive web pages that combine text with data (*)
13.Which of the following best describes the Application User Interface within App Builder?
     Supports multiple user interfaces within a single application. (*)
14. Which of the following best describes Packaged Applications within App Builder?
     Include a set of business productivity and sample applications which can be installed with just a few clicks. (*)
15.  Which of the following best describes Desktop and Mobile Database Applications within App Builder?
      The user interface is optimized for larger displays, such as desktop, laptop and tablet screens. (*)

The User role of End user can perform which of the following in Application Express?

Run existing Applications. (*) Which of the following best describes the App Builder within Application Express?         Provides tools create the pages that make up an Oracle Application Express application. (*) In Application Express User roles are best described as which of the following?         Divided in to four primary roles. (*) In Application Express, a Workspace is best described as which of the following?         A logical work area which is associated with one or more Oracle database schemas. (*) Which of the following best describes Packaged Apps within Application Express?         Provides a suite of business productivity applications, easily installed with only a few clicks. (*) Oracle Application Express includes the SQL Workshop for application developers to maintain database objects?         True (*) Which of the following types of applications can be created using App Builder?          Websheet applications. (*)         Database applications. (*) Which of the following best describes SQL Commands within SQL Workshop?       Enables developers to use SQL Commands to create, edit, view, run, and delete database objects. (*)

Read More