doucu9677 2015-07-29 19:10
浏览 62
已采纳

如何将单个MySQL结果保存到PHP变量?

I have this database that I've been working on, and I'm at the point where I'm trying to tie everything together and start integrating the information from my database tables into actual web pages. What I'm trying to do is to query the database for specific answers which I want to save to PHP variables so I can perform a simple <?php echo $variable; ?> throughout my webpage. However I can't seem to figure out how to do that.

Here's a sample of what I've been trying.

SQL

$Name = "John Smith";

$Nickname = $db->query('SELECT `Nickname` FROM `Profiles` WHERE `Name` =' . $Name);
$country = $db->query('Select `Country` from `Profiles` Where `Name` =' . $Name);

PHP/HTML

<div>
<table>
<tr>
<th colspan ="2"><?php echo $Name; ?></th>
</tr>
<tr>
<td>Country</td><td><?php echo $country; ?></td>
</tr>
<tr>
<td>Nickname</td><td><?php echo $Nickname; ?></td>
</tr>
</table>
</div>

This isn't EXACTLY what I've been doing, the table(s) I'm trying to plug this information into is/are far more complicated, which is why if at all possible, I'd like to avoid using the normal method of returning MySQL queries:

Code I'd like to avoid if possible

<?php
while ($rows = $country->fetch()){
echo ['Country'];
}
?>

In the event that the above code is still by far the simplest way to return any/all query results, I just have one question: Is it possible to nest different while ($rows = $variable->fetch()) statements within each other? Because my table has information from different database tables somewhat scattered throughout it and there are a couple of places where I would NEED to nest the WHILE statement. Would it work?

Edit:

So I've tried a couple of suggestions. First, I changed my SQL syntax for the $Name so that it will work in the SQL query.

`WHERE `Name` ="' . $Name . '"');`

So now that's working. But I've tried the other 2 suggestions and both are breaking my code (the page won't load).

Also, no one's answered my question about being able to nest While() Statements.

  • 写回答

2条回答 默认 最新

  • douhai5835 2015-08-01 13:28
    关注

    I figured it out! I was able to assign the results from my database query into variables that I could then recall through a simple <?php echo $variable; ?> at any time, as many times as needed. Here is what I did.

    SQL Example

    $result = $db->query('Select `Name`, `Age`, `Color` from `People` ');
    while ($rows = $result->fetch()){
    $Name = $rows['Name'];
    $Age = $rows['Age'];
    $Color = $rows['Color'];
    }
    

    In Webpage

    <p>
    Hello, my name is <?php echo $Name; ?>. 
    I am <?php echo $Age; ?> years old and my favorite color is <?php echo $Color; ?>.
    </p>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 爬取网页信息并保存需要完整代码
  • ¥15 一分十不等功分器阻设计问题,请问这个56Ω怎么得到的
  • ¥15 (标签-matlab)
  • ¥100 求看看这个数学建模,有偿
  • ¥15 深度学习目标检测现在框架加注意力的创新可以投几区?
  • ¥15 PdfiumViewer pdf转图片
  • ¥15 利用Java连接API接口总是出问题
  • ¥15 请教一个关于镜头标定,棋盘格格子大小的问题(畸变测试)
  • ¥15 安装GroudingDINO RuntimeError: Error compiling objects for extension
  • ¥15 急!C++指针编写相关的问题