---
title: "Hämta information"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/49141-hämta-information"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "Coper"
published: "2002-07-31T13:02:47.000Z"
updated: "2002-07-31T20:10:32.000Z"
replies: 3
views: 269
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/php/49141-hämta-information"
---

# Hämta information

## #1 — Coper, 2002-07-31T13:02Z

...

Permalänk: https://www.webforum.nu/p/49141

## #2 — nkrantz, 2002-07-31T13:57Z

borde funka nu:

```php
<html>
<body>

<?php
$db_=_mysql_connect("localhost",_"root");
mysql_select_db("mydb",$db);
if_(isset($_GET['id']) ||_isset($_POST['id']))
{
	if_($_POST['submit'])
	{
		$sql_=_"UPDATE_employees_SET first='".$_POST['first']."',last='".$_POST['last']."',address='".$_POST['address']."',position='".$_POST['$position']."'_WHERE_id=".$_POST['id'];
		$result_=_mysql_query($sql);
		echo_"Thank you! Information updated.\n";
	}_
	else_
	{
		// query the DB
		$sql_=_"SELECT_*_FROM_employees_WHERE_id=".$_POST['id'];
		$result_=_mysql_query($sql);		
		$myrow_=_mysql_fetch_array($result);
		?>

		<form method="post" action="<?php_echo_$PHP_SELF?>">
		<input type=hidden name="id" value="<?php_echo_$myrow["id"]_?>">
		First name:<input type="Text" name="first" value="<?php_echo_$myrow["first"]_?>"><br>
		Last name:<input type="Text" name="last" value="<?php_echo_$myrow["last"]_?>"><br>
		Address:<input type="Text" name="address" value="<?php_echo_$myrow["address"]_?>"><br>
		Position:<input type="Text" name="position" value="<?php_echo_$myrow["position"]_?>"><br>
		<input type="Submit" name="submit" value="Enter information">
		</form>
		<?php
	}
}
else
{
	// display list of employees
	$result_=_mysql_query("SELECT * FROM employees",$db);
	while_($myrow_=_mysql_fetch_array($result))
	{
		printf("<a href=\"%s?id=%s\">%s %s</a><br>\n",_$PHP_SELF,_$myrow["id"],_$myrow["first"],_$myrow["last"]);
	}
}

?>
</body>
</html>
```

Permalänk: https://www.webforum.nu/p/737312

## #3 — Coper, 2002-07-31T15:50Z

...

Permalänk: https://www.webforum.nu/p/737381

## #4 — U2K, 2002-07-31T20:10Z

Hmm.. det blev en massa \_ streck överallt... Bort!

Permalänk: https://www.webforum.nu/p/737590

---

Tråden på webben: https://www.webforum.nu/amne/php/49141-hämta-information
