我的SQL没有返回预期的值[重复]

Question

This question already has an answer here:

• getting resource #id 3 error 2 answers
• MySQL SUM query problems php 3 answers

I am new to phpMySQL and php. and I am trying to get a value from database and put it in a textbox. Currently, I only have 1 value in my table to test the code:

This is my code:

<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "dbtest";
$tbl_name="tbltest";

$con = mysql_connect("$mysql_hostname","$mysql_user","$mysql_password");

if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("$mysql_database", $con);
$all = mysql_query("SELECT Balance FROM tbltest");
?>

And then in my HTML side, I have this:

<input type="text" name="Balance" value="<?php echo $all; ?>" />

But when I tried to run the code the value that appears in the textbox is:

Resource Id #4

What did I miss? Thank you for the help

</div>

Answer 1

mysql_query does not return the result itself, but returns the resource that holds the result.

You can use mysql_fetch_assoc or other relevant to fetch one row from that resource.

The code should be like: $con = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);

if (!$con) {
    die('Could not connect: ' . mysql_error());
}

mysql_select_db($mysql_database, $con);
$res = mysql_query("SELECT Balance FROM tbltest");

$all = mysql_fetch_assoc($res); //actually $all is not all the result, it's first row.
                                // $all might be like array('Balance' => '100');

and HTML part, as arrays could not be echoed directly('Array' is shown instead), you have to specify the index of $all:

<input type="text" name="Balance" value="<?php echo $all['Balance']; ?>" />