add_styles_page(); $db = new db_safeguard(); $stock_data_res = $db->query("stock", "SELECT * FROM stock WHERE record_id = {$_GET['record_id']}"); // echo "SELECT * FROM stock_control WHERE record_id = {$_GET['record_id']}"; $stock_data = $stock_data_res->fetch_assoc(); $record_id = new input(); $record_id->type("hidden"); $record_id->name("record_id"); $record_id->id("record_id"); $record_id->value($_GET['record_id']); $stock_id_label = new label(); $stock_id_label->for("stock_no"); $stock_id_label->value("STOCK NO : "); $stock_id_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $stock_id = new input(); $stock_id->type("text"); $stock_id->name("stock_no"); $stock_id->id("stock_no"); $stock_id->value_from_db('stock', 'stock_no', "stock_no = '{$stock_data['stock_no']}'"); $stock_id->readonly(); $stock_id->addAttribute("style", "font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $item_name_label = new label(); $item_name_label->for("item_name"); $item_name_label->value("ITEM NAME : "); $item_name_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $item_name = new input(); $item_name->type("text"); $item_name->name("item_name"); $item_name->id("item_name"); $item_name->value_from_db('stock', 'item_name', "stock_no = '{$stock_data['stock_no']}'"); $item_name->addAttribute("style", "font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $quantity_label = new label(); $quantity_label->for("quantity"); $quantity_label->value("QUANTITY"); $quantity = new input(); $quantity->type("number"); $quantity->name("quantity"); $quantity->id("quantity"); $quantity->style("width:30vw;"); // $quantity->value_from_db('stock', 'quantity', "stock_no = '{$stock_data['stock_no']}'"); $serial_number_label = new label(); $serial_number_label->for("serial_number_label"); $serial_number_label->value("SERIAL NUMBER : "); $serial_number_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $serial_number = new input(); $serial_number->type("text"); $serial_number->name("serial_number"); $serial_number->id("serial_number"); $serial_number->addAttribute("style", "font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $serial_number->value_from_db("stock", "serial_number", "stock_no = '{$stock_data['stock_no']}'"); $status_label = new label(); $status_label->for("status"); $status_label->value("STATUS : "); $status_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $submit_btn = new button(); $submit_btn->value("UPDATE"); $submit_btn->onclick("update_stock()"); ?>

EDIT STOCK

add(); ?>
add(); $stock_id->add(); ?>
query("stock_types", "SELECT * FROM stock_types WHERE record_id = '{$stock_data['stock_type_id']}'"); $stock_type = $stock_type_res->fetch_assoc(); ?>
add(); $item_name->add(); ?>
query("suppliers", "SELECT * FROM suppliers WHERE record_id = '{$stock_data['supplier_id']}'"); // echo "SELECT * FROM suppliers WHERE record_id = '{$stock_data['supplier_id']}'"; $supplier_id = $supplier_id_res->fetch_assoc(); ?>
query("stock_trans", "SELECT * FROM stock_trans WHERE stock_no = '{$stock_data['stock_no']}'"); // echo "SELECT * FROM stock_trans WHERE stock_no = '{$stock_data['stock_no']}'"; $stock_quantity = $stock_quantity_res->fetch_assoc(); ?>
add(); ?>
add(); ?>