her er så den næsten færdige kode, resten er nok forskellig alt efter hvor og hvad man bruger det til
så michael så er det nok nu du skal svare så du kan få nogle point for det der gav mig nok til at løse opgaven
<?php
function connect_db()
{
$db_host="xxxxxxx";$db_database="xxxxxx";$db_bruger="xxxxxx";$db_password="xxxxx";
$link = mysqli_connect($db_host,$db_bruger,$db_password,$db_database) or die('kan ikke forbinde til SQL serveren');
return $link;
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>db test</title>
</head>
<body>
<?php
$link=connect_db();
if(isset($_POST['submit']))
{
echo'hent post verdierne';
echo'<form action="test.php" method="post">';
$sql="SELECT COLUMN_NAME,COLUMN_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='".$_GET['t_name']."'";
$result=mysqli_query($link,$sql);
while($row=mysqli_fetch_array($result))
{
echo $row['COLUMN_NAME'].' = ';
echo $_POST[$row['COLUMN_NAME']].'<br>';
}
}
if(isset($_GET['t_name']))
{
echo'<br><br>formularen<br>';
echo'<form action="test.php?t_name='.$_GET['t_name'].'" method="post">';
$sql="SELECT COLUMN_NAME,COLUMN_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='".$_GET['t_name']."'";
$result=mysqli_query($link,$sql);
while($row=mysqli_fetch_array($result))
{
echo $row['COLUMN_NAME'].' -- '.$row['COLUMN_TYPE'].'--->';
$type=explode('(',$row['COLUMN_TYPE']);
$type[1]=substr($type[1], 0, -1);
switch ($type[0])
{
case 'int':
echo'<input name="'.$row['COLUMN_NAME'].'" type="text" ><br>';
break;
case 'varchar':
if($type[1]>=100)
{
echo'<textarea name="'.$row['COLUMN_NAME'].'"></textarea><br>';
}else{
echo'<input name="'.$row['COLUMN_NAME'].'" type="text" ><br>';
}
break;
case 'text':
echo'<textarea name="'.$row['COLUMN_NAME'].'"></textarea><br>';
break;
}
}
echo'<input type="submit" name="submit" value="insert"><br>';
echo'</form>';
}
echo'<br><br><br>Tabeller<br>';
$sql="SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS";
$result=mysqli_query($link,$sql);
while($row=mysqli_fetch_array($result))
{
if($row['TABLE_NAME']==strtolower($row['TABLE_NAME']))
{
echo '<a href="test.php?t_name='.$row['TABLE_NAME'].'">'.$row['TABLE_NAME'].'</a><br>';
}
}
?>
</body>
</html>
