$username = "root";
$password = "myPassword";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)  or die("Unable
to connect to MySQL");
echo "Connected to MySQL<br>";

//select a database to work with
$selected = mysql_select_db("iccsimd",$dbhandle)  or die("Could not select

//execute the SQL query and return records
$result = mysql_fetch_assoc(mysql_query("SELECT invid, invdate, note,
amount FROM invheader"));

<INPUT type="text" name="Mytxt" id="MytextID" value="<?php echo
$result['note'];?>" />

Like Maciek mentioned, if this is a new project use PDO or MySQLi instead,
else use a PDO wrapper for MySQL functions.

On Wed, Sep 18, 2013 at 7:45 AM, Maciek Sokolewicz <
maciek.sokolew...@gmail.com> wrote:

> On 18-9-2013 7:33, iccsi wrote:
>> I have following html code to show my input text box and php to connect
>> server and select result from database server.
>> I would like to know how I can I use php to assign the value to my input
>> text.
>> Your help and information is great appreciated,
>> Regards,
> Hi iccsi,
> first, look at 
> http://www.php.net/mysql_**fetch_array<http://www.php.net/mysql_fetch_array>the
>  example should help you.
> Once you have the value you're looking for in a variable, you simply
> assign insert it into the value property of your input element. Ie. you
> should have something like <input type="text" name="a" id="b" value="the
> variable containing your data">
> Also please note that the mysql extension is deprecated; you are advised
> to switch to either PDO_MySQL or mysqli instead.
> - Tul
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to