Re: Re: assign database result to iinput text box

<?php $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 aerver"); //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.sokolewicz@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 > >