PHP mysqli返回变量类型 - variable type return by php mysqli

variable type return by php mysqli

本文关键字：类型变量返回 mysqli PHP | 更新日期: 2023-09-26

我有下面的表在我的mysql数据库，

    CREATE TABLE deadline_tasks(
    user_id REFERENCES user(user_id),
    task_id INT NOT NULL AUTO_INCREMENT,
    deadline DATE NOT NULL,
    min_chunk_length TIME NOT NULL,
    estimated_time TIME NOT NULL,
    location NOT NULL,
    event_name VARCHAR(30) NOT NULL,
    description VARCHAR(30) NOT NULL,
    PRIMARY KEY(task_id)
    FOREIGN KEY (user_id));

，我使用下面的代码查询数据库。

$result_tasks = $mysqli->query("SELECT deadline, min_chunk_length, estimated_duration,  
task_id FROM deadline_tasks WHERE user_id = Get[$Name]")
for($deadline_task_from_db = array(); 
$row = $result_tasks->fetch_assoc();
$deadline_tasks_from_db[] = $row);

什么是变量类型在我的数组$deadline_task_from_db?

试一试:

   $result_tasks = $mysqli->prepare("SELECT deadline, min_chunk_length, estimated_duration,  task_id FROM deadline_tasks WHERE user_id = ? ");
    $result_tasks->bind_param('i', Get[$Name]); // Bind "Get[$Name]" to parameter.
                                     ^^^^^^^^--//i dont know if this true variable. Please check it what you mean by it.
    $result_tasks->execute(); // Execute the prepared query.
    $result_tasks->store_result();
    $result_tasks->bind_result($deadline ,$min_chunk_length ,$estimated_duration,$task_id ); // get variables from result.
    while ($row = $result_tasks->fetch()){
        echo $deadline;
        echo $min_chunk_length;
        .........
      }

要查看php中变量的类型，可以使用var_dumphttp://www.php.net/var_dump

使用mysqli_fetch_field()，您可以获得"type"下的类型http://www.php.net/manual/en/mysqli-result.fetch-field.php