$ss = new DB_DataObject(); $DB_Connection = $ss->getDatabaseConnection(); $DB_Connection->setFetchMode(DB_FETCHMODE_ORDERED); or $DB_Connection->setFetchMode(DB_FETCHMODE_ASSOC); DB_FETCHMODE_ORDERED,DB_FETCHMODE_ASSOC,DB_FETCHMODE_OBJECT $sql_user_sub_category = "SELECT * FROM user_sub_category WHERE flag=1;"; $_SESSION["pager_stuff"]= $DB_Connection->getAll("$sql_user_sub_category"); //--insert or update /delete query --// $this->query("INSERT INTO $seqname (vapor) VALUES (0)"); ------------------------------------------------------------------------------------------------------------------// $ss = new DB_DataObject(); $DB_Connection = $ss->getDatabaseConnection(); //---------------insert record --------------------------------------------------------------------// $result = $DB_Connection->query("UPDATE sysmaster SET value='$mr_id1' WHERE category='merchandise_autoincrement' ;"); //$result->free(); //-------insert the order --// $sql = "INSERT INTO order_list_header(refno,scd,name,client_groups,description,clients,banner_path,start_date,end_date,flag) VALUES("; $sql .= "'".$mr_id2; $sql .= "','".$_POST["scd"]; $sql .= "','".$_POST["name"]; $sql .= "','".implode(",", array_keys($_POST["client_group_list"])); $sql .= "','".$_POST["description"]; $sql .= "','".implode(",", array_keys($_POST["client_list"])); $sql .= "','".$_POST["upload_image_hiddenfield"]; $sql .= "','".date("Y-m-d", parse_mmddyyyy($_POST["start_date"])); $sql .= "','".date("Y-m-d", parse_mmddyyyy($_POST["end_date"])) . " 16:00:00"; $sql .= "',1"; $sql .= ");"; //echo $sql; $result = $DB_Connection->query($sql); $result->free(); //----------------update record -----------------------------------------------------------------// $sql = "UPDATE order_list_header SET "; $sql .= "name='".$_POST["name"]; $sql .= "',description='".$_POST["description"]; $sql .= "',client_groups='".implode(",", array_keys($_POST["client_group_list"])); $sql .= "',clients='".implode(",", array_keys($_POST["client_list"])); $sql .= "',banner_path='".$_POST["upload_image_hiddenfield"]; $sql .= "',start_date='".date("Y-m-d", parse_mmddyyyy($_POST["start_date"])); $sql .= "',end_date='".date("Y-m-d", parse_mmddyyyy($_POST["end_date"])) . " 16:00:00"; $sql .= "',flag=1"; $sql .= " WHERE refno='".$_POST["scd"]."';"; //echo $sql; $result = $DB_Connection->query($sql); //----------------select query ----------------------------------------------------------// $result = $DB_Connection->query("SELECT * FROM order_list_header WHERE refno='{$_GET['scd']}' ;"); $result2 = $result->fetchRow(DB_FETCHMODE_ASSOC); if (count($result2) < 1 ){ header ("location:" . ON_ERROR_GO_TO); exit; } else { $fill_values["refno"] = $_GET["scd"]; $fill_values["scd"] = $result2['refno']; $fill_values["name"] = $result2['name']; $fill_values["client_groups"] = explode(",", $result2['client_groups']); $fill_values["description"] = $result2['description']; $fill_values["clients"] = explode(",", $result2['clients']); $fill_values["start_date"] = date("d-m-Y", parse_yyyymmdd($result2['start_date'])); $fill_values["end_date"] = date("d-m-Y", parse_yyyymmdd($result2['end_date'])); $fill_values["banner_path"] = $result2['banner_path']; } //------------------------------------------------------------------------------------------------//