Skip to main content
KB: Import

Import Excel (Auto Fill-Up Data)

By September 8, 2024No Comments

//——————–AUTO FILL IN THE DATA WHEN IMPORT EXCEL FILE———————
$values[“users_id”]=$_SESSION[“user_id”];
$values[“created_at”]=now();
$values[“recordStatus”]=$data[“recordStatus”] = “Approved”;
$values[“dataSource”]=$data[“dataSource”] = “Upload”;
$values[“trace”]=$data[“trace”] = “phprunner”;

Note:

  • Green Color is table fields
  • Blue Color is auto fill in data