CREATE TABLE ZN_Header_xls
(
id_ZN int,
NumberZN varchar(255),
DateZN date,
Supplier varchar(255),
SupplierAddress varchar(255),
TIN int,
Сustomer varchar(255),
СustomerContacts varchar(255),
CarBrandModel varchar(255),
ProdYear smallint,
Gosnum varchar(255),
VIN varchar(255),
Payer varchar(255),
RepairOrderNumber varchar(255),
CurrDate date,
MasterSTO varchar(255),
SumNoWear float,
AmountInText varchar(255)
);
INSERT INTO ZN_Header_xls (
id_ZN,
NumberZN,
DateZN,
Supplier,
SupplierAddress,
TIN,
Сustomer,
СustomerContacts,
CarBrandModel,
ProdYear,
Gosnum,
VIN,
Payer,
RepairOrderNumber,
CurrDate,
MasterSTO,
SumNoWear,
AmountInText) VALUES
(
1,
'ЗН134',
'2023-11-30',
'Кузовной',
'Пермь',
12459732,
'Иванов',
'8-989-989-8989',
'Opel Astra',
2008,
'А123АА059',
'OSJF2044',
'СК Ингосстрах',
'65468132',
'2023-12-04',
'Максим',
65549.25,
''
);
Show tables;
SELECT id_ZN,
NumberZN,
DateZN,
Supplier,
SupplierAddress,
TIN,
Сustomer,
СustomerContacts,
CarBrandModel,
ProdYear,
Gosnum,
VIN,
Payer,
RepairOrderNumber,
CurrDate,
MasterSTO,
SumNoWear,
AmountInText FROM ZN_Header_xls Where id_ZN = 1;
<?php
function InfoEssence($ess) {
//Передан объект
if(is_object($ess)){
$class = get_class($ess); //класс объекта
$obj = $ess;
$vars_obj = '<pre>' . print_r(get_object_vars($obj), true) . '</pre>';
//Передан класс
} else {
$class = $ess;
$vars_obj = null;
}
$vars_class = '<pre>' . print_r(get_class_vars($class), true) . '</pre>';
$methods = '<pre>' . print_r(get_class_methods($class), true) . '</pre>';
if ($vars_obj) echo 'Свойства объекта- экземпляра класса '.$class.':'.$vars_obj;
echo 'Свойства класса '.$class.':'.$vars_class.
'Методы класса '.$class.':'.$methods;
}
$query = "SELECT id_ZN,
NumberZN,
DateZN,
Supplier,
SupplierAddress,
TIN,
Сustomer,
СustomerContacts,
CarBrandModel,
ProdYear,
Gosnum,
VIN,
Payer,
RepairOrderNumber,
CurrDate,
MasterSTO,
SumNoWear,
AmountInText FROM ZN_Header_xls Where id_ZN = 1";
$result = $mysqli->query($query);
InfoEssence($result);
$headerData = $result->fetch_assoc();
InfoEssence($headerData);