[EST]

How can i get the information from the MySQL database and display it through the Text box?

[kickinhard007]

hi there,

you really need to learn SQL in order to build upon the code i've written below, but here is an example of how to pull text from a database and place it into a text box, and a text area.

your database needs to have three fields:

id,title,content

as an example, we will just be printing the title of an article, and the article text.

first of all, we have a basic HTML page with a link, we add a variable called 'linkID' to that link so we can pull a certain record out of the database, here is what the link should look like in your page:-

Code:

<a href="print_text.php?linkID=1">Link 1</a>

so, this link is telling our script to grab the data for record number 1, in the script below you will see that we search the database and grab the record depending on this number.

print_text.php

PHP Code:

<?php



// Define MySQL connection settings - Edit them!



$host = "localhost"; 

$username = "username"; 

$password = "passwords"; 

$database = "database"; 



//Select the relevant data from the table, based on the ID passed

//through the link



mysql_connect($host,$username,$password) or die("Unable to connect to database");



@mysql_select_db("$database") or die("Unable to select database $database");



//Edit this to match your database table!



$sqlquery = "SELECT title,content FROM your_table WHERE id='$linkID'";



//Put the data from the SQL query into a variable called $result



$result = mysql_query($sqlquery) or die("Unable to perform query");



//Take the data from the SQL query and put it into seperate 

//variables



$rows = mysql_fetch_array($result);

$title = $rows['title'];

$content = $rows['content'];        



//Form to print the title and content. The variables used here are 

//the ones that we specified above, based on the data we pulled 

//from the database.    



print "<form>

<br>Edit Selected Record<br>

<br>

<input type=\"text\" size=\"50\" value=\"$title\"><br>

<br>

<textarea cols=\"40\" rows=\"8\">$content</textarea><br>

<br>

</form>";



?>