Lab 3 Codes Explanation

      main.html
      http://mdad.atspace.cc/products/main.html



DB_CONNECT
This php file is to be used by other PHP pages to connect to Database
http://mdad.atspace.cc/products/db_connect.php







http://mdad.atspace.cc/products/get_all_products.php



http://mdad.atspace.cc/products/searchProduct.php

http://mdad.atspace.cc/products/addProduct.php

Comments

Post a Comment

Popular posts from this blog

Simple Login Example (PHP Server + Android Client)

Image
  Simple Login Example I have created this simple Login Example and intentionally leave it as the kind of login that is subject to hacking using SQL injection technique. I will discuss on SQL injection later. XAMP server side (PHP) Database create table users(     userid varchar (20) primary key ,    password varchar (80) not null ); insert the data userid as 'test' and password as '1234' for testing INSERT INTO `users`(`userid`, `password`) VALUES ('test','1234') PHP Step 0: Create    db_connect.php (  Refer to Lab2) Step1 :Create a  loginTest.php <<< Server Side>>>  loginTest.php          <?php // check for post data if ( isset ( $_POST [ "id" ])) { $id = $_POST [ 'id' ]; $pw = $_POST [ 'pw' ]; // include db connect class require_once __DIR__ . '/db_connect.php' ; // connecting to db $db = new DB_CONNECT(); $db -> connect (); ...
Read more

Lab 6: Using split

  Using split https://www.w3schools.com/java/tryjava.asp?filename=demo_compiler import java.util.* ; public class Main { public static void main ( String [] args ) { // ArrayList to store product info in Hashmap for ListView ArrayList < HashMap < String , String >> productsList = new ArrayList < HashMap < String , String >>(); String result = "1;Long-grain rice, not parboiled, WKB;88.00:7;Pineapple King;19.00:11;Oat Bran;1.00:12;Apple;20.00:14;Soya Bean;2.00:" ; System . out . println ( result + "\n\n" ); String [] products = result . split ( " : " ); for ( int i = 0 ; i < products . length ; i ++) { //System.out.println(products[i]); String [] details = products [ i ]. split ( " ; " ); String id = details [ 0 ]; String name = details [ 1 ]; String price = details [ 2 ]; ...
Read more