?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 MySQLbr;
//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.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_arrayhttp://www.php.net/mysql_fetch_arraythe
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