问题[mysql]

使用 PDO 处理数据库。

原来只能用这个循环了foreach？

因为我在输出处得到一个数组$pdo->fetchAll()......

以前用过while，疑问，while还是foreach迭代记录更快？

我的代码有什么问题，是否可以迭代结果while？

class bb
{

    public $db_id;
    public $query_id;

    function connect()
    {

        $this->db_id = new PDO('mysql:host=localhost;dbname=table', 'user', 'pass', [
            PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'", 
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION]);

        !$this->db_id && $this->display_error('No connect');

    }

    function query($sql, $value = [])
    {
        !$this->db_id && $this->connect();

        !($this->query_id = $this->db_id->prepare($sql)) 
              && $this->display_error(false, $sql);

        $this->query_id->execute($value);

        return $this->query_id;

    }

    function fetchAll()
    {
        return $this->query_id->fetchAll();
    }

    function display_error($error, $sql= '')
    {
        die('-----------');
    }

}

$pdo = new bb;


$pdo->query("SELECT * FROM `error` WHERE `code` in (?,?) ORDER BY `type` ASC", [404,410]);
        
//while ($r = $pdo->fetchAll())
//  print('sdf');
foreach ($pdo->fetchAll() as $r) 
    echo $r['url'].PHP_EOL;

可以这样做：

function fetchAll()
{
  return $this->fetchAll();
}

也就是说，访问对象内部、对象或其他东西。我不明白...

我需要将数据存储在数据库中，例如：

    {
        'Heading': [
                        [a1, a2, ..., an], 
                        [a1, a2, ..., an], 
                        ..., 
                        [a1, a2, ..., an]
        ],
        'Disclosure': [
                        [a1, a2, ..., an], 
                        [a1, a2, ..., an], 
                        ..., 
                        [a1, a2, ..., an]
        ],
        'Measure_unit': [
                        [a1, a2, ..., an], 
                        [a1, a2, ..., an], 
                        ..., 
                        [a1, a2, ..., an]
        ],
        'Quantity': [
                        [a1, a2, ..., an], 
                        [a1, a2, ..., an], 
                        ..., 
                        [a1, a2, ..., an]
        ],
        'Code': [
                        [a1, a2, ..., an], 
                        [a1, a2, ..., an], 
                        ..., 
                        [a1, a2, ..., an]
        ]
    }

搜索需要这些数据；除了这些数据之外，还有存储在常规列表中的数据（例如组织的名称）。数据库结构必须如下所示：名称、描述、地址以及来自 、 等的每个Heading列表Disclosure。

数据示例链接： https: //etender.gov.az/main/competition/detail/316641

如何从数据库中获取其中stat "5": "1.5" 和 stat "1": 大于查询得到的数的所有数据。例如，我从查询中获取数字 100，并且需要获取统计数据“1”：大于 100。

|id |prom       |stat                                               |user|date      |
|-----------------------------------------------------------------------------------|
|1  |77-4390    |{"1":"824","2":"30","3":"9026","4":"40","5":"1.5"} |11  |10.08.2024|
|-----------------------------------------------------------------------------------|
|2  |77-4391    |{"1":"904","2":"51","3":"9222","4":"40","5":"1.5"} |23  |10.08.2024|
|-----------------------------------------------------------------------------------|
|3  |77-4355    |{"1":"334","2":"30","3":"9026","4":"40","5":"2.5"} |45  |10.08.2024|
|-----------------------------------------------------------------------------------|
|4  |77-4391    |{"1":"824","2":"60","3":"9023","4":"40","5":"1.5"} |11  |10.08.2024|
|-----------------------------------------------------------------------------------|
|5  |77-4391    |{"1":"624","2":"50","3":"9046","4":"40","5":"3.5"} |19  |10.08.2024|
|-----------------------------------------------------------------------------------|
|6  |77-4391    |{"1":"24","2":"50","3":"9122","4":"40","5":"1.5"}  |15  |10.08.2024|
+-----------------------------------------------------------------------------------+ 

для вывода "5": "1.5" использую:
SELECT * from cst WHERE prom='77-4391' AND  stat LIKE '%5":"1.5%'

+-----------------------------------------------------------------------------------+
|id |prom       |stat                                               |user|date      |
|-----------------------------------------------------------------------------------|
|2  |77-4391    |{"1":"904","2":"51","3":"9222","4":"40","5":"1.5"} |23  |10.08.2024|
|-----------------------------------------------------------------------------------|
|4  |77-4391    |{"1":"824","2":"60","3":"9023","4":"40","5":"1.5"} |11  |10.08.2024|
|-----------------------------------------------------------------------------------|
|6  |77-4391    |{"1":"24","2":"50","3":"9122","4":"40","5":"1.5"}  |15  |10.08.2024|
+-----------------------------------------------------------------------------------+ 

Каким запросом получить данные где stat "1":> 100
+-----------------------------------------------------------------------------------+
|id |prom       |stat                                               |user|date      |
|-----------------------------------------------------------------------------------|
|2  |77-4391    |{"1":"904","2":"51","3":"9222","4":"40","5":"1.5"} |23  |10.08.2024|
|-----------------------------------------------------------------------------------|
|4  |77-4391    |{"1":"824","2":"60","3":"9023","4":"40","5":"1.5"} |11  |10.08.2024|
|-----------------------------------------------------------------------------------|

大家好，我正在为我的应用程序编写代码并遇到一个错误。
bug如下：
执行该请求时，显示空响应

SELECT * FROM jobs WHERE lat = 47.02489170 AND lng = 28.83106860;
# или
SELECT * FROM jobs WHERE lng = 28.83106860;

但是当执行请求而不指定 lng 时：

SELECT * FROM jobs WHERE lat = 47.02489170;

这会产生以下响应：

+------+-----------------------+-------------+-------------+-------------+
| id   | title                 | description | lat         | lng         |
+------+-----------------------+-------------+-------------+-------------+
| 1510 | Administrator magazin |        NULL | 47.02489170 | 28.83106860 |
+------+-----------------------+-------------+-------------+-------------+

这是 mysql 中的某种错误还是 double 不那么准确？
如果有任何答案或文章链接，我将不胜感激。

职位空缺表

 CREATE TABLE `jobs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  ...
  `lat` double(10,8) DEFAULT NULL,
  `lng` double(10,8) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3230 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC

我在 phpMyAdmin 中有一个表，当我想从中删除一列时，我使用：

ALTER TABLE pepole DROP bio;

但是当我查看互联网上的示例时，我发现人们使用以下内容：

ALTER TABLE pepole DROP COLUMN bio; 

我知道 COLUMN 是一列，但是如果一切都适合我，是否有必要使用它？