Source: (Install MySQL Table)

install/MySQL_Table.php

Source: (Install MySQL Data)

install/MySQL_Data.php

Help To Decide Table Name

Source: (Install MySQL Data)

						
Id
INT(20)

						
Firstname
VARCHAR(20)

						
Lastname
VARCHAR(20)

						
Phone Number
VARCHAR(20)
Save Phone # without 00 or +
						
E-Mail
VARCHAR(50)

						
Amount
DECIMAL(20,8)

						
Currecny
VARCHAR(3)
EUR / PKR / NOK
						
VAT%
VARCHAR (3)
example ('-','9','21')
					

[TableName]Colum

Query

$tables["shpl_Wallets"] = [
    "Id"                    => ["INT", "20", "NOT NULL AUTO_INCREMENT PRIMARY KEY"],
    "Status"                => ["ENUM", "'Active', 'Suspended', 'Closed'", "NOT NULL"],
    "Type"                  => ["ENUM", "'Personal', 'Business', 'System', 'Credit'", "NOT NULL"],
    "AccountNumber"         => ["VARCHAR", "255", "NOT NULL UNIQUE"],
    "Balance"               => ["DECIMAL", "20,8", "NOT NULL"],
    "Currency"              => ["VARCHAR", "3", "NOT NULL"],
    "AccountName"           => ["VARCHAR", "50", "NOT NULL"],
    "AccountHashKey"        => ["VARCHAR", "255", "NOT NULL"],
    "AccountConnected"      => ["VARCHAR", "255", "NOT NULL"],
    "InsertTimestemp"       => ["TIMESTAMP", "", "DEFAULT CURRENT_TIMESTAMP"],
    "UpdateTimestemp"       => ["TIMESTAMP", "", "DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"]
];

Query

$CreateSQL_Table="turnover";
$result = $con->query("CREATE TABLE `".$CreateSQL_Table."` (`Id` int(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); // Defatult Always Must
$result = $con->query("ALTER TABLE  `".$CreateSQL_Table."` ADD `Date` DATE NOT NULL ;"); // Date Colum
$result = $con->query("ALTER TABLE  `".$CreateSQL_Table."` ADD `Datetime` DATETIME NOT NULL ;"); // DateTime Colum
$result = $con->query("ALTER TABLE  `".$CreateSQL_Table."` ADD `Text255` VARCHAR(255) NOT NULL;"); // VARCHAR
$result = $con->query("ALTER TABLE  `".$CreateSQL_Table."` ADD `INT` INT(20) NOT NULL;"); // INT
$result = $con->query("ALTER TABLE  `".$CreateSQL_Table."` ADD `ENUM` ENUM('Enable','Disable') NOT NULL;"); // Status
$result = $con->query("ALTER TABLE  `".$CreateSQL_Table."` ADD `Amount` DECIMAL(20,8) NOT NULL;"); // Status 

Query for PHP-8

$CreateSQL_Table="TABLENAME"; $tableColum=null;
$result = $con->query("CREATE TABLE IF NOT EXISTS `$CreateSQL_Table` (`Id` int(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$result = mysqli_query($con,"SHOW COLUMNS FROM `$CreateSQL_Table`");
while($row = mysqli_fetch_array($result)){
    $ClickColum = isset($ClickColum) ? $ClickColum : $row['Field'];
    $tableColum[]=$row['Field'];
}
if(!in_array("Status", $tableColum)){ $result = $con->query("ALTER TABLE `$CreateSQL_Table` ADD `Status` ENUM('Enable', 'Disable') NOT NULL;"); }
if(!in_array("Title", $tableColum)){ $result = $con->query("ALTER TABLE `$CreateSQL_Table` ADD `Title` VARCHAR(255) NOT NULL;"); }
if(!in_array("Link", $tableColum)){ $result = $con->query("ALTER TABLE `$CreateSQL_Table` ADD `Link` VARCHAR(255) NOT NULL;"); }
if(!in_array("Target", $tableColum)){ $result = $con->query("ALTER TABLE `$CreateSQL_Table` ADD `Target` VARCHAR(255) NOT NULL;"); }
if(!in_array("InId", $tableColum)){ $result = $con->query("ALTER TABLE `$CreateSQL_Table` ADD `InId` VARCHAR(255) NOT NULL;"); }
if(!in_array("Icon", $tableColum)){ $result = $con->query("ALTER TABLE `$CreateSQL_Table` ADD `Icon` VARCHAR(255) NOT NULL;"); }